Freeradius 3.0.25 not processing accounting section after sqlippool module returns notfound
Antônio Modesto
modesto at hubsoft.com.br
Thu Dec 23 21:48:55 CET 2021
Recently I upgraded one of my servers to freeradius 3.0.25 and I am
facing a problem that did not happen in the previous version (3.0.21). I
have the following code in my accounting session:
accounting {
if (Framed-Protocol == PPP && Acct-Status-Type != Accounting-On) {
-sqlippool
}
if (Acct-Status-Type != Accounting-On) {
-sql
if (noop) {
ok
}
}
if (Acct-Status-Type == Accounting-On || Acct-Status-Type ==
Accounting-Off) {
log_accounting
}
attr_filter.accounting_response
}
In this server we do not have any pools enabled, so the radippool table
is empty. When analysing the output in debug mode, the accounting
section stops executing after sqlippool is called (The module returns
notfound):
(1) sqlippool: --> UPDATE radippool SET expiry_time =
'now'::timestamp(0) + '43200 seconds'::interval WHERE nasipaddress =
'A.B.C.D' AND pool_key = 'C8:3A:35:23:97:08' AND framedipaddress =
'172.17.105.22' AND username = 'user008274' AND callingstationid =
'C8:3A:35:23:97:08'
(1) sqlippool: Executing query: UPDATE radippool SET expiry_time =
'now'::timestamp(0) + '43200 seconds'::interval WHERE nasipaddress =
'A.B.C.D' AND pool_key = 'C8:3A:35:23:97:08' AND framedipaddress =
'172.17.105.22' AND username = 'user008274' AND callingstationid =
'C8:3A:35:23:97:08'
rlm_sql_postgresql: Status: PGRES_COMMAND_OK
rlm_sql_postgresql: query affected rows = 0
rlm_sql (sql): Released connection (3)
(1) [sqlippool] = notfound
(1) } # if (Framed-Protocol == PPP && Acct-Status-Type !=
Accounting-On) = notfound
(1) } # accounting = notfound
What should I do to force freeradius to continue the work in the
accounting section even when sqlippool returns notfound?
--
Att, *Antônio Modesto*
More information about the Freeradius-Users
mailing list