|
|
MariaDB [neutron]> select id,mac_address,device_id from ports;7 t6 P3 n$ q, l' [* x
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+
. f' G" q4 t' K| id | mac_address | device_id |
+ {2 Y6 k8 A* J8 V" [+--------------------------------------+-------------------+-------------------------------------------------------------------------------+
8 p' b8 J% Y8 c- Y% Q8 a, y| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | fa:16:3e:f3:6a:61 | 714e03e2-78a1-48e7-bdcc-98cf72012b4e |* ~; `- E: o/ d+ U
| 1a864374-7926-44d4-b047-4fe182b9788b | fa:16:3e:25:dd:bc | 35b1e14e-1b4f-46b5-8c50-871705a96b36 |3 [+ h8 \3 |8 a
| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | fa:16:3e:86:3d:3f | c1487ea4-e354-45bd-97d1-d25c04186053 |
; G/ b6 z6 a) d! u- L; I" x| 26c2b56d-03ba-4679-8b38-241cf3949645 | fa:16:3e:02:dc:f6 | 92aa63b3-ab7b-44fa-808a-d33e5f6f3253 |, Q; E6 r/ e) t9 {
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | fa:16:3e:9e:ba:bc | 61b3ac44-6d9a-47c0-9f10-a86380552156 |3 i0 o7 w! ^/ E9 D1 Z P
| 2f511e86-c37f-462c-9ece-54de4ff411ac | fa:16:3e:dc:dc:b3 | bf6482f3-cbaf-4e6f-b0ae-eab1aa234a73 |
& Q+ K+ |) ~, p; q |; Q| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | fa:16:3e:ed:4c:ad | eefdc520-99d3-43ca-8d19-ee0ceb02200e |
, {4 X' y+ s0 x- M| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | fa:16:3e:4a:47:2e | b63fa7c6-4a40-4824-9710-b1eeab2cefaf |
/ z5 n# O- T! r+ \: I| 53a87f50-41af-446c-ae4a-ef7ef0484877 | fa:16:3e:bd:5c:f5 | 87056023-5cd4-48ac-a675-d503bcb3cfb2 |+ T7 }& n7 J8 D) |$ L |
| 6076391e-e731-49ca-a807-947f488eafc4 | fa:16:3e:b6:e5:6f | dhcp57aa2c89-eb31-5aa6-baa3-9db19f8fe78d-4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
- B$ d/ x' K9 {( k| 673ba259-1e09-446c-b401-a5d648709010 | fa:16:3e:9f:0c:be | aace037f-9503-448a-ada6-faa2fcb88540 |, q# @7 ?7 _: v/ ~ P
| 69feb745-1f87-4756-9783-018378eb93cb | fa:16:3e:14:21:5d | 905dd6ea-2b05-432a-9704-dab1f496ffcd |
1 S; t- }, x5 q% e+ Y- `| 6a163325-9ca4-4aab-813a-34936495498e | fa:16:3e:ab:a5:c6 | 08331d00-0ff4-4044-9bc7-cdf6d2e1b804 |
- Q5 N- N# y4 ^| 72247f1c-a9fa-4d61-ac9b-458f44756796 | fa:16:3e:5f:86:bc | 3f0aeeea-f232-4f5b-81b6-96b8d222630e |# f4 m3 [( _9 c4 q w$ H- j$ C
| 73378cf5-f15c-4069-93d5-5db03f7a5091 | fa:16:3e:96:5b:ae | be9445cd-bdda-4d3a-969a-c3b127cd89ff |; G: o) f( `. A1 m$ y' C
| 77113585-e4ac-4d66-b9ad-4e322a6816ce | fa:16:3e:01:33:ea | e588be3b-3765-4679-80e8-ea61dc2ad039 |& M0 ^- b7 d8 W$ K- V5 \
| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | fa:16:3e:0d:fe:50 | 6626af94-61d0-4f74-948b-734c34969933 |! K* {4 Y4 c. [6 f/ q: W
| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | fa:16:3e:c5:26:d0 | 1119aac5-d6f4-40e4-92c1-a541ca2b5603 |
9 S1 e& F1 K" b: N6 {| 885290f6-c90e-4733-acac-ffc26bc03385 | fa:16:3e:09:b5:e6 | 9b592059-2acd-4962-ae05-dbfd8b2f2851 |& k$ `* ^! X; n: e
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | fa:16:3e:b4:b4:4a | fb9d360f-bf85-41d0-a11c-7da528ade98a |$ v x# j! @! a& |8 k
| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | fa:16:3e:03:cc:9d | |' N* ?% s6 }. E: J
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | fa:16:3e:05:26:6f | 08b9e4e2-5594-4a07-bd79-9cc61fa109d4 |
4 R; L" z9 t5 u: e7 q| a996f2df-611b-4a17-8698-155998df9638 | fa:16:3e:1a:e1:0c | 2757130d-b5ea-4a19-b8eb-5949385c8df2 |
}5 i- e1 q; a9 a. W| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | fa:16:3e:50:6c:e6 | 43b8d644-8ec9-4d3f-bc7d-9d1c49518c08 |7 }& B( |- o) ], R8 D2 z
| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | fa:16:3e:fe:ba:59 | f4c09f55-2898-4961-8692-7c44fb27e070 |
9 ~# K. M* A- o7 @8 f1 s| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | fa:16:3e:88:34:74 | b2a989e6-c143-4dc6-88af-5a96f5b6f74e |! R7 B( T; P6 Y5 _/ k
| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | fa:16:3e:33:45:f1 | 4c19026c-4c62-49c2-b0b4-5f612ca2c7c8 |( w, Y( z$ j" M" d" [3 \
| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | fa:16:3e:0e:6e:a8 | 48c9b28d-ab90-4954-9137-1b3991744d96 |
3 O/ V9 u3 i1 t# ]| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | fa:16:3e:b6:c4:7f | ae4ed8d3-50c1-4c6f-b04c-fc3a5083631f |
' l6 a+ f* E T: Z3 [: ^7 V| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | fa:16:3e:e3:c0:98 | 2c37d181-9948-42ed-8a57-8636ea53964f |
- |8 Y' e2 t7 e- U/ N. M| da93c706-fccc-4400-a3a4-e3ca1b388c29 | fa:16:3e:a9:13:ac | 5975df9a-e6c9-41de-bf17-a86cd1146c79 |& X# I4 o8 G! U% E# ~+ B5 U
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | fa:16:3e:d2:56:f8 | 9ba64156-7928-44ed-8a54-419b6d222c42 |- P' {7 X& G6 Z' x2 l
| ea70424f-f8cc-4129-8447-5f94c30af872 | fa:16:3e:db:45:d5 | 1d436c7c-fad4-4ac2-b4f0-64ddb1877573 |
# V6 l( p8 Z, w3 N2 |% P0 g| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | fa:16:3e:9e:c8:3e | 1cd8b955-0e6d-4edc-b4e5-874e2e262321 |
: S! `0 N" x8 A8 f* ], z| f8c71615-8862-47d9-b8c3-0d3966e01e5e | fa:16:3e:1e:96:93 | dhcpcf40685d-2640-5ca8-ae55-13e97b35a6fa-450187cb-d1db-4125-a105-740c64d2fc2d |! ?# W. {, Q- \% T/ k; o
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+" E& r6 F8 A" x5 x4 h: R5 D5 q; u' H
35 rows in set (0.01 sec)* D% P. j e9 ?0 ^. z2 b
MariaDB [neutron]> select * from portbindingports;2 ?( Y7 @/ n1 |7 }' H& v4 j0 a
Empty set (0.00 sec)
/ c- f5 W; Z" b( {9 n2 i% [MariaDB [neutron]> select * from portdnses;
- d9 ?" w v+ u6 k& a; uEmpty set (0.00 sec)* X* E3 J. u! j1 e
MariaDB [neutron]> select * from portsecuritybindings ;
# B. J$ f9 a/ n* t, @+--------------------------------------+-----------------------+
1 A% ?3 W& ^ |8 e- g, s| port_id | port_security_enabled |0 |1 G' ?, e, x: @
+--------------------------------------+-----------------------+# y# M8 x' h9 _8 c% M
| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 1 |5 |: j# Q# k$ l6 X) O
| 1a864374-7926-44d4-b047-4fe182b9788b | 1 |4 _1 \6 E& f6 c/ i
| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 1 |4 M d; @: r, f; c! i: E) \
| 26c2b56d-03ba-4679-8b38-241cf3949645 | 1 |; N# j/ |4 b o& M. T
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 1 |( [9 Q$ i% a' i0 v( F2 }+ b
| 2f511e86-c37f-462c-9ece-54de4ff411ac | 1 |& m6 G, G v* T t9 j
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 1 |
* U* s& @1 B5 K$ S7 i, N3 f2 ?6 [| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 1 |
4 \6 s; j/ m. `# R, N. o9 v- K| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 1 |
! s$ D: A: Y6 Z. w& G1 O| 6076391e-e731-49ca-a807-947f488eafc4 | 0 |
* y0 F, z6 ?! u, G6 B| 673ba259-1e09-446c-b401-a5d648709010 | 1 |9 y/ P0 Y# o7 t$ Y
| 69feb745-1f87-4756-9783-018378eb93cb | 1 |/ o8 @3 U/ ]* O
| 6a163325-9ca4-4aab-813a-34936495498e | 1 |! Y8 t4 ?4 R- J7 R+ t5 i
| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 1 |* ^% F5 Z+ j3 L& O: ~" \
| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 1 |
( F1 J8 J# \% Z3 D% ~| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 1 |
, [( n. K7 b! ^" l: i8 [4 O1 j' r* @| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 1 |) S2 |* f6 Y$ `0 y3 N& T9 b
| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 1 |$ H @; v6 r- d0 C& W% N
| 885290f6-c90e-4733-acac-ffc26bc03385 | 1 |0 w- b4 m+ x4 ^2 n) g1 U
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 1 |2 @- b6 |. S- r) {# ~! d
| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 1 |
5 q+ i4 L' G' T4 Y! k| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 1 |, R2 }- k/ y0 w8 T
| a996f2df-611b-4a17-8698-155998df9638 | 1 |0 x i% s0 ?5 x- t* {+ b
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 1 |
' S$ R$ B1 }1 v( ?; n& ?| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 1 |
8 c% H& w6 d* P! u1 r+ }& ?3 U| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 1 |7 }8 D4 Z6 \: N# Q
| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 1 |% `5 k1 F: C! h, R) r# q, f$ F
| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 1 |3 O- {( I; u4 k" c- I& x6 Z# \' ^
| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 1 |
0 E( _: F, T3 l6 S, s9 R" }| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 1 |
4 Y6 W( W8 f6 L. E( e| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 0 |
; T" d/ w5 G- Z3 z| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 1 |
3 \8 `4 U n3 ?% I* m* q: S| ea70424f-f8cc-4129-8447-5f94c30af872 | 1 |
# \6 x2 |4 o- g7 s& b v| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 1 | h. p2 i! ?' v' x, C) h
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 1 |
- r2 c" H7 Y$ E% l+--------------------------------------+-----------------------+
8 F; c( M) u8 }" E/ ]- Y" @" M6 l35 rows in set (0.00 sec)5 ^: v, G5 n2 U3 L
MariaDB [neutron]> select * from ipallocations ;
+ [! O) ~" C% V) m+--------------------------------------+----------------+--------------------------------------+--------------------------------------+: V8 N4 Z# e+ n3 ^
| port_id | ip_address | subnet_id | network_id |
) } V" C$ m, A/ G& V8 {% o+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
; L) E. w$ Z6 l9 e) z| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 10.101.102.3 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
* |7 ]* |# v9 H" d$ s9 ?2 c| 1a864374-7926-44d4-b047-4fe182b9788b | 10.101.103.13 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 82c02dbf-e2ca-48ec-9c3f-d106ba789347 |0 N* M+ B# S; B o9 u
| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 10.101.102.10 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
: g# m0 ?/ ~/ t0 _3 q) Y| 26c2b56d-03ba-4679-8b38-241cf3949645 | 10.101.104.105 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
3 j6 Q9 S5 Z7 l' D w% E| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 10.101.102.28 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
6 z# |' q2 E% g8 K" o| 2f511e86-c37f-462c-9ece-54de4ff411ac | 10.101.102.9 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |* ^5 C5 r1 z9 J5 d
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 10.101.102.5 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |+ P$ a/ A6 |. [& g! {3 M6 }
| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 10.101.102.6 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
$ t9 u- I" ?6 x4 }# \- [/ }- s y1 v9 e| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 10.101.102.17 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |$ S4 W X4 {* `2 i. p; b/ G, N
| 6076391e-e731-49ca-a807-947f488eafc4 | 10.101.104.2 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |/ ?. b9 X7 ^5 M# b2 r- @7 o K
| 673ba259-1e09-446c-b401-a5d648709010 | 10.101.102.34 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
5 ^( h) f% B9 n' z1 P. K| 69feb745-1f87-4756-9783-018378eb93cb | 10.101.102.23 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
3 h6 N! l4 J! }* O! N0 U9 u| 6a163325-9ca4-4aab-813a-34936495498e | 10.101.102.14 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
) z$ n3 O) b: l: s' i: U. {| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 10.101.102.26 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
4 |( ^( D2 M$ K7 M; Y1 G' D) ~. P| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 10.101.102.7 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |, R# }7 m$ t. k& X' {4 F0 R. A+ B2 l
| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 10.101.102.20 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |( t6 V. e( X/ K2 X; S
| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 10.101.102.33 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |+ O; B" W' @' S9 W8 v
| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 10.101.102.32 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
8 V: r: w6 @. Q+ Q| 885290f6-c90e-4733-acac-ffc26bc03385 | 10.101.102.19 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
. \. ~" K. c8 i$ k| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 10.101.102.4 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
3 N9 f) |2 ?( m| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 10.101.102.2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
! d) f3 x( c: |2 a+ ^( M| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
+ F* R& I0 t: c$ d- v| a996f2df-611b-4a17-8698-155998df9638 | 10.101.102.24 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |: [3 z5 u" b8 a
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 10.101.102.27 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
5 G. L# ?1 v* L' L| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 10.101.102.12 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
8 O1 R- `1 F% w/ l- ^| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 10.101.102.15 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |3 A, l3 K( o5 R; @: R
| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 10.101.102.18 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |$ y, L& z8 J5 A9 _. D; G
| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 10.101.102.21 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
0 \% A- v. T, U' Y$ F) a| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 10.101.102.8 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
; ^7 i' M6 b& s+ B" R| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 10.101.102.22 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
! z( K* y- b+ @# D# W* c7 p4 K| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 10.101.104.14 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
# C* w( i d# J5 e3 c: a| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 10.101.102.25 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |# j: _' W% ~/ g6 A
| ea70424f-f8cc-4129-8447-5f94c30af872 | 10.101.102.13 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |8 {* u& v& B9 ^. K' c5 B
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 10.101.102.30 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
+ A/ P) V5 `! E! x/ w' M| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |, J8 i- j7 _4 s0 H( j
+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
5 F2 v7 C( g" X9 g& V% a1 F+ M; Q35 rows in set (0.00 sec)0 h+ l3 h8 m8 p# H6 y
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;
; Q% n: J; i2 j! q8 Z+ _7 h+ G# eEmpty set (0.01 sec)
, S4 `: `: m& r( J1 H6 a( `5 pMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1' ;
# Z! G3 _# d& }4 f* p8 G+--------------------------------------+--------------+--------------------------------------+--------------------------------------+
8 n+ i4 B U3 A| port_id | ip_address | subnet_id | network_id |6 K2 u8 C* @. b
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+8 o# j! N7 Z" \! x/ `7 u
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
: ^3 k) f4 R9 N8 f1 t+--------------------------------------+--------------+--------------------------------------+--------------------------------------+
; q/ v4 o/ X+ O0 b; F6 u1 row in set (0.00 sec)
8 c- y2 U$ Z- @& z+ W; \MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.11' ;; G3 J$ y: g1 O" V4 V) Y
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
?1 T' i. b' s% {* W, k+ \| port_id | ip_address | subnet_id | network_id |
% w4 q+ K( I2 y% f" A) I9 z1 `+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
* d: z& E# d5 X* H) ^4 p| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |& Q% E' O$ q6 o: Q
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+: ~2 M8 n; i0 r$ D
1 row in set (0.00 sec)
+ D0 X6 Z. W! P- d) e5 m/ |' p/ _) fMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1*' ;
8 z7 o. _" A$ C* }; H, TEmpty set (0.00 sec)
- g1 W3 `; q/ I$ \MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;+ o6 y; U8 i0 S: j# s- I* n
Empty set (0.00 sec)
- k4 b Y) a/ W* c1 N9 fMariaDB [neutron]> select * from ipavailabilityrange where ip_address='10.101.102.16' ;7 A! l& ?: J, q% v
ERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist
2 J' e- y' o( Y" x, xMariaDB [neutron]> select * from ipavailabilityrange ;
0 ], W' f. {" n- IERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist
0 E; r. @, m6 z) I: P8 QMariaDB [neutron]> select * from ipamallocationpools ;: C+ \& |. ]% O. A
+--------------------------------------+--------------------------------------+----------------+----------------+( I5 A9 d, E7 _( F- Q0 d" p
| id | ipam_subnet_id | first_ip | last_ip |% }! t* I* J% G, x, c
+--------------------------------------+--------------------------------------+----------------+----------------+$ X c/ e' u2 ^ ]+ Y: W B/ x
| 9797b147-8198-4de9-9e5c-d16d84a56825 | 5711d030-3af4-48ef-8843-543af61a3cd7 | 10.101.104.1 | 10.101.104.253 |3 C0 l" s2 C0 p; D
| c5cf06df-3015-4685-b2e3-4e21850a1012 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.1 | 10.101.103.99 |
! G8 k; b, a4 z: W| ca29d040-54c6-4621-a457-ac430c20d3f1 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.200 | 10.101.103.253 |
6 o1 F( b% F' h& e" a$ R; [. [& K| d9474fb4-2a6a-4d84-86ae-283b06185857 | f4879db9-c192-4208-be21-2384929abaf3 | 10.101.102.1 | 10.101.102.253 |- d0 e- n# n# b% S: ]% }
+--------------------------------------+--------------------------------------+----------------+----------------+
' V+ G0 E/ h) H9 ?& z; y5 o# Y- ~; v4 rows in set (0.00 sec)" J) z8 g" P: n" W! i! @
MariaDB [neutron]> select * from ipallocationpools ;* {8 o. F; s! [3 `$ f0 j7 \0 b
+--------------------------------------+--------------------------------------+----------------+----------------+; s$ I6 [* @: U
| id | subnet_id | first_ip | last_ip |8 R2 G N7 o" Q$ |; o4 b
+--------------------------------------+--------------------------------------+----------------+----------------+ }! m5 Q1 N$ h2 j3 Y1 H$ u2 S* w
| 221fd87b-0556-401a-9130-dcbf45107e15 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.200 | 10.101.103.253 |
' `3 J; E9 a" ~/ I5 s4 @( _| 78fe6a3c-1ccf-4e29-9574-1942a2dd10ed | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.1 | 10.101.103.99 |. a* z8 H' L- n. X' s, f, N
| e2587070-8def-4e55-9ffe-55a2e51cd9c1 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 10.101.104.1 | 10.101.104.253 |/ L0 C" ~8 ^6 N/ S) j0 ^0 Z3 {
| fad83ad2-378a-47d7-aa30-bc8234cceff2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 10.101.102.1 | 10.101.102.253 |
$ p. ~" t2 \. N: B1 V+--------------------------------------+--------------------------------------+----------------+----------------+
J- F( S9 T" s0 K; c. o$ A( u4 rows in set (0.00 sec)9 B" R0 l) s+ \" M! `
|
|
发表于 2021-11-25 00:00:08