MySQL Connection Failure
lists at yazzy.org
Tue Jul 12 09:36:42 CEST 2005
On Mon, 11 Jul 2005 17:18:00 -0500
"Thomas Tinsley" <ttinsley at everyones-wireless.com> wrote:
> >> 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 at 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
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.
> Marcin Jessa
More information about the Freeradius-Users