Bugzilla Bug 30642

I installed qmail, courier-imap, and vpopmail for virtual e-mail hosting. 
vpopmail-5.2.1-r5 worked fine, however when I upgraded to vpopmail-5.2.1-r7
e-mail stopped being delivered.  I looked at /var/log/qmail/qmail-send/current
and noticed the following error:

delivery 1: deferral:
could_not_connect_to_mysql_update_server_Access_denied_for_user:_'root@localhost'_(Using_password:_YES)_with_database/could_not_connect_to_mysql_update_server_Access_denied_for_user:_'root@localhost'_(Using_password:_YES)/

I was still able to add users and domains and see them being updated in the
MySQL database.  Also, I noticed that the username it mentioned in the error is
root, however the user in /etc/vpopmail.conf is vpopmail.  It seems the
vdelivermail application is not successfully using the mysql config file patch
for vpopmail.  I downloaded vpopmail-5.2.1, applied all patches but that patch,
manually set the database info in vmysql.h, used the following config options
(copied from the config used in the ebuild for vpopmail-5.32.1-r7):

./configure  --prefix=/usr --host=i686-pc-linux-gnu --mandir=/usr/share/man
--infodir=/usr/share/info --datadir=/usr/share --sysconfdir=/etc
--localstatedir=/var/lib --enable-ip-alias-domains=n --enable-mysql=y
--enable-libs=/usr/include/mysql --enable-sqllibdir=/usr/lib/mysql
--enable-mysql-logging=y --enable-auth-logging=y --enable-valias=y
--enable-mysql-replication=n --enable-clear-passwd=y --sbindir=/usr/sbin
--bindir=/usr/bin --sysconfdir=/var/vpopmail/etc --enable-qmaildir=/var/qmail
--enable-qmail-newu=/var/qmail/bin/qmail-newu
--enable-qmail-inject=/var/qmail/bin/qmail-inject
--enable-qmail-newmrh=/var/qmail/bin/qmail-newmrh --enable-vpopuser=vpopmail
--enable-many-domains=y --enable-vpopgroup=vpopmail --enable-file-locking=y
--enable-file-sync=y --enable-md5-passwords=y
--enable-defaultquota=30000000,1000C --enable-roaming-users=y
--enable-relay-clear-minutes=60 --enable-tcprules-prog=/usr/bin/tcprules
--enable-tcpserver-file=/etc/tcp.smtp --enable-logging=y --enable-log-name=vpopmail

then did a make, make install-strip and manually setup the cron job.  After
doing that everything is working fine.  To the best of my knowledge the problem
is isolated down to the /usr/portage/distfiles/vpopmail-5.2.1-mysql.diff patch
not working for vdelivermail.
Here are my use flags and I do not have unstable enabled or anything in
/usr/local/portage

USE="apache2 berkdb clearpasswd crypt curl doc flash gd gdbm gpm imap ldap
maildir mcal memlimit mysql ncurses pam perl postgres python readline samba snmp
ssl tcltk tiff usb xml xml2 zlib -alsa -cups -gnome -gtk -kde -motif -X"

This was all done after doing an emerge sync and emerge -u world and was done on
the evening of Oct 7th.

Reproducible: Always
Steps to Reproduce:
1. install qmail (emerge qmail)
2. install vpopmail (emerge vpopmail)
3. install courier-imap (emerge courier-imap)
4. add a domain (vadddomain test.com)
5. add an account (adduser test@test.com)
6. send mail to the new user

Actual Results:  
The mail was not delivered and the above error was in
/var/log/qmail/qmail-send/current

Expected Results:  
delivered the mail to the user

I had apache2 and bind running as well.  I did have a proper /etc/tcp.smtp file
setup.  I can repeatedly uninstall qmail, vpopmail, courier-imap, delete
/var/qmail, /var/vpopmail, /var/log/qmail, /etc/vpopmail.conf, and
/etc/courier-imap and re-install everything from scratch and I have the same
exact error.

I forgot my emerge info:
Portage 2.0.49-r3 (default-x86-1.4, gcc-3.2.3, glibc-2.3.2-r1, 2.4.22)
=================================================================
System uname: 2.4.22 i686 Pentium III (Coppermine)
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CFLAGS="-mcpu=pentium3 -O3 -pipe"
CHOST="i686-pc-linux-gnu"
COMPILER="gcc3"
CONFIG_PROTECT="/etc /var/qmail/control /usr/share/config /usr/kde/2/share/config
/usr/kde/3/share/config /var/bind /usr/X11R6/lib/X11/xkb"
CONFIG_PROTECT_MASK="/etc/gconf /etc/afs/C /etc/afs/afsws /etc/env.d"
CXXFLAGS="-mcpu=pentium3 -O3 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="sandbox ccache autoaddcvs"
GENTOO_MIRRORS="ftp://ftp.gtlib.cc.gatech.edu/pub/gentoo ftp://ftp.ussg.iu.edu/pub/linux/gentoo
ftp://mirror.iawnet.sandia.gov/pub/gentoo/ ftp://sunsite.ualberta.ca/pub/unix/Linux/gentoo/
http://cs.ubishops.ca/pub/gentoo http://csociety-ftp.ecn.purdue.edu/pub/gentoo/
http://sunsite.ualberta.ca/pub/unix/Linux/gentoo/ http://www.ibiblio.org/gentoo
"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY=""
SYNC="rsync://rsync.us.gentoo.org/gentoo-portage"
USE="x86 oss apm arts avi encode foomaticdb gif imlib jpeg libg++ mad mikmod
mmx mpeg nls oggvorbis pdflib png quicktime sdl spell svga truetype xmms
xv slang java tcpd libwww qt opengl afs apache2 berkdb clearpasswd crypt
curl doc flash gd gdbm gpm imap ldap maildir mcal memlimit mysql ncurses
pam perl postgres python readline samba snmp ssl tcltk tiff usb xml xml2
zlib -alsa -cups -gnome -gtk -kde -motif -X"

what permissions and owner/group is on your /etc/vpopmail.conf and what user
does your qmail-send start vpopmail as?

the file is owned by root.root and its permissions are 600

This was the problem. ;)
By chowning /etc/vpopmail.conf to vpopmail.vpopmail after emerging vpopmail
everything is working fine again.

Even though that should have been obvious to me it would be helpful if the
ebuild could do that when it creates the file.

fixed in CVS now.
proper permissions are asserted on the file in the new ebuild.

Thank you, I'm sure others will be silently happy when vpopmail continues
to work "out of the box."