Re: [vchkpw] vchkpw with mysql

2004-08-24 Thread Dave Goodrich
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. Othe

Re: [vchkpw] vchkpw with mysql

2004-08-24 Thread Brian
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, Au

Re: [vchkpw] vchkpw with mysql

2004-08-24 Thread Dave Goodrich
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/

Re: [vchkpw] vchkpw with mysql

2004-08-24 Thread Brian
current my settings on my debian host key_buffer= 16M max_allowed_packet = 1M that's the only places where I can change something .. right to change this? I'm not a mysql professional :-( thanx for your help, Brian - Original Message - From: "Dave Goodrich" <[EMAIL PROTE

Re: [vchkpw] vchkpw with mysql

2004-08-24 Thread Dave Goodrich
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, i

[vchkpw] vchkpw with mysql

2004-08-24 Thread Brian
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 d

[vchkpw] vadddomain irregularities.

2004-08-24 Thread shadowplay.net
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

Re: [vchkpw] Re: MySQL logging

2004-08-24 Thread Tom Collins
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 th

Re: [vchkpw] Migration

2004-08-24 Thread Simon
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

Re: [vchkpw] Re: MySQL logging

2004-08-24 Thread Richard A . Secor
If the script is set to only be readable and executable by root then it shouldn't be too big of a problem unless you really have that many people with root access. There is no where that I know of in vpopmail to automatically keep tabs on the amount of records in the vlog table. That's why I h

Re: [vchkpw] Migration

2004-08-24 Thread Dave Goodrich
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 al

[vchkpw] Re: MySQL logging

2004-08-24 Thread Maurice Snellen
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 th

Re: [vchkpw] MySQL logging

2004-08-24 Thread Richard A . Secor
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 thi

RE: [vchkpw] smtp-submit support version and patch

2004-08-24 Thread Dave
>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

[vchkpw] MySQL logging

2004-08-24 Thread Maurice Snellen
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