The following issue has been CLOSED ====================================================================== http://www.dbmail.org/mantis/view.php?id=824 ====================================================================== Reported By: ribasushi Assigned To: ====================================================================== Project: DBMail Issue ID: 824 Category: Database layer Reproducibility: unable to reproduce Severity: block Priority: normal Status: closed target: Resolution: no change required Fixed in Version: ====================================================================== Date Submitted: 26-Dec-09 10:45 CET Last Modified: 15-Jan-10 21:54 CET ====================================================================== Summary: Mysterious failures while operating over a network Description: I tried to move the mysql database of a perfectly running 3 year old 50GB dbmail installation to a standalone database server. While on the surface things appear to work smoothly, there is some inexplicable behavior on some operations if the database and the dbmail binary are on different machines. Everything works fine as long as the packets do not leave the host. I can reliably reproduce this with dbmail-util as shown below. I get similar errors (same message "...for the right syntax to use near '' at line 1..." different SELECT query) with dbmail-smtp insertion for *some* messages. There seems to be no corelation between message size and failure. ======================================================================
---------------------------------------------------------------------- (0002961) ribasushi (reporter) - 26-Dec-09 10:46 http://www.dbmail.org/mantis/view.php?id=824#c2961 ---------------------------------------------------------------------- It seems that this is *somewhat* related to bug#0000816, however all of the problems go away when the dbmail process and the database are on the same host, even if they are connected via smtp (socket explicitly disabled, an internet facing ip chosen as host) Issue History Date Modified Username Field Change ====================================================================== 26-Dec-09 10:45 ribasushi New Issue 26-Dec-09 10:46 ribasushi Note Added: 0002961 15-Jan-10 21:54 paul Reproducibility always => unable to reproduce 15-Jan-10 21:54 paul Status new => closed 15-Jan-10 21:54 paul Resolution open => no change required ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev