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@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@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> - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html