At Mon, 15 Dec 2003 10:25:36 +0000,
James Green wrote:
Use radiusd -X and see what happens with the requests. You should see
the sql queries that the server tries to execute.
Zorbadelos,
This has been done. That is how I know it connects to the database, but doesn't perform any SQL queries.
I can get it to look up the user in the database even, it just refuses to log the result in the database.
Its driving me up the wall :-(
James
Good morning all,======================================================
We have a server with a really old copy of FreeRADIUS logging accounting data to mysql 3.xx. We are now in the process of upgrading to the latest stable of mysql 4 and freeradius.
We've built the system on a separate machine and it works during testing, except it doesn't log anything to mysql. We have authorisation checks using flat files, but use mysql for logging.
radtest works fine, nothing in mysql. radiusd -x shows it connects fine to the mysql server, and mysqld shows it has connected.
Yet there is no sqltrace.sql file either.
We have confirmed the username/password details can log in, and the table names are correct. The accounting{} part is as default, with 'sql' right above 'unix'.
Some help would be appreciated. We are at a loss!
Thanks,
James Green
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Kostas Zorbadelos
Currently at: Otenet IT Department mailto: [EMAIL PROTECTED]
Out there in the darkness, out there in the night
out there in the starlight, one soul burns brighter
than a thousand suns.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
