radacct is not filled up

[Andreas Meyer]

Hello!

"Fajar A. Nugraha" <list at fajar.net> wrote:

> On Tue, Jul 17, 2012 at 5:59 AM, Andreas Meyer <anmeyer at anup.de> wrote:
> > Hello!
> >
> > I authenticate a users against a mysql-db and everything is fine. Get entries
> > in the radpostauth table but the radacct table stays emtpy, instead the
> > logging is done in /usr/var/log/radius/radacct/192.168.1.254


> > I cannot find the place where in a configurationfile I can change
> > the value to log into the radacct table.
> 
> Did you read http://wiki.freeradius.org/SQL-HOWTO ?
> 
> Search for "accounting"

Yes, I read the SQL-Howto. Made a change in the dialup.conf from
sql_user_name = "%{User-Name}" to
sql_user_name = "%{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}}"

and the debug output shows that the radiusd is using stripped user-name.
But the radacct is not filled up. All is written to the logfile in
/usr/var/log/radius/radacct/192.168.1.254

I wonder if it might have something to do with the buffered-sql in
/usr/etc/raddb/sites-available. I made no changes to that file.

mysql> use radius;
Database changed
mysql> show tables;
+------------------+
| Tables_in_radius |
+------------------+
| badusers         |
| mtotacct         |
| nas              |
| radacct          |
| radcheck         |
| radgroupcheck    |
| radgroupreply    |
| radpostauth      |
| radreply         |
| radusergroup     |
| totacct          |
| userinfo         |
+------------------+
12 rows in set (0.01 sec)

Everything is fine and radcheck and radpostauth and userinfo and so on is
written to the database exept for the radacct information.

  Andreas