3GPP data in mysql radacct table

[Matthew Newton]

On Fri, May 13, 2016 at 12:25:08PM +0300, liran kessel wrote:
> I can see the schema.conf the create table of radacct, so I can
> just add the extra fields and recreate the table? and add the
> Location-info as an integer?

Yes

> regarding the sql_log this is the entry 
>         Start = "INSERT INTO ${acct_table} (AcctSessionId, UserName, \
>          NASIPAddress, FramedIPAddress, AcctStartTime, AcctStopTime, \
>          AcctSessionTime, AcctTerminateCause) VALUES                 \
>          ('%{Acct-Session-Id}', '%{User-Name}', '%{NAS-IP-Address}', \
>          '%{Framed-IP-Address}', '%S', '0', '0', '');”
> 
> so I would need to add the name of the fields to the insert statements based on their field names?
> for example 
> %{ 3GPP-Location-Info} 
> %{3GPP-IMSI-MCC-MNC}
> 
> correct? 

Yes, but...

> How would i configure the hex translation?

Do something like

  update request {
    Tmp-Integer-1 := "%{3GPP-Location-Info}"
  }

before calling sql, then write Tmp-Integer-1 to the database
rather than 3GPP-Location-Info.

Matthew


-- 
Matthew Newton, Ph.D. <mcn4 at 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 at le.ac.uk>