Re: Write 3GPP attributes accounting into mysql problem

15 Jan 2014

      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?

Re: Write 3GPP attributes accounting into mysql problem

Phil Mayers