Hi Ozhan, You can use following query to update the nics table: update nics set removed=now() where id=<replace nic id with id of the nic>;
If you already have router with XX.XX.XX.15 iP address don't have to do anything. Otherwise restart router. Best Regards, Sanjeev N Chief Product Engineer, Accelerite Off: +91 40 6722 9368 | EMail: [email protected] -----Original Message----- From: Özhan Rüzgar Karaman [mailto:[email protected]] Sent: Wednesday, May 18, 2016 5:31 PM To: [email protected] Subject: Re: Problem Releasing of Previously Allocated IP Address Hi Sanjeev; I checked the nics table and it looks like it has 2 ip addresses for DomainRouter vm_type. Domain router is working with x.x.x.15 ip address and it looks like x.x.x.5 ip should be marked as removed. Whats the sql statement to mark x.x.x.5 ip to be marked as removed? Also after removing ip do i need to make any further actions? Below i am sending the sql output of nics table. Thanks for all help! Regards Özhan mysql> select id,instance_id,ip4_address,state,strategy,reserver_name,reservation_id,vm_type,created,removed from nics where vm_type = 'DomainRouter'; +-----+-------------+----------------+--------------+-------------+--------------------+--------------------------------------+--------------+---------------------+---------------------+ | id | instance_id | ip4_address | state | strategy | reserver_name | reservation_id | vm_type | created | removed | +-----+-------------+----------------+--------------+-------------+--------------------+--------------------------------------+--------------+---------------------+---------------------+ | 20 | NULL | xxx.xxx.xxx.5 | Reserved | PlaceHolder | NULL | NULL | DomainRouter | 2016-05-05 15:26:56 | NULL | | 21 | 8 | xxx.xxx.xxx.5 | Deallocating | Create | DirectNetworkGuru | NULL | DomainRouter | 2016-05-05 15:26:56 | 2016-05-10 08:06:29 | | 22 | 8 | NULL | Deallocating | Start | ControlNetworkGuru | 956bfd7e-b451-40a5-9c36-410a1baf658a | DomainRouter | 2016-05-05 15:26:57 | 2016-05-10 08:06:29 | | 106 | 88 | xxx.xxx.xxx.15 | Deallocating | Create | DirectNetworkGuru | NULL | DomainRouter | 2016-05-10 08:06:41 | 2016-05-10 08:18:19 | | 107 | 88 | NULL | Deallocating | Start | ControlNetworkGuru | 21e67876-57d0-45da-8cd9-bf1bbda79aec | DomainRouter | 2016-05-10 08:06:41 | 2016-05-10 08:18:19 | | 114 | 91 | xxx.xxx.xxx.15 | Reserved | Create | DirectNetworkGuru | NULL | DomainRouter | 2016-05-10 08:20:07 | NULL | | 115 | 91 | 169.254.3.100 | Reserved | Start | ControlNetworkGuru | 774ea7ff-1e5a-4f59-bccd-72cbbb266e89 | DomainRouter | 2016-05-10 08:20:07 | NULL | +-----+-------------+----------------+--------------+-------------+--------------------+--------------------------------------+--------------+---------------------+---------------------+ 7 rows in set (0.00 sec) On Fri, May 13, 2016 at 4:33 PM, Sanjeev Neelarapu < [email protected]> wrote: > Please check the nics table with the network id. I guess it will have > two ip addresses for vm_type DomainRouter. If that is the case one > entry needs to be marked as removed. > > Best Regards, > Sanjeev N > Chief Product Engineer, Accelerite > Off: +91 40 6722 9368 | EMail: [email protected] > > > > -----Original Message----- > From: Özhan Rüzgar Karaman [mailto:[email protected]] > Sent: Friday, May 13, 2016 1:19 PM > To: [email protected] > Subject: Re: Problem Releasing of Previously Allocated IP Address > > Hi Sanjeev; > If i mark that ip state to Null, what will happen for > defaultDns":"x.x.x.5 entry in > com.cloud.agent.api.routing.DhcpEntryCommand ? Do you know where Router VM > DhcpEntryCommand gets its defaultDns value? > > Thanks > Özhan > > On Fri, May 13, 2016 at 10:10 AM, Sanjeev Neelarapu < > [email protected]> wrote: > > > You can file a bug for it. Router vm should not get different IP in > > shared network. One way is to DB hack. Mark the allocated state to > > null in user_ip_address table for the IPs which are not in use. > > > > Best Regards, > > Sanjeev N > > Chief Product Engineer, Accelerite > > Off: +91 40 6722 9368 | EMail: [email protected] > > > > > > > > -----Original Message----- > > From: Özhan Rüzgar Karaman [mailto:[email protected]] > > Sent: Friday, May 13, 2016 12:13 PM > > To: [email protected] > > Subject: Re: Problem Releasing of Previously Allocated IP Address > > > > Hi; > > But in my situation router vm gets different ip address after i > > destroyed it. I could not delete that C class network there are some > > active vm's on that network. > > > > Thanks > > Özhan > > > > On Thu, May 12, 2016 at 5:21 PM, Sanjeev Neelarapu < > > [email protected]> wrote: > > > > > Router vm gets the same ip address even after destroying and > > > recreating it. Since CS does not have a mechanism to notify the > > > router vm after for existing guest vms it won't change the IP > > > address. ASAIK the IP will be released only after deleting that > network. > > > > > > Best Regards, > > > Sanjeev N > > > Chief Product Engineer, Accelerite > > > Off: +91 40 6722 9368 | EMail: [email protected] > > > > > > > > > -----Original Message----- > > > From: Özhan Rüzgar Karaman [mailto:[email protected]] > > > Sent: Wednesday, May 11, 2016 8:35 PM > > > To: [email protected] > > > Subject: Problem Releasing of Previously Allocated IP Address > > > > > > Hi; > > > I have setup of advanced networking with security groups enabled. > > > Yesterday i destroyed and restarted router-vm and after that i > > > noticed that from the CloudStack dashboard on Shared Network IP's > > > there is one more extra ip address allocated then its expected. > > > > > > I checked mysql db (select * from user_ip_address where > > > state="Allocated";) to see which ip addresses are allocated and i > > > noticed that there is an ip address like x.x.x.5 is allocated but > > > its not used by any vm or systemvm's. > > > > > > After that i check management server log and i noticed that this > > > ip is high probably router vm's previous ip address. Because on > > > management server log i noticed lines like below: > > > > > > 2016-05-11 16:54:54,374 DEBUG [c.c.a.t.Request] > > > (Work-Job-Executor-116:ctx-19aae9a4 job-1302/job-1303 > > > ctx-eb95bef0) > > > (logid:7f64e204) Seq 10-1563030545674275235: Sending { Cmd , MgmtId: > > > 345050167520, via: 10(kvma16), Ver: v1, Flags: 100011, > > > > > > [{"com.cloud.agent.api.routing.DhcpEntryCommand":{"vmMac":"06:49:d6:00:00:03","vmIpAddress":"x.x.x.4","vmName":"win10CreateTemp444","defaultRouter":"x.x.x.1","defaultDns":"x.x.x.5","duid":"00:00:00:00:00:00:xx:00:00:03","isDefault":true,"executeInSequence":false,"accessDetails":{"zone.network.type":"Advanced","router.guest.ip":"x.x.x.15","router.ip":"169.254.3.100"," > > > router.name":"r-91-VM"},"wait":0}}] } > > > > > > So the suspicious ip address is written in "defaultDns":"x.x.x.5" > > > field and its not correct. I am not currently using dhcp addresses > > > which CloudStack provides but 1 of my ip addresses are gone :) > > > > > > So why this could happen is this be a bug? > > > > > > I also checked logs that defaultDns entry is sometimes correct > > > routervm > > > ip(x.x.x.15) and sometimes old router vm's ip (x.x.x.5). > > > > > > Thanks > > > Özhan Rüzgar Karaman > > > > > > > > > > > > DISCLAIMER > > > ========== > > > This e-mail may contain privileged and confidential information > > > which is the property of Accelerite, a Persistent Systems business. > > > It is intended only for the use of the individual or entity to > > > which it is addressed. If you are not the intended recipient, you > > > are not authorized to read, retain, copy, print, distribute or use > > > this message. If you have received this communication in error, > > > please notify the sender and delete all copies of this message. > > > Accelerite, a Persistent Systems business does not accept any > > > liability for virus > > infected mails. > > > > > > > > > > > DISCLAIMER > > ========== > > This e-mail may contain privileged and confidential information > > which is the property of Accelerite, a Persistent Systems business. > > It is intended only for the use of the individual or entity to which > > it is addressed. If you are not the intended recipient, you are not > > authorized to read, retain, copy, print, distribute or use this > > message. If you have received this communication in error, please > > notify the sender and delete all copies of this message. Accelerite, > > a Persistent Systems business does not accept any liability for > > virus > infected mails. > > > > > > DISCLAIMER > ========== > This e-mail may contain privileged and confidential information which > is the property of Accelerite, a Persistent Systems business. It is > intended only for the use of the individual or entity to which it is > addressed. If you are not the intended recipient, you are not > authorized to read, retain, copy, print, distribute or use this > message. If you have received this communication in error, please > notify the sender and delete all copies of this message. Accelerite, a > Persistent Systems business does not accept any liability for virus infected > mails. > DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Accelerite, a Persistent Systems business. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Accelerite, a Persistent Systems business does not accept any liability for virus infected mails.
