radacct is not filled up

[Marinko Tarlać]

>I fear the AP is not sending accounting packets at all. The only
>thing I can configure at the TP-Link AP is that it can communicate
>with the radiusserver at port 1812 for auth packets.

Good to know.... I had the same problem with TP Link... RADIUS auth works fine but accounting no-no



On 17.7.2012 11:54, Andreas Meyer wrote:
> Hello!
>
> "Fajar A. Nugraha" <list at fajar.net> wrote:
>
>> 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.
> Ok
>
>>> +- 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.
> I fear the AP is not sending accounting packets at all. The only
> thing I can configure at the TP-Link AP is that it can communicate
> with the radiusserver at port 1812 for auth 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
> not that I know of
>
> I have a section in radisud.conf to listen for type = acct
>
>> (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.
> I must say I am not sure, what information belongs to post-auth exactly
> and why. I promise I read the FAQ!
>
>    Andreas
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>