Package: ejabberd Version: 2.1.10-4 Severity: grave Justification: error in some querys to database causes malfuntion on xmmp server Tags: patch wheeze
Postgresql not support "//" escape strings, only "/'" that its standar sql99, and do not cause problem in others database odbc engines. when i enable ejabberd mod_private users and other that use odbc conection, see errors in log, for querys.. configured to use postgresql to stored the amount huge users in the enterprise. HOW TO REPRODUCE ERROR: 1) configure the ejabberd with odbc potgresql conection 2) change to enable all odbc related modules, EXCEPT VCARD (miscdocumented) 3) tail /var/log/ejabberd/ejabberd.log | grep odbc u can see error querys wuth this if users start private chats.. HOW TO FIX: please patch that file as: src/odbc/odbc_queries.erl @@ -557,7 +557,7 @@ escape($\n) -> "\\n"; escape($\t) -> "\\t"; escape($\b) -> "\\b"; escape($\r) -> "\\r"; -escape($') -> "\\'"; +escape($') -> "''"; escape($") -> "\\\""; escape($\\) -> "\\\\"; escape(C) -> C. Postgresql not support "//" escape strings, only "/'" that its standar sql99 -- System Information: Debian Release: 7.0.0 APT prefers stable APT policy: (900, 'papachama'), (750, 'stable'), (600, 'testing'), (550, 'unstable'), (500, 'experimental') Architecture: i386 (x86) Kernel: Linux 3.0.0-venenux-libre-1 (SMP w/8 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash -- Lenz McKAY Gerardo (PICCORO) http://venenux.net -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
