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@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@le.ac.uk>