Skip to Content
Menu
This question has been flagged
4 Replies
3102 Views

Hello 


I’m new to odoo, using V17 at the moment


after some mistakes like not saving my master password so where safe, reinstalling dodo again and postgresql, I’m getting this error when creating a new database 


as far as I’m concerned this is some kind of error regarding the connection to postgresql


I know pretty much nothing when it comes to programming so I need a little help 



Avatar
Discard
Best Answer

Hello Alejandro, 

In the odoo config file, you mention all the passwords.

For the master password, you can change this parameter : 

admin_passwd = Set a new password here 

For the PostgreSQL password, I think you've added a db_user in the odoo config file in the following parameter.

If you forgot the Postgres user password you can alter the password using this SQL : 

ALTER USER db_user_name WITH PASSWORD 'new_password';

After altering the password you need to define the password in the odoo config file(db_password).


thanks.

Avatar
Discard
Best Answer

You must go to pgAdmin, in the list on the left look for Login Roles/Groups; Right click and create a new role. The username and password that you must enter is the one that appears in the odoo.conf file that must be inside the Odoo "server" folder. Also in "privileges" check all the options, so you can create your database.

Finally, restart your postgreSQL server.

I hope it helps!

Avatar
Discard
Best Answer

Yo lo resolví, configurando en el server de Postgres el usuario, la contraseña y el puerto que está en el archivo "odoo.conf". 
Yo tenía el server de Postgres en otro puerto y no me funcionaba cambiar el puerto en el archivo, así que tuve que cambiar el puerto del server y además crear el usuario que estaba en el odoo.conf y ponerle esa contraseña que decía ahi en ese archivo.

Avatar
Discard
Best Answer

Hi,

Thanks for your response Manish, and I hope I'm not to rude... but honestly, I don't get how this answer helps someone that doesn't know anything about programming. I have the same problem as Alejandro, and I don't have a clue about what you're saying.

I'm trying to either create a new db, or restore a copy I downloaded from Odoo Online (I need both). And the only thing I do is fill out the creation (or restore) form, where it asks the Master Password, Database Name, email, etc...

And in both cases I get the same error:

Database creation: operational error ()

So I don't know how this links with the Odoo config file (honestly, I don't even know where it is or how to open it).

Are there any step-by-step instructions we can follow to solve this?

Avatar
Discard
Related Posts Replies Views Activity
0
Jul 23
1249
2
Aug 22
1772
0
Jul 22
1588
2
Jul 22
1591
2
Jul 22
1507