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} 

How would i configure the hex translation?


> 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