[Users] ovirt-report Forbidden access error

[Alessandro Bianchi]

Il 02/02/2014 07:40, Yedidyah Bar David ha scritto:
> ----- Original Message -----
>> From: "Alessandro Bianchi" <a.bianchi at skynet.it>
>> To: users at ovirt.org
>> Sent: Friday, January 31, 2014 4:13:51 PM
>> Subject: [Users] ovirt-report  Forbidden access error
>>
>> Hi all
>>
>> I installed
>>
>> ovirt-engine-reports-3.3.2-1.fc19.noarch using yum
>>
>> Now I have reports listed when right clicking on Vms but on any report i
>> see this error:
>>
>>
>>    Forbidden
>>
>> You don't have permission to access /ovirt-engine-reports/flow.html on
>> this server.
>>
>> This seems to be related to apache redirection but how to fix it?
>>
>> I have three files in conf.d
>>
>> ovirt-engine-root-redirect.conf
>> z-ovirt-engine-proxy.conf
>> z-ovirt-engine-reports-proxy.conf
>>
>> but can't figure how to fix them
>>
>> I applied no changes to these files
> Did you also run 'ovirt-engine-reports-setup' after installing it?
> Was it a new installation or an upgrade from 3.2? Both engine and reports.
> Did you install and setup dwh?
>
> Note that there are several bugs in dwh/reports 3.3.2, targeted to be fixed
> in 3.3.3. So you might want to wait till 3.3.3 is released.
>
> Regards,
Ok

after upgrading to 3.3.3 it asks me to setup dwh again so

ovirt-engine-dwh-setup

ends with error, log says

2014-02-04 09:01:26::DEBUG::common_utils::907::root:: Executing command 
--> '/usr/share/ovirt-engine-dwh/db-scripts/upgrade.sh -s localhost -p 
5432 -u engine_history -d ovirt_engine_history -l 
/var/log/ovirt-engine/ovirt-history-db-upgrade-2014_02_04_09_01_26.log 
-g' 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

Best regards


-- 

SkyNet SRL

Via Maggiate 67/a - 28021 Borgomanero (NO) - tel. +39 0322-836487/834765 
- fax +39 0322-836608

http://www.skynet.it <http://www.skynet.it/>

Autorizzazione Ministeriale n.197

Le informazioni contenute in questo messaggio sono riservate e 
confidenziali ed è vietata la diffusione in qualunque modo eseguita.
Qualora Lei non fosse la persona a cui il presente messaggio è 
destinato, La invitiamo ad eliminarlo ed a distruggerlo non 
divulgandolo, dandocene gentilmente comunicazione.
Per qualsiasi informazione si prega di contattare info at skynet.it (e-mail 
dell'azienda). Rif. D.L. 196/2003