Thanks Mice, your hints very helpful. so, i end up with shortening current range to match previous total ip, then i added the rest 10 by adding new public IP range from UI.
Regards, Heince On 14-Aug-2012, at 4:07 PM, Mice Xia wrote: > Heince, > > 1) Try adding a new public IP range from UI. > 2) Or try inserting them into DB manually, a row with 'Free' state will be > your example to start off. > > Regards > Mice > > -----Original Message----- > From: heince kurniawan [mailto:hei...@gmail.com] > Sent: Tuesday, August 14, 2012 2:49 PM > To: cloudstack-users@incubator.apache.org > Subject: Re: change / replace public ip range > > Hi Mice, > > The result is not updated to my new range. > I understand from you that user_ip_address table is where CS get total public > ip. > > in that table, i see only 10 row with new ip that i've been modified(my > previous total ip is 10) instead of 20 (my new total ip). > How do i generate the rest 10 ip to that table ? > > Regards, > Heince > > > On 14-Aug-2012, at 2:24 PM, Mice Xia wrote: > >> Heince, >> >> Try executing following SQL and check the result, replace your zone id with >> 'center_id = 1'. This should give the same result as UI shows: >> >> SELECT COUNT(user_ip_address.public_ip_address) FROM user_ip_address INNER >> JOIN vlan ON user_ip_address.vlan_db_id=vlan.id WHERE >> user_ip_address.data_center_id = 1 AND (vlan.vlan_type = 'VirtualNetwork' >> ); >> >> Regards >> Mice >> >> -----Original Message----- >> From: heince kurniawan [mailto:hei...@gmail.com] >> Sent: Tuesday, August 14, 2012 1:00 PM >> To: cloudstack-users@incubator.apache.org >> Subject: Re: change / replace public ip range >> >> Hi Alena, >> >> I did it but still the total is wrong, any db table that i need to modify? >> >> Regards, >> Heince >> >> >> On 14-Aug-2012, at 3:34 AM, Alena Prokharchyk wrote: >> >>> Hi Heince, >>> >>> Execute listCapacity Api call with fetchlatest=true. It will re-calculate >>> the capacity and return you the up to date result. >>> >>> -Alena. >>> >>> On 8/13/12 12:17 PM, "heince kurniawan" <hei...@gmail.com> wrote: >>> >>>> Hi Alena, >>>> >>>> I have modified it, and router, system vms already using new ip. >>>> but the total capacity of the ip is wrong, how do i workaround this ? >>>> >>>> Regards, >>>> Heince >>>> >>>> >>>> On 14-Aug-2012, at 12:29 AM, Alena Prokharchyk wrote: >>>> >>>>> The IP address stays with the vm for the entire life cycle, till it's >>>>> expunged. >>>>> >>>>> Modifying the DB is the only one way to workaround it. But changing it >>>>> in >>>>> the user_ip_address table is not enough. You should: >>>>> >>>>> * change the record in cloud.vlan table that corresponds to ip address >>>>> range. >>>>> * Change the record in nics table for all vms nics to have new ip >>>>> address >>>>> * restart the guest network >>>>> * stop/start ALL user vms in network >>>>> >>>>> >>>>> -Alena. >>>>> >>>>> On 8/13/12 1:16 AM, "Mice Xia" <mice_...@tcloudcomputing.com> wrote: >>>>> >>>>>> In database there is a table 'user_ip_address' for public IP address >>>>>> allocation, maybe you can try changing its address and restart network >>>>>> on >>>>>> UI. >>>>>> There is also a table 'vlan', and you may want to change its >>>>>> description >>>>>> to reflect your new IP range in UI. >>>>>> >>>>>> It seems to work for trunk, not sure if it's applicable for 3.0.2. >>>>>> >>>>>> Caution: >>>>>> Don¹t forget to backup your database (or everything) before you try >>>>>> this >>>>>> workaround. >>>>>> >>>>>> Regards >>>>>> Mice >>>>>> >>>>>> -----Original Message----- >>>>>> From: heince kurniawan [mailto:hei...@gmail.com] >>>>>> Sent: Monday, August 13, 2012 12:28 PM >>>>>> To: cloudstack-users@incubator.apache.org >>>>>> Subject: change / replace public ip range >>>>>> >>>>>> Hi, >>>>>> >>>>>> I'm using CS 3.0.2 advanced networking , just changed our ISP with new >>>>>> IP >>>>>> ranges, and I'm trying to change the previous ip assignment. >>>>>> >>>>>> This is what i've done: >>>>>> - stop all vms >>>>>> - maintenance all hosts >>>>>> - destroy router and system vms >>>>>> - disable zone >>>>>> >>>>>> but i still can't delete the public ip, status : "The IP range can't be >>>>>> deleted because it has allocated public IP addresses." >>>>>> >>>>>> Even though i have destroyed router, the guest network mapping to >>>>>> public >>>>>> ip is still on state 'allocated', i can't delete the guest network : >>>>>> "Can't delete the network, not all user vms are expunged. Vm >>>>>> VM[User|i-2-7-VM] is in Stopped state" >>>>>> >>>>>> And i don't want to destroy all the vms, any workaround ? >>>>>> >>>>>> Bottom line: i just need to change the public ip range without >>>>>> destroying >>>>>> any user's vm. >>>>>> >>>>>> Regards, >>>>>> Heince >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >
