Open Stack

Razique, thanks for the tip.
To find out which tables has the hostname set I did this:
# 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
This will print many data with the name of the tables and after all
occurrences of the HOSTNAME inside the tables.

Then I've changed all host to the correct hostname

# for i in {187..190} 193 195; do mysql -uroot -p'PASSWORD' -e "update
TABLE set host=NEW_HOSTNAME where id =$i;" nova; done

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

Thanks man! it solved my a part of my issue.



On Fri, Dec 14, 2012 at 12:59 PM, Razique Mahroua <razique.mahroua at gmail.com
> wrote:

> Check the nova database, the network tables and fixed_ip contains the
> hostname.
> Update these fields too and you should be ok :)
> (Maybe your /etc/hosts files, keystone endpoints if you used hostnames)
>
> *Razique Mahroua** - **Nuage & Co*
> razique.mahroua at gmail.com
> Tel : +33 9 72 37 94 15
>
>
> Le 14 déc. 2012 à 15:43, Gui Maluf <guimalufb at gmail.com> a écrit :
>
> Hey guys. I think I did a stupid thing.
> My setup is 1 cloudcontroller + node and 2 node with FlatDHCP, mult_host,
> net HA.
>
> 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.
>
> 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
>
> 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
>
> I couldn't found nothing wrong on logs, no errors. Anyway, here are my
> logs and setup files.
>
> controller nova.conf: http://paste.openstack.org/show/28095/
> node nova.conf: http://paste.openstack.org/show/28096/
> iptables -L -t nat + brctl show + virsh list:
> http://paste.openstack.org/show/28098/
>
> Any other information please let me know!
> I need to fix this ASAP
>
> --
> *guilherme* \n
> \t *maluf*
>
>  _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack at lists.launchpad.net
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp
>
>
>


-- 
*guilherme* \n
\t *maluf*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20121214/733d6d10/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: NUAGECO-LOGO-Fblan_petit.jpg
Type: image/jpeg
Size: 10122 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20121214/733d6d10/attachment.jpg>