The config table is more legacy garb^H^H^H^Hleftover that *was* removed
from the mysql tables, and *should* have been removed from the
postgresql tables as well.
In the old-days (pre-1.0) the config tables contained some of the
settings that are nowadays present in the config-file.
Even though there is some talk on the -devel list on reviving that table
for new uses, it is in fact not in use today.
John Hansen wrote:
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
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
