|
|
MariaDB [neutron]> select id,mac_address,device_id from ports;$ c" X; I8 G; |0 I
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+
" L) n P" V6 d0 v" Q% N| id | mac_address | device_id |' n: q( w L+ ~3 r
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+9 \1 L# @! ?4 O, o3 I. F
| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | fa:16:3e:f3:6a:61 | 714e03e2-78a1-48e7-bdcc-98cf72012b4e |9 E' v/ T1 r$ ?/ Q" K0 q5 D
| 1a864374-7926-44d4-b047-4fe182b9788b | fa:16:3e:25:dd:bc | 35b1e14e-1b4f-46b5-8c50-871705a96b36 |: ? a6 \: C- x/ O$ `3 Y( p1 l
| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | fa:16:3e:86:3d:3f | c1487ea4-e354-45bd-97d1-d25c04186053 |
8 Z1 V8 S9 A- \5 M| 26c2b56d-03ba-4679-8b38-241cf3949645 | fa:16:3e:02:dc:f6 | 92aa63b3-ab7b-44fa-808a-d33e5f6f3253 |( q: w) P E; h1 S$ D, x
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | fa:16:3e:9e:ba:bc | 61b3ac44-6d9a-47c0-9f10-a86380552156 |+ L" ]+ F% l; H6 V7 y, Z7 h
| 2f511e86-c37f-462c-9ece-54de4ff411ac | fa:16:3e:dc:dc:b3 | bf6482f3-cbaf-4e6f-b0ae-eab1aa234a73 |
9 N8 \3 q5 C2 s4 z: M, n: `| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | fa:16:3e:ed:4c:ad | eefdc520-99d3-43ca-8d19-ee0ceb02200e |! B ]8 r+ }1 U1 I6 X5 r. C
| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | fa:16:3e:4a:47:2e | b63fa7c6-4a40-4824-9710-b1eeab2cefaf |" S+ E( S2 J! R' ?; O
| 53a87f50-41af-446c-ae4a-ef7ef0484877 | fa:16:3e:bd:5c:f5 | 87056023-5cd4-48ac-a675-d503bcb3cfb2 |
. `/ w) a$ m: O2 @$ W| 6076391e-e731-49ca-a807-947f488eafc4 | fa:16:3e:b6:e5:6f | dhcp57aa2c89-eb31-5aa6-baa3-9db19f8fe78d-4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
- m7 ^$ [. K7 Y; P [| 673ba259-1e09-446c-b401-a5d648709010 | fa:16:3e:9f:0c:be | aace037f-9503-448a-ada6-faa2fcb88540 |' p7 e- I/ B' }8 e: w, G
| 69feb745-1f87-4756-9783-018378eb93cb | fa:16:3e:14:21:5d | 905dd6ea-2b05-432a-9704-dab1f496ffcd |
( b0 w- F, P" q| 6a163325-9ca4-4aab-813a-34936495498e | fa:16:3e:ab:a5:c6 | 08331d00-0ff4-4044-9bc7-cdf6d2e1b804 |* H8 K/ E7 q! L3 r3 z x" Z- N) j
| 72247f1c-a9fa-4d61-ac9b-458f44756796 | fa:16:3e:5f:86:bc | 3f0aeeea-f232-4f5b-81b6-96b8d222630e | ]9 a1 a4 }; T$ V
| 73378cf5-f15c-4069-93d5-5db03f7a5091 | fa:16:3e:96:5b:ae | be9445cd-bdda-4d3a-969a-c3b127cd89ff |- @, m/ p8 `, O' [' D$ T
| 77113585-e4ac-4d66-b9ad-4e322a6816ce | fa:16:3e:01:33:ea | e588be3b-3765-4679-80e8-ea61dc2ad039 |
j9 r# X+ \% G N' A ]; Y3 m5 T| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | fa:16:3e:0d:fe:50 | 6626af94-61d0-4f74-948b-734c34969933 |1 k( F- L% w5 N& q. F9 f
| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | fa:16:3e:c5:26:d0 | 1119aac5-d6f4-40e4-92c1-a541ca2b5603 |: R# U; R: S0 p- ]
| 885290f6-c90e-4733-acac-ffc26bc03385 | fa:16:3e:09:b5:e6 | 9b592059-2acd-4962-ae05-dbfd8b2f2851 |
# v% g; v8 M. f, Q% W0 g| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | fa:16:3e:b4:b4:4a | fb9d360f-bf85-41d0-a11c-7da528ade98a |
9 l3 v6 p* T$ V$ ?# V| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | fa:16:3e:03:cc:9d | |
/ E: ? D+ m1 D, l| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | fa:16:3e:05:26:6f | 08b9e4e2-5594-4a07-bd79-9cc61fa109d4 |
2 B, L; Q; u; h0 E) _| a996f2df-611b-4a17-8698-155998df9638 | fa:16:3e:1a:e1:0c | 2757130d-b5ea-4a19-b8eb-5949385c8df2 |9 k* _: P% C5 [( C) \. Q
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | fa:16:3e:50:6c:e6 | 43b8d644-8ec9-4d3f-bc7d-9d1c49518c08 |3 s; m% l6 J1 I9 S
| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | fa:16:3e:fe:ba:59 | f4c09f55-2898-4961-8692-7c44fb27e070 |
8 c0 L. L1 v0 U8 C6 N8 D| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | fa:16:3e:88:34:74 | b2a989e6-c143-4dc6-88af-5a96f5b6f74e |
+ v) \# c7 H0 K: p6 K0 }| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | fa:16:3e:33:45:f1 | 4c19026c-4c62-49c2-b0b4-5f612ca2c7c8 |0 P. i/ r5 @2 x/ ^1 A
| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | fa:16:3e:0e:6e:a8 | 48c9b28d-ab90-4954-9137-1b3991744d96 |% N$ F& \# d2 ]; b) \- E
| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | fa:16:3e:b6:c4:7f | ae4ed8d3-50c1-4c6f-b04c-fc3a5083631f |
8 ~/ T- A. K# }2 H| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | fa:16:3e:e3:c0:98 | 2c37d181-9948-42ed-8a57-8636ea53964f | l7 H: h! ?0 {* _$ k
| da93c706-fccc-4400-a3a4-e3ca1b388c29 | fa:16:3e:a9:13:ac | 5975df9a-e6c9-41de-bf17-a86cd1146c79 |# Q( R( Y. T9 N3 m$ Q7 V1 F
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | fa:16:3e:d2:56:f8 | 9ba64156-7928-44ed-8a54-419b6d222c42 |
/ E$ }: r( r p8 S# `5 o* }# u/ C3 y6 H2 u| ea70424f-f8cc-4129-8447-5f94c30af872 | fa:16:3e:db:45:d5 | 1d436c7c-fad4-4ac2-b4f0-64ddb1877573 |+ g2 O; S; j9 [9 Y& D
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | fa:16:3e:9e:c8:3e | 1cd8b955-0e6d-4edc-b4e5-874e2e262321 |7 d6 h: C7 x( C2 M1 V/ C% F3 q
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | fa:16:3e:1e:96:93 | dhcpcf40685d-2640-5ca8-ae55-13e97b35a6fa-450187cb-d1db-4125-a105-740c64d2fc2d |' t3 |$ m. e- [9 \4 c, \6 i% I
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+; @5 M- `! k4 e* a i
35 rows in set (0.01 sec)
& }/ n1 \( T5 z8 ~MariaDB [neutron]> select * from portbindingports;7 E6 I% j0 Y% y. n
Empty set (0.00 sec)
d8 n+ m* y' L" z& CMariaDB [neutron]> select * from portdnses;+ O% Y, F6 v- p" @ S/ [
Empty set (0.00 sec)4 ~# X- H2 o) ~8 z& k; _; T) d
MariaDB [neutron]> select * from portsecuritybindings ;
8 z% x7 L3 [9 G5 d- K& P+--------------------------------------+-----------------------+
/ }/ e7 k$ u/ z0 Z0 @& o1 ]| port_id | port_security_enabled |
# T& N! x: |8 J3 m# u8 k7 m5 y1 q' v+--------------------------------------+-----------------------+
4 S* k2 Y. U+ P1 _| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 1 |
. {. O+ C! C! V# j* ?1 @- h, C| 1a864374-7926-44d4-b047-4fe182b9788b | 1 |- q1 z* E' l: y) K/ d/ P$ X; p
| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 1 |
" \; v2 e+ T/ q$ T& W+ e# b8 [| 26c2b56d-03ba-4679-8b38-241cf3949645 | 1 |/ N4 V% p- p& V& F+ ~
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 1 |
) ]9 q+ G( e' }6 R| 2f511e86-c37f-462c-9ece-54de4ff411ac | 1 |0 }! v5 N7 T: D: s- r
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 1 |
3 F. f7 o+ w, o4 x| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 1 |. o3 u' {( O) k# A2 G
| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 1 |
4 d" f, a" g4 p3 Z h) r6 O9 H| 6076391e-e731-49ca-a807-947f488eafc4 | 0 |4 k7 q' M$ X0 Y* w& c
| 673ba259-1e09-446c-b401-a5d648709010 | 1 |
: q [* H- X* c2 I4 T| 69feb745-1f87-4756-9783-018378eb93cb | 1 |
$ v& [# E( U$ O6 W- \- S| 6a163325-9ca4-4aab-813a-34936495498e | 1 |+ K& T! a% ~1 ]0 N5 a
| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 1 |
4 o9 ]7 e* }: t: n( I: w, }* P| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 1 |
. F( w' {) _% u; M: e| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 1 |
( o2 x* q% I% y2 X+ N3 i| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 1 |
0 v' C: I3 N g0 O: W {| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 1 |& P+ J4 v( v" h" h0 z: }
| 885290f6-c90e-4733-acac-ffc26bc03385 | 1 |# m; E: m0 O1 W2 R) ]! ^- d- l
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 1 |9 e2 ?: }9 }/ H% n9 u ]" Q+ |: }% n
| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 1 |
5 T7 J& l* k% J| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 1 |' b% t( v% Y0 ^, D# l
| a996f2df-611b-4a17-8698-155998df9638 | 1 |
; T1 r- s7 e8 ?| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 1 |
( H% F) [2 A4 \* D/ h- t3 m: W: v| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 1 |
+ n/ w1 y0 c+ [6 b2 b| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 1 |
* x; B `/ L# g5 V# Z1 J( ]| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 1 |
$ f W7 e5 u" t* @0 j! C& J8 M4 v| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 1 |5 s# i. ^) z. f" O D1 k
| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 1 |
2 B* B4 X: G% [# I| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 1 |
3 v9 }- g6 U5 ?% y2 {8 R| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 0 |! G8 H0 k: c, p; `. E
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 1 |7 W7 \, L9 q4 K/ j- P# p4 l& z
| ea70424f-f8cc-4129-8447-5f94c30af872 | 1 |$ l0 U7 d, a& w
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 1 |
. Q# p# o& \7 z0 M" U| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 1 |
, ~1 _" o% J7 u7 g# A' E+--------------------------------------+-----------------------+; G% I( c! k4 E. a! j
35 rows in set (0.00 sec)) _$ T6 h6 @, u6 y0 ^; g6 c
MariaDB [neutron]> select * from ipallocations ;
; r! |; V4 x5 q7 o2 F1 a3 e+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
+ R- f3 i4 X& ?# d2 Y5 a, F| port_id | ip_address | subnet_id | network_id |
. d: ?3 @8 p0 l5 [+--------------------------------------+----------------+--------------------------------------+--------------------------------------+- B' i4 S! c4 b; w1 Y* u
| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 10.101.102.3 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |4 z9 U, Y% `" q
| 1a864374-7926-44d4-b047-4fe182b9788b | 10.101.103.13 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 82c02dbf-e2ca-48ec-9c3f-d106ba789347 |5 R7 v/ t2 }) K& ^4 b% y
| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 10.101.102.10 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |* [: h# q+ C. I- t `; h
| 26c2b56d-03ba-4679-8b38-241cf3949645 | 10.101.104.105 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |0 T' r; e$ L% @) v3 O4 o
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 10.101.102.28 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
( c. u9 |' M1 m; W* a$ T| 2f511e86-c37f-462c-9ece-54de4ff411ac | 10.101.102.9 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |( T! k, e/ G1 i2 X# u& U1 F
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 10.101.102.5 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
6 }+ `) p" U7 c7 F! R" ^& J| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 10.101.102.6 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
, Q0 W& `( g- E* |. O| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 10.101.102.17 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |3 k' E3 Q$ [$ p, ~8 s: G" z
| 6076391e-e731-49ca-a807-947f488eafc4 | 10.101.104.2 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
2 t& q f8 r3 k. w1 o/ z| 673ba259-1e09-446c-b401-a5d648709010 | 10.101.102.34 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |7 z: v$ S: I* C! B& M6 b
| 69feb745-1f87-4756-9783-018378eb93cb | 10.101.102.23 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
6 t% u8 Q6 j/ Q) a| 6a163325-9ca4-4aab-813a-34936495498e | 10.101.102.14 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |! `' @7 k3 o2 H0 q' H+ A
| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 10.101.102.26 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
2 ?2 Z+ ~( j* D8 D; n5 d- ?| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 10.101.102.7 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
2 B, s5 S( v# P" s; X9 || 77113585-e4ac-4d66-b9ad-4e322a6816ce | 10.101.102.20 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |& e4 ~4 a3 Q& S w! A! u: v, _
| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 10.101.102.33 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
+ R( D m U# T: @| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 10.101.102.32 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |9 m% `" f# D4 Z7 `' T
| 885290f6-c90e-4733-acac-ffc26bc03385 | 10.101.102.19 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |8 V- G y( p0 W+ V
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 10.101.102.4 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
( p/ g# f8 H2 g! W0 f4 S# n/ A| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 10.101.102.2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |# _6 |- s9 b( J9 T/ u$ F# @$ D
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |) ?7 Z2 w2 Z$ |9 o i$ E$ U+ M
| a996f2df-611b-4a17-8698-155998df9638 | 10.101.102.24 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |+ A' ^' K; X8 D+ S" U
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 10.101.102.27 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |& x$ l+ O' @/ \8 o8 U2 E
| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 10.101.102.12 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
B7 D4 n2 `& z; l+ z% S/ _| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 10.101.102.15 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |' Z/ X) h! ?6 D
| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 10.101.102.18 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
3 }! E: a2 I3 W* w0 ~. s$ x. y| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 10.101.102.21 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
# f' g/ \ k* Z; F- m% L* \| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 10.101.102.8 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |. i3 F- ~/ ^& h7 G8 ~+ p+ f! X
| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 10.101.102.22 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
; [$ B( W" m4 [" |( m- i1 m4 [4 A% W| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 10.101.104.14 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
; F( V1 a& R( J1 v0 s1 d| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 10.101.102.25 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
' a$ y$ \4 f" ?! L8 |; i| ea70424f-f8cc-4129-8447-5f94c30af872 | 10.101.102.13 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |; U% |0 ?) [9 G' N1 ?8 M, Q
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 10.101.102.30 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
0 r4 r8 j9 p& }1 F- Q, z* l| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
1 f* l; A+ ?6 c% t/ m2 K/ G8 e+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
* _2 r, Q% i* E+ H. R" K: }" f35 rows in set (0.00 sec) x' B r# y( }, N; Q
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;
. H7 W1 R" M# K6 T* sEmpty set (0.01 sec)
5 i$ }5 C3 P' L/ n$ I! a% NMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1' ;, I4 |% I; N! {0 Z' u6 @ }7 o
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+
& j. Y" w E) K( ^; {, W| port_id | ip_address | subnet_id | network_id | c! Z! y8 U9 [1 w
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+! R! S2 k1 p: @' \( S
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |+ |- U' Z! z& d9 Z
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+: ]- W3 ?7 S' ^; b5 b- ?( T
1 row in set (0.00 sec)
: ^2 r2 i& R1 ]8 W: gMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.11' ;
( P# j. f. ]& @4 Z+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
5 C2 [0 }* h( g% X' G| port_id | ip_address | subnet_id | network_id |
! A7 A! f2 y* C# V' ?+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
: ~: d0 W4 w# a# q" ]) V ~+ f4 i| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |6 q5 x3 b& B! Y2 B5 Z8 e
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
& W0 e2 B; e# @1 row in set (0.00 sec)0 H j3 o; o5 f3 |9 u$ P+ z
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1*' ;. d- a, X- {) G) b- q
Empty set (0.00 sec); \0 k/ x! n( F: x7 B8 a
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;4 d9 ^. ~ C6 O9 Z% L( E
Empty set (0.00 sec)
' q: E3 F( a; F+ N" y0 M* FMariaDB [neutron]> select * from ipavailabilityrange where ip_address='10.101.102.16' ;
2 B m: H Q% Y/ jERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist
' } Q* Z! t p" D4 UMariaDB [neutron]> select * from ipavailabilityrange ;7 r% l8 M: w& M9 L0 U: \ P
ERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist
$ j' B/ m F& X* M+ i K+ fMariaDB [neutron]> select * from ipamallocationpools ;5 D+ g# B) ?0 ?( M8 L; `4 w& R: f
+--------------------------------------+--------------------------------------+----------------+----------------+" S- L3 ^% S! o0 ]- M
| id | ipam_subnet_id | first_ip | last_ip | ~% s( ~1 y; ~) A5 p1 v9 C. }1 L
+--------------------------------------+--------------------------------------+----------------+----------------+
! X5 k# p s. J7 y/ s| 9797b147-8198-4de9-9e5c-d16d84a56825 | 5711d030-3af4-48ef-8843-543af61a3cd7 | 10.101.104.1 | 10.101.104.253 |
9 }9 a7 Z9 \: L, f: v/ o5 P| c5cf06df-3015-4685-b2e3-4e21850a1012 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.1 | 10.101.103.99 |
" ~! _& n A" [$ L0 @' p& B| ca29d040-54c6-4621-a457-ac430c20d3f1 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.200 | 10.101.103.253 |5 M# a U/ n4 x
| d9474fb4-2a6a-4d84-86ae-283b06185857 | f4879db9-c192-4208-be21-2384929abaf3 | 10.101.102.1 | 10.101.102.253 |
4 X& k8 e- Z" r a% z6 w! M+--------------------------------------+--------------------------------------+----------------+----------------+
/ R$ X" e6 \6 E$ v& m4 r0 V. J) @4 rows in set (0.00 sec)
! @" x+ R& B. _- O% dMariaDB [neutron]> select * from ipallocationpools ;
& H/ D9 T" T; \+ l; o1 a+--------------------------------------+--------------------------------------+----------------+----------------+/ V# y/ x$ N) y9 R% I/ Q
| id | subnet_id | first_ip | last_ip |
. ?: f- E. x. B7 e+--------------------------------------+--------------------------------------+----------------+----------------+9 H3 z! j1 F; ]9 K; F1 v; x+ C
| 221fd87b-0556-401a-9130-dcbf45107e15 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.200 | 10.101.103.253 |
% P. C" u- y; @/ z$ f| 78fe6a3c-1ccf-4e29-9574-1942a2dd10ed | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.1 | 10.101.103.99 |
. q1 I! R" R! ^| e2587070-8def-4e55-9ffe-55a2e51cd9c1 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 10.101.104.1 | 10.101.104.253 |
7 a+ a( W/ ?8 b: `| fad83ad2-378a-47d7-aa30-bc8234cceff2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 10.101.102.1 | 10.101.102.253 | f1 ]9 y+ Y1 g, U
+--------------------------------------+--------------------------------------+----------------+----------------+
6 U7 ?0 w, O" g# r" E# p0 k' \4 rows in set (0.00 sec)
i# W3 v% m, N I" d8 P4 i h |
|
发表于 2021-11-25 00:00:08