Arch Linux User Repository

@bidossessi

Many thanks to the updated package, Odoo is working for now without any problems.

Odoo 15 is working now with Python 3.10, I had tested the latest version and locally update PKGBUILD for the file odoo_15.0.20220512.tar.gz (it is necessary change the _pkgsubver, package "python<=3.9" to "python", update all sha256sums and download the odoo.install file from https://aur.archlinux.org/cgit/aur.git/snapshot/odoo.tar.gz).

The second choice will be docker, Odoo 15 is working with them in Arch Linux without any problems.

Hey All, Me again, felling a bit overwhelmed Odoo that essentially runs my whole business from web --> shop --> accountancy is now down I was trying to find a fix for the bug only thing I can find is a patch for python-odoorpc any had success with this not being a programmer in any seance of the word reading through it is daunting. Any help would be much appreciated.

Regards Graeme

@AlphaJack If I knew what the hell triple backticks was I would, yes I would agree there is some sort of incompatibility issue, in research if odoo is going to install itself within the current python directory what ever version that may be, time to move on as with every update causes a problem. Thanks Regards Graeme

@graeme Seems an upstream issue (2021-11-13), probably caused by an incompatibility (2021-12-09)with python 3.10.

Next time I would suggest to use triple backticks to make this kind of errors more readable:

```
CODE
```

Hey all, So had odoo V14 and python 3.9 running on a basic server ran an update this morning python up to 3.10 now odoo wont start with following errors:

Traceback (most recent call last): Dec 17 16:27:13 archserver odoo[64378]: File "/usr/bin/odoo", line 5, in <module> Dec 17 16:27:13 archserver odoo[64378]: import odoo Dec 17 16:27:13 archserver odoo[64378]: File "/usr/lib/python3.10/site-packages/odoo/init.py", line 115, in <module> Dec 17 16:27:13 archserver odoo[64378]: from . import osv Dec 17 16:27:13 archserver odoo[64378]: File "/usr/lib/python3.10/site-packages/odoo/osv/init.py", line 4, in <module> Dec 17 16:27:13 archserver odoo[64378]: from . import osv Dec 17 16:27:13 archserver odoo[64378]: File "/usr/lib/python3.10/site-packages/odoo/osv/osv.py", line 5, in <module> Dec 17 16:27:13 archserver odoo[64378]: from ..models import Model, TransientModel, AbstractModel Dec 17 16:27:13 archserver odoo[64378]: File "/usr/lib/python3.10/site-packages/odoo/models.py", line 6582, in <module> Dec 17 16:27:13 archserver odoo[64378]: collections.Set.register(BaseModel) Dec 17 16:27:13 archserver odoo[64378]: AttributeError: module 'collections' has no attribute 'Set' Dec 17 16:27:13 archserver systemd[1]: odoo.service: Main process exited, code=exited, status=1/FAILURE Dec 17 16:27:13 archserver systemd[1]: odoo.service: Failed with result 'exit-code'.

any ideas? thanks Graeme

@Faalagorn @Frahik @vmchura I have adopted and updated the package to v14, I did not encounter any database error with the new version

Hello, same problem as Faalagorn and Frahik. I am new at this package, please, I need help about it, thank you.

I have the same problem as Faalgorn, I have not been able to solve it, I tried through virtual environments and installing this package, but I have not been able to solve it

I managed to install it (I manually copied werkzeug's 3.8 files to 3.9 for Python 3.9 to work; probably not the best solution but it worked). I also had to create and give persmissions manually to /var/lib/odoo/, but I get the following error when creating or duplicating a database:

Database creation error: relation "ir_model" does not exist LINE 1: SELECT * FROM ir_model WHERE state='manual' ^ 

I find some results online but no real answer online – anyone had this error?

Dear genofire, yes, I agree and I prefer too not use old legacy packages.

Maybe new Odoo 14 will correct all problems, can you please update this package to the next version?

sorry @krouziciorel , but install with pip legacy version is a no go. I really hope that this package use venv / virtualenv - where i am fine with pip.

I also had to install python-wheel to get this package to install. Seems it was missed as a dependency?

Everything is fine now, I tried both options:

1.

commands:

    sudo pacman -Rdd python-werkzeug

    sudo pip3 install libsass

    sudo pip3 install Werkzeug == 0.15.0

and after starting Postgresql server and command

    python /usr/bin/odoo -r odoo -r odoo -w 123456 -i base

I can log in. The only problem is that I need to re-create the database after I leave the odoo service, because I can't login with my pre-created e-mail and password. However, this is handled by davispuh:

2.

• The /var/lib/odoo directory does not exist, so I will create it:

  mkdir -p /var/lib/odoo
  

and follow davispuh instructions, just uninstall existing python-werkzeug using pip3 and install older version 0.16.1 using AUR archive.

Now just run it:

    sudo systemctl start postgresql.service

    sudo systemctl start odoo.service

and everything works fine, if I create a new database and user with e-mail and password, everything is fine after both services and reload.

Thank you very much for your help, ideally when the next version of Odoo will be able to work with python-werkzeug 1.0+.

By the way, after playing with the above packages I cannot run pgadmin4, I get the message:

    Python path: "/usr/lib/python3.8:/usr/lib/python3.8/lib-dynload:/usr/lib/python3.8/site-packages"
    Python Home: "/usr/lib/python3.8"
    Webapp path: "/usr/lib/pgadmin4/web/pgAdmin4.py"
    "Failed to launch application server, server thread exiting."
    qt.qpa.xcb: QXcbConnection: XCB Error: 3 (BadWindow), Sequence: 610,      Resource id: 13112968, Major Code: 40 (TranslateCoords), Minor Code: 0

here it will run using:

    sudo python3 /usr/lib/pgadmin4/web/pgAdmin4.py

and then I can launch the web interface at

    http://127.0.0.1:5050/

Maybe you also need to fix

sudo chown -R odoo:odoo /var/lib/odoo
sudo chmod -R ug+rwX /var/lib/odoo

I actually got it working very easily. Basically I just downgraded python-werkzeug like this

$ sudo pacman -U https://archive.archlinux.org/packages/p/python-werkzeug/python-werkzeug-0.16.1-1-any.pkg.tar.zst

And that's it, now it works for me. Proper fix would be add python-werkzeug-0.16 to AUR and then make this package to depend on it.

As for why it doesn't work for you guys is because most likly you've wrong permissions on those python folders. Try fixing with

$ sudo chown -R root:root /usr/lib/python3.8/site-packages
$ sudo chmod -R a+rX /usr/lib/python3.8/site-packages

OK, so I was able to make Odoo run on a clean install of Arch now, by running it manually, instead of using systemctl. My steps where like this:

sudo pacman -Rdd python-werkzeug

sudo pip3 install libsass

sudo pip3 install Werkzeug==0.16.0

python /usr/bin/odoo -r odoo -d odoo -w test -i base

(The "-i base" is only used the first time to initialise the database, the -r is the database user and -d is the name of the database. -w is the password of the database user).

I will continue to see if I can figure out why the service gives a "500 Internal server error", but at least we have a workaround - which was my 1st priority right now. Using 'screen' or 'tmux' etc. should make it convenient to run it as this.

--- I do however understand that this is not what we all want, and will continue to investigate ---

If you find a -real- solution to the service not running correctly, please let me know, so I can make a fix in the package build.

Cheers

I report the same bug as davispuh, it is currently not possible to use python-werkzeug 1.0.

I tried to install an older version: pip3 install werkzeug == 0.16.0

Now everything seems OK, sudo systemctl status odoo.service:

● odoo.service - Advanced OpenSource ERP and CRM server Loaded: loaded (/usr/lib/systemd/system/odo.service; disabled; vendor preset: disabled) Active: active (running) since Sun 2020-03-29 10:41:39 CEST; 2s ago Process: 2359 ExecStartPre = / usr / bin / install -d -m755 -o oooo -g oooo / run / oooo (code = exited, status = 0 / SUCCESS) PID Main: 2360 (odoo) Tasks: 4 (limit: 4515) Memory: 56.0M CGroup: /system.slice/odoo.service 602365 / usr / bin / python / usr / bin / odoo -c /etc/odoo/odoo.conf -pidfile = / run / odoo / odoo.pid

Mar 29 10:41:38 arch systemd [1]: Starting the OpenSource ERP and CRM server ... Mar 29 10:41:38 arch systemd [1]: Started Advanced OpenSource ERP and CRM server Mar 29 10:41:40 arch Odoo [2360]: 2020-03-29 08: 41: 40.097 2360 INFO? Odoo: Odoo version 13.0-20200321 Mar 29 10:41:40 arch Odoo [2360]: 2020-03-29 08: 41: 40.097 2360 INFO? odoo: Using configuration file at /etc/odoo/odoo.conf Mar 29 10:41:40 arch Odoo [2360]: 2020-03-29 08: 41: 40.097 2360 INFO? odoo: addons paths: ['/usr/lib/python3.8/site-packages/>' Mar 29 10:41:40 arch Odoo [2360]: 2020-03-29 08: 41: 40,098 2360 INFO? odoo: database: odoo @default: default Mar 29 10:41:40 arch Odoo [2360]: 2020-03-29 08: 41: 40,382 2360 INFO? odoo.addons.base.models.ir_actions_report Mar 29 10:41:40 arch Odoo [2360]: 2020-03-29 08: 41: 40.605 2360 INFO? odoo.service.server: HTTP service (werkzeug) running on>

After you try to start a Web login:

http://localhost:8068/

I'm getting 500 Internal Server Error

and via sudo systemctl status odoo.service:

● odoo.service - Advanced OpenSource ERP and CRM server Loaded: loaded (/usr/lib/systemd/system/odo.service; disabled; vendor preset: disabled) Active: active (running) since Sun 2020-03-29 10:41:39 CEST; 14s ago Process: 2359 ExecStartPre = / usr / bin / install -d -m755 -o oooo -g oooo / run / oooo (code = exited, status = 0 / SUCCESS) PID Main: 2360 (odoo) Tasks: 4 (limit: 4515) Memory: 58.6M CGroup: /system.slice/odoo.service 602365 / usr / bin / python / usr / bin / odoo -c /etc/odoo/odoo.conf -pidfile = / run / odoo / odoo.pid

Mar 29 10:41:50 arch Odoo [2360]: value = self.fget (obj) Mar 29 10:41:50 arch Odoo [2360]: File "/usr/lib/python3.8/site-packages/odoo/http.py", line 1263, in session_store Mar 29 10:41:50 arch Odoo [2360]: path = odoo.tools.config.session_dir Mar 29 10:41:50 arch Odoo [2360]: File "/usr/lib/python3.8/site-packages/odoo/tools/config.py", line 685, in session_dir Mar 29 10:41:50 Arch Odoo [2360]: os.makedirs (d, 0o700) Mar 29 10:41:50 arch Odoo [2360]: File "/usr/lib/python3.8/os.py", line 213, in makedirs Mar 29 10:41:50 arch Odoo [2360]: makedirs (head, exist_ok = exist_ok) Mar 29 10:41:50 arch Odoo [2360]: File "/usr/lib/python3.8/os.py", line 223, in makedirs Mar 29 10:41:50 arch Odoo [2360]: mkdir (name, mode) Mar 29 10:41:50 arch Odoo [2360]: PermissionError: [Errno 13] Operation refused: '/ var / lib / odoo' - - -

I see just [Errno 13].

Ubuntu also has problems: https://www.odoo.com/forum/help-1/question/no-module-named-werkzeug-contrib-164288

I haven't figured out the solution yet.

Hi @davispuh, I will look at this in the morning (it's nighttime here now). In the meantime, I guess installing the module using pip might be a temporary solution?

Thanks for the heads up.

Currently it fails with

  File "/usr/bin/odoo", line 5, in <module>
    import odoo
  File "/usr/lib/python3.8/site-packages/odoo/__init__.py", line 117, in <module>
    from . import service
  File "/usr/lib/python3.8/site-packages/odoo/service/__init__.py", line 7, in <module>
    from . import wsgi_server
  File "/usr/lib/python3.8/site-packages/odoo/service/wsgi_server.py", line 25, in <module>
    import werkzeug.contrib.fixers
ModuleNotFoundError: No module named 'werkzeug.contrib'

Because python-werkzeug is 1.0 which isn't compatible. See https://github.com/odoo/odoo/issues/45914

Hi @Vallinger - the package is now updated to version 20200321. Sorry for the late reply.

It is now compatible with Python 3.8 - https://github.com/odoo/odoo/pull/40355 Install a newer nightly by changing the subversion in the PKGBUILD to a new one: 'yay -S --mflags "--skipchecksums" --editmenu odoo' in the PKGBUILD change the value of _pkgsubversion to a new one - https://nightly.odoo.com/13.0/nightly/src/ - e.g., 20200226.

In my case I had to install the [python2-wheel] package for a successful installation. Maybe this must be added as a build dependency?

Not compatible with Python 3.8? https://github.com/odoo/odoo/issues/40232

PR to fix https://github.com/odoo/odoo/pull/40355

Package is updated, should work now

1. I suggest using sassc package instead of python-libsass
2. Download link is broken
3. It is better to use wkhtmltopdf-static, package version do not display documents header and footer
4. Old odoo 12 version

I had to run the commands from @lonaowna's comment on 2018-06-05 to get odoo working here. Should the relevant parts of odoo.install be in post_install rather than post_upgrade?

@golodhrim thanks, fixed.

If anyone has trouble: don't forget to rebuild your Python AUR packages manually. For odoo, these are python-pypdf2 python-num2words python-ebaysdk python-ofxparse ptyhon-stdnum python-vatnumber.

should be updated to 20180806 at least, as there are incompatibilities with pzthon 3.7

@lonaowna, thanks! It works now! :)

@bOlaE, sorry: I messed up something in the last update. It should be fixed now.

You don't need to reinstall, you can run this as root:

mkdir -p /var/lib/odoo
chown -R odoo /var/lib/odoo

Hi Guys, I have just installed this package but there is nothing in localhost:8069, anyone can help me?

@bidosessi, thanks!

I've updated the package to 11.0. If I've missed any dependencies or anyone wants to be co-maintainer, please let me know.

@Ionaowna I've disowned the package. My client has chosen to move away from odoo, and you just reminded me that this issue here was pending. Feel free to take over.

Here is a working PKGBUILD for 11.0: https://gist.github.com/slokhorst/19e3c7bfda1c49070abcd0b1c9729ca2

I have created AUR packages for the missing Python packages (python-ebaysdk, python-psycogreen, python-vatnumber).

@bidossessi, if you do not want to maintain version 11.0, please move this one to 'odoo10', as mentioned below.

@satriani Do you have the PKGBUILD for 11? It sounds like you have. Did you need to install one of those packages?

• python-ebaysdk
• python-ldap
• python-psycogreen
• python-pychart
• python-vatnumber

@bidossessi. Can you give us an update on your plans with this outdated package? Could you move it to a new package 'odoo10'? This would make it possible for someone else to take over and update to 11.