本人是刚刚接触openerp。 今天刚刚下载了openerp,安装在windows 2008的服务器上面,再好不容易安装好后,出现了以下问题:
Internal Server Error
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.
在windows的services中,OpenErp Server 7.0的状态是“已启动”, Postgresql-x64-9.2的状态是“已启动”。
以下是openerp-server-log里面的内容
2013-11-13 09:30:24,157 2168 INFO ? openerp: OpenERP version 7.0-20131113-002526<br />2013-11-13 09:30:24,157 2168 INFO ? openerp: addons paths: C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons<br />2013-11-13 09:30:24,157 2168 INFO ? openerp: database hostname: localhost<br />2013-11-13 09:30:24,157 2168 INFO ? openerp: database port: 5432<br />2013-11-13 09:30:24,157 2168 INFO ? openerp: database user: openpg<br />2013-11-13 09:30:25,095 2168 ERROR ? openerp.sql_db: Connection to the database failed<br />Traceback (most recent call last):<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py", line 440, in borrow<br /> File "psycopg2\__init__.pyc", line 178, in connect<br />OperationalError: missing "=" after "9.2" in connection info string<br /><br />2013-11-13 09:30:25,095 2168 ERROR PostgreSQL 9.2 openerp: Failed to initialize database `PostgreSQL 9.2`.<br />Traceback (most recent call last):<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\cli\server.py", line 97, in preload_registry<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\pooler.py", line 33, in get_db_and_pool<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\modules\registry.py", line 192, in get<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\modules\registry.py", line 208, in new<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\modules\registry.py", line 76, in __init__<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py", line 484, in cursor<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py", line 182, in __init__<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py", line 377, in _locked<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py", line 440, in borrow<br /> File "psycopg2\__init__.pyc", line 178, in connect<br />OperationalError: missing "=" after "9.2" in connection info string<br /><br />2013-11-13 09:30:25,095 2168 INFO PostgreSQL 9.2 openerp: OpenERP server is running, waiting for connections...<br />2013-11-13 09:30:25,173 2168 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069<br />2013-11-13 09:30:46,956 2168 ERROR ? openerp.sql_db: Connection to the database failed<br />Traceback (most recent call last):<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py", line 440, in borrow<br /> File "psycopg2\__init__.pyc", line 178, in connect<br />OperationalError: ÖÂÃü´íÎó: Óû§ "openpg" Password ÈÏ֤ʧ°Ü<br /><br />2013-11-13 09:30:47,253 2168 INFO ? werkzeug: 127.0.0.1 - - [13/Nov/2013 09:30:47] "GET / HTTP/1.1" 500 -<br />2013-11-13 09:30:47,299 2168 ERROR ? werkzeug: Error on request:<br />Traceback (most recent call last):<br /> File "werkzeug\serving.py", line 159, in run_wsgi<br /> <br /> File "werkzeug\serving.py", line 146, in execute<br /> <br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\service\wsgi_server.py", line 417, in application<br /> return application_unproxied(environ, start_response)<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\service\wsgi_server.py", line 403, in application_unproxied<br /> result = handler(environ, start_response)<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 528, in __call__<br /> return self.dispatch(environ, start_response)<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 487, in __call__<br /> return self.app(environ, start_wrapped)<br /> File "werkzeug\wsgi.py", line 411, in __call__<br /> <br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 553, in dispatch<br /> result = handler(request)<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 621, in <lambda><br /> return lambda request: HttpRequest(request).dispatch(method)<br /> File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 294, in dispatch<br /> e.faultString, traceback.format_exc())<br /> File "simplejson\__init__.py", line 286, in dumps<br /> <br /> File "simplejson\encoder.py", line 228, in encode<br /> <br /> File "simplejson\encoder.py", line 515, in _iterencode<br /> <br /> File "simplejson\encoder.py", line 483, in _iterencode_dict<br /> <br /> File "simplejson\encoder.py", line 458, in _iterencode_dict<br /> <br /> File "simplejson\encoder.py", line 52, in py_encode_basestring_ascii<br /> <br /> File "encodings\utf_8.py", line 16, in decode<br /> <br />UnicodeDecodeError: 'utf8' codec can't decode bytes in position 1081-1082: invalid data<br />
以上的错误看起来应该是openerp没有能和postgresql链接起来。我已经在windows的firewall里面帮助了PostgreSQL的5432开了口,并把openerp-server同样是开了口。所以应该不是防火墙的问题。
以下是我PostgreSQL的信息:
服务器名称是: PostgreSQL 9.2 (localhost:5432)<br />数据库名称:postgres<br />
如果我的经验没错的话,应该是没有正确的连接到数据库上面,还请高手们给小弟一个方向。
还有就是不知道哪里有openerp7.0的教程,可以学习使用openerp的,甚至是开发的?
因为本人还是在校学生,没办法付那个3000多欧元的online training。
先行感谢。