This question has been flagged
1 Reply
7728 Views
xmlrpcodooXML-RPCodoo12
Avatar
Umair Saleem

I have below simple program to connect odoo 12 on my local system. I am getting a below-mentioned error. Please advise. 


import xmlrpc.client
import csv

server = "http://localhost:8069"
database = "dietfacts2"
user = "admin"
pwd = "admin"


common = xmlrpc.client.ServerProxy('{}/xmlrpc/2/common'.format(server))
print("Version Details: " , common.version())


uid = common.authenticate(database, user, pwd, {})
print(uid)

​

Below is the Output: ( I have printed version details.)

Version Details: {'server_version': '12.0', 'server_version_info': [12, 0, 0, 'final', 0, ''], 'server_serie': '12.0', 'protocol_version': 1}

xmlrpc.client.Fault: exp_method_name\n File "/home/odoodev/odoo/odoo/service/common.py", line 30, in exp_authenticate\n res_users = odoo.registry(db)[\'res.users\']\n File "/home/odoodev/odoo/odoo/__init__.py", line 117, in registry\n return modules.registry.Registry(database_name)\n File "/home/odoodev/odoo/odoo/modules/registry.py", line 62, in __new__\n return cls.new(db_name)\n File "/home/odoodev/odoo/odoo/modules/registry.py", line 83, in new\n registry.setup_signaling()\n File "/home/odoodev/odoo/odoo/modules/registry.py", line 361, in setup_signaling\n cr.execute("CREATE SEQUENCE base_registry_signaling INCREMENT BY 1 START WITH 1")\n File "/home/odoodev/odoo/odoo/sql_db.py", line 148, in wrapper\n return f(self, *args, **kwargs)\n File "/home/odoodev/odoo/odoo/sql_db.py", line 225, in execute\n res = self._obj.execute(query, params)\npsycopg2.errors.DuplicateTable: relation "base_registry_signaling" already exists\n\n'>

Main Error npsycopg2.errors.DuplicateTable: relation "base_registry_signaling" already exists


Avatar
Discard
Sehrish

Reference: http://learnopenerp.blogspot.com/2019/10/connecting-to-odoo-using-xml-rpc.html

Avatar
Niyas Raphy (Walnut IT)
Best Answer

Hi,

Please try this code and see,

import xmlrpclib

url = "http://localhost:8009"
database = "d_b"
user = "admin"
pwd = "admin"


common = xmlrpclib.ServerProxy('{}/xmlrpc/2/common'.format(url))
print( "common", common.version())

uid = common.authenticate(database, user, pwd, {})
print(uid)

Thanks

Avatar
Discard