(RADIATOR) Request for Feature

2003-01-15 Thread Vangelis Kyriakakis
Hello,

Sometimes it is very helpful to disable NAS queries while checking
for Simultaneus-Use on some Handlers. Now we can only prevent NAS
queries on a client basis using NasType. Is a Handler or AuthBy based
flag, that would enable-disable the queries, possible?

   Regards
Vangelis

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



(RADIATOR) Session database with mysql

2003-01-15 Thread tdn
Hello,

Am trying to implement a session database using a mysql database.
My problem is that i notice that there are so many cases when people have
actually logged out, but not
deleted from the database.

(see my database structure and part of my cfg file)

create table radonline (
username   char(50) NOT NULL,
nasidentifier   char(50),
 nasipaddress char(15),
nasport int,
acctsessionid   char(30) NOT NULL,
time_stamp   int,
framedipaddress  char(15),
nasporttype  char(10),
servicetype  char(20),
calledstationid  char(16),
callingstationid char(16),
 usrchassiscallslot   int,
 usrchassiscallchannelint,

UNIQUE RADONLINE_I (nasidentifier, username),
INDEX RADONLINE_I2 (username)
);



cfg file
=


SessionDatabase SQL
Identifier InSQL

DBSourcedbi:mysql:radonline:1.1.1.1
DBUsername 
DBAuth xxx


AddQuery insert into radonline (username, \
nasidentifier, \
nasipaddress, \
nasport, \
acctsessionid, \
time_stamp, \
framedipaddress, \
nasporttype, \
servicetype, \
calledstationid, \
callingstationid, \
usrchassiscallslot, \
usrchassiscallchannel) \
values ('%u', \
'%N', \
'%{NAS-IP-Address}', \
0%{NAS-Port}, \
'%{Acct-Session-Id}',  \
%{Timestamp}, \
'%{Framed-IP-Address}', \
'%{NAS-Port-Type}', \
'%{Service-Type}', \
'%{Called-Station-Id}', \
'%{Calling-Station-Id}', \
0%{USR-Chassis-Call-Slot}, \
0%{USR-Chassis-Call-Channel} )

   DeleteQuery delete from radonline where acctsessionid='%4' and
nasipaddress='%2' and username='%u'

   ClearNasQuerydelete from radonline where nasidentifier='%N'

   CountQueryselect
nasidentifier,nasport,acctsessionid,framedipaddress from radonline where
username='%u'
/SessionDatabase

TDN

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



(RADIATOR) 100% processor load outside the time service window

2003-01-15 Thread MStefan
I was trying to implement the Time and Simultaneous-use check/reply items
but the radiator is getting nervous

Inside the service window  We08:00-16:00 everything goes perfect but outside
the server gets stuck(100% load and blocked)

I am running a test on my computer with NT and Access ODBC

Any clue/help appreciated ?


Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT410

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all
owable Time range
Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT411

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all
owable Time range
Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT412

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
3
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
4
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
5
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
6
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
7
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
8
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
9
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT248
0
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT248
1

Kind Regards

Marius Stefan
Service Designer/Development Department
Enertel N.V
K.P van der Mandelelaan 130-144
3062 MB Rotterdam
Postbus 25226
3001 HE Rotterdam
Phone:+31(0)10 880 3798
Fax:+31(0)10 880 3901
Mobile:+31(0)65 460 4973
www.enertel.nl




#***
# 
# Dit e-mailbericht met eventuele attachments is uitsluitend bestemd voor de
# geadresseerde(n) en bevat mogelijk vertrouwelijke gegevens en/of is
# beschermd door intellectuele eigendomsrechten. Bent u niet de
# geadresseerde, neemt u dan zo spoedig mogelijk contact op met de afzender
# en verzoeken wij u het e-mailbericht en eventuele attachments van uw
# computer te verwijderen. Elk gebruik van de inhoud van dit e-mailbericht
# en eventuele attachments (waaronder verveelvoudiging, verspreiding of het
# anderzins openbaar maken in welke vorm dan ook) door andere personen dan
# de bedoelde geadresseerden is verboden. De weergegeven mening is puur
# persoonlijk en hoeft niet noodzakelijk over een te komen met die van
# Enertel. Enertel is niet aansprakelijk voor de inhoud van dit
# e-mailbericht en eventuele attachments.


===
Archive at 

(RADIATOR) logging IPASS accounting records to Database

2003-01-15 Thread Ayotunde Itayemi



Hi Hugh, Hi All,

I would like to log only IPASS accounting start and 
stop request to a database
tableso as to get some sort of record locally 
- how can I implement this?
I want something a little bit "simpler" than the 
long detail file generated by 
the AcctLogFileName clause (see below pls). One can 
more easily peruse
entries in an Oracle table.

Regards,
Tunde Itayemi.


Relevant parts of my config :

Client localhost # 
ipass client for VNAS (incoming metrong 
roamers) 
Secret Identifier 
ipassclient IdenticalClients 
63.10.10.212 RewriteUsername 
s/^IPASS\/([^@]+)\@([^@]+)$/IPASS\/$1#$2\@myipass//Client

AuthBy 
RADIUS 
Identifier 
ipassNetserver 
Host 
63.10.10.211 
Secret 
AuthPort 
11812 
AcctPort 
11813 AddToRequest 
Called-Station-Id=%{Called-Station-Id}, 
NAS-IP-Address=%N 
DefaultSimultaneousUse 1/AuthBy

Handler 
Realm=myipass 
AcctLogFileName 
%L/ipass/detail 
RewriteUsername 
s/^IPASS\/([^#]+)\#([^@]+)\@myipass$/IPASS\/$1\@$2/ 
AuthBy ipassNetserver/Handler

Handler 
Client-Identifier=ipassclient 
AuthByPolicy ContinueWhileAccept 
RewriteUsername s/^([^@]+).*/$1/ 
RewriteUsername tr/A-Z/a-z/ 
UsernameCharset a-zA-Z0-9\._@- 
AcctLogFileName 
%L/account.log 
PasswordLogFileName 
%L/password.log SessionDatabase 
SDB1 AuthBy 
SQLClientauth StripFromReply 
Framed-IP-Address/Handler



(RADIATOR) More than one DNS server via Address Allocator SQL

2003-01-15 Thread Cortney Thompson
Is there a way to assign two DNS servers using Address Allocator 
SQL?  Something like
DNSSERVER-PRI = X.X.X.X.
DNSSERVER-SEC= Y.Y.Y.Y.

Instead of DNSSERVER = Z.Z.Z.Z

Thanks
Cortney


Cortney Thompson
[EMAIL PROTECTED]

 Opinions are mine and do not necessarily reflect
   those of wyoming.com LLC

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.


(RADIATOR) CallerID logging in AuthLog SQL

2003-01-15 Thread gordons
Hi all,

I have a problem - I want to include Calling-Station-ID in my AuthLog
table.
Unfortunately, I can't find the correct attribute to include in the SQL
statement to do so.

I have the standard:

 FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, REASON)
values (%t, '%n', 0, %1)

Does anyone know the value to insert for callerid? It's not in the
attributes table in the manual...

Cheers,

Gordon Smith  CCNA
Network Operations Manager

MoreNet Ltd

PGP Fingerprint: 8303 3372 E226 08C2 8A42 4188 D9E1 D2F5 832E 67C5




===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) CallerID logging in AuthLog SQL

2003-01-15 Thread Hugh Irvine

Hello Gordon -

You will need to modify your RADAUTHLOG table first to include the 
column, then do something like this:

 FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, REASON, 
CALLINGSTATIONID)
values (%t, '%n', 0, %1, %{Calling-Station-Id})

You will find the list of attributes in the dictionary file included in 
the distribution (the file called dictionary).

Here are the definitions for both Calling-Station-Id and 
Called-Station-Id from the dictionary:

ATTRIBUTE   Called-Station-Id   30  string
ATTRIBUTE   Calling-Station-Id  31  string

regards

Hugh


On Thursday, Jan 16, 2003, at 09:54 Australia/Melbourne, 
[EMAIL PROTECTED] wrote:

Hi all,

I have a problem - I want to include Calling-Station-ID in my AuthLog
table.
Unfortunately, I can't find the correct attribute to include in the SQL
statement to do so.

I have the standard:

 FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, REASON)
values (%t, '%n', 0, %1)

Does anyone know the value to insert for callerid? It's not in the
attributes table in the manual...

Cheers,

Gordon Smith  CCNA
Network Operations Manager

MoreNet Ltd

PGP Fingerprint: 8303 3372 E226 08C2 8A42 4188 D9E1 D2F5 832E 67C5




===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.




--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



(RADIATOR) Dual Accounting Streams Possible?

2003-01-15 Thread Cliff Daniel
I'm looking for a way to configure radiator to send a duplicate stream 
to another radius host, just for logging purposes only.   Is there any 
easy way to accomplish this?  I've search the archives for this list and 
only saw one thing similar but that was for Auth and I didn't quite 
understand it :-)

Regards,
Cliff

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.


Re: (RADIATOR) More than one DNS server via Address Allocator SQL

2003-01-15 Thread Hugh Irvine

Hello Cortney -

This is currently not supported directly, but you could write a hook to 
do it fairly easily.

Note that the radius protocol does not have a standard way to do this 
in any case.

There are some example hooks in the file goodies/hooks.txt in the 
distribution.

regards

Hugh


On Thursday, Jan 16, 2003, at 07:44 Australia/Melbourne, Cortney 
Thompson wrote:

Is there a way to assign two DNS servers using Address Allocator 
SQL?  Something like
DNSSERVER-PRI = X.X.X.X.
DNSSERVER-SEC= Y.Y.Y.Y.

Instead of DNSSERVER = Z.Z.Z.Z

Thanks
Cortney


Cortney Thompson
[EMAIL PROTECTED]

 Opinions are mine and do not necessarily reflect
   those of wyoming.com LLC

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) 100% processor load outside the time service window

2003-01-15 Thread queksteven

Hi,

U should included the NODEFAULTs clauses.

Radiator will attempt to incremental the user ID when the query failed till
u Reboot the PC.



[EMAIL PROTECTED]  15/01/2003 11:48 PM
Sent by: [EMAIL PROTECTED]

   

  To:  [EMAIL PROTECTED]

  cc:  (bcc: QUEK Steven/Mgr - IDD Network/STSunPage/ST Group) 

  Subject: (RADIATOR) 100% processor load outside the time service window  

   

   

   







I was trying to implement the Time and Simultaneous-use check/reply items
but the radiator is getting nervous

Inside the service window  We08:00-16:00 everything goes perfect but
outside
the server gets stuck(100% load and blocked)

I am running a test on my computer with NT and Access ODBC

Any clue/help appreciated ?


Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT410

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all
owable Time range
Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT411

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all
owable Time range
Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT412

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
3
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
4
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
5
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
6
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
7
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
8
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
9
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT248
0
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not within
an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT248
1

Kind Regards

Marius Stefan

Re: (RADIATOR) logging IPASS accounting records to Database

2003-01-15 Thread Hugh Irvine

Hello Tunde -

You just need to add an AuthBy SQL clause to your configuration file, 
something like this:

Client localhost
    # ipass client for VNAS (incoming metrong roamers)
    Secret
    Identifier ipassclient
    IdenticalClients 63.10.10.212
    RewriteUsername 
s/^IPASS\/([^@]+)\@([^@]+)$/IPASS\/$1#$2\@myipass/
/Client
 
AuthBy RADIUS
    Identifier  ipassNetserver
    Host    63.10.10.211
    Secret  
    AuthPort    11812
    AcctPort    11813
    AddToRequest Called-Station-Id=%{Called-Station-Id}, 
NAS-IP-Address=%N
    DefaultSimultaneousUse 1
/AuthBy
 
AuthBy SQL
	Identifier SQLAccounting
	DBSource .
	DBUsername .
	DBAuth .
	# empty AuthSelect to disable authentication
	AuthSelect
	# configure AccountingTable and AcctColumnDef's
	AccountingTable IPASSACCOUNTING
	AcctColumnDef .
	.
/AuthBy

Handler Realm=myipass
    AcctLogFileName  %L/ipass/detail
    RewriteUsername  
s/^IPASS\/([^#]+)\#([^@]+)\@myipass$/IPASS\/$1\@$2/

AuthByPolicy ContinueAlways

AuthBy SQLAccounting

    AuthBy ipassNetserver

/Handler
 
Handler Client-Identifier=ipassclient
    AuthByPolicy ContinueWhileAccept
    RewriteUsername s/^([^@]+).*/$1/
    RewriteUsername tr/A-Z/a-z/
    UsernameCharset a-zA-Z0-9\._@-
    AcctLogFileName %L/account.log
    PasswordLogFileName %L/password.log
    SessionDatabase SDB1
    AuthBy SQLClientauth
    StripFromReply Framed-IP-Address
/Handler
 

regards

Hugh


On Thursday, Jan 16, 2003, at 06:52 Australia/Melbourne, Ayotunde 
Itayemi wrote:

Hi Hugh, Hi All,
 
I would like to log only IPASS accounting start and stop request to a 
database
table so as to get some sort of record locally - how can I implement 
this?
I want something a little bit simpler than the long detail file 
generated by
the AcctLogFileName clause (see below pls). One can more easily peruse
entries in an Oracle table.
 
Regards,
Tunde Itayemi.
 
 
Relevant parts of my config :
 
Client localhost
    # ipass client for VNAS (incoming metrong roamers)
    Secret
    Identifier ipassclient
    IdenticalClients 63.10.10.212
    RewriteUsername 
s/^IPASS\/([^@]+)\@([^@]+)$/IPASS\/$1#$2\@myipass/
/Client
 
AuthBy RADIUS
    Identifier  ipassNetserver
    Host    63.10.10.211
    Secret  
    AuthPort    11812
    AcctPort    11813
    AddToRequest Called-Station-Id=%{Called-Station-Id}, 
NAS-IP-Address=%N
    DefaultSimultaneousUse 1
/AuthBy
 
Handler Realm=myipass
    AcctLogFileName  %L/ipass/detail
    RewriteUsername  
s/^IPASS\/([^#]+)\#([^@]+)\@myipass$/IPASS\/$1\@$2/
    AuthBy ipassNetserver
/Handler
 
Handler Client-Identifier=ipassclient
    AuthByPolicy ContinueWhileAccept
    RewriteUsername s/^([^@]+).*/$1/
    RewriteUsername tr/A-Z/a-z/
    UsernameCharset a-zA-Z0-9\._@-
    AcctLogFileName %L/account.log
    PasswordLogFileName %L/password.log
    SessionDatabase SDB1
    AuthBy SQLClientauth
    StripFromReply Framed-IP-Address
/Handler
 


--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Dual Accounting Streams Possible?

2003-01-15 Thread Hugh Irvine

Hello Cliff -

Yes this is quite simple to do (I assume you want a copy of the 
accounting only?).

Something like this:

# define AuthBy clauses

AuthBy RADIUS
	ForwardAccountingOnly
	Host ...
	Secret 
	IgnoreAuthentication
	.
/AuthBy

AuthBy RADIUS
	ForwardToProxy
	Host ...
	Secret 
	.
/AuthBy

# define Handlers or Realms

Realm 
	AuthByPolicy ContinueAlways
	AuthBy ForwardAccountingOnly
	AuthBy ForwardToProxy
	.
/Realm


regards

Hugh


On Thursday, Jan 16, 2003, at 11:59 Australia/Melbourne, Cliff Daniel 
wrote:

I'm looking for a way to configure radiator to send a duplicate stream 
to another radius host, just for logging purposes only.   Is there any 
easy way to accomplish this?  I've search the archives for this list 
and only saw one thing similar but that was for Auth and I didn't 
quite understand it :-)

Regards,
Cliff

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) 100% processor load outside the time service window

2003-01-15 Thread Hugh Irvine

Hello Marius -

You should add a NoDefault parameter to your AuthBy SQL clause:

	AuthBy SQL
		.
		NoDefault
		.
	/AuthBy

regards

Hugh


On Thursday, Jan 16, 2003, at 02:48 Australia/Melbourne,  
[EMAIL PROTECTED] wrote:

I was trying to implement the Time and Simultaneous-use check/reply  
items
but the radiator is getting nervous

Inside the service window  We08:00-16:00 everything goes perfect but  
outside
the server gets stuck(100% load and blocked)

I am running a test on my computer with NT and Access ODBC

Any clue/help appreciated ?


Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT410

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all
owable Time range
Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT411

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all
owable Time range
Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT412

Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
3
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
4
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
5
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
6
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
7
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
8
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT247
9
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT248
0
Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
within an
all
owable Time range
Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
CLID,ctime,dtimeout,portlimit
from whitelist where DNIS=12345 and CLID=1234

Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
DEFAULT248
1

Kind Regards

Marius Stefan
Service Designer/Development Department
Enertel N.V
K.P van der Mandelelaan 130-144
3062 MB Rotterdam
Postbus 25226
3001 HE Rotterdam
Phone:+31(0)10 880 3798
Fax:+31(0)10 880 3901
Mobile:+31(0)65 460 4973
www.enertel.nl




#** 
*
#
# Dit e-mailbericht met eventuele attachments is uitsluitend bestemd  
voor de
# geadresseerde(n) en bevat mogelijk vertrouwelijke gegevens en/of is
# beschermd door intellectuele eigendomsrechten. Bent u niet de
# geadresseerde, neemt u dan zo spoedig mogelijk contact op met de  
afzender
# en verzoeken wij u het e-mailbericht en eventuele attachments van uw
# computer te verwijderen. Elk gebruik van de inhoud van dit  
e-mailbericht
# en eventuele attachments (waaronder verveelvoudiging, verspreiding  
of het
# anderzins openbaar maken in welke vorm dan ook) door andere personen  
dan
# de bedoelde 

Re: (RADIATOR) Session database with mysql

2003-01-15 Thread Hugh Irvine

Hello -

The usual reason for stale records being left in the session database 
is missing stop records. In other words, if you do not receive a stop 
record when a user session completes, then you will not delete that 
users record from the session database.

It is also possible that the delete query that you show below is not 
correct. Have you checked a trace 4 to make sure that this is doing the 
right thing and deleting the correct record?

I will need to see the complete configuration file (no secrets) 
together with a trace 4 debug from Radiator showing what is happening.

regards

Hugh


On Wednesday, Jan 15, 2003, at 21:22 Australia/Melbourne, 
[EMAIL PROTECTED] wrote:

Hello,

Am trying to implement a session database using a mysql database.
My problem is that i notice that there are so many cases when people 
have
actually logged out, but not
deleted from the database.

(see my database structure and part of my cfg file)

create table radonline (
username   char(50) NOT NULL,
nasidentifier   char(50),
 nasipaddress char(15),
nasport int,
acctsessionid   char(30) NOT NULL,
time_stamp   int,
framedipaddress  char(15),
nasporttype  char(10),
servicetype  char(20),
calledstationid  char(16),
callingstationid char(16),
 usrchassiscallslot   int,
 usrchassiscallchannelint,

UNIQUE RADONLINE_I (nasidentifier, username),
INDEX RADONLINE_I2 (username)
);



cfg file
=


SessionDatabase SQL
Identifier InSQL

DBSourcedbi:mysql:radonline:1.1.1.1
DBUsername 
DBAuth xxx


AddQuery insert into radonline (username, \
nasidentifier, \
nasipaddress, \
nasport, \
acctsessionid, \
time_stamp, \
framedipaddress, \
nasporttype, \
servicetype, \
calledstationid, \
callingstationid, \
usrchassiscallslot, \
usrchassiscallchannel) \
values ('%u', \
'%N', \
'%{NAS-IP-Address}', \
0%{NAS-Port}, \
'%{Acct-Session-Id}',  \
%{Timestamp}, \
'%{Framed-IP-Address}', \
'%{NAS-Port-Type}', \
'%{Service-Type}', \
'%{Called-Station-Id}', \
'%{Calling-Station-Id}', \
0%{USR-Chassis-Call-Slot}, \
0%{USR-Chassis-Call-Channel} )

   DeleteQuery delete from radonline where acctsessionid='%4' and
nasipaddress='%2' and username='%u'

   ClearNasQuerydelete from radonline where nasidentifier='%N'

   CountQueryselect
nasidentifier,nasport,acctsessionid,framedipaddress from radonline 
where
username='%u'
/SessionDatabase

TDN

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Request for Feature

2003-01-15 Thread Hugh Irvine

Hello Vangelis -

I can't think of an easy way to do this, but I have copied Mike on this 
mail for his comments.

regards

Hugh


On Wednesday, Jan 15, 2003, at 21:01 Australia/Melbourne, Vangelis 
Kyriakakis wrote:

Hello,

Sometimes it is very helpful to disable NAS queries while checking
for Simultaneus-Use on some Handlers. Now we can only prevent NAS
queries on a client basis using NasType. Is a Handler or AuthBy based
flag, that would enable-disable the queries, possible?

   Regards
Vangelis

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.




--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



(RADIATOR) Time check item

2003-01-15 Thread Anton Krall
Guys.. I trying to make 2 AuthBy SQL.. one is a standard one and the
other is for a dialup plan called Nightly

The 2nd one has to have a check item: Time = Wk-0800

Thing is... where do I put the check item? I forgot :

Thx for the help.

__
Anton Krall


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Time check item

2003-01-15 Thread Hugh Irvine

Hello Anton -

A check item usually goes in a user record.

Ie:

someuser  Password = xxx, Time = Wk-0800
	..

There are other possibilities depending on what else you are doing in 
your configuration file.

regards

Hugh


On Thursday, Jan 16, 2003, at 16:19 Australia/Melbourne, Anton Krall 
wrote:

Guys.. I trying to make 2 AuthBy SQL.. one is a standard one and the
other is for a dialup plan called Nightly

The 2nd one has to have a check item: Time = Wk-0800

Thing is... where do I put the check item? I forgot :

Thx for the help.

__
Anton Krall


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.




--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



RE: (RADIATOR) 100% processor load outside the time service window

2003-01-15 Thread MStefan

Thanks guys.It has solved the problem for Time+Session-Timeout but also for
Simultaneous-Use(port Limit)

Perfect


-Original Message-
From: Hugh Irvine [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 2:48 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: (RADIATOR) 100% processor load outside the time service
window



Hello Marius -

You should add a NoDefault parameter to your AuthBy SQL clause:

AuthBy SQL
.
NoDefault
.
/AuthBy

regards

Hugh


On Thursday, Jan 16, 2003, at 02:48 Australia/Melbourne,  
[EMAIL PROTECTED] wrote:

 I was trying to implement the Time and Simultaneous-use check/reply  
 items
 but the radiator is getting nervous

 Inside the service window  We08:00-16:00 everything goes perfect but  
 outside
 the server gets stuck(100% load and blocked)

 I am running a test on my computer with NT and Access ODBC

 Any clue/help appreciated ?


 Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT410

 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all
 owable Time range
 Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT411

 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all
 owable Time range
 Wed Jan 15 16:42:20 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT412

 Wed Jan 15 16:42:20 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all

 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT247
 3
 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all
 owable Time range
 Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT247
 4
 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all
 owable Time range
 Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT247
 5
 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all
 owable Time range
 Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT247
 6
 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all
 owable Time range
 Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT247
 7
 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all
 owable Time range
 Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT247
 8
 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all
 owable Time range
 Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT247
 9
 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all
 owable Time range
 Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT248
 0
 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL REJECT: Time: not  
 within an
 all
 owable Time range
 Wed Jan 15 16:38:50 2003: DEBUG: Query is: select
 CLID,ctime,dtimeout,portlimit
 from whitelist where DNIS=12345 and CLID=1234

 Wed Jan 15 16:38:50 2003: DEBUG: Radius::AuthSQL looks for match with
 DEFAULT248
 1

 Kind Regards

 Marius Stefan
 Service Designer/Development Department
 Enertel N.V
 K.P van der Mandelelaan 130-144
 3062 MB Rotterdam
 Postbus 25226
 3001 HE Rotterdam
 Phone:+31(0)10 880 3798
 Fax:+31(0)10 880 3901
 Mobile:+31(0)65 460 4973
 www.enertel.nl




 #** 
 *
 #
 # Dit e-mailbericht met eventuele attachments is uitsluitend bestemd  
 

RE: (RADIATOR) Time check item

2003-01-15 Thread Anton Krall
If I needed to hard code the check into the authby so that the user
record (SQL) would only have username and pw?

__
Anton Krall
CEO 


%-Original Message-
%From: [EMAIL PROTECTED] 
%[mailto:[EMAIL PROTECTED]] On Behalf Of Hugh Irvine
%Sent: Jueves, 16 de Enero de 2003 12:09 a.m.
%To: Anton Krall
%Cc: [EMAIL PROTECTED]
%Subject: Re: (RADIATOR) Time check item
%
%
%
%Hello Anton -
%
%A check item usually goes in a user record.
%
%Ie:
%
%someuser  Password = xxx, Time = Wk-0800
%   ..
%
%There are other possibilities depending on what else you are doing in 
%your configuration file.
%
%regards
%
%Hugh
%
%
%On Thursday, Jan 16, 2003, at 16:19 Australia/Melbourne, Anton Krall 
%wrote:
%
% Guys.. I trying to make 2 AuthBy SQL.. one is a standard one and the 
% other is for a dialup plan called Nightly
%
% The 2nd one has to have a check item: Time = Wk-0800
%
% Thing is... where do I put the check item? I forgot :
%
% Thx for the help.
%
% __
% Anton Krall
%
%
% ===
% Archive at http://www.open.com.au/archives/radiator/
% Announcements on [EMAIL PROTECTED]
% To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe 
% radiator' in the body of the message.
%
%
%
%-- 
%Radiator: the most portable, flexible and configurable RADIUS 
%server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, 
%NT, MacOS X.
%-
%Nets: internetwork inventory and management - graphical, 
%extensible, flexible with hardware, software, platform and 
%database independence.
%
%===
%Archive at http://www.open.com.au/archives/radiator/
%Announcements on [EMAIL PROTECTED]
%To unsubscribe, email '[EMAIL PROTECTED]' with
%'unsubscribe radiator' in the body of the message.
%
%


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Time check item

2003-01-15 Thread Hugh Irvine

Hello Anton -

As mentioned previously, the answer depends on what else you are doing 
in your configuration file and how you are going to recognise and 
process the radius requests. You can use Handlers or cascaded AuthBy 
clauses, it depends on what else is required.

Please outline your requirements in more detail and I will try to make 
a sensible suggestion.

regards

Hugh


On Thursday, Jan 16, 2003, at 18:18 Australia/Melbourne, Anton Krall 
wrote:

If I needed to hard code the check into the authby so that the user
record (SQL) would only have username and pw?

__
Anton Krall
CEO


%-Original Message-
%From: [EMAIL PROTECTED]
%[mailto:[EMAIL PROTECTED]] On Behalf Of Hugh Irvine
%Sent: Jueves, 16 de Enero de 2003 12:09 a.m.
%To: Anton Krall
%Cc: [EMAIL PROTECTED]
%Subject: Re: (RADIATOR) Time check item
%
%
%
%Hello Anton -
%
%A check item usually goes in a user record.
%
%Ie:
%
%someuser  Password = xxx, Time = Wk-0800
%	..
%
%There are other possibilities depending on what else you are doing in
%your configuration file.
%
%regards
%
%Hugh
%
%
%On Thursday, Jan 16, 2003, at 16:19 Australia/Melbourne, Anton Krall
%wrote:
%
% Guys.. I trying to make 2 AuthBy SQL.. one is a standard one and the
% other is for a dialup plan called Nightly
%
% The 2nd one has to have a check item: Time = Wk-0800
%
% Thing is... where do I put the check item? I forgot :
%
% Thx for the help.
%
% __
% Anton Krall
%
%
% ===
% Archive at http://www.open.com.au/archives/radiator/
% Announcements on [EMAIL PROTECTED]
% To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe
% radiator' in the body of the message.
%
%
%
%--
%Radiator: the most portable, flexible and configurable RADIUS
%server anywhere. Available on *NIX, *BSD, Windows 95/98/2000,
%NT, MacOS X.
%-
%Nets: internetwork inventory and management - graphical,
%extensible, flexible with hardware, software, platform and
%database independence.
%
%===
%Archive at http://www.open.com.au/archives/radiator/
%Announcements on [EMAIL PROTECTED]
%To unsubscribe, email '[EMAIL PROTECTED]' with
%'unsubscribe radiator' in the body of the message.
%
%


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.




--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



RE: (RADIATOR) Dual Accounting Streams Possible?

2003-01-15 Thread david.kramar
Hi Cliff
FYI, maybe your RAS support AAA Broadcast Accounting like Cisco.

http://www.cisco.com/en/US/products/sw/iosswrel/ps1834/products_feature_guide09186a008007fe4a.html

David

-Pvodn zprva-
Od: Cliff Daniel [mailto:[EMAIL PROTECTED]]
Odeslno: 16. ledna 2003 1:59
Komu: [EMAIL PROTECTED]
Pedmt: (RADIATOR) Dual Accounting Streams Possible?


I'm looking for a way to configure radiator to send a duplicate stream 
to another radius host, just for logging purposes only.   Is there any 
easy way to accomplish this?  I've search the archives for this list and 
only saw one thing similar but that was for Auth and I didn't quite 
understand it :-)

Regards,
Cliff

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.