Hi Jeff,
Here are some commands you can run to determine the number of
connections (to determine if this is the issue) to the MariaDB in the
event that this happens again:
1) echo "show full processlist" | mysql -u root -ppassword
2) doveadm who
3) ps aux | grep vpopmail | grep dovecot
Eric
On 9/15/2017 4:02 PM, Jeff Koch wrote:
I raised it to 300 but we're a little concerned about all these root
sessions. Could they be a form of break-in attempt and why would they
affect mysql to the point that dovecot could not connect. And what the
heck is a 'user-89.slice. vpopmail is usually user 89.
Jeff
On 9/15/2017 5:57 PM, Eric Broch wrote:
I think I'd try upping the connection count, what's it at 151?
On 9/15/2017 3:25 PM, Jeff Koch wrote:
Nope.
But I did see this strange series of entries in /var/log/messages -
which started at 12:03 and continued to 12:15. This was the same
period that dovecot was complaining that it couldn't connect to mysql
Sep 15 12:04:01 vid systemd: Started Session 208671 of user root.
Sep 15 12:04:01 vid systemd: Starting Session 208671 of user root.
Sep 15 12:04:01 vid systemd: Started Session 208670 of user root.
Sep 15 12:04:01 vid systemd: Starting Session 208670 of user root.
Sep 15 12:04:01 vid systemd: Started Session 208672 of user root.
Sep 15 12:04:01 vid systemd: Starting Session 208672 of user root.
......
..........
Sep 15 12:15:01 vid systemd: Starting Session 208707 of user root.
Sep 15 12:15:01 vid systemd: Started Session 208709 of user root.
Sep 15 12:15:01 vid systemd: Starting Session 208709 of user root.
Sep 15 12:15:01 vid systemd: Started Session 208708 of user root.
Sep 15 12:15:01 vid systemd: Starting Session 208708 of user root.
Sep 15 12:15:01 vid systemd: Created slice user-89.slice.
Sep 15 12:15:01 vid systemd: Starting user-89.slice.
Sep 15 12:15:01 vid systemd: Started Session 208710 of user vpopmail.
Sep 15 12:15:01 vid systemd: Starting Session 208710 of user vpopmail.
Sep 15 12:15:17 vid clamd: SelfCheck: Database status OK.
Sep 15 12:15:18 vid systemd: Removed slice user-89.slice.
Sep 15 12:15:18 vid systemd: Stopping user-89.slice.
Jeff
On 9/15/2017 4:09 PM, Eric Broch wrote:
Any entries in /var/log/mariadb/mariadb.log ?
On 9/15/2017 1:21 PM, Jeff Koch wrote:
For about a 15 minutes period users couldn't receive emails -
emails were bouncing back saying the users did not exist. We
traced the problem to the dovecot log where we saw this:
Sep 15 12:16:23 auth-worker: Error: vmysql: sql error[3]: Table
'vpopmail.users' doesn't exist
Sep 15 12:16:23 auth-worker: Error: Attempting to rebuild
connection to SQL server
Sep 15 12:16:23 auth-worker: Error: vmysql: connection rebuild
failed: Table 'vpopmail.users' doesn't exist
Shortly thereafter dovecot was able to connect and emails began
being received normally again.
Any thoughts on how to prevent this in the future? Should we raise
the number of mysql connections - we're using the default.
Regards, Jeff Koch
--
Eric Broch
White Horse Technical Consulting (WHTC)
--
Eric Broch
White Horse Technical Consulting (WHTC)
