Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
4617 Zobrazení

hello,

my odoo is odoo 14 aphla1

my odoo server and postgresql in same lan.

I first install the odoo server use local postgresql,it work ok.

but when I connect postgresql server,I get 500 error.

my other server connect the postgresql,them work ok.(example,confluence and jira)

-----------

this is my postgresql server conf:

pg_hba.conf


# IPv4 local connections:

host    all             all             127.0.0.1/32            md5

host    all             all             192.168.0.0/24          md5



postgresql.conf

# - Connection Settings -


listen_addresses = '*'          # what IP address(es) to listen on;


---------------------

this is my odoo server conf


db_host = 192.168.0.3

db_port = 5432

db_user = odoo

db_passwrod = vCG{82d9]GFbPY9


----------------------

I test psql connect from odoo server to postgresql,it is ok.



# psql -U odoo -h 192.168.0.3 odoo

Password for user odoo: 

psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))

SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)

Type "help" for help.


odoo=>

-----------------------

but ,when I visit the odoo server,i get 500 error.


i check the odoo log,this is error log:


2020-07-04 01:20:44,930 4892 INFO ? odoo.sql_db: Connection to the database failed

2020-07-04 01:20:44,931 4892 INFO ? werkzeug: 127.0.0.1 - - [04/Jul/2020 01:20:44] "GET /favicon.ico HTTP/1.0" 500 - 0 0.000 0.005

2020-07-04 01:20:44,934 4892 ERROR ? werkzeug: Error on request:

Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 270, in run_wsgi

    execute(self.server.app)

  File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 258, in execute

    application_iter = app(environ, start_response)

  File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 439, in app

    return self.app(e, s)

  File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 142, in application

    return application_unproxied(environ, start_response)

  File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied

    result = odoo.http.root(environ, start_response)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1291, in __call__

    return self.dispatch(environ, start_response)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1261, in __call__

    return self.app(environ, start_wrapped)

  File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 766, in __call__

    return self.app(environ, start_response)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1425, in dispatch

    self.setup_db(httprequest)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1348, in setup_db

    httprequest.session.db = db_monodb(httprequest)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1509, in db_monodb

    dbs = db_list(True, httprequest)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1476, in db_list

    dbs = odoo.service.db.list_dbs(force)

  File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 380, in list_dbs

    with closing(db.cursor()) as cr:

  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 671, in cursor

    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)

  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 243, in __init__

    self._cnx = pool.borrow(dsn)

  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 554, in _locked

    return fun(self, *args, **kwargs)

  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 622, in borrow

    **connection_info)

  File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 130, in connect

    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)

psycopg2.OperationalError: fe_sendauth: no password supplied - - -


===========================================================


What is the reason and how to solve it?

I hope everyone can help


Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
4
zář 24
1343
2
bře 15
10368
2
bře 24
2196
1
pro 21
3402
0
pro 21
1574