Buffered SQL Setup Not Reading Detail File
Gary T. Giesen
giesen at snickers.org
Tue Nov 8 16:39:53 CET 2011
I tried adding the noop block to the detail reader and doesn't seem to
make a difference. I'm still seeing this suspicious debug:
Tue Nov 8 10:34:18 2011 : Debug: [<thread>] server buffered-sql {
Tue Nov 8 10:34:18 2011 : Debug: [<thread>] # Executing section
preacct from file /etc/raddb/sites-enabled/buffered-sql
Tue Nov 8 10:34:18 2011 : Debug: [<thread>] +- entering group preacct {...}
Tue Nov 8 10:34:18 2011 : Debug: ++[preprocess] returns ok
Tue Nov 8 10:34:18 2011 : Debug: ++[acct_unique] returns noop
Tue Nov 8 10:34:18 2011 : Debug: ++[files] returns noop
Tue Nov 8 10:34:18 2011 : Debug: # Executing section accounting from
file /etc/raddb/sites-enabled/buffered-sql
Tue Nov 8 10:34:18 2011 : Debug: +- entering group accounting {...}
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand: %{Stripped-User-Name} ->
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] ... expanding second conditional
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand: %{User-Name} ->
user at realm.com
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand:
%{%{User-Name}:-DEFAULT} -> user at realm.com
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand:
%{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} -> user at realm.com
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] sql_set_user escaped user
--> 'user at realm.com'
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand:
%{Acct-Input-Gigawords} ->
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] ... expanding second conditional
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand: %{Acct-Input-Octets} -> 90
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand:
%{Acct-Output-Gigawords} ->
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] ... expanding second conditional
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand:
%{Acct-Output-Octets} -> 76
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand:
%{Acct-Delay-Time} -> 40725
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand:
UPDATE radacct_stop SET acctstoptime = '%S',
acctsessiontime = '%{Acct-Session-Time}',
acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 |
'%{%{Acct-Input-Octets}:-0}',
acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 |
'%{%{Acct-Output-Octets}:-0}',
acctterminatecause = '%{Acct-Terminate-Cause}',
acctstopdelay = '%{%{Acct-Delay-Time}:-0}',
connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid
= '%{Acct-Session-Id}' AND username =
'%{SQL-User-Name}' AND nasipaddress =
'%{NAS-IP-Address}' -> UPDATE radacct_stop SET
acctstoptime = '2011-11-08 10:34:18',
acctsessiontime = '0', acctinputoctets = '0' << 32
| '90',
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] expand: stop packet with
zero session length. [user '%{User-Name}', nas '%{NAS-IP-Address}'] ->
stop packet with zero session length. [user 'user at realm.com', nas
'10.99.0.39']
Tue Nov 8 10:34:18 2011 : Debug: [sql-acct] stop packet with zero
session length. [user 'user at realm.com', nas '10.99.0.39']
Tue Nov 8 10:34:18 2011 : Debug: ++[sql-acct] returns noop
Tue Nov 8 10:34:18 2011 : Debug: } # server buffered-sql
Tue Nov 8 10:34:18 2011 : Debug: Detail - No response configured for
request 1929. Will retry in 30 seconds
Tue Nov 8 10:34:18 2011 : Debug: Finished request 1929.
Tue Nov 8 10:34:19 2011 : Debug: Cleaning up request 1929 ID 15923
with timestamp +166
Any suggestions on unlang to work around it (I've never used it before).
GG
More information about the Freeradius-Users
mailing list