(RADIATOR) AuthLog & Framed-IP-Address

[James Nelson]

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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.