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 syslog
#
# Logging is broken up into 8 logging levels and each level can be
indivually turned on or off.
# The Stderr/log file logs all entries to stderr or the log file.
# Syslog logging uses the facility mail and the logging level of the
event for logging.
# Syslog can then be configured to log data according to the levels.
#
# Set the log level to the sum of the values next to the levels you
want to record.
# 1 = Emergency
# 2 = Alert
# 4 = Critical
# 8 = Error
# 16 = Warning
# 32 = Notice
# 64 = Info
# 128 = Debug
# 256 = Database -> Logs at debug level
#
# Examples: 0 = Nothing
# 31 = Emergency + Alert + Critical + Error + Warning
# 511 = Everything
#
file_logging_levels = 7
#
syslog_logging_levels = 31
(be careful when posting high debug level ones they do contain
(cleartext) passwords!
On 2013-04-26 14:02, Alfredo Saldanha wrote:
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
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
