<div dir="ltr">Thanks Mark! Your solution worked!</div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-06-18 5:42 GMT-03:00 Mark Kirkwood <span dir="ltr"><<a href="mailto:mark.kirkwood@catalyst.net.nz" target="_blank">mark.kirkwood@catalyst.net.nz</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="">On 18/06/14 16:10, Raphael Ribeiro wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello, I have configured a multi node and neutron single flat network in<br>
CentOS OpenStack IceHouse version<br>
<br>
Have one controller, one compute and one network node. But when I try<br>
create a neutron network we are getting below error:<br>
<br>
</blockquote>
<br>
</div><div class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Maybe a database error?<br>
<br>
I noticed that the database does not have this table "ipallocationpools":<br>
<br>
mysql> show tables;<br>
<br>
+-----------------------+<br>
<br>
| Tables_in_neutron |<br>
<br>
+-----------------------+<br>
<br>
| agents |<br>
<br>
| alembic_version |<br>
<br>
| externalnetworks |<br>
<br>
| ml2_flat_allocations |<br>
<br>
| ml2_gre_allocations |<br>
<br>
| ml2_gre_endpoints |<br>
<br>
| ml2_network_segments |<br>
<br>
| ml2_vlan_allocations |<br>
<br>
| ml2_vxlan_allocations |<br>
<br>
| ml2_vxlan_endpoints |<br>
<br>
| networks |<br>
<br>
| ports |<br>
<br>
| quotas |<br>
<br>
| securitygrouprules |<br>
<br>
| securitygroups |<br>
<br>
| subnets |<br>
<br>
+-----------------------+<br>
<br>
16 rows in set (0.00 sec)<br>
</blockquote>
<br>
<br></div>
Yes. not enough tables! Here are mine:<br>
<br>
mysql> show tables;<br>
+-----------------------------<u></u>-+<br>
| Tables_in_neutron |<br>
+-----------------------------<u></u>-+<br>
| agents |<br>
| alembic_version |<br>
| allowedaddresspairs |<br>
| arista_provisioned_nets |<br>
| arista_provisioned_tenants |<br>
| arista_provisioned_vms |<br>
| cisco_ml2_credentials |<br>
| cisco_ml2_nexusport_bindings |<br>
| consistencyhashes |<br>
| dnsnameservers |<br>
| externalnetworks |<br>
| extradhcpopts |<br>
| floatingips |<br>
| ipallocationpools |<br>
| ipallocations |<br>
| ipavailabilityranges |<br>
| ml2_brocadenetworks |<br>
| ml2_brocadeports |<br>
| ml2_flat_allocations |<br>
| ml2_gre_allocations |<br>
| ml2_gre_endpoints |<br>
| ml2_network_segments |<br>
| ml2_port_bindings |<br>
| ml2_vlan_allocations |<br>
| ml2_vxlan_allocations |<br>
| ml2_vxlan_endpoints |<br>
| networkdhcpagentbindings |<br>
| networks |<br>
| ports |<br>
| quotas |<br>
| routerl3agentbindings |<br>
| routerroutes |<br>
| routers |<br>
| securitygroupportbindings |<br>
| securitygrouprules |<br>
| securitygroups |<br>
| servicedefinitions |<br>
| servicetypes |<br>
| subnetroutes |<br>
| subnets |<br>
+-----------------------------<u></u>-+<br>
40 rows in set (0.00 sec)<br>
<br>
I suspect you have the db connection set in the wrong file - the docs are a little light on which of the plethora of neutron files actually need it. In short *only* the plugin config does. E.g I'm using ML2 so:<br>
<br>
$ cat /etc/neutron/neutron.conf<br>
...<br>
[database]<br>
# set in plugin<br>
#connection =<br>
<br>
<br>
$ cat /etc/neutron/plugins/ml2/ml2_<u></u>conf.ini<br>
...<br>
[database]<br>
connection = mysql://<a href="http://neutron:password@127.0.0.1/neutron" target="_blank">neutron:password@127.<u></u>0.0.1/neutron</a><br>
<br>
Then (re)initialize the various db structures and restart all neutron daemons:<br>
<br>
$ neutron-db-manage --config-file /etc/neutron/neutron.conf \<br>
--config-file /etc/neutron/plugins/ml2/ml2_<u></u>conf.ini upgrade head<br>
<br>
<br>
If things are still confused, you might need to drop your existing neutron db and redo the above with a clean one!<br>
<br>
Regards<span class="HOEnZb"><font color="#888888"><br>
<br>
Mark</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
______________________________<u></u>_________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/<u></u>cgi-bin/mailman/listinfo/<u></u>openstack</a><br>
Post to : <a href="mailto:openstack@lists.openstack.org" target="_blank">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/<u></u>cgi-bin/mailman/listinfo/<u></u>openstack</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div><i><div style="display:inline!important"><span style="font-style:normal">Raphael Pereira Ribeiro</span></div></i></div><div><i>Instituto de Computação - IC/UFAL</i></div>
<div><i>Graduando em Ciências da Computação</i></div><div><font color="#0000EE"><u><a href="http://lattes.cnpq.br/9969641216207080" target="_blank"><i>http://lattes.cnpq.br/9969641216207080</i></a></u></font></div>
</div>