mysql Accounting not working

Mario Alberto Cruz Gartner mario.cruz at gmail.com
Thu Jul 14 18:37:12 CEST 2005


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
>




More information about the Freeradius-Users mailing list