• 版块
  • 标签
  • 热门
  • 用户
  • 群组
皮肤
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • 默认(Flatly)
  • 不使用皮肤
折叠

Odoo 中文社区

odoo15网站登录报错

已定时 已固定 已锁定 已移动 Odoo 开发与实施交流
10 帖子 3 发布者 702 浏览
    • 从旧到新
    • 从新到旧
    • 最多赞同
回复
  • 在新帖中回复
登录后回复
此主题已被删除。只有拥有主题管理权限的用户可以查看。
  • S 离线
    S 离线
    steven
    写于 最后由 steven 编辑
    #1

    本机win10家庭中文版21H1,安装了odoo15和postgresql12数据库。
    fd9f0d87-cd8d-4dc9-8122-d524d04b5f7b-image.png
    141c7957-d3b3-4e65-96c8-37809e2bd63b-image.png
    但从浏览器登录时,却提示错误。
    5547a57a-b5d6-4eb7-b5d5-44318f4ce8cc-image.png
    查询win10日志提示

    • System

      • Provider

      [ Name] Microsoft-Windows-DistributedCOM
      [ Guid] {1B562E86-B7AA-4131-BADC-B6F3A001407E}
      [ EventSourceName] DCOM

      • EventID 10016

      [ Qualifiers] 0

      Version 0

      Level 3

      Task 0

      Opcode 0

      Keywords 0x8080000000000000

      • TimeCreated

      [ SystemTime] 2022-05-22T03:09:08.1288646Z

      EventRecordID 173459

      • Correlation

      [ ActivityID] {69866905-3077-4036-955c-6d8265185490}

      • Execution

      [ ProcessID] 1316
      [ ThreadID] 12996

      Channel System

      Computer LENOVO14RYZEN-JB

      • Security

      [ UserID] S-1-5-18

    • EventData

      param1 应用程序-特定
      param2 本地
      param3 启动
      param4 Windows.SecurityCenter.WscBrokerManager
      param5 不可用
      param6 NT AUTHORITY
      param7 SYSTEM
      param8 S-1-5-18
      param9 LocalHost (使用 LRPC)
      param10 不可用
      param11 不可用

    conf文件如下:
    67fa7438-3348-49ec-84b7-f6a81c4e999d-image.png

    postgresql权限如下:
    dbbe1c66-6d2b-4c66-a044-53b121713a3e-image.png

    请问到底 问题出在哪里?

    1 条回复 最后回复
    0
  • S 离线
    S 离线
    steven
    写于 最后由 编辑
    #2

    添加补充信息:
    ●odoo日志:
    2022-05-23 02:04:45,513 7712 INFO ? odoo.sql_db: Connection to the database failed
    2022-05-23 02:04:45,519 7712 INFO ? werkzeug: 127.0.0.1 - - [23/May/2022 02:04:45] "GET /favicon.ico HTTP/1.1" 500 - 0 0.000 0.205
    2022-05-23 02:04:45,530 7712 ERROR ? werkzeug: Error on request:
    Traceback (most recent call last):
    File "C:\Program Files\Odoo 15.0.20220514\python\lib\site-packages\werkzeug\serving.py", line 306, in run_wsgi
    execute(self.server.app)
    File "C:\Program Files\Odoo 15.0.20220514\python\lib\site-packages\werkzeug\serving.py", line 294, in execute
    application_iter = app(environ, start_response)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\service\server.py", line 482, in app
    return self.app(e, s)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\service\wsgi_server.py", line 112, in application
    return application_unproxied(environ, start_response)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\service\wsgi_server.py", line 87, in application_unproxied
    result = odoo.http.root(environ, start_response)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1336, in call
    return self.dispatch(environ, start_response)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1302, in call
    return self.app(environ, start_wrapped)
    File "C:\Program Files\Odoo 15.0.20220514\python\lib\site-packages\werkzeug\middleware\shared_data.py", line 220, in call
    return self.app(environ, start_response)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1488, in dispatch
    self.setup_db(httprequest)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1393, in setup_db
    httprequest.session.db = db_monodb(httprequest)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1609, in db_monodb
    dbs = db_list(True, httprequest)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1576, in db_list
    dbs = odoo.service.db.list_dbs(force)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\service\db.py", line 389, in list_dbs
    with closing(db.cursor()) as cr:
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\sql_db.py", line 706, in cursor
    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\sql_db.py", line 256, in init
    self._cnx = pool.borrow(dsn)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\sql_db.py", line 589, in locked
    return fun(self, *args, **kwargs)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\sql_db.py", line 657, in borrow
    **connection_info)
    File "C:\Program Files\Odoo 15.0.20220514\python\lib\site-packages\psycopg2_init
    .py", line 127, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
    psycopg2.OperationalError - - -

    digitalsatoriD 1 条回复 最后回复
    0
  • digitalsatoriD 离线
    digitalsatoriD 离线
    digitalsatori 管理员
    在 中回复了steven 最后由 编辑
    #3

    @steven 在 odoo15网站登录报错 中说:

    Connection to the database failed

    应该是连接数据库出错。看看数据库的用户名/密码设置,以及odoo实例的访问权限。

    【上海先安科技】(tony AT openerp.cn)

    S 1 条回复 最后回复
    0
  • S 离线
    S 离线
    steven
    在 中回复了digitalsatori 最后由 编辑
    #4

    @digitalsatori
    ●数据库的对应好象都没有错误。主机号、用户名、port号、密码都一致。
    225fa9b2-ba2e-47ec-b199-be8148548c83-image.png

    c07f8c3a-7906-45af-928e-d2fc98f1d1f1-image.png

    ●odoo.conf文件:
    abae2f08-7782-4985-8d5d-a40b6afcf8f4-image.png

    ●但就是用pdamin4打开数据库里,有个注释好象有问题:
    7aaf37c4-a967-4cf9-b97b-bda0d2c289f1-image.png
    但我安装的数据库路径却是:
    ae809a7a-f29f-428d-902e-80ecc3e012fd-image.png

    digitalsatoriD 1 条回复 最后回复
    0
  • digitalsatoriD 离线
    digitalsatoriD 离线
    digitalsatori 管理员
    在 中回复了steven 最后由 编辑
    #5

    @steven 你可以把pg_hba.conf的内容发一下吗?另外,Odoo的配置文件中 db_host 将localhost改为 127.0.0.1试一下。

    【上海先安科技】(tony AT openerp.cn)

    S 1 条回复 最后回复
    0
  • S 离线
    S 离线
    steven
    在 中回复了digitalsatori 最后由 steven 编辑
    #6

    @digitalsatori
    ●我在odoo.conf中将db_host修改成了127.0.0.1,并重启了odoo和postgresql服务,再在浏览器中登录127.0.0.1:8069,还是不行。
    odoo日志如下:
    2022-05-15 03:08:26,940 8804 INFO ? odoo: Odoo version 15.0-20220514
    2022-05-15 03:08:26,940 8804 INFO ? odoo: Using configuration file at C:\Program Files\Odoo 15.0.20220514\server\odoo.conf
    2022-05-15 03:08:26,940 8804 INFO ? odoo: addons paths: ['C:\Program Files\Odoo 15.0.20220514\server\odoo\addons', 'c:\users\jiangbin\appdata\local\openerp s.a\odoo\addons\15.0', 'c:\program files\odoo 15.0.20220514\server\odoo\addons']
    2022-05-15 03:08:26,940 8804 INFO ? odoo: database: openpg@localhost:5432
    2022-05-15 03:08:27,718 8804 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at C:\Program Files\Odoo 15.0.20220514\thirdparty\wkhtmltopdf.exe
    2022-05-15 03:08:28,470 8804 INFO ? odoo.service.server: Initiating shutdown
    2022-05-15 03:08:28,470 8804 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
    2022-05-15 03:08:30,706 7620 INFO ? odoo: Odoo version 15.0-20220514
    2022-05-15 03:08:30,707 7620 INFO ? odoo: Using configuration file at C:\Program Files\Odoo 15.0.20220514\server\odoo.conf
    2022-05-15 03:08:30,707 7620 INFO ? odoo: addons paths: ['C:\Program Files\Odoo 15.0.20220514\server\odoo\addons', 'c:\users\jiangbin\appdata\local\openerp s.a\odoo\addons\15.0', 'c:\program files\odoo 15.0.20220514\server\odoo\addons']
    2022-05-15 03:08:30,707 7620 INFO ? odoo: database: openpg@localhost:5432
    2022-05-15 03:08:30,930 7620 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at C:\Program Files\Odoo 15.0.20220514\thirdparty\wkhtmltopdf.exe
    2022-05-15 03:08:31,149 7620 INFO ? odoo.service.server: HTTP service (werkzeug) running on LENOVO14RYZEN-JB:8069
    2022-05-15 03:08:35,231 7620 INFO ? odoo.sql_db: Connection to the database failed
    2022-05-15 03:08:39,278 7620 INFO ? odoo.sql_db: Connection to the database failed
    2022-05-15 03:10:56,511 7620 INFO ? odoo.http: HTTP Configuring static files
    2022-05-15 03:11:00,585 7620 INFO ? odoo.sql_db: Connection to the database failed
    2022-05-15 03:11:00,589 7620 INFO ? werkzeug: 127.0.0.1 - - [15/May/2022 03:11:00] "GET / HTTP/1.1" 500 - 0 0.000 4.063
    2022-05-15 03:11:00,595 7620 ERROR ? werkzeug: Error on request:
    Traceback (most recent call last):
    File "C:\Program Files\Odoo 15.0.20220514\python\lib\site-packages\werkzeug\serving.py", line 306, in run_wsgi
    execute(self.server.app)
    File "C:\Program Files\Odoo 15.0.20220514\python\lib\site-packages\werkzeug\serving.py", line 294, in execute
    application_iter = app(environ, start_response)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\service\server.py", line 482, in app
    return self.app(e, s)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\service\wsgi_server.py", line 112, in application
    return application_unproxied(environ, start_response)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\service\wsgi_server.py", line 87, in application_unproxied
    result = odoo.http.root(environ, start_response)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1336, in call
    return self.dispatch(environ, start_response)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1302, in call
    return self.app(environ, start_wrapped)
    File "C:\Program Files\Odoo 15.0.20220514\python\lib\site-packages\werkzeug\middleware\shared_data.py", line 220, in call
    return self.app(environ, start_response)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1488, in dispatch
    self.setup_db(httprequest)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1393, in setup_db
    httprequest.session.db = db_monodb(httprequest)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1609, in db_monodb
    dbs = db_list(True, httprequest)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\http.py", line 1576, in db_list
    dbs = odoo.service.db.list_dbs(force)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\service\db.py", line 389, in list_dbs
    with closing(db.cursor()) as cr:
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\sql_db.py", line 706, in cursor
    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\sql_db.py", line 256, in init
    self._cnx = pool.borrow(dsn)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\sql_db.py", line 589, in locked
    return fun(self, *args, **kwargs)
    File "C:\Program Files\Odoo 15.0.20220514\server\odoo\sql_db.py", line 657, in borrow
    **connection_info)
    File "C:\Program Files\Odoo 15.0.20220514\python\lib\site-packages\psycopg2_init
    .py", line 127, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
    psycopg2.OperationalError: could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "localhost" (::1) and accepting
    TCP/IP connections on port 5432?
    could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "localhost" (127.0.0.1) and accepting
    TCP/IP connections on port 5432? - - -

    ●pg_hba.conf的截图如下:
    6f633b1a-4065-4d21-b1d0-9f9ac30d8205-image.png

    1 条回复 最后回复
    0
  • S 离线
    S 离线
    seven
    写于 最后由 编辑
    #7

    dbname没指定

    S 2 条回复 最后回复
    0
  • S 离线
    S 离线
    steven
    在 中回复了seven 最后由 编辑
    #8

    @seven
    指定了db_name也还是不行。

    1 条回复 最后回复
    0
  • S 离线
    S 离线
    steven
    在 中回复了seven 最后由 编辑
    #9

    @seven
    @seven
    指定了db_name也还是不行。

    我在想,也许是原来的odoo14没有卸载干净,导致与后来的odoo15冲突,所以odoo15无法登录。

    刚才在卸载odoo15时,发现也无法卸载干净。用win10自带的卸载程序,被提示“无法完全卸载”。后来,即便删除了所有安装目录下的文件,也还是留存于win10的“程序与应用”中。

    a80172b9-2c32-4e35-b2e8-98730a805867-image.png

    1 条回复 最后回复
    0
  • S 离线
    S 离线
    steven
    写于 最后由 编辑
    #10

    今天采用了一个简单粗暴的方法解决了该问题。
    修复操作系统、重装odoo(内部包含postgresql)。免得产生odoo连接postgresql数据库可能会产生的问题。

    1 条回复 最后回复
    0

  • 登录

  • 没有帐号? 注册

  • 登录或注册以进行搜索。
  • 第一个帖子
    最后一个帖子
0
  • 版块
  • 标签
  • 热门
  • 用户
  • 群组
  • 登录

  • 没有帐号? 注册

  • 登录或注册以进行搜索。