Odoo Server (MOVED TO GITHUB)

why openerp-server 7.0 need access to postgres table?

Asked by Mariano Dangelo

I have installed openerp 6.1 on webfaction shared hosting, it doesn't have create db permision, creating db on another server and migrating to webfaction postgres db, works....

When openerp 7.0 was realeased I installed on webfaction and when I try it thought an error trying to access postgres table.... but the user hasn't rights to do it.... passing thought the error it works ok, it create product, clients, etc,

the question is why openerp need access to postgres table, and if I can solve it?

TRACEBACK:

Client Traceback (most recent call last):
  File "/home/usuario/webapps/openerp/web/addons/web/http.py", line 195, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/usuario/webapps/openerp/web/addons/web/controllers/main.py", line 708, in get_list
    return db_list(req)
  File "/home/usuario/webapps/openerp/web/addons/web/controllers/main.py", line 87, in db_list
    dbs = proxy.list()
  File "/home/usuario/webapps/openerp/web/addons/web/session.py", line 28, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/home/usuario/webapps/openerp/web/addons/web/session.py", line 101, in send
    raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)

Server Traceback (most recent call last):
  File "/home/usuario/webapps/openerp/web/addons/web/session.py", line 87, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/usuario/webapps/openerp/server/openerp/netsvc.py", line 281, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/usuario/webapps/openerp/server/openerp/service/web_services.py", line 122, in dispatch
    return fn(*params)
  File "/home/usuario/webapps/openerp/server/openerp/service/web_services.py", line 351, in exp_list
    cr = db.cursor()
  File "/home/usuario/webapps/openerp/server/openerp/sql_db.py", line 477, in cursor
    return Cursor(self._pool, self.dbname, serialized=serialized)
  File "/home/usuario/webapps/openerp/server/openerp/sql_db.py", line 183, in __init__
    self._cnx = pool.borrow(dsn(dbname))
  File "/home/usuario/webapps/openerp/server/openerp/sql_db.py", line 378, in _locked
    return fun(self, *args, **kwargs)
  File "/home/usuario/webapps/openerp/server/openerp/sql_db.py", line 433, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
  File "/usr/local/lib/python2.7/site-packages/psycopg2/__init__.py", line 179, in connect
    connection_factory=connection_factory, async=async)
OperationalError: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "marianodan_podioerp", database "postgres", SSL on
FATAL: no pg_hba.conf entry for host "127.0.0.1", user "marianodan_podioerp", database "postgres", SSL off

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Serpent Consulting Services (serpent-consulting-services) said : 		#1

Mariano,

Would you please make sure marianodan_podioerp user is a superuser?

Thanks.

Revision history for this message
Serpent Consulting Services (serpent-consulting-services) said : 		#2

Additionally, the possible causes are:

1. You are connecting to the wrong server.
   >>> Is the DB server running on the same host as Python does?

2. You got the wrong port.
   >>> Check the server log if you see a connection attempt. You have to log connections for that, of course. See the config parameter log_connections. ( http://www.postgresql.org/docs/current/interactive/runtime-config-logging.html#GUC-LOG-CONNECTIONS)

3. You did not reload (SIGHUP) the server after changing pg_hba.conf - or reloaded the wrong cluster (if you have multiple DB clusters).
   >>> Use pg_ctl or pg_ctlcluser on Debian and derivatives for that. (http://www.postgresql.org/docs/current/interactive/app-pg-ctl.html)

Hope this helps.
courtesy : stackoverflow.

Thanks.

Can you help with this problem?

Provide an answer of your own, or ask Mariano Dangelo for more information if necessary.

To post a message you must log in.