odoo | Permission denied to create database ??

MagnumPL

Cadet
Joined
Oct 27, 2021
Messages
6
Freshly installed app

I can't generate the Database, and when I want to log in to the container, I can't use the nano & vi command
2023-04-23 20:48:42.193829+00:00ERROR: couldn't write the config file
2023-04-23 20:48:42.209985+00:002023-04-23 20:48:42,209 1 INFO None odoo.service.db: Create database `odoo`.
2023-04-23 20:48:42.215706+00:002023-04-23 20:48:42,215 1 ERROR None odoo.sql_db: bad query: CREATE DATABASE "odoo" ENCODING 'unicode' LC_COLLATE 'C' TEMPLATE "template0"
2023-04-23 20:48:42.215749+00:00ERROR: permission denied to create database
2023-04-23 20:48:42.215759+00:002023-04-23T20:48:42.215759227Z
2023-04-23 20:48:42.216331+00:002023-04-23 20:48:42,215 1 ERROR None odoo.http: permission denied to create database
2023-04-23 20:48:42.216346+00:002023-04-23T20:48:42.216346295Z
2023-04-23 20:48:42.216354+00:00Traceback (most recent call last):
2023-04-23 20:48:42.216371+00:00File "/usr/lib/python3/dist-packages/odoo/http.py", line 141, in dispatch_rpc
2023-04-23 20:48:42.216379+00:00result = dispatch(method, params)
2023-04-23 20:48:42.216389+00:00File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 462, in dispatch
2023-04-23 20:48:42.216404+00:00return g[exp_method_name](*params)
2023-04-23 20:48:42.216412+00:00File "<decorator-gen-14>", line 2, in exp_create_database
2023-04-23 20:48:42.216420+00:00File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 41, in if_db_mgt_enabled
2023-04-23 20:48:42.216428+00:00return method(self, *args, **kwargs)
2023-04-23 20:48:42.216442+00:00File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 130, in exp_create_database
2023-04-23 20:48:42.216450+00:00_create_empty_database(db_name)
2023-04-23 20:48:42.216458+00:00File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 112, in _create_empty_database
2023-04-23 20:48:42.216468+00:00cr.execute(
2023-04-23 20:48:42.216483+00:00File "<decorator-gen-3>", line 2, in execute
2023-04-23 20:48:42.216491+00:00File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 90, in check
2023-04-23 20:48:42.216499+00:00return f(self, *args, **kwargs)
2023-04-23 20:48:42.216507+00:00File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 313, in execute
2023-04-23 20:48:42.216519+00:00res = self._obj.execute(query, params)
2023-04-23 20:48:42.216527+00:00psycopg2.errors.InsufficientPrivilege: permission denied to create database
2023-04-23 20:48:42.216535+00:002023-04-23T20:48:42.216535362Z
 

NugentS

MVP
Joined
Apr 16, 2020
Messages
2,947
Don't you think a little more information might help?

I can tell you - it looks like a permissions issue
 

MagnumPL

Cadet
Joined
Oct 27, 2021
Messages
6
I will gladly provide all logs. only you can write what would be most helpful
 

aikidd

Cadet
Joined
Nov 16, 2012
Messages
1
How do you grant permission to the webUI to create the database after installation?

Failed to work for me today after a fresh install.
"Database creation error: permission denied to create database"

odoo 15.0_13.0.0Up to date
Used Ports:8069\TCP, 8072\TCP, 8071\TCP
Status:ACTIVE
Pods:5
Deployments:2
Statefulsets: 0
Catalog: Truecharts
Train: Stable
Item Name:odoo
 

sfatula

Guru
Joined
Jul 5, 2022
Messages
608
Since it's Truecharts, I would suggest asking on their support channel, on discord.
 
Top