(RADIATOR) SessionDatabase Problem
Julian Rose
julian.rose at atlas.net.uk
Fri Jan 25 10:51:49 CST 2002
Hi All,
I am having problems with getting the session database function to work
correctly,
When I issue a request to the server, I see the server try to run the delete
query, but not the add or count queries.
Is something wrong here, or do I not understand the function properly ;)
Best regards.. Julian.
----debug----
Attributes:
NAS-IP-Address = 195.54.226.39
NAS-Port = 38
NAS-Port-Type = Async
User-Name = "test"
Called-Station-Id = "408"
Calling-Station-Id = "2074281900"
User-Password =
"<210>t<233>:<243>d<31><25>n<190><201><146><194>fz<141>"
Service-Type = Framed-User
Framed-Protocol = PPP
Fri Jan 25 16:13:41 2002: DEBUG: Handling request with Handler
'Realm=atlas.co.uk'
Fri Jan 25 16:13:41 2002: DEBUG: rad-a Deleting session for test,
195.54.226.39, 38
Fri Jan 25 16:13:41 2002: DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='195.54.226.39' and NASPORT=038
Fri Jan 25 16:13:41 2002: DEBUG: Handling with Radius::AuthSQL
Fri Jan 25 16:13:41 2002: DEBUG: Handling with Radius::AuthSQL:
Fri Jan 25 16:13:41 2002: DEBUG: Query is: select s.PASSWORD, r.ATTR1,
r.ATTR2, s.ATTR1, s.ATTR2, s.ATTR3, s.ATTR4 from STANDARD s, REALMS r where
s.REALM = r.REALM AND s.USERNAME="test" and s.ACTIVE="Y"
Fri Jan 25 16:13:41 2002: DEBUG: Radius::AuthSQL looks for match with
test at atlas.co.uk
Fri Jan 25 16:13:41 2002: DEBUG: Radius::AuthSQL ACCEPT:
Fri Jan 25 16:13:41 2002: DEBUG: Access accepted for test at atlas.co.uk
Fri Jan 25 16:13:41 2002: DEBUG: do query is: insert into AUTHLOG values
('1011975221', 'test', 'atlas.co.uk', '195.54.226.39', 'OK', '')
Fri Jan 25 16:13:41 2002: DEBUG: Packet dump:
*** Sending to 195.54.226.39 port 1645 ....
Packet length = 44
02 0f 00 2c 10 13 24 a6 08 dd 7c 3c d9 91 02 a4
78 04 e3 09 08 06 c3 36 e9 01 06 06 00 00 00 02
0d 06 00 00 00 01 07 06 00 00 00 01
Code: Access-Accept
Identifier: 15
Authentic: <144><5><13><28><160><231><211><138>i<146><153><254><177><209>\e
Attributes:
Framed-IP-Address = 195.54.233.1
User-Service = 2
Framed-Compression = Van-Jacobsen-TCP-IP
Framed-Protocol = PPP
----/debug----
----config----
<Realm atlas.co.uk>
<AuthBy SQL>
DBSource dbi:mysql:radius
DBUsername #######
DBAuth #######
AuthSelect \
select s.PASSWORD, r.ATTR1, r.ATTR2, s.ATTR1, \
s.ATTR2, s.ATTR3, s.ATTR4 from STANDARD s, REALMS r \
where s.REALM = r.REALM AND s.USERNAME="%U" and s.ACTIVE="Y"
AuthColumnDef 0, User-Password, check
AuthColumnDef 1, User-Service, reply
AuthColumnDef 2, Framed-Compression, reply
AuthColumnDef 3, Framed-Protocol, reply
AuthColumnDef 4, Framed-IP-Address, reply
AuthColumnDef 5, cisco-avpair, reply
AuthColumnDef 6, Idle-Timeout, reply
# Accounting Logs
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctFailedLogFileName %L/missedaccounting
</AuthBy>
AuthLog sqllog
</Realm>
<SessionDatabase SQL>
DBSource dbi:mysql:radius
DBUsername #######
DBAuth #######
</SessionDatabase>
----/config---
_____________________________________________________________________
This message has been checked for all known viruses by Atlas Internet
Powered by MessageLabs - http://www.atlas.net.uk
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list