You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@cloudstack.apache.org by raja sekhar <ra...@gmail.com> on 2015/05/12 00:36:28 UTC

Public IP Missing.

Hi All,

I have created a shared network in ACS 4.3.1.
When ever i want to remove the network from UI, it is showing error unable
to remove network. There are no vm's under this network.
I tried to remove the network from backend by executing these commands in
DB.

update networks set state='Destroy',removed=now() where id=315;
update vm_instance set state='Stopped' where id=393;
update vm_instance set removed=now() where id=393;
update domain_router set public_ip_address='NULL' where id=393;
update nics set state='Deallocating' where id=747;
update nics set removed=now() where id=747;

Now the network is removed from ui, but the public ip is not getting free.
what is the procedure and commands to be executed in order to free the
public ip from backend.


Regards,
Rajasekhar.

Re: Public IP Missing.

Posted by raja sekhar <ra...@gmail.com>.

Thanks to all, the IP is free now.

Regards,
Rajasekhar.

On Tue, May 12, 2015 at 1:04 AM, anil lakineni <
anilkumar459.lakineni@gmail.com> wrote:

> Hi Sanjeev and Jayapal,
>
> Thanks it is working, I got my IP back.
>
> Thanks,
> Anil.
>
> On Tue, May 12, 2015 at 9:45 AM, Jayapal Reddy Uradi <
> jayapalreddy.uradi@citrix.com> wrote:
>
> > Hi Rajsekhar,
> >
> > Try setting public ip address table columns state=Free, removed=<date>
> and
> > allocated=null.
> >
> > Thanks,
> > Jayapal
> >
> > On 12-May-2015, at 4:06 AM, raja sekhar <ra...@gmail.com> wrote:
> >
> > > Hi All,
> > >
> > > I have created a shared network in ACS 4.3.1.
> > > When ever i want to remove the network from UI, it is showing error
> > unable
> > > to remove network. There are no vm's under this network.
> > > I tried to remove the network from backend by executing these commands
> in
> > > DB.
> > >
> > > update networks set state='Destroy',removed=now() where id=315;
> > > update vm_instance set state='Stopped' where id=393;
> > > update vm_instance set removed=now() where id=393;
> > > update domain_router set public_ip_address='NULL' where id=393;
> > > update nics set state='Deallocating' where id=747;
> > > update nics set removed=now() where id=747;
> > >
> > > Now the network is removed from ui, but the public ip is not getting
> > free.
> > > what is the procedure and commands to be executed in order to free the
> > > public ip from backend.
> > >
> > >
> > > Regards,
> > > Rajasekhar.
> >
> >
>

Re: Public IP Missing.

Posted by anil lakineni <an...@gmail.com>.

Hi Sanjeev and Jayapal,

Thanks it is working, I got my IP back.

Thanks,
Anil.

On Tue, May 12, 2015 at 9:45 AM, Jayapal Reddy Uradi <
jayapalreddy.uradi@citrix.com> wrote:

> Hi Rajsekhar,
>
> Try setting public ip address table columns state=Free, removed=<date> and
> allocated=null.
>
> Thanks,
> Jayapal
>
> On 12-May-2015, at 4:06 AM, raja sekhar <ra...@gmail.com> wrote:
>
> > Hi All,
> >
> > I have created a shared network in ACS 4.3.1.
> > When ever i want to remove the network from UI, it is showing error
> unable
> > to remove network. There are no vm's under this network.
> > I tried to remove the network from backend by executing these commands in
> > DB.
> >
> > update networks set state='Destroy',removed=now() where id=315;
> > update vm_instance set state='Stopped' where id=393;
> > update vm_instance set removed=now() where id=393;
> > update domain_router set public_ip_address='NULL' where id=393;
> > update nics set state='Deallocating' where id=747;
> > update nics set removed=now() where id=747;
> >
> > Now the network is removed from ui, but the public ip is not getting
> free.
> > what is the procedure and commands to be executed in order to free the
> > public ip from backend.
> >
> >
> > Regards,
> > Rajasekhar.
>
>

Re: Public IP Missing.

Posted by Jayapal Reddy Uradi <ja...@citrix.com>.

Hi Rajsekhar,

Try setting public ip address table columns state=Free, removed=<date> and allocated=null.

Thanks,
Jayapal 

On 12-May-2015, at 4:06 AM, raja sekhar <ra...@gmail.com> wrote:

> Hi All,
> 
> I have created a shared network in ACS 4.3.1.
> When ever i want to remove the network from UI, it is showing error unable
> to remove network. There are no vm's under this network.
> I tried to remove the network from backend by executing these commands in
> DB.
> 
> update networks set state='Destroy',removed=now() where id=315;
> update vm_instance set state='Stopped' where id=393;
> update vm_instance set removed=now() where id=393;
> update domain_router set public_ip_address='NULL' where id=393;
> update nics set state='Deallocating' where id=747;
> update nics set removed=now() where id=747;
> 
> Now the network is removed from ui, but the public ip is not getting free.
> what is the procedure and commands to be executed in order to free the
> public ip from backend.
> 
> 
> Regards,
> Rajasekhar.

Re: Public IP Missing.

Posted by Sanjeev N <sa...@apache.org>.

update user_ip_address set allocated=NULL where id=<id>

On Tue, May 12, 2015 at 9:04 AM, ilya <il...@gmail.com> wrote:

> Have you destroyed router vm for this network?
>
> I'd instead try to identify what holds up the network instead of deleting
> by force.
>
>
> On 5/11/15 3:36 PM, raja sekhar wrote:
>
>> Hi All,
>>
>> I have created a shared network in ACS 4.3.1.
>> When ever i want to remove the network from UI, it is showing error unable
>> to remove network. There are no vm's under this network.
>> I tried to remove the network from backend by executing these commands in
>> DB.
>>
>> update networks set state='Destroy',removed=now() where id=315;
>> update vm_instance set state='Stopped' where id=393;
>> update vm_instance set removed=now() where id=393;
>> update domain_router set public_ip_address='NULL' where id=393;
>> update nics set state='Deallocating' where id=747;
>> update nics set removed=now() where id=747;
>>
>> Now the network is removed from ui, but the public ip is not getting free.
>> what is the procedure and commands to be executed in order to free the
>> public ip from backend.
>>
>>
>> Regards,
>> Rajasekhar.
>>
>>
>

Re: Public IP Missing.

Posted by ilya <il...@gmail.com>.

Have you destroyed router vm for this network?

I'd instead try to identify what holds up the network instead of 
deleting by force.

On 5/11/15 3:36 PM, raja sekhar wrote:
> Hi All,
>
> I have created a shared network in ACS 4.3.1.
> When ever i want to remove the network from UI, it is showing error unable
> to remove network. There are no vm's under this network.
> I tried to remove the network from backend by executing these commands in
> DB.
>
> update networks set state='Destroy',removed=now() where id=315;
> update vm_instance set state='Stopped' where id=393;
> update vm_instance set removed=now() where id=393;
> update domain_router set public_ip_address='NULL' where id=393;
> update nics set state='Deallocating' where id=747;
> update nics set removed=now() where id=747;
>
> Now the network is removed from ui, but the public ip is not getting free.
> what is the procedure and commands to be executed in order to free the
> public ip from backend.
>
>
> Regards,
> Rajasekhar.
>