Bug#441960: openser-postgres-module: Fails to connect to running Postgresql.

[Jan-Hendrik Palic]

Package: openser-postgres-module
Version: 1.2.2-1
Severity: normal


Hi,

installing openser 1.2.2-1 selfbackported on etch with the postgresql-module
fails to connect to the database server and database. The database is propagated
with the postgresqldb.sh script, which is located in the source of openser.

I looked around and found the following thread an solution under 

http://openser.org/pipermail/users/2007-August/012641.html

which described the problem I had.

I already prepared a patch:

#! /bin/sh /usr/share/dpatch/dpatch-run
## 12_ability_to_connect_to_psql.dpatch by <Daniel.Frey at external.t-mobile.de>
##
## All lines beginning with `## DP:' are a description of the patch.
## DP: 1.2.2 is not able to connect to psql, this patch fix it.

@DPATCH@
diff -Nurd a/modules/postgres/db_res.c b/modules/postgres/db_res.c
--- a/modules/postgres/db_res.c 2007-08-16 16:23:05.000000000 +0200
+++ b/modules/postgres/db_res.c 2007-09-12 10:30:58.000000000 +0200
@@ -572,6 +572,7 @@
   * If this is not done, a memory leak will happen.
   */
  for (col = 0; col < ROW_N(_row); col++) {
+   _val = &(ROW_VALUES(_row)[col]);
           switch (VAL_TYPE(_val)) {
             case DB_STRING:
               LOG(L_DBG, "PG[free_row]: %p=pkg_free() VAL_STRING[%d]\n", (char *)VAL_STRING(_val), col);

Regards

Jan

-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.21-2-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_GB at euro, LC_CTYPE=en_GB at euro (charmap=ISO-8859-15) (ignored: LC_ALL set to en_GB.ISO-8859-15)
Shell: /bin/sh linked to /bin/bash