Odoo Help


OpenERP Server Error after fresh Installation on Ubuntu 12.04 64-bit

Sven Meikel Auer
on 7/8/13, 5:45 PM 3,986 views


I hope someone can help me fix the following error.

OpenERP Server Error

Client Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, **self.params) File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 777, in create params['create_admin_pwd']) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 103, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 122, in dispatch return fn(params) File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 167, in exp_create_database self._create_empty_database(db_name) File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 136, in _create_empty_database cr.execute("""CREATE DATABASE "%s" ENCODING 'unicode' TEMPLATE "%s" """ % (name, chosen_template)) File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 161, in wrapper return f(self, *args, *kwargs) File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) DataError: encoding UTF8 does not match locale en_US DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1.

Thank you for your help.

Greetings Sven


Jeudy Nicolas

--Jeudy Nicolas--
| 6 7 8
Pelousey, France
--Jeudy Nicolas--

- Linux administrator - Functional guy with OpenERP - Python, html, css, javascript developer OpenERP Ready Partner

Jeudy Nicolas
On 7/8/13, 6:14 PM


you ubuntu install is'not in UTF-8 mode (unicode).

if you write in a terminal:

env | grep LANG

You should have LANG=en_US.UTF-8 to be able to support unicode encoding. If it's not the case, just write this:

sudo locale-gen en_US.UTF-8
sudo dpkg-reconfigure locales
sudo update-locale LANG=en_US.UTF-8

And now logout your session or just restart your server, you will be able to launch OpenERP.

My System shows follow: LANG=en_US.UTF-8 and as LANGUAGE=en - the problem persists. Thanks for your help and I hope that I have a idea.

Sven Meikel Auer
on 7/8/13, 7:17 PM
Steven Furick
On 4/21/16, 9:22 AM

This script solved the problem for me

sudo su postgres
update pg_database set datistemplate=false where datname='template1';
drop database Template1;
create database template1 with owner=postgres encoding='UTF-8' 
lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;
update pg_database set datistemplate=true where datname='template1';
Alexander Lindemann
On 6/28/15, 4:33 PM

I have tried all solutions, none fixes the problem.

I have restarted Odoo and terminal session after all "fixes".

Anyone have additional suggestions?

I was not able to comment due to karma requirements...

Alexander Lindemann
on 6/28/15, 4:34 PM
S. Edelman
On 6/20/15, 5:28 AM

Similar issue here and have restarted the server and Odoo but no effect. Still complaining

DataError: encoding "UTF8" does not match locale "en_US"

DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1".

Note that we are trying install the first database after Odoo install and we would like to select the UK English for it. It anyway complains about "en_US" instead of "en_GB", and the error is the same if we try to install "en_US" instead. Anyhow, when asking with the command "env | grep LANG", the answer is:



The LANG value stays if restarting the server but the LANGUAGE value cuts off and says after that "LANGUAGE=en_US:" instead.

- - - 


I  got the problem solved by totally removing Odoo installation and postgresql as well.

After that checked with the command "locale" what are the language locales.

They were already ok in this point since I have been trying to get them in order indeed but the solution to get them in order in case needed is this one:

For Ubuntu 14.04 to add these lines to the /etc/bash.bashrc file: 

export LC_ALL="en_GB.UTF-8"

export LC_CTYPE="en_GB.UTF-8"

or it can be "en_US.UTF-8" or any other language that is needed as the main language.

After that running the Odoo install with the postgresql database settings, things should go in order and then you will be able to create the first database with the Odoo Database Manager after the fresh install. I hope this helps somebody since this was quite a hurdle to find out what goes wrong with the locales (very difficult to fix afterwards, so faster to install all again after the locales are in order!).

Ok, got the values all ok now but still Odoo is insisting with the same error. Is there a possibility this error is actually misleading and something else is wrong? This is Ubuntu 14.04.2 and after setting the locales we installed again postgresql in order to get the effect on the locales into it. I added this to our /etc/bash.bashrc file: (using command "sudo vim /etc/bash.bashrc" ) export LC_ALL="en_GB.UTF-8" export LC_CTYPE="en_GB.UTF-8" So, after this we have restarted both the server and Odoo, checked that locales are still staying correct and then tried to make the Odoo DB from the database manager but it is repeating the same error. How could this be solved?

S. Edelman
on 6/20/15, 1:59 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 7/8/13, 5:45 PM
Seen: 3986 times
Last updated: 4/21/16, 9:22 AM