3GPP data in mysql radacct table

liran kessel lirankessel at gmail.com
Fri May 13 11:25:08 CEST 2016


yes version 2.2.6 was installed.

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?

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? 
How would i configure the hex translation?

Thanks
 

> On 13 May 2016, at 12:15 PM, Matthew Newton <mcn4 at leicester.ac.uk> wrote:
> 
> On Fri, May 13, 2016 at 11:06:41AM +0300, liran kessel wrote:
>> Thanks for the help, however we don’t have  a mods-config directory with all its sub directories.
> 
> FreeRADIUS version 2?
> 
> Look in any of
> 
> raddb/modules/sql_log
> raddb/sql/*/*.conf
> 
> 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




More information about the Freeradius-Users mailing list