Re: [vchkpw] vlog has not entries since upgrade
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/10/2014 10:36 AM, John Stile wrote: I have not seen any new additions to the mysql table vlog for a long time, so I am worried an update broke something. I am using vpopmail-5.4.33-r1, mysql-5.5.40, and netqmail-1.06-r2 I tried to delete the vlong table and recreate from what I have read in the source file vpopmail-5.4.33/vmysql.c, but still no change. What could be happening? How can I debug this, when eveything runs though tcpserver? I am on gentoo, so I hope it is not too spam-ish to show my configure and build log: John, it's difficult to tell why it's not working from what you've sent along, but it sounds like it could be related to the deletion and re-creation of the table. Your best bet for debugging is going to be to strace/gdb a manually run qmail service that calls vpopmail. If you're not comfortable with that, you could try printf debugging. And lastly, if you're not comfortable with that, feel free to give us a call, and we can help you out. Good luck! - -- /* Matt Brookings m...@inter7.com GnuPG Key 62817373 Software developer Systems technician Inter7 Internet Technologies, Inc. (815)776-9465 */ -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.22 (GNU/Linux) iQEcBAEBAgAGBQJUiwgQAAoJEOjQVexigXNzKBwH/AgOWlCZNrPysL4kdTub9XjN 5XIrzqlyBR9CD1We3eIKGE4p7UY5sLg4vLOSDptZC0eOLlPb3E6V/1vIYWqJMXv5 H9F8tKgcSSwOAvc9rJdjPFH7r0hv46I3tfxlgM6u0VnUWAydf+Hx6DQ/ILvAsiDL kmlMe2i22d/TALYGjTSZi3JTfL9v+mYSyRRkaD4as3VTx3hhejgnfT7uXO6xNtRz +Rru7pLYFr0yRpCYaE/JaJNXojG+Kru8V5+4/nGjbD5wLrYbvZ6AtLM7SMcLw5Am MdSrGNXqXFEjH07xhaNXIgy5OW9CFiS7D6relrI/gaXWjM8gqAhNyrZBtnZkhaw= =JM35 -END PGP SIGNATURE-
[vchkpw] vlog has not entries since upgrade
I have not seen any new additions to the mysql table vlog for a long time, so I am worried an update broke something. I am using vpopmail-5.4.33-r1, mysql-5.5.40, and netqmail-1.06-r2 I tried to delete the vlong table and recreate from what I have read in the source file vpopmail-5.4.33/vmysql.c, but still no change. What could be happening? How can I debug this, when eveything runs though tcpserver? I am on gentoo, so I hope it is not too spam-ish to show my configure and build log: Emerging (1 of 1) net-mail/vpopmail-5.4.33-r1::gentoo * vpopmail-5.4.33.tar.gz SHA256 SHA512 WHIRLPOOL size ;-) ... [ ok ] * * Massive important warning if you are upgrading to 5.2.1-r8 or older * The internal structure of the mail storage has changed for * consistancy with the rest of Gentoo! Please review and utilize the * script at /bin/vpopmail-Maildir-dotmaildir-fix.sh * to upgrade your system! (It can do conversions both ways). * You should be able to run it right away without any changes. * * * Use of vpopmail's tcp.smtp[.cdb] is also deprecated now, consider * using net-mail/relay-ctrl instead. * * * If you are upgrading from 5.4.17 or older, you have to fix your * MySQL tables: * * ALTER TABLE `dir_control` CHANGE `domain` `domain` CHAR(96) NOT NULL; * ALTER TABLE `ip_alias_map` CHANGE domain domain CHAR(96) NOT NULL; * ALTER TABLE `lastauth` CHANGE domain domain CHAR(96) NOT NULL; * ALTER TABLE `valias` CHANGE domain domain CHAR(96) NOT NULL; * ALTER TABLE `vlog` CHANGE domain domain CHAR(96) NOT NULL; * ALTER TABLE `vpopmail` CHANGE domain domain CHAR(96) NOT NULL; * ALTER TABLE `limits` CHANGE domain domain CHAR(96) NOT NULL, * ADD `disable_spamassassin` TINYINT(1) DEFAULT 0 NOT NULL AFTER `disable_smtp`, * ADD `delete_spam` TINYINT(1) DEFAULT 0 NOT NULL AFTER `disable_spamassassin`; * * * Newer versions of vpopmail contain a quota daemon called vusaged. * This ebuild DOES NOT INSTALL vusaged and has therefore disabled * its usage in /etc/vusagec.conf. DO NOT ENABLE! * Otherwise mail delivery WILL BREAK * Unpacking source... Unpacking vpopmail-5.4.33.tar.gz to /var/tmp/portage/net-mail/vpopmail-5.4.33-r1/work Source unpacked in /var/tmp/portage/net-mail/vpopmail-5.4.33-r1/work Preparing source in /var/tmp/portage/net-mail/vpopmail-5.4.33-r1/work/vpopmail-5.4.33 ... * Applying vpopmail-5.4.9-access.violation.patch ... [ ok ] * Applying vpopmail-lazy.patch ... [ ok ] * Applying vpopmail-double-free.patch ... [ ok ] * Applying vpopmail-vpgsql.patch ... [ ok ] * Running eautoreconf in '/var/tmp/portage/net-mail/vpopmail-5.4.33-r1/work/vpopmail-5.4.33' ... * Running aclocal ... [ ok ] * Running autoconf ... [ ok ] * Running autoheader ... [ ok ] * Running automake --add-missing --copy --foreign --force-missing ... [ ok ] * Running elibtoolize in: vpopmail-5.4.33/ * Applying ltmain/1.5 patch ... * Applying portage/1.5.10 patch ... * Applying relink/1.4.1 patch ... * Applying sed/1.5.6 patch ... * Applying as-needed/1.5 patch ... * Running elibtoolize in: vpopmail-5.4.33/vusaged/ * Replacing obsolete head/tail with POSIX compliant ones * - fixed cdb/Makefile Source prepared. Configuring source in /var/tmp/portage/net-mail/vpopmail-5.4.33-r1/work/vpopmail-5.4.33 ... * Setting VPOP_HOME to: /var/vpopmail * econf: updating vpopmail-5.4.33/config.guess with /usr/share/gnuconfig/config.guess * econf: updating vpopmail-5.4.33/config.sub with /usr/share/gnuconfig/config.sub ./configure --prefix=/usr --build=x86_64-pc-linux-gnu --host=x86_64-pc-linux-gnu --mandir=/usr/share/man --infodir=/usr/share/info --datadir=/usr/share --sysconfdir=/etc --localstatedir=/var/lib --disable-dependency-tracking --disable-silent-rules --libdir=/usr/lib64 --enable-incdir=/usr/include/mysql