On Mon, 11 Jul 2005 17:18:00 -0500 "Thomas Tinsley" <ttinsley@everyones-wireless.com> wrote:
Marcin,
Hi my name is Tom and I am installing FreeRadius for the first time.
Specifications: OS: Fedora Core 4 Linux Kernel 2.6.11smp Freeradius version : 1.0.2
1.0.2 has security holes. Use 1.0.4
Update complete. Problem still present.
MySQL version : 4.1.11
DEBUG Info:
Mon Jul 11 14:05:01 2005 : Error: rlm_sql (sql): Failed to connect DB handle #4 Mon Jul 11 14:05:01 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 1 Mon Jul 11 14:05:10 2005 : Info: rlm_sql (sql): Trying to (re)connect unconnected handle 4.. Mon Jul 11 14:05:10 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4 Mon Jul 11 14:05:10 2005 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius Mon Jul 11 14:05:10 2005 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
Your MySQL is not running or you have wrong username and pass or no database to connect to or wrong database name.
MySQL is running. Username, Password, and Database have been confirmed using Dialup-Admin to connect and administrate data records.
Question?
Does anyone have a method to trace the connection attempt? MySQL is
not kicking out any log info that would help.
Read above. I have been through the basic troubleshooting steps. Downloaded the newest version (./configure, make, makeinstall) and still get an error. The error points to a specific socket that does exist and is part of the MySQL configuration.
Ok, try to use this config: http://www.yazzy.org/configs/linux/my.cnf It's a standard config for gentoo but I am sure you can addapt it to RedHat. Pay attention to the socket variable.
I have confirmed the MySQL server is running, and can connect to databases using PHP & PERL.
type mysql -u root -p You will be prompted to type in your pass if mysql is running ok.
I do not have trouble using the mysql client to connect to the server and select the radius database. I can even execute select statements against tables to view the test data.
Is there any chance that freeradius is not compatible with my current version of MySQL?
No. I run it on MySQL 5.x on FreeBSD.
MyADMINPHP and Dialup-Admin are installed, configured, and tested successfully for the MySQL server. I just need to get Radius to do the same. Radius.conf & sql.conf are modified accordingly.
Any help would be appreciated. Thank you.
Cheers, Marcin Jessa