Re: Move running vm to project

2014-07-02 Thread Saif Siddiqui
Geoff Higginbottom writes: > > I think I've cracked it. > > I have to update the following tables and columns: > > Table: vm_instance > Columns: account_id & owner > > Table: nics > Columns: network_id > > Table: network_map > Columns: network_id > > Table: networks > Columns: account_id >

Re: Move running vm to project

2014-02-09 Thread Rafael Weingartner
peblue.com > > -Original Message- > From: Sean Hamilton [mailto:s...@seanhamilton.co.uk] > Sent: 20 January 2014 09:47 > To: users@cloudstack.apache.org > Subject: Re: Move running vm to project > > Rafael, > > If you look at the account table in the cloud database,

Re: Move running vm to project

2014-01-20 Thread Rafael Weingartner
el Weingartner [mailto:rafaelweingart...@gmail.com] > Sent: 20 January 2014 11:40 > To: users@cloudstack.apache.org > Subject: Re: Move running vm to project > > The tables that you updated the account_id I totally understand why you did > that, but, why did you update the network

RE: Move running vm to project

2014-01-20 Thread Geoff Higginbottom
0542 | S: +44 20 3603 0540 | M: +447968161581 geoff.higginbot...@shapeblue.com -Original Message- From: Rafael Weingartner [mailto:rafaelweingart...@gmail.com] Sent: 20 January 2014 11:40 To: users@cloudstack.apache.org Subject: Re: Move running vm to project The tables that you update

Re: Move running vm to project

2014-01-20 Thread Rafael Weingartner
> > Geoff Higginbottom > > D: +44 20 3603 0542 | S: +44 20 3603 0540 | M: +447968161581 > > geoff.higginbot...@shapeblue.com > > -Original Message- > From: Rafael Weingartner [mailto:rafaelweingart...@gmail.com] > Sent: 20 January 2014 10:21 > To: users@cloudstack.apa

RE: Move running vm to project

2014-01-20 Thread Geoff Higginbottom
| S: +44 20 3603 0540 | M: +447968161581 geoff.higginbot...@shapeblue.com -Original Message- From: Rafael Weingartner [mailto:rafaelweingart...@gmail.com] Sent: 20 January 2014 10:21 To: users@cloudstack.apache.org Subject: Re: Move running vm to project Sean, Geoff, This week I am going

Re: Move running vm to project

2014-01-20 Thread Rafael Weingartner
t does not work >> >> Regards >> >> Geoff Higginbottom >> >> D: +44 20 3603 0542 | S: +44 20 3603 0540 | M: +447968161581 >> >> geoff.higginbot...@shapeblue.com >> >> -Original Message- >> From: Sean Hamilton [mailto:s...@seanhamilton.

Re: Move running vm to project

2014-01-20 Thread Sean Hamilton
o.uk] > Sent: 20 January 2014 09:47 > To: users@cloudstack.apache.org > Subject: Re: Move running vm to project > > Rafael, > > If you look at the account table in the cloud database, you'll see that > some fields in account_name look like *PrjAcct-[Project Name]-2 *they have >

RE: Move running vm to project

2014-01-20 Thread Geoff Higginbottom
09:47 To: users@cloudstack.apache.org Subject: Re: Move running vm to project Rafael, If you look at the account table in the cloud database, you'll see that some fields in account_name look like *PrjAcct-[Project Name]-2 *they have the type set as 5: select * from cloud.account where type =

Re: Move running vm to project

2014-01-20 Thread Sean Hamilton
Rafael, If you look at the account table in the cloud database, you'll see that some fields in account_name look like *PrjAcct-[Project Name]-2 *they have the type set as 5: select * from cloud.account where type =5; I think that if you use the migrateVM API command and make this user the owner,

Re: Move running vm to project

2014-01-19 Thread Rafael Weingartner
Well, I could do that. However, this way seems that the VM is just going to be migrate to that user and not to a project. Unless the 'master' account of a project has the ability to migrate its VMs to a specific project since it can be master in more than one project. On Sun, Jan 19, 2014 at 2:26

Re: Move running vm to project

2014-01-19 Thread Sean Hamilton
Isn't there a master user account for a project? This account holds resources for that project, including vms. You could list all user accounts in a project and find the 'master' account and use migrate VM command? > On 19 Jan 2014, at 15:48, Rafael Weingartner > wrote: > > I saw that comma

Re: Move running vm to project

2014-01-19 Thread Rafael Weingartner
I saw that command, but, reading the docs, it seems that it just migrate VMs between accounts. On Sat, Jan 18, 2014 at 6:22 AM, Geoff Higginbottom wrote: > Rafael, > > There is a migrate VM API command that allows you to move a VM to another > account, it might work with projects as we'll but I

Re: Move running vm to project

2014-01-18 Thread Geoff Higginbottom
Rafael, There is a migrate VM API command that allows you to move a VM to another account, it might work with projects as we'll but I have not tried it. http://cloudstack.apache.org/docs/api/apidocs-4.2/root_admin/assignVirtualMachine.html Regards Geoff Higginbottom CTO / Cloud Architect D: