<div dir="ltr"><div class="gmail_quote">hi,<br><div dir="ltr"><div><div><div><div><div>i am trying to setup three node setup unfortunately we have truncated networks table in nova database from mysql . <br></div>and because of that we are facing one more error in launching instance  .<br></div>please help us to restore the networks tables for nova database .<br><br></div>we have tried uninstalling all the nova packages for controller node  and reinstalled .<br></div>even though still the networks tables for nova database is empty ..<br></div>because of this we are not able to launch the instance .<br><div><br>user@user-ThinkCentre-M73:~$ source admin-openrc.sh<br>user@user-ThinkCentre-M73:~$ neutron net-create ext-net --shared --router:external=True<br>Created a new network:<br>+---------------------------+--------------------------------------+<br>| Field                     | Value                                |<br>+---------------------------+--------------------------------------+<br>| admin_state_up            | True                                 |<br>| id                        | 5ab6836d-b04a-4d45-88ca-4ca7c3e15db5 |<br>| name                      | ext-net                              |<br>| provider:network_type     | gre                                  |<br>| provider:physical_network |                                      |<br>| provider:segmentation_id  | 1                                    |<br>| router:external           | True                                 |<br>| shared                    | True                                 |<br>| status                    | ACTIVE                               |<br>| subnets                   |                                      |<br>| tenant_id                 | 92ae5ba7cdcf41a7ac82d3c25dd209e6     |<br>+---------------------------+--------------------------------------+<br>user@user-ThinkCentre-M73:~$ neutron subnet-create ext-net --name ext-subnet --allocation-pool start=203.0.113.101,end=203.0.113.200 --disable-dhcp --gateway 203.0.113.1 <a href="http://203.0.113.0/24" target="_blank">203.0.113.0/24</a><br>Created a new subnet:<br>+------------------+----------------------------------------------------+<br>| Field            | Value                                              |<br>+------------------+----------------------------------------------------+<br>| allocation_pools | {"start": "203.0.113.101", "end": "203.0.113.200"} |<br>| cidr             | <a href="http://203.0.113.0/24" target="_blank">203.0.113.0/24</a>                                     |<br>| dns_nameservers  |                                                    |<br>| enable_dhcp      | False                                              |<br>| gateway_ip       | 203.0.113.1                                        |<br>| host_routes      |                                                    |<br>| id               | 3c2d650e-51ae-4924-989d-d881e2ebfe1b               |<br>| ip_version       | 4                                                  |<br>| name             | ext-subnet                                         |<br>| network_id       | 5ab6836d-b04a-4d45-88ca-4ca7c3e15db5               |<br>| tenant_id        | 92ae5ba7cdcf41a7ac82d3c25dd209e6                   |<br>+------------------+----------------------------------------------------+<br>user@user-ThinkCentre-M73:~$ neutron net-list<br>+--------------------------------------+----------+-----------------------------------------------------+<br>| id                                   | name     | subnets                                             |<br>+--------------------------------------+----------+-----------------------------------------------------+<br>| 5ab6836d-b04a-4d45-88ca-4ca7c3e15db5 | ext-net  | 3c2d650e-51ae-4924-989d-d881e2ebfe1b <a href="http://203.0.113.0/24" target="_blank">203.0.113.0/24</a> |<br>| a78571fd-e9fc-40ea-a488-e460b20e267a | demo-net | 0c66fbc3-edb3-4c46-b725-76443de8e570 <a href="http://192.168.1.0/24" target="_blank">192.168.1.0/24</a> |<br>+--------------------------------------+----------+-----------------------------------------------------+<br>user@user-ThinkCentre-M73:~$ nova net-list<br>+----+-------+------+<br>| ID | Label | CIDR |<br>+----+-------+------+<br>+----+-------+------+<br><br>user@user-ThinkCentre-M73:~$ source demo-openrc.sh<br>user@user-ThinkCentre-M73:~$ nova net-list<br>+----+-------+------+<br>| ID | Label | CIDR |<br>+----+-------+------+<br>+----+-------+------+<br><br></div></div>
</div><br></div>