Write 3GPP attributes accounting into mysql problem

bit1 bit1 at freemail.hu
Wed Jan 15 14:49:06 CET 2014


Hi 
Thanks Phil.

rad_recv: Accounting-Request packet from host 127.0.0.1 port 38530, id=126, length=153
        Acct-Status-Type = Start
        Calling-Station-Id = "12312312312"
        Framed-IP-Address = 10.0.0.1
        Acct-Session-Id = "d43363551081e4a8"
        NAS-IP-Address = 10.11.11.77
        Framed-Protocol = GPRS-PDP-Context
        Called-Station-Id = "test-gprs"
        NAS-Identifier = "test-gprs"
        User-Name = "testuser"
        NAS-Port-Type = Virtual
        Service-Type = Framed-User
        X3GPP-IMSI = "123123123123123"
        Cisco-AVPair = "bar"


Wed Jan 15 14:41:10 2014 : Info: [sql]  expand: INSERT INTO radacct (test1,test,fullpacket) VALUES ('%{request:X3GPP-IMSI}','%{Cisco-AVPair}','%Z') -> INSERT INTO radacct (test1,test,fullpacket) VALUES ('123123123123123','bar','        Acct-Status-Type = Start        Calling-Station-Id = "12312312312"  Framed-IP-Address = 10.0.0.1    Acct-Session-Id = "d43363551081e4a8"    NAS-IP-Address = 10.11.11.77    Framed-Protocol = GPRS-PDP-Context  Called-Station-Id = "test-gprs"         NAS-Identifier = "test-gprs"    User-Name = "testuser"  NAS-Port-Type = Virtual     Service-Type = Framed-User      X3GPP-IMSI = "123123123123123"  Cisco-AVPair = "bar"    Acct-Unique-Session-Id = "6ce7054b4a610197" SQL-User-Name = "testuser" ')

There is the modified X3GPP-IMSI. It can be a bug in the mod_sql xpand?
Regards
Dohány Tibor
mailto:bit1 at freemail.hu

Phil Mayers <p.mayers at imperial.ac.uk> írta:
>On 15/01/14 12:43, bit1 wrote:
>
>> There is the "bar". It seems works with Cisco-AVPair (as man unlang mentioned) but not for 3GPP-*.
>
>Man, weird.
>
>Could you check the dictionaries to ensure they aren't mangled in some 
>fashion? In particular dictionary.3gpp
>
>I wonder if it's because it starts with a digit? You could try renaming 
>the attribute in the dictionary e.g. stick an "X" in front of it, then 
>update your config/SQL queries.
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>


More information about the Freeradius-Users mailing list