Is this for version 2.17.1? I don't see patches for SessionDatabase
NULL for 2.17.1.
I tried reversing the order - placing SessionDatabase DBM last and it
seems to be working... that's weird. I read one of your old emails and
you said to try to reverse the order which I did. Is this the bug?
Thanks,
Janet
Hugh Irvine wrote:
>
> 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.
--
_____________________________________________________
Janet del Mundo
Internet Administrator, Startec Global Communications
135 Chalan Santo Papa Agana, Guam 96910
Email: [EMAIL PROTECTED]
Phone: (671) 475-6879
Fax : (671) 477-6054
===
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.
