Write 3GPP attributes accounting into mysql problem

[Arran Cudbard-Bell]

On 15 Jan 2014, at 13:49, bit1 <bit1 at 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 at freeradius.org>
FreeRADIUS Development Team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 881 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140115/a8f616d4/attachment.pgp>