Hugh, Thanks, that did the trick.
Julian > -----Original Message----- > From: Hugh Irvine [mailto:[EMAIL PROTECTED]] > Sent: 26 January 2002 01:29 > To: Julian Rose; [EMAIL PROTECTED] > 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 > > [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. > > _____________________________________________________________________ > 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
