postgresql 安装odoo后出现Odoo 500服务器内部错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/39076484/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Odoo 500 server internal error after installation of odoo
提问by Abbas Per?in
H? all. Thank you for this community. I want use odoo for my job. but I'm so tired, I'm on the verge of giving up from odoo.
H？全部。感谢这个社区。我想在我的工作中使用 odoo。但是我太累了，我快要放弃odoo了。
I would be very grateful if you help.
如果您提供帮助，我将不胜感激。
After installation, I can get once localhost8069 . And creating database. ANd ? take create database error.
安装后，我可以得到一次 localhost8069 。并创建数据库。和 ？采取创建数据库错误。
Database creation error: "invalid byte sequence for encoding "UTF8": 0xff " while parsing /usr/lib/python2.7/dist-packages/openerp/addons/base/base_data.xml:55, near <span>--<br/> Administrator</span>
数据库创建错误：在解析 /usr/lib/python2.7/dist-packages/openerp/addons/base/base_data.xml:55 时，“用于编码“UTF8”的无效字节序列：0xff“，<span>--< br/> 管理员</span>
After this error ? take always 500 internal server error. I can not see login interface anymore. I just see 500 internal server error.
在这个错误之后？总是 500 内部服务器错误。我再也看不到登录界面了。我只看到 500 个内部服务器错误。
6 days I'm working and I could not reach a solution. I used ubuntu and pardus ( some kind debian) . And the results did not change.
我正在工作 6 天，但无法找到解决方案。我使用了 ubuntu 和 pardus（某种 debian）。结果没有改变。
But when ? used w7 ? succeed. I was able to get odoo. But ? want use odoo in linux not windows.
但当 ？用过 w7 吗？成功。我能够得到odoo。但 ？想在linux而不是windows中使用odoo。
I guess this error about database. But ? didnt find source about conf?gure postgresql for odoo. Can you help me pls ?
我猜这个关于数据库的错误。但 ？没有找到有关 odoo 配置 postgresql 的来源。你能帮我吗？
This is my steps for installions of odoo after fresh ubuntu :
这是我在新的 ubuntu 之后安装 odoo 的步骤：
1-)
1-)
wget -O - nightly.odoo.com/odoo.key | apt-key add -
echo "deb nightly.odoo.com/9.0/nightly/deb/ ./" >> /etc/apt/sources.list
apt-get update && apt-get install odoo
2-) and go : http://localhost:8069
2-) 然后去：http://localhost:8069
Log file : ? erased log file and restart odoo server and try few time localhost:8069 again :
日志文件：？删除日志文件并重新启动 odoo 服务器并再次尝试 localhost:8069 ：
And this is end of new fresh log file :
这是新的新日志文件的结尾：
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1554, in setup_db
setup_db 中的文件“/usr/lib/python2.7/dist-packages/openerp/http.py”，第 1554 行
httprequest.session.db = db_monodb(httprequest)
httprequest.session.db = db_monodb(httprequest)
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1701, in db_monodb
db_monodb 中的文件“/usr/lib/python2.7/dist-packages/openerp/http.py”，第 1701 行
dbs = db_list(True, httprequest)
dbs = db_list(True, httprequest)
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1675, in db_list
db_list 中的文件“/usr/lib/python2.7/dist-packages/openerp/http.py”，第 1675 行
dbs = openerp.service.db.list_dbs(force)
dbs = openerp.service.db.list_dbs(force)
File "/usr/lib/python2.7/dist-packages/openerp/service/db.py", line 323, in list_dbs with closing(db.cursor()) as cr: File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 630, in cursor
文件“/usr/lib/python2.7/dist-packages/openerp/service/db.py”，第323行，在list_dbs中，关闭（db.cursor（））为cr：文件“/usr/lib/python2. 7/dist-packages/openerp/sql_db.py", line 630, in cursor
return Cursor(self.pool, self.dbname, self.dsn, serialized=serialized) File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 164, in __init
return Cursor( self.pool, self.dbname, self.dsn, serialized=serialized) File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 164, in __init
self._cnx = pool.borrow(dsn)
self._cnx = pool.borrow(dsn)
File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 513, in _locked
文件“/usr/lib/python2.7/dist-packages/openerp/sql_db.py”，第 513 行，在 _locked
return fun(self, *args, **kwargs)
返回乐趣（自我，*args，**kwargs）
File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 581, in borrow
文件“/usr/lib/python2.7/dist-packages/openerp/sql_db.py”，第581行，借用
**connection_info)
**连接信息）
File "/usr/lib/python2.7/dist-packages/psycopg2/init.py", line 164, in connect
文件“/usr/lib/python2.7/dist-packages/psycopg2/初始化的.py”，线路164，在连接
conn = _connect(dsn, connection_factory=connection_factory, async=async)
conn = _connect(dsn, connection_factory=connection_factory, async=async)
OperationalError: fe_sendauth: no password supplied
OperationalError: fe_sendauth: 没有提供密码
回答by Ghassan Zein
Let's try with the first solution:
让我们尝试第一个解决方案：
Make sure the permission is correct for postgres engine by giving the correct one as the following:
通过提供正确的权限，确保 postgres 引擎的权限正确，如下所示：
sudo chown -R postgres:postgres /var/run/postgresql (default directory)
sudo chown -R postgres:postgres /var/run/postgresql (默认目录)
Plus, make sure the port 8069 is open.
另外，请确保端口 8069 已打开。
回答by Abbas Per?in
I finally found a solution. The problem is very simple. This problem is caused by using debian, which is not English. The English debian worked without error.
我终于找到了解决方案。问题很简单。这个问题是用debian造成的，不是英文的。英文版 debian 运行没有错误。
As a result, we always use the operating system in English.
因此，我们始终使用英文操作系统。
回答by user3676872
- try this command: ps -A
- check for postgresql & odoo proccess and kill them all
- do it for few times
- if you are using VMware like me restart it
- hope that answer your question
- 试试这个命令：ps -A
- 检查 postgresql 和 odoo 进程并将它们全部杀死
- 做几次
- 如果您像我一样使用 VMware 重新启动它
- 希望回答你的问题
