Debian Bug report logs - #568119
openerp-server: unable to create a database

Display info messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: Toni Mueller <support@oeko.net>

To: submit@bugs.debian.org

Cc: support@oeko.net

Subject: openerp-server: unable to create a database

Date: Tue, 2 Feb 2010 16:22:48 +0100

Package: openerp-server
Version: 5.0.6-3
Severity: important

*** Please type your report below this line ***


Hello,

if used together with postgresql-8.4, openerp-server uses an inappropriate SQL
statement to create the initial database. This results in no database being
created, thus the inability to make any kind of use of the package.

The following patch fixes this:

--- web_services.py.orig	2009-09-22 15:18:06.000000000 +0200
+++ web_services.py	2010-02-02 15:46:05.000000000 +0100
@@ -75,7 +75,7 @@
         cr = db.serialized_cursor()
         try:
             cr.autocommit(True) # XXX inhibit the effect of a serialized cursor. is it what we want ?
-            cr.execute('CREATE DATABASE "%s" ENCODING \'unicode\'' % db_name)
+            cr.execute('CREATE DATABASE "%s" ENCODING \'unicode\' TEMPLATE template0' % db_name)
         finally:
             cr.close()
             sql_db.close_db('template1')


Kind regards,
--Toni++


-- System Information:
Debian Release: squeeze/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'proposed-updates'), (500, 'stable'), (250, 'unstable')
Architecture: i386 (i686)

Kernel: Linux 2.6.32-trunk-686-bigmem (SMP w/4 CPU cores)
Locale: LANG=de_DE.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages openerp-server depends on:
ii  adduser                      3.112       add and remove users and groups
ii  debconf [debconf-2.0]        1.5.28      Debian configuration management sy
ii  python                       2.5.4-9     An interactive high-level object-o
ii  python-libxslt1              1.1.26-1+b1 Python bindings for libxslt1
ii  python-lxml                  2.2.4-1+b1  pythonic binding for the libxml2 a
ii  python-psycopg2              2.0.13-2+b1 Python module for PostgreSQL
ii  python-pychart               1.39-7      Python library for creating high q
ii  python-pydot                 1.0.2-1     Python interface to Graphviz's dot
ii  python-reportlab             2.3-1       ReportLab library to create PDF do
ii  python-tz                    2009u-1     Python version of the Olson timezo

Versions of packages openerp-server recommends:
ii  ghostscript                8.70~dfsg-2.1 The GPL Ghostscript PostScript/PDF
ii  graphviz                   2.20.2-7      rich set of graph drawing tools
ii  postgresql                 8.4.2-2       object-relational SQL database (su
ii  postgresql-client-8.4 [pos 8.4.2-2       front-end programs for PostgreSQL 
ii  python-imaging             1.1.7-1+b1    Python Imaging Library
ii  python-matplotlib          0.99.1.2-2+b1 Python based plotting system in a 
ii  python-openssl             0.9-1+b1      Python wrapper around the OpenSSL 
ii  python-pyparsing           1.5.2-1       Python parsing module

Versions of packages openerp-server suggests:
ii  openerp-client                5.0.6-2    Enterprise Resource Management (cl

-- debconf information excluded

-- debsums errors found:
debsums: changed file /usr/lib/openerp-server/service/web_services.py (from openerp-server package)

Message #10 received at 568119-close@bugs.debian.org (full text, mbox, reply):

From: Daniel Baumann <daniel@debian.org>

To: 568119-close@bugs.debian.org

Subject: Bug#568119: fixed in openerp-server 5.0.6-4

Date: Sat, 06 Feb 2010 09:39:36 +0000

Source: openerp-server
Source-Version: 5.0.6-4

We believe that the bug you reported is fixed in the latest version of
openerp-server, which is due to be installed in the Debian FTP archive:

openerp-server_5.0.6-4.diff.gz
  to main/o/openerp-server/openerp-server_5.0.6-4.diff.gz
openerp-server_5.0.6-4.dsc
  to main/o/openerp-server/openerp-server_5.0.6-4.dsc
openerp-server_5.0.6-4_all.deb
  to main/o/openerp-server/openerp-server_5.0.6-4_all.deb



A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 568119@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Daniel Baumann <daniel@debian.org> (supplier of updated openerp-server package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.8
Date: Sat, 06 Feb 2010 10:22:05 +0100
Source: openerp-server
Binary: openerp-server
Architecture: source all
Version: 5.0.6-4
Distribution: unstable
Urgency: low
Maintainer: Debian Open Object Maintainers <open-object@lists.debian-maintainers.org>
Changed-By: Daniel Baumann <daniel@debian.org>
Description: 
 openerp-server - Enterprise Resource Management (server)
Closes: 568119
Changes: 
 openerp-server (5.0.6-4) unstable; urgency=low
 .
   * Adding explicit debian source version 1.0 until switch to 3.0.
   * Updating year in copyright file.
   * Updating to standards 3.8.4.
   * Adding patch from Toni Mueller <support@oeko.net> to fix SQL for
     postgresql 8.4 (Closes: #568119).
Checksums-Sha1: 
 0fe3ea58d062a52ab46e5ee2c3109c6c991bce92 1386 openerp-server_5.0.6-4.dsc
 5b54b499d29623d7251b2df27cd2998f8a7ef01a 26523 openerp-server_5.0.6-4.diff.gz
 402d497116a53f26809ad9b43c04a736323d17a6 8701302 openerp-server_5.0.6-4_all.deb
Checksums-Sha256: 
 ee4681c17115793e8391bcd17146f52d72ce0e6279a414bc966b81945ba9b7f0 1386 openerp-server_5.0.6-4.dsc
 eca671645a800ca9b4b7dfe54e307cde991ed70f8fefa83df5618dc84bbaa0e0 26523 openerp-server_5.0.6-4.diff.gz
 b8bcf185772fe1cb803284fe8baa6b4f85b8d436b9ba987c5fb18943dfa87f84 8701302 openerp-server_5.0.6-4_all.deb
Files: 
 760cc84093752a3cae66f3303f093d1b 1386 net optional openerp-server_5.0.6-4.dsc
 2e846e32d2b0754b68c737e8ad935997 26523 net optional openerp-server_5.0.6-4.diff.gz
 f26ab66d8e254f8adf8b01c477cd8fb3 8701302 net optional openerp-server_5.0.6-4_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEUEARECAAYFAkttNdcACgkQ+C5cwEsrK57GIwCWIITSOCIV5OuIeG9AMHfsB9eq
ZQCfQGsZN40HK/p2k7bhFQea4mzthTs=
=AWUK
-----END PGP SIGNATURE-----

Send a report that this bug log contains spam.