(RADIATOR) SessionDatabase Problem
Julian Rose
julian.rose at atlas.net.uk
Tue Jan 29 11:50:43 CST 2002
Hugh,
Thanks, that did the trick.
Julian
> -----Original Message-----
> From: Hugh Irvine [mailto:hugh at open.com.au]
> Sent: 26 January 2002 01:29
> To: Julian Rose; radiator at open.com.au
> Subject: Re: (RADIATOR) SessionDatabase Problem
>
>
>
> 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
> > 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.
>
> --
> 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.
>
> _____________________________________________________________________
> This message has been scanned for all known viruses.
> Atlas Internet - Powered By MessageLabs.
_____________________________________________________________________
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