Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to change database name, database user name and password? #4

Open
lalebarde opened this issue Sep 19, 2022 · 0 comments
Open

How to change database name, database user name and password? #4

lalebarde opened this issue Sep 19, 2022 · 0 comments

Comments

@lalebarde
Copy link

Hi,
Nice work, thank you. For security reasons, I want to change database name, database user name and password, at least the password, but I fail to do so.

I did modify both docker-compose and odoo.conf, cf here.

But I get ERROR: relation "ir_module_module" does not exist at character 53:

odoo-db-1 | Success. You can now start the database server using:
odoo-db-1 |
odoo-db-1 | pg_ctl -D /var/lib/postgresql/data -l logfile start
odoo-db-1 |
odoo-db-1 | waiting for server to start....2022-09-19 10:57:54.843 UTC [52] 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
odoo-db-1 | 2022-09-19 10:57:55.169 UTC [52] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
odoo-db-1 | 2022-09-19 10:57:55.649 UTC [53] LOG: database system was shut down at 2022-09-19 10:57:14 UTC
odoo-db-1 | 2022-09-19 10:57:55.800 UTC [52] LOG: database system is ready to accept connections
odoo-db-1 | done
odoo-db-1 | server started
odoo-db-1 |
odoo-db-1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
odoo-db-1 |
odoo-db-1 | waiting for server to shut down...2022-09-19 10:57:56.200 UTC [52] LOG: received fast shutdown request
odoo-db-1 | .2022-09-19 10:57:56.347 UTC [52] LOG: aborting any active transactions
odoo-db-1 | 2022-09-19 10:57:56.353 UTC [52] LOG: background worker "logical replication launcher" (PID 59) exited with exit code 1
odoo-db-1 | 2022-09-19 10:57:56.355 UTC [54] LOG: shutting down
odoo-db-1 | 2022-09-19 10:57:57.147 UTC [52] LOG: database system is shut down
odoo-db-1 | done
odoo-db-1 | server stopped
odoo-db-1 |
odoo-db-1 | PostgreSQL init process complete; ready for start up.
odoo-db-1 |
odoo-db-1 | 2022-09-19 10:57:57.595 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
odoo-db-1 | 2022-09-19 10:57:57.595 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
odoo-db-1 | 2022-09-19 10:57:57.595 UTC [1] LOG: listening on IPv6 address "::", port 5432
odoo-db-1 | 2022-09-19 10:57:58.068 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
odoo-db-1 | 2022-09-19 10:57:58.226 UTC [64] LOG: database system was shut down at 2022-09-19 10:57:56 UTC
odoo-db-1 | 2022-09-19 10:57:58.227 UTC [65] FATAL: the database system is starting up
odoo-db-1 | 2022-09-19 10:57:58.322 UTC [1] LOG: database system is ready to accept connections
odoo-web-1 | Running as user 'root' is a security risk.
odoo-db-1 | 2022-09-19 10:59:01.661 UTC [84] ERROR: relation "ir_module_module" does not exist at character 53
odoo-db-1 | 2022-09-19 10:59:01.661 UTC [84] STATEMENT:
odoo-db-1 | SELECT latest_version
odoo-db-1 | FROM ir_module_module
odoo-db-1 | WHERE name='base'

Even when I change only the password with ASCII characters such as 123.

What do I miss? How could I achieve this please?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant