c2c-oerpscenario team mailing list archive

[Bogdan Stanciu <bogdanovidiu.stanciu@xxxxxxxxx>]

On 10. 01. 11 18:20, Vo Minh Thu (OpenERP) wrote:
> It seems you're using an updated server code with a non-updated db.
>
> Did you try to use the -u option (used together with -d) to update your
> db?
>
i am quite sure this is the reason...

I completely missed this action.

however, running "python openerp-server.py -d db_name -u all" in the
corresponding folder gives me this error:

[2011-01-10 18:35:33,142][bs_assets] ERROR:db.connection_pool:Connection
to the database failed
Traceback (most recent call last):
  File
"/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line
301, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
OperationalError: fe_sendauth: no password supplied

Traceback (most recent call last):
  File "openerp-server.py", line 121, in <module>
    db,pool = pooler.get_db_and_pool(dbname,
update_module=tools.config['init'] or tools.config['update'],
pooljobs=False)
  File
"/usr/local/lib/python2.6/dist-packages/openerp-server/pooler.py", line
39, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File
"/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py",
line 805, in load_modules
    cr = db.cursor()
  File
"/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line
343, in cursor
    return Cursor(self._pool, self.dbname, serialized=serialized)
  File
"/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line
93, in __init__
    self._cnx = pool.borrow(dsn(dbname))
  File
"/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line
250, in _locked
    return fun(self, *args, **kwargs)
  File
"/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line
301, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
psycopg2.OperationalError: fe_sendauth: no password supplied

could you please advice?

thank you!

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/701104

Title:
  [6.0 rc2] ERROR module install/upgrade fails on existing db

Status in OpenObject Server:
  Invalid

Bug description:
  following the last changes to the server, I get an error on install/upgrade of any module.
I suppose that this is due to the lack of the field ir_translation.xml_id, which did not exist and it is not created during install upgrade. everything is ok on new db.

i checked several [un]certified modules...

[2011-01-10 17:57:03,429][bs_assets] INFO:i18n:module hr: loading translation file (fr) for language fr_FR
[2011-01-10 17:57:03,430][bs_assets] INFO:i18n:loading /home/openerp/addons/hr/i18n/fr.po
[2011-01-10 17:57:03,443][bs_assets] ERROR:db.cursor:Programming error: column "xml_id" of relation "ir_translation" does not exist
LINE 1: insert into "ir_translation" (id,"lang","src","xml_id","name...
                                                      ^
, in query insert into "ir_translation" (id,"lang","src","xml_id","name","type","value","module","res_id") values (10469,%s,%s,%s,%s,%s,%s,%s,%s)
[2011-01-10 17:57:03,444][bs_assets] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base/module/wizard/base_module_upgrade.py", line 98, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/pooler.py", line 60, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/pooler.py", line 39, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 885, in load_modules
    processed_modules.extend(load_module_graph(cr, graph, status, report=report, skip_modules=processed_modules))
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 774, in load_module_graph
    modobj.update_translations(cr, 1, [mid], None)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base/module/module.py", line 514, in update_translations
    tools.trans_load(cr, f, lang, verbose=False, context=context2)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/tools/translate.py", line 841, in trans_load
    r = trans_load_data(cr, fileobj, fileformat, lang, verbose=verbose, context=context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/tools/translate.py", line 928, in trans_load_data
    trans_obj.create(cr, uid, dic)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base/ir/ir_translation.py", line 184, in create
    ids = super(ir_translation, self).create(cursor, user, vals, context=context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3601, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "xml_id" of relation "ir_translation" does not exist
LINE 1: insert into "ir_translation" (id,"lang","src","xml_id","name...
                                                      ^