the problem with the relaying is actually related to courier-imap.. if you configured vpopmail with --enable-mysql=y --enable-roaming-users=y then you are setup for mysql relaying.. i have tried the tcpserver patches and it seems to work although never really gets triggered.. (if you have an ipv4/ipv6 enabled imap server then the mysql enabled tcpserver is a pain in the rectum)
plain vpopmail-5.3.X series is ready to go in this department, however a patch needs to be applied to courier-imap. you can verify this by looking for the existence of a vpopmail.relay table.. if you have the table but no rows of data, all you are missing is the /var/qmail/control/sql file and the courier-imap patch.. roaming users with courier-imap was working up until the 1.53 series.. beyond that a patch is needed to remove a bunch of broken and misplaced ifdef's apply this patch to your courier-imap source tree and add "-DHAVE_OPEN_SMTP_RELAY -DHAVE_VLOGAUTH" to your CFLAGS when you compile it. it has been tested to work with up to courier-imap-2.01.tar.gz but should work with newer versions.. in the past on brand new installs this works to get roaming-user support pretty easily and not messing with cdb files.. let me know how it goes.. Nathan Goodman Unemployed Network Administrator Casualty of April 2003 Cutbacks ----- Original Message ----- From: Joseph Kacmarcik <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 11:14 PM Subject: [vchkpw] mysql relay table frustrations > hi list! > > so... i've read a number of posts, looked in a number of places, compiled > and recompiled numerous times, but i can't get qmail/vpopmail/courier on > linux to write to an sql relay table. everything works except this part. i > can authenticate and receive via pop or imap, and either over ssl. i can > send using webmail on the local system. > > i used the same patches and the same configure concoctions to compile the > same software on two different freebsd boxes and it works fine (please > don't ask why i don't just use the bsd boxes). > > so, here's my configure lines: > > no patches to vpopmail. i started with 5.3.23 and am on 5.3.27 now with > the same results > > /usr/local/src/vpopmail-5.3.27 > ./configure --enable-mysql=y --enable-roaming-users=y \ > --enable-defaultquota=1073741824S,100000C --enable-learn-passwords=y \ > --enable-logging=p --enable-mysql-logging=y --enable-qmail-ext=y > > no patches for courier imap. started with 2.1.1, am using 2.1.2 now. > > /usr/local/src/courier-imap-2.1.2 > ./configure --prefix=/usr/local --exec-prefix=/usr/local --without-authldap \ > --without-authshadow --with-authvchkpw --without-authcram \ > --sysconfdir=/usr/local/etc/courier-imap \ > --datadir=/usr/local/share/courier-imap \ > --libexecdir=/usr/local/libexec/courier-imap \ > --enable-workarounds-for-imap-client-bugs --disable-root-check \ > --without-authdaemon --with-redhat > > > my qmail-smtpd startup is: (variables are handled in the script) > exec softlimit -m 8000000 tcpserver -S -R -H -c100 -x > /usr/local/vpopmail/etc/tcp.smtp.cdb -u $QMAILUID -g $NOFILESGID 0 smtp > qmail-smtpd salo.chubbo.net /usr/local/vpopmail/bin/vchkpw /usr/bin/true > splogger smtpd > > have tried removing path to tcp.smtp.cdb too. > > /var/qmail/control/sql > server localhost > port 3306 > database vpopmail > table relay > user vpopmail > pass password > time 1800 > > ~vpopmail/etc/vpopmail.mysql > localhost|0|vpopmail|password|vpopmail > localhost|0|vpopmail|password|vpopmail > > i'm logging mysql traffic for debugging and i don't see any inserts into > the relay table, only selects and deletes (from cron). > > ucspi was patched with mr simerson's ucspi-tcp-0.88-mysql3+rss.patch > although i have tried ucspi-tcp-0.88-mysql+rss.patch with the same > results. > > i really hope i'm stupid this year and it's a simple thing, but i can't > figure it out. > > thoughts and helpful comments appreciated. > > thanks in advance! > joe > >
courier-imap-1.7.3-vpopmail.patch
Description: Binary data
