New sql queries in sql.conf

Hello folks, I'm using an MySQL database to authenticate my users. I'm trying to create new sql queries to put new values in new fields. I try to do like this: postauth_profile = SELECT Value FROM ${authreply_table} WHERE UserName = '%{SQL-User-Name}' AND STRCMP(Attribute, 'State') = 0

Re: radacct table empty

Well I'll give more information, the user that I have authenticating have the following configuration in my radcheck and radreply table 00045700A43BUser-Password == "default", NAS-Identifier = 192 Reply-Message := "" State = 102 I'm using an Freeradius 1.0.1, MySQL 4.0.20 and Slackware Linux.

radacct table empty

Hello folks, I have done tests and more tests here to log the accounting logs in the mysql. I ahev search in the web and found some tips in how to do this, but I still does't have success. In my radiusd.conf in the section regarding accounting I have this: accounting { sql} And in the sql.conf

Re:Re: radacct table empty

Thanks for you reply, but I don't understand just one thing, I have a lot of logs in the directory /usr/local/var/log/radius/radacct/192.168.2.253/   In this directory I have logs auth-detail-something and reply-detail-something. This isn't accounting information?? Regards, André Zenun Thor

radacct table empty

Hello folks, I'm making a test with freeradius authenticating with an DB in MySQL. I have activate logs for the authentications and it create a directory for each nas in my network in the directory /usr/local/var/log/radius/radacct/IP of the NAS/logs, in this directory I havea lot of logs, but

Configuring Freeradius to authenticate with MySQL

Hello folks I'm trying to configure freeradius to authenticate with MySQL. I made tests without MySQL and works fine. But With MySQL I'm having problems. I create the database radius and create the tables with the mysql file that come in the tgzof the sources usingthecommand mysql -root radius