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