Odoo 中文社区

eremiter

@digitalsatori 在有研究odoo10中docker怎么安装pysftp 中说：

gcc

谢谢指点，其实 apt install gcc 是有测试过的，也是安装不上的，可能也是少了什么库

eremiter

环境：ubuntu18+docker17，在database/manager备份数据库，出现如下，真是邪门
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpiUgH1y/dump.sql', u'odoo10') error 1

日志：
018-06-19 13:18:56,421 1 INFO odoo10 odoo.service.db: DUMP DB: odoo10 format zip
odoo10_1 | 2018-06-19 13:18:56,661 1 ERROR odoo10 odoo.addons.web.controllers.main: Database.backup
odoo10_1 | Traceback (most recent call last):
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 687, in backup
odoo10_1 | dump_stream = odoo.service.db.dump_db(name, None, backup_format)
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/service/db.py", line 197, in dump_db
odoo10_1 | odoo.tools.exec_pg_command(*cmd)
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/tools/misc.py", line 124, in exec_pg_command
odoo10_1 | raise Exception('Postgres subprocess %s error %s' % (args2, rc))
odoo10_1 | Exception: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpjIyYWu/dump.sql', u'odoo10') error 1
odoo10_1 | 2018-06-19 13:18:56,720 1 INFO odoo10 werkzeug: 192.168.1.13 - - [19/Jun/2018 13:18:56] "POST /web/database/backup HTTP/1.1" 200 -
odoo10_1 | 2018-06-19 13:19:19,730 1 INFO odoo10 werkzeug: 192.168.1.13 - - [19/Jun/2018 13:19:19] "POST /longpolling/poll HTTP/1.1" 200 -
odoo10_1 | 2018-06-19 13:22:42,435 1 INFO odoo10 odoo.service.db: DUMP DB: odoo10 format zip
odoo10_1 | 2018-06-19 13:22:42,669 1 ERROR odoo10 odoo.addons.web.controllers.main: Database.backup
odoo10_1 | Traceback (most recent call last):
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 687, in backup
odoo10_1 | dump_stream = odoo.service.db.dump_db(name, None, backup_format)
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/service/db.py", line 197, in dump_db
odoo10_1 | odoo.tools.exec_pg_command(*cmd)
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/tools/misc.py", line 124, in exec_pg_command
odoo10_1 | raise Exception('Postgres subprocess %s error %s' % (args2, rc))
odoo10_1 | Exception: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpMqTBnJ/dump.sql', u'odoo10') error 1
odoo10_1 | 2018-06-19 13:22:42,730 1 INFO odoo10 werkzeug: 192.168.1.13 - - [19/Jun/2018 13:22:42] "POST /web/database/backup HTTP/1.1" 200 -
odoo10_1 | 2018-06-19 13:23:03,860 1 INFO odoo10 odoo.service.db: DUMP DB: odoo10 format zip
odoo10_1 | 2018-06-19 13:23:04,100 1 ERROR odoo10 odoo.addons.web.controllers.main: Database.backup
odoo10_1 | Traceback (most recent call last):
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 687, in backup
odoo10_1 | dump_stream = odoo.service.db.dump_db(name, None, backup_format)
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/service/db.py", line 197, in dump_db
odoo10_1 | odoo.tools.exec_pg_command(*cmd)
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/tools/misc.py", line 124, in exec_pg_command
odoo10_1 | raise Exception('Postgres subprocess %s error %s' % (args2, rc))
odoo10_1 | Exception: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpckWKkn/dump.sql', u'odoo10') error 1
odoo10_1 | 2018-06-19 13:23:04,160 1 INFO odoo10 werkzeug: 192.168.1.13 - - [19/Jun/2018 13:23:04] "POST /web/database/backup HTTP/1.1" 200 -
odoo10_1 | 2018-06-19 13:23:04,269 1 INFO ? werkzeug: 192.168.1.13 - - [19/Jun/2018 13:23:04] "GET /web/static/src/img/favicon.ico HTTP/1.1" 200 -
odoo10_1 | 2018-06-19 13:23:12,213 1 INFO odoo10 werkzeug: 192.168.1.13 - - [19/Jun/2018 13:23:12] "GET /web/database/ HTTP/1.1" 404 -
odoo10_1 | 2018-06-19 13:23:12,303 1 INFO odoo10 werkzeug: 192.168.1.13 - - [19/Jun/2018 13:23:12] "GET /favicon.ico HTTP/1.1" 404 -
odoo10_1 | 2018-06-19 13:23:18,535 1 INFO odoo10 werkzeug: 192.168.1.13 - - [19/Jun/2018 13:23:18] "GET /web/database/manager HTTP/1.1" 200 -
odoo10_1 | 2018-06-19 13:23:26,743 1 INFO odoo10 odoo.service.db: DUMP DB: odoo10 format zip
odoo10_1 | 2018-06-19 13:23:26,963 1 ERROR odoo10 odoo.addons.web.controllers.main: Database.backup
odoo10_1 | Traceback (most recent call last):
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 687, in backup
odoo10_1 | dump_stream = odoo.service.db.dump_db(name, None, backup_format)
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/service/db.py", line 197, in dump_db
odoo10_1 | odoo.tools.exec_pg_command(*cmd)
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/tools/misc.py", line 124, in exec_pg_command
odoo10_1 | raise Exception('Postgres subprocess %s error %s' % (args2, rc))
odoo10_1 | Exception: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmp0uRY56/dump.sql', u'odoo10') error 1
odoo10_1 | 2018-06-19 13:23:27,022 1 INFO odoo10 werkzeug: 192.168.1.13 - - [19/Jun/2018 13:23:27] "POST /web/database/backup HTTP/1.1" 200 -
odoo10_1 | 2018-06-19 13:33:53,871 1 INFO odoo10 werkzeug: 192.168.1.13 - - [19/Jun/2018 13:33:53] "GET /web/database/manager HTTP/1.1" 200 -
odoo10_1 | 2018-06-19 13:34:01,206 1 INFO odoo10 odoo.service.db: DUMP DB: odoo10 format zip
odoo10_1 | 2018-06-19 13:34:01,466 1 ERROR odoo10 odoo.addons.web.controllers.main: Database.backup
odoo10_1 | Traceback (most recent call last):
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 687, in backup
odoo10_1 | dump_stream = odoo.service.db.dump_db(name, None, backup_format)
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/service/db.py", line 197, in dump_db
odoo10_1 | odoo.tools.exec_pg_command(*cmd)
odoo10_1 | File "/usr/lib/python2.7/dist-packages/odoo/tools/misc.py", line 124, in exec_pg_command
odoo10_1 | raise Exception('Postgres subprocess %s error %s' % (args2, rc))
odoo10_1 | Exception: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpiUgH1y/dump.sql', u'odoo10') error 1
odoo10_1 | 2018-06-19 13:34:01,525 1 INFO odoo10 werkzeug: 192.168.1.13 - - [19/Jun/2018 13:34:01] "POST /web/database/backup HTTP/1.1" 200 -

eremiter

登入docker安装pip install pysftp，错误信息退出

/usr/lib/python2.7# pip install pysftp
Downloading/unpacking pysftp
Downloading pysftp-0.2.9.tar.gz
Running setup.py (path:/tmp/pip-build-327rFu/pysftp/setup.py) egg_info for package pysftp

no previously-included directories found matching 'docs/_build'

Downloading/unpacking paramiko>=1.17 (from pysftp)
Downloading paramiko-2.4.1-py2.py3-none-any.whl (194kB): 194kB downloaded
Downloading/unpacking pyasn1>=0.1.7 (from paramiko>=1.17->pysftp)
Downloading pyasn1-0.4.3-py2.py3-none-any.whl (72kB): 72kB downloaded
Downloading/unpacking bcrypt>=3.1.3 (from paramiko>=1.17->pysftp)
Downloading bcrypt-3.1.4.tar.gz (42kB): 42kB downloaded
Running setup.py (path:/tmp/pip-build-327rFu/bcrypt/setup.py) egg_info for package bcrypt

warning: no previously-included files found matching 'requirements.txt'
warning: no previously-included files found matching 'tasks.py'
warning: no previously-included files found matching '.travis.yml'
warning: no previously-included files found matching 'wheel-scripts'
warning: no previously-included files found matching 'Jenkinsfile'
warning: no previously-included files found matching '.jenkins'
warning: no previously-included files matching '*' found under directory '.jenkins'
warning: no previously-included files matching '*' found under directory 'wheel-scripts'
no previously-included directories found matching '.travis'

Downloading/unpacking pynacl>=1.0.1 (from paramiko>=1.17->pysftp)
Downloading PyNaCl-1.2.1.tar.gz (3.3MB): 3.3MB downloaded
Running setup.py (path:/tmp/pip-build-327rFu/pynacl/setup.py) egg_info for package pynacl
unable to execute 'x86_64-linux-gnu-gcc': No such file or directory
unable to execute 'x86_64-linux-gnu-gcc': No such file or directory

    No working compiler found, or bogus compiler options passed to
    the compiler from Python's standard "distutils" module.  See
    the error messages above.  Likely, the problem is not related
    to CFFI but generic to the setup.py of any Python package that
    tries to compile C code.  (Hints: on OS/X 10.8, for errors about
    -mno-fused-madd see http://stackoverflow.com/questions/22313407/
    Otherwise, see https://wiki.python.org/moin/CompLangPython or
    the IRC channel #python on irc.freenode.net.)
Traceback (most recent call last):
  File "<string>", line 17, in <module>
  File "/tmp/pip-build-327rFu/pynacl/setup.py", line 251, in <module>
    "Programming Language :: Python :: 3.6",
  File "/usr/lib/python2.7/distutils/core.py", line 111, in setup
    _setup_distribution = dist = klass(attrs)
  File "/usr/lib/python2.7/dist-packages/setuptools/dist.py", line 262, in __init__
    self.fetch_build_eggs(attrs['setup_requires'])
  File "/usr/lib/python2.7/dist-packages/setuptools/dist.py", line 287, in fetch_build_eggs
    replace_conflicting=True,
  File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 631, in resolve
    dist = best[req.key] = env.best_match(req, ws, installer)
  File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 874, in best_match
    return self.obtain(req, installer)
  File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 886, in obtain
    return installer(requirement)
  File "/usr/lib/python2.7/dist-packages/setuptools/dist.py", line 338, in fetch_build_egg
    return cmd.easy_install(req)
  File "/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 636, in easy_install
    return self.install_item(spec, dist.location, tmpdir, deps)
  File "/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 666, in install_item
    dists = self.install_eggs(spec, download, tmpdir)
  File "/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 856, in install_eggs
    return self.build_and_install(setup_script, setup_base)
  File "/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 1078, in build_and_install
    self.run_setup(setup_script, setup_base, args)
  File "/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 1066, in run_setup
    raise DistutilsError("Setup script exited with %s" % (v.args[0],))
distutils.errors.DistutilsError: Setup script exited with 1
Complete output from command python setup.py egg_info:
unable to execute 'x86_64-linux-gnu-gcc': No such file or directory

unable to execute 'x86_64-linux-gnu-gcc': No such file or directory

No working compiler found, or bogus compiler options passed to

the compiler from Python's standard "distutils" module.  See

the error messages above.  Likely, the problem is not related

to CFFI but generic to the setup.py of any Python package that

tries to compile C code.  (Hints: on OS/X 10.8, for errors about

-mno-fused-madd see http://stackoverflow.com/questions/22313407/

Otherwise, see https://wiki.python.org/moin/CompLangPython or

the IRC channel #python on irc.freenode.net.)

Traceback (most recent call last):

File "", line 17, in

File "/tmp/pip-build-327rFu/pynacl/setup.py", line 251, in

"Programming Language :: Python :: 3.6",

File "/usr/lib/python2.7/distutils/core.py", line 111, in setup

_setup_distribution = dist = klass(attrs)

File "/usr/lib/python2.7/dist-packages/setuptools/dist.py", line 262, in init

self.fetch_build_eggs(attrs['setup_requires'])

File "/usr/lib/python2.7/dist-packages/setuptools/dist.py", line 287, in fetch_build_eggs

replace_conflicting=True,

File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 631, in resolve

dist = best[req.key] = env.best_match(req, ws, installer)

File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 874, in best_match

return self.obtain(req, installer)

File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 886, in obtain

return installer(requirement)

File "/usr/lib/python2.7/dist-packages/setuptools/dist.py", line 338, in fetch_build_egg

return cmd.easy_install(req)

File "/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 636, in easy_install

return self.install_item(spec, dist.location, tmpdir, deps)

File "/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 666, in install_item

dists = self.install_eggs(spec, download, tmpdir)

File "/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 856, in install_eggs

return self.build_and_install(setup_script, setup_base)

File "/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 1078, in build_and_install

self.run_setup(setup_script, setup_base, args)

File "/usr/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 1066, in run_setup

raise DistutilsError("Setup script exited with %s" % (v.args[0],))

distutils.errors.DistutilsError: Setup script exited with 1

Cleaning up...
Command python setup.py egg_info failed with error code 1 in /tmp/pip-build-327rFu/pynacl
Storing debug log for failure in /root/.pip/pip.log

eremiter

@guohuadeng 在 odoo11-windows64位高性能最新绿色版下载及制作方法-提速50% 中说：

主要用于开发，便于多版本共存及本机快速测试。实测下发现比旧的绿色性性能提升很多，共享下。
64位版本性能会比32位高很多，包括高效指令及大内存更快巡址。对高资源消耗的odoo，使用64位是十分有必要的。

本版本参考 greenodoo 绿色版，在全部进行了64位版本更新的基础上进行了参数优化，同时因为使用了nginx，实现了longpolling，可以使用桌面消息通知，也不会经常报错了。

主要由以下主要程序组成

python 2.7.13 ，64位

postgresql 9.6.4 ，64位

Nginx 1.12.1， 32位

odoo 11 ，官方github，20170817版(注意选择master分支)，如果需要最新版点此下载

实测效果：

32位绿色版新建一个默认数据库用时 1分28秒

64位优化版用时 51秒，性能提升明显

详细信息访问
http://www.sunpop.cn/odoo11_fast_x64_download/
或者Github
https://github.com/guohuadeng/odoo11-x64

牛人一个，odoo10也能提速多少呢

eremiter

@jalena 谢谢热心的jalena

eremiter

@卓忆在整理及测试：Odoo11安装,Odoo11生产环境部署：在Ubuntu Server16.04下Odoo11安装并配置为服务中说：

@digitalsatori 在整理及测试：Odoo11安装,Odoo11生产环境部署：在Ubuntu Server16.04下Odoo11安装并配置为服务中说：

写得非常全面，仔细。

请注意Odoo 11虽然能向后兼容支持Python2.7.X，但是只有在Python3.5.X上做了完整测试，所以大家尽可能还是用Python3来启动Odoo。

另外，Odoo运行环境的部署要尽可能使用虚拟Python环境与系统Python环境想隔离，建议使用pipenv, pipevn的使用请参见我们的公司博客：http://odoo.com.cn/posts/pipenv/

谢谢Tony的指点，的确是和系统自带的环境隔离后会更好。

T哥，功德无量，试问一下，python3版本有好多，到底要安装哪一个3.5、3.6、3、7；postgresql也有好多，默认是安装哪一个版本，如何指定安装的版本

Latest Python 3 Release - Python 3.6.3
Latest Python 2 Release - Python 2.7.14

eremiter

是并发1万页，就是数据量到达1万就有问题

eremiter

odoo10有什么插件，可以让普通用户查看发出的邮件，目前只有收件箱，没有发件箱？？？

eremiter

自己搞定，分享一下，方便别人，详情请见这个

http://blog.csdn.net/m0_37586991/article/details/73844247

eremiter

原先是odoo10,新建一个odoo11，原先的项目不见了，不知如何切换不同的odoo项目

eremiter

@eremiter

eremiter 发布的帖子