|
|
MariaDB [neutron]> select id,mac_address,device_id from ports;
1 O2 `; ?$ a& a+ a" u( T+--------------------------------------+-------------------+-------------------------------------------------------------------------------+$ X* j! o6 a+ M4 m
| id | mac_address | device_id |2 H4 C, s* J X- X9 K0 U
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+
- W' A; M6 Z3 @( x3 V7 N/ o| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | fa:16:3e:f3:6a:61 | 714e03e2-78a1-48e7-bdcc-98cf72012b4e |
) o% o: B2 Q$ u; {. J8 K| 1a864374-7926-44d4-b047-4fe182b9788b | fa:16:3e:25:dd:bc | 35b1e14e-1b4f-46b5-8c50-871705a96b36 |
" @1 K1 }. h4 x4 {4 q8 e& `| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | fa:16:3e:86:3d:3f | c1487ea4-e354-45bd-97d1-d25c04186053 |6 d+ y9 |5 p9 Z1 X& ~8 P0 R7 X
| 26c2b56d-03ba-4679-8b38-241cf3949645 | fa:16:3e:02:dc:f6 | 92aa63b3-ab7b-44fa-808a-d33e5f6f3253 |! u3 j/ h/ E" \. l4 D+ d# x% w% l
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | fa:16:3e:9e:ba:bc | 61b3ac44-6d9a-47c0-9f10-a86380552156 |
, u# {8 S* a; J3 w| 2f511e86-c37f-462c-9ece-54de4ff411ac | fa:16:3e:dc:dc:b3 | bf6482f3-cbaf-4e6f-b0ae-eab1aa234a73 |& o! s4 \5 X4 w) i, r8 T
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | fa:16:3e:ed:4c:ad | eefdc520-99d3-43ca-8d19-ee0ceb02200e |" J5 A, E9 L5 `; o# f: t
| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | fa:16:3e:4a:47:2e | b63fa7c6-4a40-4824-9710-b1eeab2cefaf |( Y$ _- ~; U) E9 e$ u
| 53a87f50-41af-446c-ae4a-ef7ef0484877 | fa:16:3e:bd:5c:f5 | 87056023-5cd4-48ac-a675-d503bcb3cfb2 |
0 c3 n a8 I' s| 6076391e-e731-49ca-a807-947f488eafc4 | fa:16:3e:b6:e5:6f | dhcp57aa2c89-eb31-5aa6-baa3-9db19f8fe78d-4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |7 Z* [ z o! I
| 673ba259-1e09-446c-b401-a5d648709010 | fa:16:3e:9f:0c:be | aace037f-9503-448a-ada6-faa2fcb88540 |0 j _ j; r7 V6 z9 E* i5 F; \. N
| 69feb745-1f87-4756-9783-018378eb93cb | fa:16:3e:14:21:5d | 905dd6ea-2b05-432a-9704-dab1f496ffcd |
2 Q4 ?' r' o4 c2 i R& T& q1 i| 6a163325-9ca4-4aab-813a-34936495498e | fa:16:3e:ab:a5:c6 | 08331d00-0ff4-4044-9bc7-cdf6d2e1b804 |1 k: f; [( H" V/ H- o7 }# s
| 72247f1c-a9fa-4d61-ac9b-458f44756796 | fa:16:3e:5f:86:bc | 3f0aeeea-f232-4f5b-81b6-96b8d222630e |) [7 B/ s E1 S d* b/ t
| 73378cf5-f15c-4069-93d5-5db03f7a5091 | fa:16:3e:96:5b:ae | be9445cd-bdda-4d3a-969a-c3b127cd89ff |, d3 ?3 H& P+ P, k9 q+ B7 N _. J
| 77113585-e4ac-4d66-b9ad-4e322a6816ce | fa:16:3e:01:33:ea | e588be3b-3765-4679-80e8-ea61dc2ad039 |
5 ]1 D$ ]. y2 |4 C, {2 {, Y| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | fa:16:3e:0d:fe:50 | 6626af94-61d0-4f74-948b-734c34969933 |% `& \) n' Z6 k" D/ h
| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | fa:16:3e:c5:26:d0 | 1119aac5-d6f4-40e4-92c1-a541ca2b5603 |0 |. u! ~1 V4 G! c! b' I
| 885290f6-c90e-4733-acac-ffc26bc03385 | fa:16:3e:09:b5:e6 | 9b592059-2acd-4962-ae05-dbfd8b2f2851 |
* D% ?7 u d* b$ F. R. k- T| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | fa:16:3e:b4:b4:4a | fb9d360f-bf85-41d0-a11c-7da528ade98a |# ?3 R9 O1 N+ O
| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | fa:16:3e:03:cc:9d | |/ J% |8 @5 D1 O
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | fa:16:3e:05:26:6f | 08b9e4e2-5594-4a07-bd79-9cc61fa109d4 |
* @6 F/ t" g6 X# {. E6 @; A| a996f2df-611b-4a17-8698-155998df9638 | fa:16:3e:1a:e1:0c | 2757130d-b5ea-4a19-b8eb-5949385c8df2 |2 ]& S, T; w# a. o9 f, f0 r
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | fa:16:3e:50:6c:e6 | 43b8d644-8ec9-4d3f-bc7d-9d1c49518c08 |
! C6 ^% n" |9 l" z| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | fa:16:3e:fe:ba:59 | f4c09f55-2898-4961-8692-7c44fb27e070 |
7 | c% p% u: O7 J9 z* d8 \1 Z: R9 S| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | fa:16:3e:88:34:74 | b2a989e6-c143-4dc6-88af-5a96f5b6f74e |0 n# Y- n6 `) Y) t
| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | fa:16:3e:33:45:f1 | 4c19026c-4c62-49c2-b0b4-5f612ca2c7c8 |- d( m! C5 ?2 `2 ?6 f6 P
| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | fa:16:3e:0e:6e:a8 | 48c9b28d-ab90-4954-9137-1b3991744d96 |
# y; [: N% B9 H) B0 a" L8 L| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | fa:16:3e:b6:c4:7f | ae4ed8d3-50c1-4c6f-b04c-fc3a5083631f |7 d) Q& _2 i! W- t% B% C% z
| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | fa:16:3e:e3:c0:98 | 2c37d181-9948-42ed-8a57-8636ea53964f |
1 z0 ]% w5 j3 I/ b# r| da93c706-fccc-4400-a3a4-e3ca1b388c29 | fa:16:3e:a9:13:ac | 5975df9a-e6c9-41de-bf17-a86cd1146c79 |
) \; ?/ `- X+ {8 }| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | fa:16:3e:d2:56:f8 | 9ba64156-7928-44ed-8a54-419b6d222c42 |1 U* j0 e8 \" u! V' ~1 c. ^9 X
| ea70424f-f8cc-4129-8447-5f94c30af872 | fa:16:3e:db:45:d5 | 1d436c7c-fad4-4ac2-b4f0-64ddb1877573 | L( h* [5 L z B( c3 c
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | fa:16:3e:9e:c8:3e | 1cd8b955-0e6d-4edc-b4e5-874e2e262321 |" v( G- o6 e% z0 p* `
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | fa:16:3e:1e:96:93 | dhcpcf40685d-2640-5ca8-ae55-13e97b35a6fa-450187cb-d1db-4125-a105-740c64d2fc2d |
( b% x8 v. l6 K+ V+ X4 W, i" [+--------------------------------------+-------------------+-------------------------------------------------------------------------------+
5 n- Z; f+ c5 F8 g35 rows in set (0.01 sec)' f% k" Y, b0 Z8 K. G- q8 |3 R
MariaDB [neutron]> select * from portbindingports;( `" O" n* y5 h9 b. X
Empty set (0.00 sec) y8 `( t# Q5 W' B6 E" @
MariaDB [neutron]> select * from portdnses;
( t2 h, v# A2 A/ T# l! s# y; dEmpty set (0.00 sec)
% ]2 @: O( ~2 H9 o0 V; iMariaDB [neutron]> select * from portsecuritybindings ;
; q7 f' E' x7 N2 N, C+--------------------------------------+-----------------------+* a; {/ b2 K& X. z2 w+ F
| port_id | port_security_enabled |
4 }5 W' a! O J+ a2 x* G* `+--------------------------------------+-----------------------+
; E* S$ f: V; \2 A. i( m$ H| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 1 |2 [$ o. D1 n' v) ?# i
| 1a864374-7926-44d4-b047-4fe182b9788b | 1 |- f* u( n+ D; G1 j* n( v7 k6 d
| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 1 |4 X4 e# {7 ]# B3 i
| 26c2b56d-03ba-4679-8b38-241cf3949645 | 1 |
' J/ o. C1 {; V7 {; L5 o| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 1 |
. Q" g$ D. `; }, B+ v: E8 |9 a| 2f511e86-c37f-462c-9ece-54de4ff411ac | 1 |0 v" C5 k& I1 K' r1 g
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 1 |
i. v6 O' [6 H1 Z| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 1 |7 o1 W% e3 l6 n c. p/ M' i7 S0 l
| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 1 |% W) c Z' u* j' v
| 6076391e-e731-49ca-a807-947f488eafc4 | 0 |: a2 e1 _4 [5 J8 Z6 Z6 `, R
| 673ba259-1e09-446c-b401-a5d648709010 | 1 |0 W4 o* |6 Q- q( ?, c; h2 J! I P
| 69feb745-1f87-4756-9783-018378eb93cb | 1 |
: x, I- D4 _: a# m| 6a163325-9ca4-4aab-813a-34936495498e | 1 |
* n3 c) L) m- `% z; P$ B| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 1 |3 O1 u5 R( h! x7 X) }( v9 n# C
| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 1 |
# m p) Q& @4 I1 W4 O1 E| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 1 |
* U, W4 ?$ X9 ?. e" R1 i| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 1 |; ]; I! B0 u3 B6 o/ P0 h7 u
| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 1 |
3 y, X+ {3 q: `3 d! a5 J9 _| 885290f6-c90e-4733-acac-ffc26bc03385 | 1 |( n0 ^% c' X# r; B! q4 o6 Y8 c) W
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 1 |
4 z" {$ U& o4 h; W) p: |3 J% X, f2 b| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 1 |, l |$ v& r2 ?$ q+ ~. ?8 F w4 K
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 1 |* t1 d/ I w0 A6 t7 _2 d" T& ?
| a996f2df-611b-4a17-8698-155998df9638 | 1 |7 k3 D' I) D M7 s9 G0 j3 q- r O
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 1 |0 C5 S% `0 W8 S8 J4 k( D
| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 1 |
. @: [# D+ l/ L: a| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 1 |
' k$ U2 r" F1 s| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 1 |& v1 i+ |7 J* c! a3 a, V
| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 1 |
3 j& t) y; V% i" F| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 1 |
1 [5 t/ |, q4 M! g- ~( U3 ?| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 1 |
+ L$ x* |7 |+ t7 _2 w& v| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 0 |8 n# i/ P3 @* l; K" S1 ~3 ^9 e6 i
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 1 |
# q: G+ n! r1 J5 w' `1 z| ea70424f-f8cc-4129-8447-5f94c30af872 | 1 |
7 @& {5 r2 Y9 }( y! n| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 1 |
# N) S& }+ C, ]: @) l3 H| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 1 |7 \ r2 _6 W8 g- M/ a
+--------------------------------------+-----------------------+; r8 f [& B/ ]" k4 X
35 rows in set (0.00 sec)8 B( o; F3 o) ?
MariaDB [neutron]> select * from ipallocations ;( S% U* X# y" o
+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
$ @: Q* B" v; W3 N6 A2 O| port_id | ip_address | subnet_id | network_id |
2 V) ^7 v7 i/ x. o) g+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
6 |$ |. \% z; t4 q0 T9 c5 D| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 10.101.102.3 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |& m& {& G h" k$ G
| 1a864374-7926-44d4-b047-4fe182b9788b | 10.101.103.13 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 82c02dbf-e2ca-48ec-9c3f-d106ba789347 |
) D" X9 y1 p4 H) L6 v4 q| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 10.101.102.10 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |& ], @2 u& g) S5 W4 {
| 26c2b56d-03ba-4679-8b38-241cf3949645 | 10.101.104.105 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |8 B' }3 ]; R* u' _/ d& c
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 10.101.102.28 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
$ q9 N3 {0 k) d% V4 Q| 2f511e86-c37f-462c-9ece-54de4ff411ac | 10.101.102.9 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
4 D4 [% @8 ~, T# m| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 10.101.102.5 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |% b1 t+ {4 s& r3 f* ?
| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 10.101.102.6 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
2 d: h# m+ s1 Y3 Y1 _8 R' d9 X| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 10.101.102.17 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
& E, u" E5 }- Y4 E3 Q| 6076391e-e731-49ca-a807-947f488eafc4 | 10.101.104.2 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
: B" S' u1 }, |% u I: b| 673ba259-1e09-446c-b401-a5d648709010 | 10.101.102.34 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |6 l3 I" e1 w& L. {* g
| 69feb745-1f87-4756-9783-018378eb93cb | 10.101.102.23 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |- y! ^3 a2 j+ W+ o2 \0 G: b
| 6a163325-9ca4-4aab-813a-34936495498e | 10.101.102.14 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
5 L, ^+ u* C% ^) \+ ~$ @) a/ Z/ o| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 10.101.102.26 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
: R( K) _; h+ }' d| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 10.101.102.7 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
h4 K" V6 s; X% [$ ~ L. Q| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 10.101.102.20 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |6 Z& y; C% \$ f) ]9 q0 A
| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 10.101.102.33 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
- {2 Y& W3 Z' ]| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 10.101.102.32 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
, L/ C" b. h9 L| 885290f6-c90e-4733-acac-ffc26bc03385 | 10.101.102.19 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |, r5 ]# @1 h8 ]: X
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 10.101.102.4 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
% w" d0 A- a7 X, \& Z| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 10.101.102.2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
+ I( D( a. ]6 ^/ l| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
' R* C8 T9 |! y9 U) g| a996f2df-611b-4a17-8698-155998df9638 | 10.101.102.24 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |* C( _( K9 y( h) r# q
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 10.101.102.27 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |9 A7 Q% |1 M5 Z! u; ?
| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 10.101.102.12 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
: |/ I) b6 w: V" ]/ ]| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 10.101.102.15 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
" Q) F# J3 f4 C3 C& D| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 10.101.102.18 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
4 A3 o F* f; @, F| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 10.101.102.21 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
$ ?4 W& v& ], k6 g( N| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 10.101.102.8 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
: N' b2 {9 B* \7 ^) C| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 10.101.102.22 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
! j0 ]; \6 ?: D6 \- Y. y9 u& Y9 E| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 10.101.104.14 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
# g4 p, B N% w7 w! n: Q5 ?| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 10.101.102.25 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
4 B- I) C, g9 l" G3 U% f, D2 n| ea70424f-f8cc-4129-8447-5f94c30af872 | 10.101.102.13 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |3 I7 Z; @% o) j+ @; o
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 10.101.102.30 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |6 j& ^( D* m4 d
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |! p" j( F; C; Q
+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
* ]5 ]% x6 D6 E0 N* O" M! ?2 G% }35 rows in set (0.00 sec)
! d) T3 b$ w% g5 f* d+ Y W2 ZMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;
# |0 R9 K* q9 R7 j8 m8 \2 y9 ?Empty set (0.01 sec)7 T- l$ N1 m2 |3 S [6 J
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1' ;
% c3 r, s; R3 b6 ]+--------------------------------------+--------------+--------------------------------------+--------------------------------------+
: j( X: o9 A" f8 q: r1 x7 Y| port_id | ip_address | subnet_id | network_id |
! e1 s; t1 c, J3 s9 L" ~6 _+--------------------------------------+--------------+--------------------------------------+--------------------------------------+* F6 a- q1 Z$ H' }% i2 l
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |! k6 M( Y: r" S0 p6 @ P6 j) U
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+/ S) W( c1 s+ K( l- \ \8 K
1 row in set (0.00 sec)8 i; j3 L* U/ h1 j4 f8 Y8 g" p
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.11' ;/ Q/ r' [; B8 Y" t1 N; g) e, \& V
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
3 P3 V Y8 U& P5 w: o| port_id | ip_address | subnet_id | network_id |; v5 N E9 t# k. L' P$ x8 c4 F
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+; W3 U# ?6 ~: C, W" F: E
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |4 ]. y5 ]) [6 f/ D7 D/ |0 X- @# p
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+, {$ L" n5 x; n# B3 ?8 _$ m3 h
1 row in set (0.00 sec)* B# e. ?7 _% M0 Y, A; D
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1*' ;
, s$ K& ^" Z$ R2 Z K5 [1 X4 ?Empty set (0.00 sec)
# k( P; m7 h8 G, W5 V2 q9 L$ oMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;( G; O4 T' p$ n2 Z/ e5 G
Empty set (0.00 sec)
- S: M2 x; e! i9 ~+ i0 r: |6 MMariaDB [neutron]> select * from ipavailabilityrange where ip_address='10.101.102.16' ;
! b; P- S/ u5 G! |ERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist
: e- A5 k" b, M1 K& Z3 h/ p+ z- uMariaDB [neutron]> select * from ipavailabilityrange ;
0 v& o- P+ v; k* i' K2 g' B {' KERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist, G; l- |1 F4 Q( W
MariaDB [neutron]> select * from ipamallocationpools ;8 e: W9 T( y/ O4 I2 O" I5 Z
+--------------------------------------+--------------------------------------+----------------+----------------+
' _7 z7 G" i+ E7 U& F% e' \| id | ipam_subnet_id | first_ip | last_ip |
! X& v4 P3 Y) G( e+--------------------------------------+--------------------------------------+----------------+----------------+3 ^! `# _+ R2 l! J8 e) M; v# ]
| 9797b147-8198-4de9-9e5c-d16d84a56825 | 5711d030-3af4-48ef-8843-543af61a3cd7 | 10.101.104.1 | 10.101.104.253 |
* _" v1 j" Y$ e; j$ k |9 W4 c8 Z' t| c5cf06df-3015-4685-b2e3-4e21850a1012 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.1 | 10.101.103.99 |
8 d! M0 Q/ C* [+ a) p: `8 [| ca29d040-54c6-4621-a457-ac430c20d3f1 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.200 | 10.101.103.253 |
/ v# k- z8 Y1 G# T3 \' J| d9474fb4-2a6a-4d84-86ae-283b06185857 | f4879db9-c192-4208-be21-2384929abaf3 | 10.101.102.1 | 10.101.102.253 |5 N1 I0 x! Y# ?5 l9 B
+--------------------------------------+--------------------------------------+----------------+----------------+
) R1 z" t1 h/ R0 [4 rows in set (0.00 sec)
+ A7 t6 c- O5 v% A% `7 A( M& \MariaDB [neutron]> select * from ipallocationpools ;
5 B8 A* Q* {3 a4 I4 I3 A" K+--------------------------------------+--------------------------------------+----------------+----------------+
\5 ]' S z. P( [% `7 @& }| id | subnet_id | first_ip | last_ip |
; r/ a& H6 q- {( m% S6 j' T+--------------------------------------+--------------------------------------+----------------+----------------+
8 H# P/ c$ Y6 n$ t# r" x || 221fd87b-0556-401a-9130-dcbf45107e15 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.200 | 10.101.103.253 |0 v1 `5 n; `, `- V, M: N- v( s d7 Y
| 78fe6a3c-1ccf-4e29-9574-1942a2dd10ed | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.1 | 10.101.103.99 |
4 U9 K- `. W# a* D| e2587070-8def-4e55-9ffe-55a2e51cd9c1 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 10.101.104.1 | 10.101.104.253 |: H6 X3 N* X$ e
| fad83ad2-378a-47d7-aa30-bc8234cceff2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 10.101.102.1 | 10.101.102.253 |5 ]% f) g* x+ D+ r
+--------------------------------------+--------------------------------------+----------------+----------------+9 R; v3 @1 X' [! b2 z0 C
4 rows in set (0.00 sec)$ ?0 I9 A4 [) o+ @$ f5 H/ W" w
|
|
发表于 2021-11-25 00:00:08