mysql Accounting not working

2005-07-14 Thread Leonardo Valente 
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: [EMAIL PROTECTED]

__
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

Re: mysql Accounting not working

2005-07-14 Thread Mario Alberto Cruz Gartner 
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
 
 __
 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

Re: mysql Accounting not working

2005-07-14 Thread 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 [EMAIL PROTECTED]
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
 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
  
  __
  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: [EMAIL PROTECTED]





___ 
Yahoo! Acesso Grátis - Internet rápida e grátis. 
Instale o discador agora! http://br.acesso.yahoo.com/
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html