Community mailing list archives

community@mail.odoo.com

RE: postgrescredentials(forbackups)? installed with bitnami-odooinstaller

by
mangoo
- 02/03/2015 21:56:25
On 2015-02-04 03:03, Atul jain wrote:
> 1. Default password for postgres is postgres_

Apparently it's not:

root@odoo01:~# export PGPASSWORD=postgres_
root@odoo01:~# /opt/odoo-8.0-5/postgresql/bin/psql -U postgres
psql.bin: FATAL:  password authentication failed for user "postgres"


> 2.
> And if you want login in to the psql shell then just login with
> postgres user but login without root  user but user should have sudo
> access

Nope, Odoo changes default postgres settings and does not allow it:

root@odoo01:~# su - postgres
No directory, logging in with HOME=/
$ /opt/odoo-8.0-5/postgresql/bin/psql
Password:
psql.bin: FATAL:  password authentication failed for user "postgres"
$ /opt/odoo-8.0-5/postgresql/bin/psql
Password:
psql.bin: FATAL:  password authentication failed for user "postgres"


> 3.
> And third way is that just see openerp-server.conf file there you can
> see database user and password then login with that

This one does work.

It's not administrator login (postgres) though - only bn_openerp user 
giving access to bitnami_openerp database.

Is it the only database used by Odoo?


> and then run
> Alter role postgres with password 'password';

Nope - bn_openerp user is not a privileged user.

bitnami_openerp=> alter role postgres with password 'xxxxxxx';
ERROR:  must be superuser to alter superusers


Is there any way to access postgres as a superuser on Odoo setup made 
with bitnami-odooinstaller? Anyone knows?

-- 
Tomasz Chmielewski
http://www.sslrack.com