On 2016-06-27 19:15, Fernando Fuentes wrote: > Ricky, > > I am under the impression that the DB migration was implemented in > release 3.6.6. > > I might be wrong. > > https://www.ovirt.org/release/3.6.6/ > > What's New in 3.6.6? > Enhancement > oVirt Engine > > BZ 1241149 [RFE] Provide way to preform in-cluster upgrade of hosts from > el6->el7. > BZ 1332463 [RFE] restore: ensure that 3.6 on el6 backup can be restored > on 3.6 on el7 > Feature: > > Allow engine-backup on el7 to restore backups taken on el6. > > Reason: > > engine 4.0 does not support el6. Users that want to upgrade from 3.6 on > el6 to 4.0 on el7 have to do this by backing up the engine on 3.6/el6 > and restore on 4.0/el7. > > This feature, backported from 4.0, allows to do such a migration also in > 3.6. > > Result: > > Using this flow, it's possible to migrate a el6 setup to el7: > > On the existing engine machine run: > 1. engine-backup --mode=backup --file=engine-3.6.bck --log=backup.log > > On a new el7 machine: > 2. Install engine, including dwh if it was set up on el6. > 3. Copy engine-3.6.bck to the el7 machine > 4. engine-backup --mode=restore --file=engine-3.6.bck --log=restore.log > --provision-db --no-restore-permissions > 5. engine-setup > > Check engine-backup documentation for other options, including using > remote databases, extra grants/permissions, etc. >
One step forward, two backward.... - upgrade the old EL6 to ovirt 3.6.6 - engine-backup --mode=backup --file=engine-backup.tar.gz --log=backup.log - install http://resources.ovirt.org/pub/yum-repo/ovirt-release40.rpm, to have ovirt-engine 4.0.0.6. - yum install ovirt-engine - |engine-backup --mode=restore --no-restore-permissions --provision-db --file=engine-backup.tar.gz --log=engine-backup-restore.log Then I got this error... "Preparing to restore: - Unpacking file 'engine-backup.tar.gz' Restoring: - Files ------------------------------------------------------------------------------ Please note: Operating system is different from the one used during backup. Current operating system: centos7 Operating system at backup: centos6 Apache httpd configuration will not be restored. You will be asked about it on the next engine-setup run. ------------------------------------------------------------------------------ Provisioning PostgreSQL users/databases: - user 'engine', database 'engine' Restoring: FATAL: Can't connect to database 'ovirt_engine_history'. Please see '/usr/bin/engine-backup --help'." I have attached the engine-backup-restore.log. //Ricky |
2016-06-28 09:42:01 20260: Start of engine-backup mode restore scope all file
engine-backup.tar.gz
2016-06-28 09:42:01 20260: OUTPUT: Preparing to restore:
2016-06-28 09:42:01 20260: OUTPUT: - Unpacking file 'engine-backup.tar.gz'
2016-06-28 09:42:01 20260: Opening tarball engine-backup.tar.gz to
/tmp/engine-backup.YuNYQaC9J3
2016-06-28 09:42:02 20260: Verifying md5
2016-06-28 09:42:02 20260: Verifying version
2016-06-28 09:42:02 20260: Reading config
2016-06-28 09:42:02 20260: OUTPUT: Restoring:
2016-06-28 09:42:02 20260: OUTPUT: - Files
2016-06-28 09:42:02 20260: Restoring files
2016-06-28 09:42:02 20260: Reloading configuration
2016-06-28 09:42:02 20260: OUTPUT: Provisioning PostgreSQL users/databases:
2016-06-28 09:42:02 20260: provisionDB: user engine host localhost port 5432
database engine secured False secured_host_validation False
2016-06-28 09:42:02 20260: OUTPUT: - user 'engine', database 'engine'
[ INFO ] Stage: Initializing
[ INFO ] Stage: Environment setup
Configuration files:
['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf',
'/etc/ovirt-engine-setup.conf.d/10-packaging.conf',
'/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf',
'/tmp/engine-backup.YuNYQaC9J3/pg-provision-answer-file']
Log file:
/var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20160628094202-nwcp21.log
Version: otopi-1.5.0 (otopi-1.5.0-1.el7.centos)
[ INFO ] Stage: Environment packages setup
[ INFO ] Stage: Programs detection
[ INFO ] Stage: Environment customization
[ INFO ] Stage: Setup validation
[ INFO ] Stage: Transaction setup
[ INFO ] Stage: Misc configuration
[ INFO ] Stage: Package installation
[ INFO ] Stage: Misc configuration
[ INFO ] Creating PostgreSQL 'engine' database
[ INFO ] Configuring PostgreSQL
[ INFO ] Stage: Transaction commit
[ INFO ] Stage: Closing up
[ INFO ] Stage: Clean up
Log file is located at
/var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20160628094202-nwcp21.log
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ INFO ] Execution of provisiondb completed successfully
2016-06-28 09:42:08 20260: OUTPUT: Restoring:
2016-06-28 09:42:08 20260: Generating pgpass
2016-06-28 09:42:08 20260: Verifying connection
2016-06-28 09:42:08 20260: pg_cmd running: psql -w -U engine -h localhost -p
5432 engine -c select 1
?column?
----------
1
(1 row)
2016-06-28 09:42:08 20260: pg_cmd running: psql -w -U engine -h localhost -p
5432 engine -t -c show lc_messages
2016-06-28 09:42:08 20260: pg_cmd running: pg_dump -w -U engine -h localhost -p
5432 engine -s
2016-06-28 09:42:08 20260: pg_cmd running: psql -w -U ovirt_engine_history -h
localhost -p 5432 ovirt_engine_history -c select 1
psql: FATAL: Ident authentication failed for user "ovirt_engine_history"
2016-06-28 09:42:08 20260: FATAL: Can't connect to database
'ovirt_engine_history'. Please see '/usr/bin/engine-backup --help'.
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
