freeradius 3.2 accounting with sqlippool

[mohammed Irheem]

hello,
in freeradius 3.2 i enable sqlippool and make static ip for radcheck user
accounting update not working
working only if client take ip from sqlippool



(1) # Executing section accounting from file
/usr/local/etc/raddb/sites-enabled/default
(1)   accounting {
(1)     [unix] = noop
rlm_sql (sql): Reserved connection (1)
(1) sqlippool: EXPAND %{User-Name}
(1) sqlippool:    --> 77777
(1) sqlippool: SQL-User-Name set to '77777'
(1) sqlippool: EXPAND UPDATE radippool SET expiry_time = NOW() + INTERVAL
1210 SECOND WHERE nasipaddress =
'%{%{Nas-IP-Address}:-%{Nas-IPv6-Address}}' AND pool_key = '%{NAS-Port}'
AND username = '%{User-Name}' AND callingstationid =
'%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}'
(1) sqlippool:    --> UPDATE radippool SET expiry_time = NOW() + INTERVAL
1210 SECOND WHERE nasipaddress = '192.168.254.1' AND pool_key = '15728742'
AND username = '77777' AND callingstationid = 'C0:25:E9:4B:81:2D' AND
framedipaddress = '10.104.255.254'
(1) sqlippool: Executing query: UPDATE radippool SET expiry_time = NOW() +
INTERVAL 1210 SECOND WHERE nasipaddress = '192.168.254.1' AND pool_key =
'15728742' AND username = '77777' AND callingstationid =
'C0:25:E9:4B:81:2D' AND framedipaddress = '10.104.255.254'
rlm_sql_mysql: Rows matched: 0  Changed: 0  Warnings: 0
rlm_sql (sql): Released connection (1)
Need 1 more connections to reach min connections (3)
Need more connections to reach 10 spares
rlm_sql (sql): Opening additional connection (7), 1 of 30 pending slots used
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX socket,
server version 5.7.39, protocol version 10
(1)     [sqlippool] = notfound
(1)   } # accounting = notfound
(1) Not sending reply to client.
(1) Finished request
(1) Cleaning up request packet ID 125 with timestamp +274 due to done



Thanks