I've had similar problems with MySQL before (not in relation to FreeRadius, but the same socket problem) and the easiest way for me to fix it was to change the hostname where the application thinks MySQL exists from localhost to the actual hostname of the machine. This bypasses the use of the mysql.sock UNIX socket and just uses the TCP socket that MySQL opens on its standard port. I'm not sure if you have mysqld's TCP port disabled, in which case this wouldn't work, but if not hopefully this will fix the problem without having to recompile MySQL. On 11/5/05, Seferovic Edvin <edvin.seferovic@kolp.at> wrote:
Hi,
I have been looking at sql.conf, but no use.. I use localhost, usual port, username and password are okay.. and this is what freeradius says to me now.
Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Info: rlm_sql (sql): Attempting to connect to root@localhost:/radius Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Error: rlm_sql (sql): Failed to connect DB handle #0 Info: Ready to process requests.
But according to my new mysql datadir location ( and my my.cnf file ) - the socket can be found at /data/mysql/mysql.sock... shouldn't freeRadius find out the new location? How is this done anyway?
Any hints? I would be thankful !
Regards,
Edvin Seferovic
-----Original Message----- From: aland@nitros9.org [mailto:aland@nitros9.org] On Behalf Of Alan DeKok Sent: Sonntag, 06. November 2005 05:15 To: edvin.seferovic@kolp.at; FreeRadius users mailing list Subject: Re: mysql.sock moved and cannot be found by freeradius !
Seferovic Edvin" <edvin.seferovic@kolp.at> wrote:
when I started it for the second time - it said that it cannot find the mysql.sock file in the "usual" place ( /var/lib/mysql/mysql.sock )... is the location of mysql.sock hard-coded in freeradius ?
No. See "sql.conf".
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html