Re: [Users] Reimporting storage domains after reinstalling ovirt
On Mon, Mar 17, 2014 at 2:18 AM, Boudewijn Ector wrote:
Okay that sounds like database permissions:
[root@Xovirt-engine]# cat
/etc/ovirt-engine/engine.conf.d/10-setup-database.conf
ENGINE_DB_HOST="localhost"
ENGINE_DB_PORT="5432"
ENGINE_DB_USER="engine"
ENGINE_DB_PASSWORD="********"
ENGINE_DB_DATABASE="engine"
ENGINE_DB_SECURED="False"
ENGINE_DB_SECURED_VALIDATION="False"
ENGINE_DB_DRIVER="org.postgresql.Driver"
ENGINE_DB_URL="jdbc:postgresql://${ENGINE_DB_HOST}:${ENGINE_DB_PORT}/${ENGINE_DB_DATABASE}?sslfactory=org.postgresql.ssl.NonValidatingFactory"
I tried to reset the database's password using this in the psql shell:
alter user engine WITH password '********';
(the same password as above)
Still authentication fails, but when I do this:
psql -h localhost -p 5432 -U engine engine
It works fine... O gosh more debugging ;). Any clue where I should have
a look?
I just tried copying the old /etc/ovirt* stuff over /etc/overt* so both
configs and db are sync'ed again. To no avail.
Thanks guys!
Boudewijn
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
For PostgreSQL access you have to check your previous settings in
/var/lib/pgsql/data
relevant files are
pg_hba.conf
and
postgresql.conf
On a standard ovirt 3.3.3 on CentOS 6.5 my config is
pg_hba.conf;
local all all ident
host engine engine 0.0.0.0/0 md5
host engine engine ::0/0 md5
host all all 127.0.0.1/32 ident
host all all ::1/128 ident
If I compare modifications made by engine setup in respect of pre-defined ones:
[root@ovirteng02 data]# diff postgresql.conf postgresql.conf.20140301072333
64,65c64
< # max_connections = 100 # (change requires restart)
< max_connections = 150
---
max_connections = 100 # (change requires restart)
[root@ovirteng02 data]# diff pg_hba.conf pg_hba.conf.20140301072333
71,72d70
< host engine engine 0.0.0.0/0 md5
< host engine engine ::0/0 md5
check also your PostgreSQL version with the original one.
HIH,
Gianluca