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@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 _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users