who is the db owner?



Yaniv

Also is this clean install?

Actually I'm not able to reproduce, on my system is filing in another point:

2013-12-23 13:32:37::ERROR::rhevm-dwh-setup::629::root:: Traceback (most recent call last):
  File "/usr/bin/rhevm-dwh-setup", line 481, in main
    dbExists, owned = getDBStatus(db_dict, PGPASS_TEMP)
  File "/usr/bin/rhevm-dwh-setup", line 308, in getDBStatus
    exists, owned = utils.dbExists(dbdict, TEMP_PGPASS)
  File "/usr/share/ovirt-engine-dwh/common_utils.py", line 648, in dbExists
    if rc == 0:
UnboundLocalError: local variable 'rc' referenced before assignment

(In reply to Sandro Bonazzola from comment #3)
> Actually I'm not able to reproduce, on my system is filing in another point:
> 
> 2013-12-23 13:32:37::ERROR::rhevm-dwh-setup::629::root:: Traceback (most
> recent call last):
>   File "/usr/bin/rhevm-dwh-setup", line 481, in main
>     dbExists, owned = getDBStatus(db_dict, PGPASS_TEMP)
>   File "/usr/bin/rhevm-dwh-setup", line 308, in getDBStatus
>     exists, owned = utils.dbExists(dbdict, TEMP_PGPASS)
>   File "/usr/share/ovirt-engine-dwh/common_utils.py", line 648, in dbExists
>     if rc == 0:
> UnboundLocalError: local variable 'rc' referenced before assignment

this is unrelated to this bug. it's exploited by using non english locale. Opened a separate bug.

You can not use engine as db owner in 3.3 clean install of dwh and reports.



Yaniv

1) db owner is: remoteuser.

create database ovirt_engine_history  template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8' owner remoteuser;

2) As can be seen from comment 1 line 4, it was on clean install.

3) engine user will not work, maybe engine_history, in that case the instructions (which are missing in this case - as it is an upgrade flow instead of installation) should be changed and require a specific user (which will fail in the field, imho).

fail is32.1:

- rhevm-dwh-setup when executed on clean install for first time and doing remote install still "thinks" it is doing upgrade...

-%-
# rhevm-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 ]
Remote installation is selected.

Remote installation selected. Make sure that DBA creates a user and the database in the following fashion:
        create role <role> with login encrypted password <password>;
        create database ovirt_engine_history template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8' owner <role>;

Provide a remote DB user:  :  [engine_history]remote_engine_history
Please choose a password for the db user: 
Warning: Weak Password.
Re-type password: 
Could not connect to remote database - please try again.

      ^^^^^^^^^^^ - ignore, i created remote db under different name (corrected later)

Remote installation selected. Make sure that DBA creates a user and the database in the following fashion:
        create role <role> with login encrypted password <password>;
        create database ovirt_engine_history template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8' owner <role>;

Provide a remote DB user:  :  [remote_engine_history]
Please choose a password for the db user: 
Warning: Weak Password.
Re-type password: 

Existing DB was found on the system. The size of the detected DB is 5 MB, free space in the backup folder /var/lib/ovirt-engine/backups is approximately 12.0 GB. 

^^^^^^^^^^^ - of course! rhevm-dwh-setup tells me to create it (see above for instructions for DBA)


The upgrade utility can backup the existing database. The time and space required for the database backup depend on its size. The detected DB size is 5 MB. This process takes time, and in some cases (for instance, when the size is few GBs) may take few hours to complete. Would you like to continue and backup the existing database?
Answering "no" will skip the backup step and continue the upgrade without backing up the database (yes|no):
-%-

It should not talk about any upgrade at all if I'm doing clean remote install.

The BZ is about failure, not about 'upgrade' info in output.

is32.2 it passed OK.

Existing DB was found on the system. The size of the detected DB is 5 MB, free space in the backup folder /var/lib/ovirt-engine/backups is approximately 12.0 GB. 

The upgrade utility can backup the existing database. The time and space required for the database backup depend on its size. The detected DB size is 5 MB. This process takes time, and in some cases (for instance, when the size is few GBs) may take few hours to complete. Would you like to continue and backup the existing database?
Answering "no" will skip the backup step and continue the upgrade without backing up the database (yes|no): yes
Are you sure you would like to continue and backup database ovirt_engine_history?
Answering "no" will stop the upgrade (yes|no): yes
Backing up the DB...                                  [ DONE ]
The DB was backed up as '/var/lib/ovirt-engine/backups/ovirt-engine-history.backup.2014_01_16_14_25_29'
The DB backup was created with compression. You must use "pg_restore" command if you need to recover the DB from the backup.
Creating DB...                                        [ DONE ]
Setting DB connectivity...                            [ DONE ]
Starting ovirt-engine...                              [ DONE ]
Starting oVirt-ETL...                                 [ DONE ]
Successfully installed rhevm-dwh.
The installation log file is available at: /var/log/ovirt-engine/rhevm-dwh-setup-2014_01_16_14_16_12.log

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHBA-2014-0036.html