Vpopmail and TMDA
Does anybody have any experience integrating vpopmail (4.9.10 or 4.10.X/5.0) with TMDA? Can you share any tips or tricks, especially in dealing with mailing lists. TIA, Dave
Re: spam on lists
> > No God Damnit! I am sick and tired of all of you who assume just > > because I use Outlook Express as my mail client that I don't have a > > friggin' clue. Because DJB has done this with all of his mailing > > lists, I'm now denied access to resources such as the qmail mailing > > list. > > The lists are archived. Feel free to write an extension for Gnus to > browse them. Yes, Gnus groks various web archive formats including > freshmeat and /.. Why would I do that when I don't use or like Gnus? > > > Yes, there are some of use with clue(tm) that know how to configure OE > > properly, and use it. > > Cool. So why didn't you publish your patches against, say, Melissa > earlier? You could have become a hero. I said I know how to configure it, Not how to patch it > > Oh. You didn't have any? Well, so much for your clue(tm) and knowledge > of configuring broken closed source software, Dave. Can you demonstrate a single instance of *ANY* OE propogated virus that originated from me? I don't think so. I think that demonstrates my clue in configuring OE. > > > Strip attachements and HTML if you want, I have no problem with that. > > But deny me access to this list because of the mailer I use??? Get a > > Fuckin' life! > > Dave, I run mailservers. It is because of people like you that people So do I. I run a qmail cluster for a nationwide DSL provider. > like me have to deal with gigabytes (I'm not kidding) of .doc and .xls > files sent by various Microsoft viruses. It's just not worth it, you Have *I* ever sent you gigabytes of infected files? I don't think so. Don't paint me with that brush. I'm sure I've gotten just as much as you. > know? Really. Microsoft has had a lot of time to fix their operating > system and their internet tools. They haven't succeeded. And I'm fed up > sick with mopping up the bloody trail they leave all across *MY* servers. So am I. But that doesn't change the fact that OE gives me the combination of features *I* want. Yes, I'm used Pine, Elm, Mutt, Gnus and a whole slew of other mua's. And every time, I come back to OE because it gives me what I want, and works the way I want. > >> Did I forget anything? Yes. RSP for administrivia to the list. > > Add RSP for reality-proof lusers. I guess for people like Robin we'll need RSP for Rectal Cranium Inversion Dave
Re: spam on lists
> * Ken Jones <[EMAIL PROTECTED]> writes: > > > Which qmailadmin options should I set for the mailing lists? > > Definitly -x. Also run them through a procmail recipe that applies > weighted scoring to quoting ratios and kill all full-quoters. While > you're at it, killfile anything that says Outlook or MS Mail. No God Damnit! I am sick and tired of all of you who assume just because I use Outlook Express as my mail client that I don't have a friggin' clue. Because DJB has done this with all of his mailing lists, I'm now denied access to resources such as the qmail mailing list. I *like* Outlook Express. I've evaluated any number of mail clients, and I keep comming back to Outlook Express. The mail client that comes with Mozilla has some possibilities, but I haven't had a chance to eval it yet. Yes, there are some of use with clue(tm) that know how to configure OE properly, and use it. Strip attachements and HTML if you want, I have no problem with that. But deny me access to this list because of the mailer I use??? Get a Fuckin' life! > > Did I forget anything? Yes. RSP for administrivia to the list. > Dave
Re: required conversion from Netscape mail server to QMAIL
> hello sir > > what iam looking is > not new mail, iam looking old stored mails to move to new qmail server > with out dropping singel mail > so the my clients will have transparent moving to qmial server > with new look and old mails > thanks What I did when I had to do something similar was to compile vpopmail with clear text passwords and learn passwords, as well as using MySQL. I wrote a little perl script that would query the MySQL db once every hour or so, and collect all the users who had a clear text password set and weren't the postmaster. From that, I built a config file for fetchmail, then ran fetchmail against the old server (still running), and reinjected the mail into the new qmail server. Good Luck! > any advice > hari Dave W
Re: [vchkpw] Re: error adding Simerson patch
> Mysql is installed and working properly, I edited the conf-ld and > conf-cc files to include the correct path to mysql. I did notice that > the compile command in conf-ld begins with gcc -s. I don't know what > the s indicates or if that could be a problem. > > Anyone else have problems applying this patch? Any ideas? Did you install MySQL from source? If you didn't, have you installed the mysql-devel or equivilant package? > > regis > Dave
[vchkpw] Testers Wanted for SpamAssassin/Vpopmail control panel
I'm looking for a few select ALPHA testers for a web based control panel I have written specifically for use with vpopmail and Spam Assassin. It features: * Authenticates using the vpopmail.pm api * Can be turned on or off be individual users * uses .qmail files in the users virtual home directory * User can change their password and setup forwards in a manner similar to qmailadmin * User can setup a out-of-office/vacation autoresponder in a manner similar to qmailadmin Contact me OFF-LIST if you would be interested in participating in the ALPHA test. Dave
Re: [vchkpw] SMTP Perms
> Rob G wrote: > > > transferring from XMail to Qmail .. but I think I have it... now on to mail > > lists (which was the reason I switched to qmail) any suggestions that work > > well with vpopmail and qmail? > > There's really only one choice: ezmlm with the ezmlm-idx patches. > > If anyone has managed to get mailman working with qmail + vpopmail I > would love to hear about it! Piece of cake. Search the archives, I posted my solution here and to the mailman list I believe. > > -- > Aj. > Systems Administrator / Developer Dave
[vchkpw] vpopmail, LDAP and AD
Ok, I know this is going to ruffle some feathers, but I've been doing some research, and it looks possible and doable. I've been approached to recommend a mail server for a very large organization. However, they are a Microsoft shop, and will be migrating to Windows 2000 and Active Directory very shortly. For qmail+vpopmail to be acceptable to them, they want "point and click". Ok, qmailadmin will give them point and click, but now they've got user information in two different places. I believe the ldap option for vpopmail works reasonably well, even if some people don't care for it :) And Active Directory is essential built on top of LDAP. So, has anybody done any actual work on having vpopmail authenticate against AD? TIA, Dave
Re: [vchkpw] Can postmaster set user quota
On Monday, February 10, 2003 3:10 PM, Jonas Pasche <[EMAIL PROTECTED]> wrote: > Hi Manish, > >> But I am facing a problem that I want to give the rights of disk >> usage per user to the domain postmaster. > > What's wrong with the vsetuserquota program? Because the domain postmaster often (if not always) have a shell account to run it :) On a more helpful note, I just grabed and installed the latest qmailadmin development version (1.0.10) to try and address a seperate issue, and discovered that it now supports the domain postmaster modifying user quotas, provide the option is added to the ./configure line. > Jonas Dave
Re: [vchkpw] vpopmail 5.3.16 oddities
On Saturday, February 15, 2003 9:10 PM, Jim <[EMAIL PROTECTED]> wrote: > On Saturday, February 15, 2003 8:40 PM, Bill Shupp wrote: > >> This is exactly how it _should_ behave. Your .qmail-default is setup >> so that all _unmatching_ addresses will be put in the "jim" Maildir. >> But you have a real account for "spam", so vdelivermail sees that and >> puts it in the "spam" Maildir. Where did you expect mail for "spam" >> to be delivered? > > I think I may have confused you. If you re-read my message, you may > understand. > > I have a .qmail-default and a .qmail-jim, which both have > | /usr/local/bin/spamc | /home/vpopmail/bin/vdelivermail '' > /home/vpopmail/domains/jimtest.com/jim > &[EMAIL PROTECTED] Jim, are you saying that .qmail-default and .qmail-jim are *identical* files, and have the same three lines? Or is the lines wrapping and it's two lines, with /home/vpopmail/domains/jimtest.com/jim being the catchall delivery? If the answer is yes to either line, then Bill's explaination is correct. Like Bill said, the .qmail-default will be used for the delivery instructions unless it's overridden by a more specific .qmail file, like .qmail-jim. I suggest you read the dot-qmail man page for more information. So, because there's no .qmail-spam, qmail uses the delivery instructions in .qmail-default, which pipe the mail through spamc and the output from spamc is piped to vdelivermail, which finds the user "spam" and delivers it. > .. messages to spam _should_ just be placed in > /home/vpopmail/domains/jimtest.com/spam (because there is no > .qmail-spam (or Maildir/.qmail)) That is mostly correct. User .qmail files should go in their directory under the domain, not in the Maildir. But because there is no .qmail-spam file, then like Bill and I have said, your *DEFAULT* delivery instructions (from .qmail-default) is to pipe the message to spamc, then pipe the out to vdelivermail which then puts in ~vpopmail/domains/jimtest.com/spam/Maildir/new. If you do not want mail sent to [EMAIL PROTECTED] to be processed by spamc, you either need to change your .qmail-default or add a .qmail-spam that will write the message directly into the spam/Maildir > > instead, messages to the spam account are piped through spamc before > being delivered to the spam mailbox Because that's what you've told qmail to do with your .qmail-default -- the **DEFAULT** delivery instruction if a more specific .qmail file is not found. > > Thanks for your reply, > > jim > Dave
Re: [vchkpw] vpopmail 5.3.16 oddities
On Saturday, February 15, 2003 10:00 PM, Jim <[EMAIL PROTECTED]> wrote: > Well, to start off, i just want to make it clear that I am not > arguing, I am just trying to become more clear. If you mean understand, then ok :) > > > On Saturday, February 15, 2003 9:32 PM, Cory Wright wrote: >> In order to fully understand this you need to have a good >> understanding of how qmail's virtual domains work. The >> .qmail-default file is called for every vpopmail account that has >> not been overridden by a .qmail file in the domain's directory. > > I have read the documentation before posting my problems. > > Per the documentation from vdelivermail: >>> [default account for delivery] >>> If the email does match any .qmail-user file and also does not >>> match any > virtual domain user, this is the default delivery instructions. > > 'spam' is a virtual domain user. the vdelivermail in my environment > is not complying with the documented behavior. > > the documentation in dot-qmail also says that a user account will take > precedence over a .qmail-default. > > i understand the concept of a catch-all. the .qmail-default is > acting as a .qmail-catchall instead of an encompassed catch-all. > > IE: the documentation does not say: > If the email does match any .qmail-user file, this is the default > delivery instructions. Ok, I think you're getting confused by the virtualization layer that vpopmail adds. Remember, vpopmail is an *add-on* to qmail. Read the qmail-users man page. This is critical to the way that vpopmail works. If you look in qmail/control/virtualdomains, you'll see a line like jimtest.com:jimtest.com That tells qmail that any mail for jimtest.com should be delivered to the *user* jimtest.com. When qmail doesn't find a jimtest.com in /etc/passwd, it then looks in the cdb file created qmail/users/assign. If you look in there, you'll see a line like +jimtest.com-:jimtest.com:515:510:/home/vpopmail/domains/jimtest.com:-:: This tells qmail the following: All email for jimtest.com is going to be controled by the .qmail* files in /home/vpopmail/domains/jimtest.com. Now, qmail doesn't know anything about the vpopmail users, nor the directory structure under /home/vpopmail/domains/jimtest. So it looks for a .qmail-spam file. It doesn't find one. Because it doesn't know anything about the users, it then reads the .qmail-default file and follows the delivery instructions in there, which pipe the message to spamc. It's the vdelivermail program that knows all about the users in jimtest.com and does the final delivery. > > > jim > Dave
Re: [vchkpw] vpopmail as a daemon
On Sunday 23 February 2003 21:56, Jesse Guardiani wrote: > OK. Again, I admit lack of experience here. But, it still seems like a > vpopmail specific protocol would be faster than transfering and modifying > files over NFS. Does everyone really think that NFS would be faster? First off, I've designed and built 2 different qmail+vpopmail clusters, using different platforms (Sun and Linux), both using NFS (EMC and RaidZone), and they both work like champs. Ok, as to your question. NFS is optimized for sending the data for the network and writing it to disk, or reading the data from disk and pushing it back out. Your vpopmail daemon would have to do the same thing -- accept the message via a network port and then write it to the disk. Sounds a lot like NFS to me. Why not go with the mature protocol? > Thanks for the reply. > > Jesse
[vchkpw] OT: Spamarrest
Sorry for the waste of bandwidth folks, but somebody who's using spamarrest is subscribed to this list: Brian <[EMAIL PROTECTED]> I got a request from him to validate myself when I posted a follow up to the vpopmail daemon thread. For those of you that don't know, while they claim it's not spam, Spamarrest spams. There was a thread recently on the Spam Assassin mailing list about it. Spamarrest feels that if you validate yourself to one of thier customers that it gives them the right to send you solicitations for their service. You can read more about their practices at http://www.groovymother.com/archives/000545.html Brian, if you even see this, please consider other solutions. Dave
Re: [vchkpw] spamassassin with per-user settings
Iain wrote: > Hi, > > I have been working on getting spamassassin working with vpopmail and > SQL based user preferences with a fair amount of success. > > I use the following in my .qmail-default for a particular domain: > >> preline /usr/bin/maildrop /etc/spamassassin/mailfilter > > where the mailfilter is included at the bottom of this email. I have > even backported the SAM module for IMP from CVS so that webmail users > can adjust their spam settings. > > This all works well, creating a SPAM folder if it doesn't exist and > moving any SPAM into that folder. > > The only problem is that the .qmail-default file will be overwritten > by qmailadmin if the catchall settings are changed. I have seen a few > people mention this on the list before but haven't seen an answer. > Some people have suggested that procmail is the answer. Can anyone > provide an example of how procmail can achieve similar results to the > maildrop filter below? No procmail, but if you instead call maildrop on a per-user basis from the users .qmail file, you don't have to worry about the qmail-default being rewritten :) > > ## > mailfilter > ## > import EXT > import HOST > import HOME > VHOME=`/home/vpopmail/bin/vuserinfo -d [EMAIL PROTECTED] > VPOP="| /home/vpopmail/bin/vdelivermail '' bounce-no-mailbox" > > if ($SIZE < 262144) > { > xfilter "/usr/bin/spamc -u [EMAIL PROTECTED]" > } > > if ((/^X-Spam-Flag:.*YES/)) > { >`test -d $VHOME/Maildir/.SPAM` >if( $RETURNCODE == 1 ) >{ >`maildirmake $VHOME/Maildir/.SPAM;chown -R vpopmail.vchkpw > $VHOME/Maildir/.SPAM` >} >to "$VHOME/Maildir/.SPAM/" > } > > to "$VPOP" Ya know, it's fun watching this .mailfilter morph since I posted it to the list. Dave
Re: Re[4]: [vchkpw] SpamAssassin/vmodinfo changes
Gabriel Ambuehl wrote: > -BEGIN PGP SIGNED MESSAGE- > > Hello Dave, Hi Gabriel. No need to CC me, I get the list email just as fast :) > > Friday, March 7, 2003, 9:09:17 PM, you wrote: >> The lack of being able to turn it off per user is probably the only >> thing that holds me back from using it :) > > I suppose adding a new field into vpasswd is a nono as it would break > a lot of existing code, right? So the flagfile is probably the best > idea (easy to implement, too). Thoughts? Yes, I think some sort of dotfile would be the best. Then any number of tools could use it. Suggestion, for those of us that use sql user prefs. If the dotfile is present but empty, just make the connection to spamc/spamd, assuming that vpopmail support in spamassassin is being used. If there's text in the dotfile, use that for the -u option > > > Best regards, > Gabriel > Dave
Re: [vchkpw] problem with valias and maildrop filter
Iain wrote: > Hi, > > I have been using maildrop to filter spam by using the following in > .qmail-default for each domain: > >> preline /usr/bin/maildrop /etc/spamassassin/mailfilter > > I have included the mailfilter at the end of this email. > > However when I set this up I found that SQL based aliases stopped > working. Email sent to these alias addresses goes to a black hole. > > This is with vpopmail 5.3.18. Any ideas as to what could be causing > this? Did you rebuild vpopmail between when it worked and when it stoped? Is /home/vpopmail/bin/vdelivermail the correct path? If the answers are No and Yes respectively, you might need to escape the '' in the VPOP line. Try making the VPOP line this: VPOP="| /home/vpopmail/bin/vdelivermail \'\' bounce-no-mailbox" Also, double check the logic of the conditionals in your mailfilter. I haven't had a chance to pull it apart, but it doesn't "look right" > > cheers, Iain. > Dave
Re: [vchkpw] more weirdness with vdelivermail and maildrop
On Wednesday 12 March 2003 22:38, Iain wrote: > However this doesn't: > > cat testmail.txt | maildrop mailfilter-test > > when mailfilter-test is: > import EXT > import HOST > VPOP="| /home/vpopmail/bin/vdelivermail '' bounce-no-mailbox" > to "$VPOP" > > I see vdelivermail: valiases processed but the mail is not sent on the > alias destination. > > please help. Iain, can you try your test again, but this time can you try specifying the full path to mailfilter-test? > > cheers, Iain. Dave
Re: [vchkpw] more weirdness with vdelivermail and maildrop
On Thursday 13 March 2003 00:40, Iain wrote: > On Thu, 13 Mar 2003 04:44, Dave Weiner wrote: > > > I see vdelivermail: valiases processed but the mail is not sent on the > > > alias destination. > > > > > > please help. > > > > Iain, can you try your test again, but this time can you try specifying > > the full path to mailfilter-test? > > I've done that but it doesn't make a difference. Is there anything in the logs at all? Any messages from maildrop? Can you add some explicit loging? Dave
Re: [vchkpw] more weirdness with vdelivermail and maildrop
Iain wrote: > Well if I turn on logging in maildrop i see the following when i send > to an alias. This is the same as what I see when I send to a non > alias. > > Date: Thu Mar 13 16:21:38 2003 > From: Iain <[EMAIL PROTECTED]> > Subj: test 3 > File: | /home/vpopmail/bin/vdelivermail '' bounce-no-mailbox > (873) Iain, can you run the follow query from inside mysql and email me the results? select * from valias where alias="iain" and domain="voffice.myspinach.org"; Dave
Re: [vchkpw] more weirdness with vdelivermail and maildrop
Iain wrote: > [EMAIL PROTECTED] is the from address and does not exist in > the valias table. That's what I get for answering before cafinee :) Can you do a query *like* that one for the valias you're trying to send to? I'm thinking that it's a problem with the alias definition itself, not vpopmail, mysql or maildrop. Dave
Re: [vchkpw] more weirdness with vdelivermail and maildrop
Iain wrote: > I'm pretty sure the alias line is fine: > > mysql> select * from valias where alias = 'alias1' and domain = > 'test.rucc.net.au'; > ++--+---+ >> alias | domain | valias_line | > ++--+---+ >> alias1 | test.rucc.net.au | [EMAIL PROTECTED] | > ++--+---+ > 1 row in set (0.00 sec) > > mysql> > > The aliases work fine without the maildrop filter. So i think it is > something to do with the way maildrop is interacting with > vdelivermail. Very, very strange > > Do you have valias enabled on your system? Maybe you could try it and Yes, as well as maildrop. However, I call it from user's .qmail files, not the .qmail-default > see if you see the same behaviour. At least one other person on this > list has indicated that they do. > > cheers, iain. > Dave
Re: [vchkpw] more weirdness with vdelivermail and maildrop
On Thursday 13 March 2003 20:54, Iain wrote: > On Fri, 14 Mar 2003 10:09, Dave Weiner wrote: > > > Do you have valias enabled on your system? Maybe you could try it and > > > > Yes, as well as maildrop. However, I call it from user's .qmail files, > > not the .qmail-default > > really. What version of vpopmail and maildrop are you using? Would you mind > posting your maildrop filter? vpopmail 5.3.16, maildrop 1.3.8 The user's .qmail file just gets "|maildrop" put in it. In ~vpopmail is this .mailfilter # # We need to know the actual dir for the vpopmail user # import EXT import HOST VHOME=`/var/vpopmail/bin/vuserinfo -d [EMAIL PROTECTED] # # Do we send the mail through spamc? # exception { include "$VHOME/.spamc" } # # If there's a spamfolder file in the users directory # it will have the rule to deliver to the SPAM folder # exception { include $VHOME/.spamfolder } # # Include any other rules that the user might have from # sqwebmail or other compatible program # exception { include $VHOME/Maildir/.mailfilter } # # Default delivery if all else fails # exception { to "$VHOME/Maildir/" } if .spamc is present in the users directory, it will contain: if ( $SIZE < 262144 ) # # Only filter if less than 256K # { exception { xfilter '/usr/bin/spamc -f -u "[EMAIL PROTECTED]"' } } and if .spamfolder is present, it will contain: if ( /^X-Spam-Flag: *YES/) { exception { to "$VHOME/Maildir/.SPAM/" } } Maildir/.mailfilter is there for 2 things -- a place to put custom filtering rules (my partner and I are working on a SquirrelMail plugin to do this), and to give some support for people transitioning from or using sqwebmail This setup gives us some nice flexibility -- to turn on spamassassin, I just have to drop the .spamc file in the user directory. To deliver to a SPAM folder, just drop the .spamfolder into the user directory. I've been playing with a squirrelmail plugin to let the user turn this all on or off. > > thanks, Iain. You're welcome! Dave
Re: [vchkpw] more weirdness with vdelivermail and maildrop
Jesse Guardiani wrote: >> Actually, thinking about it, not everybody using vpopmail uses >> squirrelmail so this would be better as a separate tool, or possibly >> integrated with qmailadmin. > > Not sure if you know this, but sqwebmail already has the ability to > create filters. Yes I am, and it's client side filtering, and it's slow. I much prefere server side filtering :) > >> >> Would it be possible to hack some code from courier into qmailadmin >> to manage the maildrop filters? > > Sure, but I don't think that's a good place for the code. I think a Personally, I don't think the sqwebmail code for doing maildrop filters is all that good. I think Mr. Sam designed the maildrop rule portion of sqwebmail for people like him (and us) -- sysadmins. The average user is just *lost* when the see some of those options. > PHP script would be much more appropriate for general filter > creation. I'm surprised no-one has created one yet. > > But, the problem is that you've got to have a way to make sure that > the filters are letting mail through. Either that, or you've got to > create your filters in a way that is foolproof (like, making sure the > folder actually exists before allowing the user to make a filter that > drops > mail there. Or, making sure a defunct filter rule is deleted when the > user deletes a folder in their webmail client.) > > With that in mind, it makes a lot of sense to put this functionality > in the webmail client. (But note that sqwebmail does NOT currently > delete > a filter if it's corresponding folder is deleted.) Correct -- this way, we can get a list of the folders. I'm not certain if we can tie into the folder deletion routines of squirrelmail, but we sure as hell can put the delivery instructions inside "exception { }" so if the folder does go away, the mail will fall through and get picked up the the default delivery line :) Dave
Re: [vchkpw] more weirdness with vdelivermail and maildrop
Jesse Guardiani wrote: > Huh? sqwebmail uses maildrop. maildrop is server side. What are you > talking about? Just reading too fast, and parsed your sqwebmail as squirrelmail :) Dave
Large site questions
I've installed vpopmail/sqwebmail/courier-imap/qmailadmin on a small system (< 200 users spread over ~40 domains) and it works like a champ and I love it. I'm working on a project for a large client, and I've got them willing to look at a qmail/vpopmail/sqwebmail/courier-imap/qmailadmin solution instead of outsourcing their e-mail, so I've got a couple of questions. They currently have ~1,000,000 (yes, 1 million) mail boxes and growing spread over ~30 domains. The biggest single domain has ~400,000 users/mailboxes. As new users get added, I have a feeling that the rebuilding the cdb file for authentication is just not going to be practical. Is MySQL with the --enable-large-site=y the best choice? Is anybody running qmail/vpopmail with ~400,000+ users/mailboxes? If you are, would you e-mail me privately with your platform (OS and hardware), and any loadbalancing you may be doing? TIA, Dave Weiner
Re: mysql high availability
> Hi Dave, Hi Ken! :) > Yes, I was looking at that. > The first thing that I ran into is trying to minimize database > transactions during a pop access. The authentication part is > easy, just read the user info from mysql. > > There are two optional transactions that do updates during > an authentication > 1) the roaming users --enable-roaming-users=y > 2) authentication logging --enable-auth-log=y > Well, the solution I came up with is to set up 2 MySQL servers doing two-replication, and load balance the hostname compiled in via a BIPIP. But not everybody has that luxury :) > It seems pretty wasteful to have the authentication > mechanism open two database connections, one for > the read only auth and one for the two possible updates. > But I really can not see a way around it. Yes, it is wasteful, until you need it it :) Why not make it a setup option? You currently have an option for MySQL auth and an option for large site. So why not just add an option like --enable-sql-redunancy=y? So, if you want a RO and a Write connection, you can choose to have it. > > For the roaming users stuff to work, the IP addresses > have to be centralized. Otherwise in a clustered setup > once they pop, they may or may not be able to use smtp > relaying. We have tried using a file based system with > a NFS mount, but it runs into synchronization problems > when multiple machines are updating the file at the same > time, and locking doesn't help because NFS locks will > fail. > > One thing we've been looking at is having "fall back" > servers for both the read and update mysql connections. > Meaning: if a connection to one fails, then it attempts > a connection to the fallback machine. > > The other thing is the authentication needs to be compiled > into the binaries. One other option is a patch from > Ondrej that gets the mysql auth data from environment > variables. > > Ken Jones > Dave
Migrating users
Ok, I'm just about done building my qmail/vpopmail/sqwebmail/courier-imap cluster, and I find out that I need to migrate a bunch of users from Iplanet to the new system. Has anybody done this before? Any tips, tricks or pointers? Dave W
Problem building 4.10.9 on Solaris 7
I'm getting an error when I try to build 4.10.9 on Solaris 7. ./configure runs just fine. I've included system info, the ./configure commands, and the error below. Dave W # uname -a SunOS costello.laserlink.net 5.7 Generic_106541-15 sun4u sparc SUNW,Ultra-1 # ./configure --enable-roaming-users=y --enable-ip-alias-domains=y \ --enable-passwd=y --enable-mysql=y --enable-incdir=/var/lib/mysql/include/my sql \ --enable-libdir=/var/lib/mysql/lib/mysql --enable-valias=y . . . creating config.h vpopmail 4.10.9 Current settings --- vpopmail directory = /var/qmail/vpopmail uid = 7797 gid = 2109 roaming users = ON --enable-roaming-users=y tcpserver file = /etc/tcp.smtp open_smtp file = /etc/open-smtp user quota = OFF --enable-hardquota=n default auth module = mysql --enable-mysql=y table optimization = many domains --enable-large-site=n default system passwords = ON --enable-passwd=y default auth logging = OFF --enable-auth-logging=n default mysql clear passwd = OFF --enable-clear-passwd=n default valias processing = ON --enable-valias=y pop syslog = show only failure attempts --enable-logging=e default default domain = --enable-default-domain= auth inc dir = -I/var/lib/mysql/include/mysql auth lib dir = # make . . . make[2]: Entering directory `/usr/local/src/vpopmail-4.10.9' gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vpopmail.c gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c md5.c gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c bigdir.c gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vauth.c vauth.c: In function `vauth_setpw_size': vauth.c:576: warning: int format, uid_t arg (arg 5) vauth.c:576: warning: int format, gid_t arg (arg 6) vauth.c:587: warning: int format, uid_t arg (arg 5) vauth.c:587: warning: int format, gid_t arg (arg 6) gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c file_lock.c gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vpalias.c rm -f libvpopmail.a ar cru libvpopmail.a vpopmail.o md5.o bigdir.o vauth.o file_lock.o vpalias.o cdb/*.o ranlib libvpopmail.a gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vchkpw.c vchkpw.c: In function `main': vchkpw.c:116: warning: int format, gid_t arg (arg 3) vchkpw.c:116: warning: long unsigned int format, unsigned int arg (arg 4) vchkpw.c:124: warning: int format, uid_t arg (arg 3) vchkpw.c:124: warning: long unsigned int format, unsigned int arg (arg 4) gcc -g -O2 -Wall -o vchkpw vchkpw.o libvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vdelivermail.c gcc -g -O2 -Wall -o vdelivermail vdelivermail.o libvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c clearopensmtp.c gcc -g -O2 -Wall -o clearopensmtp clearopensmtp.o libvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vadddomain.c gcc -g -O2 -Wall -o vadddomain vadddomain.o libvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vdeldomain.c gcc -g -O2 -Wall -o vdeldomain vdeldomain.o libvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vpasswd.c gcc -g -O2 -Wall -o vpasswd vpasswd.o libvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vadduser.c gcc -g -O2 -Wall -o vadduser vadduser.o ibvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vdeluser.c gcc -g -O2 -Wall -o vdeluser vdeluser.o libvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vaddaliasdomain.c gcc -g -O2 -Wall -o vaddaliasdomain vaddaliasdomain.o libvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vsetuserquota.c gcc -g -O2 -Wall -o vsetuserquota vsetuserquota.o libvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vpopbull.c gcc -g -O2 -Wall -o vpopbull vpopbull.o libvpopmail.a -L/var/lib/mysql/lib/mysql -lmysqlclient -lz -lsocket -lnsl -l crypt -lz -lm gcc -I. -I/var/lib/mysql/include/mysql -g -O2 -Wall -c vdeloldusers.c vdeloldusers.c:143: `#else' not within a conditional
Problem installing vpopmail.pm
I just upgraded to vpopmail 4.10.9, and grabbed the latest version of vpopmail.pm. When I try and build it, I get the following error: /usr/local/bin/perl -I/usr/local/lib/perl5/5.00503/sun4-solaris -I/usr/local /lib/perl5/5.00503 /usr/local/lib/perl5/5.00503/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.00503/ExtUtils/typemap -typemap typemap vpopmail.xs >xstmp.c && mv xstmp.c vpopmail.c Error: Cannot parse function definition from ' char* alias' in vpopmail.xs, line 302 Error: Cannot parse function definition from ' char* alias' in vpopmail.xs, line 308 Please specify prototyping behavior for vpopmail.xs (see perlxs manual) make: *** [vpopmail.c] Error 1 System info: # uname -a SunOS costello.laserlink.net 5.7 Generic_106541-15 sun4u sparc SUNW,Ultra-1 Anybody (Sean?) have an idea what the problem could be? Thanks, Dave
Problem delivering mail using 4.10.9
I've successfully built vpopmail 4.10.9 on a Solaris 7 box, and I'm now testing it. There seems to be a problem delivering mail. I get this message in my log file: @40003b1d00f22f937f2c delivery 1: deferral: Unable_to_switch_to_/var/qmail/vpopmail/domains/covad.local:_file_does_not_e xist._(#4.3.0)/ Which is the wrong directory. It should be switching to /var/qmail/vpopmail/domains/0/covad.local The correct info is stored in the MySQL database: # bin/vuserinfo -v [EMAIL PROTECTED] version: 4.10.9 name: davew passwd: OOQaPgOnWNk86 uid:0 gid:0 all services available gecos: davew dir:|/var/qmail/vpopmail/domains/0/covad.local/davew| quota: NOQUOTA Is this a known problem with 4.10.9? Should I upgrade to 4.10.15 that just came out? Dave Weiner
Re: vpopmail stress testing
> Thought you folks might be interested. I am doing some > stress testing of mysql and mysql replication > > add/del 57,000 domains > add/del 100,000 users spread across the 57,000 domains > > No problems so far. Doing my own stress tests on 4.10.15 here: 5,000 domains, 200 users each + postmaster, for 1,005,000 users total. Using MySQL, but not the large site option or replication. I'm using a program called "postal" to test it, by sending 4,000 e-mail messages to a random e-mail address out of the 1,000,000 non-postmaster address. I'll let you all know the results. > > Ken Jones > Dave W
Problem with Configure?
Building vpopmail 4.10.19 on Solaris 7: ./configure --enable-roaming-users=y --enable-ip-alias-domains=y \ --enable-passwd=y --enable-mysql=y --enable-incdir=/var/lib/mysql/include/my sql \ --enable-libdir=/var/lib/mysql/lib/mysql --enable-valias=y --enable-mysql-re plication=n \ --enable-file-locking=y --enable-qmail-ext=y After running ./configure with the above options, the final lines of output from ./configure are: creating config.h vpopmail 4.10.19 Current settings --- vpopmail directory = /var/qmail/vpopmail uid = 7797 gid = 2109 ip alias = OFF --enable-ip-alias-domains=n (default) address extentions = ON --enable-qmail-ext=y roaming users = ON --enable-roaming-users=y tcpserver file = /var/qmail/vpopmail/etc/tcp.smtp open_smtp file = /var/qmail/vpopmail/etc/open-smtp user quota = OFF --enable-hardquota=n default auth module = mysql --enable-mysql=y mysql replication = OFF --enable-mysql-replication=n default table optimization = many domains --enable-many-domains=y default system passwords = ON --enable-passwd=y default file locking = ON --enable-file-locking=y default file sync = ON --enable-file-sync=y default auth logging = OFF --enable-auth-logging=n default mysql clear passwd = OFF --enable-clear-passwd=n default valias processing = ON --enable-valias=y pop syslog = show only failure attempts --enable-logging=e default default domain = --enable-default-domain= auth inc = -I/var/lib/mysql/include/mysql auth lib = -L/var/lib/mysql/lib/mysql -lmysqlclient -lz You'll notice that it says ip alias is off. But I have --enable-ip-alias-domains=y in my ./configure line. Is this a bug with ./configure, and if so, does anybody have a fix? I don't know enough about how configure scripts work to track it down myself :( Dave W
qmailadmin templates
Hi all, and especially Ken! I'm just about finished building and testing my qmail cluster (yes, I'll make a full report when I'm done and can breath! My "proof-of-concept, let's see if we can build a qmail cluster and then see how much load it can handle" project became "put it into production" very near the beginning, so I've had to compress the build time, and the month of testing I had scheduled into very little time!) Anyway, I'm running vpopmail 4.10.19, soon to be 4.10.20. I've installed qmailadmin 0.52 (which was the latest development version on the 13th. I see it's up to 0.53. Damn KenI can't keep up with you! :D). I've got all the templates changed the way I want, but I can't find template for four "sub pages" (for lack of a better word) off of the show_mailinglist.html page. They are "Delete Subscriber", "Show Subscribers", "Delete Moderator" and "Show Moderator". Is it possible to change the look of these pages without hacking the source? Is there a template I'm missing? Will upgrading to 0.53 fix this? Enquiring minds want to know :) Dave
Re: [vchkpw] synchronize control files
On Sunday 21 September 2003 08:35 pm, Tim Hasson wrote: > I recall a old problem from the days of vpopmail 4.9.x which was a bug in > vadddomain not sending a HUP signal to qmail-send to tell it to reread > control/rcpthosts. > The problem manifested itself when a new domain is added, then you try to > send a message to a mailbox at that domain, qmail typically refused the > delivery saying something like: > "Although I am listed as best preference MX for this domain, it's not > listed in my rcpthosts", or similar. > > Suppose you did ./vadddomain on one of the cluster servers running > qmail/vpop. Sure if you use NFS, the changes will show from any of the > servers running the NFS client. However, only the server which you ran > vadddomain on will have it's qmail-send restarted and it will be the only > one that will receive mail for that domain. The others will not untill > qmail-send is restarted, or the server is rebooted. What I did (back in the 4.5 tree, I believe), was to write a little shell script that would do a svc -h /service/qmail. Then, using daemontools and tcpserver, I setup it up to listen on a unused port and to only accept connections from my "master" server. The script would return either a "OK" or "FAIL", and all I had to do from the master server was telnet on that port to each of the other servers in the cluster. You could also setup a ssh key for root on the master box, and setup the other boxes in the cluster to allow root to log in using a key and no password, and just write a little wrapper script around vadddomain that calls vadddomain, the ssh's to each of the other boxes in the cluster and does the svc -h /service/qmail. Just make sure you set it up on each of the boxes that root can only ssh in from the master server. However, that's more of a hole than the daemontools/tcpserver solution. > > Respectfully, > Tim Hasson -- Dave Weiner Partner Coyote Technical Services, LLC
Re: [vchkpw] Vpopmail 5.3.30 released
On Thursday 20 November 2003 19:36, Tom Collins wrote: > http://vpopmail.sf.net/ > > This should fix all known problems with 5.3.29. > Great news Tom! Does this also fix the problem with roaming users? I don't see it explicitly mentioned in the change log. Dave
Re: [vchkpw] Vpopmail 5.3.30 released
On Friday 21 November 2003 13:49, Tom Collins wrote: > On Friday, November 21, 2003, at 08:17 AM, Dave Weiner wrote: > > Great news Tom! Does this also fix the problem with roaming users? I > > don't > > see it explicitly mentioned in the change log. > > Yes. It was probably referred to as "POP before SMTP" in the ChangeLog > instead of roaming users. Nope, looked for that as well. The changelog may very well list the actual fixes done for it, but nothing that explicitly says "Roaming Users" or "POP before SMTP" or any variations, hence my asking :) You might want to fix that Thanks! Dave
Re: [vchkpw] spam assassin enable/disable per domain flag
On Tuesday 13 January 2004 02:47 pm, Ken Jones wrote: > Do you mean: > 1) site wide configuration: call spamc with no -u option > 2) domain: call spamc with -u domainname > 3) user: spamc -u [EMAIL PROTECTED] > > I've got it running now with 1) and 3) but not sure if it can do 2). If you're using mysql user prefs, I don't see why you couldn't do #2. the value of -u is just a key used to look up the prefs in the mysql database. At worse, do #2 with -u [EMAIL PROTECTED] > > Ken Dave
Re: [vchkpw] NFS and vpopmail
Have I got my permissions COMPLETELY screwed up? I know this is more of an NFS question rather than vpopmail - but I figure that anyone who has a working NFS/vpopmail setup should know. The big thing with NFS is make sure that the UID and GID are the _SAME_ on all machines. thanks, Matt Dave
Re: [vchkpw] Poll of sorts
Matt Brookings wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I was wondering if anyone had any input on moving vpopmail to Subversion. After working with CVS for years, and then moving most of my development trees to Subversion, I've found it to be much easier to work with. I'd be very interested in seeing the project moved over to Subversion. Does anyone have any input on this? - -- Have you looked at/considered Git? I've just started using it, and I'm finding that I like it's approach much better than CVS or Subversion. It's website is at http://git-scm.com/ Dave !DSPAM:496e110e32671977374722!