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=192.168.100.31, lip=190.128.232.2, 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 me ----- Best Regards Cesar -- View this message in context: http://dovecot.2317879.n4.nabble.com/Dovecot-error-wuth-MySQL-tp40765.html Sent from the Dovecot mailing list archive at Nabble.com.
Am 14.03.2013 09:28, schrieb Cesar:> 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=192.168.100.31, lip=190.128.232.2, 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=0> The 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 > menot not shutdown mysqld or filter in /etc/rsyslog.conf which would be a silly idea because the next time with a problem you supress maybe important messages and starts eeking for help -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 263 bytes Desc: OpenPGP digital signature URL: <http://dovecot.org/pipermail/dovecot/attachments/20130314/9a5de002/attachment.bin>
Am 14.03.2013 09:28, schrieb Cesar:> 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=192.168.100.31, lip=190.128.232.2, 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 > me > > > > ----- > Best Regards > Cesar > -- > View this message in context: http://dovecot.2317879.n4.nabble.com/Dovecot-error-wuth-MySQL-tp40765.html > Sent from the Dovecot mailing list archive at Nabble.com. >looks like your mysql server was not reachable Best Regards MfG Robert Schetterer -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstra?e 15, 81669 M?nchen Sitz der Gesellschaft: M?nchen, Amtsgericht M?nchen: HRB 199263 Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer Aufsichtsratsvorsitzender: Joerg Heidrich
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=192.168.100.31, > lip=190.128.232.2, 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 helpThe 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. __________________________________________________________________