Hello All,
I got an error while creating a DB, the error given below.
ProgrammingError: permission denied to create database
can anyone hel me Thanks.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Księgowość
- Zapasy
- PoS
- Project
- MRP
To pytanie dostało ostrzeżenie
11
Odpowiedzi
73051
Widoki
You should do following steps:
1. ssh to your server where odoo is installed
2. sudo su postgres (the idea is to switch to postgresql user)
3. psql
4. ALTER USER odoo WITH CREATEDB;
5. Go back to web page and try create db once again
This error occur when you are try to create a DB from a user that connect Postgres that user's role is not set to be privilege, that has the right to create DB.
solution:
1. set the user that trying to connect to be superuser
psql > Alter user YOURUSER with SUPERUSER;
2. User PgAdmin to set privilege
file:///home/minhtech/Pictures/guiOdoo.png
permission also. Give your postgres user permission to create database
1 sudo su postgres
2 psql
3 ALTER USER odoo WITH CREATEDB;
4 \q
5 logout
6 restart server
Please try using Master Password: admin
I am trying with the master password admin, getting same error. Can you please help me?
Not at a Current Master password, please try to admin as default password..
To change master password, edit
/etc/openerp/openerp-server.conf
Set value for
admin_passwd
root@dev1:~# cat /etc/openerp/openerp-server.conf
[options]
; This is the password that allows database operations:
admin_passwd = oQoADDDLbw124
db_host = False
db_port = False
db_user = openerp
db_password = False
root@dev1:~#
Your postgresql user that you're running Odoo with doesn't have database creation permission.
ALTER USER odoo_db_user WITH option CREATEDB;
Please check your log file and post it here.
You will need to create a postgres user: by default the only user is postgres, and Odoo forbids connecting as postgres.
on Linux, use your distribution's package, then create a postgres user named like your login
Because postgres only allow the login if you have the same distribution user.
check the user permission also. Give your postgres user permission to create database with ALTER.
To do this
sudo -i -u postgres
psql
create user your_user_name;
alter role your_user_name with superuser createdb;
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
1
lip 19
|
19486 | ||
|
1
mar 15
|
3997 | ||
|
1
cze 25
|
5344 | ||
|
2
gru 24
|
5907 | ||
|
0
lut 23
|
3838 |
It will be very hard to tell what happened unless you give a lot more details. Which environment was used, which odoo, how was it installed.... etc. etc.
HI do you got solution for this problem?. I am getting same error, can you please help me?
you have the uncomment the admin password in your config file.