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

Reply via email to