[6.1RC] Compatibility issue with Postgres 9.0 - db names in hex prevent connection

Bug #917030 reported by Ismael Matos
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Odoo Server (MOVED TO GITHUB)
Fix Released
Medium
OpenERP's Framework R&D

Bug Description

I've just installed OpenERP 6.1RC side by side to an existing 6.0 with PostgreSQL 9.0.

During the installation process a new database was created sucessfully - openerp61

When I try to use the GTK client, the OpenERP Login screen shows the list of PostgreSQL databases as HEX strings instead of plain characters. After clicking the OK button, it returns an error indicating the is unable to connect to the database ou de database does not exist.

Here are the corresponding error messages in the server log:
[2012-01-15 13:52:14,266][x6f70656e6572703631] ERROR:db.connection_pool:Connection to the database failed
Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 6.1rc1-20120112-173907\server\.\openerp\sql_db.py", line 423, in borrow
OperationalError: FATAL: banco de dados "x6f70656e6572703631" não existe

Everything OpenERP v6.0 seems to be working fine.

I could not find any significant differences in the openerp-server.conf

Thanks you for helping

Related branches

Revision history for this message
Kyle Waid (midwest) wrote :

in postgresql.conf :
- #bytea_output = 'hex' # hex, escape
+ bytea_output = 'escape'

Amit Parik (amit-parik)
affects: openobject-addons → openobject-server
Changed in openobject-server:
assignee: nobody → OpenERP's Framework R&D (openerp-dev-framework)
importance: Undecided → Medium
status: New → Confirmed
summary: - [6.1RC] Unable to connect - db names in hex
+ [6.1RC] Compatibility issue with Postgres 9.0 - db names in hex prevent
+ connection
Revision history for this message
Antony Lesuisse (OpenERP) (al-openerp) wrote :

This should be fixed in 4009 revid:<email address hidden>
could you please test under windows and confirm ?

Changed in openobject-server:
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.