Write 3GPP attributes accounting into mysql problem

bit1 bit1 at freemail.hu
Wed Jan 15 09:25:25 CET 2014


Hi All
If I simplify the dialup.conf sql insert in a following way?

accounting_start_query = "INSERT INTO ${acct_table1} (test,fullpacket) VALUES ('%{request:3GPP-IMSI}','%Z')"

The result is:

Wed Jan 15 09:13:59 2014 : Info: [sql]  expand: %{User-Name} -> testuser
Wed Jan 15 09:13:59 2014 : Info: [sql] sql_set_user escaped user --> 'testuser'
Wed Jan 15 09:13:59 2014 : Info: [sql]  expand: INSERT INTO radacct (test,fullpacket) VALUES ('%{request:3GPP-IMSI}','%Z') -> INSERT INTO radacct (test,fullpacket) VALUES ('','    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      3GPP-IMSI = "123123123123123"       Acct-Unique-Session-Id = "6ce7054b4a610197"     SQL-User-Name = "testuser" ')
Thanks in advance.
Regards
Dohány Tibor
mailto:bit1 at freemail.hu

Arran Cudbard-Bell <a.cudbardb at freeradius.org> írta:
>
>On 14 Jan 2014, at 09:18, bit1 <bit1 at freemail.hu> wrote:
>
>> Hi All.
>> Attached the full logfile. 
>> Thanks in advance.
>
>Query and debug output buffers are limited in 2.x.x, you might want to try 3.0.1 at least then we'd be able to see the whole query.
>
>-Arran
>
>Arran Cudbard-Bell <a.cudbardb at freeradius.org>
>FreeRADIUS Development Team
>
>FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
>
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


More information about the Freeradius-Users mailing list