Can't connect to database
Dovecot has been giving me problems for the past week or so. Today the error log showed me this:
Jan 2 13:33:39 grace dovecot: auth-worker(3250): Error: mysql(localhost): Connect failed to database (postfix): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- waiting for 5 seconds before retry
The socket is there, showing full permissions (rwx for owner, group, and rest of the universe) so I can't understand why dovecot can't connect.
Is there anyone who can help?
Ken
On 02/01/2022 22:36 Ken Wright daddywarlock@gmail.com wrote:
Dovecot has been giving me problems for the past week or so. Today the error log showed me this:
Jan 2 13:33:39 grace dovecot: auth-worker(3250): Error: mysql(localhost): Connect failed to database (postfix): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- waiting for 5 seconds before retry
The socket is there, showing full permissions (rwx for owner, group, and rest of the universe) so I can't understand why dovecot can't connect.
Is there anyone who can help?
Ken
Maybe MySQL is not running, or perhaps something is blocking connecting to it? Check dmesg and (if on redhat based system) /var/log/audit/audit.log
Aki
mysql(localhost): Connect failed to database (postfix): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Maybe MySQL is not running, or perhaps something is blocking connecting to it? Check dmesg and (if on redhat based system) /var/log/audit/audit.log
Environment? Chroot, docker, selinux can prevent sockets from being reachable. Another area to check... when the socket has rwx for others, if one of the parent directories is blocking access for others then programs will be denied access.
On Mon, 2022-01-03 at 00:44 +0200, Aki Tuomi wrote:
Maybe MySQL is not running, or perhaps something is blocking connecting to it? Check dmesg and (if on redhat based system) /var/log/audit/audit.log When I ran systemctl status mysql, it tells me mariadb.service is active and running.
participants (3)
-
Aki Tuomi
-
dovecot＠ptld.com
-
Ken Wright