Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
course odoo database community gettingstarted
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
course odoo database community gettingstarted
About this forum
  1. Getting Started
  2. Forum

ERROR: relation "ir_module_module" does not exist at character 53

Subscribe

Get notified when there's activity on this post

This question has been flagged
databasedockerdocker-compose
1 Reply
12829 Views
Avatar
lalebarde2

Hi, 

I am trying to test odoo deployment under docker on my testing PC without reverse proxy. After `docker-compose up`, I get the following error: `ERROR: relation "ir_module_module" does not exist at character 53`, and the browser at `https://localhost:8069/` says approximately: `Secure connexion failure - error while connecting to localhost:8069. PR_END_OF_FILE_ERROR`.


The terminal where I have launched `docker-compose up` logs:

db    | PostgreSQL init process complete; ready for start up.
db |
db | 2022-09-11 16:52:28.526 UTC [1] LOG: starting PostgreSQL 14.5 (Debian 14\\.5\\-1\\.pgdg110\\+1\\)\\ on\\ x86_64\\-pc\\-linux\\-gnu,\\ compiled\\ by\\ gcc\\ \\(Debian\\ 10\\.2\\.1\\-6\\)\\ 10\\.2\\.1\\ 20210110,\\ 64\\-bit
db\\ \\ \\ \\ \\|\\ 2022\\-09\\-11\\ 16:52:28\\.526\\ UTC\\ \\[1\\]\\ LOG:\\ \\ listening\\ on\\ IPv4\\ address\\ "0\\.0\\.0\\.0",\\ port\\ 5432
db\\ \\ \\ \\ \\|\\ 2022\\-09\\-11\\ 16:52:28\\.526\\ UTC\\ \\[1\\]\\ LOG:\\ \\ listening\\ on\\ IPv6\\ address\\ "::",\\ port\\ 5432
db\\ \\ \\ \\ \\|\\ 2022\\-09\\-11\\ 16:52:28\\.529\\ UTC\\ \\[1\\]\\ LOG:\\ \\ listening\\ on\\ Unix\\ socket\\ "/var/run/postgresql/\\.s\\.PGSQL\\.5432"
db\\ \\ \\ \\ \\|\\ 2022\\-09\\-11\\ 16:52:28\\.534\\ UTC\\ \\[62\\]\\ LOG:\\ \\ database\\ system\\ was\\ shut\\ down\\ at\\ 2022\\-09\\-11\\ 16:52:28\\ UTC
db\\ \\ \\ \\ \\|\\ 2022\\-09\\-11\\ 16:52:28\\.541\\ UTC\\ \\[1\\]\\ LOG:\\ \\ database\\ system\\ is\\ ready\\ to\\ accept\\ connections
db\\ \\ \\ \\ \\|\\ 2022\\-09\\-11\\ 16:53:35\\.060\\ UTC\\ \\[76\\]\\ ERROR:\\ \\ relation\\ "ir_module_module"\\ does\\ not\\ exist\\ at\\ character\\ 53
db\\ \\ \\ \\ \\|\\ 2022\\-09\\-11\\ 16:53:35\\.060\\ UTC\\ \\[76\\]\\ STATEMENT:\\ \\
db\\ \\ \\ \\ \\|\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ SELECT\\ latest_version
db\\ \\ \\ \\ \\|\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ FROM\\ ir_module_module
db\\ \\ \\ \\ \\|\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ WHERE\\ name='base'

There\ is\ something\ interesting\ here, but it has changed nothing to the result for me:


Error about db not initialized may still show up when using volume:
volumes:
- odoo-db-data:/var/lib/postgresql/data/pgdata # removing this volume removes the error
Somehow got it to work by:
docker-compose exec web bash
odoo -i base -d odoo --stop-after-init --db_host=db -r odoo -w odoo
...
re-up using docker-compose

Here is my `docker-compose.yml`:

version: '3.9'
services:
odoo:
container_name: odoo
image: odoo:15.0
volumes:
- ./extra-addons:/opt/odoo/extra-addons
- ./etc:/etc/odoo
- odoo-web-data:/var/lib/odoo
ports:
- "8069:8069"
depends_on:
- db
environment:
- PASSWORD_FILE=/run/secrets/postgresql_password
secrets:
- postgresql_password
restart: always
db:
container_name: db
image: postgres:14
environment:
- POSTGRES_DB=postgres
- POSTGRES_PASSWORD_FILE=/run/secrets/postgresql_password
- POSTGRES_USER=glopibuf
- PGDATA=/var/lib/postgresql/data/pgdata
volumes:
- odoo-db-data:/var/lib/postgresql/data/pgdata
secrets:
- postgresql_password
ports:
- 5432:5432
restart: always
volumes:
odoo-web-data:
odoo-db-data:

secrets:
postgresql_password:
file: odoo_pg_pass

and my `odoo.conf`:

[options]
db_host = db
db_user = glopibuf
db_name = postgres
db_template = template0
db_maxconn = 64
db_filter = ^xxxxxx.*$
db_sslmode = allow
logfile = /var/log/odoo/openerp-server.log
logrotate = True
log-db = False
syslog = False
log-level = warn
interface = localhost
port = 8069
secure = True
proxy_mode = False
addons_path = /opt/odoo/extra-addons,/opt/openerp/odoo/addons,/home/myaddons
timezone = Europe/Paris
secure_cert_file = server.cert
secure_pkey_file = server.pkey
xmlrpcs = False
xmlrpcs_interface = 127.0.0.1
xmlrpcs_port = 8071
xmlrpc = False
xmlrpc_interface = 127.0.0.1
xmlrpc_port = 8069
longpolling_port = 8072
import_partial =
unaccent = False
translate_modules = ['all']
server_wide_modules = None
smtp_server = localhost
smtp_user = False
smtp_password = False
smtp_ssl = False
email_from = "xxx@yyy.com"
smtp_port = 25
workers = 1
max_cron_threads = 1
limit_time_cpu = 60
limit_time_real = 170
limit_memory_soft = 255652815
limit_memory_hard = 1395864371
limit_request = 8196
osv_memory_count_limit = False
osv_memory_age_limit = 1.0
test_enable = False
test_file = False
test_report_directory = False
test_commit = False
without_demo = none

Here is the project tree:

.
├── docker-compose.yml
├── etc
│   └── odoo.conf
├── extra-addons
├── odoo_pg_pass








0
Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

Try to change your docker-composer.yaml file like below

version: '3'
services:
odoo:
image: odoo:15.0 #image of the odoo
env_file: .env #environment file(contains odoo environment)
depends_on:
- postgres
ports:
- "8000:8069" #port mapping
Volumes: #mapping directory
- data:/var/lib/odoo
- ./config:/etc/odoo 
- ./extra-addons:/mnt/extra-addons
postgres: 
image: postgres:13 #postgres image
env_file: .env #environment file(contains postgres environment)
volumes:
- db:/var/lib/postgresql/data/pgdata

volumes:
data:
db:

Try to create an .env file with following configuration.

#psql environment variable
POSTGRES_DB=postgres
POSTGRES_PASSWORD=odoo
POSTGRES_USER=odoo15
PGDATA=/var/lib/postgresql/data/pgdata
#odoo environment variables
HOST=postgres
USER=odoo15
PASSWORD=odoo

For any further reference visit following link

https://www.cybrosys.com/blog/odoo-14-deployment-using-docker

Regards

0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Odoo 18 enterprice in Docker
docker
Avatar
Avatar
Avatar
2
Feb 25
12782
Odoo 18 docker image ? Solved
docker
Avatar
Avatar
Avatar
2
Nov 24
49606
Odoo Community connection to Postgres DB Issues
database connection docker community odoo16
Avatar
Avatar
1
Aug 23
11359
docker odoo build custom module
docker
Avatar
Avatar
1
Jan 23
9063
local installation Solved
database odoo
Avatar
Avatar
1
Oct 24
8538
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now