[Users] How to scratch previous versions reports and dwh installation?

[Gianluca Cecchi]

for example,

- yum remove ovirt-engine-dwh ovirt-engine-reports

- psql
drop database ovirt_engine_history;
drop database ovirtenginereports;

cd /etc
mv ovirt-engine-dwh/ ovirt-engine-dwh.old
mv ovirt-engine-reports/ ovirt-engine-reports.old
mv ovirt-engine/ovirt-engine-dwh ovirt-engine/ovirt-engine-dwh.old

mv /var/lib/ovirt-engine/deployments/ovirt-engine-reports.war.dodeploy
 /var/lib/ovirt-engine/deployments/ovirt-engine-reports.war.dodeploy.old

and run setup again after installing ovirt-engine-dwh-3.3.3-1.fc19.noarch
(I currently have stable + updates-testing repos enabled)

[root at tekkaman ~]# ovirt-engine-dwh-setup
Welcome to ovirt-engine-dwh setup utility

In order to proceed the installer must stop the ovirt-engine service
Would you like to stop the ovirt-engine service (yes|no): yes
Stopping ovirt-engine...                              [ DONE ]

This utility can configure a read only user for DB access. Would you
like to do so? (yes|no): yes
Error: user name cannot be empty
Provide a username for read-only user : ovirt_read
Provide a password for read-only user:
Warning: Weak Password.
Re-type password:
Should postgresql be setup with secure connection? (yes|no): yes
Creating DB...                                        [ ERROR ]
Error encountered while installing ovirt-engine-dwh, please consult
the log file: /var/log/ovirt-engine/ovirt-engine-dwh-setup-2014_02_02_16_29_34.log

The main problem in log is:

2014-02-02 16:30:04::DEBUG::ovirt-engine-dwh-setup::144::root:: ovirt
engine history db creation is logged at
/var/log/ovirt-engine/ovirt-history-db-install-2014_02_02_16_30_04.log
2014-02-02 16:30:04::DEBUG::common_utils::907::root:: Executing
command --> '/usr/share/ovirt-engine-dwh/db-scripts/create_schema.sh
-l /var/log/ovirt-engine/ovirt-history-db-install-2014_02_02_16_30_04.log
-u engine_history -s localhost -p 5432 -g' in working directory
'/root'
2014-02-02 16:30:04::DEBUG::common_utils::962::root:: output =
2014-02-02 16:30:04::DEBUG::common_utils::963::root:: stderr = psql:
FATAL:  password authentication failed for user "engine_history"
FATAL:  password authentication failed for user "engine_history"
password retrieved from file "/tmp/pgpassW0tW24.tmp"

2014-02-02 16:30:04::DEBUG::common_utils::964::root:: retcode = 2
2014-02-02 16:30:04::ERROR::decorators::27::root:: Traceback (most
recent call last):
  File "/usr/share/ovirt-engine-dwh/decorators.py", line 20, in wrapped_f
    output = f(*args)
  File "/bin/ovirt-engine-dwh-setup", line 160, in createDbSchema
    envDict={'ENGINE_PGPASS': PGPASS_TEMP},
  File "/usr/share/ovirt-engine-dwh/common_utils.py", line 967, in execCmd
    raise Exception(msg)
Exception: Error while trying to create ovirt_engine_history db

2014-02-02 16:30:04::ERROR::ovirt-engine-dwh-setup::691::root::
Exception caught!
2014-02-02 16:30:04::ERROR::ovirt-engine-dwh-setup::692::root::
Traceback (most recent call last):
  File "/bin/ovirt-engine-dwh-setup", line 637, in main
    createDbSchema(db_dict)
  File "/usr/share/ovirt-engine-dwh/decorators.py", line 28, in wrapped_f
    raise Exception(instance)
Exception: Error while trying to create ovirt_engine_history db

So it seems a problem with creating db

Currently

[root at tekkaman ~]# grep -v ^# /var/lib/pgsql/data/pg_hba.conf

local   all             postgres                                     trust
local   all             all                                     md5
host    ovirtenginereports engine_reports  0.0.0.0/0               md5
host    ovirtenginereports engine_reports  ::0/0                   md5
host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5
host    ovirt_engine_history engine_history  ::0/0                   trust


where is stored information for user engine_history do I have also to
cleanup this user information?
See my full log
/var/log/ovirt-engine/ovirt-engine-dwh-setup-2014_02_02_16_29_34.log
here:
https://drive.google.com/file/d/0BwoPbcrMv8mvQnJlRkljTkhjMTg/edit?usp=sharing

Gianluca