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里面的内容

    [code]2013-11-13 09:30:24,157 2168 INFO ? openerp: OpenERP version 7.0-20131113-002526
    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
    2013-11-13 09:30:24,157 2168 INFO ? openerp: database hostname: localhost
    2013-11-13 09:30:24,157 2168 INFO ? openerp: database port: 5432
    2013-11-13 09:30:24,157 2168 INFO ? openerp: database user: openpg
    2013-11-13 09:30:25,095 2168 ERROR ? openerp.sql_db: Connection to the database failed
    Traceback (most recent call last):
      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

    2013-11-13 09:30:25,095 2168 ERROR PostgreSQL 9.2 openerp: Failed to initialize database PostgreSQL 9.2.
    Traceback (most recent call last):
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\cli\server.py", line 97, in preload_registry
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\pooler.py", line 33, in get_db_and_pool
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\modules\registry.py", line 192, in get
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\modules\registry.py", line 208, in new
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\modules\registry.py", line 76, in init
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\sql_db.py", line 484, in cursor
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\sql_db.py", line 182, in init
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\sql_db.py", line 377, in locked
      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

    2013-11-13 09:30:25,095 2168 INFO PostgreSQL 9.2 openerp: OpenERP server is running, waiting for connections...
    2013-11-13 09:30:25,173 2168 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069
    2013-11-13 09:30:46,956 2168 ERROR ? openerp.sql_db: Connection to the database failed
    Traceback (most recent call last):
      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: ÖÂÃü´íÎó:  Óû§ "openpg" Password ÈÏ֤ʧ°Ü

    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 -
    2013-11-13 09:30:47,299 2168 ERROR ? werkzeug: Error on request:
    Traceback (most recent call last):
      File "werkzeug\serving.py", line 159, in run_wsgi
       
      File "werkzeug\serving.py", line 146, in execute
       
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\service\wsgi_server.py", line 417, in application
        return application_unproxied(environ, start_response)
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\service\wsgi_server.py", line 403, in application_unproxied
        result = handler(environ, start_response)
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 528, in call
        return self.dispatch(environ, start_response)
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 487, in call
        return self.app(environ, start_wrapped)
      File "werkzeug\wsgi.py", line 411, in call
       
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 553, in dispatch
        result = handler(request)
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 621, in <lambda>
        return lambda request: HttpRequest(request).dispatch(method)
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 294, in dispatch
        e.faultString, traceback.format_exc())
      File "simplejson_init_.py", line 286, in dumps
       
      File "simplejson\encoder.py", line 228, in encode
       
      File "simplejson\encoder.py", line 515, in _iterencode
       
      File "simplejson\encoder.py", line 483, in _iterencode_dict
       
      File "simplejson\encoder.py", line 458, in _iterencode_dict
       
      File "simplejson\encoder.py", line 52, in py_encode_basestring_ascii
       
      File "encodings\utf_8.py", line 16, in decode
       
    UnicodeDecodeError: 'utf8' codec can't decode bytes in position 1081-1082: invalid data
    [/code]

    以上的错误看起来应该是openerp没有能和postgresql链接起来。我已经在windows的firewall里面帮助了PostgreSQL的5432开了口,并把openerp-server同样是开了口。所以应该不是防火墙的问题。

    以下是我PostgreSQL的信息:
    [code]服务器名称是: PostgreSQL 9.2 (localhost:5432)
    数据库名称:postgres
    [/code]
    如果我的经验没错的话,应该是没有正确的连接到数据库上面,还请高手们给小弟一个方向。

    还有就是不知道哪里有openerp7.0的教程,可以学习使用openerp的,甚至是开发的?

    因为本人还是在校学生,没办法付那个3000多欧元的online training。

    先行感谢。



  • 本人是刚刚接触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里面的内容

    [code]2013-11-13 09:30:24,157 2168 INFO ? openerp: OpenERP version 7.0-20131113-002526
    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
    2013-11-13 09:30:24,157 2168 INFO ? openerp: database hostname: localhost
    2013-11-13 09:30:24,157 2168 INFO ? openerp: database port: 5432
    2013-11-13 09:30:24,157 2168 INFO ? openerp: database user: openpg
    2013-11-13 09:30:25,095 2168 ERROR ? openerp.sql_db: Connection to the database failed
    Traceback (most recent call last):
      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

    2013-11-13 09:30:25,095 2168 ERROR PostgreSQL 9.2 openerp: Failed to initialize database PostgreSQL 9.2.
    Traceback (most recent call last):
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\cli\server.py", line 97, in preload_registry
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\pooler.py", line 33, in get_db_and_pool
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\modules\registry.py", line 192, in get
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\modules\registry.py", line 208, in new
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\modules\registry.py", line 76, in init
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\sql_db.py", line 484, in cursor
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\sql_db.py", line 182, in init
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server.\openerp\sql_db.py", line 377, in locked
      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

    2013-11-13 09:30:25,095 2168 INFO PostgreSQL 9.2 openerp: OpenERP server is running, waiting for connections...
    2013-11-13 09:30:25,173 2168 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069
    2013-11-13 09:30:46,956 2168 ERROR ? openerp.sql_db: Connection to the database failed
    Traceback (most recent call last):
      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: ÖÂÃü´íÎó:  Óû§ "openpg" Password ÈÏ֤ʧ°Ü

    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 -
    2013-11-13 09:30:47,299 2168 ERROR ? werkzeug: Error on request:
    Traceback (most recent call last):
      File "werkzeug\serving.py", line 159, in run_wsgi
       
      File "werkzeug\serving.py", line 146, in execute
       
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\service\wsgi_server.py", line 417, in application
        return application_unproxied(environ, start_response)
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\service\wsgi_server.py", line 403, in application_unproxied
        result = handler(environ, start_response)
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 528, in call
        return self.dispatch(environ, start_response)
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 487, in call
        return self.app(environ, start_wrapped)
      File "werkzeug\wsgi.py", line 411, in call
       
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 553, in dispatch
        result = handler(request)
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 621, in <lambda>
        return lambda request: HttpRequest(request).dispatch(method)
      File "C:\Program Files (x86)\OpenERP 7.0-20131113-002526\Server\server\openerp\addons\web\http.py", line 294, in dispatch
        e.faultString, traceback.format_exc())
      File "simplejson_init_.py", line 286, in dumps
       
      File "simplejson\encoder.py", line 228, in encode
       
      File "simplejson\encoder.py", line 515, in _iterencode
       
      File "simplejson\encoder.py", line 483, in _iterencode_dict
       
      File "simplejson\encoder.py", line 458, in _iterencode_dict
       
      File "simplejson\encoder.py", line 52, in py_encode_basestring_ascii
       
      File "encodings\utf_8.py", line 16, in decode
       
    UnicodeDecodeError: 'utf8' codec can't decode bytes in position 1081-1082: invalid data
    [/code]

    以上的错误看起来应该是openerp没有能和postgresql链接起来。我已经在windows的firewall里面帮助了PostgreSQL的5432开了口,并把openerp-server同样是开了口。所以应该不是防火墙的问题。

    以下是我PostgreSQL的信息:
    [code]服务器名称是: PostgreSQL 9.2 (localhost:5432)
    数据库名称:postgres
    [/code]
    如果我的经验没错的话,应该是没有正确的连接到数据库上面,还请高手们给小弟一个方向。

    还有就是不知道哪里有openerp7.0的教程,可以学习使用openerp的,甚至是开发的?

    因为本人还是在校学生,没办法付那个3000多欧元的online training。

    先行感谢。



  • 请多看:
    www.shine-it.net         
    http://blog.sina.com.cn/kaiyuanlvzhou

    汉化包: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后面少了个等于号?



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



  • 我用绿色版也不行



  • 重启了服务器就可以了


登录后回复
 

与 Odoo 中文社区 的连接断开,我们正在尝试重连,请耐心等待