Re: Can't connect to database

[Ken Wright]

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.

Re: Can't connect to database

[dovecot]

>> 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.

Re: Can't connect to database

[Aki Tuomi]

> On 02/01/2022 22:36 Ken Wright  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

Can't connect to database

[Ken Wright]

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