3GPP data in mysql radacct table

[liran kessel]

1 more question , how would I go about storing it as a hex string in the mysql DB?
then I can translate only the part I want using SQL.

Thanks

> On 23 May 2016, at 12:50 PM, Matthew Newton <mcn4 at leicester.ac.uk> wrote:
> 
> On Sun, May 22, 2016 at 11:22:46PM +0300, liran kessel wrote:
>> Here you go, but for some reason I don’t see the whole update command.
> 
> You missed all the detail from the top, so I don't know what
> version you're running, but tested and it works fine on latest
> 3.0.
> 
> You'll need to update to use Tmp-Integer64-1. The number is too
> big for 32 bits.
> 
> This works here:
> 
>        update request {
>                Tmp-Integer64-1 := &3GPP-Location-Info
>        }
> 
>        sql
> 
> which, using your supplied packet, results in the db containing:
> 
> sqlite> select test from radacct;
> 10402618446946336
> sqlite> 
> 
> 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