sql ip pool module assign IP 0.0.0.0 to users

[Mirko Alberio]

Hello!

We have the following problem:

When many of out NAS (which are Wireless PPPOE POPs) that are Mikrotik 
based are rebooted (for maintanance, updates or maybe outages) and then 
simultaneously connect to our Freeradius instance to authenticate again 
we are experiencing the following rows in the logs:

Thu Nov 18 06:25:06 2021 : Error: Received conflicting packet from 
client OpenFiber port 50242 - ID: 114 due to unfinished request.  Giving 
up on old request.
Thu Nov 18 06:25:06 2021 : Error: Received conflicting packet from 
client  port 33577 - ID: 70 due to unfinished request.  Giving up on old 
request.
Thu Nov 18 06:25:06 2021 : Error: Received conflicting packet from 
client  port 37882 - ID: 21 due to unfinished request.  Giving up on old 
request.
Thu Nov 18 06:25:06 2021 : Error: Received conflicting packet from 
client  port 50131 - ID: 95 due to unfinished request.  Giving up on old 
request.
Thu Nov 18 06:25:06 2021 : Error: Received conflicting packet from 
client  port 40360 - ID: 211 due to unfinished request.  Giving up on 
old request.
Thu Nov 18 06:25:06 2021 : WARNING: (8349606) WARNING: Module rlm_sql 
became unblocked
Thu Nov 18 06:25:06 2021 : WARNING: (8349607) WARNING: Module rlm_sql 
became unblocked
Thu Nov 18 06:25:06 2021 : WARNING: (8349608) WARNING: Module rlm_sql 
became unblocked
Thu Nov 18 06:25:06 2021 : WARNING: (8349609) WARNING: Module rlm_sql 
became unblocked
Thu Nov 18 06:25:06 2021 : WARNING: (8349610) WARNING: Module rlm_sql 
became unblocked
Thu Nov 18 06:25:06 2021 : WARNING: (8349605) WARNING: Module rlm_sql 
became unblocked
Thu Nov 18 06:25:06 2021 : WARNING: (8349611) WARNING: Module rlm_sql 
became unblocked

... etc ...

And the customers PPPOE sessions are getting an assigned IP = 0.0.0.0 
instead of one of the IP pool. If we disconnect those sessions proprerly 
and let them authenticate again the problem is fixed.

We have some doubts that this could happen because the POPs are not 
sending the correct AccTerminate packets when rebooting, so it is not 
freeing up the pools. And also those sessions are not recognized as 
active because we are using NAS PORT ID as pool key and it changes, 
maybe would be better tu user the Mac Address as key?

A final note: our IP pool is nearly exhausted, we have about 30 free 
IPs. Could this also give problems?

Thanks.

-- 
Mirko Alberio - Assistenza tecnica
e-mail: mirko.alberio at telemar.it

Telemar SpA Internet Quality Provider
Via Enrico Fermi, 235 - 36100 Vicenza - Italia
Tel 0444 291302 - Fax 0444 566310 - www.telemar.it
Assistenza tecnica 0444 1420000
Reg. Imp. Di Vicenza /C.F./P.I. 02508710247
Cap. Soc. € 120.000,00 I.V.
R.E.A. VI-236292