Re: [Dbmail] dbmail archiving

2013-04-26 Thread Thomas Raschbacher
according to http://workaround.org/ispmail/lenny/postfix-database-mappings it shouldn'T matter if you return the alias or the 1 (my query). but the 1 is probably the save option to avoid any problems.. from the manpage: http://linux.die.net/man/5/dbmail.conf # Logging via stderr/log file and

Re: [Dbmail] dbmail archiving

2013-04-26 Thread Alfredo Saldanha
My query I got from the archiving-howto: query = SELECT alias FROM dbmail_aliases WHERE alias = '%s' But I'll try yours. I didn't find out how to improove my logs. Do you have some idea how to debug better dbmail ? On Fri, Apr 26, 2013 at 6:59 AM, Thomas Raschbacher wrote: > Hi. > > one thing I

Re: [Dbmail] dbmail archiving

2013-04-26 Thread Thomas Raschbacher
Hi. one thing I noticed is that your SQL query is different from mine.. I got this: query = select distinct 1 from dbmail_aliases where alias='%s' apart from that you could try to turn up logging more. Regards On 2013-04-25 16:32, Alfredo Saldanha wrote: Hi there, I'm trying to implement

[Dbmail] dbmail archiving

2013-04-25 Thread Alfredo Saldanha
Hi there, I'm trying to implement Mail Archiving solution using dbmail. I'm following the document: http://www.dbmail.org/dokuwiki/doku.php/archiving-howto Everything was made by the document, but I can't receive messages. My dbmai.conf: http://dpaste.com/1073240/ I've created a user: dbmail-use

[Dbmail] Archiving with Postfix and DBMail (howto)

2006-01-06 Thread Adam Kosmin
Hello everyone, Just thought I'd mention my contribution to the wiki. http://www.dbmail.org/dokuwiki/doku.php?id=archiving-howto Very quickly, the goals of the project are as follows: All inbound and outbound mail should be archived to a separate database. Mail should be archived according to

Re: [Dbmail] archiving

2005-11-23 Thread Adam Kosmin
I do it because I wanted to insert the mail dynamically (based on user and date). This is just my approach of course and may not be inline with your needs. Just throwing the idea out. Adam Rod G wrote: Thanks for sharing your information Adam. Is procmail necessary for inserting the mail int

Re: [Dbmail] archiving

2005-11-23 Thread Rod G
Thanks for sharing your information Adam. Is procmail necessary for inserting the mail into the MySQL database? I'm pretty green on procmail and how dbmail inserts into the database. Thanks, Rod On 11/23/05, Adam Kosmin <[EMAIL PROTECTED]> wrote: > I'm building this very system myself using dbma

Re: [Dbmail] archiving

2005-11-23 Thread Adam Kosmin
I'm building this very system myself using dbmail/postfix/procmail/mysql 5.x. Here are some tips to get you started... First, my assumptions: I assume you will have an archive server (archive.example.com) running another instance of postfix and dbmail. Users will have an account on the archi

Re: [Dbmail] archiving

2005-11-23 Thread Jesse Norell
On Wed, 2005-11-23 at 10:57 -0500, Rod G wrote: > Hello, > > I am interested in introducing dbmail into a system without modifying > how the current system works. I would like to use dbmail for message > archiving purposes. My MTA is postfix. I would like to setup all mail > -- sent and received -

[Dbmail] archiving

2005-11-23 Thread Rod G
Hello, I am interested in introducing dbmail into a system without modifying how the current system works. I would like to use dbmail for message archiving purposes. My MTA is postfix. I would like to setup all mail -- sent and received -- to be archived into a database. Is this possible to setup