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. > +- 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html