warning and ignore radius log messages
Hi Too many the following logs started to come from our radius servers (version 3.0.20). db is external and PostgreSql-12. What does this mean? Is it database problem or anything else? What can we do? There is no auth. and acct. problem on the FR server observed. WARNING: Module rlm_sql became unblocked Ignoring duplicate packet from client 34Acibh01 port 1812 - ID: 129 due to unfinished request in component session module sql Regards -- Can Paçacı pacaci@servisnet.com.tr Servisnet A.Ş. Tel: 90 216 9999677 90 530 5450952
On 29/04/2022 09:18, Can Paçacı wrote:
Too many the following logs started to come from our radius servers (version 3.0.20). db is external and PostgreSql-12. What does this mean? Is it database problem or anything else? What can we do? There is no auth. and acct. problem on the FR server observed.
WARNING: Module rlm_sql became unblocked
Ignoring duplicate packet from client 34Acibh01 port 1812 - ID: 129 due to unfinished request in component session module sql
The database is responding too slowly. The NAS doesn't get a response in time so sends a duplicate request, which FreeRADIUS ignores because it is already waiting for the database to respond on the first request. You need to fix the database. -- Matthew
Hi again, How can we find where there are a corruption or misconfiguration in the database? Could you please help a bit for that. According to customer needs and integrations, the changes we made in the radius database are to add some tables and add columns to some tables and also created some indexes. And also it keeps a single record for each session then it was updating this in incoming messages about the session. But we changed it to open a log for every incoming message. Regards On 4/29/22 12:03, Matthew Newton wrote:
On 29/04/2022 09:18, Can Paçacı wrote:
Too many the following logs started to come from our radius servers (version 3.0.20). db is external and PostgreSql-12. What does this mean? Is it database problem or anything else? What can we do? There is no auth. and acct. problem on the FR server observed.
WARNING: Module rlm_sql became unblocked
Ignoring duplicate packet from client 34Acibh01 port 1812 - ID: 129 due to unfinished request in component session module sql
The database is responding too slowly. The NAS doesn't get a response in time so sends a duplicate request, which FreeRADIUS ignores because it is already waiting for the database to respond on the first request.
You need to fix the database.
-- Can Paçacı pacaci@servisnet.com.tr Servisnet A.Ş. Tel: 90 216 9999677 90 530 5450952
On Apr 29, 2022, at 10:30 AM, Can Paçacı <pacaci@servisnet.com.tr> wrote:
How can we find where there are a corruption or misconfiguration in the database? Could you please help a bit for that.
It's not corruption. The database is slow.
According to customer needs and integrations, the changes we made in the radius database are to add some tables and add columns to some tables and also created some indexes. And also it keeps a single record for each session then it was updating this in incoming messages about the session. But we changed it to open a log for every incoming message.
The default configuration works, and is fast. If you make changes, then you have to understand what the impact of those changes are. If you add too many indexes, then the database will get slow. On the other hand, if you have 100 million rows and no indexes, then the database will also be slow. You have to configure the queries and database to do the least amount of work possible for every packet. That's the only way to fix things. Some general recommendations are here: https://networkradius.com/articles/2022/01/10/its-always-the-database.html Alan DeKok.
participants (3)
-
Alan DeKok -
Can Paçacı -
Matthew Newton