Acctstoptime same as acctstarttime
Hello, I'm using FreeRadius 2.1.12 and I gotta a database problem with the user connection registry. Can you help me? When the connection is registered, the acctstoptime field is filled with the same content from the acctstarttime field, the user doesn't loose connection but radius fills the field like it lost at the same time it started. However, when the user actually looses connection, the field gets updated to the right actual time. As of now, I can't update my FreeRadius since it's the one being used for the clients and it can't stop at any time then. Thank you in advance.
On Jan 31, 2018, at 3:44 PM, Yahn do Amaral Almeida Pinheiro <yahnaamaralp@gmail.com> wrote:
I'm using FreeRadius 2.1.12 and I gotta a database problem with the user connection registry. Can you help me?
You should upgrade to 2.2.10.
When the connection is registered, the acctstoptime field is filled with the same content from the acctstarttime field, the user doesn't loose connection but radius fills the field like it lost at the same time it started. However, when the user actually looses connection, the field gets updated to the right actual time.
FreeRADIUS doesn't invent accounting data. It receives accounting data from the NAS. It then stores that data in the DB. So if the data in the DB is wrong, it's because the NAS sends the wrong data. What you *can* do is to check: if ((Acct-Status-Type == Interim-Update) && Acct-Stop-Time) { update request { Acct-Stop-Time !* ANY } } Put that at the top of the "preacct" section, and it should help. You might need to edit it for v2... I haven't used that in years.
As of now, I can't update my FreeRadius since it's the one being used for the clients and it can't stop at any time then.
You should be able to build a new system, and then swap it over. Alan DeKok.
I understand. I'll check and test my NAS then. Thank you very much. 2018-01-31 19:39 GMT-02:00 Alan DeKok <aland@deployingradius.com>:
On Jan 31, 2018, at 3:44 PM, Yahn do Amaral Almeida Pinheiro < yahnaamaralp@gmail.com> wrote:
I'm using FreeRadius 2.1.12 and I gotta a database problem with the user connection registry. Can you help me?
You should upgrade to 2.2.10.
When the connection is registered, the acctstoptime field is filled with the same content from the acctstarttime field, the user doesn't loose connection but radius fills the field like it lost at the same time it started. However, when the user actually looses connection, the field gets updated to the right actual time.
FreeRADIUS doesn't invent accounting data. It receives accounting data from the NAS. It then stores that data in the DB.
So if the data in the DB is wrong, it's because the NAS sends the wrong data.
What you *can* do is to check:
if ((Acct-Status-Type == Interim-Update) && Acct-Stop-Time) { update request { Acct-Stop-Time !* ANY } }
Put that at the top of the "preacct" section, and it should help. You might need to edit it for v2... I haven't used that in years.
As of now, I can't update my FreeRadius since it's the one being used for the clients and it can't stop at any time then.
You should be able to build a new system, and then swap it over.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
participants (2)
-
Alan DeKok -
Yahn do Amaral Almeida Pinheiro