MySQL Connection Failure

[Marcin Jessa]

On Mon, 11 Jul 2005 14:20:51 -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
 
> 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.

> 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 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.

> 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