[Users] Reimporting storage domains after reinstalling ovirt

[Gianluca Cecchi]

On Mon, Mar 17, 2014 at 2:18 AM, Boudewijn Ector wrote:

>
> Okay that sounds like database permissions:
>
>
> [root at 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 at 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 at 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 at 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