Sigh. I found two my mistakes. Both in the dbmail_filters table.
1. The headername was capitalized so it never matched the dbmail_headername.
2. The headervalue is [email protected]; not just support.
With those changes, the filter table is being consulted. And the
appropriate mailbox found. But mail is till delivered to INBOX. Here is
what seems to be the relevant section of the log:
dbmail-lmtpd[23137]: [0x7fb58981fa00] Database:[db]
db_stmt_prepare(+411): [0x7fb58986dc90] [SELECT
f.mailbox,f.headername,f.headervalue FROM dbmail_filters f JOIN
dbmail_headername n ON f.headername=n.headername JOIN dbmail_header h ON
h.headername_id = n.id join dbmail_headervalue v on
v.id=h.headervalue_id WHERE v.headervalue ILIKE f.headervalue AND
h.physmessage_id=? AND f.user_id in (?,?)]
dbmail-lmtpd[23137]: [0x7fb58981fa00] Database:[db]
db_stmt_set_u64(+431): [0x7fb589888e60] 1:[76]
dbmail-lmtpd[23137]: [0x7fb58981fa00] Database:[db]
db_stmt_set_u64(+431): [0x7fb589888e60] 2:[16]
dbmail-lmtpd[23137]: [0x7fb58981fa00] Database:[db]
db_stmt_set_u64(+431): [0x7fb589888e60] 3:[17]
dbmail-lmtpd[23137]: [0x7fb58981fa00] Debug:[message]
get_mailbox_from_filters(+1950): match [to: [email protected]]
file-into mailbox [support]
At this point, we have the right mailbox
dbmail-lmtpd[23137]: [0x7fb58981fa00] Info:[message]
sort_and_deliver(+1999): Destination [[email protected]] useridnr
[17], mailbox [support], source [0]
dbmail-lmtpd[23137]: [0x7fb58981fa00] Info:[misc] find_bounded(+297):
Missing part or all of our bounding points
dbmail-lmtpd[23137]: [0x7fb58981fa00] Database:[db]
db_stmt_prepare(+411): [0x7fb58986dc90] [SELECT name FROM
dbmail_sievescripts WHERE owner_idnr = ? AND active = 1]
There are no sievescripts
dbmail-lmtpd[23137]: [0x7fb58981fa00] Database:[db]
db_stmt_set_u64(+431): [0x7fb589888bc0] 1:[17]
dbmail-lmtpd[23137]: [0x7fb58981fa00] Debug:[db] db_findmailbox(+1896):
looking for mailbox with FQN [yes].
At this point, it seems to be looking for a mailbox with the FQN of
"yes" which it will not find.
dbmail-lmtpd[23137]: [0x7fb58981fa00] Debug:[misc]
mailbox_remove_namespace(+202): [yes]
dbmail-lmtpd[23137]: [0x7fb58981fa00] Database:[db]
db_stmt_prepare(+411): [0x7fb58986dc90] [SELECT mailbox_idnr FROM
dbmail_mailboxes WHERE owner_idnr = ? AND name ILIKE ? ]
dbmail-lmtpd[23137]: [0x7fb58981fa00] Database:[db]
db_stmt_set_u64(+431): [0x7fb589888f20] 1:[17]
dbmail-lmtpd[23137]: [0x7fb58981fa00] Database:[db]
db_stmt_set_str(+419): [0x7fb589888f20] 2:[yes]
office dbmail-lmtpd[23137]: [0x7fb58981fa00] Info:[db]
db_findmailbox(+1917): no mailbox [yes] for owner [17]
dbmail-lmtpd[23137]: [0x7fb58981fa00] Debug:[db] db_findmailbox(+1896):
looking for mailbox with FQN [INBOX].
And now, we are looking for INBOX again.
On 08/26/2013 08:33 AM, Lynn Dobbs wrote:
On 08/24/2013 03:40 AM, Paul J Stevens wrote:
Lynn,
I don't see any glaring omissions. Can you post a debug 511 log for the
delivery?
On 08/24/2013 02:25 AM, Lynn Dobbs wrote:
dbmail 3.1.3
Dbmail_users
user_idnr | userid | passwd | client_idnr
| (etc)
-----------+--------------------------------+--------+-------------+
16 | anyone | | 0 |
15 | __@!internal_delivery_user!@__ | | 0 |
17 | __public__ | | 0 |
18 | [email protected] | foo | 0 |
Dbmail_mailboxes
mailbox_idnr | owner_idnr | name | (etc)
--------------+------------+---------+
30 | 18 | INBOX |
31 | 17 | support |
32 | 15 | INBOX |
33 | 17 | INBOX |
dbmail_aliases;
alias_idnr | alias | deliver_to | (etc)
------------+-------------------------+------------+
10 | [email protected] | 17 |
dbmail_acl;
user_id | mailbox_id | lookup_flag | (etc)
---------+------------+-------------+
18 | 30 | 1 |
18 | 31 | 1 |
18 | 33 | 1 |
dbmail_filters;
user_id | id | headername | headervalue | mailbox
---------+----+------------+-------------+---------
17 | 2 | To | support | support
What have i missed?
Lynn
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
