The tables that you updated the account_id I totally understand why you did that, but, why did you update the network_id on networks and network_map?
On Mon, Jan 20, 2014 at 8:33 AM, Geoff Higginbottom <geoff.higginbot...@shapeblue.com> wrote: > 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. -- Rafael Weingärtner