And while we're on the subject of leftover garbage destined for /dev/null:
Why does the 2.0 tree still contain all the pre-1.0 sql fixes, and a
bogus mysql2pgsql tree ??
Very confusing stuff for new users, I'm sure.
Also,
Has a new tag been introduced into the CVS tree? When I'm updating the
HEAD branch, the migration code for mysql is missing, and the python
scripts remain in place.
Paul J Stevens wrote:
> 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: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] 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: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] 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: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] 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
>>>> mymaillist@server.org you@private.net
>>>> mymaillist@server.org he@external.com
>>>> mymaillist@server.org metoo@private.net
>>>> 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 myalias@server.org mydestination@anotherplace.com
>>>> 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 myalias@server.org (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: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] 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: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] 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:paul@nfg.nl
>>> NET FACILITIES GROUP PGP: finger paul@nfg.nl
>>> 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 paul@nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
Why does the 2.0 tree still contain all the pre-1.0 sql fixes, and a
bogus mysql2pgsql tree ??
Very confusing stuff for new users, I'm sure.
Also,
Has a new tag been introduced into the CVS tree? When I'm updating the
HEAD branch, the migration code for mysql is missing, and the python
scripts remain in place.
Paul J Stevens wrote:
> 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: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] 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: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] 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: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] 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
>>>> mymaillist@server.org you@private.net
>>>> mymaillist@server.org he@external.com
>>>> mymaillist@server.org metoo@private.net
>>>> 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 myalias@server.org mydestination@anotherplace.com
>>>> 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 myalias@server.org (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: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] 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: dbmail-admin@dbmail.org [mailto:dbmail-admin@dbmail.org] 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:paul@nfg.nl
>>> NET FACILITIES GROUP PGP: finger paul@nfg.nl
>>> 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 paul@nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl