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