rlm_sql_mysql Problem with Freeradius on Centos 5

[liran tal]

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 at 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 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
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070607/46f1e64f/attachment.html>