Logging CDRs into MySQL

tnt at kalik.net tnt at kalik.net
Thu Nov 6 16:04:25 CET 2008


>I am facing difficulties in integrating MySQL and FreeRadius for the accounting. I have setup the mysql with a database named 'radius'. I have also defined a table 'rt_cdr1' which is to be used to store the CDRs that come in the accounting request. I add the following statements in radiusd.conf.
>
>-----------
>
>accounting{
>detail
>sql
>}
>------
>

Why? Accounting section is in default virtual server:

>including configuration file /usr/local/etc/raddb/sites-enabled/default

>Also in the mysql.conf I have the following :
>
>acct_table1="rt_cdr1"
>acct_table2="rt_cdr1"
>

Which is not linked anywhere:

>including configuration file /usr/local/etc/raddb/sql.conf
>including configuration file /usr/local/etc/raddb/sql/mysql/dialup.conf
>including configuration file /usr/local/etc/raddb/sql/mysql/counter.conf

Maybe sql.conf?

>Is their any other configurations that needs to be done to make the free radius pump the accounting request into databas?..I serarched to no avail . 
>

Edit the accounting queries in dialup.conf if you want extra attributes
logged.

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list