Bug Tracker item #2881599, was opened at 2009-10-19 10:40 Message generated for change (Comment added) made by sbajic You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2881599&group_id=250683
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: daemon Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nicolas Haller (gaasmann) Assigned to: Nobody/Anonymous (nobody) Summary: failure with Dpsam and Postgresql Initial Comment: HI, I have a problem with DSPAM 3.8.0 and I don't know if it's resolved in 3.9.0 (I don't see any clue in ChangeLog). I have a process chain to analyse spam: Internet----SMTP/25----Postfix----LMTP/4242----DSPAM----SMTP/10024----amavisd-new----SMTP/10025----Postfix----transport/deliver Dspam works with a PgSQL DB. When Pg fails(connection refused, DB can't answer to a request, ...) Dspam reject all future email. It send an error "530 5.2.0 Message is empty. Aborting." in the LMTP transaction. I must restart DSPAM daemon to accept new mail correctly. If you need more infos, tell me. Thanks ---------------------------------------------------------------------- >Comment By: Stevan Bajic (sbajic) Date: 2009-10-19 11:39 Message: Hallo Nicolas As far as I know, PostgreSQL does not offer an autoconnect feature as MySQL does. So the only way to to fix that issue in the PostgreSQL driver would be to shut down all (or just the ones not being able to connect) the connections from DSPAM to PostgreSQL and reopen them. Is it possible for you to post some more debugging information or error logs indicating where the error inside DSPAM is happening? How is your setup? Does PostgreSQL run on the same system as DSPAM? How do you connect to PostgreSQL? Using TCP/IP or do you use sockets? Do you know if your PostgreSQL instance has gone away while DSPAM was running? Have you tried to use connection profiles with DSPAM? Kind Regards from Switzerland Stevan Bajic ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2881599&group_id=250683 ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
