Hi Jayapal, Thanks I managed to clear the table by running the following SQL command:
mysql> UPDATE op_dc_ip_address_alloc SET nic_id=NULL, reservation_id=NULL, taken=NULL; Then after I was able to change my POD IP range. Many thanks.... -----Original Message----- From: Jayapal Reddy Uradi [mailto:jayapalreddy.ur...@citrix.com] Sent: 26 March 2013 03:49 To: users@cloudstack.apache.org Subject: RE: Change IP range of POD in Cloudstack Connect to the cloudstack database in management server using 'mysql' and use the database 'cloud '. Update the entries 'op_dc_ip_address_alloc' table. Thanks, Jayapal > -----Original Message----- > From: Valery Fongang [mailto:fongang.val...@pertechtual.com] > Sent: Tuesday, March 26, 2013 12:46 AM > To: users@cloudstack.apache.org > Subject: RE: Change IP range of POD in Cloudstack > > Hi, > > Sorry I'm a newbie that appears to know how to follow instructions :-)... > Could you please send me the exact query I need to run?... > > Thanks, > > -----Original Message----- > From: Bryan Whitehead [mailto:dri...@megahappy.net] > Sent: 25 March 2013 17:40 > To: users@cloudstack.apache.org > Subject: Re: Change IP range of POD in Cloudstack > > You'll need to directly connect to the mysql database and update the record. > This can break stuff so make sure all VM's (including > systemVM's) have not already allocated IP's in the range you want to cut off. > > On Mon, Mar 25, 2013 at 5:35 AM, Valery Fongang > <fongang.val...@pertechtual.com> wrote: > > Hi, > > > > How can I change (shrink) the IP range of my POD without recreating > > the > entire POD?... When I try to edit it tells me there are IP addresses > in this POD that are already assigned. However I have deleted all > system VMs and disabled the entire zone. No user VM exists. > > > > Thanks,
