No Accounting records from only 1 NAS
Hi dear friends I have a FreeRADIUS Version 2.1.12 working fine!! I have several NAS devices working fine. Freeradius server records all their accounting record in mysql database, table radacct. It works!! But I have one NAS device that can authenticate its users, and it sends Accounting data, but the freeradius server is not recording that data in the mysql database. I know that accounting data is arriving to the server because the log. Example: Mon Apr 3 07:07:28 2017 Acct-Status-Type = Start User-Name = "0003AB94EF3F" Framed-IP-Address = 192.168.24.56 NAS-IP-Address = 192.168.50.2 Calling-Station-Id = "0003ab94ef3f" NAS-Identifier = "ApNextel" NAS-Port-Id = "WIFIGRATIS-NEXTEL" NAS-Port-Type = Wireless-802.11 NAS-Port = 3232248322 Called-Station-Id = "000456b94fc0" Framed-MTU = 1400 Acct-Session-Id = "00-04-56-B9-4F-C0-00-00-00-11-00-03-AB-94-EF-3F" Event-Timestamp = "Apr 3 2017 07:07:27 COT" Acct-Delay-Time = 0 Acct-Unique-Session-Id = "44582e4931b31778" Timestamp = 1491221248 Mon Apr 3 07:17:28 2017 Acct-Status-Type = Interim-Update User-Name = "0003AB94EF3F" Framed-IP-Address = 192.168.24.56 NAS-IP-Address = 192.168.50.2 Calling-Station-Id = "0003ab94ef3f" NAS-Identifier = "ApNextel" NAS-Port-Id = "WIFIGRATIS-NEXTEL" NAS-Port-Type = Wireless-802.11 NAS-Port = 3232248322 Called-Station-Id = "000456b94fc0" Framed-MTU = 1400 Acct-Session-Id = "00-04-56-B9-4F-C0-00-00-00-11-00-03-AB-94-EF-3F" Event-Timestamp = "Apr 3 2017 07:17:27 COT" Acct-Input-Packets = 1453 Acct-Output-Packets = 1461 Acct-Input-Octets = 309768 Acct-Output-Octets = 784758 Acct-Session-Time = 600 Acct-Delay-Time = 0 Acct-Unique-Session-Id = "44582e4931b31778" Timestamp = 1491221848 Looking in the mysql database, I can see all the record from all other devices, but not form this one. What can I chech? Regards Andrés --
On Apr 3, 2017, at 9:01 AM, Andrés Gómez <andres.gomez.ruiz@gmail.com> wrote:
I have a FreeRADIUS Version 2.1.12 working fine!! I have several NAS devices working fine. Freeradius server records all their accounting record in mysql database, table radacct. It works!!
But I have one NAS device that can authenticate its users, and it sends Accounting data, but the freeradius server is not recording that data in the mysql database. ... Looking in the mysql database, I can see all the record from all other devices, but not form this one.
What can I chech?
Run the server in debugging mode, as suggested in the FAQ, "man" page, web pages, and daily on this list. Alan DeKok.
Hi Alan. Thank you. Afgter debbugin I saw that the problem was that acctsessionID is too long. I changed the width of that slot to varchar(64) and all is working. Regards 2017-04-03 8:02 GMT-05:00 Alan DeKok <aland@deployingradius.com>:
On Apr 3, 2017, at 9:01 AM, Andrés Gómez <andres.gomez.ruiz@gmail.com> wrote:
I have a FreeRADIUS Version 2.1.12 working fine!! I have several NAS devices working fine. Freeradius server records all their accounting record in mysql database, table radacct. It works!!
But I have one NAS device that can authenticate its users, and it sends Accounting data, but the freeradius server is not recording that data in the mysql database. ... Looking in the mysql database, I can see all the record from all other devices, but not form this one.
What can I chech?
Run the server in debugging mode, as suggested in the FAQ, "man" page, web pages, and daily on this list.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
-- *C. Andrés Gómez R.* *Magister en Software Libre* *Esp. Gerencia Estratégica de Telecomunicaciones* http://about.me/andresgom/ Bogotá - Colombia Móvil: (+ 57) 3102733166
participants (2)
-
Alan DeKok -
Andrés Gómez