search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.02k stars 978 forks source link

Socket file not in /tmp #2887

Open Thunderhun opened 4 years ago

Thunderhun commented 4 years ago

Hi,

I would like to change the socket file directory, I added the "nasty" space at the end of the line too. My version: ProxySQL version 2.0.12-38-g58a909a0, codename Truls mysql-interfaces | 0.0.0.0:3306,/var/run/mysqld/mysqld.sock

Unfortunately there is no socket file on that path.

Did i miss something?

Robert

Thunderhun commented 4 years ago

I had to create the directory manually /var/run/mysqld and set the rights to proxysql:proxysql, then the socket file is there. But that isn't a solution during a reboot.

Thunderhun commented 4 years ago

A created a config file in /usr/lib/tmpfiles.d/proxysql.conf, so this will create the directory during system start and the socket file could be created by proxysql. The content is: d /run/mysqld 0755 proxysql proxysql