search for: vmysql

Hi all, I'm facing this error: dovecot: auth(default): vmysql: sql error[3]: MySQL server has gone away I've been reading this list archives and seems to be a resolved issue (back to 2005), so dovecot should just reconnect but it does not so. I'm using dovecot 1.1.3 with vpopmail 5.4.25 with this configuration: # 1.1.3: /usr/local/etc/dovecot.conf l...

I keep getting these messages in the log: @4000000044f1db7732acaddc dovecot: Error: auth(default): vmysql: sql error[3]: MySQL server has gone away I see that at least one user has the same problem: http://www.mail-archive.com/vchkpw at inter7.com/msg23311.html Unfortunately, no solution is given. I also found the MySQL Problems page on the wiki, but the issues are supposed to be resolved for m...

...H 1 PLAIN service=POP3 lip=81.xx.xx.xx rip=81.xx.xx.xx resp= dovecot: Dec 15 12:12:11 Info: auth(default): client out: CONT 1 dovecot: Dec 15 12:12:11 Info: auth(default): client in: CONT 1 AGRhbmlAbGludXhzb2x1dGlvbnMfgucm8AcG9jcG9j dovecot: Dec 15 12:12:11 Error: auth(default): vmysql: sql error[3]: MySQL server has gone away dovecot: Dec 15 12:12:11 Info: auth(default): vpopmail(dani@domain.com,81.xx.xx.xx): unknown user dovecot: Dec 15 12:12:12 Info: auth(default): client out: FAIL 1 user=dani@domain.com dovecot: Dec 15 12:12:12 Info: auth(default): client in: AUTH 2 PL...

Hi all, I'm having an intermittent problem logging users in through a webmail client (RoundCube). My maillog reports this: auth(default): vmysql: sql error[3]: MySQL server has gone away imap-login: Disconnected: user=<sales at coppersinkdepot.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured The MySQL server hasn't gone anywhere, I can log into it fine and other apps report no problems with it. Restarting Dovecot fixes...

...AUTH 1 PLAIN service=POP3 lip=81.18.x.x rip=81.18.x.x resp= dovecot: Jan 31 14:51:28 Info: auth(default): client out: CONT 1 dovecot: Jan 31 14:51:28 Info: auth(default): client in: CONT 1 AGRhbmlAbGlgudXhzb2x1fdGlvbnMucmh8AcG9jcG9j dovecot: Jan 31 14:51:28 Error: auth(default): vmysql: sql error[3]: MySQL server has gone away dovecot: Jan 31 14:51:28 Info: auth(default): vpopmail(dani@domain.ro,81.18.x.x): unknown user dovecot: Jan 31 14:51:29 Info: auth(default): client out: FAIL 1 user=dani@domain.ro dovecot: Jan 31 14:51:29 Info: auth(default): client in: AUTH 2 PLAIN...

...client in: AUTH 1 PLAIN service=POP3 lip=81.x.x.x rip=81.x.x.x resp= dovecot: Dec 18 03:42:08 Info: auth(default): client out: CONT 1 dovecot: Dec 18 03:42:08 Info: auth(default): client in: CONT 1 AGRhbmlAbGludXhzb2x1dGlvbnMucm8AcG9jcG9j dovecot: Dec 18 03:42:08 Error: auth(default): vmysql: sql error[3]: MySQL server has gone away dovecot: Dec 18 03:42:08 Info: auth(default): vpopmail(dani@domain,81.x.x.x): unknown user dovecot: Dec 18 03:42:09 Info: auth(default): client out: FAIL 1 user=dani@domain dovecot: Dec 18 03:42:09 Info: auth(default): client in: AUTH 2 PLAIN servic...

...it (both for user's sake and to have a decent webmail), so I decided to install dovecot (it certainly does its work on my home box). Problem is: I haven't had success with authentication. At first I tried the most obvious: using the vpopmail backend. Unfortunately I received lots of "vmysql: MySQL server has gone away" just like in http://article.gmane.org/gmane.mail.imap.dovecot/10321 So I decided to spice up a query to vpopmail's MySQL table, and there another problem was waiting for me: "Access denied" just like in this thread http://article.gmane.org/gmane.mai...

...gt;> > > > tar xzvf vpopmail* cd vpopmail_folder su groupadd -g 89 vchkpw useradd -g vchkpw -u 89 -d /var/vpopmail vpopmail mkdir /var/vpopmail create vpopmail database and vpopmail user in Mysql (update, delete, create, alter, drop, index..) adjust the vpomail sql cofig file: vi vmysql.h provided Mysql is installed in /usr/local/mysql: ./configure --enable-mysql=y --enable-sqlincdir=/usr/local/mysql/include/mysql/ --enable-sqllibdir=/usr/local/mysql/lib/mysql/ --enable-incdir=/usr/local/mysql/include/mysql/ --enable-libdir=/usr/local/mysql/lib/mysql/ --enable-clear-passwd=n --e...