Hello Julian -
The entries in the session database are maintained by the accounting records
sent by the NAS once the session starts. If you are not receiving accounting
records, you will not see any entries in the RADONLINE table.
regards
Hugh
On Sat, 26 Jan 2002 03:51, Julian Rose wrote:
> 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
> [EMAIL PROTECTED]
> Fri Jan 25 16:13:41 2002: DEBUG: Radius::AuthSQL ACCEPT:
> Fri Jan 25 16:13:41 2002: DEBUG: Access accepted for [EMAIL PROTECTED]
> 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 [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
--
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.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
