Write 3GPP attributes accounting into mysql problem
Hi Freeradius-Users May be some of you facing with this problem, but I haven't a proper solution yet. I have a freeradius 2.2.0 and mysql 5.5.28. I would like to write (and of course aggregate) accounting records into mysql db. I 'v tried to modify the dialup.conf to extract the 3GPP radius attributes as well as the standard attributes (appended extra fields, db schema modified as well). accounting_start_query = " \ INSERT INTO ${acct_table1} \ (acctsessionid, acctuniqueid, username, \ realm, nasipaddress, nasportid, \ nasporttype, acctstarttime, acctstoptime, \ acctsessiontime, acctauthentic, connectinfo_start, \ connectinfo_stop, acctinputoctets, acctoutputoctets, \ calledstationid, callingstationid, acctterminatecause, \ servicetype, framedprotocol, framedipaddress, \ acctstartdelay, acctstopdelay, xascendsessionsvrkey, test,fullpacket) \ VALUES \ ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', \ '%{SQL-User-Name}', \ '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', \ '%{NAS-Port-Type}', '%S', NULL, \ '0', '%{Acct-Authentic}', '%{Connect-Info}', \ '', '0', '0', \ '%{Called-Station-Id}', '%{Calling-Station-Id}', '', \ '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', \ '%{%{Acct-Delay-Time}:-0}', '0', '0','%{request:3GPP-IMSI}','%Z')" But the '%{request:3GPP-IMSI}' does not work, it is empty, however the '%Z' countains the full accounting packet. It seems the 3GPP-* runtime variable does not get value or may be the format is wrong. I'v made a not so elegant solution with mysql-udf-preg and regexped the necessary attribs from full packet , but i think it could be too slow with more attribs/inserts. Do you have any idea how to solve this issue? Dohány Tibor mailto:bit1@freemail.hu
bit1 wrote:
But the '%{request:3GPP-IMSI}' does not work, it is empty, however the '%Z' countains the full accounting packet. It seems the 3GPP-* runtime variable does not get value or may be the format is wrong.
(a) run the server in debugging mode to see what's going on (b) see the FAQ about accounting data. This isn't magic. If there's no 3GPP-IMSI in the request, then the server can't insert it into the database.
I'v made a not so elegant solution with mysql-udf-preg and regexped the necessary attribs from full packet , but i think it could be too slow with more attribs/inserts. Do you have any idea how to solve this issue?
You've been very careful to post as little information as possible. i.e. not the debug output as suggested in the FAQ, "man" page, web pages, Wiki, and daily on this list. So... no. I have no idea how to solve this issue. Alan DeKok.
Hi Sorry for the less info. This is the test method. #cat /usr/local/etc/raddb/sql/mysql/dialup.conf | grep -e request -e test -e fullpacket acctstartdelay, xascendsessionsvrkey, test,fullpacket) \ '0','0','%{request:3GPP-IMSI}','%Z')" acctstartdelay, acctstopdelay, xascendsessionsvrkey, test,fullpacket) \ '%{%{Acct-Delay-Time}:-0}', '0', '0','%{request:3GPP-IMSI}','%Z')" # # # # # #cat /tmp/auth.packet 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" #radclient -f /tmp/auth.packet 127.0.0.1:2813 acct testing123 Received response ID 114, code 5, length = 20 #mysql -e "select * from radacct\G" radius *************************** 1. row *************************** radacctid: 228 acctsessionid: d43363551081e4a8 acctuniqueid: 6ce7054b4a610197 username: testuser groupname: realm: nasipaddress: 10.11.11.77 nasportid: nasporttype: Virtual acctstarttime: 2014-01-13 16:34:14 acctstoptime: NULL acctsessiontime: 0 acctauthentic: connectinfo_start: connectinfo_stop: acctinputoctets: 0 acctoutputoctets: 0 calledstationid: test-gprs callingstationid: 12312312312 acctterminatecause: servicetype: Framed-User framedprotocol: GPRS-PDP-Context framedipaddress: 10.0.0.1 acctstartdelay: 0 acctstopdelay: 0 xascendsessionsvrkey: 0 test: fullpacket: 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" # Here is the debug output. Mon Jan 13 16:34:14 2014 : Info: # Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default Mon Jan 13 16:34:14 2014 : Info: +- entering group preacct {...} Mon Jan 13 16:34:14 2014 : Info: ++[preprocess] returns ok Mon Jan 13 16:34:14 2014 : Info: [acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent Mon Jan 13 16:34:14 2014 : Info: [acct_unique] Hashing ',NAS-Identifier = "test-gprs",NAS-IP-Address = 10.11.11.77,Acct-Session-Id = "d43363551081e4a8",User-Name = "testuser"' Mon Jan 13 16:34:14 2014 : Info: [acct_unique] Acct-Unique-Session-ID = "6ce7054b4a610197". Mon Jan 13 16:34:14 2014 : Info: ++[acct_unique] returns ok Mon Jan 13 16:34:14 2014 : Info: [suffix] No '@' in User-Name = "testuser", looking up realm NULL Mon Jan 13 16:34:14 2014 : Info: [suffix] No such realm "NULL" Mon Jan 13 16:34:14 2014 : Info: ++[suffix] returns noop Mon Jan 13 16:34:14 2014 : Info: # Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default Mon Jan 13 16:34:14 2014 : Info: +- entering group accounting {...} Mon Jan 13 16:34:14 2014 : Info: [detail] expand: %{Packet-Src-IP-Address} -> 127.0.0.1 Mon Jan 13 16:34:14 2014 : Info: [detail] expand: /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d -> /var/log/radacct/127.0.0.1/detail-20140113 Mon Jan 13 16:34:14 2014 : Info: [detail] /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radacct/127.0.0.1/detail-20140113 Mon Jan 13 16:34:14 2014 : Info: [detail] expand: %t -> Mon Jan 13 16:34:14 2014 Mon Jan 13 16:34:14 2014 : Info: ++[detail] returns ok Mon Jan 13 16:34:14 2014 : Info: [sql] expand: %{User-Name} -> testuser Mon Jan 13 16:34:14 2014 : Info: [sql] sql_set_user escaped user --> 'testuser' Mon Jan 13 16:34:14 2014 : Info: [sql] expand: %{Acct-Delay-Time} -> Mon Jan 13 16:34:14 2014 : Info: [sql] ... expanding second conditional Mon Jan 13 16:34:14 2014 : Info: [sql] expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey, test,fullpacket) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP Mon Jan 13 16:34:14 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 3 Mon Jan 13 16:34:14 2014 : Debug: rlm_sql (sql): Released sql socket id: 3 Mon Jan 13 16:34:14 2014 : Info: ++[sql] returns ok Mon Jan 13 16:34:14 2014 : Info: ++[exec] returns noop Mon Jan 13 16:34:14 2014 : Info: [attr_filter.accounting_response] expand: %{User-Name} -> testuser Mon Jan 13 16:34:14 2014 : Debug: attr_filter: Matched entry DEFAULT at line 12 Mon Jan 13 16:34:14 2014 : Info: ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 114 to 127.0.0.1 port 14127 Mon Jan 13 16:34:14 2014 : Info: Finished request 0. Mon Jan 13 16:34:14 2014 : Info: Cleaning up request 0 ID 114 with timestamp +183 Mon Jan 13 16:34:14 2014 : Debug: Going to the next request Mon Jan 13 16:34:14 2014 : Info: Ready to process requests. Unfortunately the end of sql insert slided out. Best Regards Dohány Tibor mailto:bit1@freemail.hu Alan DeKok <aland@deployingradius.com> írta:
bit1 wrote:
But the '%{request:3GPP-IMSI}' does not work, it is empty, however the '%Z' countains the full accounting packet. It seems the 3GPP-* runtime variable does not get value or may be the format is wrong.
(a) run the server in debugging mode to see what's going on
(b) see the FAQ about accounting data.
This isn't magic. If there's no 3GPP-IMSI in the request, then the server can't insert it into the database.
I'v made a not so elegant solution with mysql-udf-preg and regexped the necessary attribs from full packet , but i think it could be too slow with more attribs/inserts. Do you have any idea how to solve this issue?
You've been very careful to post as little information as possible. i.e. not the debug output as suggested in the FAQ, "man" page, web pages, Wiki, and daily on this list.
So... no. I have no idea how to solve this issue.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
bit1 wrote:
Hi Sorry for the less info.
This is the test method.
I didn't ask for that.
#cat /tmp/auth.packet
I didn't ask for that.
#mysql -e "select * from radacct\G" radius
I didn't ask for that.
Here is the debug output. Mon Jan 13 16:34:14 2014 : Info: # Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default
No. You've edited it, and remove most of the useful information. Alan DeKok.
Hi Alan It seems you dont belive me. No I havent edited. This is an untouched input from console. # #radclient -f /tmp/auth.packet 127.0.0.1:2813 acct testing123 rad_recv: Accounting-Request packet from host 127.0.0.1 port 14803, id=236, length=142 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" Mon Jan 13 20:45:52 2014 : Info: # Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default Mon Jan 13 20:45:52 2014 : Info: +- entering group preacct {...} Mon Jan 13 20:45:52 2014 : Info: ++[preprocess] returns ok Mon Jan 13 20:45:52 2014 : Info: [acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent Mon Jan 13 20:45:52 2014 : Info: [acct_unique] Hashing ',NAS-Identifier = "test-gprs",NAS-IP-Address = 10.11.11.77,Acct-Session-Id = "d43363551081e4a8",User-Name = "testuser"' Mon Jan 13 20:45:52 2014 : Info: [acct_unique] Acct-Unique-Session-ID = "6ce7054b4a610197". Mon Jan 13 20:45:52 2014 : Info: ++[acct_unique] returns ok Mon Jan 13 20:45:52 2014 : Info: [suffix] No '@' in User-Name = "testuser", looking up realm NULL Mon Jan 13 20:45:52 2014 : Info: [suffix] No such realm "NULL" Mon Jan 13 20:45:52 2014 : Info: ++[suffix] returns noop Mon Jan 13 20:45:52 2014 : Info: # Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default Mon Jan 13 20:45:52 2014 : Info: +- entering group accounting {...} Mon Jan 13 20:45:52 2014 : Info: [detail] expand: %{Packet-Src-IP-Address} -> 127.0.0.1 Mon Jan 13 20:45:52 2014 : Info: [detail] expand: /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d -> /var/log/radacct/127.0.0.1/detail-20140113 Mon Jan 13 20:45:52 2014 : Info: [detail] /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radacct/127.0.0.1/detail-20140113 Mon Jan 13 20:45:52 2014 : Info: [detail] expand: %t -> Mon Jan 13 20:45:52 2014 Mon Jan 13 20:45:52 2014 : Info: ++[detail] returns ok Mon Jan 13 20:45:52 2014 : Info: [sql] expand: %{User-Name} -> testuser Mon Jan 13 20:45:52 2014 : Info: [sql] sql_set_user escaped user --> 'testuser' Mon Jan 13 20:45:52 2014 : Info: [sql] expand: %{Acct-Delay-Time} -> Mon Jan 13 20:45:52 2014 : Info: [sql] ... expanding second conditional Mon Jan 13 20:45:52 2014 : Info: [sql] expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey, test,fullpacket) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP Mon Jan 13 20:45:52 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 3 Mon Jan 13 20:45:52 2014 : Debug: rlm_sql (sql): Released sql socket id: 3 Mon Jan 13 20:45:52 2014 : Info: ++[sql] returns ok Mon Jan 13 20:45:52 2014 : Info: ++[exec] returns noop Mon Jan 13 20:45:52 2014 : Info: [attr_filter.accounting_response] expand: %{User-Name} -> testuser Mon Jan 13 20:45:52 2014 : Debug: attr_filter: Matched entry DEFAULT at line 12 Mon Jan 13 20:45:52 2014 : Info: ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 236 to 127.0.0.1 port 14803 Mon Jan 13 20:45:52 2014 : Info: Finished request 0. Received response ID 236, code 5, length = 20 Mon Jan 13 20:45:52 2014 : Info: Cleaning up request 0 ID 236 with timestamp +8 Mon Jan 13 20:45:52 2014 : Debug: Going to the next request Mon Jan 13 20:45:52 2014 : Info: Ready to process requests. # # I can attach the whole console log from the init script (with unprintable characters as well) if it helps. Regards Dohány Tibor mailto:bit1@freemail.hu Alan DeKok <aland@deployingradius.com> írta:
bit1 wrote:
Hi Sorry for the less info.
This is the test method.
I didn't ask for that.
#cat /tmp/auth.packet
I didn't ask for that.
#mysql -e "select * from radacct\G" radius
I didn't ask for that.
Here is the debug output. Mon Jan 13 16:34:14 2014 : Info: # Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default
No. You've edited it, and remove most of the useful information.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi, Alan wrote:
No. You've edited it, and remove most of the useful information.
On Mon, Jan 13, 2014 at 08:57:51PM +0100, bit1 wrote:
Hi Alan It seems you dont belive me. No I havent edited. This is an untouched input from console.
The debug output should start something like radiusd: FreeRADIUS Version 3.0.1 (git #ca55a63), for host x86_64-unknown-linux-gnu, built on Jan 13 2014 at 20:37:29 Copyright (C) 1999-2014 The FreeRADIUS server project and contributors There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License For more information about these matters, see the file named COPYRIGHT Starting - reading configuration files ... including dictionary file raddb/dictionary including configuration file raddb/debug.conf including configuration file raddb/radiusd.conf ... Not including it all, right from the top, usually means you're missing something that's important, or useful to help you. Cheers, Matthew
# #radclient -f /tmp/auth.packet 127.0.0.1:2813 acct testing123 rad_recv: Accounting-Request packet from host 127.0.0.1 port 14803, id=236, length=142 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" Mon Jan 13 20:45:52 2014 : Info: # Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default Mon Jan 13 20:45:52 2014 : Info: +- entering group preacct {...} Mon Jan 13 20:45:52 2014 : Info: ++[preprocess] returns ok Mon Jan 13 20:45:52 2014 : Info: [acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent Mon Jan 13 20:45:52 2014 : Info: [acct_unique] Hashing ',NAS-Identifier = "test-gprs",NAS-IP-Address = 10.11.11.77,Acct-Session-Id = "d43363551081e4a8",User-Name = "testuser"' Mon Jan 13 20:45:52 2014 : Info: [acct_unique] Acct-Unique-Session-ID = "6ce7054b4a610197". Mon Jan 13 20:45:52 2014 : Info: ++[acct_unique] returns ok Mon Jan 13 20:45:52 2014 : Info: [suffix] No '@' in User-Name = "testuser", looking up realm NULL Mon Jan 13 20:45:52 2014 : Info: [suffix] No such realm "NULL" Mon Jan 13 20:45:52 2014 : Info: ++[suffix] returns noop Mon Jan 13 20:45:52 2014 : Info: # Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default Mon Jan 13 20:45:52 2014 : Info: +- entering group accounting {...} Mon Jan 13 20:45:52 2014 : Info: [detail] expand: %{Packet-Src-IP-Address} -> 127.0.0.1 Mon Jan 13 20:45:52 2014 : Info: [detail] expand: /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d -> /var/log/radacct/127.0.0.1/detail-20140113 Mon Jan 13 20:45:52 2014 : Info: [detail] /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radacct/127.0.0.1/detail-20140113 Mon Jan 13 20:45:52 2014 : Info: [detail] expand: %t -> Mon Jan 13 20:45:52 2014 Mon Jan 13 20:45:52 2014 : Info: ++[detail] returns ok Mon Jan 13 20:45:52 2014 : Info: [sql] expand: %{User-Name} -> testuser Mon Jan 13 20:45:52 2014 : Info: [sql] sql_set_user escaped user --> 'testuser' Mon Jan 13 20:45:52 2014 : Info: [sql] expand: %{Acct-Delay-Time} -> Mon Jan 13 20:45:52 2014 : Info: [sql] ... expanding second conditional Mon Jan 13 20:45:52 2014 : Info: [sql] expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey, test,fullpacket) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP Mon Jan 13 20:45:52 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 3 Mon Jan 13 20:45:52 2014 : Debug: rlm_sql (sql): Released sql socket id: 3 Mon Jan 13 20:45:52 2014 : Info: ++[sql] returns ok Mon Jan 13 20:45:52 2014 : Info: ++[exec] returns noop Mon Jan 13 20:45:52 2014 : Info: [attr_filter.accounting_response] expand: %{User-Name} -> testuser Mon Jan 13 20:45:52 2014 : Debug: attr_filter: Matched entry DEFAULT at line 12 Mon Jan 13 20:45:52 2014 : Info: ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 236 to 127.0.0.1 port 14803 Mon Jan 13 20:45:52 2014 : Info: Finished request 0. Received response ID 236, code 5, length = 20 Mon Jan 13 20:45:52 2014 : Info: Cleaning up request 0 ID 236 with timestamp +8 Mon Jan 13 20:45:52 2014 : Debug: Going to the next request Mon Jan 13 20:45:52 2014 : Info: Ready to process requests. # #
-- Matthew Newton, Ph.D. <mcn4@le.ac.uk> Systems Specialist, Infrastructure Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom
Hi All. Attached the full logfile. Thanks in advance. Regards Dohány Tibor mailto:bit1@freemail.hu Matthew Newton <mcn4@leicester.ac.uk> írta:
Hi,
Alan wrote:
No. You've edited it, and remove most of the useful information.
On Mon, Jan 13, 2014 at 08:57:51PM +0100, bit1 wrote:
Hi Alan It seems you dont belive me. No I havent edited. This is an untouched input from console.
The debug output should start something like
radiusd: FreeRADIUS Version 3.0.1 (git #ca55a63), for host x86_64-unknown-linux-gnu, built on Jan 13 2014 at 20:37:29 Copyright (C) 1999-2014 The FreeRADIUS server project and contributors There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License For more information about these matters, see the file named COPYRIGHT Starting - reading configuration files ... including dictionary file raddb/dictionary including configuration file raddb/debug.conf including configuration file raddb/radiusd.conf ...
Not including it all, right from the top, usually means you're missing something that's important, or useful to help you.
Cheers,
Matthew
# #radclient -f /tmp/auth.packet 127.0.0.1:2813 acct testing123 rad_recv: Accounting-Request packet from host 127.0.0.1 port 14803, id=236, length=142 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" Mon Jan 13 20:45:52 2014 : Info: # Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default Mon Jan 13 20:45:52 2014 : Info: +- entering group preacct {...} Mon Jan 13 20:45:52 2014 : Info: ++[preprocess] returns ok Mon Jan 13 20:45:52 2014 : Info: [acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent Mon Jan 13 20:45:52 2014 : Info: [acct_unique] Hashing ',NAS-Identifier = "test-gprs",NAS-IP-Address = 10.11.11.77,Acct-Session-Id = "d43363551081e4a8",User-Name = "testuser"' Mon Jan 13 20:45:52 2014 : Info: [acct_unique] Acct-Unique-Session-ID = "6ce7054b4a610197". Mon Jan 13 20:45:52 2014 : Info: ++[acct_unique] returns ok Mon Jan 13 20:45:52 2014 : Info: [suffix] No '@' in User-Name = "testuser", looking up realm NULL Mon Jan 13 20:45:52 2014 : Info: [suffix] No such realm "NULL" Mon Jan 13 20:45:52 2014 : Info: ++[suffix] returns noop Mon Jan 13 20:45:52 2014 : Info: # Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default Mon Jan 13 20:45:52 2014 : Info: +- entering group accounting {...} Mon Jan 13 20:45:52 2014 : Info: [detail] expand: %{Packet-Src-IP-Address} -> 127.0.0.1 Mon Jan 13 20:45:52 2014 : Info: [detail] expand: /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d -> /var/log/radacct/127.0.0.1/detail-20140113 Mon Jan 13 20:45:52 2014 : Info: [detail] /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radacct/127.0.0.1/detail-20140113 Mon Jan 13 20:45:52 2014 : Info: [detail] expand: %t -> Mon Jan 13 20:45:52 2014 Mon Jan 13 20:45:52 2014 : Info: ++[detail] returns ok Mon Jan 13 20:45:52 2014 : Info: [sql] expand: %{User-Name} -> testuser Mon Jan 13 20:45:52 2014 : Info: [sql] sql_set_user escaped user --> 'testuser' Mon Jan 13 20:45:52 2014 : Info: [sql] expand: %{Acct-Delay-Time} -> Mon Jan 13 20:45:52 2014 : Info: [sql] ... expanding second conditional Mon Jan 13 20:45:52 2014 : Info: [sql] expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey, test,fullpacket) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '! ', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP Mon Jan 13 20:45:52 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 3 Mon Jan 13 20:45:52 2014 : Debug: rlm_sql (sql): Released sql socket id: 3 Mon Jan 13 20:45:52 2014 : Info: ++[sql] returns ok Mon Jan 13 20:45:52 2014 : Info: ++[exec] returns noop Mon Jan 13 20:45:52 2014 : Info: [attr_filter.accounting_response] expand: %{User-Name} -> testuser Mon Jan 13 20:45:52 2014 : Debug: attr_filter: Matched entry DEFAULT at line 12 Mon Jan 13 20:45:52 2014 : Info: ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 236 to 127.0.0.1 port 14803 Mon Jan 13 20:45:52 2014 : Info: Finished request 0. Received response ID 236, code 5, length = 20 Mon Jan 13 20:45:52 2014 : Info: Cleaning up request 0 ID 236 with timestamp +8 Mon Jan 13 20:45:52 2014 : Debug: Going to the next request Mon Jan 13 20:45:52 2014 : Info: Ready to process requests. # #
-- Matthew Newton, Ph.D. <mcn4@le.ac.uk>
Systems Specialist, Infrastructure Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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
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
Add the following to authorize {}, post the debug output: authorize { update request { 3GPP-IMSI := 123123123123123 } update request { Tmp-String-0 := "%{request:3GPP-IMSI}" } } Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
Thanks Arran. Here it is (the prolog attached if needed): rad_recv: Accounting-Request packet from host 127.0.0.1 port 44001, id=5, length=142 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" Wed Jan 15 12:29:40 2014 : Info: # Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default Wed Jan 15 12:29:40 2014 : Info: +- entering group preacct {...} Wed Jan 15 12:29:40 2014 : Info: ++[preprocess] returns ok Wed Jan 15 12:29:40 2014 : Info: [acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent Wed Jan 15 12:29:40 2014 : Info: [acct_unique] Hashing ',NAS-Identifier = "test-gprs",NAS-IP-Address = 10.11.11.77,Acct-Session-Id = "d43363551081e4a8",User-Name = "testuser"' Wed Jan 15 12:29:40 2014 : Info: [acct_unique] Acct-Unique-Session-ID = "6ce7054b4a610197". Wed Jan 15 12:29:40 2014 : Info: ++[acct_unique] returns ok Wed Jan 15 12:29:40 2014 : Info: [suffix] No '@' in User-Name = "testuser", looking up realm NULL Wed Jan 15 12:29:40 2014 : Info: [suffix] No such realm "NULL" Wed Jan 15 12:29:40 2014 : Info: ++[suffix] returns noop Wed Jan 15 12:29:40 2014 : Info: # Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default Wed Jan 15 12:29:40 2014 : Info: +- entering group accounting {...} Wed Jan 15 12:29:40 2014 : Info: [detail] expand: %{Packet-Src-IP-Address} -> 127.0.0.1 Wed Jan 15 12:29:40 2014 : Info: [detail] expand: /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d -> /var/log/radacct/127.0.0.1/detail-20140115 Wed Jan 15 12:29:40 2014 : Info: [detail] /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radacct/127.0.0.1/detail-20140115 Wed Jan 15 12:29:40 2014 : Info: [detail] expand: %t -> Wed Jan 15 12:29:40 2014 Wed Jan 15 12:29:40 2014 : Info: ++[detail] returns ok Wed Jan 15 12:29:40 2014 : Info: [sql] expand: %{User-Name} -> testuser Wed Jan 15 12:29:40 2014 : Info: [sql] sql_set_user escaped user --> 'testuser' Wed Jan 15 12:29:40 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" ') Wed Jan 15 12:29:40 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 3 Wed Jan 15 12:29:40 2014 : Debug: rlm_sql (sql): Released sql socket id: 3 Wed Jan 15 12:29:40 2014 : Info: ++[sql] returns ok Wed Jan 15 12:29:40 2014 : Info: ++[exec] returns noop Wed Jan 15 12:29:40 2014 : Info: [attr_filter.accounting_response] expand: %{User-Name} -> testuser Wed Jan 15 12:29:40 2014 : Debug: attr_filter: Matched entry DEFAULT at line 12 Wed Jan 15 12:29:40 2014 : Info: ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 5 to 127.0.0.1 port 44001 Wed Jan 15 12:29:40 2014 : Info: Finished request 0. Wed Jan 15 12:29:40 2014 : Info: Cleaning up request 0 ID 5 with timestamp +165 Wed Jan 15 12:29:40 2014 : Debug: Going to the next request Wed Jan 15 12:29:40 2014 : Info: Ready to process requests. Regards Dohány Tibor mailto:bit1@freemail.hu Arran Cudbard-Bell <a.cudbardb@freeradius.org> írta:
Add the following to authorize {}, post the debug output:
authorize { update request { 3GPP-IMSI := 123123123123123 }
update request { Tmp-String-0 := "%{request:3GPP-IMSI}" } }
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
On 15/01/14 11:36, bit1 wrote:
Wed Jan 15 12:29:40 2014 : Info: [sql] expand: INSERT INTO radacct (test,fullpacket) VALUES ('%{request:3GPP-IMSI}','%Z') -> INSERT INTO radacct (test,fullpacket) VALUES ('',' ... 3GPP-IMSI = "123123123123123" ...)
Well THAT is extremely weird. I wonder if it's a more general problem with all VSAs, as opposed to something specific to 3GPP-* Could you try this: 1. Set the SQL query to: INSERT INTO radacct (test,fullpacket) VALUES ( '%{request:3GPP-IMSI}','%{Cisco-AVPair}','%Z') 2. Put the following in your config: accounting { ... update request { Cisco-AVPair += "foo" } sql ... } 3. Run a debug, and see if the Cisco-AVPair VSA is affected as well. Possibly there's a bug in the SQL xlat for VSAs?
Hi Thanks Phil. I'v edited dialup.conf to: accounting_start_query = "INSERT INTO ${acct_table1} (test1,test,fullpacket) VALUES ('%{request:3GPP-IMSI}','%{Cisco-AVPair}','%Z')" Inserted into accounting {} and there is a foo: Wed Jan 15 13:24:31 2014 : Info: [sql] expand: %{User-Name} -> testuser Wed Jan 15 13:24:31 2014 : Info: [sql] sql_set_user escaped user --> 'testuser' Wed Jan 15 13:24:31 2014 : Info: [sql] expand: INSERT INTO radacct (test1,test,fullpacket) VALUES ('%{request:3GPP-IMSI}','%{Cisco-AVPair}','%Z') -> INSERT INTO radacct (test1,test,fullpacket) VALUES ('','foo',' 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" Cisco-AVPair = "foo" SQL-User-Name = "testuser" ') Wed Jan 15 13:24:31 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 3 Wed Jan 15 13:24:31 2014 : Debug: rlm_sql (sql): Released sql socket id: 3 After then cleared the accounting {} and inserted Cisco-AVPair = "bar" into the radius acct packet: Wed Jan 15 13:31:24 2014 : Info: [sql] expand: INSERT INTO radacct (test1,test,fullpacket) VALUES ('%{request:3GPP-IMSI}','%{Cisco-AVPair}','%Z') -> INSERT INTO radacct (test1,test,fullpacket) VALUES ('','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 3GPP-IMSI = "123123123123123" Cisco-AVPair = "bar" Acct-Unique-Session-Id = "6ce7054b4a610197" SQL-User-Name = "testuser" ') There is the "bar". It seems works with Cisco-AVPair (as man unlang mentioned) but not for 3GPP-*. Regards Dohány Tibor mailto:bit1@freemail.hu Phil Mayers <p.mayers@imperial.ac.uk> írta:
On 15/01/14 11:36, bit1 wrote:
Wed Jan 15 12:29:40 2014 : Info: [sql] expand: INSERT INTO radacct (test,fullpacket) VALUES ('%{request:3GPP-IMSI}','%Z') -> INSERT INTO radacct (test,fullpacket) VALUES ('',' ... 3GPP-IMSI = "123123123123123" ...)
Well THAT is extremely weird.
I wonder if it's a more general problem with all VSAs, as opposed to something specific to 3GPP-*
Could you try this:
1. Set the SQL query to:
INSERT INTO radacct (test,fullpacket) VALUES ( '%{request:3GPP-IMSI}','%{Cisco-AVPair}','%Z')
2. Put the following in your config:
accounting { ... update request { Cisco-AVPair += "foo" } sql ... }
3. Run a debug, and see if the Cisco-AVPair VSA is affected as well. Possibly there's a bug in the SQL xlat for VSAs? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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.
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@freemail.hu Phil Mayers <p.mayers@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
On 15 Jan 2014, at 13:49, bit1 <bit1@freemail.hu> wrote:
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?
Oh, yeah, that's right. Digits bad. Use %{request: 3GPP-IMSI}. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
Hi All Thanks for all of your help. Upgraded it to 2.2.3 and it works as expected. Best regards Dohány Tibor mailto:bit1@freemail.hu Phil Mayers <p.mayers@imperial.ac.uk> írta:
On 15/01/14 13:49, bit1 wrote:
There is the modified X3GPP-IMSI. It can be a bug in the mod_sql xpand?
Of course Alan is right - this is a known issue in 2.2.0. 2.2.3 should work correctly. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Phil Mayers wrote:
There is the "bar". It seems works with Cisco-AVPair (as man unlang mentioned) but not for 3GPP-*.
Man, weird. ... 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.
It's a bug in an older version of the server. Alan DeKok.
On 15/01/14 14:20, Alan DeKok wrote:
Phil Mayers wrote:
There is the "bar". It seems works with Cisco-AVPair (as man unlang mentioned) but not for 3GPP-*.
Man, weird. ... 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.
It's a bug in an older version of the server.
Ah yes, that old thing (the %{0} regexp group confusion) Sorry, I should have spotted that but didn't realise OP was still on 2.2.0 - I thought he'd upgraded to 3.x since we were now seeing all the queries, but I now see my mistake.
On Wed, Jan 15, 2014 at 01:10:48PM +0000, Phil Mayers wrote:
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-*.
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.
Rings a bell. I'm sure this came up over the last year sometime. A digit after : in an xlat causes it to bomb out (think Tunnel-Private-Group-Id:0) Broken in 2.2.0: https://github.com/FreeRADIUS/freeradius-server/blob/release_2_2_0/src/main/... I think it got fixed before 2.2.3: https://github.com/FreeRADIUS/freeradius-server/blob/release_2_2_3/src/main/... Try upgrading and see if it works. Matthew -- Matthew Newton, Ph.D. <mcn4@le.ac.uk> Systems Specialist, Infrastructure Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom For IT help contact helpdesk extn. 2253, <ithelp@le.ac.uk>
participants (5)
-
Alan DeKok -
Arran Cudbard-Bell -
bit1 -
Matthew Newton -
Phil Mayers