Install Odoo from docker

[Pava]

Is it possible to get working Odoo https://hub.docker.com/_/odoo in Unraid ? This is the best productivity aplication, but no way to get working.  I try to install but no UI. Please if somebody know how I can get working Odoo.

[Thomasg]

Just open the console (ssh in or use from the GUI the >_ button in the top) and run this:

 

docker run -d -e POSTGRES_USER=odoo -e POSTGRES_PASSWORD=odoo -e POSTGRES_DB=postgres --name db postgres:13

 

This will install your database and set the username and password. Save the master password here.

 

Then run:

 

docker run -v odoo-data:/var/lib/odoo -d -p 8069:8069 --name odoo --link db:db -t odoo

 

 

This will create the instance with persistent storage. 

 

Then connect to you servers ip with port 8069.   Something like 192.168.1.22:8069   This will get you to the first login page where you create the database and have the option to load demo data to play around with. 

 

Used the sauce from : https://registry.hub.docker.com/_/odoo/

 

Not I would advice to look into backups of the database, just in case.   Here is a good walkthrough. 

 

 

 

 

 

 

 

[firebat45]

I ran the commands you listed, Thomasg.  Finally got Odoo up and running, which is great.

 

I can't find the persistent file locations though.  From what little I know it looks like maybe the Odoo volume is listed backwards?  

[Richamc01]

I cannot get this working for the life of me. Every time I save the docker template and check the logs, I get:

grep: /etc/odoo/odoo.conf: No such file or directory

 

When I attempt to open the webui, I see this in the logs:

2023-03-20 20:04:50,346 1 ERROR ? odoo.modules.loading: Database odoo not initialized, you can force it with `-i base` 
2023-03-20 20:04:50,347 1 INFO ? odoo.modules.registry: Registry loaded in 0.178s 
2023-03-20 20:04:50,350 1 ERROR odoo odoo.http: Exception during request handling. 
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1584, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 134, in retrying
    result = func()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1598, in _serve_ir_http
    ir_http = self.registry['ir.http']
  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 190, in __getitem__
    return self.models[model_name]
KeyError: 'ir.http'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1990, in __call__
    response = request._serve_db()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1590, in _serve_db
    exc.error_response = self.registry['ir.http']._handle_error(exc)
  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 190, in __getitem__
    return self.models[model_name]
KeyError: 'ir.http'
2023-03-20 20:04:50,356 1 INFO odoo werkzeug: 192.168.89.249 - - [20/Mar/2023 20:04:50] "GET / HTTP/1.1" 500 - 8 0.195 0.086
2023-03-20 20:04:50,604 1 ERROR odoo odoo.http: Exception during request handling. 
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1584, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 134, in retrying
    result = func()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1598, in _serve_ir_http
    ir_http = self.registry['ir.http']
  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 190, in __getitem__
    return self.models[model_name]
KeyError: 'ir.http'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1990, in __call__
    response = request._serve_db()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1590, in _serve_db
    exc.error_response = self.registry['ir.http']._handle_error(exc)
  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 190, in __getitem__
    return self.models[model_name]
KeyError: 'ir.http'
2023-03-20 20:04:50,605 1 INFO odoo werkzeug: 192.168.89.249 - - [20/Mar/2023 20:04:50] "GET /favicon.ico HTTP/1.1" 500 - 2 0.012 0.037
2023-03-20 20:04:56,372 1 ERROR odoo odoo.sql_db: bad query: 
            SELECT latest_version
            FROM ir_module_module
             WHERE name='base'
        
ERROR: relation "ir_module_module" does not exist
LINE 3:             FROM ir_module_module
                         ^
 
2023-03-20 20:04:56,373 1 WARNING odoo odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo. 
2023-03-20 20:04:58,377 1 ERROR odoo odoo.sql_db: bad query: 
            SELECT latest_version
            FROM ir_module_module
             WHERE name='base'
        
ERROR: relation "ir_module_module" does not exist
LINE 3:             FROM ir_module_module
                         ^
 
2023-03-20 20:04:58,378 1 WARNING odoo odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo. 

 

I created a config file in the appdata folder (which is set in the docker template as /etc/odoo) and I still have the same problem.

 

Would you mind sharing some screenshots of the setup that you were able to get working? 

[ryoko227]

I don't know if this "the right way", but I got to the odoo webUI doing the following. Hopefully it is helpful to you or someone else, and it's here for me when I need it later ^^;

 

Reference per @Thomasg - "Used the sauce from : https://registry.hub.docker.com/_/odoo/"

 

 

Firstly, install PostgreSQL 15 via your unRAID Apps and set as follows...

 

Name  - db    <---- per the reference "The alias of the container running Postgres must be db for Odoo to be able to connect to the Postgres server."

POSTGRES_PASSWORD: Set a password you think is strong, I used a 16 chars alphanumeric from a rnd generator
POSTGRES_USER: odoo
POSTGRES_DB: postgres

 

Next, install the Odoo15 from your unRAID Apps and set as follows...

 

Addons: /mnt/cache/appdata/odoo/extra-addons  <--changed these to /mnt/cache/appdata/   to hopefully keep it all in an easy to find/use space.
Configuration: /mnt/cache/appdata/odoo/config  <--changed these to /mnt/cache/appdata/    to hopefully keep it all in an easy to find/use space.
DB Username: odoo
Database Password: Previously entered strong password from above
Database URL: your unRAID server IP

 

And that seems to have worked for me. Hope it helps o/

[wipzcream]

Dear All

 

Any one know How to config Swag reverse proxy with Odoo 15. I want to access from outside 

 

Best Regards

[NeoSys]

On 3/28/2023 at 3:12 AM, ryoko227 said:

I don't know if this "the right way", but I got to the odoo webUI doing the following. Hopefully it is helpful to you or someone else, and it's here for me when I need it later ^^;

 

Reference per @Thomasg - "Used the sauce from : https://registry.hub.docker.com/_/odoo/"

 

 

Firstly, install PostgreSQL 15 via your unRAID Apps and set as follows...

 

Name  - db    <---- per the reference "The alias of the container running Postgres must be db for Odoo to be able to connect to the Postgres server."

POSTGRES_PASSWORD: Set a password you think is strong, I used a 16 chars alphanumeric from a rnd generator
POSTGRES_USER: odoo
POSTGRES_DB: postgres

 

Next, install the Odoo15 from your unRAID Apps and set as follows...

 

Addons: /mnt/cache/appdata/odoo/extra-addons  <--changed these to /mnt/cache/appdata/   to hopefully keep it all in an easy to find/use space.
Configuration: /mnt/cache/appdata/odoo/config  <--changed these to /mnt/cache/appdata/    to hopefully keep it all in an easy to find/use space.
DB Username: odoo
Database Password: Previously entered strong password from above
Database URL: your unRAID server IP

 

And that seems to have worked for me. Hope it helps o/

 

For the life of me I just do not understand what I am doing wrong. I followed all steps but no GUI logs say "grep: /etc/odoo/odoo.conf: No such file or directory"

 

Im I supposed to somehting additional from "Reference per @Thomasg - "Used the sauce from : https://registry.hub.docker.com/_/odoo/"

 

Please any help would really be welcomed I am really really lost in the weeds here.

 

Thanks,

 

Vic

[PixelPrint]

I also tried with odoo and it's probably the hardest app to selfhost that i ever tried. I once managed to let it work, but then after an upgrade it broke and i never managed to let it work again. I wonder if it's intentional to let people to subscribe to the cloud service (which is completely unaffordable for small business like me)

[NeoSys]

4 hours ago, PixelPrint said:

I also tried with odoo and it's probably the hardest app to selfhost that i ever tried. I once managed to let it work, but then after an upgrade it broke and i never managed to let it work again. I wonder if it's intentional to let people to subscribe to the cloud service (which is completely unaffordable for small business like me)

It is so so fustrating becuase it is such an amazing software. I hope someone comes up on this thread that can walk us through it.

[carotna]

On 6/12/2023 at 1:35 PM, wipzcream said:

Dear All

 

Any one know How to config Swag reverse proxy with Odoo 15. I want to access from outside 

 

Best Regards

 

Hi, have you managed to get it working with Swag? I have it to odoo.mydomain.com, I get the login screen, but after I login I get a white screen with nothing on it.

[kydsid]

On 9/15/2023 at 9:33 PM, carotna said:

 

Hi, have you managed to get it working with Swag? I have it to odoo.mydomain.com, I get the login screen, but after I login I get a white screen with nothing on it.

Is the login in the center or off to the left without images.  I got it up and running with the CA image.  But then it stopped responding correctly.  Login came up, left justified in screen, then just a white screen.  Little digging found this may happen due to non-persistent storage (storage within the container, instead of to a share) when an app/component in Odoo restarts. I know the template on CA has storage locations, but the docker for me never put any data there.  

 

I used the above commands in root terminal and have a new instance up and running.  Waiting to see if it is stable.  I am not a professional just have a bit of ability so shot in the dark.