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