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 Table: volumes Columns: account_id There may be more that need updating, but the VM is now showing up in the Project, and can ping other VMs which were created in the Project. One thing to note is that the VM I migrated was created in a standard account which is in the same Domain as the Project. Regards 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.apache.org Subject: Re: Move running vm to project Sean, Geoff, This week I am going to take a look at the database and the api, to see if I can find a nice way to work this around. Anything I find I will let you know ;) On Mon, Jan 20, 2014 at 7:53 AM, Sean Hamilton <s...@seanhamilton.co.uk> wrote: > Darn. I've not had to do this myself before. I wonder if the ROOT > volume needs to be updated in the same way? There are a lot of > resources associated with a vm. > > > On 20 January 2014 09:50, Geoff Higginbottom < > geoff.higginbot...@shapeblue.com> wrote: > >> I actually tried that 30 mins ago and unfortunately it 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.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, 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, it will get moved into that project. You can see that this >> user account 'owns' all vms within that project. >> >> Not sure if this helps at all... >> >> Sean >> >> >> On 19 January 2014 16:32, Rafael Weingartner >> <rafaelweingart...@gmail.com >> >wrote: >> >> > 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 PM, Sean Hamilton >> > <s...@seanhamilton.co.uk> >> > wrote: >> > > 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 < >> > rafaelweingart...@gmail.com> wrote: >> > >> >> > >> 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 >> > >> <geoff.higginbot...@shapeblue.com> 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 have >> > not tried it. >> > >>> >> > >>> >> > http://cloudstack.apache.org/docs/api/apidocs-4.2/root_admin/assign >> > Vir >> > tualMachine.html >> > >>> >> > >>> >> > >>> Regards >> > >>> >> > >>> Geoff Higginbottom >> > >>> CTO / Cloud Architect >> > >>> >> > >>> >> > >>> D: +44 20 3603 0542<tel:+442036030542> | S: +44 20 3603 0540<tel: >> > +442036030540> | M: +447968161581<tel:+447968161581> >> > >>> >> > >>> geoff.higginbot...@shapeblue.com<mailto: >> > geoff.higginbot...@shapeblue.com> | www.shapeblue.com<htp:// >> > www.shapeblue.com/> >> > >>> >> > >>> ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N >> > 4HS<x-apple-data-detectors://37> >> > >>> >> > >>> >> > >>> >> > >>> On 18 Jan 2014, at 00:47, "Rafael Weingartner" < >> > rafaelweingart...@gmail.com<mailto:rafaelweingart...@gmail.com>> wrote: >> > >>> >> > >>> Hi, >> > >>> I was wondering, is it possible to move a running VM to a project? >> > >>> If so, how could I do that? I know that I can do that working >> > >>> directly on the database, but this would be an error prone job. >> > >>> >> > >>> -- >> > >>> Rafael Weing?rtner >> > >>> Need Enterprise Grade Support for Apache CloudStack? >> > >>> Our CloudStack Infrastructure Support< >> > http://shapeblue.com/cloudstack-infrastructure-support/> offers the >> > best >> > 24/7 SLA for CloudStack Environments. >> > >>> >> > >>> Apache CloudStack Bootcamp training courses >> > >>> >> > >>> **NEW!** CloudStack 4.2 training< >> > http://shapeblue.com/cloudstack-training/> >> > >>> 08/09 January 2014, >> > >>> London<http://shapeblue.com/cloudstack-training/> >> > >>> 13-17 January 2014, GLOBAL. Instructor led, On-line< >> > http://shapeblue.com/cloudstack-training/> >> > >>> 20-24 January 2014, GLOBAL. Instructor led, On-line< >> > http://shapeblue.com/cloudstack-training/> >> > >>> >> > >>> This email and any attachments to it may be confidential and >> > >>> are >> > intended solely for the use of the individual to whom it is addressed. >> > Any views or opinions expressed are solely those of the author and >> > do not necessarily represent those of Shape Blue Ltd or related >> > companies. If you are not the intended recipient of this email, you >> > must neither take any action based upon its contents, nor copy or >> > show it to anyone. Please contact the sender if you believe you >> > have received >> this email in error. >> > Shape Blue Ltd is a company incorporated in England & Wales. >> > ShapeBlue Services India LLP is a company incorporated in India and >> > is operated under license from Shape Blue Ltd. Shape Blue Brasil >> > Consultoria Ltda is a company incorporated in Brasil and is >> > operated under license from Shape Blue Ltd. ShapeBlue is a registered >> > trademark. >> > >> >> > >> >> > >> >> > >> -- >> > >> Rafael Weingärtner >> > >> > >> > >> > -- >> > Rafael Weingärtner >> > >> This email and any attachments to it may be confidential and are >> intended solely for the use of the individual to whom it is >> addressed. Any views or opinions expressed are solely those of the >> author and do not necessarily represent those of Shape Blue Ltd or >> related companies. If you are not the intended recipient of this >> email, you must neither take any action based upon its contents, nor >> copy or show it to anyone. Please contact the sender if you believe >> you have received this email in error. Shape Blue Ltd is a company >> incorporated in England & Wales. ShapeBlue Services India LLP is a >> company incorporated in India and is operated under license from >> Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company >> incorporated in Brasil and is operated under license from Shape Blue Ltd. >> ShapeBlue is a registered trademark. >> -- Rafael Weingärtner This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd or related companies. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales. ShapeBlue Services India LLP is a company incorporated in India and is operated under license from Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is operated under license from Shape Blue Ltd. ShapeBlue is a registered trademark.
