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@gmail.com> Subject: Re: rlm_sql_mysql Problem with Freeradius on Centos 5 To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Message-ID: <3ed55890706070012r1a1891b2xce125f51f45c2664@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@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