Bugzilla Bug 126809

net-mail/vpopmail-5.4.13 starts, but for every login using courier-imap/authlib
with authvchkpw, it gets a "MySQL server has gone away" error in the syslog.
after discussing with vivo, and testing with one-thread in /etc/mysql/my.cnf,
things work again. issue seems to be related to the mysql server threading, I
would expect this issue to exist in 4.1 possibly as well as the 5.0.x tested
here.

Portage 2.1_pre6-r3 (default-linux/x86/2006.0, gcc-4.0.3, glibc-2.4-r0,
2.6.15-ck3-r1 i686)
=================================================================
System uname: 2.6.15-ck3-r1 i686 Pentium III (Coppermine)
Gentoo Base System version 1.12.0_pre16
ccache version 2.4 [enabled]
dev-lang/python:     2.3.5-r2, 2.4.2-r1
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r1
sys-devel/binutils:  2.16.1-r2
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r3
ACCEPT_KEYWORDS="x86 ~x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=pentium3 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3/share/config
/usr/share/config /var/bind /var/qmail/alias /var/qmail/control
/var/vpopmail/domains /var/vpopmail/etc"
CONFIG_PROTECT_MASK="/etc/gconf /etc/revdep-rebuild /etc/terminfo /etc/env.d"
CXXFLAGS="-O2 -march=pentium3 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig ccache distlocks fixpackages metadata-transfer nostrip
sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org
http://distro.ibiblio.org/pub/linux/distributions/gentoo"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://ftp.cc.swin.edu.au/gentoo-portage"
USE="alsa apache2 apm avi bash-completion berkdb bitmap-fonts bzip2 calendar
cli crypt ctype cups curl dba debug dhcp divx4linux dri dv dvb dvd dvdread eds
eix emboss encode esd exif expat extraengine fam fastbuild ffmpeg foomaticdb
force-cgi-redirect fortran ftp gd gdbm gif gpm gstreamer hash imap imlib innodb
ipv6 jabber jpeg kerberos ldap libclamav libg++ libwww logrotate mad maildir
mcal memlimit mhash mikmod mmx motif mp3 mpeg mysql mysqli ncurses nls nptl
nptlonly ogg pam pcntl pcre pdflib perl pic pie png posix postgres python
quicktime radius readline samba sdl session simplexml snmp soap sockets spell
spl sqlite ssl tcpd tidy tiff tokenizer truetype truetype-fonts type1-fonts
udev unicode usb userlocales utf8 v4l vhosts vorbis wddx x86 xml xml2 xmlrpc
xmms xsl xv xvid zaptel zlib elibc_glibc kernel_linux userland_GNU"
Unset:  ASFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, LANG, LC_ALL, LDFLAGS, LINGUAS

btw, forgot to note, using dev-db/mysql-5.0.19 for testing here.

Seeing the same thing with MythTV here. The one-thread thing doesn't seem to
work for mythtv though. It wedges waiting for the second thread to connect and
do something useful as far as I can tell. I've downgraded to 4.0.26 for now.
I'll see if that works any better (I'm using an old 4.0.26 package I had, so
any ebuild changes won't affect it hopefully).

Created an attachment (id=95625) [edit]
vpopmail patch to resolve mysql timeout problem

I found this patch on the vpopmail mailing list
(http://www.mail-archive.com/vchkpw@inter7.com/msg23758.html). I applied it to
vpopmail-5.4.16 ebuild on my server and it resolved the "mysql server has gone
away" problem when using mysql 5. The patch has already been merged into
vpopmail-5.4.17, which is the latest development release on sourceforge
(http://sourceforge.net/project/showfiles.php?group_id=85937), though I haven't
tested that version yet.

good to hear, ill give it a test soon myself. thanks.

I'm still having this problem with "mysql has gone away" on vpopmail 5.4.17.

Using Gentoo hardened.

Don't see what are you requesting here from MySQL folks; the patch is for
vpopmail, so apply it.

5.4.19 is in portage now. please test and reopen if it doesn't solve the
connection issues