3GPP data in mysql radacct table

[liran kessel]

I tried the change as you recommended in sql_log but it didn’t effect the servers configuration.

afterwards i changed the /etc/radact/sql/mysql/dialup.conf and this helped me get the info into the DB.

regarding your point on  configuring this update_request.
>  update request {
>    Tmp-Integer-1 := "%{3GPP-Location-Info}"
>  }

where would I do that? in the dialup.conf file? as part of the update command or a separate section?

Thanks


> On 13 May 2016, at 3:06 PM, Matthew Newton <mcn4 at leicester.ac.uk> wrote:
> 
> 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>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html