(RADIATOR) AuthLog & Framed-IP-Address

Thu, 14 Aug 2003 13:00:48 -0700

I'm having problems getting Radiator to log the Framed-IP-Address in the SQL logs it generates. The NAS's are 3Com & Cisco devices. The problem seems to originate from the fact that the record is created before the NAS responds with the reply that contains the Framed-IP-Address. Here is a debug & part of my radius config. I've been digging through the archives & fighting this for a couple days, so any help would be appreciated. Thanks.

*** Received from ###.###.###.### port 1812 ....
Code:       Access-Request
Identifier: 161
Authentic:  <238><182><17>;-<218><212><199><12><225>X<245><192>d<30>|
Attributes:
   NAS-IP-Address = ###.###.###.###
   NAS-Port = 24
   NAS-Port-Type = Virtual
   User-Name = "user"
   User-Password = xxxxxxxxxx
   Service-Type = Framed-User
   Framed-Protocol = PPP

Fri Aug 8 13:35:51 2003: DEBUG: Rewrote user name to user
Fri Aug 8 13:35:51 2003: DEBUG: Handling request with Handler ''
Fri Aug 8 13:35:51 2003: DEBUG: Deleting session for user, ###.###.###.###, 24
Fri Aug 8 13:35:51 2003: DEBUG: Handling with Radius::AuthSQL
Fri Aug 8 13:35:51 2003: DEBUG: Handling with Radius::AuthSQL:
Fri Aug 8 13:35:51 2003: DEBUG: Query is:
Fri Aug 8 13:35:51 2003: DEBUG: Radius::AuthSQL looks for match with user
Fri Aug 8 13:35:51 2003: DEBUG: Radius::AuthSQL ACCEPT:
Fri Aug 8 13:35:51 2003: DEBUG: Access accepted for user
Fri Aug 8 13:35:51 2003: DEBUG: do query is: 'insert into RadAcct values ('13:35:51','08/08/2003','Success','user','user','###.###.###.###','','')':

Fri Aug  8 13:35:51 2003: DEBUG: Packet dump:
*** Sending to ###.###.###.### port 1812 ....
Code:       Access-Accept
Identifier: 161
Authentic:  <238><182><17>;-<218><212><199><12><225>X<245><192>d<30>|
Attributes:
   Service-Type = Framed-User
   Framed-Protocol = PPP
   Framed-Routing = None
   Framed-MTU = 1500
   Framed-Compression = Van-Jacobson-TCP-IP
   Idle-Timeout = 1800
   Session-Timeout = 43200
   Port-Limit = 1

Fri Aug  8 13:35:54 2003: DEBUG: Packet dump:
*** Received from ###.###.###.### port 1813 ....
Code:       Accounting-Request
Identifier: 162
Authentic:  <233>h.<128><149><209><214><167>kN<23><215><253>^<180><22>
Attributes:
   NAS-IP-Address = ###.###.###.###
   NAS-Port = 24
   NAS-Port-Type = Virtual
   User-Name = "user"
   Acct-Status-Type = Start
   Acct-Authentic = RADIUS
   Service-Type = Framed-User
   Acct-Session-Id = "000179B4"
   Framed-Protocol = PPP
   Framed-IP-Address = ###.###.###.###
   Acct-Delay-Time = 0



<Handler>

   # Look up user details in a mySQL DB
   <AuthBy SQL>

       DBSource     xxxxxxx
       DBUsername     xxxxxxx
       DBAuth         xxxxxxx

AuthSelect select xxxxxxxxxxxxxxx

       AddToReply Service-Type = Framed-User,\
               Framed-Protocol = PPP,\
               Framed-Routing = None,\
               Framed-MTU = 1500,\
               Framed-Compression = Van-Jacobson-TCP-IP,\
           Idle-Timeout = 1800,\
           Session-Timeout = 43200,\
           Port-Limit = 1

</AuthBy>


<AuthLog SQL>

       DBSource     xxxxxxx
       DBUsername     xxxxxxx
       DBAuth         xxxxxxx
       Table        Accounting

SuccessQuery insert into Accounting values ('%H:%M:%S','%m/%d/%Y','Success','%u','%U','%c',%1,'%a')
FailureQuery insert into Accounting values ('%H:%M:%S','%m/%d/%Y','Failure(PAP-Auth)','%u','%U','%c',%1,'%a')
LogSuccess 1

</AuthLog>

</Handler>

::James Nelson

===
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.

Reply via email to