MySQL Connection Failure
lists at yazzy.org
Mon Jul 11 23:24:40 CEST 2005
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.
> 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
> 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.
> Does anyone have a method to trace the connection attempt? MySQL is
> not kicking out any log info that would help.
>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.
More information about the Freeradius-Users