Receiving “Database creation error: access denied” while creating a database in Odoo? We can help you fix it.

Odoo is a platform that companies can use to easily manage the basics of the company such as human resources, finance, accounting, sales, and many other enterprise features.

At Bobcares, we often receive requests to solve such database creation errors as a part of our Server Management Services.

Today, we’ll discuss the error in detail and see how our Support Engineers fix it.

 

What causes database creation error: access denied odoo?

The error happens when the master password is not the same as the admin password in odoo configuration file.

That means the Master Password entered in the Create Database step doesn’t match the admin_password in the odoo-server.conf file

A typical error message appears as:

database creation error: access denied odoo

How we fix database creation: error access denied odoo?

We saw what causes this error to occur. Let’s now see how our Support Engineers fix this error for our customers.

Recently, one of our customers approached us with the same error.

Our Support Engineers started troubleshooting the problem by checking if the admin_password in odoo.conf is correct. We saw the admin_password was displaying something like this,

admin_password = $pbkdf2-sha512$25000$15oTopRSSomREkLIeQ8hRA$QlTTxd4bqTTxSI0/u4g/yukO9jT2yFtTx4sAu46GtMKHnooPWT

So we won’t be able to know what is the DB-admin password.

But we can change it. So we changed it as below.

admin_passwd = 'new-password'

Then we restarted the odoo server using the command,

service odoo restart

And then we tried to recreate the DB again. This also didn’t work. So we checked for the parameters db_user and db_password in the odoo configuration file which is placed in /etc/odoo/odoo.conf.

The customer was using PostgreSQL with the specified user and password.

So we specified the same user and password in /etc/odoo/odoo.conf in parameters db_user and db_password.

Then we restarted the PostgreSQL using the command

/etc/init.d/postgresql restart

Finally, this fixed the error.

 

[Need any assistance in fixing database errors? – We’ll help you]

 

Conclusion

In short, the error occurs when the master password set in Odoo conf file is not the same as the database password. Today we saw how our Support Engineers fix this error.