on the sql.conf add "sqltrace = yes" start up with "radiusd -X" and see what happen. You test the mysql conneciotn from the SAME host that freeradius? On 7/14/05, Leonardo Valente <leovalente2000@yahoo.com.br> wrote:
Hello,
I use Debian Linux Sarge, kernel 2.6.8-2(368), freeradius 1.0.2, and I'm trying to configure freeradius + mysql Accounting. I created database from script "db_mysql.sql", and created a user to access database with full privileges. I tested to access database from another host and it's fine. I can get authentication from localhost and another host. BUT freeradius is not insert accounting information in database. I used "freeradius -X" to get some debug information and I can't see it doing INSERT. But I know that freeradius connect into database when I start the daemon, I could see that in "mysql.log". I looked into "mysql.log" and freeradius is not doing INSERT. Database name, database username, password and host are set in "sql.conf". And "accounting" tag from "radiusd.conf" is: ------- accounting { sql } --------
Someone can tell me if I forgot some configuration? I just wanna do Mysql Accounting...
Thanks in advance
- "Dize-me tuas comunidades e te direi quem és..." Leonardo Valente MSN: agunoiado@hotmail.com
__________________________________________________ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html