Hello Janet -
There was a bug in SessionDatabase NULL. You should check the patches area.
hth
Hugh
On Tuesday 27 February 2001 14:10, Janet N del Mundo wrote:
> Hi Everyone,
>
> I'm trying to use multiple instances of SessionDatabase, but it keeps
> defaulting to the wrong SessionDatabase during the accounting request.
> I want to separate my dialup users and my DSL users. Everytime I do a
> radpwtst to test a regular dialup user, the SessionDatabase defaults to
> SessionDatabase SQL. I'm trying to figure out why, but I'm
> unsuccessful.
>
> Here's what I have:
> -------------------
>
> <SessionDatabase NULL>
> Identifier NULL
> </SessionDatabase>
>
> <SessionDatabase DBM>
> Identifier Dialup-SessionCheck
> Filename %D/online
> </SessionDatabase>
>
> <SessionDatabase SQL>
> Identifier DSL-SessionCheck
> DBSource dbi:FreeTDS:....;
> DBUsername radius
> DBAuth step!0ff
>
> AddQuery insert into RADONLINE ...
>
> DeleteQuery delete from RADONLINE where USERNAME='%n' and \
> NASIDENTIFIER='%N' and
> ACCTSESSIONID='%{Acct-Session-Id}'
>
> ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
>
> CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from
> RADONLINE \
> where USERNAME='%n'
>
> </SessionDatabase>
> ..
> ..
> ..
>
> <Handler NAS-IP-Address = xxx.xxx.xxx.xxx>
> SessionDatabase DSL-SessionCheck
> PasswordLogFileName %D/Radiator-2.17.1/gtapass.log.%y%m
> AuthByPolicy ContinueWhileAccept
> AuthBy Check-Users
>
> <AuthBy FILE>
> Filename %D/users-sql
> AddToReplyIfNotExist Framed-IP-Address = 255.255.255.254
> </AuthBy>
> </Handler>
>
> <Handler Request-Type = Accounting-Request>
> SessionDatabase NULL
> AuthByPolicy ContinueAlways
> AuthBy InsertIntoSQL
> </Handler>
>
> <Handler>
> SessionDatabase Dialup-SessionCheck
> PasswordLogFileName %D/Radiator-2.17.1/gtapass.log.%y%m
> AuthByPolicy ContinueWhileAccept
>
> AuthBy Check-Users
>
> <AuthBy FILE>
> Filename %D/users-sql
> AddToReplyIfNotExist Framed-IP-Address = 255.255.255.254
> </AuthBy>
>
> </Handler>
>
> Here's my log file:
> -------------------
> *** Received from 127.0.0.1 port 1637 ....
> Code: Access-Request
> Identifier: 62
> Authentic: 1234567890123456
> Attributes:
> User-Name = "mikesanlite"
> Service-Type = Framed-User
> NAS-IP-Address = 203.63.154.1
> NAS-Port = 11
> NAS-Port-Type = Async
> User-Password =
> "<255>!<207><158>ELL<177><225><27><202><174><163>[L<172>"
>
> Tue Feb 27 13:04:48 2001: DEBUG: Check if Handler Prefix = IPASS/ should
> be used to handle this request
> Tue Feb 27 13:04:48 2001: DEBUG: Check if Handler Realm = estart.com
> should be used to handle this request
> Tue Feb 27 13:04:48 2001: DEBUG: Check if Handler NAS-IP-Address =
> 202.128.81.2 should be used to handle this request
> Tue Feb 27 13:04:48 2001: DEBUG: Check if Handler Request-Type =
> Accounting-Request should be used to handle this request
> Tue Feb 27 13:04:48 2001: DEBUG: Check if Handler should be used to
> handle this request
> Tue Feb 27 13:04:48 2001: DEBUG: Handling request with Handler ''
> Tue Feb 27 13:04:48 2001: DEBUG: Dialup-SessionCheck Deleting session
> for mikesanlite, 203.63.154.1, 11
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthGROUP
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthFILE
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthFILE
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> DEFAULT
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSYSTEM
> Tue Feb 27 13:04:48 2001: DEBUG: getpwnam got mikesanlite,
> s1JrqcKdgmUlg, 4784, 2001, , , Mike Santos Lite, /fs1/u7/mikesanlite,
> /usr/slocal/sbin/flash
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM REJECT: User
> mikesanlite is not in Group mailbox
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE REJECT: User
> mikesanlite is not in Group mailbox
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> DEFAULT1
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSYSTEM
> Tue Feb 27 13:04:48 2001: DEBUG: getpwnam got mikesanlite,
> s1JrqcKdgmUlg, 4784, 2001, , , Mike Santos Lite, /fs1/u7/mikesanlite,
> /usr/slocal/sbin/flash
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM REJECT: User
> mikesanlite is not in Group gcc
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE REJECT: User
> mikesanlite is not in Group gcc
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> DEFAULT2
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSYSTEM
> Tue Feb 27 13:04:48 2001: DEBUG: getpwnam got mikesanlite,
> s1JrqcKdgmUlg, 4784, 2001, , , Mike Santos Lite, /fs1/u7/mikesanlite,
> /usr/slocal/sbin/flash
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM REJECT: User
> mikesanlite is not in Group shell
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE REJECT: User
> mikesanlite is not in Group shell
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> DEFAULT3
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSYSTEM
> Tue Feb 27 13:04:48 2001: DEBUG: getpwnam got mikesanlite,
> s1JrqcKdgmUlg, 4784, 2001, , , Mike Santos Lite, /fs1/u7/mikesanlite,
> /usr/slocal/sbin/flash
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM REJECT: User
> mikesanlite is not in Group limited
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE REJECT: User
> mikesanlite is not in Group limited
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> DEFAULT4
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSYSTEM
> Tue Feb 27 13:04:48 2001: DEBUG: getpwnam got mikesanlite,
> s1JrqcKdgmUlg, 4784, 2001, , , Mike Santos Lite, /fs1/u7/mikesanlite,
> /usr/slocal/sbin/flash
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM REJECT: User
> mikesanlite is not in Group email
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE REJECT: User
> mikesanlite is not in Group email
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> DEFAULT5
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSYSTEM
> Tue Feb 27 13:04:48 2001: DEBUG: getpwnam got mikesanlite,
> s1JrqcKdgmUlg, 4784, 2001, , , Mike Santos Lite, /fs1/u7/mikesanlite,
> /usr/slocal/sbin/flash
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM REJECT: User
> mikesanlite is not in Group isdn64
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE REJECT: User
> mikesanlite is not in Group isdn64
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> DEFAULT6
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSYSTEM
> Tue Feb 27 13:04:48 2001: DEBUG: getpwnam got mikesanlite,
> s1JrqcKdgmUlg, 4784, 2001, , , Mike Santos Lite, /fs1/u7/mikesanlite,
> /usr/slocal/sbin/flash
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM REJECT: User
> mikesanlite is not in Group isdn128
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE REJECT: User
> mikesanlite is not in Group isdn128
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> DEFAULT7
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSYSTEM
> Tue Feb 27 13:04:48 2001: DEBUG: getpwnam got mikesanlite,
> s1JrqcKdgmUlg, 4784, 2001, , , Mike Santos Lite, /fs1/u7/mikesanlite,
> /usr/slocal/sbin/flash
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM REJECT: User
> mikesanlite is not in Group unlimited
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE REJECT: User
> mikesanlite is not in Group unlimited
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> DEFAULT8
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSYSTEM
> Tue Feb 27 13:04:48 2001: DEBUG: getpwnam got mikesanlite,
> s1JrqcKdgmUlg, 4784, 2001, , , Mike Santos Lite, /fs1/u7/mikesanlite,
> /usr/slocal/sbin/flash
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSYSTEM ACCEPT:
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE ACCEPT:
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthFILE
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE looks for match with
> DEFAULT
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSQL
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSQL
> Tue Feb 27 13:04:48 2001: DEBUG: Query is: select Password, Expiration,
> SimUse, IdleTime, SessionTime, StaticIP from USERS where IDENTIFIER =
> 'mikesanlite' AND STATUS != 'C'
>
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSQL looks for match with
> mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthSQL ACCEPT:
> Tue Feb 27 13:04:48 2001: DEBUG: Radius::AuthFILE ACCEPT:
> Tue Feb 27 13:04:48 2001: DEBUG: Access accepted for mikesanlite
> Tue Feb 27 13:04:48 2001: DEBUG: Packet dump:
> *** Sending to 127.0.0.1 port 1637 ....
> Code: Access-Accept
> Identifier: 62
> Authentic: 1234567890123456
> Attributes:
> Framed-Protocol = PPP
> Service-Type = Annex-Framed-Tunnel
> Port-Limit = 1
> Idle-Timeout = 100
> Session-Timeout = 29000
> Framed-IP-Address = 255.255.255.254
>
> Tue Feb 27 13:04:48 2001: DEBUG: Packet dump:
> *** Received from 127.0.0.1 port 1637 ....
> Code: Accounting-Request
> Identifier: 63
> Authentic: (Y<16><188><164>Qm<230><229><149><1>w<237><193><159><224>
> Attributes:
> User-Name = "mikesanlite"
> Service-Type = Framed-User
> NAS-IP-Address = 203.63.154.1
> NAS-Port = 11
> NAS-Port-Type = Async
> Acct-Session-Id = "00001234"
> Acct-Status-Type = Start
> Framed-IP-Address = 255.255.255.254
>
> Tue Feb 27 13:04:48 2001: DEBUG: Check if Handler Prefix = IPASS/ should
> be used to handle this request
> Tue Feb 27 13:04:48 2001: DEBUG: Check if Handler Realm = estart.com
> should be used to handle this request
> Tue Feb 27 13:04:48 2001: DEBUG: Check if Handler NAS-IP-Address =
> 202.128.81.2 should be used to handle this request
> Tue Feb 27 13:04:48 2001: DEBUG: Check if Handler Request-Type =
> Accounting-Request should be used to handle this request
> Tue Feb 27 13:04:48 2001: DEBUG: Handling request with Handler
> 'Request-Type = Accounting-Request'
> Tue Feb 27 13:04:48 2001: DEBUG: DSL-SessionCheck Adding session for
> mikesanlite, 203.63.154.1, 11
> Tue Feb 27 13:04:48 2001: DEBUG: do query is: delete from RADONLINE
> where USERNAME='mikesanlite' and NASIDENTIFIER='203.63.154.1' and
> ACCTSESSIONID='00001234'
>
> Tue Feb 27 13:04:48 2001: DEBUG: do query is: insert into RADONLINE
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
> FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('mikesanlite',
> '203.63.154.1', 11,'00001234', 983243088, '255.255.255.254',
> '','Framed-User')
>
> Tue Feb 27 13:04:48 2001: DEBUG: Handling with Radius::AuthSQL
> Tue Feb 27 13:04:48 2001: DEBUG: Handling accounting with
> Radius::AuthSQL
> Tue Feb 27 13:04:48 2001: DEBUG: do query is: insert into ACCOUNTING
> (IDENTIFIER, TIME_STAMP, ACCTSTATUSTYPE, ACCTSESSIONID,
> NASIDENTIFIER, NASPORT, FRAMEDIPADDRESS)
> values
> ('mikesanlite', '02-27-2001 13:04:48', 'Start',
> '00001234', '203.63.154.1', 11, '255.255.255.254')
>
> Tue Feb 27 13:04:48 2001: DEBUG: Accounting accepted
> Tue Feb 27 13:04:48 2001: DEBUG: Packet dump:
> *** Sending to 127.0.0.1 port 1637 ....
> Code: Accounting-Response
> Identifier: 63
> Authentic: (Y<16><188><164>Qm<230><229><149><1>w<237><193><159><224>
> Attributes:
>
> HELP!!!
> Janet
--
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.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
