[trunk] unsupported locale with Python 2.4

Used same trunk version as in https://bugs.launchpad.net/bugs/322025 (where I said to report this locale bug).

In Python 2.4 there is a bug on the locale settings, especially on resetting the locale. See http://bugs.python.org/issue504219 for the bug.

So updating the database gave me the error:

[Wed Jan 28 2009 15:59:53] INFO:init:module base: loading security/base_security.xml
[Wed Jan 28 2009 15:59:54] INFO:init:module base: loading maintenance/maintenance_view.xml
[Wed Jan 28 2009 15:59:54] INFO:init:module base: loading security/ir.model.access.csv
[Wed Jan 28 2009 16:00:04] INFO:init:module base: loading translation file for language nl_NL
Traceback (most recent call last):
  File "./openerp-server.py", line 108, in ?
    pooler.get_db_and_pool(db, update_module=tools.config['init'] or tools.config['update'])
  File "/opt/server/bin/pooler.py", line 40, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/opt/server/bin/addons/__init__.py", line 657, in load_modules
    load_module_graph(cr, basegraph, status, perform_checks=False, report=report)
  File "/opt/server/bin/addons/__init__.py", line 623, in load_module_graph
    modobj.update_translations(cr, 1, [mid], None)
  File "/opt/server/bin/addons/base/module/module.py", line 473, in update_translations
    tools.trans_load(cr.dbname, f, lang, verbose=False)
  File "/opt/server/bin/tools/translate.py", line 504, in trans_load
    r = trans_load_data(db_name, fileobj, fileformat, lang, strict=strict, verbose=verbose)
  File "/opt/server/bin/tools/translate.py", line 570, in trans_load_data
    locale.resetlocale(locale.LC_ALL)
  File "/usr/lib/python2.4/locale.py", line 391, in resetlocale
    _setlocale(category, _build_localename(getdefaultlocale()))
locale.Error: unsupported locale setting
-bash-3.2$

I'm trying to load the Dutch translation, but this doesn't work.

Go into the python console and do some locale settings on CentOS:

Python 2.4.3 (#1, May 24 2008, 13:47:28)
[GCC 4.1.2 20070626 (Red Hat 4.1.2-14)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import locale
>>> locale.getdefaultlocale()
('en_US', 'utf')
>>> locale._build_localename(locale.getdefaultlocale())
'en_US.utf'
>>> locale.resetlocale
<function resetlocale at 0xb7eb13ac>
>>> locale.resetlocale()
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/lib/python2.4/locale.py", line 391, in resetlocale
    _setlocale(category, _build_localename(getdefaultlocale()))
locale.Error: unsupported locale setting
>>>

Doing the same on Fedora 10 gave me:

Python 2.5.2 (r252:60911, Sep 30 2008, 15:41:38)
[GCC 4.3.2 20080917 (Red Hat 4.3.2-4)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import locale
>>> locale.getdefaultlocale()
('en_US', 'UTF8')
>>> locale._build_localename(locale.getdefaultlocale())
'en_US.UTF8'
>>> locale.resetlocale()
>>>

As you can see, python 2.5 gives me the right encoding, python 2.4 give me the wrong encoding back (utf instead of UTF8).

On this moment I fixed this by backup the locale.py locale.pyo and locale.pyc of python 2.4 and copy the same files from python 2.5 into /usr/lib/python2.4, which fixed this, but it's better to get a workaround in OpenERP.