[ovirt-users] Re: oVirt 4.4 Engine data migration & GUI notes
On Wed, Jul 22, 2020 at 4:41 PM Andrei Verovski wrote: > > > > > On 22 Jul 2020, at 13:05, Yedidyah Bar David wrote: > > > > On Wed, Jul 22, 2020 at 12:50 PM Andrei Verovski > > wrote: > >> > >> Hi ! > >> > >> I have installed new oVirt 4.4 Engine (as separate entity, not hosted > >> engine) and migrated data from old 4.3 installation. > >> Everything went smooth. > > > > Can you please clarify exactly what you did? Did you use engine-backup > > backup/restore? > > Yes, ovirt built-in backup/restore > > engine-backup --mode=restore --log=restore1.log > --file=ovirt-engine-backup-20200721122423.backup --provision-db > --provision-dwh-db --no-restore-permissions > > > > >> > >> Q: Which PostgreSQL password now active - new one I entered during install > >> or old which could migrate with old data? > > > > I do not think you should have been prompted for a password during > > install, unless you refer to Grafana's admin. Please clarify. > > > > Perhaps you used a remote database? > > Database local, not remote. > I had a prompt for postgresql password during install. When exactly? > > oVirt Engine 4.4 fresh install on CentOS 8.2 appliance, with these command, > instruction from official web site, then restore from backup (snippet above) > > yum install https://resources.ovirt.org/pub/yum-repo/ovirt-release44.rpm > yum module -y enable javapackages-tools > yum module -y enable pki-deps > yum module -y enable postgresql:12 > yum install postgresql-server postgresql-contrib > postgresql-setup --initdb > systemctl enable postgresql; systemctl start postgresql > > su - postgres -c psql > create role engine with login encrypted password ‘my password'; > create role ovirt_engine_history with login encrypted password 'my password'; > > create database engine owner engine template template0 encoding 'UTF8' > lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8'; > create database ovirt_engine_history owner ovirt_engine_history template > template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8'; > > \c engine > CREATE EXTENSION "uuid-ossp"; > CREATE LANGUAGE plpgsql; > > \c ovirt_engine_history > CREATE EXTENSION "uuid-ossp"; > CREATE LANGUAGE plpgsql; Sorry, I do not understand. Please explain the issue with more details - what did you do, what happened. Please attach relevant logs, e.g. from /var/log/ovirt-engine/setup/* . Generally speaking, you do not need to create databases or users manually before restore. Using --provision* options should do that for you. In principle, depending on exact conditions, it indeed can happen that you'll be prompted for DB credentials. It's hard to guess, though, what was the exact issue, without more details and logs. Thanks and best regards, -- Didi ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/VH2WTYJ75D27VPUYI2KAUE4MWBKTLAND/
[ovirt-users] Re: oVirt 4.4 Engine data migration & GUI notes
> On 22 Jul 2020, at 13:05, Yedidyah Bar David wrote: > > On Wed, Jul 22, 2020 at 12:50 PM Andrei Verovski wrote: >> >> Hi ! >> >> I have installed new oVirt 4.4 Engine (as separate entity, not hosted >> engine) and migrated data from old 4.3 installation. >> Everything went smooth. > > Can you please clarify exactly what you did? Did you use engine-backup > backup/restore? Yes, ovirt built-in backup/restore engine-backup --mode=restore --log=restore1.log --file=ovirt-engine-backup-20200721122423.backup --provision-db --provision-dwh-db --no-restore-permissions > >> >> Q: Which PostgreSQL password now active - new one I entered during install >> or old which could migrate with old data? > > I do not think you should have been prompted for a password during > install, unless you refer to Grafana's admin. Please clarify. > > Perhaps you used a remote database? Database local, not remote. I had a prompt for postgresql password during install. oVirt Engine 4.4 fresh install on CentOS 8.2 appliance, with these command, instruction from official web site, then restore from backup (snippet above) yum install https://resources.ovirt.org/pub/yum-repo/ovirt-release44.rpm yum module -y enable javapackages-tools yum module -y enable pki-deps yum module -y enable postgresql:12 yum install postgresql-server postgresql-contrib postgresql-setup --initdb systemctl enable postgresql; systemctl start postgresql su - postgres -c psql create role engine with login encrypted password ‘my password'; create role ovirt_engine_history with login encrypted password 'my password'; create database engine owner engine template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8'; create database ovirt_engine_history owner ovirt_engine_history template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8'; \c engine CREATE EXTENSION "uuid-ossp"; CREATE LANGUAGE plpgsql; \c ovirt_engine_history CREATE EXTENSION "uuid-ossp"; CREATE LANGUAGE plpgsql; ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/USG524FECMYPFDRQHF7MMYTU5OYVEHUI/
[ovirt-users] Re: oVirt 4.4 Engine data migration & GUI notes
Hi, On Wed, Jul 22, 2020 at 1:07 PM Yedidyah Bar David wrote: > On Wed, Jul 22, 2020 at 12:50 PM Andrei Verovski > wrote: > > > > Hi ! > > > > I have installed new oVirt 4.4 Engine (as separate entity, not hosted > engine) and migrated data from old 4.3 installation. > > Everything went smooth. > > Can you please clarify exactly what you did? Did you use engine-backup > backup/restore? > > > > > Q: Which PostgreSQL password now active - new one I entered during > install or old which could migrate with old data? > > I do not think you should have been prompted for a password during > install, unless you refer to Grafana's admin. Please clarify. > > Perhaps you used a remote database? > > > > > I noticed GUI changes straight on dashboard. > > Icons on top (data centres, clusters, hosts, etc) are simply put, too > huge. This serves no useful purpose whatsoever, and consumes screen real > estate for no reason. > > Decreasing their size by 2/3 will help to make 1st page more informative > at 1st sight without extra scrolling. > > Adding Laura for this part. Perhaps better start a new thread, or open > a bug, next time... It's less comfortable to discuss two unrelated > things in the same mail thread. > Regarding dashboard large icons, which browser are you using? If it's firefox 68.10 ESR, then I guess you are referring to this bug https://bugzilla.redhat.com/show_bug.cgi?id=1855761 which is already fixed for next oVirt version (4.4.2). Thanks, Sharon > > Thanks and best regards, > -- > Didi > ___ > Users mailing list -- users@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org > Privacy Statement: https://www.ovirt.org/privacy-policy.html > oVirt Code of Conduct: > https://www.ovirt.org/community/about/community-guidelines/ > List Archives: > https://lists.ovirt.org/archives/list/users@ovirt.org/message/GHDPV6FJK2RFYCGNKLS4GDO4FUU26B73/ > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/VF6NI3U5EVZASVPPNBIY45VA7HA36APU/
[ovirt-users] Re: oVirt 4.4 Engine data migration & GUI notes
On Wed, Jul 22, 2020 at 12:50 PM Andrei Verovski wrote: > > Hi ! > > I have installed new oVirt 4.4 Engine (as separate entity, not hosted engine) > and migrated data from old 4.3 installation. > Everything went smooth. Can you please clarify exactly what you did? Did you use engine-backup backup/restore? > > Q: Which PostgreSQL password now active - new one I entered during install or > old which could migrate with old data? I do not think you should have been prompted for a password during install, unless you refer to Grafana's admin. Please clarify. Perhaps you used a remote database? > > I noticed GUI changes straight on dashboard. > Icons on top (data centres, clusters, hosts, etc) are simply put, too huge. > This serves no useful purpose whatsoever, and consumes screen real estate for > no reason. > Decreasing their size by 2/3 will help to make 1st page more informative at > 1st sight without extra scrolling. Adding Laura for this part. Perhaps better start a new thread, or open a bug, next time... It's less comfortable to discuss two unrelated things in the same mail thread. Thanks and best regards, -- Didi ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/GHDPV6FJK2RFYCGNKLS4GDO4FUU26B73/
