I believe I've setup buffered SQL correctly in my configuration, and I do have some data that's made it into SQL...
I used the default buffered-sql in sites-enabled on RHEL 6... In my sites-enabled/default, I have it logging to a detail file (and not SQL). I also have the sites-enabled/buffered-sql where the listen section has the detail file and the accounting section has sql-acct listed. I then have a file /etc/raddb called sql-acct where I've defined sql-acct (I also have a separate sql called sql-auth for authentication). The detail files are written (daily) and a detail.work is created, but it hangs and never disappears (nor written to the database). There only warnings/errors I see at all are: Mon Nov 7 15:51:12 2011 : Info: [sql-acct] stop packet with zero session length. [user '[email protected]', nas '10.99.0.39'] Mon Nov 7 15:52:31 2011 : Info: # Executing section accounting from file /etc/raddb/sites-enabled/default Mon Nov 7 15:52:31 2011 : Info: +- entering group accounting {...} Mon Nov 7 15:52:31 2011 : Info: [detail] expand: /var/log/radius/radacct/detail-%Y%m%d -> /var/log/radius/radacct/detail-20111107 Mon Nov 7 15:52:31 2011 : Info: [detail] /var/log/radius/radacct/detail-%Y%m%d expands to /var/log/radius/radacct/detail-20111107 Mon Nov 7 15:52:31 2011 : Info: [detail] expand: %t -> Mon Nov 7 15:52:31 2011 Mon Nov 7 15:52:31 2011 : Info: ++[detail] returns ok Mon Nov 7 15:52:31 2011 : Info: ++[unix] returns noop Mon Nov 7 15:52:31 2011 : Info: [radutmp] expand: /var/log/radius/radutmp -> /var/log/radius/radutmp Mon Nov 7 15:52:31 2011 : Info: [radutmp] expand: %{User-Name} -> [email protected] Mon Nov 7 15:52:31 2011 : Info: ++[radutmp] returns ok Any ideas on how to troubleshoot/fix this? Thanks, GG - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
