MySQL Connection Failure

[Marcin Jessa]

On Mon, 11 Jul 2005 17:18:00 -0500
"Thomas Tinsley" <ttinsley at 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 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
> 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
>