rlm_sql_mysql Problem with Freeradius on Centos 5

[Andy Hughes]

Hi all,

After much head scratching I worked it out. The problem was that SELinux was enabled and stopping radiusd from connecting to the socket.

Thanks for your help.

Andy

> 
> Message: 2
> Date: Thu, 7 Jun 2007 10:12:38 +0300
> From: "liran tal" <liransgarage at gmail.com>
> Subject: Re: rlm_sql_mysql Problem with Freeradius on Centos 5
> To: "FreeRadius users mailing list"
> 	<freeradius-users at lists.freeradius.org>
> Message-ID:
> 	<3ed55890706070012r1a1891b2xce125f51f45c2664 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> 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:
> https://lists.freeradius.org/pipermail/freeradius-users/attachments/20070607/46f1e64f/attachment-0001.html
> 
> ------------------------------
> 
> ************************************************