4. 新手第一次安装openerp求助！无法连接数据库

Odoo中文社区可以通过以下三个域名访问：shine-it.net , odoocn.org，odoo.net.cn

原论坛用户的基本信息和发帖这里都予以保留，请注意：原论坛用户无需重新注册新用户，但是您的密码需要重置

开发人员可以登录gitter讨论组: http://gitter.im/odoo-china/Talk, 需要github账号

如果您登录系统碰到问题，请在微信公众号留言：

新手第一次安装openerp求助！无法连接数据库

  • 5

    看到网上对openerp的评价蛮高的！！就想下载下来在XP下试用一下！如果好用的话就吧店里的电脑换成UBUNTU装OPENERP，但是我现在在XP下所有的都安装完毕后就是无法连接数据库！！下面是日志文件，请高手帮我分析一下！谢谢！
    [2010-09-02 00:22:53,842] INFO:dbpool:Connecting to template1
    [2010-09-02 00:22:54,046] ERROR:dbpool:[01]:
    [2010-09-02 00:22:54,046] ERROR:dbpool:[02]: Environment Information :
    [2010-09-02 00:22:54,046] ERROR:dbpool:[03]: System : Windows-XP-5.1.2600-SP3
    [2010-09-02 00:22:54,046] ERROR:dbpool:[04]: OS Name : nt
    [2010-09-02 00:22:54,046] ERROR:dbpool:[05]: Operating System Release : XP
    [2010-09-02 00:22:54,046] ERROR:dbpool:[06]: Operating System Version : 5.1.2600
    [2010-09-02 00:22:54,046] ERROR:dbpool:[07]: Operating System Architecture : 32bit
    [2010-09-02 00:22:54,046] ERROR:dbpool:[08]: Operating System Locale : zh_CN.cp936
    [2010-09-02 00:22:54,046] ERROR:dbpool:[09]: Python Version : 2.5.2
    [2010-09-02 00:22:54,046] ERROR:dbpool:[10]: OpenERP-Server Version : 5.0.6
    [2010-09-02 00:22:54,046] ERROR:dbpool:[11]: Last revision No. & ID :
    [2010-09-02 00:22:54,046] ERROR:dbpool:[12]: Unable to connect to template1: FATAL:  password authentication failed for user "openpg"
    下面是客户端的：
    Traceback (most recent call last):
      File "modules\gui\main.pyo", line 548, in server_change
      File "modules\gui\main.pyo", line 355, in _refresh_langlist
      File "rpc.pyo", line 261, in db_exec_no_except
      File "rpc.pyo", line 272, in exec_no_except
      File "tiny_socket.pyo", line 74, in myreceive
    ValueError: invalid literal for int() with base 10: 'HTTP/1.1'
    Traceback (most recent call last):
      File "modules\gui\main.pyo", line 548, in server_change
      File "modules\gui\main.pyo", line 355, in _refresh_langlist
      File "rpc.pyo", line 261, in db_exec_no_except
      File "rpc.pyo", line 272, in exec_no_except
      File "tiny_socket.pyo", line 74, in myreceive
      File "tiny_socket.pyo", line 68, in read
    socket.error: (10054, 'Connection reset by peer')
    Traceback (most recent call last):
      File "modules\gui\main.pyo", line 548, in server_change
      File "modules\gui\main.pyo", line 355, in _refresh_langlist
      File "rpc.pyo", line 261, in db_exec_no_except
      File "rpc.pyo", line 272, in exec_no_except
      File "tiny_socket.pyo", line 74, in myreceive
    ValueError: invalid literal for int() with base 10: 'HTTP/1.1'
    Traceback (most recent call last):
      File "modules\gui\main.pyo", line 548, in server_change
      File "modules\gui\main.pyo", line 355, in _refresh_langlist
      File "rpc.pyo", line 261, in db_exec_no_except
      File "rpc.pyo", line 272, in exec_no_except
      File "tiny_socket.pyo", line 74, in myreceive
      File "tiny_socket.pyo", line 68, in read
    socket.error: (10054, 'Connection reset by peer')
    Traceback (most recent call last):
      File "modules\gui\main.pyo", line 548, in server_change
      File "modules\gui\main.pyo", line 355, in _refresh_langlist
      File "rpc.pyo", line 261, in db_exec_no_except
      File "rpc.pyo", line 272, in exec_no_except
      File "tiny_socket.pyo", line 74, in myreceive
    ValueError: invalid literal for int() with base 10: 'HTTP/1.1'
    Traceback (most recent call last):
      File "modules\gui\main.pyo", line 548, in server_change
      File "modules\gui\main.pyo", line 355, in _refresh_langlist
      File "rpc.pyo", line 261, in db_exec_no_except
      File "rpc.pyo", line 272, in exec_no_except
      File "tiny_socket.pyo", line 74, in myreceive
      File "tiny_socket.pyo", line 68, in read
    socket.error: (10054, 'Connection reset by peer')
    Traceback (most recent call last):
      File "modules\gui\main.pyo", line 548, in server_change
      File "modules\gui\main.pyo", line 355, in _refresh_langlist
      File "rpc.pyo", line 261, in db_exec_no_except
      File "rpc.pyo", line 272, in exec_no_except
      File "tiny_socket.pyo", line 74, in myreceive
      File "tiny_socket.pyo", line 68, in read
    socket.error: (10054, 'Connection reset by peer')
    Traceback (most recent call last):
      File "modules\gui\main.pyo", line 548, in server_change
      File "modules\gui\main.pyo", line 355, in _refresh_langlist
      File "rpc.pyo", line 261, in db_exec_no_except
      File "rpc.pyo", line 272, in exec_no_except
      File "tiny_socket.pyo", line 74, in myreceive
    ValueError: invalid literal for int() with base 10: 'HTTP/1.1'
    我程序全是默认安装的！没做任何设置！只是把openerp-allinone-setup-5.0.6.exe安装在E盘根目录下了！！
    postgresql-8.4.4-1-windows.exe 默认安装，已开启服务，并连接服务！未作其他任何设置！

    还有一个问题就是双击openerp-server.exe就只是出来一个黑色的命令行窗口，好像未执行任何命令！！窗口也不会自己关闭！！
    请高手帮我看看好吗？？谢谢大家了！！


    谢谢二楼大侠的帮助！我已经添加了你所说的用户了！！现在打开客户端显示“没有找到数据库，你必须创建一个”
    我该创建一个怎么的数据库呢
    我点创建套帐老是不成功！！
    该怎么解决呢？
    我添加的默认用户是在PSQL的登录角色里创建的！

    0
  • 管理员

    [quote]: Unable to connect to template1: FATAL:  password authentication failed for user "openpg"[/quote]
    你需要在pgsql中创建openerp默认使用的用户：openpg, 密码设为openpgpwd

    0

  • 既然用All In One何必独立装pgsql，配置文件仔细读一下吧。创建帐套不成功是因为openerp server找不到你的pgsql命令路径

    0
  • 管理员

    [quote author=wjfonhand link=topic=2148.msg6735#msg6735 date=1283404980]
    既然用All In One何必独立装pgsql，配置文件仔细读一下吧。创建帐套不成功是因为openerp server找不到你的pgsql命令路径
    [/quote]

    虽然你没有提及创建账套有问题，wjfonhand已经提前为你指出了未来将出现的问题。


    你可以把“pgsql安装目录/bin“ 放到windows的path环境变量中，或者更改Openerp服务器安装目录下的openerp-server.conf， 将pgsql的安装路径加进去

    0
  • 5

    现在又出现以下问题！！无法创建套帐，应该是什么字体没找到！！但是宋体我的电脑里面有啊！！
    服务器端日志文件：
    [2010-09-03 08:57:16,765] INFO:server:version - 5.0.12
    [2010-09-03 08:57:16,765] INFO:server:addons_path - f:\openerp\Server\addons
    [2010-09-03 08:57:16,765] INFO:server:database hostname - 127.0.0.1
    [2010-09-03 08:57:16,765] INFO:server:database port - 5432
    [2010-09-03 08:57:16,765] INFO:server:database user - openpg
    [2010-09-03 08:57:16,765] INFO:objects:initialising distributed objects services
    [2010-09-03 08:57:17,140] INFO:web-services:starting XML-RPC services, port 8069
    [2010-09-03 08:57:17,140] INFO:web-services:starting NET-RPC service, port 8070
    [2010-09-03 08:57:17,140] INFO:web-services:the server is running, waiting for connections...
    客户端日志文件
    F:\openerp\Client\library.zip\modules\gui\main.py:510: PangoWarning: couldn't load font "宋体 Not-Rotated 9", falling back to "Sans Not-Rotated 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:510: PangoWarning: couldn't load font "宋体 9", falling back to "Sans 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:549: PangoWarning: couldn't load font "宋体 Bold Not-Rotated 9", falling back to "Sans Bold Not-Rotated 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:604: PangoWarning: couldn't load font "宋体 Italic 9", falling back to "Sans Italic 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:510: PangoWarning: couldn't load font "宋体 Not-Rotated 9", falling back to "Sans Not-Rotated 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:510: PangoWarning: couldn't load font "宋体 9", falling back to "Sans 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:549: PangoWarning: couldn't load font "宋体 Bold Not-Rotated 9", falling back to "Sans Bold Not-Rotated 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:510: PangoWarning: couldn't load font "宋体 Not-Rotated 9", falling back to "Sans Not-Rotated 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:510: PangoWarning: couldn't load font "宋体 9", falling back to "Sans 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:549: PangoWarning: couldn't load font "宋体 Bold Not-Rotated 9", falling back to "Sans Bold Not-Rotated 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:604: PangoWarning: couldn't load font "宋体 Italic 9", falling back to "Sans Italic 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:510: PangoWarning: couldn't load font "宋体 Not-Rotated 9", falling back to "Sans Not-Rotated 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:510: PangoWarning: couldn't load font "宋体 9", falling back to "Sans 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:549: PangoWarning: couldn't load font "宋体 Bold Not-Rotated 9", falling back to "Sans Bold Not-Rotated 9", expect ugly output.
    F:\openerp\Client\library.zip\modules\gui\main.py:604: PangoWarning: couldn't load font "宋体 Italic 9", falling back to "Sans Italic 9", expect ugly output.

    0

  • 建议看 Server 端 log 你的客户端log 好象 5.0.12 都会有.

    0
  • A

    我安装了也不行,7 8 版本都一样,但是下了个绿色版的,可以上去.你可以试下.

    不过现在又提示登陆账号密码不对了,估计是官方有调整.

    0