ippool 0.0.0.0 assignment problem

[Mirko Alberio]

Hi! Hope this can be useful for someone.

I found the base problem of my radius ippool assignment problem!

Maybe for future reference for other users, the problem was: WHITESPACE 
in an ip pool address row!

So in some way the NAS where assuming 0.0.0.0 as framed ip address for this.

This is the radiusd -X output that helped me:

(1675) sqlippool: Executing query: COMMIT
(1675) sqlippool: EXPAND START TRANSACTION
(1675) sqlippool:    --> START TRANSACTION
(1675) sqlippool: Executing query: START TRANSACTION
(1675) sqlippool: EXPAND SELECT framedipaddress FROM radippool WHERE 
pool_name = '%{control:Pool-Name}' AND (expiry_time < NOW() OR 
expiry_time IS NULL) ORDER BY (username <> '%{User-Name}'), 
(callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR 
UPDATE SKIP LOCKED
(1675) sqlippool:    --> SELECT framedipaddress FROM radippool WHERE 
pool_name = 'pool1' AND (expiry_time < NOW() OR expiry_time IS NULL) 
ORDER BY (username <> 'xxxxxxxxx'), (callingstationid <> 
'XX:XX:XX:75:36:B6'), expiry_time LIMIT 1 FOR UPDATE SKIP LOCKED
(1675) sqlippool: Executing select query: SELECT framedipaddress FROM 
radippool WHERE pool_name = 'pool1' AND (expiry_time < NOW() OR 
expiry_time IS NULL) ORDER BY (username <> 'xxxxxxxxx'), 
(callingstationid <> 'XX:XX:XX:75:36:B6'), expiry_time LIMIT 1 FOR 
UPDATE SKIP LOCKED
(1675) sqlippool: EXPAND COMMIT
(1675) sqlippool:    --> COMMIT
(1675) sqlippool: Executing query: COMMIT
*(1675) sqlippool: Invalid IP number **[12.34.56.7__] **returned from 
instbase query.*
rlm_sql (sql): Released connection (11)
(1675) sqlippool: EXPAND IP Allocation FAILED from %{control:Pool-Name} 
(did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} 
user %{User-Name})
(1675) sqlippool:    --> IP Allocation FAILED from pool1 (did vlan102 
cli XX:XX:XX:75:36:B6 port 15731656 user xxxxxxxxx)
(1675)     [sqlippool] = noop

Mirko Alberio
Amministratore di Sistemi


Via Enrico Fermi, 235 - 36100 Vicenza - Italia
Tel 0444 291302 - Fax 0444 566310 - www.telemar.it <http://www.telemar.it>
Reg. Imp. Di Vicenza /C.F./P.I. 02508710247
Cap. Soc. € 120.000,00 I.V.
R.E.A. VI-236292

<https://it-it.facebook.com/TelemarIt/> 
<https://www.instagram.com/telemar_it/> 
<https://it.linkedin.com/company/telemar-s-p-a->

Il presente messaggio non costituisce offerta e/o accettazione 
contrattuale.

Ai sensi del Regolamento europeo per la protezione dei dati personali n. 
679/2016 (GDPR) si precisa che le informazioni contenute in questo 
messaggio e/o nel/i file/s allegato/i sono riservate ed a uso esclusivo 
del destinatario. Qualora il messaggio in parola Le fosse pervenuto per 
errore, La invitiamo ad eliminarlo senza copiarlo e a non inoltrarlo a 
terzi, dandocene gentilmente comunicazione. Grazie.
Pursuant to General Data Protection Regulation (GDPR), you are hereby 
informed that this message contains confidential information intended 
only for the use of the addressee. If you are not the addressee, and 
have received this message by mistake, please delete it and immediately 
notify us. You may not copy or disseminate this message to anyone. Thank 
you.