[vchkpw] MySQL logging
Listmembers: I've got sql logging enabled on my server and recently noticed that this leads to a rather large table and there doesn't seem to be a utility or command to clear the logging table given a timeframe of log that should be kept, like with logrotate. Have I overlooked something? What are others who have sql logging enabled using to keep the size of this table within acceptable limits. -- Greetings, Maurice
RE: [vchkpw] smtp-submit support version and patch
On Aug 23, 2004, at 5:26 PM, Dave wrote: Give that the mail systems on these machines are rock solid from a stability perspective, and have had multiple tweaks and other patches made to accompanying packages since installation, not to mention the database format changes for some of the older versions that would be required in the case of an upgrade, I would prefer a diff or patch to insert this functionality into the existing vchkpw code. I can then manually create a patch, or edit the appropriate files and recompile. Here's what you're looking for: http://cvs.sourceforge.net/viewcvs.py/vpopmail/vpopmail/vchkpw.c? r1=1.6r2=1.8 or, a simpler patch from an earlier release that just covers the port 587 stuff: http://cvs.sourceforge.net/viewcvs.py/vpopmail/vpopmail/vchkpw.c? r1=1.3r2=1.4 perfect, will play with this to start. The CVS interface on SourceForge should help you craft custom patches and be selective with what to include and not include. If your CRAM-MD5 auth isn't working properly, be sure to apply the vchkpw patch from between 1.9 and 1.10. It makes vchkpw's CRAM-MD5 compatible with the latest SMTP AUTH patches (which follow a standard protocol for passing information between qmail-smtpd and vchkpw). Will look into it. If you're using MySQL as a backend though, I highly recommend you go through the painful process of upgrading to 5.4.6 as it has numerous bug fixes over the 5.3.x releases, and closes an SQL-injection vulnerability. It should be an easy upgrade from the 5.3.x servers, I got involved with vpopmail well after 4.9.10, so I don't know much about that release. There were some structural changes in the mysql tables some time back, which has been one of the reasons(excuses) to avoid the upgrade. Bottom line is we are waiting for a security/functionality issue that isn't so easy to implement a patch which will leave us with no choice but to upgrade, or stability becomes affected with all the patches. Thanks for the link. Dave
Re: [vchkpw] MySQL logging
Have you thought of writing a script in perl and run it in the crontab? Richard A. Secor [EMAIL PROTECTED] Sequential Logic http://www.seqlogic.com/ +1.914.494.0751 On Aug 24, 2004, at 06:11, Maurice Snellen wrote: Listmembers: I've got sql logging enabled on my server and recently noticed that this leads to a rather large table and there doesn't seem to be a utility or command to clear the logging table given a timeframe of log that should be kept, like with logrotate. Have I overlooked something? What are others who have sql logging enabled using to keep the size of this table within acceptable limits. -- Greetings, Maurice
[vchkpw] Re: MySQL logging
On Tuesday, August 24, 2004 at 08:42 (which was Tuesday, August 24, 2004 at 14:42 where I am) Richard A. Secor wrote: Have you thought of writing a script in perl and run it in the crontab? I have (although not specifically in perl), but that would require directly interfacing with MySQL and thus exposing the user/password combination in yet another place. This is why I was looking for a more 'formal' way to solve this. -- Greetings, Maurice PS: please trim quotes to context.
Re: [vchkpw] Migration
Are you using MySQL? We have done this twice, in the middle of the second migration now. If you have a lot of domains (over 100) getting the moved domains into the proper split is a concern. Example, you have 101 domains, domain 99.com is in /home/vpopmail/domains/99.com. But your new server already has 20 domains. When you add domain 99.com it will be in /home/vpopmail/domains/0/99.com. See the problem? All your paths in vpasswd, assign, possibly your .qmail files will be wrong. If you can script the edit process on assign, virtualdomains, morercpthosts, .qmail files, it is not too bad. This is what I have done both times. My recommended processes if you don't have that many users/domains is to simply add the domains and users to the new system, point your DNS there. Once you confirm the new system is working then move the mail files over to their new home. This can be done easily by mounting the domains directory from the old server to the new server and copying the Maildir contents from the old Maildir to the new Maildir. Keep in mind, vpopmail doesn't care what you do, the issue (if you don't use MySQL) is qmail. Keep thinking what you have to accomplish to make qmail happy and vpopmail will work just fine. I have found vuserinfo, vadduser, vadddomain, vmoduser, vpasswd to be very happy run from a script. DAve Simon wrote: Hello everyone, I am presently running. vpopmail 5.2.1 with qmailadmin 1.0.6. I have just built a new box running vpopmail 5.4.0 and qmailadmin 1.2.0. The new box is running without a problem. I would like to move my current domains to the new box. I was planning on tarballing the domains folder and then untarballing it on the new machine. I assume that its not this simple any help would be appreciated. Simon -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
Re: [vchkpw] Migration
Wanted to thank everyone for their help. I tarred /home/vpopmail/domains updated the assign file and so far everything is working smoothly. I'll keep you posted on how it goes. Thanks again. Simon - Original Message - From: Dave Kettmann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 23, 2004 3:57 PM Subject: RE: [vchkpw] Migration -Original Message- From: Jacob S. [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 2:44 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] Migration (quoting fixed) On Mon, 23 Aug 2004 14:35:27 -0500 Dave Kettmann [EMAIL PROTECTED] wrote: -Original Message- From: Simon [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 2:08 PM To: [EMAIL PROTECTED] Subject: [vchkpw] Migration Hello everyone, I am presently running. vpopmail 5.2.1 with qmailadmin 1.0.6. I have just built a new box running vpopmail 5.4.0 and qmailadmin 1.2.0. The new box is running without a problem. I would like to move my current domains to the new box. I was planning on tarballing the domains folder and then untarballing it on the new machine. I assume that its not this simple any help would be appreciated. I believe this can work, but make sure that the path to ~vpopmail is the same on both servers. Also don't forget to copy your changes in /var/qmail/users/assign. It depends on how you are storing your passwords. I did a move from one machine to another (not sure what versions) and if qmailadmin and vpopmail are working fine on the new box, I had no problem just tarring up the mail structure (/home/vpopmail/*) and putting it on the new machine. Just dont forget to copy the passwords over :) I may be wrong in this, but it did seem to work for me. If I'm wrong .. someone please correct me. Don't you mean tarring the mail structure _/home/vpopmail/domains_? Simply tarring /home/vpopmail/* will will defeat his upgrade, as the vpopmail bin directory is part of what you just tarred. Yes, I did mean that, sorry to confuse anyone. :-) HTH, Jacob -- GnuPG Key: 1024D/16377135 Random .signature #57: Windows NT encountered the following error: The operation completed successfully.
Re: [vchkpw] Re: MySQL logging
On Aug 24, 2004, at 6:19 AM, Maurice Snellen wrote: Have you thought of writing a script in perl and run it in the crontab? I have (although not specifically in perl), but that would require directly interfacing with MySQL and thus exposing the user/password combination in yet another place. If the script is owned by vpopmail (or root), and run in the vpopmail (or root) crontab, then it would have permissions to read the ~vpopmail/etc/vpopmail.mysql file to get the password information. Even if you embedded it in the script, you could make the file readable only by root. -- 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] vadddomain irregularities.
hey all... im running 2 smtp qmail/vpopmail w/mysql servers with a shared via nfs mail directory (for the domains tree) I am having issues in adding additional domains I use ~vpopmail/bin/vadddomain to add the domain on the primary box. all qmail control files and the users files are all updated and the domain directory is created. I can then add users etc... with no issues. when I head over to the secondary box.. and do a vadddomain I receive the following error. Error. Failed while attempting to add domain to auth backend Error: no auth connection a vuserinfo of a user in the original domain from the secondary box makes no complaint at all in addition the ENTIRE domain directory that I just added and all users... is unlinked in the process... poof gone vanished... can someone explain the reasons for this? im assuming at this time that the best work arround is a manual modification of the qmail control files and the users files and then a qmailctl restart... however im curious as to why vadddomain would unlink a directory structure that was already in place...AND complain of no auth access the the db its been running off for the last month? but in the next shell command give me full userinfo pulled from the same database. kenneth gf brown
Re: [vchkpw] vchkpw with mysql
I have seen some similar issues with using vpopmail and MySQL. Most notably a failure to authenticate becasue MySQL doesn't respond correctly. Not sure if it was timing out or what. The solution was to give MySQL more resources over the default install. I upped my key, index, and table cache, increased my thread cache, now I have no problems. I use MySQL heavliy though, three cluster machines hitting it all day, plus spamassassin uses it as well. YMMV. DAve Brian wrote: Hello List, I have installed vpopmail with mysql-support. It's running well but sometimes my mail client ask about username and password. Error message is the user is not found. vpopmail[1003]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:99.99.99.99 The User exist in the database and next time it's running well again. someone know this problem? thanx, Brian -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
Re: [vchkpw] vchkpw with mysql
Brian wrote: current my settings on my debian host key_buffer= 16M max_allowed_packet = 1M that's the only places where I can change something .. Where is this? /etc/my.cnf? There are a lot of tunable vars that can be set in your my.cnf file. Look in your MySQL source, maybe in /usr/local/share/mysql, there are some sample *.cnf files in there. A lot depends on how much memory your system has, and how much it is using. right to change this? I'm not a mysql professional :-( Sure, that is why it is there. Just make sure you know what you are changing, I'm no MySQL guru either. I would first get your bin log running and see what is going on with the mysql daemon. The select may not even be happening which is what I saw. http://dev.mysql.com/doc/mysql/en/Binary_log.html I'm no expert and may not be the best person to guide you through this ;^) DAve thanx for your help, Brian - Original Message - From: Dave Goodrich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 7:52 PM Subject: Re: [vchkpw] vchkpw with mysql I have seen some similar issues with using vpopmail and MySQL. Most notably a failure to authenticate becasue MySQL doesn't respond correctly. Not sure if it was timing out or what. The solution was to give MySQL more resources over the default install. I upped my key, index, and table cache, increased my thread cache, now I have no problems. I use MySQL heavliy though, three cluster machines hitting it all day, plus spamassassin uses it as well. YMMV. DAve Brian wrote: Hello List, I have installed vpopmail with mysql-support. It's running well but sometimes my mail client ask about username and password. Error message is the user is not found. vpopmail[1003]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:99.99.99.99 The User exist in the database and next time it's running well again. someone know this problem? thanx, Brian -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker! -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
Re: [vchkpw] vchkpw with mysql
Thanx for your help, I found sampels for smale, medium, large and huge systems. Now I have something to do ;-) in debian is it in /usr/share/doc/mysql-server/examples/ thanx, Brian - Original Message - From: Dave Goodrich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 8:33 PM Subject: Re: [vchkpw] vchkpw with mysql Brian wrote: current my settings on my debian host key_buffer= 16M max_allowed_packet = 1M that's the only places where I can change something .. Where is this? /etc/my.cnf? There are a lot of tunable vars that can be set in your my.cnf file. Look in your MySQL source, maybe in /usr/local/share/mysql, there are some sample *.cnf files in there. A lot depends on how much memory your system has, and how much it is using. right to change this? I'm not a mysql professional :-( Sure, that is why it is there. Just make sure you know what you are changing, I'm no MySQL guru either. I would first get your bin log running and see what is going on with the mysql daemon. The select may not even be happening which is what I saw. http://dev.mysql.com/doc/mysql/en/Binary_log.html I'm no expert and may not be the best person to guide you through this ;^) DAve thanx for your help, Brian - Original Message - From: Dave Goodrich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 7:52 PM Subject: Re: [vchkpw] vchkpw with mysql I have seen some similar issues with using vpopmail and MySQL. Most notably a failure to authenticate becasue MySQL doesn't respond correctly. Not sure if it was timing out or what. The solution was to give MySQL more resources over the default install. I upped my key, index, and table cache, increased my thread cache, now I have no problems. I use MySQL heavliy though, three cluster machines hitting it all day, plus spamassassin uses it as well. YMMV. DAve Brian wrote: Hello List, I have installed vpopmail with mysql-support. It's running well but sometimes my mail client ask about username and password. Error message is the user is not found. vpopmail[1003]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:99.99.99.99 The User exist in the database and next time it's running well again. someone know this problem? thanx, Brian -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker! -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
Re: [vchkpw] vchkpw with mysql
Brian wrote: Thanx for your help, I found sampels for smale, medium, large and huge systems. Now I have something to do ;-) No problem. I would suggest though if you are new to MySQL you first get vpopmail and qmail up and running, learn them and what they can do before you add MySQL auth. Other than ease of dealing with large numbers of users, there is no real advantage to using MySQL IMO. I found the standard vpopmail using cdb to very reliable, robust and quite fast. We only moved to MySQL auth to gain a better interface for user/domain management. DAve in debian is it in /usr/share/doc/mysql-server/examples/ thanx, Brian - Original Message - From: Dave Goodrich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 8:33 PM Subject: Re: [vchkpw] vchkpw with mysql Brian wrote: current my settings on my debian host key_buffer= 16M max_allowed_packet = 1M that's the only places where I can change something .. Where is this? /etc/my.cnf? There are a lot of tunable vars that can be set in your my.cnf file. Look in your MySQL source, maybe in /usr/local/share/mysql, there are some sample *.cnf files in there. A lot depends on how much memory your system has, and how much it is using. right to change this? I'm not a mysql professional :-( Sure, that is why it is there. Just make sure you know what you are changing, I'm no MySQL guru either. I would first get your bin log running and see what is going on with the mysql daemon. The select may not even be happening which is what I saw. http://dev.mysql.com/doc/mysql/en/Binary_log.html I'm no expert and may not be the best person to guide you through this ;^) DAve thanx for your help, Brian - Original Message - From: Dave Goodrich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 7:52 PM Subject: Re: [vchkpw] vchkpw with mysql I have seen some similar issues with using vpopmail and MySQL. Most notably a failure to authenticate becasue MySQL doesn't respond correctly. Not sure if it was timing out or what. The solution was to give MySQL more resources over the default install. I upped my key, index, and table cache, increased my thread cache, now I have no problems. I use MySQL heavliy though, three cluster machines hitting it all day, plus spamassassin uses it as well. YMMV. DAve Brian wrote: Hello List, I have installed vpopmail with mysql-support. It's running well but sometimes my mail client ask about username and password. Error message is the user is not found. vpopmail[1003]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:99.99.99.99 The User exist in the database and next time it's running well again. someone know this problem? thanx, Brian -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker! -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker! -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!