ProxySQL 2.7.3 - Can not start without proxysql.pid

[Wil Knoll]

Hello All,

I have a fresh Ubuntu 24.04 install with Proxysql 2.7.3 installed from the repo. After install, when trying to start using the shipped proxysql.service unit file, we get

2025-07-10T01:08:57.390688+00:00 ubuntu-24-004 systemd[1]: proxysql.service: Can't open PID file /var/lib/proxysql/proxysql.pid (yet?) after start-post: No such file or directory

The directory does exit. And is owned by proxysql. The service has never run so there wouldn't be a PID file to start I would think. If we touch and then cown proxysql.pid to proxysql, so there is an empty file in that location, we get the following:

2025-07-10T01:15:40.147360+00:00 ubuntu-24-004 systemd[1]: proxysql.service: Failed to parse PID from file /var/lib/proxysql/proxysql.pid: Invalid argument    2025-07-10T01:15:40.147686+00:00 ubuntu-24-004 systemd[1]: proxysql.service: Failed with result 'protocol'.

And as ProxySQL quits, it deletes the proxysql.pid file. So if we try to start it again, we get the first error again. 

This feels like I'm missing something very simple and embarrassing. Any ideas?

Cheers,

Wil

[Wil Knoll]

Think we have isolated where the issue is. We were dragging an old proxysql.cnf along with us and there must be some config setting that was dropped. When using the shipped proxysql.cnf the system loads normally. Sorry for the noise, we'll start with a fresh config. 

Cheers,

Wil