Skip to Content
This question has been flagged
2 Replies
13201 Views
Avatar
Bruce Rochester

I'm trying to import data using odoo_import_example as a reference, however I'm having trouble  connecting to RPC. I get the following error:

2019-05-28 16:54:50,975 1368 ERROR TTPowerTest odoo.http: Exception during JSON request handling.
Traceback (most recent call last):
  File "/opt/odoo/odoo/http.py", line 654, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/opt/odoo/odoo/http.py", line 312, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "/opt/odoo/odoo/tools/pycompat.py", line 87, in reraise
    raise value
  File "/opt/odoo/odoo/http.py", line 696, in dispatch
    result = self._call_function(**self.params)
  File "/opt/odoo/odoo/http.py", line 345, in _call_function
    return self.endpoint(*args, **kwargs)
  File "/opt/odoo/odoo/http.py", line 939, in __call__
    return self.method(*args, **kw)
  File "/opt/odoo/odoo/http.py", line 517, in response_wrap
    response = f(*args, **kw)
  File "/opt/odoo/odoo/addons/base/controllers/rpc.py", line 71, in jsonrpc
    return dispatch_rpc(service, method, args)
  File "/opt/odoo/odoo/http.py", line 120, in dispatch_rpc
    result = dispatch(method, params)
  File "/opt/odoo/odoo/service/model.py", line 35, in dispatch
    security.check(db,uid,passwd)
  File "/opt/odoo/odoo/service/security.py", line 16, in check
    return res_users.check(db, uid, passwd)
  File "/opt/odoo/odoo/addons/base/models/res_users.py", line 624, in check
    self._check_credentials(passwd)
  File "/opt/odoo/odoo/addons/base/models/res_users.py", line 322, in _check_credentials
    raise AccessDenied()
odoo.exceptions.AccessDenied: Access denied

I've double checked that I'm logging in on the correct database, with the correct name (admin) and password. Here is my connection.conf:

[Connection]
hostname = localhost
database = TTPowerTest
login = admin
password = SECRET
protocol = jsonrpc
port = 8069
uid = 1


Any ideas why I am not able to log in to RPC? The same user/pw works when logging into Odoo...

Avatar
Discard
Zbik

Submit your RPC example code.

Avatar
Bruce Rochester
Author Best Answer

The issue appears to be an incorrect uid. I changed it from 1 to 2 and everything worked.

I found the uid with the following Python code:

>>> import xmlrpclib
>>> host = "http://localhost:8069"
>>> db = "Db1"
>>> username = "admin"
>>> password = "SECRET"
>>> url = '%s/xmlrpc/' % (host)
>>> common_proxy = xmlrpclib.ServerProxy(url+'common')
>>> object_proxy = xmlrpclib.ServerProxy(url+'object')
>>> uid = common_proxy.login(db,username,password)
>>> print(uid)
​
Avatar
Discard