in my "sql.conf": ------------------------------------- sqltrace = yes sqltracefile = ${logdir}/sqltrace.sql ------------------------------------- freeradius user has privileges to write in ${logdir}, but this file not even is created when I do "freeradius -X" or "freeradius -x". Yes, I tested mysql connection from SAME host that free radius. Like I said, I can see in "mysql.log" freeradius connected 5 times, when I start up daemon, but I can't see INSERT TO... Can debian freeradius package not be compiled with mysql account support? I don't have ideas anymore... I think I'll try compile from source code... and test... Thanks --- Mario Alberto Cruz Gartner <mario.cruz@gmail.com> escreveu:
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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- "Dize-me tuas comunidades e te direi quem és..." Leonardo Valente MSN: agunoiado@hotmail.com _______________________________________________________ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/