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 attachment 95625 [details, diff] 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
