Hello! "Fajar A. Nugraha" <list@fajar.net> wrote:
On Tue, Jul 17, 2012 at 4:08 PM, Andreas Meyer <anmeyer@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