Buffered SQL Setup Not Reading Detail File

[Gary T. Giesen]

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 'user at realm.com', 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}
-> user at realm.com
Mon Nov  7 15:52:31 2011 : Info: ++[radutmp] returns ok


Any ideas on how to troubleshoot/fix this?

Thanks,

GG