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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]: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 [EMAIL PROTECTED]: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 [EMAIL PROTECTED]: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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
