On Tue, Feb 4, 2014 at 10:39 AM, Alessandro Bianchi wrote:
Il 04/02/2014 09:55, Gianluca Cecchi ha scritto:
On Tue, Feb 4, 2014 at 9:10 AM, Alessandro Bianchi wrote:
in working directory '/usr/share/ovirt-engine-dwh/db-scripts'
2014-02-04 09:01:26::DEBUG::common_utils::962::root:: output =
2014-02-04 09:01:26::DEBUG::common_utils::963::root:: stderr = psql: FATALE:
autenticazione con password fallita per l'utente "engine_history"
password retrieved from file "/tmp/pgpassNkKGNp.tmp"
(autenticazione con password fallita per l'utente "engine_history" =
authentication failed for user "engine_history" system language is italian)
so it seems a user creation permission problem on the database
since I'm not too familiar with pgsql how is it supposed to fix this?
It look like it misses the password in some ovirt configuration file but
where to edit and how o fix it?
Any hint?
Thank you
See this thread of mine if you want to start from scratch and you
don't have any previous reports/dwh data or you don't mind to loose
them. Engine and its data is not impacted at all.
Eventually I'm going to open a bug for bad mgmt of pre-existing DB
user during setup (eg due to a previously failed in the middle
install).
http://lists.ovirt.org/pipermail/users/2014-February/020740.html
Let us know how it goes.
Gianluca
Thank you
I'm following the post but I'm stuck at 3)
drop user engine_history;
ERRORE: il ruolo "engine_history" non può essere eliminato perché alcuni
oggetti ne dipendono
DETTAGLI: proprietario di database ovirt_engine_history
300 oggetti nel database ovirt_engine_history
it says "Error: can't remove role engine_history because some object depend
on it. Detail: database owner ovirt_engine_history 300 objects in database
ovirt_engine history"
Any hint?
Thank you for your help
It seems I forgot a step... let us call 2bis)
you have to drop the two DBS before of users:
as postgres user
- psql
drop database ovirt_engine_history;
drop database ovirtenginereports;
and then you can drop users
Gianluca