mysql Accounting not working

[Leonardo Valente]

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 at 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 at 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 at 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 at hotmail.com


	
	
		
_______________________________________________________ 
Yahoo! Acesso Grátis - Internet rápida e grátis. 
Instale o discador agora! http://br.acesso.yahoo.com/