3GPP data in mysql radacct table

[liran kessel]

I have version 2.2.6

but it fails when trying to add Tmp-Integer64-1 (see attached).



 Module: Instantiating module "acct_unique" from file /etc/raddb/modules/acct_unique
  acct_unique {
  	key = "User-Name, Acct-Session-Id, NAS-IP-Address, NAS-Identifier, NAS-Port"
  }
 Module: Checking accounting {...} for more modules to load
 Module: Linked to module rlm_detail
 Module: Instantiating module "detail" from file /etc/raddb/modules/detail
  detail {
  	detailfile = "/var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d"
  	header = "%t"
  	detailperm = 384
  	dirperm = 493
  	locking = no
  	log_packet_header = no
  }
/etc/raddb/sites-enabled/default[404]: ERROR: Unknown vendor name in attribute name "Tmp-Integer64-1"
/etc/raddb/sites-enabled/default[378]: Errors parsing accounting section.

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: radius_log.txt
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20160523/1fd5723f/attachment-0001.txt>
-------------- next part --------------


we will upgrade to version 3?


> 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