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 >>>> >>> >>> >> >> > >
