anyone use MailScanner with dbmail and postfix>

_______________________________________________
Dbmail mailing list
Dbmail <at> dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

dbnews

Earlier a thread was started regarding an nntp frontend to the dbmail
system.

Is there any progress on this or has it been canned?
I think it would make a great addition to dbmail for mailing lists and
small newsfeeds.

... John

Pop3

Hi,

When using getmail to fetch messages via pop3, I've noticed that it
always fetches mail in descending date order. Is there any reason why
they're not fetched in ascending date order?

... John

Re: dbmail_auto_notifications & dbmail_auto_replies

Is there a possiblity that someone could outline these tables and what 
they are used for? There are several requests for the info? Please?

We are building a backend management system which encorpoates DBmail and 
it would be good to understand these more fully.

Kirti S. Bajwa wrote:
> Me too. I was going to post a request just when I saw this post. Maybe sone
> dbMail gurus can explain one table each.
> 
> Kirti
> 
> -----Original Message-----
> From: Alessandro Magnolo [mailto:alessandro.magnolo <at> gmail.com]
> Sent: Monday, September 27, 2004 5:46 PM
> To: DBMail mailinglist
> Subject: Re: [Dbmail] dbmail_auto_notifications & dbmail_auto_replies
> 
> 
> 
>>Can someone give details on what these tables are used for and how they
>>work?
> 
> 
> I too would like some documentation about the DB structure.
> I figured out some info from the source code, but what a pain! 
> 
> Alessandro
> _______________________________________________
> Dbmail mailing list
> Dbmail <at> dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> _______________________________________________
> Dbmail mailing list
> Dbmail <at> dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> 
> 

Re: dbnews

I, at one time, asked the question, and spurred some tangential 
conversation about another feature.....

Well, anyway, work got in the way, and my needs changed.

Is there anyone else working on nntp?

ed

On Mon, 4 Oct 2004, John Hansen wrote:

> Earlier a thread was started regarding an nntp frontend to the dbmail
> system.
>
> Is there any progress on this or has it been canned?
> I think it would make a great addition to dbmail for mailing lists and
> small newsfeeds.
>
> ... John
>
> _______________________________________________
> Dbmail mailing list
> Dbmail <at> dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>

DBMAIL 2.0rc8 and Gentoo

Hello,

Yesterday I decided to try out dbmail. I've gotten it working with
postgresql, fetchmail, exim and sylpheed in order to retrieve and read
my email. But I had some problems and some questions.

First of all, I'm using this on gentoo. I saw the contributed startup
scripts in the dbmail tarball so I figure there must be other gentoo
users too.  Does anyone have a good ebuild for this? I saw the ebuild in
the following bug report, but it didn't work at all (it wasn't even
doing a make install). I played around with that enough to get it to
work but it's definitely not perfect, and I really don't know much about
ebuilds so I'd be excited to see one from someone who knows what they're
doing. 

http://bugs.gentoo.org/show_bug.cgi?id=22331

I've also had trouble with the provided startup scripts. If I try to
stop dbmail-lmtpd or dbmail-imapd, I get an error like, "can't find a
process with that pid". So I edited scripts to stop the processes by
name instead. That seems to work, but I still have other problems. I
just rebooted and the script did not know to wait until after
postgressql to start. That's a simple fix, but what troubled me was that
the startup script thought everything was ok when it wasn't. Then the
system was in this state where I couldn't restart dbmail because it
already thought it was started. 

Also,  everything was working fine last night, but when I
woke up this morning, I found my dbmail was dead! No lmtp or imap
process at all. I didn't have the trace logging turned up very high
(level 1) but there were no logs at all saying dbmail was shutting down
or why. Any ideas?

Allen

_______________________________________________
Dbmail mailing list
Dbmail <at> dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail-dev] Re: Malformed headers in Outlook Express

Hello Dan,

> Aaron Stone wrote:
> 
> >>From the file dbmail/EXTRAS:
> >
> >    Dbmail can forward to external programs. 
> >    Create an alias. Set the deliver_to for that alias to:
> >    "|/usr/bin/procmail" will pipe the message for the alias to procmail
> >    "!/usr/bin/procmail" will do the same but add a mbox style header 

  The "mbox style header" Aaron was pointing out is the very "From " line
you mention below that is causing you problems.  Ie. change "!" to "|" in
your deliver_to.

> >Dan Stilts <dstilts <at> allmopars.com> said:
> >
> >  
> >
> >>one other bit of info i just noticed
> >>
> >>When comparing the headers from the two emails (one sent to alias with 
> >>deliver_to set to procmail, which is then inserted again using 
> >>dbmail-smtp -m "INBOX" -u <user>, and one sent to deliver_to of the uid 
> >>of the account), I notice an extra line being added to the end:
> >>
> >> From dstilts <at> allmopars.com Tue Oct 5 10: 26:00 2004
> >>

--
Jesse Norell

administrator <at> kci.net is not my email address;
change "administrator" to my first name.
--

from sendmail to dbmail

I start by describing my setup.
Old system is redhat 9 system, with sendmail. All mail accounts are unix 
user accounts, very simple setup.
New system is based on gentoo, running postfix and dbmail.

We have multiple domains, some hosting and some of our own. We want to 
move from old to new. Accounts I can make, no problem. But some of the 
users have messages in their boxes, and thats the problem I'm trying to 
solve.
I wouldn't like to explain to our users, that their mail isn't there 
anymore. So I'm asking help on the subject. Any ideas howto move mail 
from sendmail system to dbmail-system.

I'm not that good at explaining this and I know that I'm forgetting to 
tell something important.If someone wants to help me,  I will gladly 
provide the missing information when asked..

new to dbmail, liked what I have seen so far.
Thanks in advance.
Henrik Andersson
henrik (at) 8bits (dot) fi

RE: from sendmail to dbmail

Hello,

  There's a utility called mbox2dbmail (I think) that will
convert those.  Probably the easiest way would be to copy
all your mail from the old server to a temporary place on
the new one and run it there (otherwise you have to also
setup network access from your old server to the database
on your new one).  It's been quite a while since I've done
that, and I think at the time it required a simple shell
script to run through all the mailboxes and run it on each
one ... search the archives of this mailing list and check
man pages for more info.  Reply back here if you get stuck,
and I'm sure someone can help.

Jesse

---- Original Message ----
From: Henrik Andersson <dbmail <at> dbmail.org>
To: dbmail <at> dbmail.org
Subject: [Dbmail] from sendmail to dbmail
Sent: Wed, 06 Oct 2004 04:12:42 +0300

> I start by describing my setup.
> Old system is redhat 9 system, with sendmail. All mail accounts are unix 
> user accounts, very simple setup.
> New system is based on gentoo, running postfix and dbmail.
> 
> We have multiple domains, some hosting and some of our own. We want to 
> move from old to new. Accounts I can make, no problem. But some of the 
> users have messages in their boxes, and thats the problem I'm trying to 
> solve.
> I wouldn't like to explain to our users, that their mail isn't there 
> anymore. So I'm asking help on the subject. Any ideas howto move mail 
> from sendmail system to dbmail-system.
> 
> I'm not that good at explaining this and I know that I'm forgetting to 
> tell something important.If someone wants to help me,  I will gladly 
> provide the missing information when asked..
> 
> new to dbmail, liked what I have seen so far.
> Thanks in advance.
> Henrik Andersson
> henrik (at) 8bits (dot) fi
> _______________________________________________
> Dbmail mailing list
> Dbmail <at> dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> 
-- End Original Message --

--
Jesse Norell

administrator <at> kci.net is not my email address;
change "administrator" to my first name.
--

Anyone interested in SPF for their Postfix/DbMail Setup?

FYI:
Anyone interested in enabling  SPF (plus MS CALLER-ID if desired) for 
their Postfix MTA / DbMail system?
This is not intended as a recommendation but if you have considered 
implementing the new SPF I have been running the Postfix SMTP policy 
daemon with Postfix/DbMail with good result.

SPF is worth watching now as it is widely becoming the (open-source) 
sender policy framework of choice over TEOS, CALLER-ID and many other 
proposals.

SPF is an SMTP MTA policy daemon. No change to your DbMail installation 
is indicated but SPF certainly is a plus for your DbMail system, 
preventing 'junk' from entering your mail storage database.
SPF relies on a DNS Zone TXT entry to indicate which MX servers are 
allowed to handle mail for the zone and what zones if any it handles 
mail for. Check your DNS. Soon everyone will be getting SPF bounces 
until they correctly configure their DNS servers to indicate their 
authorized MXs.
Try this: http://spf.pobox.com/wizard.html?mydomain=<ENTER YOUR DOMAIN> )

Mail::SPF::Query for POSTFIX 2.1/2.2 can be implemented with:
i) a simple PERL policy daemon;
ii) 2 new PERL modules (and if your PERL needs it, a sprucing up of 
NET:: modules) and
iii) a master.cf/main.cf config change.

Mail::SPF::Query is at:
(http://search.cpan.org/~freeside/Mail-SPF-Query-1.997/ )

(MS CALLER-ID) LMAP::CID2SPF Is at:
http://www.baschny.de/spf/LMAP-CID2SPF-0.9.tar.gz

Postfix policy daemon is here:
http://spf.pobox.com/postfix-policyd.txt

INSTALLATION:
Please read Postfix's README_FILES/SMTPD_POLICY_README

MASTER.CF
  policy  unix  -       n       n       -       -       spawn
      user=nobody argv=/usr/bin/perl /usr/libexec/postfix/smtpd-policy.pl

MAIN.CF (note that order is critical)
  smtpd_recipient_restrictions =
    ...
    reject_unknown_sender_domain,
    reject_unauth_destination,
    check_policy_service unix:private/policy,
    ...

LINKS: Postfix SMTP Policy Info
http://www.ipnet6.org/postfix/spf/    -Postfix Patch home page
http://spf.pobox.com/                          - SPF background
http://www.libspf2.org/                      - LibSPF2 site
http://www.trusted-forwarder.org/    - Global whitelist
http://www.postfix.org/                      - Postfix home page

I have no experience with these so I can't vouch for  SPF on  Sendmail, 
Qmail, Exim but overall reports are fair to excellent.
See: http://www.libsrs2.org/status.html  for Sendmail, Qmail, Exim -  
SPF help.

best to all...
Mike

-=-=-=-=-=-=-
DBMA (PERL CGI GUI DbMail Administrator)
Latest Version 2.1.1 at http://library.mobrien.com/dbmailadministrator/)