>From dbmail 1.2.3, from create_tables.pgsql:
Status: O
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
