radacct is not filled up

[Fajar A. Nugraha]

On Tue, Jul 17, 2012 at 4:08 PM, Andreas Meyer <anmeyer at anup.de> wrote:

> Hm, no luck with this one. I changed buffered.sql to log to sql, but it

Did I EVER mention anything about buffered.sql?
Was it EVER mentioned in the wiki page?

>        accounting {
>         sql
>         }

so accounting section has sql. That's good.

> # Executing section post-auth from file /usr/etc/raddb/sites-enabled/default

See that? That's post-auth. That section is called after
access-request packets are processed.

> +- entering group post-auth {...}
> [reply_log]     expand: /usr/var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d -> /usr/var/log/radius/radacct/192.168.1.254/reply-detail-20120717
> [reply_log] /usr/var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d expands to /usr/var/log/radius/radacct/192.168.1.254/reply-detail-20120717
> [reply_log]     expand: %t -> Tue Jul 17 10:57:08 2012
> ++[reply_log] returns ok
> [sql]   expand: %{Stripped-User-Name} ->
> [sql]   ... expanding second conditional
> [sql]   expand: %{User-Name} -> bitcorner-1

... and you didn't have ANYTHING in the log about accounting.

Does your NAS send accounting packets? Accounting section is only
called when radius receive accounting packets.


Or is it that you want to log some data to sql in post-auth, instead
of accounting? If so, then you need to modify the correct section
(i.e. post-auth, not accounting). And the table modified will NOT be
radacct, but radpostauth. See sql.conf and sql/mysql/dialup.conf for
details, look for "postauth". You CAN change what's logged, and where,
by editing the queries.

-- 
Fajar