Salut Mike and Hugues !
I had already "aaa accounting update newinfo" on my Cisco 5300.
1) However, why FRAMEDIPADDRESS field is not sometimes present in the SQL
insert or update as I mentioned below ?
It seems also that Alive packets are not sent sometimes and in that case,
Framed-IP-Address is not present in Stop packets.
Then, IP state stays at '1' and I need to expire it. Before solving the
problem of absence of Alive and IP in Stop, I would like to put a new
"update RADPOOL" query at each Stop packets which allows to free the state
of the IP corresponding to the callingID (I will create a callingID column
in RADPOOL and I suppose that there is one session by callingID).
2) Is it possible to do that ?
Thanks in advance for your help. Gildas.
-----Message d'origine-----
De : Mike McCauley [mailto:[EMAIL PROTECTED]]
Envoyé : vendredi 29 septembre 2000 15:52
À : Gildas PERROT
Cc : [EMAIL PROTECTED]
Objet :
Hello Gildas,
Looks like your Accounting Stop does not contain the Framed-IP-Address
needed
to determine which address to clear from the pools table. Theis means that
your
NAS is not sending Framed-IP-Address. Do you know why that might be? Are you
using Cisco NAS? If so this is a known problkem with Cisco, and I believe
there
is a special Cisco config flag to tell it to include the IP address in
accounting requests. Hugh, can you confirm that?
Cheers.
On Sep 28, 11:41pm, [EMAIL PROTECTED] wrote:
> Subject: BOUNCE [EMAIL PROTECTED]: Message too long (>40000 chars)
> >From mikem Thu Sep 28 23:41:23 2000
> Received: by oscar.open.com.au (8.9.0/8.9.0) id XAA13343
> for [EMAIL PROTECTED]; Thu, 28 Sep 2000 23:41:21 +1000 (EST)
> >Received: from hyperbate.francenet.fr (hyperbate.francenet.fr
[193.149.97.80]) by perki.connect.com.au with ESMTP id AAA11208
> (8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Fri, 29 Sep 2000 00:32:00
+1100
(EST)
> Received: from hyperbate.francenet.fr (hyperbate.francenet.fr
[193.149.97.80]) by perki.connect.com.au with ESMTP id AAA11208
> (8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Fri, 29 Sep 2000 00:32:00
+1100
(EST)
> Received: from secours (ARennes-301-1-1-10.abo.wanadoo.fr [193.251.66.10])
> by hyperbate.francenet.fr (8.10.1/8.10.1) with SMTP id e8SDVPn00155
> for <[EMAIL PROTECTED]>; Thu, 28 Sep 2000 15:31:26 +0200 (MET DST)
> From: "Gildas PERROT" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Problem with SQL accounting
> Date: Thu, 28 Sep 2000 15:30:49 +0200
> Message-ID: <[EMAIL PROTECTED]>
> MIME-Version: 1.0
> X-Priority: 3 (Normal)
> X-MSMail-Priority: Normal
> X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
> Importance: Normal
> X-Mimeole: Produced By Microsoft MimeOLE V5.50.4133.2400
> Content-Type: multipart/mixed;
> boundary="----=_NextPart_000_004A_01C02961.14128B20"
>
> C'est un message de format MIME en plusieurs parties.
>
> ------=_NextPart_000_004A_01C02961.14128B20
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> Hi,
>
> I am using SQL authentification and accounting with Radiator-2.16.3 and
> MySQL 3.22.32.
>
> I noticed that sometimes, client IP is not saved in accounting tables and
in
> the same time, its state is not put to 0 after the end of the session.
> Here are the interesting debug lines :
>
> Thu Sep 28 09:13:43 2000: DEBUG: do query is: insert into 2000_09_28
> (USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
ACCTINPUTOCTETS,
> ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, NASPORT, CALLINGID,
> CALLEDID)
> values
> ('carrefour', 970125223, 'Stop', 0, 294, 153, '0000015A', 4,
20,
> '608715017', '6641')
>
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthDYNADDRESS
> Thu Sep 28 09:13:43 2000: DEBUG: do query is: update RADPOOL set STATE=0,
> TIME_STAMP=970125223
> where YIADDR=''
>
> You can see here that FRAMEDIPADDRESS is not in the "insert" SQL request
and
> YIADDR is empty in the "update" SQL request.
>
> That problem doesn't occur sytematically and you see below that sometimes,
> everything is OK (I didn't change anything between the 2 cases)
>
> Thu Sep 28 09:15:51 2000: DEBUG: do query is: insert into 2000_09_28
> (USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
ACCTINPUTOCTETS,
> ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, NASPORT,
FRAMEDIPADDRESS,
> CALLINGID, CALLEDID)
> values
> ('carrefour', 970125351, 'Stop', 0, 554, 1506, '0000015C', 122,
11,
> '10.69.1.42', '670487956', '6641')
>
> Thu Sep 28 09:15:51 2000: DEBUG: Handling with Radius::AuthDYNADDRESS
> Thu Sep 28 09:15:51 2000: DEBUG: do query is: update RADPOOL set STATE=0,
> TIME_STAMP=970125351
> where YIADDR='10.69.1.42'
>
> Any idea about that problem ? Thanks in advance for your help.
Gildas.
>
> ------=_NextPart_000_004A_01C02961.14128B20
> Content-Type: text/plain;
> name="radius_cfg.txt"
> Content-Transfer-Encoding: quoted-printable
> Content-Disposition: attachment;
> filename="radius_cfg.txt"
>
> Foreground
> Trace 4
> AuthPort 1645
> AcctPort 1646
> LogDir /var/log/radiator
> DbDir /usr/local/etc/radiator
> LogFile %L//%Y%m/radiator-%Y%m%d
> DictionaryFile %D/dictionary
> #PidFile %L/radiator.pid
> PidFile /tmp/radiator.pid
>
> # Mise en minuscules des username pour l'accounting=20
> # car l'authentification MySQL est insensible a la caste
> RewriteUsername tr/A-Z/a-z/
>
> <Client DEFAULT>
> Secret *****
> # Adresse de base pour le Framed-Group =3D 0 : IP =3D cette IP + =
> NAS-Port
> # FramedGroupBaseAddress 10.69.1.30
> </Client>
>
> # Plages d'adresses IP pour table RADPOOL
> <AddressAllocator SQL>
> Identifier SQLAllocator
> DBSource dbi:mysql:radius
> DBUsername radiator
> DBAuth ra1diator
>
> <AddressPool Test>
> Subnetmask 255.255.255.0
> Range 10.69.1.199 10.69.1.199
> </AddressPool>
> <AddressPool Public>
> Subnetmask 255.255.255.0
> Range 10.69.1.200 10.69.1.253
> </AddressPool>
> <AddressPool Fluxus>
> Subnetmask 255.255.255.0
> Range 10.69.1.25 10.69.1.39
> </AddressPool>
> <AddressPool Carrefour>
> Subnetmask 255.255.255.0
> Range 10.69.1.40 10.69.1.54
> </AddressPool>
> </AddressAllocator>
>
> # Appel sur le 66 42
> #<Handler Called-Station-Id =3D 6642>
>
> <Handler>
> SessionDatabase SDBSQL
> # <AuthBy FILE>
> # Filename %D/users.6642
> # Nocache
> AuthByPolicy ContinueWhileAccept
> <AuthBy SQL>
> DBSource dbi:mysql:radius
> DBUsername radiator
> DBAuth ra1diator
> AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
> from SUBSCRIBERS where USERNAME =3D '%n'
> </AuthBy>
> <AuthBy SQL>
> DBSource dbi:mysql:radius
> DBUsername radiator
> DBAuth ra1diator
> AuthSelect select NULL, CHECKATTR, REPLYATTR from SUBSCRIBERS
where =
> USERNAME =3D 'DEFAULT'
> AccountingStopsOnly
> AccountingTable %Y_%m_%d
> 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 NASPORT,NAS-Port,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> AcctColumnDef CALLINGID, Calling-Station-Id
> AcctColumnDef CALLEDID, Called-Station-Id
> </AuthBy>
> <AuthBy DYNADDRESS>
> Allocator SQLAllocator
> StripFromReply PoolHint
> </AuthBy>
> </Handler>
>
> #<Handler>
> # AcctLogFileName %L/%Y%m/account-%Y%m%d
> # # permet d'avoir plusieurs AuthBy
> # AuthByPolicy ContinueWhileReject
> # <AuthBy FILE>
> # Filename %D/wap
> # FramedGroup 0
> # </AuthBy>
> # <AuthBy FILE>
> # Filename %D/kit
> # </AuthBy>
> #</Handler>
>
> # Base de donnees des sessions ouvertes
> <SessionDatabase SQL>
> Identifier SDBSQL
> DBSource dbi:mysql:radius
> DBUsername radiator
> DBAuth ra1diator
> AddQuery insert into ONLINE (USERNAME, NASIDENTIFIER, NASPORT, \
> ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, CALLINGID,
CALLEDID) \
> values ('%n', '%N', %{NAS-Port}, '%{Acct-Session-Id}', \
> %{Timestamp}, '%{Framed-IP-Address}', %{Calling-Station-Id}, =
> %{Called-Station-Id} )
> DeleteQuery delete from ONLINE where USERNAME=3D'%n' and =
> NASPORT=3D%{NAS-Port}
> </SessionDatabase>
>
>
>
>
> ------=_NextPart_000_004A_01C02961.14128B20
> Content-Type: text/plain;
> name="radiator-20000928.txt"
> Content-Transfer-Encoding: quoted-printable
> Content-Disposition: attachment;
> filename="radiator-20000928.txt"
>
> Thu Sep 28 09:13:39 2000: DEBUG: Packet dump:
> *** Received from 10.69.1.1 port 1645 ....
> Code: Access-Request
> Identifier: 69
> Authentic: <236><0><24>fp<228><142>1<192>F<129><134><19><205>g<162>
> Attributes:
> NAS-IP-Address =3D 10.69.1.1
> NAS-Port =3D 20
> NAS-Port-Type =3D Async
> User-Name =3D "Carrefour"
> Called-Station-Id =3D "6641"
> Calling-Station-Id =3D "608715017"
> CHAP-Password =3D =
> "<9><206><243><239><243><255>V<218>G<183><15><31><229><188><246><8>F"
> Service-Type =3D Framed-User
> Framed-Protocol =3D PPP
>
> Thu Sep 28 09:13:39 2000: DEBUG: Rewrote user name to carrefour
> Thu Sep 28 09:13:39 2000: DEBUG: Check if Handler should be used to =
> handle this request
> Thu Sep 28 09:13:39 2000: DEBUG: Handling request with Handler ''
> Thu Sep 28 09:13:39 2000: DEBUG: SDBSQL Deleting session for Carrefour, =
> 10.69.1.1, 20
> Thu Sep 28 09:13:39 2000: DEBUG: do query is: delete from ONLINE where =
> USERNAME=3D'carrefour' and NASPORT=3D20
>
> Thu Sep 28 09:13:39 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:39 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:39 2000: DEBUG: Query is: select PASSWORD, CHECKATTR, =
> REPLYATTR from SUBSCRIBERS where USERNAME =3D 'carrefour'
>
> Thu Sep 28 09:13:39 2000: DEBUG: Radius::AuthSQL looks for match with =
> carrefour
> Thu Sep 28 09:13:39 2000: DEBUG: Radius::AuthSQL ACCEPT:=20
> Thu Sep 28 09:13:39 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:39 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:39 2000: DEBUG: Query is: select NULL, CHECKATTR, =
> REPLYATTR from SUBSCRIBERS where USERNAME =3D 'DEFAULT'
>
> Thu Sep 28 09:13:39 2000: DEBUG: Radius::AuthSQL looks for match with =
> carrefour
> Thu Sep 28 09:13:39 2000: DEBUG: Radius::AuthSQL ACCEPT:=20
> Thu Sep 28 09:13:39 2000: DEBUG: Handling with Radius::AuthDYNADDRESS
> Thu Sep 28 09:13:39 2000: DEBUG: Query is: select YIADDR, SUBNETMASK, =
> DNSSERVER from RADPOOL where
> POOL=3D'Carrefour' and STATE=3D0 order by TIME_STAMP
>
> Thu Sep 28 09:13:39 2000: DEBUG: do query is: update RADPOOL set =
> STATE=3D1, TIME_STAMP=3D970125219,=20
> EXPIRY=3D970211619, USERNAME=3D'carrefour' where YIADDR=3D'10.69.1.51'
>
> Thu Sep 28 09:13:39 2000: DEBUG: Access accepted for carrefour
> Thu Sep 28 09:13:39 2000: DEBUG: Packet dump:
> *** Sending to 10.69.1.1 port 1645 ....
> Code: Access-Accept
> Identifier: 69
> Authentic: <236><0><24>fp<228><142>1<192>F<129><134><19><205>g<162>
> Attributes:
> Service-Type =3D Framed-User
> Framed-IP-Netmask =3D 255.255.255.0
> Framed-IP-Address =3D 10.69.1.51
>
> Thu Sep 28 09:13:39 2000: DEBUG: Packet dump:
> *** Received from 10.69.1.1 port 1646 ....
> Code: Accounting-Request
> Identifier: 70
> Authentic: <20>.S<30><137>^,<239>]j<198>&<139>/<193><240>
> Attributes:
> NAS-IP-Address =3D 10.69.1.1
> NAS-Port =3D 20
> NAS-Port-Type =3D Async
> User-Name =3D "Carrefour"
> Called-Station-Id =3D "6641"
> Calling-Station-Id =3D "608715017"
> Acct-Status-Type =3D Start
> Acct-Authentic =3D RADIUS
> Service-Type =3D Framed-User
> Acct-Session-Id =3D "0000015A"
> Framed-Protocol =3D PPP
> Acct-Delay-Time =3D 0
>
> Thu Sep 28 09:13:39 2000: DEBUG: Rewrote user name to carrefour
> Thu Sep 28 09:13:39 2000: DEBUG: Check if Handler should be used to =
> handle this request
> Thu Sep 28 09:13:39 2000: DEBUG: Handling request with Handler ''
> Thu Sep 28 09:13:39 2000: DEBUG: SDBSQL Adding session for Carrefour, =
> 10.69.1.1, 20
> Thu Sep 28 09:13:39 2000: DEBUG: do query is: delete from ONLINE where =
> USERNAME=3D'carrefour' and NASPORT=3D20
>
> Thu Sep 28 09:13:39 2000: DEBUG: do query is: insert into ONLINE =
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, =
> FRAMEDIPADDRESS, CALLINGID, CALLEDID) values ('carrefour', '10.69.1.1', =
> 20, '0000015A', 970125219, '', 608715017, 6641 )
>
> Thu Sep 28 09:13:39 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:39 2000: DEBUG: Handling accounting with =
> Radius::AuthSQL
> Thu Sep 28 09:13:39 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:39 2000: DEBUG: Handling accounting with =
> Radius::AuthSQL
> Thu Sep 28 09:13:39 2000: DEBUG: Handling with Radius::AuthDYNADDRESS
> Thu Sep 28 09:13:39 2000: DEBUG: Accounting accepted
> Thu Sep 28 09:13:39 2000: DEBUG: Packet dump:
> *** Sending to 10.69.1.1 port 1646 ....
> Code: Accounting-Response
> Identifier: 70
> Authentic: <20>.S<30><137>^,<239>]j<198>&<139>/<193><240>
> Attributes:
>
> Thu Sep 28 09:13:43 2000: DEBUG: Packet dump:
> *** Received from 10.69.1.1 port 1645 ....
> Code: Access-Request
> Identifier: 71
> Authentic: "<189>P<226><212><156>q.<192>F<129><134>y<8><208>9
> Attributes:
> NAS-IP-Address =3D 10.69.1.1
> NAS-Port =3D 20
> NAS-Port-Type =3D Async
> User-Name =3D "Carrefour"
> Called-Station-Id =3D "6641"
> Calling-Station-Id =3D "608715017"
> CHAP-Password =3D =
> "<10><21>k<197>qo<180>P<132><225>QG<204><197><131><199><205>"
> Service-Type =3D Framed-User
> Framed-Protocol =3D PPP
>
> Thu Sep 28 09:13:43 2000: DEBUG: Rewrote user name to carrefour
> Thu Sep 28 09:13:43 2000: DEBUG: Check if Handler should be used to =
> handle this request
> Thu Sep 28 09:13:43 2000: DEBUG: Handling request with Handler ''
> Thu Sep 28 09:13:43 2000: DEBUG: SDBSQL Deleting session for Carrefour, =
> 10.69.1.1, 20
> Thu Sep 28 09:13:43 2000: DEBUG: do query is: delete from ONLINE where =
> USERNAME=3D'carrefour' and NASPORT=3D20
>
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Query is: select PASSWORD, CHECKATTR, =
> REPLYATTR from SUBSCRIBERS where USERNAME =3D 'carrefour'
>
> Thu Sep 28 09:13:43 2000: DEBUG: Radius::AuthSQL looks for match with =
> carrefour
> Thu Sep 28 09:13:43 2000: DEBUG: Radius::AuthSQL ACCEPT:=20
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Query is: select NULL, CHECKATTR, =
> REPLYATTR from SUBSCRIBERS where USERNAME =3D 'DEFAULT'
>
> Thu Sep 28 09:13:43 2000: DEBUG: Radius::AuthSQL looks for match with =
> carrefour
> Thu Sep 28 09:13:43 2000: DEBUG: Radius::AuthSQL ACCEPT:=20
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthDYNADDRESS
> Thu Sep 28 09:13:43 2000: DEBUG: Query is: select YIADDR, SUBNETMASK, =
> DNSSERVER from RADPOOL where
> POOL=3D'Carrefour' and STATE=3D0 order by TIME_STAMP
>
> Thu Sep 28 09:13:43 2000: DEBUG: do query is: update RADPOOL set =
> STATE=3D1, TIME_STAMP=3D970125223,=20
> EXPIRY=3D970211623, USERNAME=3D'carrefour' where YIADDR=3D'10.69.1.49'
>
> Thu Sep 28 09:13:43 2000: DEBUG: Access accepted for carrefour
> Thu Sep 28 09:13:43 2000: DEBUG: Packet dump:
> *** Sending to 10.69.1.1 port 1645 ....
> Code: Access-Accept
> Identifier: 71
> Authentic: "<189>P<226><212><156>q.<192>F<129><134>y<8><208>9
> Attributes:
> Service-Type =3D Framed-User
> Framed-IP-Netmask =3D 255.255.255.0
> Framed-IP-Address =3D 10.69.1.49
>
> Thu Sep 28 09:13:43 2000: DEBUG: Packet dump:
> *** Received from 10.69.1.1 port 1646 ....
> Code: Accounting-Request
> Identifier: 72
> Authentic: <243>J<225><227>E<244>4c<173>aX<142><152>8<172>q
> Attributes:
> NAS-IP-Address =3D 10.69.1.1
> NAS-Port =3D 20
> NAS-Port-Type =3D Async
> User-Name =3D "Carrefour"
> Called-Station-Id =3D "6641"
> Calling-Station-Id =3D "608715017"
> Acct-Status-Type =3D Stop
> Acct-Authentic =3D RADIUS
> Service-Type =3D Framed-User
> Acct-Session-Id =3D "0000015A"
> Framed-Protocol =3D PPP
> Acct-Input-Octets =3D 294
> Acct-Output-Octets =3D 153
> Acct-Input-Packets =3D 9
> Acct-Output-Packets =3D 8
> Acct-Session-Time =3D 4
> Acct-Delay-Time =3D 0
>
> Thu Sep 28 09:13:43 2000: DEBUG: Rewrote user name to carrefour
> Thu Sep 28 09:13:43 2000: DEBUG: Check if Handler should be used to =
> handle this request
> Thu Sep 28 09:13:43 2000: DEBUG: Handling request with Handler ''
> Thu Sep 28 09:13:43 2000: DEBUG: SDBSQL Deleting session for Carrefour, =
> 10.69.1.1, 20
> Thu Sep 28 09:13:43 2000: DEBUG: do query is: delete from ONLINE where =
> USERNAME=3D'carrefour' and NASPORT=3D20
>
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Handling accounting with =
> Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Handling accounting with =
> Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: do query is: insert into 2000_09_28
> (USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
ACCTINPUTOCTETS, =
> ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, NASPORT, CALLINGID, =
> CALLEDID)=20
> values=20
> ('carrefour', 970125223, 'Stop', 0, 294, 153, '0000015A', 4,
20, =
> '608715017', '6641')
>
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthDYNADDRESS
> Thu Sep 28 09:13:43 2000: DEBUG: do query is: update RADPOOL set =
> STATE=3D0, TIME_STAMP=3D970125223
> where YIADDR=3D''
>
> Thu Sep 28 09:13:43 2000: DEBUG: Accounting accepted
> Thu Sep 28 09:13:43 2000: DEBUG: Packet dump:
> *** Sending to 10.69.1.1 port 1646 ....
> Code: Accounting-Response
> Identifier: 72
> Authentic: <243>J<225><227>E<244>4c<173>aX<142><152>8<172>q
> Attributes:
>
> Thu Sep 28 09:13:43 2000: DEBUG: Packet dump:
> *** Received from 10.69.1.1 port 1646 ....
> Code: Accounting-Request
> Identifier: 73
> Authentic: <171>`<191><205><179><157><216>_p%<143>@<196><235>5<240>
> Attributes:
> NAS-IP-Address =3D 10.69.1.1
> NAS-Port =3D 20
> NAS-Port-Type =3D Async
> User-Name =3D "Carrefour"
> Called-Station-Id =3D "6641"
> Calling-Station-Id =3D "608715017"
> Acct-Status-Type =3D Start
> Acct-Authentic =3D RADIUS
> Service-Type =3D Framed-User
> Acct-Session-Id =3D "0000015B"
> Framed-Protocol =3D PPP
> Acct-Delay-Time =3D 0
>
> Thu Sep 28 09:13:43 2000: DEBUG: Rewrote user name to carrefour
> Thu Sep 28 09:13:43 2000: DEBUG: Check if Handler should be used to =
> handle this request
> Thu Sep 28 09:13:43 2000: DEBUG: Handling request with Handler ''
> Thu Sep 28 09:13:43 2000: DEBUG: SDBSQL Adding session for Carrefour, =
> 10.69.1.1, 20
> Thu Sep 28 09:13:43 2000: DEBUG: do query is: delete from ONLINE where =
> USERNAME=3D'carrefour' and NASPORT=3D20
>
> Thu Sep 28 09:13:43 2000: DEBUG: do query is: insert into ONLINE =
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, =
> FRAMEDIPADDRESS, CALLINGID, CALLEDID) values ('carrefour', '10.69.1.1', =
> 20, '0000015B', 970125223, '', 608715017, 6641 )
>
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Handling accounting with =
> Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Handling accounting with =
> Radius::AuthSQL
> Thu Sep 28 09:13:43 2000: DEBUG: Handling with Radius::AuthDYNADDRESS
> Thu Sep 28 09:13:43 2000: DEBUG: Accounting accepted
> Thu Sep 28 09:13:43 2000: DEBUG: Packet dump:
> *** Sending to 10.69.1.1 port 1646 ....
> Code: Accounting-Response
> Identifier: 73
> Authentic: <171>`<191><205><179><157><216>_p%<143>@<196><235>5<240>
> Attributes:
>
> Thu Sep 28 09:13:49 2000: DEBUG: Packet dump:
> *** Received from 10.69.1.1 port 1645 ....
> Code: Access-Request
> Identifier: 74
> Authentic: _0 <152><217>sD<140><192>F<129><134><9>j<149><225>
> Attributes:
> NAS-IP-Address =3D 10.69.1.1
> NAS-Port =3D 11
> NAS-Port-Type =3D Async
> User-Name =3D "Carrefour"
> Called-Station-Id =3D "6641"
> Calling-Station-Id =3D "670487956"
> CHAP-Password =3D =
> "<7><187>"meBU<252><6><15><129>><213><235><26><249><170>"
> Service-Type =3D Framed-User
> Framed-Protocol =3D PPP
>
> Thu Sep 28 09:13:49 2000: DEBUG: Rewrote user name to carrefour
> Thu Sep 28 09:13:49 2000: DEBUG: Check if Handler should be used to =
> handle this request
> Thu Sep 28 09:13:49 2000: DEBUG: Handling request with Handler ''
> Thu Sep 28 09:13:49 2000: DEBUG: SDBSQL Deleting session for Carrefour, =
> 10.69.1.1, 11
> Thu Sep 28 09:13:49 2000: DEBUG: do query is: delete from ONLINE where =
> USERNAME=3D'carrefour' and NASPORT=3D11
>
> Thu Sep 28 09:13:49 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:49 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:49 2000: DEBUG: Query is: select PASSWORD, CHECKATTR, =
> REPLYATTR from SUBSCRIBERS where USERNAME =3D 'carrefour'
>
> Thu Sep 28 09:13:49 2000: DEBUG: Radius::AuthSQL looks for match with =
> carrefour
> Thu Sep 28 09:13:49 2000: DEBUG: Radius::AuthSQL ACCEPT:=20
> Thu Sep 28 09:13:49 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:49 2000: DEBUG: Handling with Radius::AuthSQL
> Thu Sep 28 09:13:49 2000: DEBUG: Query is: select NULL, CHECKATTR, =
> REPLYATTR from SUBSCRIBERS where USERNAME =3D 'DEFAULT'
>
> Thu Sep 28 09:13:49 2000: DEBUG: Radius::AuthSQL looks for match with =
> carrefour
> Thu Sep 28 09:13:49 2000: DEBUG: Radius::AuthSQL ACCEPT:=20
> Thu Sep 28 09:13:49 2000: DEBUG: Handling with Radius::AuthDYNADDRESS
> Thu Sep 28 09:13:49 2000: DEBUG: Query is: select YIADDR, SUBNETMASK, =
> DNSSERVER from RADPOOL where
> POOL=3D'Carrefour' and STATE=3D0 order by TIME_STAMP
>
> Thu Sep 28 09:13:49 2000: DEBUG: do query is: update RADPOOL set =
> STATE=3D1, TIME_STAMP=3D970125229,=20
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
