odoo-13-docker-compose icon indicating copy to clipboard operation
odoo-13-docker-compose copied to clipboard

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

Open lalebarde opened this issue 2 years ago • 0 comments

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?

lalebarde avatar Sep 19 '22 11:09 lalebarde