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