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
