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