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