You can set the environment variable MYSQL_UNIX_PORT as follows: export MYSQL_UNIX_PORT=/usr/mysql/mysql.sock
I'm not sure why the freeradius mysql client doesn't check my.cnf, but I had the same issue and solved as above. Regards, Simon. --- On Monday 26 July 2004 19:54, Masoud Safi wrote: > From: Kostas Kalevras <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > >To: [EMAIL PROTECTED] > >Subject: Re: Mystery of mysql.sock location in FreeRADIUS > >Date: Sat, 24 Jul 2004 02:27:39 +0300 (EEST) > > > >On Thu, 22 Jul 2004, Masoud Safi wrote: > > > Greetings, > > > > > > My radius server which uses MySQL 4.0.18-standard has been running fine > > > >for > > > > > a few months until my /var partition got full. I had to move the data > > > >files > > > > > from /var/lib/mysql to /usr/mysql. > > > > > > After some config changes on the MySQL configs, the MySQL campe up > > > >running > > > > > fine. An ODBC connection which I have had from a Windows box to the > > > >MySQL > > > > > server works fine too. > > > > > > However, FreeRADIUS would not connect to MySQL passing the following > > > >erro. > > > > > ----- > > > rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 > > > rlm_sql_mysql: Starting connect to MySQL server for #0 > > > rlm_sql_mysql: Couldn't connect socket to MySQL server > > > >[EMAIL PROTECTED]:radius > > > > > rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through > > > socket '/var/lib/mysql/mysql.sock' (2)' > > > rlm_sql (sql): Failed to connect DB handle #0 > > > ----- > > > > > > Obviously, I had to make sure that "socket=/usr/mysql/mysql.sock" was > > > in > > > >the > > > > > CLIENT portion of my.cnf file. > > > > > > Here is my DB status output: > > > Server version 4.0.18-standard > > > Protocol version 10 > > > Connection Localhost via UNIX socket > > > UNIX socket /usr/mysql/mysql.sock > > > > > > Now, I can not figure out where in my system is a reference to > > > '/var/lib/mysql/mysql.socke It is not in radiusd.conf, or sql.conf. > > > > > > Any ideas? > > > >If you are sure you 've fixed my.cnf then things should work fine. I would > >suggest tracing the open() calls of the freeradius to check which my.cnf > >file is > >opened by the mysql library used by the sql module. > > Yes, I am sure I configured the my.cfg correctly and that is why my Windows > based ODBC connections work. I also searched my entire HDD for other > instances of my.cfg, but I only have one copy. It seams to me that > freeradius may be reading the mysql.sock info from somewhere else, but > don't know where? > > As far as tracing the open() calls of freeradius, is there anything else I > need to do, other than running radiusd -X? > > _________________________________________________________________ > FREE pop-up blocking with the new MSN Toolbar – get it now! > http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html