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
Re: [vchkpw] vlog and mysql
truncate table Itamar Reis Peixoto e-mail: [EMAIL PROTECTED] msn: [EMAIL PROTECTED] skype: itamarjp icq: 81053601 +55 34 3238 3845 +55 11 4063 5033 - Original Message - From: Remo Mattei [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Tuesday, November 28, 2006 3:04 AM Subject: [vchkpw] vlog and mysql Hello guys, I guess I never paid to much attention on this (vlog and mysql) but it looks like it's getting big.. what's the best way to drop them? Any suggestions? Thanks, Remo
[vchkpw] vlog and mysql
Hello guys, I guess I never paid to much attention on this (vlog and mysql) but it looks like it's getting big.. what's the best way to drop them? Any suggestions? Thanks, Remo
Re: [vchkpw] vlog and mysql
Ok I found that sorry.. never mind... thanks Remo Mattei wrote: Hello guys, I guess I never paid to much attention on this (vlog and mysql) but it looks like it's getting big.. what's the best way to drop them? Any suggestions? Thanks, Remo !DSPAM:456bc357116211806120903!
[vchkpw] vlog Table
Hi everyone, I have qmail + vpopmail + mysql on a red hat 8.0, the thing is that i don't want to save all the logs in vlog table in mysql, is this possible ?. Thank you a lot. Lucas G. ObredorSistemas DivisiĆ³n Banda AnchaTel. 4469-7477 Int. ( 2130 )
Re: [vchkpw] vlog Table
On Tuesday 19 October 2004 08:28 am, Lucas G. Obredor wrote: Hi everyone, I have qmail + vpopmail + mysql on a red hat 8.0, the thing is that i don't want to save all the logs in vlog table in mysql, is this possible ?. vlog is not enabled by default. Recompile vpopmail without it enabled. you can view how you configured your vpopmail by looking at config.log (newer versions) or config.status (older versions) -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 815.776.9465 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail GnuPG Key ID: 481BF7E2 ++ scriptkitchen.com/kitchen.asc pgpA6mV8F23Ec.pgp Description: PGP signature
Re: [vchkpw] VLOG....aaarrrrrggggg!!!!
On Tuesday 13 April 2004 11:57 am, Peter Morin wrote: Just curious. My VLOG has grown to over a gig..is there a more elegant way to rotating this than the normal delete vlog? Has anyone scripted this? err? Perhaps you posted to the wrong mailing list by accident? -Jeremy -- Jeremy Kitchen Systems Administrator [EMAIL PROTECTED] Kitchen @ #qmail on EFNet - Join the party! . Inter7 Internet Technologies, Inc. www.inter7.com 866.528.3530 toll free 847.492.0470 int'l 847.492.0632 fax GNUPG key ID: 93BDD6CE
Re: [vchkpw] VLOG....aaarrrrrggggg!!!!
- Original Message - From: Jeremy Kitchen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:22 AM Subject: Re: [vchkpw] VLOGaaarg On Tuesday 13 April 2004 12:12 pm, Peter Morin wrote: [fixed broken quoting, please fix your MUA] Just curious. My VLOG has grown to over a gig..is there a more elegant way to rotating this than the normal delete vlog? Has anyone scripted this? I guess I don't know what you're talking about when you talk about 'vlog' vpopmail I believe logs to syslog, and if you're having syslog issues you should be asking either your OS vendor, or the list of the system logger you're running. If there's something else you're talking about, perhaps you could expand on your original question to let us know exactly what you're talking about. I would dare to guess he is talking about loging to the MySQL database not to syslog. -John
RE: [vchkpw] VLOG....aaarrrrrggggg!!!!
Well people who use mysql, know from the first time what you were talking about. The reaction of the unknown seems a bit offense Don't think there is some otherway then just write a delete script, and put it in cron or somthing similair. Greetings, Bas At 19:36 4/13/2004, you wrote: Sorry for the confusion Jeremy. I am using VPOPMAIL with the MySQL database option. The vlog table (--enable-mysql-logging) allows to maintain the vpopmail's vlog table in MySQL (shows failed authentication requests). MySQL and VPOPMAIL - http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm Cheers, peter -Original Message- From: Jeremy Kitchen [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 2:22 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] VLOGaaarg On Tuesday 13 April 2004 12:12 pm, Peter Morin wrote: [fixed broken quoting, please fix your MUA] Just curious. My VLOG has grown to over a gig..is there a more elegant way to rotating this than the normal delete vlog? Has anyone scripted this? Perhaps you posted to the wrong mailing list by accident? Is this not the list for vpopmail issues? I guess I don't know what you're talking about when you talk about 'vlog' vpopmail I believe logs to syslog, and if you're having syslog issues you should be asking either your OS vendor, or the list of the system logger you're running. If there's something else you're talking about, perhaps you could expand on your original question to let us know exactly what you're talking about. -Jeremy -- Jeremy Kitchen Systems Administrator [EMAIL PROTECTED] Kitchen @ #qmail on EFNet - Join the party! . Inter7 Internet Technologies, Inc. www.inter7.com 866.528.3530 toll free 847.492.0470 int'l 847.492.0632 fax GNUPG key ID: 93BDD6CE
Re: [vchkpw] VLOG....aaarrrrrggggg!!!!
On Apr 13, 2004, at 10:47 AM, Bastiaan van der Put wrote: Don't think there is some otherway then just write a delete script, and put it in cron or somthing similair. Hopefully you can write it as a script that sends an SQL command to MySQL to have it delete log entries more than x days old. That's a lot cleaner than deleting the database file out from under MySQL. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] VLOG....aaarrrrrggggg!!!!
Yes, your best bet would be periodically issue an SQL command such as DELETE FROM vlog WHERE timestamp whateverdate Also note that vpopmail v5.3.14 used to log all auth requests (successful and fails) to vlog, which resulted in that table growing very big very fast 5.3.14 and later included a fix so that the amount of detail logged to vlog would be controlled by the --enable-logging= configure switch In most cases, you would only want to log auth failures, so make sure you have set --enable-logging=p Michael. - Original Message - From: Peter Morin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 3:36 AM Subject: RE: [vchkpw] VLOGaaarg Sorry for the confusion Jeremy. I am using VPOPMAIL with the MySQL database option. The vlog table (--enable-mysql-logging) allows to maintain the vpopmail's vlog table in MySQL (shows failed authentication requests). MySQL and VPOPMAIL - http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm Cheers, peter -Original Message- From: Jeremy Kitchen [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 2:22 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] VLOGaaarg On Tuesday 13 April 2004 12:12 pm, Peter Morin wrote: [fixed broken quoting, please fix your MUA] Just curious. My VLOG has grown to over a gig..is there a more elegant way to rotating this than the normal delete vlog? Has anyone scripted this? Perhaps you posted to the wrong mailing list by accident? Is this not the list for vpopmail issues? I guess I don't know what you're talking about when you talk about 'vlog' vpopmail I believe logs to syslog, and if you're having syslog issues you should be asking either your OS vendor, or the list of the system logger you're running. If there's something else you're talking about, perhaps you could expand on your original question to let us know exactly what you're talking about. -Jeremy -- Jeremy Kitchen Systems Administrator [EMAIL PROTECTED] Kitchen @ #qmail on EFNet - Join the party! . Inter7 Internet Technologies, Inc. www.inter7.com 866.528.3530 toll free 847.492.0470 int'l 847.492.0632 fax GNUPG key ID: 93BDD6CE
Re: [vchkpw] VLOG....aaarrrrrggggg!!!!
On Apr 13, 2004, at 4:22 PM, Michael Bowe wrote: Yes, your best bet would be periodically issue an SQL command such as DELETE FROM vlog WHERE timestamp whateverdate This should work as well: DELETE FROM vlog WHERE timestamp DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY) -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] VLOG....aaarrrrrggggg!!!!
On Tue, 13 Apr 2004, Tom Collins wrote: On Apr 13, 2004, at 4:22 PM, Michael Bowe wrote: Yes, your best bet would be periodically issue an SQL command such as DELETE FROM vlog WHERE timestamp whateverdate This should work as well: DELETE FROM vlog WHERE timestamp DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY) On 5.3.x, timestamp is in unix timestamp format, so you'll need something like DELETE FROM vlog WHERE timestamp unixtime_where_you_want_to_delete_from. Is using a MySQL DATETIME type new in 5.4.x? Thanks, C -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] VLOG....aaarrrrrggggg!!!!
On Apr 13, 2004, at 6:01 PM, Charles Sprickman wrote: DELETE FROM vlog WHERE timestamp DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY) On 5.3.x, timestamp is in unix timestamp format, so you'll need something like DELETE FROM vlog WHERE timestamp unixtime_where_you_want_to_delete_from. Is using a MySQL DATETIME type new in 5.4.x? My mistake. I was taking code from something else. Perhaps this would work better: DELETE FROM vlog WHERE timestamp (UNIX_TIMESTAMP() - (7 * 24 * 60 * 60)) Replace the 7 with the number of days of entries you want to keep. This is totally untested, and based on documentation I just read at dev.mysql.com. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
[vchkpw] vlog
Hi! I have vpopmail with MySQL support and I am logging messages to database vpopmail and table vlog. I cleared logs by 'delete from vlog;'. Now vpopmail stopped writing anything to vlog or it can`t write anythinf to vlog. Could you please explain it to and help me? Thanks! -- Maciej Nadolski Intelinet Administrator Say hello to us ;)
[vchkpw] vlog
I did 'delete from vlog;' many timeas earlyer and everything was ok... -- Maciej Nadolski Intelinet Administrator Say hello to us ;)