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

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

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

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

刚刚安装了OpenERP,但是打开openerp的时候遇见 Internal Server Error



  • 本人是刚刚接触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 />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py&quot;, line 440, in borrow<br />&nbsp; File &quot;psycopg2\__init__.pyc&quot;, line 178, in connect<br />OperationalError: missing &quot;=&quot; after &quot;9.2&quot; 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 />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\cli\server.py&quot;, line 97, in preload_registry<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\pooler.py&quot;, line 33, in get_db_and_pool<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\modules\registry.py&quot;, line 192, in get<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\modules\registry.py&quot;, line 208, in new<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\modules\registry.py&quot;, line 76, in __init__<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py&quot;, line 484, in cursor<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py&quot;, line 182, in __init__<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py&quot;, line 377, in _locked<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py&quot;, line 440, in borrow<br />&nbsp; File &quot;psycopg2\__init__.pyc&quot;, line 178, in connect<br />OperationalError: missing &quot;=&quot; after &quot;9.2&quot; 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 />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\.\openerp\sql_db.py&quot;, line 440, in borrow<br />&nbsp; File &quot;psycopg2\__init__.pyc&quot;, line 178, in connect<br />OperationalError: ÖÂÃü´íÎó:&nbsp; Óû§ &quot;openpg&quot; Password ÈÏ֤ʧ°Ü<br /><br />2013-11-13 09:30:47,253 2168 INFO ? werkzeug: 127.0.0.1 - - [13/Nov/2013 09:30:47] &quot;GET / HTTP/1.1&quot; 500 -<br />2013-11-13 09:30:47,299 2168 ERROR ? werkzeug: Error on request:<br />Traceback (most recent call last):<br />&nbsp; File &quot;werkzeug\serving.py&quot;, line 159, in run_wsgi<br />&nbsp; &nbsp; <br />&nbsp; File &quot;werkzeug\serving.py&quot;, line 146, in execute<br />&nbsp; &nbsp; <br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\service\wsgi_server.py&quot;, line 417, in application<br />&nbsp; &nbsp; return application_unproxied(environ, start_response)<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\service\wsgi_server.py&quot;, line 403, in application_unproxied<br />&nbsp; &nbsp; result = handler(environ, start_response)<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py&quot;, line 528, in __call__<br />&nbsp; &nbsp; return self.dispatch(environ, start_response)<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py&quot;, line 487, in __call__<br />&nbsp; &nbsp; return self.app(environ, start_wrapped)<br />&nbsp; File &quot;werkzeug\wsgi.py&quot;, line 411, in __call__<br />&nbsp; &nbsp; <br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py&quot;, line 553, in dispatch<br />&nbsp; &nbsp; result = handler(request)<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py&quot;, line 621, in &lt;lambda&gt;<br />&nbsp; &nbsp; return lambda request: HttpRequest(request).dispatch(method)<br />&nbsp; File &quot;C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py&quot;, line 294, in dispatch<br />&nbsp; &nbsp; e.faultString, traceback.format_exc())<br />&nbsp; File &quot;simplejson\__init__.py&quot;, line 286, in dumps<br />&nbsp; &nbsp; <br />&nbsp; File &quot;simplejson\encoder.py&quot;, line 228, in encode<br />&nbsp; &nbsp; <br />&nbsp; File &quot;simplejson\encoder.py&quot;, line 515, in _iterencode<br />&nbsp; &nbsp; <br />&nbsp; File &quot;simplejson\encoder.py&quot;, line 483, in _iterencode_dict<br />&nbsp; &nbsp; <br />&nbsp; File &quot;simplejson\encoder.py&quot;, line 458, in _iterencode_dict<br />&nbsp; &nbsp; <br />&nbsp; File &quot;simplejson\encoder.py&quot;, line 52, in py_encode_basestring_ascii<br />&nbsp; &nbsp; <br />&nbsp; File &quot;encodings\utf_8.py&quot;, line 16, in decode<br />&nbsp; &nbsp; <br />UnicodeDecodeError: &#039;utf8&#039; codec can&#039;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。

    先行感谢。



  • 请多看:
    www.shine-it.net          <br / http://blog.sina.com.cn/kaiyuanlvzhou br />
    汉化包:http://item.taobao.com/item.htm?id=20614195019
    有20个完善建议被采纳就可获得免费获得全部汉化包,退还全部购买款。
    包括未翻译的、错别字、标点错误、语句不通顺、不符合中国习惯 等等。

    有40个建议被采纳则享受参与者待遇,可参加OpenERP免费讲座活动,并可以成本价获得中文手册http://item.taobao.com/item.htm?id=16608114834
    请对手册多提宝贵建议。



  • 我也遇到这个问题,不知道怎么解决了,服务中的odoo-server-8.0、postgreSQL Server 都是开启状态 。 防火墙 也允许通过, 但是打开http://localhost:8069 还是出现错误:

    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.



  • File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\sql_db.py", line 440, in borrow
      File "psycopg2_init_.pyc", line 178, in connect
    OperationalError: missing "=" after "9.2" in connection info string
    ----- 从上面,9.2后面少了个等于号?



  • 那就先用绿色版吧.......



  • 我用绿色版也不行



  • 重启了服务器就可以了