mysql.sock moved and cannot be found by freeradius !

[Andrew Teixeira]

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 at 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 at 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 at 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 at nitros9.org [mailto:aland at nitros9.org] On Behalf Of Alan DeKok
> Sent: Sonntag, 06. November 2005 05:15
> To: edvin.seferovic at kolp.at; FreeRadius users mailing list
> Subject: Re: mysql.sock moved and cannot be found by freeradius !
>
> Seferovic Edvin" <edvin.seferovic at 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
>