Odoo Help

0

1
11 Answers
5
Vasili Pascal Moldavia
5/24/16, 6:03 AM

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

2

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

1
Ronak Baxi (rba) India
9/29/14, 8:42 AM

Please try using Master Password: admin

1 Comment
samba India
4/17/15, 3:04 AM

I am trying with the master password admin, getting same error. Can you please help me?

0
Avatar

Brett Lehrer United States

--Brett Lehrer--

1382
| 5 5 10
Milwaukee, United States
--Brett Lehrer--
Director of IT and open source enthusiast.
Brett Lehrer United States
4/17/15, 9:30 AM

Your postgresql user that you're running Odoo with doesn't have database creation permission.

ALTER USER odoo_db_user WITH option CREATEDB;
0
Avatar

Grover Menacho Bolivia

--Grover Menacho--
WebVision Enterprise Systems
https://www.linkedin.com/in/hmen89/
3005
| 7 8 10
La Paz, Bolivia
--Grover Menacho--

Odoo Developer

Grover Menacho Bolivia
4/6/16, 12:15 PM

Please check your log file and post it here.

0
CatsandDogs India
4/6/16, 7:17 AM

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:~# 

0
Harun Ur Rashid Bangladesh
1/28/17, 1:23 AM

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;
Ask a Question
Writer
Keep Informed
4 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register
Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now