cant connect to mysql server / ERROR: cannot open database

[Kevin Lieser]

Piler runs great now on my Debain machine. WebGUI has one problem – I will report that separate.

I have setup correct MySQL settings in piler.conf, the WebGUI config.php and the shpinx.conf. As I said, everything works fine but in my mail.log these error are constantly occuring every few seconds and I have no clue why or where wrong MySQL settings can be defined.

Aug 10 21:46:53 s2 piler[2361]: cant connect to mysql server
Aug 10 21:46:53 s2 piler[2361]: ERROR: cannot open database
Aug 10 21:46:53 s2 piler[2362]: cant connect to mysql server
Aug 10 21:46:53 s2 piler[2362]: ERROR: cannot open database

Any idea where these came from?

Piler version

piler -v
1.3.5 build 997

‌

[Janos SUTO]

Check if mysql is running when piler starts. Also double check the mysql parameters in piler.conf.

[Kevin Lieser]

I already have. I restarted piler a few times. Switched from mysql_socket parameter to mysql_hostname and mysql_port, restarted piler. MySQL is running fine. No changes. As I said, everything works great except these error messages.

[Janos SUTO]

It’s odd anyway. Can you see anything unusual in the mysql logs? Also can you check the network traffic (perhaps with ngrep) between piler and mysql? If piler is receiving and archiving emails properly, then it’s fine, however these errors are not normal.

[Kevin Lieser]

Oh my god. There was running another instance of piler (for sure with wrong settings). Killed these tasks and log entries are gone. Thanks!