Bug Tracker item #3413998, was opened at 2011-09-26 04:53 Message generated for change (Comment added) made by duck207 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3413998&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: None Group: v3.10.x Status: Pending Resolution: None Priority: 5 Private: No Submitted By: Ingo Theiss (itheiss) Assigned to: Stevan Bajic (sbajic) Summary: DSPAM broken after upgrade to PostgreSQL 9.1 Initial Comment: After PostgreSQL 9.1 has hit Debian/testing DSPAM fails to insert data into the table 'dspam_signature_data' (see attached sql_erros.txt). After digging around in the source code I have seen the function 'PQescapeByteaConn' (pgsql_drv.c line 1574) is used to escape the data. Unfortunately with PostgreSQL 9.1 the default from the setting 'standard_conforming_strings' has changed from 'off' to 'on'. Please read the following thread as I am not an expert in C-Programming nor in PostgreSQL: http://postgresql.1045698.n5.nabble.com/PQescapeByteaConn-returns-wrong-string-for-PG9-1-Beta3-td4667713.html I can confirm that DSPAM is working again if I set 'standard_conforming_strings = off' in my postgresql.conf. But since the new default for PostgreSQL 9.1 is 'standard_conforming_strings = on' this should be considered in pgsql_drv.c. ---------------------------------------------------------------------- Comment By: The Duck (duck207) Date: 2012-12-11 17:07 Message: I got warnings with this fix and standard_conforming_strings to off and this resulted in DSPAM returning with a non-zero exit code and mail delivery failure. Maybe seeting escape_string_warning to off would help, as it warns if any backslash is found in the string, even if doubled. As i can now switch standard_conforming_strings to on, i just did, then i should be able to ping this bug if the fix is not enough. ---------------------------------------------------------------------- Comment By: Ingo Theiss (itheiss) Date: 2011-10-03 01:55 Message: Hi Stevan, so far I have used the Debian packages from Julien Valroff (http://www.kirya.net/) which are available from the official Debian Backports repository. I will try to compile the pgsql part and the if problem still exists. Regards, Ingo ---------------------------------------------------------------------- Comment By: Stevan Bajic (sbajic) Date: 2011-10-01 02:37 Message: Hello Ingo, can you try latest GIT version of DSPAM and tell me if the problem still exists there? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3413998&group_id=250683 ------------------------------------------------------------------------------ LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
