Odoo Internal Server Error

hagso · 2025-10-20 17:33:23

500 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.

I've read all documentation to install odoo: https://wiki.archlinux.org/title/Odoo. I've done also for postgresql which is included in the instalation.

From all AUR packages I've only been able to install odoo18-nightly: https://aur.archlinux.org/packages/odoo18-nightly.

As I start the odoo service and I check the systemctl status is everything ok:

odoo.service - Odoo Open Source ERP and CRM version 18
     Loaded: loaded (/etc/systemd/system/odoo.service; enabled; preset: disabled)
     Active: active (running) since Mon 2025-10-20 19:25:34 CEST; 1s ago
 Invocation: 85c3462f1000462082f3b0d9b99d43e3
...

I'm accesing to a different computer which is on the same network of mine: 192. ... :8069. I know it is the right direction because when I stop the service there's no error, it just doesn't find any page.

Where do I can see an error log? Does someone had the same issue?

Lone_Wolf · 2025-10-21 10:03:45

I know nothing about odoo , but can you access it locally through http://localhost:8069 on the system the server runs on ?

twelveeighty · 2025-10-21 14:33:00

If Odoo ships with a systemd service, I assume the logs are echoed to your journal, or otherwise check the installed files. Error 500 most likely is either a DB connection issue, or some other internal fault, you would not expect 500 as a client connection error (those are typically in the 400s).

What exactly do you mean by "I've only been able to install odoo18-nightly"? What happened when you install the recommended version? It's generally not wise to install a nightly build, unless you are doing development against it. Nightly builds are buggy by definition, since contain the latest (sometimes untested) changes committed by devs.

hagso · 2025-10-21 14:52:08

Odoo is a very problematic package with it's dependences. I really don't want to install the nightly version but the official one which is odo-venv, the one referenced in archwiki guide of instalation but some python packages are not avaliable to download, are deprecated versions or the only version posible to download is not compatible with the rest of instalation so it fails. I've really tried to do it, even installing those dependences by myself but that haven't been possible.

I've followed step by step the installation for PostgreSQL package and it's configuration for odoo.

Guess that I'll continue searching on journal.

twelveeighty · 2025-10-21 17:16:15

Some older Google search hits mention /var/log/odoo/odoo-server.log. Is there a log file there?

hagso · 2025-10-23 13:23:07

Somehow I managed to finally get a error.:

Odoo Server 18.0-20251022:odoo:ERROR:odoo.sql_db:bad query: b"\n            SELECT latest_version\n            FROM ir_module_module\n             WHERE name='base'\n        "
                                  ERROR: no existe la relación «ir_module_module»
                                  LÍNEA 3:             FROM ir_module_module
Odoo Server 18.0-20251022:odoo:ERROR:odoo.http:Exception during request handling.
                                   Traceback (most recent call last):
                                     File "/var/lib/odoo18/venv/lib/python3.12/site-packages/odoo/http.py", line 2576, in __call__
                                       response = request._serve_db()
                                                  ^^^^^^^^^^^^^^^^^^^
                                     File "/var/lib/odoo18/venv/lib/python3.12/site-packages/odoo/http.py", line 2084, in _serve_db
                                       rule, args = self.registry['ir.http']._match(self.httprequest.path)
                                                    ~~~~~~~~~~~~~^^^^^^^^^^^
                                     File "/var/lib/odoo18/venv/lib/python3.12/site-packages/odoo/modules/registry.py", line 244, in __getitem__
                                       return self.models[model_name]
                                              ~~~~~~~~~~~^^^^^^^^^^^^
                                   KeyError: 'ir.http'

Ok what is failling is it the conexion from odoo to the database i think. Could be some user or password failure? I've given to the odoo user named in the odoo config file the same, put the same password. Maybe I should erase the database and make another? But I've already installed it few times and always put the same password and user so what am I doing wrong? I'm accesing to the database by graphical desktop on pgadmin outside the server so, may be a communication problem. Steps followed:

#After installing postgresql and odoo:
sudo su postgres
createdb odoo
createuser odoo --interactive --pwprompt
#sudo: y
#just for the forum psswd: odoo

Do I need to check some file?

Last edited by hagso (2025-10-23 14:30:18)

Muflone · 2025-10-23 14:28:59

Hi

I develop daily on Odoo Enterprise and my biggest recommendation is to use docker for the development or venv + older Python versions for it.

Odoo versions cannot always follow the latest Python version available on Arch, the same for the additional Python packages.

At the actual state it seems the odoo-venv is broken during the install of lxml.

odoo18-nightly seems to pin the Python version 3.12

Muflone · 2025-10-23 14:33:18

hagso wrote:

Ok what is failling is it the conexion from odoo to the database i think. Could be some user or password failure? I've given to the odoo user named in the odoo config file the same, put the same password.

Is your odoo user allowed to create new tables in the database?

hagso wrote:

Maybe I should erase the database and make another? But I've already installed it few times and always put the same password and user so what am I doing wrong?

Possibly your database restore is incomplete for the previous attempts, make sure to create a new database from the UI

hagso · 2025-10-23 14:43:53

Muflone wrote:

Hi
I develop daily on Odoo Enterprise and my biggest recommendation is to use docker for the development or venv + older Python versions for it.
Odoo versions cannot always follow the latest Python version available on Arch, the same for the additional Python packages.
At the actual state it seems the odoo-venv is broken during the install of lxml.
odoo18-nightly seems to pin the Python version 3.12

Tanks for the advice but I come from there. I was on alpine with the docker and I couldn't add my custom packages. I got errors every time i was to refresh files to add and sometimes a version from before was loaded instead of the new. The email function did not work well. Would really like to avoid it and I hoped to be able to execute natively so I had less problems but apparently not.

What mean that Python 3.12 version is pinned? Is it because is a problematic version and the errors I have cannot be solved? Do you have some github repositories for odoo docker compose so I don't have to touch nothing? Just if don't achive this

Last edited by hagso (2025-10-23 14:47:04)

Muflone · 2025-10-23 15:15:07

Arch Linux uses Python 3.13, so if you install odoo18-nightly you'll have to install also Python 3.12, however, this is the bare minimum set to start a Odoo instance with Docker:

services:
  app:
    image: odoo:19.0-20251021
    restart: 'no'
    ports:
      - "8069:8069"
    environment:
      - "ODOO_DATABASE_HOST=db"
      - "ODOO_DATABASE_PORT=5432"
      - "ODOO_DATABASE_USER=odoo"
      - "ODOO_DATABASE_PASSWORD=odoo"
    volumes:
      - ./data:/opt/odoo/data
      - ./logs:/opt/odoo/logs

  db:
     image: postgres:15.3
     restart: 'no'
     volumes:
       - ./database:/var/lib/postgresql/data
     environment:
       - "POSTGRES_USER=odoo"
       - "POSTGRES_PASSWORD=odoo"
       - "POSTGRES_DB=postgres"

Then start the stack with docker-compose up -d and open the webpage http://localhost:8069

There you can setup your new database and credentials

Muflone · 2025-10-23 15:27:54

As for the installed Odoo I believe the wiki instructions are wrong (or incomplete, missing the odoo-bin populate step).

If you create an empty database called odoo when odoo starts it will try to use it but such database will lack all the needed tables into it.

for this reason my previous docker configuration will create a new empty database called postgres, in order to allow you to create your odoo (or whatever you prefer) database from odoo itself, which will take care of creating all the needed stuff into the new db.

If you want to keep Odoo installed into your system make sure to not create a new database called odoo, or delete it if exists.

Last edited by Muflone (2025-10-23 15:41:48)

Muflone · 2025-10-23 19:22:46

I've updated the Odoo wiki page removing the createdb odoo command, letting Odoo to create its db and the tables accordingly

https://wiki.archlinux.org/title/Odoo

If you want to use the existing db you could execute instead:

sudo -u odoo /var/lib/odoo/venv/bin/odoo --config /etc/odoo/odoo.conf -i base --stop-after-init

Arch Linux

#1 2025-10-20 17:33:23

Odoo Internal Server Error

#2 2025-10-21 10:03:45

Re: Odoo Internal Server Error

#3 2025-10-21 14:33:00

Re: Odoo Internal Server Error

#4 2025-10-21 14:52:08

Re: Odoo Internal Server Error

#5 2025-10-21 17:16:15

Re: Odoo Internal Server Error

#6 2025-10-23 13:23:07

Re: Odoo Internal Server Error

#7 2025-10-23 14:28:59

Re: Odoo Internal Server Error

#8 2025-10-23 14:33:18

Re: Odoo Internal Server Error

#9 2025-10-23 14:43:53

Re: Odoo Internal Server Error

#10 2025-10-23 15:15:07

Re: Odoo Internal Server Error

#11 2025-10-23 15:27:54

Re: Odoo Internal Server Error

#12 2025-10-23 19:22:46

Re: Odoo Internal Server Error

Board footer