[vchkpw] mysql dir_control table

2004-07-16 Thread Dave Goodrich
Hello the list. We ahve been using vpopmail for over a year with no problems. We recently move to using mysql for auth and I am seeing a strange side effect. New users are no longer being created in the directory split but are all going to the domain root. We have one domain with 4557 users and

Re: [vchkpw] mysql dir_control table

2004-07-20 Thread Dave Goodrich
On Fri, Jul 16, 2004 at 11:28:46PM -0500, Dave Goodrich wrote: Hello the list. We ahve been using vpopmail for over a year with no problems. We recently move to using mysql for auth and I am seeing a strange side effect. New users are no longer being created in the directory split

[vchkpw] Who can tell me exactly how dir_control works?

2004-08-04 Thread Dave Goodrich
qmail 1.03 vpopmail 5.4.0 mysql 3.23.58 We had been using cdb and switched to using mysql auth when we moved our users to a new server. We ran vconvert on the domains and everything appeared to work fine. vpopmail.curr_users loaded with enormous numbers, level_curr loaded as zero. Adding new

Re: [vchkpw] Who can tell me exactly how dir_control works?

2004-08-06 Thread Dave Goodrich
14:59, Dave Goodrich wrote: I found little on the subject in Google, and fewer answers anywhere else. I have resorted to reading source code ( I don't program C ). The closest thing I have found is this, http://www.mail-archive.com/[EMAIL PROTECTED]/msg18607.html Though that URL is not responding

Re: [vchkpw] Who can tell me exactly how dir_control works?

2004-08-09 Thread Dave Goodrich
Michael Bowe wrote: - Original Message - From: Dave Goodrich [EMAIL PROTECTED] Mark Richardson wrote: snip I have looked at the dir hashing code before in an effort to try and understand it, but not being an expert C programmer, it makes my head spin In the mailing list archives

Re: [vchkpw] Who can tell me exactly how dir_control works?

2004-08-09 Thread Dave Goodrich
Dave Goodrich wrote: Michael Bowe wrote: - Original Message - From: Dave Goodrich [EMAIL PROTECTED] Mark Richardson wrote: snip I have looked at the dir hashing code before in an effort to try and understand it, but not being an expert C programmer, it makes my head spin In the mailing

Re: [vchkpw] ldap or mysql

2004-08-17 Thread Dave Goodrich
If you use MySQL I would highly recommend doing a clean install of all your domains and user information. Setup a new server and migrate using scripts to reload all domain/user info. An in place conversion has proven problematic for us with getting acurate dir_control information into MySQL.

Re: [vchkpw] questions on implementing/converting

2004-08-20 Thread Dave Goodrich
James Whitt wrote: I actually have two questions. The first one is if anybody has experience with converting a qmail system from vmailmgr to vpopmail. We have devised ways of doing it, but if anybody has already done it and has to do's/don'ts/pointers they came across I would appreciate it if

Re: [vchkpw] quotawarn....

2004-08-22 Thread Dave Goodrich
shadowplay.net wrote: has neone else had this issue? once again the issue is no removal of quotawarn messages Yes I have had this issue, and stopped quotawarn messages as a solution. The bigger issue for us was getting the maildirsize file to properly update sometimes. Currently we just go

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

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,

Re: [vchkpw] vchkpw with mysql

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

Re: [vchkpw] vchkpw with mysql

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

Re: [vchkpw] vchkpw with mysql

2004-08-25 Thread Dave Goodrich
, remote_ip=80.184.xxx.xx, timestamp=1093433217 It shows like the vpopmail try to create the database ... why ?? I try 10 times to recive my mail ... 9 are successfully. one time i have this problem.. cheers, brian - Original Message - From: Dave Goodrich [EMAIL PROTECTED] To: [EMAIL PROTECTED

[vchkpw] mysql and valias

2004-09-16 Thread Dave Goodrich
Good morning, I am happy to say that I think I understand how dir_control works in mysql. I do not understand the use of every field but the fields that have an effect I di understand. I will try to get something together in the next for anyone interested. My question, valias, anyone using it?

Re: [vchkpw] Recomendations for best spam rejection

2004-09-16 Thread Dave Goodrich
Andrew Niemantsverdriet wrote: I am doing a major upgrade to our mail server and I am looking for recommendations for programs and qmail patches to limit the amount of spam that gets through. What are you guys using that has great success? SpamAssassin without a doubt. Depending on how much

Re: [vchkpw] Recomendations for best spam rejection

2004-09-16 Thread Dave Goodrich
Andrew Niemantsverdriet wrote: I am doing a major upgrade to our mail server and I am looking for recommendations for programs and qmail patches to limit the amount of spam that gets through. What are you guys using that has great success? I forget to add we also use spamcop, but not in

Re: [vchkpw] Recomendations for best spam rejection

2004-09-16 Thread Dave Goodrich
Jan Lange wrote: Hi, how can I use SA global in qmail, with dropping of Mails that have more than 10 points of score? Lots of ways, .qmail-default file, qmailqueue replacements, custom scripts, ask the SpamAssassin list. I don't do that but I am sure others do. Http://www.spamassassin.org DAve

Re: [vchkpw] Recomendations for best spam rejection

2004-09-16 Thread Dave Goodrich
Jon LaBass wrote: snip Compile vpopmail with SPAM_THRESHOLD=10 and any message scored at 10.0 or above will not be delivered. Jon I just upgraded four servers this morning to 5.4.6, that is not a configure option that I know of. What vpopmail do you use? DAve -- Systems Administrator

Re: [vchkpw] Recomendations for best spam rejection

2004-09-17 Thread Dave Goodrich
Jon LaBass wrote: Jon LaBass wrote: snip Compile vpopmail with SPAM_THRESHOLD=10 and any message scored at 10.0 or above will not be delivered. Jon I just upgraded four servers this morning to 5.4.6, that is not a configure option that I know of. What vpopmail do you use? DAve Well, I use

Re: [vchkpw] Recomendations for best spam rejection

2004-09-17 Thread Dave Goodrich
Ken Jones wrote: On Friday 17 September 2004 09:02 am, Dave Goodrich wrote: Jon LaBass wrote: Jon LaBass wrote: snip Compile vpopmail with SPAM_THRESHOLD=10 and any message scored at 10.0 or above will not be delivered. Jon I just upgraded four servers this morning to 5.4.6

[vchkpw] Problems with pop auth after upgrade to mysql auth

2004-09-17 Thread Dave Goodrich
Since we changed to use mysql auth I have been getting complaints from users having to enter their password more than once. This is not consistant, it doesn't happen every time. It seems most prevelent for users of Eudora or old Outlook Express. Outlook, Netscape Mail, and Thunderbird do not

Re: [vchkpw] Recomendations for best spam rejection

2004-09-17 Thread Dave Goodrich
Jon LaBass wrote: snip Interested in knowing how well it works for you though. DAve -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker! It works quite well. I'm surprised you don't take advantage of the FreeBSD ports. Install vpopmail with the SA flags

Re: [vchkpw] Problems with pop auth after upgrade to mysql auth

2004-09-21 Thread Dave Goodrich
Dave Goodrich wrote: Since we changed to use mysql auth I have been getting complaints from users having to enter their password more than once. This is not consistant, it doesn't happen every time. It seems most prevelent for users of Eudora or old Outlook Express. Outlook, Netscape Mail

Re: [vchkpw] .dir-control - Please tell me this about it

2004-09-23 Thread Dave Goodrich
Brian Feeny wrote: Does the hashing that is used by .dir-control depend at all on the actual domain name? For example, if it came up with a hashed directory structure in which to put foobar.com, would it matter if I went in to /var/qmail/users/assign, and changed the name of the domain to

Re: [vchkpw] .dir-control - Please tell me this about it

2004-09-23 Thread Dave Goodrich
Brian Feeny wrote: On Sep 23, 2004, at 10:18 AM, Dave Goodrich wrote: Brian Feeny wrote: Does the hashing that is used by .dir-control depend at all on the actual domain name? For example, if it came up with a hashed directory structure in which to put foobar.com, would it matter if I went

Re: [vchkpw] .dir-control - Please tell me this about it

2004-09-23 Thread Dave Goodrich
domain with your old system and give it a try. I have been trying to get my arms around the dir-control issue for a while, though I don't code C, I don't think the hashing cares what your domain name is. DAve Brian On Sep 23, 2004, at 10:57 AM, Dave Goodrich wrote: Brian Feeny wrote: On Sep 23, 2004

Re: [vchkpw] what appears to be mysql errors inside.... and other questions

2004-09-23 Thread Dave Goodrich
Grimes, David wrote: Hello all, New user/abuser here... 1. Last night, due to a problem with a corporate mail server, my mail server got flooded with ~20k emails. It tried like heck to chew through them but the poor little machine just wasn't havin' it. My setup is a gentoo box running

Re: [vchkpw] Patch for problems with valiases and PostgreSQL/MySQL

2004-09-24 Thread Dave Goodrich
Tom Collins wrote: If you're using the valias table with PostgreSQL or MySQL, please take a look at the following patch: Possibly you would be the man to answer this question for me? http://www.mail-archive.com/[EMAIL PROTECTED]/msg19410.html I've read all the posts in the archive afterching on

Re: [vchkpw] The low-down on the valias feature

2004-09-24 Thread Dave Goodrich
Tom Collins wrote: On Sep 24, 2004, at 7:25 AM, Dave Goodrich wrote: I've read all the posts in the archive afterching on valias, a lot of posts, and I think my assumptions are correct. I would like to know if there are any limitations I should be aware of. --enable-valias configures vpopmail

Re: [vchkpw] .dir-control format

2004-09-24 Thread Dave Goodrich
Brian Feeny wrote: Can someone post the .dir-control format (the format of the file, and what each value represents)? This is a close as I have gotten, though I have not updated any further, it seems to be working fine. http://www.mail-archive.com/[EMAIL PROTECTED]/msg19052.html You might

Re: [vchkpw] chkuser 2.0

2004-10-14 Thread Dave Goodrich
Eric Ziegast wrote: Rick Macdougall asked I didn't see anything in the docs or change logs specifically regarding the mysql connection problem that sometimes crops up with vpopmail. Has this been addressed ? Antonio Nati replied: Yes, chkuser 2.0 includes a new call, vauth_open(), that Rick

Re: [vchkpw] Problems with pop auth after upgrade to mysql auth

2004-10-06 Thread Dave Goodrich
Dave Goodrich wrote: Chris Ess wrote: Dave Goodrich wrote: Since we changed to use mysql auth I have been getting complaints from users having to enter their password more than once. This is not consistant, it doesn't happen every time. It seems most prevelent for users of Eudora or old Outlook

Re: [vchkpw] Problems with pop auth after upgrade to mysql auth

2004-10-06 Thread Dave Goodrich
Dave Goodrich wrote: Dave Goodrich wrote: Also of note, I can see each user who is being re-prompted, /var/log/maillog shows these on each cluster machine. Oct 6 11:40:17 ecluster1 vpopmail[1748]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:68.254.88.126 Oct 6 11:40:19 ecluster1

Re: [vchkpw] Limits per owner

2004-10-06 Thread Dave Goodrich
Riccardo Bini wrote: Hi, It's possible to set limits (pop account) per unix user and not per domain?? An other question: i lost my dir_control table (mysql). I can recreate it but i dont know what the columns mean. I am struggling with this as well, though I have not been able to get back

Re: [vchkpw] email groups

2004-10-18 Thread Dave Goodrich
Bill Gradwohl wrote: I need the reciprocal of an alias (one user with many email ID's) in the form of a group (many users reachable individually via one email ID). The simplest solution would be to create .qmail-address_you_need and fill it with forwards to the address you want to recieve the

Re: [vchkpw] chkuser 2.0

2004-10-21 Thread Dave Goodrich
Tom Collins wrote: On Oct 19, 2004, at 8:14 PM, Charles Sprickman wrote: The one thing that kind of grabbed people's interest was the flood of connection dropped messages that mysql will log if I enable the log warnings option. On other mysql installations I can leave this on and I just see

Re: [vchkpw] Migrating all domains to a new box

2004-10-25 Thread Dave Goodrich
[EMAIL PROTECTED] wrote: Yes, i've searched there, but my situation is a bit different. I'll only migrate the ~vpopmail/domains dir to another machine. The database will be kept the same. When i do vdominfo any-domain.com i receive domains doesn't exists. I did some tests bringing only the domain

Re: [vchkpw] Fields' use?

2004-11-19 Thread Dave Goodrich
X-Istence wrote: On Nov 18, 2004, at 3:44 PM, Matthew Walker wrote: What are the pw_uid and pw_gid fields in the user info actually used for? I did a quick read through the docs, and couldn't find any information about what they do other than the fact that they're the user id and group id. Matthew

Re: [vchkpw] vdelivermail, user quotas and the maildirsize file

2004-12-03 Thread Dave Goodrich
[intentionaly top posted] You are my new hero Mr. Collins. If you are in or near central Indiana, my wife makes apple pie and vegetable soup that grown men will crawl through broken glass for, there are a few servings waiting for you. Can't wait to give it a try. DAve Tom Collins wrote: I've

[vchkpw] smtp auth

2005-01-28 Thread Dave Goodrich
Good morning, I find mysqlf in need of smtp auth for my users. I've looked at several bits online about it and I have a few questions for the list. qmail-1.03 as per qmail Handbook qmail-maildir++.patch qmail-0.0.0.0.patch vpopmail-5.4.8 (MySQL auth) FreeBSD 5.2.1 cat /service/qmail-smtpd/run

Re: [vchkpw] smtp auth

2005-01-30 Thread Dave Goodrich
Tom Collins wrote: On Jan 28, 2005, at 9:00 AM, Dave Goodrich wrote: 1) What is everyone else using? #!/bin/sh QMAILDUID=`id -u vpopmail` NOFILESGID=`id -g vpopmail` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` DENYMAIL=DNSCHECK export DENYMAIL LOCAL=`/usr/bin/head -1 /var/qmail/control

Re: [vchkpw] smtp auth

2005-02-04 Thread Dave Goodrich
Dave Goodrich wrote: Tom Collins wrote: On Jan 28, 2005, at 9:00 AM, Dave Goodrich wrote: snip Excellent, thank you. If I understand correctly I will also need to do nothing to my current tcp.smtp file? 3) How does this effect users who do not supply auth info? Does qmail-smtpd fall back

Re: [vchkpw] Removing a users mail directory with PHP?

2005-02-22 Thread Dave Goodrich
would work. Just a thought. DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

Re: [vchkpw] Spamassin configuration

2005-02-27 Thread Dave Goodrich
to do anything. If vdelivermail could call spamc with per user prefs, *and* deliver to a users spam box, I would be a happy camper. Mark me for willing to test any code. DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

Re: [vchkpw] Spamassin configuration

2005-02-28 Thread Dave Goodrich
the IMAP folder Spam to hold the messages tagged by spamc. That is how I had been planning to do it. Alternatively couldn't a env var be used? Change the var, change the delivery path relative to the users home dir. DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid

Re: [vchkpw] Spamassin configuration

2005-03-01 Thread Dave Goodrich
spamassassin/spamc/procmail/maildrop as before. DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

Re: [vchkpw] spamassassin development was spamassassin configuration

2005-03-03 Thread Dave Goodrich
allow spam tools other than SpamAssassin to be used. DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

Re: [vchkpw] spamassassin development was spamassassin configuration

2005-03-03 Thread Dave Goodrich
Dave Goodrich wrote: Ken Jones wrote: Charles J. Boening [EMAIL PROTECTED] said snip I also think spamc options should be stored in the same place. Currently the spamc options can be set on the configure line. We thought that would be a good place since the spamc options are site wide. I

[vchkpw] Inter7 listed in SORBS and SpamHaus?

2005-03-03 Thread Dave Goodrich
-- -- 0.1 FORGED_RCVD_HELO Received: contains a forged HELO 5.0 URIBL_SBL Contains an URL listed in the SBL blocklist [URIs: inter7.com] -- Dave Goodrich Systems Administrator http://www.tls.net Get rid

Re: [vchkpw] How to get local mail?

2005-03-03 Thread Dave Goodrich
-postmaster /var/qmail/alias/.qmail-mailer-daemon and [EMAIL PROTECTED] in, /var/qmail/alias/.qmail-nagios /var/qmail/alias/.qmail-mrtg Works for me. DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

RE: [vchkpw] Inter7 listed in SORBS and SpamHaus?

2005-03-03 Thread Dave Goodrich
URL is the message advertising, the score was based on Jeremy's signature. SURBL rocks. If could only have one anti-spam tool, it would be SURBL. http://www.surbl.org/ DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

Re: [vchkpw] vhostadmin development release

2005-03-08 Thread Dave Goodrich
follow the install doc and stop there, http://myserver.com/include/global.incopens the cookie jar. Where does one find the vpopmail daemon? I downloaded a fresh copy of 5.4.9 and the 5.5.0-devel and didn't see it. Checked in the contrib dir also. Thanks DAve -- Dave Goodrich Systems

Re: [vchkpw] vhostadmin development release

2005-03-08 Thread Dave Goodrich
Ken Jones wrote: On Tuesday 08 March 2005 1:57 pm, Dave Goodrich wrote: Ken Jones wrote: snip Someone not familiar with LAMP might follow the install doc and stop there, http://myserver.com/include/global.incopens the cookie jar. Where does one find the vpopmail daemon? I downloaded a fresh

Re: [vchkpw] vhostadmin development release

2005-03-08 Thread Dave Goodrich
vpopmail daemon, machine A gets to HUP qmail-send, but I cannot run vadddomain again on machines B, C, D. So I must login and run svc -h /service/qmail-send manually on machine B, C, and D. Hmmm, I'm pondering this one. Still liking the idea of qmail and vpopmail both in MySQL. DAve -- Dave Goodrich

Re: [vchkpw] vhostadmin development release

2005-03-08 Thread Dave Goodrich
Dave Goodrich wrote: Ken Jones wrote: snip Before I grab that (might be later this week before I can look at it), are there any ideas/concepts for using vpopmaild with a group of machines? I'm curious how this can add a domain. Are you able to HUP qmail on multiple machines once a domain is added

Re: [vchkpw] vhostadmin development release

2005-03-08 Thread Dave Goodrich
Jeremy Kitchen wrote: On Tuesday 08 March 2005 03:35 pm, Dave Goodrich wrote: Ken Jones wrote: snip Before I grab that (might be later this week before I can look at it), are there any ideas/concepts for using vpopmaild with a group of machines? I'm curious how this can add a domain. Are you able

Re: [vchkpw] vhostadmin development release

2005-03-08 Thread Dave Goodrich
Jeremy Kitchen wrote: On Tuesday 08 March 2005 04:06 pm, Dave Goodrich wrote: Understood, but what of the other three machines I have running? They all use the same control files. If I add a domain on machine A using vpopmail daemon, machine A gets to HUP qmail-send, but I cannot run vadddomain

Re: [vchkpw] Backing up a server.

2005-03-16 Thread Dave Goodrich
a simple back up that excludes mail messages. DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

Re: [vchkpw] chkuser 2.0.8 oddities

2005-03-16 Thread Dave Goodrich
to installing chkuser, and the qmail-smtpd log shows the address correctly when it is rejected. chkuser uses and logs exactly what receives from qmail-smtpd. Thanks, DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

Re: [vchkpw] chkuser 2.0.8 oddities

2005-03-16 Thread Dave Goodrich
sends a single email everything is fine. The message that is failing has over 100 rcpt to addresses. Of course, _one_ email address is incorrect, so the entire connection is rejected. I should have caught that in the logs, it's been a very long week. Thanks, DAve -- Dave Goodrich Systems

[vchkpw] I'm stumped

2005-03-18 Thread Dave Goodrich
to suggestions for next steps, criticisim of my troubleshooting, etc. Thanks, DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

Re: [vchkpw] I'm stumped

2005-03-18 Thread Dave Goodrich
Cream wrote: Dave Goodrich wrote: Good morning, I've a problem that has been harassing me for a week now. I'm no qmail/vpopmail expert, but I've solved most all my problems over the years with the archives and The qmail Handbook. So I've done my share of troubleshooting and I think I have

Re: [vchkpw] I'm stumped

2005-03-18 Thread Dave Goodrich
), and leaving his messages on the server. Thanks all, we will see what happens the rest of the day. DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

Re: [vchkpw] I'm stumped

2005-03-18 Thread Dave Goodrich
Jeremy Kitchen wrote: On Friday 18 March 2005 11:58 am, Dave Goodrich wrote: What would really be useful would be logging of message IDs in the qmail-send log at delivery, and in the qmail-pop3d log when the message is deleted by the pop client. I could then say, it was delivered, you popped

Re: [vchkpw] I'm stumped

2005-03-18 Thread Dave Goodrich
you a directorylisting, proving that the mail is there before his mail client fetches it. Uhh, looking at that again, isn't that going to write an additional copy of the message to the Maildir everytime a delivery is made? Seems qmail-local would pipe the message to that line. DAve -- Dave

Re: [vchkpw] moving maildirs to a new home

2005-03-21 Thread Dave Goodrich
the domains over to the new machine? DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!

Re: [vchkpw] moving maildirs to a new home

2005-03-21 Thread Dave Goodrich
+nfs mounted maildir system. I just did it last December. DAve -- Dave Goodrich Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!