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@freemail.hu Arran Cudbard-Bell <a.cudbardb@freeradius.org> írta:
On 14 Jan 2014, at 09:18, bit1 <bit1@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@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