"could not create database" on a new installation of ubuntu and postgresql 8.3
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Odoo Server (MOVED TO GITHUB) |
Invalid
|
Undecided
|
Unassigned | ||
openerp-server (Ubuntu) |
Confirmed
|
Undecided
|
Unassigned | ||
Bug Description
After installing and executing openerp-
[2009-02-18 16:17:47,507] INFO:dbpool:
[2009-02-18 16:17:47,517] DEBUG:sql:bad query: CREATE DATABASE "dev" ENCODING 'unicode'
[2009-02-18 16:17:47,517] DEBUG:sql:[01]: encoding UTF8 does not match server's locale en_US
[2009-02-18 16:17:47,518] DEBUG:sql:[02]: DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.
[2009-02-18 16:17:47,518] INFO:dbpool:Closing all connections to template1
Closing connection <connection object at 0x883c818; dsn: 'user=root dbname=template1', closed: 0>
I tried to set all locales to en_US.UTF-8 (my ubuntu's default was just en_US):
ubuntu@ubuntu:~$ locale
LANG=en_US.UTF-8
LC_CTYPE=
LC_NUMERIC=
LC_TIME=
LC_COLLATE=
LC_MONETARY=
LC_MESSAGES=
LC_PAPER=
LC_NAME=
LC_ADDRESS=
LC_TELEPHONE=
LC_MEASUREMENT=
LC_IDENTIFICATI
LC_ALL=
After that, I reinstalled postgresql, but it did not work.
I even did a "initdb" for postgresql:
# sudo -u postgres /usr/lib/
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".
fixing permissions on existing directory /var/lib/
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_
creating configuration files ... ok
creating template1 database in /var/lib/
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.
Success. You can now start the database server using:
/usr/
or
/usr/
but result remains the same
description: | updated |
description: | updated |
Changed in openerp-server (Ubuntu): | |
status: | New → Confirmed |
This is PostgreSQL problem, not an OpenERP Bug.
Check locale for your "postgres" user