Razique, thanks for the tip.<br>To find out which tables has the hostname set I did this:<br># for i in `mysql -uroot -p'PASSWORD' -e 'show tables;' nova | grep -v -e '+' -e 'T'`; do echo $i && mysql -uroot -p'PASSWORD' -e "select * from $i";' nova | grep OLD_HOSTNAME; done<br>
This will print many data with the name of the tables and after all occurrences of the HOSTNAME inside the tables.<br><br>Then I've changed all host to the correct hostname<br><br># for i in {187..190} 193 195; do mysql -uroot -p'PASSWORD' -e "update TABLE set host=NEW_HOSTNAME where id =$i;" nova; done<br>
<br>i.e: # for i in {187..190} 193 195; do mysql -uroot -p'PASSWORD' -e "update floating_ips set host='oxala' where id =$i;" nova; done<br><br>Thanks man! it solved my a part of my issue.<br><br>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Dec 14, 2012 at 12:59 PM, Razique Mahroua <span dir="ltr"><<a href="mailto:razique.mahroua@gmail.com" target="_blank">razique.mahroua@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Check the nova database, the network tables and fixed_ip contains the hostname.<div>
Update these fields too and you should be ok :)</div>
<div>(Maybe your /etc/hosts files, keystone endpoints if you used hostnames)</div><div><br><div>
<span style="border-spacing:0px;text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:'Lucida Grande';word-spacing:0px"><span style="font-weight:normal;font-family:Helvetica"><b style="color:rgb(19,112,138)">Razique Mahroua</b></span><span style="font-weight:normal;font-family:Helvetica;color:rgb(19,112,138)"><b> - </b></span><span style="font-family:Helvetica"><span style="font-weight:normal;font-family:Helvetica"><b style="color:rgb(19,112,138)">Nuage & Co</b></span><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px;font-size:medium"><span style="border-spacing:0px;text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><span style="border-collapse:separate;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px"><div style="font-style:normal;font-size:medium;font-family:Helvetica;font-weight:normal">
<font color="#13708a"><a href="mailto:razique.mahroua@gmail.com" target="_blank">razique.mahroua@gmail.com</a></font></div><div style="font-style:normal;font-size:medium;font-family:Helvetica"><font color="#13708a">Tel : +33 9 72 37 94 15</font></div>
</span><br><span></span><span style="font-style:normal;font-size:medium;font-family:Helvetica;font-weight:normal"></span><span style="font-weight:normal"></span></span><span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><span><span><span><img src="cid:00E07450-433E-43E6-9005-48B8FD5C669F@la.fabrique" height="125" width="125"></span>
</span></span></span></span></span></span></div>
<br><div><div>Le 14 déc. 2012 à 15:43, Gui Maluf <<a href="mailto:guimalufb@gmail.com" target="_blank">guimalufb@gmail.com</a>> a écrit :</div><br><blockquote type="cite"><div><div class="h5">Hey guys. I think I did a stupid thing.<br>
My setup is 1 cloudcontroller + node and 2 node with FlatDHCP, mult_host, net HA.<br><br>Recently I've changed the hostname of my cloudcontroller; to make things consistent I've updated the services table inside nova db to mark as deleted=1 the lines where host=oldhostname.<br>
<br>I dont know what happened because now nothing of the nova-network works. It doesn't create br100 anymore, neither iptables rules of SNAT and DNAT<br><br>The worse thing about that problem, is that this is production setup. All my instances from the cloudcontroller are unavaible cause of this. Nodes are creating everything regularly<br>
<br>I couldn't found nothing wrong on logs, no errors. Anyway, here are my logs and setup files.<br><br>controller nova.conf: <a href="http://paste.openstack.org/show/28095/" target="_blank">http://paste.openstack.org/show/28095/</a><br>
node nova.conf: <a href="http://paste.openstack.org/show/28096/" target="_blank">http://paste.openstack.org/show/28096/</a><br>iptables -L -t nat + brctl show + virsh list: <a href="http://paste.openstack.org/show/28098/" target="_blank">http://paste.openstack.org/show/28098/</a><br>
<br>Any other information please let me know!<div>I need to fix this ASAP<br><br>-- <br><font face="Arial, Helvetica, sans-serif"><b>guilherme</b> \n<br>\<font>t</font> <b>maluf</b><br></font><br>
</div></div></div>
_______________________________________________<br>Mailing list: <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>Post to : <a href="mailto:openstack@lists.launchpad.net" target="_blank">openstack@lists.launchpad.net</a><br>
Unsubscribe : <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
</blockquote></div><br></div></div></blockquote></div><br><br clear="all"><br>-- <br><font face="Arial, Helvetica, sans-serif"><b>guilherme</b> \n<br>\<font>t</font> <b>maluf</b><br></font><br>
</div>