Created attachment 895080[details]
reports setup log
Description of problem:
During installation on remote db server (engine + dwh DBs),
the part instructing how to create the reports db is missing, therefore the DB is created on the local machine:
Console:
[root@vm2 yum.repos.d]# 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>;
Database user [engine_history]: remoteuser
Database password:
Creating DB Schema... [ 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_05_12_15_19_41.log
[root@vm2 yum.repos.d]# rhevm-reports-setup
Welcome to rhevm-reports 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 ]
Editing XML files... [ DONE ]
Setting DB connectivity... [ DONE ]
Please choose a password for the reports admin user(s) (rhevm-admin and superuser):
Warning: Weak Password.
Re-type password:
Deploying Server... [ DONE ]
Updating Redirect Servlet... [ DONE ]
Importing reports... [ DONE ]
Customizing Server... [ DONE ]
Running post setup steps... [ DONE ]
Starting ovirt-engine... [ DONE ]
Restarting httpd... [ DONE ]
Succesfully installed rhevm-reports.
The installation log file is available at: /var/log/ovirt-engine/ovirt-engine-reports-setup-2014_05_12_15_29_30.log
Log:
grep rhevmreports /var/log/ovirt-engine/ovirt-engine-reports-setup-
2014_05_12_15_29_30.log
2014-05-12 15:29:33::DEBUG::common_utils::759::root:: checking if rhevmreports db already exists
2014-05-12 15:29:33::DEBUG::common_utils::517::root:: running sql query on host: vm2, port: 5432, db: rhevmreports, user: engine_reports, query: 'select 1'.
2014-05-12 15:29:33::DEBUG::common_utils::1025::root:: Executing command --> '/usr/bin/psql -w --pset=tuples_only=on --set ON_ERROR_STOP=1 --dbname rhevmreports --host vm2 --port 5432 --username engine_reports -c select 1' in working directory '/etc/yum.repos.d'
2014-05-12 15:29:33::DEBUG::common_utils::1081::root:: stderr = psql: FATAL: database "rhevmreports" does not exist
2014-05-12 15:29:33::DEBUG::common_utils::759::root:: checking if rhevmreports db already exists
2014-05-12 15:29:33::DEBUG::common_utils::1115::root:: starting runPostgresSuQuery database: rhevmreports query: "select 1;"
2014-05-12 15:29:33::DEBUG::common_utils::1025::root:: Executing command --> '/bin/su -l postgres -c /usr/bin/psql --pset=tuples_only=on --set ON_ERROR_STOP=1 -d rhevmreports -c "select 1;"' in working directory '/etc/yum.repos.d'
2014-05-12 15:29:34::DEBUG::common_utils::1081::root:: stderr = psql: FATAL: database "rhevmreports" does not exist
2014-05-12 15:29:54::DEBUG::common_utils::1115::root:: starting runPostgresSuQuery database: None query: "create database rhevmreports encoding 'UTF8' LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8' template template0 owner engine_reports;"
2014-05-12 15:29:54::DEBUG::common_utils::1025::root:: Executing command --> '/bin/su -l postgres -c /usr/bin/psql --pset=tuples_only=on --set ON_ERROR_STOP=1 -c "create database rhevmreports encoding 'UTF8' LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8' template template0 owner engine_reports;"' in working directory '/usr/share/jasperreports-server-pro/buildomatic'
2014-05-12 15:30:21::DEBUG::common_utils::1025::root:: Executing command --> '/usr/bin/createlang --host=vm2 --port=5432 --dbname=rhevmreports --username=engine_reports plpgsql' in working directory '/usr/share/jasperreports-server-pro/buildomatic'
[echo] Validating JasperServer database connection at jdbc:postgresql://vm2:5432/rhevmreports. Phase: [import-export-test]
Version-Release number of selected component (if applicable):
3.3.3 - is36.1
How reproducible:
100%
Steps to Reproduce:
1. install engine on remote db
2. install dwh on remote db
3. install remote on remote db
Actual results:
Missing instructions for reports db creation
Expected results:
Additional info:
Created attachment 895080 [details] reports setup log Description of problem: During installation on remote db server (engine + dwh DBs), the part instructing how to create the reports db is missing, therefore the DB is created on the local machine: Console: [root@vm2 yum.repos.d]# 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>; Database user [engine_history]: remoteuser Database password: Creating DB Schema... [ 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_05_12_15_19_41.log [root@vm2 yum.repos.d]# rhevm-reports-setup Welcome to rhevm-reports 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 ] Editing XML files... [ DONE ] Setting DB connectivity... [ DONE ] Please choose a password for the reports admin user(s) (rhevm-admin and superuser): Warning: Weak Password. Re-type password: Deploying Server... [ DONE ] Updating Redirect Servlet... [ DONE ] Importing reports... [ DONE ] Customizing Server... [ DONE ] Running post setup steps... [ DONE ] Starting ovirt-engine... [ DONE ] Restarting httpd... [ DONE ] Succesfully installed rhevm-reports. The installation log file is available at: /var/log/ovirt-engine/ovirt-engine-reports-setup-2014_05_12_15_29_30.log Log: grep rhevmreports /var/log/ovirt-engine/ovirt-engine-reports-setup- 2014_05_12_15_29_30.log 2014-05-12 15:29:33::DEBUG::common_utils::759::root:: checking if rhevmreports db already exists 2014-05-12 15:29:33::DEBUG::common_utils::517::root:: running sql query on host: vm2, port: 5432, db: rhevmreports, user: engine_reports, query: 'select 1'. 2014-05-12 15:29:33::DEBUG::common_utils::1025::root:: Executing command --> '/usr/bin/psql -w --pset=tuples_only=on --set ON_ERROR_STOP=1 --dbname rhevmreports --host vm2 --port 5432 --username engine_reports -c select 1' in working directory '/etc/yum.repos.d' 2014-05-12 15:29:33::DEBUG::common_utils::1081::root:: stderr = psql: FATAL: database "rhevmreports" does not exist 2014-05-12 15:29:33::DEBUG::common_utils::759::root:: checking if rhevmreports db already exists 2014-05-12 15:29:33::DEBUG::common_utils::1115::root:: starting runPostgresSuQuery database: rhevmreports query: "select 1;" 2014-05-12 15:29:33::DEBUG::common_utils::1025::root:: Executing command --> '/bin/su -l postgres -c /usr/bin/psql --pset=tuples_only=on --set ON_ERROR_STOP=1 -d rhevmreports -c "select 1;"' in working directory '/etc/yum.repos.d' 2014-05-12 15:29:34::DEBUG::common_utils::1081::root:: stderr = psql: FATAL: database "rhevmreports" does not exist 2014-05-12 15:29:54::DEBUG::common_utils::1115::root:: starting runPostgresSuQuery database: None query: "create database rhevmreports encoding 'UTF8' LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8' template template0 owner engine_reports;" 2014-05-12 15:29:54::DEBUG::common_utils::1025::root:: Executing command --> '/bin/su -l postgres -c /usr/bin/psql --pset=tuples_only=on --set ON_ERROR_STOP=1 -c "create database rhevmreports encoding 'UTF8' LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8' template template0 owner engine_reports;"' in working directory '/usr/share/jasperreports-server-pro/buildomatic' 2014-05-12 15:30:21::DEBUG::common_utils::1025::root:: Executing command --> '/usr/bin/createlang --host=vm2 --port=5432 --dbname=rhevmreports --username=engine_reports plpgsql' in working directory '/usr/share/jasperreports-server-pro/buildomatic' [echo] Validating JasperServer database connection at jdbc:postgresql://vm2:5432/rhevmreports. Phase: [import-export-test] Version-Release number of selected component (if applicable): 3.3.3 - is36.1 How reproducible: 100% Steps to Reproduce: 1. install engine on remote db 2. install dwh on remote db 3. install remote on remote db Actual results: Missing instructions for reports db creation Expected results: Additional info: