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
--
_____________________________________________________
Janet del Mundo
Internet Administrator, Startec Global Communications
135 Chalan Santo Papa Agana, Guam 96910
Email: [EMAIL PROTECTED]
===
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.
