[Users] ovirt-report Forbidden access error

[Gianluca Cecchi]

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