cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From heince kurniawan <hei...@gmail.com>
Subject Re: change / replace public ip range
Date Tue, 14 Aug 2012 06:48:41 GMT
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:heince@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" <heince@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_xia@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:heince@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
>>>>> 
>>>> 
>>>> 
>>> 
>>> 
>> 
>> 
> 


Mime
View raw message