[ovirt-users] Re: oVirt 4.4 Engine data migration & GUI notes

2020-07-23 Thread Yedidyah Bar David
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

2020-07-22 Thread Andrei Verovski


> 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

2020-07-22 Thread Sharon Gratch
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

2020-07-22 Thread Yedidyah Bar David
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/