(RADIATOR) SessionDatabase Problem

[Julian Rose]

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.