|
|
MariaDB [neutron]> select id,mac_address,device_id from ports;
" u! h1 b$ f0 T3 I* A+--------------------------------------+-------------------+-------------------------------------------------------------------------------+
( ^& Y2 B+ l' E+ c| id | mac_address | device_id |" f+ l3 |8 k: A4 L
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+
7 T1 ]) f" s- l, F0 ~% ]| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | fa:16:3e:f3:6a:61 | 714e03e2-78a1-48e7-bdcc-98cf72012b4e |( v2 E- ` `, y% w5 h4 F
| 1a864374-7926-44d4-b047-4fe182b9788b | fa:16:3e:25:dd:bc | 35b1e14e-1b4f-46b5-8c50-871705a96b36 |
' E( s) M8 H$ `6 r% U9 g2 G; `| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | fa:16:3e:86:3d:3f | c1487ea4-e354-45bd-97d1-d25c04186053 |
+ C1 ]6 R, J" m. g9 D( `( @; i| 26c2b56d-03ba-4679-8b38-241cf3949645 | fa:16:3e:02:dc:f6 | 92aa63b3-ab7b-44fa-808a-d33e5f6f3253 |( K1 ^# u) C5 o6 h) v
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | fa:16:3e:9e:ba:bc | 61b3ac44-6d9a-47c0-9f10-a86380552156 |- p% }3 J% b0 O/ o. b6 e4 e7 E0 D
| 2f511e86-c37f-462c-9ece-54de4ff411ac | fa:16:3e:dc:dc:b3 | bf6482f3-cbaf-4e6f-b0ae-eab1aa234a73 |
. A- T+ |6 k) I l% r& [ a" N: S1 _+ k| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | fa:16:3e:ed:4c:ad | eefdc520-99d3-43ca-8d19-ee0ceb02200e |
4 J0 f! T# k$ `+ [| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | fa:16:3e:4a:47:2e | b63fa7c6-4a40-4824-9710-b1eeab2cefaf |
0 w( c- m! ?+ [, u| 53a87f50-41af-446c-ae4a-ef7ef0484877 | fa:16:3e:bd:5c:f5 | 87056023-5cd4-48ac-a675-d503bcb3cfb2 |
9 d: y' U2 S7 x0 ]- q8 O' A$ W4 E| 6076391e-e731-49ca-a807-947f488eafc4 | fa:16:3e:b6:e5:6f | dhcp57aa2c89-eb31-5aa6-baa3-9db19f8fe78d-4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
1 f4 c, F' z$ t& `| 673ba259-1e09-446c-b401-a5d648709010 | fa:16:3e:9f:0c:be | aace037f-9503-448a-ada6-faa2fcb88540 |
" V6 j6 W2 m' D* Z* d| 69feb745-1f87-4756-9783-018378eb93cb | fa:16:3e:14:21:5d | 905dd6ea-2b05-432a-9704-dab1f496ffcd |
4 O. D- Z4 T2 } _" ~# B2 G| 6a163325-9ca4-4aab-813a-34936495498e | fa:16:3e:ab:a5:c6 | 08331d00-0ff4-4044-9bc7-cdf6d2e1b804 |
$ Z: d) e3 i2 P6 d& k| 72247f1c-a9fa-4d61-ac9b-458f44756796 | fa:16:3e:5f:86:bc | 3f0aeeea-f232-4f5b-81b6-96b8d222630e |
0 q! Q! d1 V e. _# _* Z| 73378cf5-f15c-4069-93d5-5db03f7a5091 | fa:16:3e:96:5b:ae | be9445cd-bdda-4d3a-969a-c3b127cd89ff |
& R8 @2 x; B! v( x5 c2 e4 H: ]| 77113585-e4ac-4d66-b9ad-4e322a6816ce | fa:16:3e:01:33:ea | e588be3b-3765-4679-80e8-ea61dc2ad039 |
# s) G& I6 I+ r5 d; t| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | fa:16:3e:0d:fe:50 | 6626af94-61d0-4f74-948b-734c34969933 |2 D2 F) W# x O/ j+ O+ d
| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | fa:16:3e:c5:26:d0 | 1119aac5-d6f4-40e4-92c1-a541ca2b5603 |
" B8 {- r* g9 p; _% Z3 v| 885290f6-c90e-4733-acac-ffc26bc03385 | fa:16:3e:09:b5:e6 | 9b592059-2acd-4962-ae05-dbfd8b2f2851 |5 U8 \9 k7 I( \0 b. m7 B% c& v
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | fa:16:3e:b4:b4:4a | fb9d360f-bf85-41d0-a11c-7da528ade98a |8 k' T7 j: g' I8 n* J2 y
| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | fa:16:3e:03:cc:9d | |
+ ], f1 E6 x" c* ~; S| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | fa:16:3e:05:26:6f | 08b9e4e2-5594-4a07-bd79-9cc61fa109d4 |, E) k' w- u' g- R2 I& O
| a996f2df-611b-4a17-8698-155998df9638 | fa:16:3e:1a:e1:0c | 2757130d-b5ea-4a19-b8eb-5949385c8df2 |) Q i/ Z. o6 i8 g/ c
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | fa:16:3e:50:6c:e6 | 43b8d644-8ec9-4d3f-bc7d-9d1c49518c08 |
+ r5 O8 n5 d$ ^5 ?+ ^8 @, z* m| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | fa:16:3e:fe:ba:59 | f4c09f55-2898-4961-8692-7c44fb27e070 |0 z" N6 h2 c0 e1 { _. A
| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | fa:16:3e:88:34:74 | b2a989e6-c143-4dc6-88af-5a96f5b6f74e |
. @. d/ ?; Z3 Y" x| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | fa:16:3e:33:45:f1 | 4c19026c-4c62-49c2-b0b4-5f612ca2c7c8 |
- z4 V2 t, G) w1 X0 W9 l) Z, e4 w| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | fa:16:3e:0e:6e:a8 | 48c9b28d-ab90-4954-9137-1b3991744d96 |9 \/ a/ H; r m! Q" a1 G- ?: n! o
| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | fa:16:3e:b6:c4:7f | ae4ed8d3-50c1-4c6f-b04c-fc3a5083631f |
1 w! [' Y0 K9 F+ ]| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | fa:16:3e:e3:c0:98 | 2c37d181-9948-42ed-8a57-8636ea53964f |! a$ N2 F( i) y( D/ h( i
| da93c706-fccc-4400-a3a4-e3ca1b388c29 | fa:16:3e:a9:13:ac | 5975df9a-e6c9-41de-bf17-a86cd1146c79 |+ L) g4 b3 Q5 D+ |; Z7 `; C5 h
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | fa:16:3e:d2:56:f8 | 9ba64156-7928-44ed-8a54-419b6d222c42 |
9 o9 e1 n3 u5 [9 L0 S& \| ea70424f-f8cc-4129-8447-5f94c30af872 | fa:16:3e:db:45:d5 | 1d436c7c-fad4-4ac2-b4f0-64ddb1877573 |
! f& C+ j5 y# |' @& L- c| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | fa:16:3e:9e:c8:3e | 1cd8b955-0e6d-4edc-b4e5-874e2e262321 |
% y/ ?- }+ z% g0 h; w| f8c71615-8862-47d9-b8c3-0d3966e01e5e | fa:16:3e:1e:96:93 | dhcpcf40685d-2640-5ca8-ae55-13e97b35a6fa-450187cb-d1db-4125-a105-740c64d2fc2d |: I' n* u/ V i& W3 A- i. w
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+
2 W! i& H9 r- Y3 m8 L. E& Z35 rows in set (0.01 sec)* [- \1 k. g1 \* U: l% h
MariaDB [neutron]> select * from portbindingports;3 c, ], q! K+ j
Empty set (0.00 sec)
% r9 R9 D$ d4 c JMariaDB [neutron]> select * from portdnses;
! V5 p, I( \- g* W' O3 hEmpty set (0.00 sec)
: o, r3 g& b) ~, j, `: p; HMariaDB [neutron]> select * from portsecuritybindings ;
3 T2 ~* q; W: n' G1 C9 ]& Q+--------------------------------------+-----------------------+) ?3 Q. m. c% Q2 L3 S6 E; v8 M2 M
| port_id | port_security_enabled |
" L7 K) {% W7 x% y+--------------------------------------+-----------------------+* W% b) t6 T9 T) S; z2 [7 h- v9 ^, \$ r
| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 1 |
& W. ~5 K/ V* p% B( W1 H; {3 X| 1a864374-7926-44d4-b047-4fe182b9788b | 1 |
0 N( S- b2 c. b! ?. o4 n4 H S! A| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 1 |
! m2 I+ W6 H( J6 r" m" I| 26c2b56d-03ba-4679-8b38-241cf3949645 | 1 |# ^" G6 V' U* {; h
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 1 |
_0 Z+ N/ q9 v- W| 2f511e86-c37f-462c-9ece-54de4ff411ac | 1 |6 O8 m) r8 e" k
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 1 |
3 l4 a. F0 ^0 a( [9 V/ w) `2 p| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 1 |
8 e' a) z* q( B- }( c/ Z| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 1 |
. n2 D! h- }3 w| 6076391e-e731-49ca-a807-947f488eafc4 | 0 |1 a. R0 k* _% R" ]4 A1 R$ V5 |
| 673ba259-1e09-446c-b401-a5d648709010 | 1 |
O I4 a* i7 d8 u: H| 69feb745-1f87-4756-9783-018378eb93cb | 1 |. P$ {" f& N, B" [% I9 {
| 6a163325-9ca4-4aab-813a-34936495498e | 1 |5 ?" ?3 L* L9 C2 N; n
| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 1 |+ W T% r0 P- e& a
| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 1 |
, C. m! F3 p! @( d5 @| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 1 |
1 x1 l/ A" ?2 z| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 1 |
r' c! K- j8 [4 R& i| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 1 |
) f7 d- `% ^0 I* j+ }0 x$ ]* {! w Q0 y| 885290f6-c90e-4733-acac-ffc26bc03385 | 1 |5 \% R# ~& W' x! Q
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 1 |
' [ F5 _& e* o' f$ `| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 1 |$ N1 v& Y; t5 e. a2 w! p5 ~' n E6 v
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 1 |
! G/ _8 c& Y" S3 S9 @6 w, q| a996f2df-611b-4a17-8698-155998df9638 | 1 |
1 Y& U5 _" j+ R2 s| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 1 |
$ l: n2 ^0 @7 r1 R8 v/ B| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 1 |
, n# Q4 K, u l9 _$ }: b| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 1 |
' B0 X& |* }: C& J- l1 C| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 1 |; \9 Y- L+ @0 X9 S$ x) j% b: d# G
| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 1 |
0 r* F3 G8 y8 k) f `6 w! N( X, Q+ E| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 1 |5 B2 E% K4 M2 q ]. J
| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 1 |% K- N$ Y1 @0 T1 Z; J
| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 0 |- J& u4 \' b- X+ @& B- [
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 1 |% ]( c. X4 W" K
| ea70424f-f8cc-4129-8447-5f94c30af872 | 1 |
- d D( ?# O. W; I# f# ]2 j4 Y| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 1 |
7 w6 h9 s9 h) x2 }' @8 q% j. }| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 1 |
6 b4 s' o3 f' U5 R; m+--------------------------------------+-----------------------+
1 l* a& U3 r/ X' a; T% n35 rows in set (0.00 sec)+ Q2 W+ h' H: J r W& l
MariaDB [neutron]> select * from ipallocations ;0 A. N5 f" z* h# ~. c% {- @
+--------------------------------------+----------------+--------------------------------------+--------------------------------------+1 L" Y0 v" @- C& Y. B
| port_id | ip_address | subnet_id | network_id |: ?2 v& u& B3 T
+--------------------------------------+----------------+--------------------------------------+--------------------------------------+$ k3 ]; P3 o# i) E/ D) F
| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 10.101.102.3 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |' z* H; f- t. b( m
| 1a864374-7926-44d4-b047-4fe182b9788b | 10.101.103.13 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 82c02dbf-e2ca-48ec-9c3f-d106ba789347 |
2 o' S, a }7 `" J| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 10.101.102.10 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
" x; ^; w1 J! E' k- P& H2 Z7 k| 26c2b56d-03ba-4679-8b38-241cf3949645 | 10.101.104.105 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |. ^7 y( S# y1 J; U
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 10.101.102.28 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |* a, y* H; Z& U" ]1 `, h
| 2f511e86-c37f-462c-9ece-54de4ff411ac | 10.101.102.9 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |. F* T# n, j L$ R
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 10.101.102.5 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
" B' n9 u/ `; k' I$ q% e7 P1 k* t| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 10.101.102.6 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
) y/ R# z; v0 J. d6 \| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 10.101.102.17 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |% a5 F! l1 Q( B6 f& c5 c6 g3 I4 W4 C
| 6076391e-e731-49ca-a807-947f488eafc4 | 10.101.104.2 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
7 K+ H$ x" G: v- e( k| 673ba259-1e09-446c-b401-a5d648709010 | 10.101.102.34 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |8 e5 Y) ^. r2 ^. `, m8 L0 O/ g2 L
| 69feb745-1f87-4756-9783-018378eb93cb | 10.101.102.23 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
; @+ q/ v D5 H0 Y| 6a163325-9ca4-4aab-813a-34936495498e | 10.101.102.14 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
- {4 N8 a( J$ M$ c* u- || 72247f1c-a9fa-4d61-ac9b-458f44756796 | 10.101.102.26 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |7 j( N' H( c- W9 N5 z
| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 10.101.102.7 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
; [% q6 N% u& w| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 10.101.102.20 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
& u1 w( M9 u; f| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 10.101.102.33 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
. R) o* v9 }: e9 a9 i6 A" e0 m| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 10.101.102.32 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |9 ~0 W) S4 ~. a& V! t% Y5 b
| 885290f6-c90e-4733-acac-ffc26bc03385 | 10.101.102.19 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |( F2 j* }- h* \9 r( t) m( j
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 10.101.102.4 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
# E& _& ]2 P0 o$ p7 [3 g8 L# e+ V| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 10.101.102.2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d | L/ ?# ]9 x7 r+ q
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
, U# B8 J6 P) U/ ~- T| a996f2df-611b-4a17-8698-155998df9638 | 10.101.102.24 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
2 D# f- u% v3 A' A| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 10.101.102.27 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
2 Q/ t" }5 y& f' Z| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 10.101.102.12 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
0 T, l7 X: j& j: L+ Y; G6 T| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 10.101.102.15 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
! X" g; F' e* G' g, f, w7 z: F( l. R| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 10.101.102.18 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
+ a) e' j, r. v, E0 M( C S| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 10.101.102.21 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
& B- w+ b, q n/ a! D: r& o| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 10.101.102.8 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
6 A# A N3 ^. @% `7 w) h| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 10.101.102.22 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
) i; S: I4 M$ ^| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 10.101.104.14 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |' P6 ]& B4 V& d4 E
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 10.101.102.25 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
+ m3 s3 P8 H( P$ g7 h* [3 x4 u| ea70424f-f8cc-4129-8447-5f94c30af872 | 10.101.102.13 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
- f) X% R# l( d' P) r| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 10.101.102.30 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |- C: V1 R; ~6 {. a1 T5 D) Z
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |5 D' ]5 C' W; f+ |# v, `) d1 S( j
+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
7 u' b: [' [5 I& h% T+ V7 u+ i' j35 rows in set (0.00 sec)' _ Q- ^- ^0 Y& g4 L5 Q
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;
I; c# Q7 e! s( e8 }Empty set (0.01 sec)& [' }. Z# M; d/ p$ w/ ]7 K
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1' ;
: w6 W, B2 ]" t- K. g7 I+--------------------------------------+--------------+--------------------------------------+--------------------------------------+ w- M6 ^+ \3 }
| port_id | ip_address | subnet_id | network_id |
& E+ G# Z* J) c9 N0 A, _+--------------------------------------+--------------+--------------------------------------+--------------------------------------+
0 S- W2 ]! d/ e: s0 y0 c5 T| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |3 G, n! P7 @2 ?/ h
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+
& R0 G7 g: ?: h! O% f5 ~0 ?1 row in set (0.00 sec)
+ [' b) |0 E( l& p3 v9 s) AMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.11' ;
9 }+ p2 }# t* y' k' Q. c6 I+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
9 @; V$ |) S" P9 r* b| port_id | ip_address | subnet_id | network_id |
3 U# q2 v3 y" u6 x0 e2 T9 p2 \, v+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
4 ^3 m. f6 c' t. A7 u| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |! [8 s/ u& n8 Y' L8 c* _$ d
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
( u6 Q6 K$ F( g; I! c- Z1 row in set (0.00 sec)
7 G1 s% T& C( L* {/ ^MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1*' ;- k" }9 T% R( s
Empty set (0.00 sec)- o/ C! s2 p) k; Q& _" z/ {1 }
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;
! |% I; s" w& KEmpty set (0.00 sec), `' h( [3 V% r% `* g* J* W) E
MariaDB [neutron]> select * from ipavailabilityrange where ip_address='10.101.102.16' ;# [+ H+ d! w0 f! N3 p
ERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist$ q* v* M5 S0 R' P, h3 v: Z
MariaDB [neutron]> select * from ipavailabilityrange ;
0 f# T X% j: H% b) ~5 `7 l, kERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist; q4 {5 w& @% X( o' q
MariaDB [neutron]> select * from ipamallocationpools ;
1 H- q' y: Q4 i" O1 ]+ G+--------------------------------------+--------------------------------------+----------------+----------------+
* V7 e* a5 A8 Q* ^5 H0 t& q0 f9 X/ ~| id | ipam_subnet_id | first_ip | last_ip |
9 [3 p+ s% e2 ~( Z6 q3 [" u0 t1 H+--------------------------------------+--------------------------------------+----------------+----------------+5 l' j. z8 k3 A* \/ k9 v
| 9797b147-8198-4de9-9e5c-d16d84a56825 | 5711d030-3af4-48ef-8843-543af61a3cd7 | 10.101.104.1 | 10.101.104.253 |; r2 ^, b& J+ ]# K7 d) q7 Y3 [
| c5cf06df-3015-4685-b2e3-4e21850a1012 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.1 | 10.101.103.99 |
; Y; Z/ ~# k+ z8 W| ca29d040-54c6-4621-a457-ac430c20d3f1 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.200 | 10.101.103.253 |5 [* m4 U E- y7 \& [- a, [
| d9474fb4-2a6a-4d84-86ae-283b06185857 | f4879db9-c192-4208-be21-2384929abaf3 | 10.101.102.1 | 10.101.102.253 |6 ^8 f' R( Y$ t y, c0 z
+--------------------------------------+--------------------------------------+----------------+----------------+; i' H4 v' \* O0 Z) E* f7 C
4 rows in set (0.00 sec)/ r( M/ @* \# O
MariaDB [neutron]> select * from ipallocationpools ;, E& N9 n* J g4 a) u. Q3 d2 W' o
+--------------------------------------+--------------------------------------+----------------+----------------+7 V9 X2 l! Z2 f; J5 X% o) I
| id | subnet_id | first_ip | last_ip |8 ?! S1 ?5 h. H% o
+--------------------------------------+--------------------------------------+----------------+----------------+
3 f# N6 ]4 c7 [" h0 O: u| 221fd87b-0556-401a-9130-dcbf45107e15 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.200 | 10.101.103.253 |/ T' W! @" M0 v+ W, H" Z
| 78fe6a3c-1ccf-4e29-9574-1942a2dd10ed | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.1 | 10.101.103.99 |
; }9 ~/ F8 C1 G3 _. R| e2587070-8def-4e55-9ffe-55a2e51cd9c1 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 10.101.104.1 | 10.101.104.253 |
! x+ H, N& }! x. q| fad83ad2-378a-47d7-aa30-bc8234cceff2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 10.101.102.1 | 10.101.102.253 |1 x- `% _# N$ m2 \0 T3 s4 v! J. b% K
+--------------------------------------+--------------------------------------+----------------+----------------+* D3 n8 W3 D3 t/ @- P1 C& ]8 m2 `
4 rows in set (0.00 sec)9 X, | ~5 C7 |
|
|
发表于 2021-11-25 00:00:08