Re: [vchkpw] Proper server backup
[EMAIL PROTECTED] wrote: Hi, If I had a server hardware failure... and my hardware breaks... so I need to set up a new one qmail server... what should I have backed up in my actual qmail server and how could I recover all data? I mean... I suppose I should compile, install and use the same vpopmail and qmail version. I suppose too I should have a backup of the mysql vpopmail database, /var/qmail directory and /home/vpopmail directory too, is enough having only this backed up? and later... I suppose I should overwrite /home/vpopmail and /var/qmail fully with my backed up version? but this couldn't cause later problems with courier-imap compiled binaries? because they're compiled with just have installed vpopmail libraries and not with backed ones? Thanks a lot mates Hope I have explained :) I'm pretty sure (someone will confirm?) that you *can't* backup the qmail queue and restore it elsewhere because it's designed around the inode numbers on the filesystem that you ran it on initially. For this reason, I would say don't backup /var/qmail/queue/* Howie
Re: [vchkpw] Re: [toaster] filtering outgoing emails
John Simpson wrote: you may have other reasons for wanting to stick with chkuser, but you should at least look at other options (if you haven't already done so.) I haven't bothered before now, but now that's two (different?) patchsets to try out for TLS+AUTH+chkuser+etc+etc :-) The last time I looked around, the only chkuser-equivalents I could find depended on reading vpopmail's mysql databases directly, which wasn't much help for our cdb-based installation. Thanks for the pointer - SPF is another thing I've been meaning to look into, so I guess it's time to build a test machine. Cheers, Howie
Re: [vchkpw] Re: [toaster] filtering outgoing emails
Rick Romero wrote: I think I need to run a different email server for the intital queue - but this then brings up questions like, how do I use SMTP AUTH with, say, Exim, and vpopmail? I've just started using qpsmtpd to do SMTP AUTH against my vpopmail users with vchkpw, to avoid running a patched qmail-smtpd[1]. qpsmtpd has many spam-filtering plugins, and several queueing plugins, including one for qmail and one for any SMTP server (effectively as a proxy). It's fairly easy to extend too, if you know perl. I added a check module to allow our backup MX to only accept mail for a list of known accounts with an afternoon's work. Seperating your SMTP services into relay, inbound, and backup MX makes life a lot easier for enforcing mail policies, IMHO. It's worth a look, perhaps. Howie. [1] actually, it's to avoid having to reconcile SMTP AUTH patches with chkuser, which I already use, and couldn't live without. I run qmail-smtpd with chkuser for the 'public' MX SMTP service, and qpsmtpd for my local user's relay SMTP server, with auth and SSL.
Re: Pop logging to MySQL
At 13:49 04/12/2001 -0600, you wrote: On Tue, 2001-12-04 at 13:42, Andy Abshagen wrote: I have vpopmail 5.0 running with logging to MySQL. However the Timestamp field contains numbers like 1007484409. Is there a way to decipher that to an actual time and date? That's unix time returned by the time(NULL) call. Any utility that understands unix time should be able to convert it to human readable format. ken Jones MySQL has a built-in function to do this too - FROM_UNIXTIME() see http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions Howie -- Howard Jones, [EMAIL PROTECTED] I see stupid people. They're everywhere. http://wotsit.thingy.com/haj/They walk around like everyone else. http://www.lesser-evil.com/ They don't even know they're stupid.
procmail vpopmail fun
After finally getting sick of deleting 95% of my mail to get the real content, I decided to try and get a mail filter going today. On my test machine (FreeBSD 4.4) I installed procmail-3.22, vpopmail-5.0, qmail-1.03 current ucspi, daemontools, etc. Having read up in http://www.mail-archive.com/vchkpw@inter7.com/msg05776.html and http://www.almqvist.net/johan/qmail/vpopmail+procmail.html I created a virtual domain, spoink.co.uk, with a couple of users in it, one called test1. In .qmail-test1 I have: |preline procmail -p -m /var/qmail/vpopmail/domains/spoink.co.uk/test1/Maildir/procmailrc and in test1/Maildir/procmailrc I have: MAILDIR=/var/qmail/vpopmail/domains/spoink.co.uk/test1/Maildir/ VERBOSE=off LOGFILE=/var/qmail/vpopmail/domains/spoink.co.uk/test1/Maildir/procmail.log LOGABSTRACT='on' # check that these are being passed through (VERBOSE will dump them to log) ZORT=$EXT NARF=$HOST :0w |/var/qmail/vpopmail/bin/vdelivermail '' bounce-no-mailbox What I get in the log is lots of: procmail: Program failure (100) of /var/qmail/vpopmail/bin/vdelivermail From [EMAIL PROTECTED] Tue Dec 04 00:17:54 2001 Subject: test22 Folder: **Bounced** 1495 However, I know that the EXT and HOST environment vars are set OK, both from procmail's logs, and by changing the vdeliver line to be a environment-dumping perlscript, and I also know that the Maildir directory exists, and can be delivered to (mail gets there fine if I remove the procmail stuff). Actually, the 'bounced' messages don't even make it back to the sender either, which makes me wonder if qmail understands what is going on. Unfortunately, vdelivermail's stdout doesn't seem to get logged anyway at when run in this way - neither the procmail or qmail-send logs show the reason for failure. Any suggestions or obvious errors? I'm not wed to procmail, but would maildrop make all this any easier? It seems that it's the vdelivermail aspect that is the common fly in both ointments. Regards, Howie (sorry for any tab-damage - I haven't figured Eudora out entirely yet) -- Howard Jones, [EMAIL PROTECTED] I see stupid people. They're everywhere. http://wotsit.thingy.com/haj/They walk around like everyone else. http://www.lesser-evil.com/ They don't even know they're stupid.