The following issue has been SUBMITTED. ====================================================================== http://dbmail.org/mantis/view.php?id=618 ====================================================================== Reported By: asianux-keith Assigned To: ====================================================================== Project: DBMail Issue ID: 618 Category: Database layer Reproducibility: always Severity: block Priority: normal Status: new target: ====================================================================== Date Submitted: 28-Jun-07 05:10 CEST Last Modified: 28-Jun-07 05:10 CEST ====================================================================== Summary: Mail addressing fouled when using sqlite backend. msgs lost. Description: When sending a message from thunderbird or evolution to a server with postfix and dbmail 2.2.5 and a sqlite(3) backend, the address decoding appears to foul up, resulting in the message being delivered incorrectly (inserted/deleted) but reported to MTA as sent, and therefore it is lost.
Note garbage in 2nd "checking user [<D0>&http://dbmail.org/mantis/view.php?id=817; `<C1>~]" Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Info:[dsn] dsn.c,dsnuser_resolve(+585): checking if [EMAIL PROTECTED] is a valid username, alias, or catchall. Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Debug:[auth] authsql.c,auth_check_user_ext(+203): checking user [EMAIL PROTECTED] in alias table Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Debug:[auth] authsql.c,auth_check_user_ext(+220): checks [0] Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Debug:[sql] dbsqlite.c,db_query(+339): SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('[EMAIL PROTECTED]') AND lower(alias) <> lower(deliver_to) Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Debug:[auth] authsql.c,auth_check_user_ext(+254): into checking loop Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Debug:[auth] authsql.c,auth_check_user_ext(+260): checking user [EMAIL PROTECTED] to 6 Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Debug:[auth] authsql.c,auth_check_user_ext(+203): checking user [<D0>&http://dbmail.org/mantis/view.php?id=817; `<C1>~] in alias table Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Debug:[auth] authsql.c,auth_check_user_ext(+220): checks [1] Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Debug:[sql] dbsqlite.c,db_query(+339): SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('<D0>&http://dbmail.org/mantis/view.php?id=817; `<C1>~') AND lower(alias) <> lower(deliver_to) Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Debug:[auth] authsql.c,auth_check_user_ext(+242): adding [] to deliver_to address Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Debug:[dsn] dsn.c,address_has_alias(+251): user [EMAIL PROTECTED] found total of [1] aliases Jun 28 17:50:24 dhcp12 dbmail/smtp[8225]: Info:[dsn] dsn.c,dsnuser_resolve(+592): delivering [EMAIL PROTECTED] as an alias. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 28-Jun-07 05:10 asianux-keith New Issue 28-Jun-07 05:10 asianux-keith File Added: dbmail-config+logs.tar.bz2 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
