- 积分
- 16841
在线时间 小时
最后登录1970-1-1
|
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
您需要 登录 才可以下载或查看，没有账号？开始注册
x
MariaDB [neutron]> select id,mac_address,device_id from ports;
8 k' V ?& z t+--------------------------------------+-------------------+-------------------------------------------------------------------------------+# @" w9 r, c4 a" J& I; @8 _& Y
| id | mac_address | device_id |/ X+ D! F1 f! w: L
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+8 B- M. F" W5 Y0 y5 t' w6 e
| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | fa:16:3e:f3:6a:61 | 714e03e2-78a1-48e7-bdcc-98cf72012b4e |! r! m' u* l( [& O% \
| 1a864374-7926-44d4-b047-4fe182b9788b | fa:16:3e:25:dd:bc | 35b1e14e-1b4f-46b5-8c50-871705a96b36 |
1 T6 f8 o, r* ~2 b1 _$ G| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | fa:16:3e:86:3d:3f | c1487ea4-e354-45bd-97d1-d25c04186053 |
3 r: ^' S: C# F: H7 W0 T) z| 26c2b56d-03ba-4679-8b38-241cf3949645 | fa:16:3e:02:dc:f6 | 92aa63b3-ab7b-44fa-808a-d33e5f6f3253 |8 P, `+ G: y* \
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | fa:16:3e:9e:ba:bc | 61b3ac44-6d9a-47c0-9f10-a86380552156 |
# {8 f- Q, ^7 _7 c* I4 N| 2f511e86-c37f-462c-9ece-54de4ff411ac | fa:16:3e:dc:dc:b3 | bf6482f3-cbaf-4e6f-b0ae-eab1aa234a73 |
* j* y+ ~8 j8 T# Z/ X| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | fa:16:3e:ed:4c:ad | eefdc520-99d3-43ca-8d19-ee0ceb02200e |
1 [% p; M" Z* I7 W( H| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | fa:16:3e:4a:47:2e | b63fa7c6-4a40-4824-9710-b1eeab2cefaf |; f; t/ C% s" G4 ?) f5 _
| 53a87f50-41af-446c-ae4a-ef7ef0484877 | fa:16:3e:bd:5c:f5 | 87056023-5cd4-48ac-a675-d503bcb3cfb2 |- G( k6 C C4 ^, r% u
| 6076391e-e731-49ca-a807-947f488eafc4 | fa:16:3e:b6:e5:6f | dhcp57aa2c89-eb31-5aa6-baa3-9db19f8fe78d-4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e | v, R4 C+ Q0 {; d" u
| 673ba259-1e09-446c-b401-a5d648709010 | fa:16:3e:9f:0c:be | aace037f-9503-448a-ada6-faa2fcb88540 |8 g3 k: f7 B- n) l$ Q2 n+ b
| 69feb745-1f87-4756-9783-018378eb93cb | fa:16:3e:14:21:5d | 905dd6ea-2b05-432a-9704-dab1f496ffcd |
3 C0 \* Y( Q/ c* h: n5 Z$ d| 6a163325-9ca4-4aab-813a-34936495498e | fa:16:3e:ab:a5:c6 | 08331d00-0ff4-4044-9bc7-cdf6d2e1b804 |
, }; _2 F9 R7 k' Z| 72247f1c-a9fa-4d61-ac9b-458f44756796 | fa:16:3e:5f:86:bc | 3f0aeeea-f232-4f5b-81b6-96b8d222630e |
! n Q: \$ B( t9 B/ A2 k( Y| 73378cf5-f15c-4069-93d5-5db03f7a5091 | fa:16:3e:96:5b:ae | be9445cd-bdda-4d3a-969a-c3b127cd89ff |& m8 `7 k6 D& \- ^# J6 _- E2 w% `
| 77113585-e4ac-4d66-b9ad-4e322a6816ce | fa:16:3e:01:33:ea | e588be3b-3765-4679-80e8-ea61dc2ad039 | P3 [9 K6 x7 @. p L: j0 o
| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | fa:16:3e:0d:fe:50 | 6626af94-61d0-4f74-948b-734c34969933 |
[1 A+ A/ N. D6 D7 A| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | fa:16:3e:c5:26:d0 | 1119aac5-d6f4-40e4-92c1-a541ca2b5603 |; k5 j$ s) m9 f1 ^, ^6 r
| 885290f6-c90e-4733-acac-ffc26bc03385 | fa:16:3e:09:b5:e6 | 9b592059-2acd-4962-ae05-dbfd8b2f2851 |% r3 o# R8 ^5 |; U# L, Q* |/ l, ]$ M1 T
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | fa:16:3e:b4:b4:4a | fb9d360f-bf85-41d0-a11c-7da528ade98a |
8 u( i- Z+ b, v+ K- m" Z9 {| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | fa:16:3e:03:cc:9d | |
% E. c! t% E$ G+ Y, b| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | fa:16:3e:05:26:6f | 08b9e4e2-5594-4a07-bd79-9cc61fa109d4 |
" Q6 B% n2 {/ m$ Z0 i, x| a996f2df-611b-4a17-8698-155998df9638 | fa:16:3e:1a:e1:0c | 2757130d-b5ea-4a19-b8eb-5949385c8df2 |5 a! K J1 u9 t* A, Y+ E
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | fa:16:3e:50:6c:e6 | 43b8d644-8ec9-4d3f-bc7d-9d1c49518c08 |
' h# v1 d5 _+ ]0 j B| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | fa:16:3e:fe:ba:59 | f4c09f55-2898-4961-8692-7c44fb27e070 |: u2 J* v# b1 q3 ^1 b
| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | fa:16:3e:88:34:74 | b2a989e6-c143-4dc6-88af-5a96f5b6f74e |2 a& t0 j* R1 i7 I9 I
| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | fa:16:3e:33:45:f1 | 4c19026c-4c62-49c2-b0b4-5f612ca2c7c8 |# o1 ]4 e' U, ]: ^# \% A
| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | fa:16:3e:0e:6e:a8 | 48c9b28d-ab90-4954-9137-1b3991744d96 |8 ]0 H' E( ~3 G. A5 O+ u2 k" |& Y
| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | fa:16:3e:b6:c4:7f | ae4ed8d3-50c1-4c6f-b04c-fc3a5083631f |
8 w7 R3 k+ b7 P0 d+ J| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | fa:16:3e:e3:c0:98 | 2c37d181-9948-42ed-8a57-8636ea53964f |
7 E N6 {# d1 e+ d! _; _ w| da93c706-fccc-4400-a3a4-e3ca1b388c29 | fa:16:3e:a9:13:ac | 5975df9a-e6c9-41de-bf17-a86cd1146c79 |' i8 G! X( A( i
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | fa:16:3e:d2:56:f8 | 9ba64156-7928-44ed-8a54-419b6d222c42 | u' }. Z) I+ _* y# C
| ea70424f-f8cc-4129-8447-5f94c30af872 | fa:16:3e:db:45:d5 | 1d436c7c-fad4-4ac2-b4f0-64ddb1877573 |4 u E0 X+ ~# @+ A
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | fa:16:3e:9e:c8:3e | 1cd8b955-0e6d-4edc-b4e5-874e2e262321 |
, M- K, y, i/ ]! M/ M| f8c71615-8862-47d9-b8c3-0d3966e01e5e | fa:16:3e:1e:96:93 | dhcpcf40685d-2640-5ca8-ae55-13e97b35a6fa-450187cb-d1db-4125-a105-740c64d2fc2d |' u% |( D4 X2 y' g
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+% Z' U" P% a: u- Z; {3 _2 [& k
35 rows in set (0.01 sec)
- e, d) l3 t7 O' IMariaDB [neutron]> select * from portbindingports;
2 h/ k: V" D2 [& o1 V) f. |2 rEmpty set (0.00 sec)
" Y4 J( q: u2 nMariaDB [neutron]> select * from portdnses;
7 `/ [+ C5 L6 M/ KEmpty set (0.00 sec)
; z# Y1 z8 `: m' |8 |MariaDB [neutron]> select * from portsecuritybindings ;/ [1 r$ q6 l( W: H, e# q
+--------------------------------------+-----------------------+4 @) U/ P7 P& A; t7 k
| port_id | port_security_enabled |) I) z: N" Y/ \! n
+--------------------------------------+-----------------------+
8 a) k. _) @9 y! q U a| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 1 |+ d4 a; v& c* a! v x7 B$ }8 W
| 1a864374-7926-44d4-b047-4fe182b9788b | 1 |
( w8 g& ^6 Z: L% `| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 1 |
' E6 g3 M G0 \! a( D| 26c2b56d-03ba-4679-8b38-241cf3949645 | 1 |
( F: s1 C% k7 i$ N" ]$ V7 p| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 1 |
6 m/ N0 {& n; V2 J2 w; t& _* v9 v/ Z| 2f511e86-c37f-462c-9ece-54de4ff411ac | 1 |+ K) x8 S& Y2 a$ p0 g* w: I9 ~
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 1 |
# \: g4 T, s; ]| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 1 |
% s$ e/ f. s- \* \| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 1 |: O. I) K. L) F b1 \1 T. P' b7 u$ r
| 6076391e-e731-49ca-a807-947f488eafc4 | 0 |6 Y' I. T, g& f& b' @8 ]* j
| 673ba259-1e09-446c-b401-a5d648709010 | 1 |
" E# _1 R8 ~, t( n" z| 69feb745-1f87-4756-9783-018378eb93cb | 1 |; ^' P/ K) j0 I( M- u( Z2 e) q
| 6a163325-9ca4-4aab-813a-34936495498e | 1 |
, y4 I8 {; r' w6 r {2 S0 Q' {| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 1 |
) M+ N- n1 E9 Y0 I| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 1 |4 `- [% N6 Y& Z( w) ^
| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 1 |: y/ r7 X, A, `- j3 z( l
| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 1 |
. j9 s) \+ W+ g- X; ^, b1 \. r8 G| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 1 |& l4 {* {: d, @4 [
| 885290f6-c90e-4733-acac-ffc26bc03385 | 1 |$ k8 C9 f; c* I1 @0 e
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 1 |
. \8 h2 |0 H3 x3 ^! o| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 1 |9 t$ r# Y! w$ S+ k: w R
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 1 |
! z. _, [! G% f| a996f2df-611b-4a17-8698-155998df9638 | 1 |; F& G# [0 z8 W7 c: |. k
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 1 |
6 E* _% E$ ~' j$ o6 Y| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 1 |
8 V# P( k1 a) W8 c1 @ O! l3 q| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 1 |, w% X! }; G# ]6 [# x1 |$ j: v+ c
| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 1 |
2 u; r, k+ R _* A5 C' V: N0 e3 F| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 1 |
' G/ c3 U4 a) @- b) s: w| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 1 |3 n% V# D' N7 |/ k5 K: A0 g
| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 1 |! N" g. Z+ `* e' U
| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 0 |- U& K: H: T6 x
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 1 |
( i% x! w" G g2 I9 A ^+ y7 Z w| ea70424f-f8cc-4129-8447-5f94c30af872 | 1 |
6 \$ a! q! _# Q$ h4 Z| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 1 |& L" \2 E) l% s3 B3 j* M
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 1 |& |( N. p$ T* W
+--------------------------------------+-----------------------+, S# O. m# o3 }( H) \/ K9 R
35 rows in set (0.00 sec)6 F$ r$ ^( t w0 M2 W; q( F
MariaDB [neutron]> select * from ipallocations ;& X4 h3 C$ S% A+ P8 x
+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
w# T E1 s# n0 t a| port_id | ip_address | subnet_id | network_id |1 f; U; J6 l4 I; N8 _1 s5 q a6 ~9 z) z" m
+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
0 }, u( O4 ?. P% o2 D/ \| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 10.101.102.3 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
9 o+ d. T: n8 Q8 @. Z- d| 1a864374-7926-44d4-b047-4fe182b9788b | 10.101.103.13 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 82c02dbf-e2ca-48ec-9c3f-d106ba789347 |
. k! n9 j4 w U* J S" L| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 10.101.102.10 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
2 j3 v! @$ B& [/ \| 26c2b56d-03ba-4679-8b38-241cf3949645 | 10.101.104.105 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |& r. V$ ?3 e$ y1 I8 G9 o- X0 p
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 10.101.102.28 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
3 b0 B# G% z$ \; \" X/ b. W9 \& p% V| 2f511e86-c37f-462c-9ece-54de4ff411ac | 10.101.102.9 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |8 g# Q9 X! |" ?2 o# R. w
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 10.101.102.5 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |3 t: Z' V. {6 \5 D6 q. q# s
| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 10.101.102.6 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
6 n* n, P7 Y Y. C| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 10.101.102.17 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |( ]4 t3 I8 u, y6 F ?+ t1 Q
| 6076391e-e731-49ca-a807-947f488eafc4 | 10.101.104.2 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |" S3 y# T, @( h9 O+ ?
| 673ba259-1e09-446c-b401-a5d648709010 | 10.101.102.34 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
, \1 Q. U5 a- O: s# |! J| 69feb745-1f87-4756-9783-018378eb93cb | 10.101.102.23 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
% i$ y: V* \6 t| 6a163325-9ca4-4aab-813a-34936495498e | 10.101.102.14 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |- \8 N9 j$ K2 K! y. {; E8 T
| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 10.101.102.26 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
% ^. t, c- n( _1 Y( l. \| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 10.101.102.7 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
. t7 c4 b0 @# G6 @7 s6 @| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 10.101.102.20 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |; R: d0 c% a {1 ~
| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 10.101.102.33 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |! Y p Y% W6 \" y) |9 V$ M7 p' @* ^
| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 10.101.102.32 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |- E" \; [& i$ Z
| 885290f6-c90e-4733-acac-ffc26bc03385 | 10.101.102.19 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
3 E! C0 l, P ]5 h! U, k. M Q8 X% }| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 10.101.102.4 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |4 @3 J8 p6 X4 b6 }- {
| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 10.101.102.2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
0 p/ c% x' I* ~0 c9 U( T| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
9 E- Q- k' F m( o$ \; E| a996f2df-611b-4a17-8698-155998df9638 | 10.101.102.24 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |% N( c' [; v+ ~1 B. }6 d) r6 S2 B% n
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 10.101.102.27 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
1 z5 U7 B9 ^9 F D* Y| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 10.101.102.12 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
: ^5 p+ J. N, C$ s; f| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 10.101.102.15 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
; U4 u/ f! L5 q3 `| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 10.101.102.18 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |# m! b7 t3 }; p. G7 M
| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 10.101.102.21 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
$ \& _$ i5 d: p# o| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 10.101.102.8 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
0 B- u% ~0 \4 K- n* B& o0 Y) y( k| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 10.101.102.22 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
9 h% i y* ?0 n: ~8 V0 T+ T8 O| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 10.101.104.14 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
5 d: z9 u, F! M) ]9 {% A$ v1 [| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 10.101.102.25 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
5 \: M1 D$ s/ M) _* x q| ea70424f-f8cc-4129-8447-5f94c30af872 | 10.101.102.13 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |4 I: w: Y2 ?$ o
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 10.101.102.30 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |9 R {1 r! q) j: x; J- [
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |7 W$ |; }$ W1 P; P) H. r s. Q
+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
9 ~% x0 G* j! {3 T! ~% \6 H5 {35 rows in set (0.00 sec)
/ s7 r( D* K* o* C# }1 |MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;
, z- A! X4 r$ k( z1 I8 S2 `Empty set (0.01 sec); Y. [4 q4 G8 @3 m
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1' ;7 M2 @7 T2 T2 y
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+# \5 M) f$ B' f. Y
| port_id | ip_address | subnet_id | network_id |0 P+ o: k }' d3 V) g* A
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+/ t) E% G, K4 h/ V! n: z+ z% K
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d | P# |* t2 e7 i/ H
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+
/ o% M, ?! E$ f! u2 ]1 Y1 row in set (0.00 sec)
: S, P+ `" s! `1 }: [- UMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.11' ;6 m, L$ F/ x" Q+ A; b
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
7 E1 B6 ^) U0 B/ r6 E: K& T| port_id | ip_address | subnet_id | network_id |2 n- B3 O3 c' Y
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+. {% j6 R5 P: v7 N% Q
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |4 [$ L6 I6 _: r
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
) W' |% M5 k o1 row in set (0.00 sec) N% t' L- o& C8 s& q+ ?0 i* A9 I
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1*' ;4 F/ H1 p6 `, K* E. F1 @7 \
Empty set (0.00 sec)
% h9 f7 O# |' kMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;
5 j" P3 t5 p$ T4 J4 T4 I tEmpty set (0.00 sec)
; ~3 @. [ I. nMariaDB [neutron]> select * from ipavailabilityrange where ip_address='10.101.102.16' ;" g# o& M, |) [- _
ERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist
: J; m* h# F5 N5 jMariaDB [neutron]> select * from ipavailabilityrange ;
# r. }0 v* k- \ p" ]- A( W( E5 R! kERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist
s, o9 _' D$ |+ dMariaDB [neutron]> select * from ipamallocationpools ;/ |% O) Y4 p* E" G4 s6 f
+--------------------------------------+--------------------------------------+----------------+----------------+2 T2 S6 P3 f" h! f
| id | ipam_subnet_id | first_ip | last_ip |
, K" X% S5 Y1 R' o7 B, c+--------------------------------------+--------------------------------------+----------------+----------------+% e- K! y) M6 p* q. p& T9 T( P
| 9797b147-8198-4de9-9e5c-d16d84a56825 | 5711d030-3af4-48ef-8843-543af61a3cd7 | 10.101.104.1 | 10.101.104.253 |
/ }* s' \0 ^7 V* }| c5cf06df-3015-4685-b2e3-4e21850a1012 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.1 | 10.101.103.99 |
8 p5 V' r2 \( s! v6 w& ~8 || ca29d040-54c6-4621-a457-ac430c20d3f1 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.200 | 10.101.103.253 |7 P) C5 f8 O7 X8 q* d
| d9474fb4-2a6a-4d84-86ae-283b06185857 | f4879db9-c192-4208-be21-2384929abaf3 | 10.101.102.1 | 10.101.102.253 |
+ m( S" B% G3 g$ i7 k+--------------------------------------+--------------------------------------+----------------+----------------+
( X1 y% u' E; P4 |5 n4 l4 rows in set (0.00 sec)
3 L1 |$ ?$ n; ^% s* W% z9 rMariaDB [neutron]> select * from ipallocationpools ;
- [9 K) V0 s7 ?+--------------------------------------+--------------------------------------+----------------+----------------+, q5 P1 M2 h% A Z# b% @
| id | subnet_id | first_ip | last_ip |4 ?9 L" }5 t9 o2 C
+--------------------------------------+--------------------------------------+----------------+----------------+' p9 N1 R5 b5 r& t
| 221fd87b-0556-401a-9130-dcbf45107e15 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.200 | 10.101.103.253 |
) ?% G; {8 u$ A* \8 @' z( i2 t| 78fe6a3c-1ccf-4e29-9574-1942a2dd10ed | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.1 | 10.101.103.99 |
$ n2 v$ e& x1 Z| e2587070-8def-4e55-9ffe-55a2e51cd9c1 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 10.101.104.1 | 10.101.104.253 |8 B/ y7 R$ M5 l, y4 Y
| fad83ad2-378a-47d7-aa30-bc8234cceff2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 10.101.102.1 | 10.101.102.253 |; |; b* o. Y5 B6 J
+--------------------------------------+--------------------------------------+----------------+----------------+, a( I- s: |5 {8 J; A1 ]
4 rows in set (0.00 sec)# o; Y1 }' T+ s8 F0 L
|
|
/4 
|返回首页|Archiver|小黑屋|易陆发现技术论坛
( 蜀ICP备2026014127号-1 )
窥视卡
雷达卡
发表于 2021-11-25 00:00:08
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
照妖镜