Your message dated Tue, 08 Jun 2010 10:04:35 +0000
with message-id <[email protected]>
and subject line Bug#584976: fixed in openerp-server 5.0.11-1
has caused the Debian Bug report #584976,
regarding openerp-server: New database can not be created if locale is en_US
(not UTF-8)
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
584976: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=584976
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: openerp-server
Version: 5.0.10-1
Severity: important
Tags: sid patch squeeze
After installing openerp-server, openerp-client, & posgresql, then
creating the
required postrgresql user openerp, I opened openerp-client and got the
expected:
"No database found, you must create one !"
message.
Selecting File -> Databases -> New database, filling in the fields and
clicking
OK results in the error message:
Error during database creation ! Could not create database.
var/log/postgresql/postgresql-8.4-main.log contains:
2010-06-07 19:54:34 EDT ERROR: encoding UTF8 does not match locale en_US
2010-06-07 19:54:34 EDT DETAIL: The chosen LC_CTYPE setting requires \
encoding LATIN1. 2010-06-07
19:54:34 EDT STATEMENT: CREATE DATABASE "mytestdb" ENCODING 'unicode' \
TEMPLATE "template0"
Some research found that the database encoding when creating a new
database is hard-coded in openerp-server to 'unicode'. Postgresql accepts
unicode if the locale (when postgresql is installed) is a UTF type or the C
locale but it only accepts LATIN1 if another locale type is found.
The attached patch queries the locale and sets the encoding for database
creation accordingly.
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.31-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/dash
Versions of packages openerp-server depends on:
ii adduser 3.112 add and remove users and groups
ii debconf [debconf-2.0] 1.5.29 Debian configuration
management sy
ii python 2.5.4-9 An interactive high-level
object-o
ii python-libxslt1 1.1.26-3 Python bindings for libxslt1
ii python-lxml 2.2.6-1 pythonic binding for the
libxml2 a
ii python-psycopg2 2.0.14-1 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.4-1 ReportLab library to create
PDF do
ii python-tz 2010b-1 Python version of the Olson
timezo
Versions of packages openerp-server recommends:
ii ghostscript 8.71~dfsg-3 The GPL Ghostscript
PostScript/PDF
ii graphviz 2.26.3-4 rich set of graph drawing tools
ii postgresql 8.4.4-1 object-relational SQL
database (su
ii postgresql-client-8.4 [postg 8.4.4-1 front-end programs for
PostgreSQL
ii python-imaging 1.1.7-1+b1 Python Imaging Library
ii python-matplotlib 0.99.1.2-3 Python based plotting
system in a
ii python-openssl 0.10-1 Python wrapper around the
OpenSSL
ii python-pyparsing 1.5.2-2 Python parsing module
Versions of packages openerp-server suggests:
ii openerp-client 5.0.10-1 Enterprise Resource
Management (cl
-- debconf-show failed
Author: Timothy E. Harris <[email protected]>
Description: Fix bug that prevents creating a new database if the locale is not a UTF-8 one.
Index: openerp-server-5.0.10/bin/service/web_services.py
===================================================================
--- openerp-server-5.0.10.orig/bin/service/web_services.py 2010-06-06 10:00:23.000000000 -0400
+++ openerp-server-5.0.10/bin/service/web_services.py 2010-06-06 10:01:26.000000000 -0400
@@ -38,6 +38,7 @@
import sql_db
import tools
import locale
+import re
from cStringIO import StringIO
logging.basicConfig()
@@ -64,11 +65,15 @@
self._pg_psw_env_var_is_set = False # on win32, pg_dump need the PGPASSWORD env var
def _create_empty_database(self, name):
+ if re.search('utf|UTF', locale.getdefaultlocale()[1]):
+ db_encoding = 'unicode'
+ else:
+ db_encoding = 'LATIN1'
db = sql_db.db_connect('template1')
cr = db.cursor()
try:
cr.autocommit(True) # avoid transaction block
- cr.execute("""CREATE DATABASE "%s" ENCODING 'unicode' TEMPLATE "template0" """ % name)
+ cr.execute("""CREATE DATABASE "%s" ENCODING '%s' TEMPLATE "template0" """ %(name, db_encoding))
finally:
cr.close()
--- End Message ---
--- Begin Message ---
Source: openerp-server
Source-Version: 5.0.11-1
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.11-1.diff.gz
to main/o/openerp-server/openerp-server_5.0.11-1.diff.gz
openerp-server_5.0.11-1.dsc
to main/o/openerp-server/openerp-server_5.0.11-1.dsc
openerp-server_5.0.11-1_all.deb
to main/o/openerp-server/openerp-server_5.0.11-1_all.deb
openerp-server_5.0.11.orig.tar.gz
to main/o/openerp-server/openerp-server_5.0.11.orig.tar.gz
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 [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Daniel Baumann <[email protected]> (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 [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.8
Date: Tue, 08 Jun 2010 11:42:23 +0200
Source: openerp-server
Binary: openerp-server
Architecture: source all
Version: 5.0.11-1
Distribution: unstable
Urgency: low
Maintainer: Debian Open Object Maintainers
<[email protected]>
Changed-By: Daniel Baumann <[email protected]>
Description:
openerp-server - Enterprise Resource Management (server)
Closes: 584976
Changes:
openerp-server (5.0.11-1) unstable; urgency=low
.
* Merging upstream version 5.0.11.
* Adding patch from Timothy E. Harris <[email protected]>
to prevents creating a new database if the locale is not a UTF-8 one
(Closes: #584976).
Checksums-Sha1:
ec3721f5cb13e7a9b08577be1e5be154c7cff011 1437 openerp-server_5.0.11-1.dsc
39cd108530e6a87867b611b7fc280fb01009bc8b 9824703
openerp-server_5.0.11.orig.tar.gz
9bc0ec66351543e2dd7589d161bc8146003fef31 16593 openerp-server_5.0.11-1.diff.gz
ca3c3247163ce6910c519e6d5296c668bdeb2120 9888464
openerp-server_5.0.11-1_all.deb
Checksums-Sha256:
2925a8c38f6cf5d7d79acbb48afcfca8d787878a5630e9c76d1ffc70bfa52ee7 1437
openerp-server_5.0.11-1.dsc
d7b4e8b64542b8857d9908bce9a2662e6413bf6db53f04f2ea8f28588de328e8 9824703
openerp-server_5.0.11.orig.tar.gz
4528776fe7cdb152909c0beb28e633ad8bf97763cc22ee03dea1899b7be2e47d 16593
openerp-server_5.0.11-1.diff.gz
954e709317bc0bd39aa0d9a681ca60f6d1a8d32ac99bd8a481c9c784339aca03 9888464
openerp-server_5.0.11-1_all.deb
Files:
2295787832af5e453f46432a4cb00a2c 1437 net optional openerp-server_5.0.11-1.dsc
ebcc883e45d8045d1a95fc4d0854924f 9824703 net optional
openerp-server_5.0.11.orig.tar.gz
fa403a5e5bb48aaccd1a22870805fdc4 16593 net optional
openerp-server_5.0.11-1.diff.gz
b5b680e4079f3750006bdf21b3ac7c17 9888464 net optional
openerp-server_5.0.11-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iEYEARECAAYFAkwOEjEACgkQ+C5cwEsrK57Z+ACeISxGwx99G0RcbZImXlNKsixQ
L4YAniQZ1ErT3D1ebWfZ6373YasKD3O3
=q0ft
-----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________
open-object mailing list
[email protected]
http://lists.debian-maintainers.org/listinfo/open-object
