Re: [Users] [URGENT] hacking the DB

2014-02-02 Thread jplor...@gmail.com
To: Juan Pablo Lorier jplor...@gmail.com Cc: users users@ovirt.org Subject: Re: [Users] [URGENT] hacking the DB Message-ID: 1814059864.10645949.1391289217257.javamail.r...@redhat.com Content-Type: text/plain; charset=utf-8 - Original Message - From: Juan Pablo Lorier jplor

Re: [Users] [URGENT] hacking the DB

2014-02-01 Thread Eli Mesika
- Original Message - From: Juan Pablo Lorier jplor...@gmail.com To: Sahina Bose sab...@redhat.com, users users@ovirt.org Sent: Friday, January 31, 2014 4:18:47 PM Subject: Re: [Users] [URGENT] hacking the DB It also has a foreign key at vds_statistics, Thanks for everything, I'll

Re: [Users] [URGENT] hacking the DB

2014-01-31 Thread Sahina Bose
On 01/31/2014 04:49 PM, Juan Pablo Lorier wrote: Hi, I'm about to hack engine db to remove a gluster volume and I'd like someone to advise me on this. The environment is in production, I've backed up the db and I'm planning to remove every entry I can find of the volume (host members, cluster,

Re: [Users] [URGENT] hacking the DB

2014-01-31 Thread Juan Pablo Lorier
Thanks Sahina!! The hosts are there as the volume. What is gone is the DC and mostly everything else. I'll send you the logs, but due to the lack of time, they are going to be the raw logs for several days as the force was last week. Regards, On 31/01/14 09:35, Sahina Bose wrote: On 01/31/2014

Re: [Users] [URGENT] hacking the DB

2014-01-31 Thread Juan Pablo Lorier
Hi again, I'm now in the process of deleting the removed cluster from the hosts. I can't just delete it from vds_groups as is a external key to vds_static, and it looks like vds_static has the hosts definition. Can I safely update the vds_group_id to ' ' in the hosts to detach them from the

Re: [Users] [URGENT] hacking the DB

2014-01-31 Thread Sahina Bose
On 01/31/2014 05:49 PM, Juan Pablo Lorier wrote: Hi again, I'm now in the process of deleting the removed cluster from the hosts. I can't just delete it from vds_groups as is a external key to vds_static, and it looks like vds_static has the hosts definition. Can I safely update the

Re: [Users] [URGENT] hacking the DB

2014-01-31 Thread Juan Pablo Lorier
It also has a foreign key at vds_statistics, Thanks for everything, I'll keep you updated on this matter. Regards, On 31/01/14 11:30, Sahina Bose wrote: On 01/31/2014 05:49 PM, Juan Pablo Lorier wrote: Hi again, I'm now in the process of deleting the removed cluster from the hosts. I can't