I am running it with -X, and it all seems fine. It shows the sql module loading, and all the accounting queries. What could I be missing? Ben On Wed, 2005-09-28 at 16:42 -0300, Paolo Rotela wrote:
That is exactly the setup I have, but it doesn't seem to be working. There are no errors reported in radius.log, and no accounting queries in sqltrace.sql. Any ideas?
Yep, reinstall it ;)
No, really, you should try to shutdown the daemon and try running "radiusd -X", then test it, and see if the debugging mode tells you something :)
Cheers, Ben
On Wed, 2005-09-28 at 15:08 -0300, Paolo Rotela wrote:
You should have something like this in your radiusd.conf
$INCLUDE ${confdir}/sql.conf
Then you should have this in sql.conf (or the file pointed to by the include, my example is with mysql, could be another engine)
sql {
# Database type # Current supported are: rlm_sql_mysql, rlm_sql_postgresql, # rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds driver = "rlm_sql_mysql"
# Connect info server = "localhost" login = "user" password = "user"
# Database table configuration radius_db = "radius"
# If you want both stop and start records logged to the # same SQL table, leave this as is. If you want them in # different tables, put the start table in acct_table1 # and stop table in acct_table2 acct_table1 = "radacct" acct_table2 = "radacct"
....
and then some accounting_*_query that inserts or updates the ${acct_table1} or ${acct_table2}.
Then your "accounting {" section in radiusd.conf should have a line saying "sql" or the sql instance name (if you are using more than the default instance for sql module).
And then you must have the "radius" database and the "radacct" table.
If all this is ok, then I don't know for sure, you should check your radius.log for errors in the sql module.
----- Original Message ----- From: "Ben Dowling" <bendowling@lineone.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Wednesday, September 28, 2005 2:30 PM Subject: Re: SQL Accouting
I previously mentioned, the accounting section contains just 'sql'. I have no sql section in radiusd.conf though (perhaps this is my problem?) and no sql_accouting definitions in my sql.conf, but the sql accouting queries are defined there, and they are correct.
The sql connection is working, and post auth data gets logged fine, just not the accouting stuff.
Cheers, Ben
On Wed, 2005-09-28 at 09:11 -0300, Paolo Rotela wrote:
Yep, but I need some more info. Your sql section in radiusd.conf and your sql_accounting* definitions in sql.conf. Also the "accounting" section in radiusd.conf, in wich it must be a "sql" instance.
Ing. Paolo Rotela Jefe Técnico Blue Telecom
Eng. Paolo Rotela CTO Blue Telecom ----- Original Message ----- From: "Ben Dowling" <bendowling@lineone.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Tuesday, September 27, 2005 6:00 PM Subject: SQL Accouting
Hi,
I'm still having problems getting FreeRadius-1.0.4 to log accounting data to sql. I know it is receiving the data, as I can log it to file. In my accounting section I have 'sql', and the SQL queries are there in sql.conf. However, when looking at the sqltrace log the only queries are inserts to radpostauth. Can anyone help?
Thanks in advance, Ben
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html