<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;">Hi All,</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">I couldn`t find this info on the web so <span style="background-color: transparent;">I created a set-by-step guide to removing orphaned floating IP addresses. Enjoy :)</span></div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;">0. Check if you have a orphaned floating ip. If you see an IP with the Instance ID <span style="background-color: transparent;">of "None", then that is the IP address you will use
below.</span></div><div style="background-color: transparent;"><span style="background-color: transparent; font-size: 16px;"># nova floating-ip-list</span><br></div><div style="background-color: transparent;">(output will look similar below)</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;">+-----------------+-------------+----------+----------------+</div><div style="background-color: transparent;">| Ip | Instance Id | Fixed Ip | Pool |</div><div style="background-color: transparent;">+-----------------+-------------+----------+----------------+</div><div style="background-color: transparent;">| 192.168.100.133 | None | None | Public Network |</div><div
style="background-color: transparent;">+-----------------+-------------+----------+----------------+</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;">Now delete the orphaned floating IP.</div><div style="background-color: transparent;">1. Login to mysql.</div><div style="background-color: transparent;"># mysql -u username -p</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;">2. List your databases if you want.</div><div style="background-color: transparent;"># show databases;</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;">3. Switch to use the ovs_quantum database.</div><div style="background-color: transparent;">mysql> use ovs_quantum; </div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;">4. Show the values in the table floatingips. Take
note of the column name (floating_ip_address<span style="background-color: transparent;">) for the orphaned IP</span></div><div style="background-color: transparent;">mysql> SELECT * FROM floatingips; (Show the table contents)</div><div style="background-color: transparent;">mysql> DELETE FROM floatingips WHERE floating_ip_address="192.168.100.133"; (insert your ip address withing the quotes)</div><div style="background-color: transparent;">mysql> SELECT * FROM floatingips; (confirm the row was deleted)</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;">5. Show the values in the table ipallocations. Take note of the column name (ip_address<span style="background-color: transparent;">)</span><span style="background-color: transparent;"> for the orphaned IP</span></div><div style="background-color: transparent;">mysql> SELECT * FROM ipallocations; (Show the table
contents)</div><div style="background-color: transparent;">mysql> DELETE FROM ipallocations WHERE ip_address="192.168.100.133"; (insert your ip address withing the quotes)</div><div style="background-color: transparent;">mysql> SELECT * FROM ipallocations; (confirm the row was deleted)</div><div style="background-color: transparent;"> </div><div style="background-color: transparent;">6. Next login to the Openstack Dashboard and delete the port for the network containing the orphaned floating IP. </div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;">In my case I deleted the whole subnet because the DHCP server does not release the IP pack in the pool unless you do this.</div><div style="background-color: transparent;">You can see this in the table ipavailabilityranges. once you delete the subnet the values clear out. </div><div style="background-color: transparent;">This last
part will only work if you <span style="background-color: transparent;">have no more instances connected to this subnet.</span></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;"><span style="background-color: transparent;">Those who are good at sql commands could figure out how to modify the IP range in the </span>ipavailabilityranges tables to release the IP back</div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;">to the dhcp server.</div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;"><br></div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;">Hope that helps
others with the same issue.</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;">Best,</div><div style="background-color: transparent;">Jake</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; background-color: transparent;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size:
12pt;"><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> laserjetyang <laserjetyang@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> Jake G. <dj_dark_junglist@yahoo.com> <br><b><span style="font-weight: bold;">Cc:</span></b> "openstack@lists.launchpad.net" <openstack@lists.launchpad.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, July 19, 2013 2:42 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Openstack] Delete orphaned floating ip<br> </font> </div> <div class="y_msg_container"><br><div id="yiv5206891541"><div dir="ltr">I will do it by entering database<br></div><div class="yiv5206891541gmail_extra"><br><br><div
class="yiv5206891541gmail_quote">On Fri, Jul 19, 2013 at 1:21 PM, Jake G. <span dir="ltr"><<a rel="nofollow" ymailto="mailto:dj_dark_junglist@yahoo.com" target="_blank" href="mailto:dj_dark_junglist@yahoo.com">dj_dark_junglist@yahoo.com</a>></span> wrote:<br>
<blockquote class="yiv5206891541gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif;"><div style="font-size:12pt;">
Hi all,</div><div style="font-size:12pt;"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;">
I have a orphaned floating IP I am unable to delete.</div><div style="font-style:normal;font-size:16px;background-color:transparent;"><br></div><div style="background-color:transparent;">
<font face="times new roman, new york, times, serif"># nova floating-ip-list</font></div><div style="background-color:transparent;"><font face="times new roman, new york, times,
serif">+-----------------+-------------+----------+----------------+</font></div><div style="background-color:transparent;"><font face="times new roman, new york, times, serif">| Ip | Instance Id | Fixed Ip | Pool |</font></div>
<div style="background-color:transparent;"><font face="times new roman, new york, times, serif">+-----------------+-------------+----------+----------------+</font></div><div style="background-color:transparent;"><font face="times new roman, new york, times, serif">| 192.168.100.133 | None | None | Public Network |</font></div>
<div style="font-style:normal;font-size:16px;background-color:transparent;"><font face="times new roman, new york, times, serif"><br></font></div><div style="font-style:normal;font-size:16px;background-color:transparent;">
<font face="times new roman, new york, times, serif">Is there a way to delete this manually?</font></div><div style="font-style:normal;font-size:16px;background-color:transparent;">
<font face="times new roman, new york, times, serif"><br></font></div><div style="font-style:normal;font-size:16px;background-color:transparent;"><font face="times new roman, new york, times, serif">Thanks,</font></div>
<div style="font-style:normal;font-size:16px;background-color:transparent;"><font face="times new roman, new york, times, serif">Jake</font></div><div style="font-style:normal;font-size:16px;background-color:transparent;">
<font face="times new roman, new york, times, serif"><br></font></div></div></div><br>_______________________________________________<br>
Mailing list: <a rel="nofollow" target="_blank" href="https://launchpad.net/~openstack">https://launchpad.net/~openstack</a><br>
Post to : <a rel="nofollow" ymailto="mailto:openstack@lists.launchpad.net" target="_blank" href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
Unsubscribe : <a rel="nofollow" target="_blank" href="https://launchpad.net/~openstack">https://launchpad.net/~openstack</a><br>
More help : <a rel="nofollow" target="_blank" href="https://help.launchpad.net/ListHelp">https://help.launchpad.net/ListHelp</a><br>
<br></blockquote></div><br></div></div><br><br></div> </div> </div> </div></body></html>