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