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 <lord...@lordvan.com> wrote: > 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 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-users -a junix -w password >> >> After that I create a forward: >> dbmail-users -x junix -t ju...@mydomain.com >> >> After that I create a archive forward: >> dbmail-users -x junix -t ju...@archive-inbound.mydomain.com >> dbmail-users -x junix -t ju...@archive-outbound.mydomain.com >> >> My postfix main.cf: http://dpaste.com/1073259/ >> >> /etc/postfix/virtual_alias_maps.cf: >> user = postfix >> password = DBPASSWD >> hosts = unix:/var/lib/mysql/mysql.sock >> dbname = dbmailarc >> query = SELECT alias FROM dbmail_aliases WHERE alias = '%s' >> >> /etc/postfix/transport: >> archive-inbound.mydomain.com dbmail-archive-inbound: >> archive-outbound.mydomain.com dbmail-archive-outbound: >> >> /etc/postfix/master.cf: >> # >> # DBMail >> # >> dbmail-lmtp unix - - n - - lmtp >> >> dbmail-archive-inbound unix - n n - - >> pipe >> flags=RDO user=dbmail >> argv=/usr/local/sbin/dbmail-archive-inbound ${recipient} >> >> dbmail-archive-outbound unix - n n - - >> pipe >> flags=RDO user=dbmail >> argv=/usr/local/sbin/dbmail-archive-outbound ${recipient} >> >> /usr/local/sbin/dbmail-archive-inbound: >> #!/bin/sh >> # email account should be passed as $1 >> cat - | /usr/sbin/dbmail-deliver -u "$1" -m >> "INBOX/Incoming/$(/bin/date +%Y)/$(/bin/date +%m)" >> >> /usr/local/sbin/dbmail-archive-outbound: >> #!/bin/sh >> # email account should be passed as $1 >> cat - | /usr/sbin/dbmail-deliver -u "$1" -m >> "INBOX/Outgoing/$(/bin/date +%Y)/$(/bin/date +%m)" >> >> When I try to send some message, I've got this: >> maillog: http://dpaste.com/1073254/ >> >> In my database the messages table is zero rows. =( >> >> Thank you. >> _______________________________________________ >> DBmail mailing list >> DBmail@dbmail.org >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
