Enter password:
mysql> connect ovs_neutron;
mysql> show tables;
+---------------------------+
| Tables_in_ovs_neutron |
+---------------------------+
| agents |
| alembic_version |
| allowedaddresspairs |
| dnsnameservers |
| externalnetworks |
| extradhcpopts |
| floatingips |
| ipallocationpools |
| ipallocations |
| ipavailabilityranges |
| networkdhcpagentbindings |
| networks |
| ovs_network_bindings |
| ovs_tunnel_allocations |
| ovs_tunnel_endpoints |
| ovs_vlan_allocations |
| portbindingports |
| ports |
| quotas |
| routerl3agentbindings |
| routerroutes |
| routers |
| securitygroupportbindings |
| securitygrouprules |
| securitygroups |
| servicedefinitions |
| servicetypes |
| subnetroutes |
| subnets |
+---------------------------+
mysql> desc floatingips;
+----------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| tenant_id | varchar(255) | YES | | NULL | |
| id | varchar(36) | NO | PRI | NULL | |
| floating_ip_address | varchar(64) | NO | | NULL | |
| floating_network_id | varchar(36) | NO | | NULL | |
| floating_port_id | varchar(36) | NO | MUL | NULL | |
| fixed_port_id | varchar(36) | YES | MUL | NULL | |
| fixed_ip_address | varchar(64) | YES | | NULL | |
| router_id | varchar(36) | YES | MUL | NULL | |
| last_known_router_id | varchar(36) | YES | | NULL | |
| status | varchar(16) | YES | | NULL | |
+----------------------+--------------+------+-----+---------+-------+
mysql> select floating_ip_address from floatingips;
+---------------------+
| floating_ip_address |
+---------------------+
| 172.24.4.236 |
| 172.24.4.231 |
| 172.24.4.232 |
+---------------------+
No comments:
Post a Comment