problem with username renamed in radacct table

Hocine M hocine.maoucha at free.fr
Thu Jan 31 16:43:59 CET 2013


Le 31/01/2013 16:07, Alan DeKok a écrit :
> Hocine M wrote:
>> For some reasons i don't understand, somtimes when accounting in radacct
>> mysql table the username is renamed in "web-portal-ssid" where ssid is
>> the SSID Web-Portal based.
>    It's because the NAS is sending "web-portal-ssid" in the
> Accounting-Request.  Or, your local configuration is updating the
> User-Name to be "web-portal-ssid".
>
>    There are no other options.
>
>    Alan DeKok.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Thanks,

My local configuration does not update the User-Name.

I noticed in detail file, username changed appear only in stop and 
Interim-Update accounting packet, and nothing in start  accounting packet.
But in radacct table for the same username (renamed) the acctstarttime 
is filled.

Thu Jan 31 13:53:55 2013
     Acct-Status-Type = Interim-Update
     Acct-Multi-Session-Id = "SESS-4883-54b78e-636521-e703"
     Acct-Session-Id = "SESS-4883-54b78e-636521-e703"
     User-Name = "web-portal-Invites"
     Event-Timestamp = "Jan 31 2013 13:53:55 CET"
     Trapeze-VLAN-Name = "Invites"
     Calling-Station-Id = "9C-04-EB-85-F4-70"
     NAS-Port-Id = "AP84/1"
     Called-Station-Id = "00-0B-0E-D2-AB-44:Invites"
     NAS-Port = 57930
     Framed-IP-Address = 10.53.1.152
     Acct-Session-Time = 23
     Acct-Output-Octets = 196179
     Acct-Input-Octets = 111779
     Acct-Output-Packets = 761
     Acct-Input-Packets = 2370
     NAS-Port-Type = Wireless-802.11
     NAS-IP-Address = 192.168.58.5
     NAS-Identifier = "Trapeze"
     Acct-Delay-Time = 0
     Acct-Unique-Session-Id = "5d505c20bb72a584"
     Stripped-User-Name = "web-portal-Invites"
     Realm = "NULL"
     Timestamp = 1359636835

Thu Jan 31 13:53:55 2013
     Acct-Status-Type = Stop
     Acct-Multi-Session-Id = "SESS-4883-54b78e-636521-e703"
     Acct-Session-Id = "SESS-4883-54b78e-636521-e703"
     User-Name = "web-portal-L3Invites"
     Event-Timestamp = "Jan 31 2013 13:53:55 CET"
     Trapeze-VLAN-Name = "Invites"
     Calling-Station-Id = "9C-04-EB-85-F4-70"
     NAS-Port-Id = "AP84/1"
     Called-Station-Id = "00-0B-0E-D2-AB-44:L3Invites"
     NAS-Port = 57930
     Framed-IP-Address = 10.53.1.152
     Acct-Session-Time = 23
     Acct-Output-Octets = 196179
     Acct-Input-Octets = 111779
     Acct-Output-Packets = 761
     Acct-Input-Packets = 2370
     NAS-Port-Type = Wireless-802.11
     NAS-IP-Address = 192.168.58.5
     NAS-Identifier = "Trapeze"
     Acct-Delay-Time = 0
     Acct-Unique-Session-Id = "5d505c20bb72a584"
     Stripped-User-Name = "web-portal-L3Invites"
     Realm = "NULL"
     Timestamp = 1359636835

Is it possibe that the start accounting request is sent to another 
radius server?








More information about the Freeradius-Users mailing list