MySQL Connection Failure

[Randy Ross]

It would be worth checking you SELinux settings on FC4.

rjr

Marcin Jessa wrote:

>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
>>
>>    
>>
>- 
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>  
>