新手第一次安装openerp求助！无法连接数据库
-
看到网上对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的登录角色里创建的！ -
[quote]: Unable to connect to template1: FATAL: password authentication failed for user "openpg"[/quote]
你需要在pgsql中创建openerp默认使用的用户：openpg, 密码设为openpgpwd -
[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的安装路径加进去 -
现在又出现以下问题！！无法创建套帐，应该是什么字体没找到！！但是宋体我的电脑里面有啊！！
服务器端日志文件：
[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.
