Framed-IPv6-Prefix and Delegated-IPv6-Prefix + SQL
Hello, I have been searching how to add Framed and Delegated IPv6 accounting data into SQL and have come across this relatively old info: http://freeradius.1045715.n5.nabble.com/IPv6-Accounting-td4432174.html I am using RedHat/CentOS EL7 with the packaged freeradius-3.0.1 I have started modding queries.conf and have made some good progress: specific changes, I added columns in the SQL radacct table (and I altered the table to add the columns in question): column_list = "\ acctsessionid, acctuniqueid, username, \ realm, nasipaddress, nasportid, \ nasporttype, acctstarttime, acctupdatetime, \ acctstoptime, acctsessiontime, acctauthentic, \ connectinfo_start, connectinfo_stop, acctinputoctets, \ acctoutputoctets, calledstationid, callingstationid, \ acctterminatecause, servicetype, framedprotocol, \ framedipaddress, framedipv6address, framedipv6pool,\ framedipv6prefix, delegatedipv6prefix" and in the start { query, I added: '%{Framed-IPv6-Address}', '%{Framed-IPv6-Pool}', '%{Framed-IPv6-Prefix}', '%{Delegated-IPv6-Prefix}' )" When I look at the detail file, I see the info I am wishing to insert into the database, note the mask of /64 and /56 Tue Oct 21 17:30:04 2014 Acct-Session-Id = '0098EF19' Tunnel-Type:0 = L2TP Tunnel-Medium-Type:0 = IPv4 Tunnel-Server-Endpoint:0 = '192.168.204.210' Tunnel-Client-Endpoint:0 = '192.168.204.231' Tunnel-Assignment-Id:0 = 'foo' Tunnel-Client-Auth-Id:0 = 'foo' Tunnel-Server-Auth-Id:0 = 'pppoe' Acct-Tunnel-Connection = '26314987' Delegated-IPv6-Prefix = 2001:db8:a000::/56 Framed-Protocol = PPP Framed-Interface-Id = 5c73:a540:688f:37e2 Framed-IPv6-Prefix = 2001:db8:a000:ff::/64 Framed-IP-Address = 192.168.138.1 User-Name = 'pppoeuser' Acct-Authentic = RADIUS X-Ascend-Connect-Progress = LAN-Session-Up [...snip...] strangely, when I check what was logged in the SQL table however, I get for some reason /38 netmask for both pieces of information (apologies for the formatting...): MariaDB [radius]> select * from radacct where radacctid = '1494'; | 1494 | 009E2FDE | 7a22c13be9bcca21aaab7d7494ed1826 | pppoeuser | | | 192.168.128.24 | 2546 | Virtual | 2014-10-21 17:30:41 | 2014-10-21 17:30:41 | NULL | 0 | 0 | RADIUS | 2000000000 | | 0 | 111 | | lag-72:450 | | Framed-User | PPP | 72.10.138.1 | | | 2001:db8:a000:ff:0:0:0:0/38 | 2001:db8:a000:0:0:0:0:0/38 | why would the detail file have the correct /64 and /56 netmasks, yet the INSERT (which seems to explode the data into proper ipv6addr format with padded zeroes) would have this strange /38 netmask added? I feel I am close, any help would be much appreciated. Thanks, M.
On 21 Oct 2014, at 22:48, Martin Brault <martyb@creenet.com> wrote:
Hello,
I have been searching how to add Framed and Delegated IPv6 accounting data into SQL and have come across this relatively old info:
http://freeradius.1045715.n5.nabble.com/IPv6-Accounting-td4432174.html
I am using RedHat/CentOS EL7 with the packaged freeradius-3.0.1
Does this still occur with 3.0.4? -Arran Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
On 2014-10-21 23:26, Arran Cudbard-Bell wrote:
On 21 Oct 2014, at 22:48, Martin Brault <martyb@creenet.com> wrote:
Hello,
I have been searching how to add Framed and Delegated IPv6 accounting data into SQL and have come across this relatively old info:
http://freeradius.1045715.n5.nabble.com/IPv6-Accounting-td4432174.html
I am using RedHat/CentOS EL7 with the packaged freeradius-3.0.1
Does this still occur with 3.0.4?
Hello, Is this a known issue? I am using the CentOS/Redhat7 packages, I will try and compile from source to test it I suppose. Thanks, M.
Martin Brault wrote:
Is this a known issue? I am using the CentOS/Redhat7 packages, I will try and compile from source to test it I suppose.
You can get up to date packages for CentOS from: http://packages.networkradius.com/ :-)
On 2014-10-22 03:31, Enrique Sainz Baixauli wrote:
Martin Brault wrote:
Is this a known issue? I am using the CentOS/Redhat7 packages, I will try and compile from source to test it I suppose.
You can get up to date packages for CentOS from: http://packages.networkradius.com/ :-)
Hello, Sadly I am using RHEL7/CentOS7, and apparently there are none. I am going to rebuild the Fedora RPM or install from source. Has this bug been fixed or was it known before? Or is my process wrong in the first place? thanks, M.
There have been many many fixes since 3.0.1 If the bug still manifests in the latest release then it needs looking into. Chances are that its already been fixed alan -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
On 2014-10-22 12:24, Alan Buxey wrote:
There have been many many fixes since 3.0.1
If the bug still manifests in the latest release then it needs looking into. Chances are that its already been fixed
Hello, I rebuilt the 3.0.4 RPM from Fedora22 on the Centos7 box and it inserts the correct prefix+netmask in the SQL table. It doesn't explode it or pad it with zeroes either like before. Thanks for your help, M.
Thanks for the update, thanks for the feedback and thanks for going through the process :) alan
participants (4)
-
Alan Buxey -
Arran Cudbard-Bell -
Enrique Sainz Baixauli -
Martin Brault