Re: Mystery of mysql.sock location in FreeRADIUS
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 version10 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
Re: Mystery of mysql.sock location in FreeRADIUS
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? well if you cant still find answers, you can try creating a soft link FROM /var (where the sock file is being created) TO /usr (where you want it to be), its not the proper mysql solution but its an approach that works! //milver - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mystery of mysql.sock location in FreeRADIUS
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 version10 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.sock'. 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. Thanks in advance. MS _ Overwhelmed by debt? Find out how to ?Dig Yourself Out of Debt? from MSN Money. http://special.msn.com/money/0407debt.armx - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Mystery of mysql.sock location in FreeRADIUS
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 version10 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.sock'. It is not in radiusd.conf, or sql.conf. Any ideas? Thanks in advance. MS _ Overwhelmed by debt? Find out how to Dig Yourself Out of Debt from MSN Money. http://special.msn.com/money/0407debt.armx - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html