freeradius can't connect to mysqld due to incorrect mysqld.sock path. rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' rlm_sql (sql): Failed to connect DB handle #0 Actual path is /tmp/mysqld.sock. Can I change path to mysqld.sock in freeradius?
rashad wrote:
freeradius can't connect to mysqld due to incorrect mysqld.sock path.
rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' rlm_sql (sql): Failed to connect DB handle #0
Actual path is /tmp/mysqld.sock. Can I change path to mysqld.sock in freeradius?
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
/var/run/mysqld/mysqld.sock is the usual location of that socket. Every program that wants to connect to mysqld through socket will per default use that one. I dunno why you set mysql to place the socket to /tmp/mysqld.sock. What u could try is to set a symlink pointing to /tmp/mysqld.sock at /var/run/mysqld/mysqld.sock as workaround. The command for that is: ln -s /tmp/mysql.sock /var/run/mysqld/mysqld.sock should do that. if /var/run/mysqld/ don't exist then u have to create it *before* doing the ln command! cheers Sebastian lg S.Wild -- Cronon AG Technik +49 941 56 71 23 95 Fon +49 941 58 41 03 9 Fon Technik zentral +49 941 59 57 91 64 Fax
When I had this problem , on any environment, not specifically freeradius, the more quick solution was make a link of the actual path of the mysql sock to the path where this is expected ('/var/run/mysqld/mysqld.sock' ) Ernesto Freyre Ramirez Jefe de Operaciones Qnet Soluciones Tecnologicas Av. Paseo de la Republica 4675 - Lima 34 Telf.: (511) 241-4122 Anexo 2245 Fax: (511) 446-8135 Visitenos en: www.qnet.com.pe ----- Original Message ----- From: rashad To: freeradius-users@lists.freeradius.org Sent: Thursday, June 23, 2005 9:21 AM Subject: mysqld.sock path problem freeradius can't connect to mysqld due to incorrect mysqld.sock path. rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' rlm_sql (sql): Failed to connect DB handle #0 Actual path is /tmp/mysqld.sock. Can I change path to mysqld.sock in freeradius? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Ernesto Freyre Ramirez -
rashad -
Sebastian Wild