rlm_sql_mysql Problem with Freeradius on Centos 5

[Andy Hughes]

Hi Freeradius Users,

I am having an issue with the rlm_sql_mysql driver on Centos 5.

When I run radius from the init.d/radiusd the server presents the following error in the radius logs.

--snip--

Fri Jun  8 02:58:42 2007 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
Fri Jun  8 02:58:42 2007 : Info: rlm_sql (sql): Attempting to connect to radius at localhost:3306/radius
Fri Jun  8 02:58:42 2007 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
Fri Jun  8 02:58:42 2007 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server radius at localhost:radius
Fri Jun  8 02:58:42 2007 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
Fri Jun  8 02:58:42 2007 : Error: rlm_sql (sql): Failed to connect DB handle #0

-- snip -- 

-- snip --
netstat -a

unix  3      [ ]         STREAM     CONNECTED     120857 /var/lib/mysql/mysql.sock
tcp           0            0 *:mysql              *:*                   LISTEN

-- snip --

I have tried running the server as root and I still receive the same error.

However,

When I run the server in extended debug mode (as root) the server starts fine and will serve authentication from the MySQL database quite happily.

--snip--

rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to radius at localhost:3306/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4
Module: Instantiated sql (sql)

--snip--

I have also tried various variations of commands in sql.conf to configure the sql port. Can anyone tell me what the appropriate configuration command is?

Can anyone shine any light on what might be the problem here?

Regards,

Andy Hughes