Re: rlm_sql_mysql Problem with Freeradius on Centos 5

["liran tal" <liransgarage@gmail.com>]

Could it be an authentication problem? Maybe you didn't spell the user to connect to mysql correct?
I would also suggest that you enable extensive logging on the mysql side to see if there are any 
requests. This is done usually in /etc/mysql/my.cnf


Liran.

On 6/7/07, Andy Hughes <andy@conet.co.nz> wrote:

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


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html