Re: [Users] Help on an almost migrated ovirt-engine

2013-01-22 Thread Juan Hernandez

On 01/22/2013 02:48 AM, Adrian Gibanel wrote:

I need to migrate an ovirt-engine from an All-In-One (AIO) setup to a dedicated 
machine.

So with an old mailing message I've tried to do it but not finished yet, that's 
why I ask for help.

I've written a wiki page for the experience so that it becomes a howto which 
can be found here:

   http://www.ovirt.org/User:Adrian15/oVirt_engine_migration

At the last step the one that finally starts ovirt-engine I've decided to ask 
help here just in case I was missing something important.

So here are my doubts.

* Original message that inspired the howto is here: 
http://www.mail-archive.com/users@ovirt.org/msg00670.html
* What packages should I delete safely from an AIO setup so that it's just an 
hypervisor once I've migrate the ovirt-engine part?


All the ovirt-engine-* packages can be safely deleted, they are not used 
by hypervisors.


There are a lot of other packages that can be removed that are 
dependencies of ovirt-engine, like httpd, jboss-as and 
java-1.7.0-openjdk, and many of the dependencies that they bring, so a 
good way to start that cleanup is this:


  yum remove 'ovirt-engine-*' 'httpd' 'java-1.7.0-openjdk' 'jboss-as'

That will remove more than 300 packages, as it will transitively include 
all the Java packages. If you want to do further cleanups you can take a 
look at the package-cleanup tool, but be careful or you may end up 
with an useless system.



* Is the right way the one I've used to recreate the database?
   ** Origin
   pg_dump -U postgres engine | gzip  engine_db.gz
   ** Destination
   pg_dump -U postgres -s -f tempdb.dump engine
   dropdb -U postgres engine
   createdb -U postgres engine
   zcat engine_db.gz | psql -U postgres engine


The default installation of ovirt-engine creates the engine database 
owned by the engine user, but you are creating it owned by postgres 
instead. I think this won't break anything, but if you want to create it 
exactly the same you can use the -O option of createdb:


  createdb -U postgres -O engine engine



* Let's read: http://www.mail-archive.com/users@ovirt.org/msg00682.html : WRT 
certificates, note that hostname should nt change, or SSL will be invalidated.
Did he mean the SSL when you connect via http or https to the manager which 
currently doesn't bother me?
Or maybe the SSL to connect to other hosts and communicate to vdsm (sorry 
if I'm saying something nonsense. I don't understand oVirt architecture 
completely) which bothers me?
* Certificates is: /etc/pki/ovirt-engine ? Something more?


There is some information on how to change certificates here:

http://lists.ovirt.org/pipermail/users/2012-October/004167.html

It is not trivial, so better if you don't change the host name.


* Conf is: /etc/ovirt-engine ? Something more?


Yes, /etc/sysconfig/ovirt-engine, but you should be able to use the one 
generated during your new installation. The only difference will be the 
database password.


--
Dirección Comercial: C/Jose Bardasano Baos, 9, Edif. Gorbea 3, planta 
3ºD, 28016 Madrid, Spain

Inscrita en el Reg. Mercantil de Madrid – C.I.F. B82657941 - Red Hat S.L.
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] Help on an almost migrated ovirt-engine

2013-01-22 Thread Adrian Gibanel
- Mensaje original - 

 De: Juan Hernandez jhern...@redhat.com
 Para: Adrian Gibanel adrian.giba...@btactic.com
 CC: users users@ovirt.org
 Enviados: Martes, 22 de Enero 2013 9:40:29
 Asunto: Re: [Users] Help on an almost migrated ovirt-engine

 On 01/22/2013 02:48 AM, Adrian Gibanel wrote:
  I need to migrate an ovirt-engine from an All-In-One (AIO) setup to
  a dedicated machine.
 
  So with an old mailing message I've tried to do it but not finished
  yet, that's why I ask for help.
 
  I've written a wiki page for the experience so that it becomes a
  howto which can be found here:
 
  http://www.ovirt.org/User:Adrian15/oVirt_engine_migration
 
  At the last step the one that finally starts ovirt-engine I've
  decided to ask help here just in case I was missing something
  important.
 
  So here are my doubts.
 
  * Original message that inspired the howto is here:
  http://www.mail-archive.com/users@ovirt.org/msg00670.html
  * What packages should I delete safely from an AIO setup so that
  it's just an hypervisor once I've migrate the ovirt-engine part?

 yum remove 'ovirt-engine-*' 'httpd' 'java-1.7.0-openjdk' 'jboss-as'

I've updated the howto. Thank you!

  * Is the right way the one I've used to recreate the database?
  ** Origin
  pg_dump -U postgres engine | gzip  engine_db.gz
  ** Destination
  pg_dump -U postgres -s -f tempdb.dump engine
  dropdb -U postgres engine
  createdb -U postgres engine
  zcat engine_db.gz | psql -U postgres engine

 I think this won't break anything, but if you want to create
 it
 exactly the same you can use the -O option of createdb:

 createdb -U postgres -O engine engine

I've finally come with:

* Origin:
pg_dump -U postgres engine | gzip  engine_db.gz
* Destination:
dropdb -U postgres engine
createdb -U postgres -O engine engine
zcat engine_db.gz | psql -U postgres engine

The last command was run finally with postgres user because using engine user I 
had these warnings:

WARNING:  no privileges could be revoked for public
REVOKE
WARNING:  no privileges could be revoked for public
REVOKE
WARNING:  no privileges were granted for public
GRANT
WARNING:  no privileges were granted for public
GRANT

  * Let's read:
  http://www.mail-archive.com/users@ovirt.org/msg00682.html : WRT
  certificates, note that hostname should nt change, or SSL will be
  invalidated.
  Did he mean the SSL when you connect via http or https to the
  manager which currently doesn't bother me?
  Or maybe the SSL to connect to other hosts and communicate to vdsm
  (sorry if I'm saying something nonsense. I don't understand oVirt
  architecture completely) which bothers me?
  * Certificates is: /etc/pki/ovirt-engine ? Something more?

 There is some information on how to change certificates here:

 http://lists.ovirt.org/pipermail/users/2012-October/004167.html

 It is not trivial, so better if you don't change the host name.

Can you please ellaborate why I should make sure that all these certificates 
know about the new host name?
If this was a plain ssh key it would just work by copying and pasting its 
private key file. That's why my doubts.
I don't mind if https at the browser complains about having one certificate for 
one domain and being another one.

Maybe communication with vdsm on hypervisors will not work at all?

  * Conf is: /etc/ovirt-engine ? Something more?

 Yes, /etc/sysconfig/ovirt-engine, but you should be able to use the
 one
 generated during your new installation. The only difference will be
 the
 database password.
Ok. I'll check that later. I understand that if no difference is found apart 
from the database password then no need to modify it in the destination.

Thank you!

-- 

-- 
Adrián Gibanel 
I.T. Manager 

+34 675 683 301 
www.btactic.com 



Ens podeu seguir a/Nos podeis seguir en: 

i 


Abans d´imprimir aquest missatge, pensa en el medi ambient. El medi ambient és 
cosa de tothom. / Antes de imprimir el mensaje piensa en el medio ambiente. El 
medio ambiente es cosa de todos. 

AVIS: 
El contingut d'aquest missatge i els seus annexos és confidencial. Si no en sou 
el destinatari, us fem saber que està prohibit utilitzar-lo, divulgar-lo i/o 
copiar-lo sense tenir l'autorització corresponent. Si heu rebut aquest missatge 
per error, us agrairem que ho feu saber immediatament al remitent i que 
procediu a destruir el missatge . 

AVISO: 
El contenido de este mensaje y de sus anexos es confidencial. Si no es el 
destinatario, les hacemos saber que está prohibido utilizarlo, divulgarlo y/o 
copiarlo sin tener la autorización correspondiente. Si han recibido este 
mensaje por error, les agradeceríamos que lo hagan saber inmediatamente al 
remitente y que procedan a destruir el mensaje . 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] Help on an almost migrated ovirt-engine

2013-01-22 Thread Gianluca Cecchi
On Tue, Jan 22, 2013 at 10:47 AM, Adrian Gibanel wrote:
 I've finally come with:

 * Origin:
 pg_dump -U postgres engine | gzip  engine_db.gz
 * Destination:
 dropdb -U postgres engine
 createdb -U postgres -O engine engine
 zcat engine_db.gz | psql -U postgres engine

In another thread regarding all-in-one db problems I had (around
29/12/12), Doron came to tell

Backup to a file called mybackup may be created by:
- cd to /usr/share/ovirt-engine/dbscripts
- ./backup.sh -u postgres -f mybackup

..

Just in case you ever wish to use the backupfile, us this procedure:
- cd to /usr/share/ovirt-engine/dbscripts
- ./restore.sh -u postgres -f mybackup -r

and I successfully tested it on the same host.
I think it could be done the same with the second part on the new host...

Gianluca
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [Users] Help on an almost migrated ovirt-engine

2013-01-22 Thread Adrian Gibanel
I've updated the howto with your instructions. I prefer the most standard oVirt 
instructions. If there are backup and restore scripts it's because of there's a 
good reason. 

In my oVirt 3.1 installation backup.sh didn't seem to have an -f option so I've 
done it just with the default filename. 
I've also made a reference to oVirt 3.2 -f option. 

Thank you! 
- Mensaje original -

 De: Gianluca Cecchi gianluca.cec...@gmail.com
 Para: Adrian Gibanel adrian.giba...@btactic.com
 CC: users users@ovirt.org
 Enviados: Martes, 22 de Enero 2013 11:03:49
 Asunto: Re: [Users] Help on an almost migrated ovirt-engine

 On Tue, Jan 22, 2013 at 10:47 AM, Adrian Gibanel wrote:
  I've finally come with:

 In another thread regarding all-in-one db problems I had (around
 29/12/12), Doron came to tell

 Backup to a file called mybackup may be created by:
 - cd to /usr/share/ovirt-engine/dbscripts
 - ./backup.sh -u postgres -f mybackup

 ..

 Just in case you ever wish to use the backupfile, us this procedure:
 - cd to /usr/share/ovirt-engine/dbscripts
 - ./restore.sh -u postgres -f mybackup -r

 and I successfully tested it on the same host.
 I think it could be done the same with the second part on the new
 host...

 Gianluca

-- 

Adrián Gibanel 
I.T. Manager 

+34 675 683 301 
www.btactic.com 

Ens podeu seguir a/Nos podeis seguir en: 

i 

Abans d´imprimir aquest missatge, pensa en el medi ambient. El medi ambient és 
cosa de tothom. / Antes de imprimir el mensaje piensa en el medio ambiente. El 
medio ambiente es cosa de todos. 

AVIS: 
El contingut d'aquest missatge i els seus annexos és confidencial. Si no en sou 
el destinatari, us fem saber que està prohibit utilitzar-lo, divulgar-lo i/o 
copiar-lo sense tenir l'autorització corresponent. Si heu rebut aquest missatge 
per error, us agrairem que ho feu saber immediatament al remitent i que 
procediu a destruir el missatge . 

AVISO: 
El contenido de este mensaje y de sus anexos es confidencial. Si no es el 
destinatario, les hacemos saber que está prohibido utilizarlo, divulgarlo y/o 
copiarlo sin tener la autorización correspondiente. Si han recibido este 
mensaje por error, les agradeceríamos que lo hagan saber inmediatamente al 
remitente y que procedan a destruir el mensaje . 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users