[Dovecot] Dovecot error wuth MySQL

Jerry jerry at seibercom.net
Thu Mar 14 12:56:37 EET 2013

On Thu, 14 Mar 2013 01:28:23 -0700 (PDT)
Cesar articulated:

> Hello PeopleCan anybody help me?My scenario:- One computer with:a)
> postfix-2.6.6-2.2.el6_1.x86_64b) mysql-5.1.66-2.el6_3.x86_64c)
> dovecot-2.0.9-2.el6_1.1.x86_64d)
> dovecot-mysql-2.0.9-2.el6_1.1.x86_64Postfix and Dovecot auth over
> MySQLThe Problem:- logwatch show me: Dovecot disconnects:    auth
> failed, 1 attempts: 1 Time(s)    in IDLE: 2 Time(s) no auth attempts:
> 6 Time(s)    no reason: 6 Time(s)  **Unmatched Entries** dovecot:
> auth: Error: mysql: Query failed, retrying: MySQL server has gone
> away: 125 Time(s)(125 Times Wow)For example part of maillog show
> me:About MySQL auth failed:Mar 10 03:55:05 gateway dovecot: auth:
> Error: mysql: Query failed, retrying: MySQL server has gone awayMar
> 10 03:55:05 gateway dovecot: auth: mysql: Connected to localhost
> (mail)Mar 10 03:55:05 gateway dovecot: pop3-login: Login:
> user=user-name at domain.com>, method=PLAIN, rip=,
> lip=, mpid=16352Mar 10 03:55:05 gateway dovecot:
> pop3(user-name at domain.com): Disconnected: Logged out top=0/0,
> retr=0/0, del=0/0, size=0The Question:How to fix it? (i don't want to
> see the dovecot auth error mysql)I will be very grateful to anyone
> who can help

The line wrapping is making this mess extremely difficult to read and
decipher. Are you even sure the MySQL server is even running? Have you
tried shutting down your system and rebooting and observing what
transpires? Do you have log entries from the MySQL and Dovecot servers?

Post the unaltered output of:

	postconf -n
	dovecot -n

It might be helpful to post the MySQL file that dovecot is using to
contact the MySQL server also.

Jerry ♔

Disclaimer: off-list followups get on-list replies or get ignored.
Please do not ignore the Reply-To header.

More information about the dovecot mailing list