Also, what on earth is the config table used for? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hansen Sent: Monday, February 09, 2004 7:05 AM To: dbmail@dbmail.org Subject: RE: Unique keys (was Re: [Dbmail] Does DBmail support spam-, virus-filter, SPF, tar pitting and sorting into folders?)
Got another question too, With the aliases table, it doesn't seem to work like the aliases file, eg: /etc/aliases contains: postmaster: root webmaster: root root: admin admin: john If I transfer these directly, it doesn't seem to work. Only if I add the @domain.tld part to each alias and deliver-to. But this means I'd have to add aliases for each domain. Is there a way to make aliases global? ... John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roel Rozendaal - IC&S Sent: Monday, February 09, 2004 12:59 AM To: dbmail@dbmail.org Subject: Re: Unique keys (was Re: [Dbmail] Does DBmail support spam-, virus-filter, SPF, tar pitting and sorting into folders?) it sure is redundant, should have been removed a long time ago :$ Op 8-feb-04 om 8:56 heeft Paul J Stevens het volgende geschreven: > Indeed. Just remove the uniqueness. > > Also, while looking into this: Roel: why do all the innodb tables > contain additional unique indexes on all tables's primary keyfields: > > PRIMARY KEY (alias_idnr), > ... > UNIQUE alias_idnr_2 (alias_idnr) > > > seems like pretty redundant to me. > > > John Hansen wrote: >> From dbmail 1.2.3, from create_tables.pgsql: >> CREATE SEQUENCE alias_idnr_seq; >> CREATE TABLE aliases ( >> alias_idnr INT8 DEFAULT nextval('alias_idnr_seq'), >> alias VARCHAR(100) NOT NULL, >> deliver_to VARCHAR(250) NOT NULL, >> client_idnr INT8 DEFAULT '0' NOT NULL, >> PRIMARY KEY (alias_idnr) >> ); >> CREATE UNIQUE INDEX aliases_alias_idx ON aliases(alias); CREATE >> UNIQUE INDEX aliases_alias_low_idx ON aliases(lower(alias)); Seems >> unique to me! Will removing the uniqueness work? >> .... John >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >> Behalf Of Roel Rozendaal - IC&S >> Sent: Sunday, February 08, 2004 2:25 AM >> To: dbmail@dbmail.org >> Subject: Re: [Dbmail] Does DBmail support spam-, virus-filter, SPF, >> tar pitting and sorting into folders? >> Hi, >> The alias-field is not unique in the aliases table - this was done to >> enable multiple recipients for one address :-) You just add aliases >> for everything you want: >> alias deliver_to >> [EMAIL PROTECTED] [EMAIL PROTECTED] >> [EMAIL PROTECTED] [EMAIL PROTECTED] >> [EMAIL PROTECTED] [EMAIL PROTECTED] >> Off course you can all the options mentioned in the deliver-to field; >> adding these aliases like above is done easily with dbmail-adduser: >> dbmail-adduser f [EMAIL PROTECTED] [EMAIL PROTECTED] >> or, to add an alias to deliver directly to your inbox (i.e. placing >> your user-id-nr in the deliver-to field): >> dbmail-adduser c username +a [EMAIL PROTECTED] (see man >> dbmail-adduser for more info) regards roel Op 7-feb-04 om 11:23 heeft >> John Hansen het volgende geschreven: >>> Cool, now the question is how? >>> >>> Seems alias in the db is a unique key, so it can't contain >>> duplicates, >>> >>> Should deliver-to then contain a comma seperated list of recipients, >>> just like the aliases file? >>> >>> .... John >>> >>> PS: re spammers, I agree totally,.... >>> >>> They should be jailed for life, and forced to spend the sentence >>> with lonely men who's had their penis enlarged. >>> >>> -----Original Message----- >>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>> Behalf Of Tim Triche >>> Sent: Saturday, February 07, 2004 10:21 AM >>> To: dbmail@dbmail.org >>> Subject: Re: [Dbmail] Does DBmail support spam-, virus-filter, SPF, >> tar >>> pitting and sorting into folders? >>> >>> >>> yes, we use it that way all the time on rockclimbing.com. >>> >>> out of sheer laziness I have begun to implement a system for routing >>> dbmail aliases selectively into phpbb forums; I was not thrilled >>> with the idea of setting up mailman, ezmlm, etc. >>> >>> but yes the aliases work great for mailing lists and if you want a >>> php class to twiddle them, I can post one to the list. no warranty, >>> of course; if it breaks you get to keep the pieces. >>> >>> I am not using the teergrube features in Postfix but IIRC it can be >>> done. That's obviously a postfix issue, not a dbmail issue. >>> >>> all in all, with postfix + clamav + amavisd-new + SA and dbmail, our >>> spam load is reduced. The critical part of that infrastructure has >>> been piping a spammy address directly to SA's bayespam (again via a >>> dbmail >>> alias) and of course as the spammers have been sending random >>> collections of words to poison the filter, it's getting worse. I >>> may have to setup DSPAM and some other intermediate solutions until >>> SPF or something like it takes hold. >>> >>> Spammers really are subhuman. If you know one, key his car, take a >>> dump in his pool, and periodically order hundreds of pizzas from >>> Domino's >> to >>> be delivered to his house. Spammers are fecal matter. >>> >>> --t >>> >>> Quoth John Hansen: >>> >>>> About aliases, >>>> >>>> Is it possible for dbmail to have one alias expand to several >>>> destinations, eg. mailinglists? >>>> >>>> Sort of like the aliases entry: list: user1,user2,user3,..... >>>> >>>> .... John >>>> >>>> -----Original Message----- >>>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>>> Behalf Of Roel Rozendaal - IC&S >>>> Sent: Saturday, February 07, 2004 4:31 AM >>>> To: dbmail@dbmail.org >>>> Subject: Re: [Dbmail] Does DBmail support spam-, virus-filter, SPF, >>>> tar pitting and sorting into folders? >>>> >>>> >>>> Hi Rene, >>>> >>>> Regarding spamfilters: you can use spamassassin very easily. Every >>>> known email address to the dbmail system is stored in the 'aliases' >>>> table which contains (alias, deliver_to) entries. As you might >>>> expect, >>> >>>> the 'alias' field represents a known email address, 'deliver_to' >>>> specifies what to do with the mail for this address. It can contain >>> >>> one >>> >>>> of the following: >>>> >>>> (1) a number. This is a reference to the user_idnr of the user who >>>> uses this alias; the mail will be delivered to his/her INBOX. >>>> (2) an emailaddress. This can be used for forwarding mail; this >>>> emailaddress may be an external forward or a local forward (i.e. the >>>> deliver_to field contains an email address which is an alias-entry >>>> in the aliases table) >>>> (3) a pipe sign ('|') followed by a shell-command. A pipe will be >>>> opened to the specified command and all mail data will be piped into >>>> the stream. >>>> (4) an exclamation mark ('!') followed by a shell-command. Works >>>> just as the pipe-sign but prepends the maildata with an mbox-style >>>> header. >>>> >>>> You can use option #3 to implement spamassassin easily: just pipe >>>> the maildata to spamassassin and you're off! >>>> >>>> On virusfilters: i've heard a few stories on this list from >>>> dbmail-systems using amavisd. It isn't hard to implement but it's a >>> >>> bit >>> >>>> of a off-dbmail topic since amavisd is configured in your mta. As >>>> you are currently using postfix i would suggest to keep using it, >>>> there's lots of info on the net about integrating amavisd and >>>> postfix. >>>> >>>> About SPF: i'm a bit of a newbie to SPF, but AFAICT by >>>> http://spf.pobox.com/intro.html , you'll be able to use it as soon >>>> as it is in your mta. >>>> >>>> Although the usefullness of tar-pitting is subject to quite some >>>> discussion ;-) this as well takes place in the mta. You're limited >>>> by the choice of your mta. >>>> >>>> Filtering mail directly into folders is currently under >>>> development; they are scheduled for version 2.1. The timeline for >>>> 2.1 development will be laid out after the release of 2.0 (very >>>> shortly now :-) but we're talking about 2-3 months max here. >>>> >>>> regards roel >>>> >>>> >>>> Op 4-feb-04 om 20:17 heeft Rene Bartsch het volgende geschreven: >>>> >>>> >>>>> Hi, >>>>> >>>>> first I'm new to list, so "Hello" to all ;-) >>>>> >>>>> I'm considering to switch from Postfix/CourierIMAP/Procmail to >>>>> DBmail as it would decrease maintenance work (no system users, >>>>> home directories, ... for email users). >>>>> >>>>> I just want to run it with a PHP-frontend to administrate and >>>>> PHP-webmail. >>>>> >>>>> Now, my questions are about handling mails: >>>>> >>>>> 1.) is there support/an interface for spam filters (SpamAssassin >>>>> preferred)? >>>>> 2.) is there support/an interface for virus filters (F-Prot >>>> >>>> preferred)? >>>> >>>>> 3.) is there support/an interface for SPF validation? >>>>> 4.) is there support/an interface for tar pitting? >>>>> >>>>> Is it possible to filter mails into folders by some kind of >>>>> regular expressions (I currently do this with procmail and IMAP)? >>>>> >>>>> Regards >>>>> Rene >>>>> _______________________________________________ >>>>> Dbmail mailing list >>>>> Dbmail@dbmail.org >>>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail >>>>> >>>> >>>> _________________________ >>>> R.A. Rozendaal >>>> IC&S >>>> T: +31 30 63 55 736 >>>> F: +31 30 63 55 731 >>>> www.ic-s.nl >>>> >>>> _______________________________________________ >>>> Dbmail mailing list >>>> Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail >>>> _______________________________________________ >>>> Dbmail mailing list >>>> Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail >>> >>> -- >>> "For many years it was believed that countless monkeys on countless >>> typewriters would eventually reproduce the genius of Shakespeare. >>> Now, thanks to the World Wide Web, we know this to be false." >>> --anonymous Internet hero >>> >>> _______________________________________________ >>> Dbmail mailing list >>> Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail >>> _______________________________________________ >>> Dbmail mailing list >>> Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail >>> >> _________________________ >> R.A. Rozendaal >> IC&S >> T: +31 30 63 55 736 >> F: +31 30 63 55 731 >> www.ic-s.nl >> _________________________ >> R.A. Rozendaal >> IC&S >> T: +31 30 63 55 736 >> F: +31 30 63 55 731 >> www.ic-s.nl >> _______________________________________________ >> Dbmail mailing list >> Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail >> _______________________________________________ >> Dbmail mailing list >> Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail > > -- > ________________________________________________________________ > Paul Stevens mailto:[EMAIL PROTECTED] > NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED] > The Netherlands________________________________http://www.nfg.nl > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail > _________________________ R.A. Rozendaal IC&S T: +31 30 63 55 736 F: +31 30 63 55 731 www.ic-s.nl _______________________________________________ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
