- 积分
- 16840
在线时间 小时
最后登录1970-1-1
|
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
您需要 登录 才可以下载或查看，没有账号？开始注册
x
MariaDB [neutron]> select id,mac_address,device_id from ports;, L5 C, [4 E, e
+--------------------------------------+-------------------+-------------------------------------------------------------------------------+
( Q# a; D2 m8 [: c| id | mac_address | device_id |
* T* E- q: m3 { R8 p' g2 m+--------------------------------------+-------------------+-------------------------------------------------------------------------------+# \, | u9 u/ \: ^0 N* u
| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | fa:16:3e:f3:6a:61 | 714e03e2-78a1-48e7-bdcc-98cf72012b4e |# o2 z* S9 K" f6 b+ U3 c! i
| 1a864374-7926-44d4-b047-4fe182b9788b | fa:16:3e:25:dd:bc | 35b1e14e-1b4f-46b5-8c50-871705a96b36 |
- \' y, b E$ n3 Z6 O y| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | fa:16:3e:86:3d:3f | c1487ea4-e354-45bd-97d1-d25c04186053 |1 K$ t% ~ Z3 ~# U6 P! F" b
| 26c2b56d-03ba-4679-8b38-241cf3949645 | fa:16:3e:02:dc:f6 | 92aa63b3-ab7b-44fa-808a-d33e5f6f3253 |
9 i$ b% w; P% Y| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | fa:16:3e:9e:ba:bc | 61b3ac44-6d9a-47c0-9f10-a86380552156 |1 H: z, K2 y& c* ]
| 2f511e86-c37f-462c-9ece-54de4ff411ac | fa:16:3e:dc:dc:b3 | bf6482f3-cbaf-4e6f-b0ae-eab1aa234a73 |
- [2 j$ ^- p$ e' t) l2 n| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | fa:16:3e:ed:4c:ad | eefdc520-99d3-43ca-8d19-ee0ceb02200e |
, Q0 D5 W: V, H8 h' ]: B: e: e| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | fa:16:3e:4a:47:2e | b63fa7c6-4a40-4824-9710-b1eeab2cefaf |% h$ Q2 Z5 u2 I+ S
| 53a87f50-41af-446c-ae4a-ef7ef0484877 | fa:16:3e:bd:5c:f5 | 87056023-5cd4-48ac-a675-d503bcb3cfb2 |1 f/ }9 a2 p" J
| 6076391e-e731-49ca-a807-947f488eafc4 | fa:16:3e:b6:e5:6f | dhcp57aa2c89-eb31-5aa6-baa3-9db19f8fe78d-4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |
' N' @* z8 R; C0 s+ O: r| 673ba259-1e09-446c-b401-a5d648709010 | fa:16:3e:9f:0c:be | aace037f-9503-448a-ada6-faa2fcb88540 |
0 a: X5 T2 G! ?. a9 || 69feb745-1f87-4756-9783-018378eb93cb | fa:16:3e:14:21:5d | 905dd6ea-2b05-432a-9704-dab1f496ffcd |
! \, m+ e5 _8 [| 6a163325-9ca4-4aab-813a-34936495498e | fa:16:3e:ab:a5:c6 | 08331d00-0ff4-4044-9bc7-cdf6d2e1b804 |
n# C* y8 \' @4 ]. y| 72247f1c-a9fa-4d61-ac9b-458f44756796 | fa:16:3e:5f:86:bc | 3f0aeeea-f232-4f5b-81b6-96b8d222630e |+ P. j1 J Q* R! t" @ p
| 73378cf5-f15c-4069-93d5-5db03f7a5091 | fa:16:3e:96:5b:ae | be9445cd-bdda-4d3a-969a-c3b127cd89ff |% y7 _3 D# e# i3 W' E7 j
| 77113585-e4ac-4d66-b9ad-4e322a6816ce | fa:16:3e:01:33:ea | e588be3b-3765-4679-80e8-ea61dc2ad039 |
1 Z5 o/ m) v2 `! \/ V/ y| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | fa:16:3e:0d:fe:50 | 6626af94-61d0-4f74-948b-734c34969933 |
! ]: y7 b/ X; [6 H3 v- e# T5 ~% h| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | fa:16:3e:c5:26:d0 | 1119aac5-d6f4-40e4-92c1-a541ca2b5603 |
9 B" P0 S4 s) {$ ?5 x: x| 885290f6-c90e-4733-acac-ffc26bc03385 | fa:16:3e:09:b5:e6 | 9b592059-2acd-4962-ae05-dbfd8b2f2851 |8 M* ]$ a1 P8 A" Z8 f2 j
| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | fa:16:3e:b4:b4:4a | fb9d360f-bf85-41d0-a11c-7da528ade98a |
|( N: [4 M5 b' F2 ]$ }! S| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | fa:16:3e:03:cc:9d | |' c1 B; W: J8 T4 g1 r2 c
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | fa:16:3e:05:26:6f | 08b9e4e2-5594-4a07-bd79-9cc61fa109d4 |
/ j0 m9 n+ X5 j- c0 W3 G| a996f2df-611b-4a17-8698-155998df9638 | fa:16:3e:1a:e1:0c | 2757130d-b5ea-4a19-b8eb-5949385c8df2 |4 x6 R5 {* k, |3 Z
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | fa:16:3e:50:6c:e6 | 43b8d644-8ec9-4d3f-bc7d-9d1c49518c08 |$ n7 q. ?% f4 A8 I1 d$ C7 K$ ?4 u
| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | fa:16:3e:fe:ba:59 | f4c09f55-2898-4961-8692-7c44fb27e070 |" R e5 M" N. z/ d. x. d5 w
| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | fa:16:3e:88:34:74 | b2a989e6-c143-4dc6-88af-5a96f5b6f74e |
; Z3 e8 P+ ~& f. k! B T| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | fa:16:3e:33:45:f1 | 4c19026c-4c62-49c2-b0b4-5f612ca2c7c8 |/ g/ ]& L8 @2 @* Z, j5 i$ B
| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | fa:16:3e:0e:6e:a8 | 48c9b28d-ab90-4954-9137-1b3991744d96 |
" x' W5 A0 ~" N- g1 m| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | fa:16:3e:b6:c4:7f | ae4ed8d3-50c1-4c6f-b04c-fc3a5083631f |3 f4 W! d% G3 `! k+ K$ G
| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | fa:16:3e:e3:c0:98 | 2c37d181-9948-42ed-8a57-8636ea53964f |
% N7 _7 ^" I r3 A6 _| da93c706-fccc-4400-a3a4-e3ca1b388c29 | fa:16:3e:a9:13:ac | 5975df9a-e6c9-41de-bf17-a86cd1146c79 |3 E0 m6 ^; O4 D4 m. \5 j
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | fa:16:3e:d2:56:f8 | 9ba64156-7928-44ed-8a54-419b6d222c42 |
5 s) e n0 V* M( b9 i0 f| ea70424f-f8cc-4129-8447-5f94c30af872 | fa:16:3e:db:45:d5 | 1d436c7c-fad4-4ac2-b4f0-64ddb1877573 |# {5 `' i1 b7 M& X* X0 q
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | fa:16:3e:9e:c8:3e | 1cd8b955-0e6d-4edc-b4e5-874e2e262321 |
0 w/ ^' ?; u! ?$ o8 \( l# Q9 Y v| f8c71615-8862-47d9-b8c3-0d3966e01e5e | fa:16:3e:1e:96:93 | dhcpcf40685d-2640-5ca8-ae55-13e97b35a6fa-450187cb-d1db-4125-a105-740c64d2fc2d |
1 t0 V) V: F& X% d+--------------------------------------+-------------------+-------------------------------------------------------------------------------+' J% t5 e& U4 j: ?8 z* D
35 rows in set (0.01 sec)5 S5 U- |& z* I+ p/ S3 R `
MariaDB [neutron]> select * from portbindingports;) w" B4 }% {/ U7 ]: B
Empty set (0.00 sec)8 t0 _1 Q& ~2 ]$ Y0 P
MariaDB [neutron]> select * from portdnses;. `* d+ @" P0 A* H. q& Z
Empty set (0.00 sec)
& _" X+ T2 K3 |6 a. ~0 WMariaDB [neutron]> select * from portsecuritybindings ;5 Y0 O: a- k; j
+--------------------------------------+-----------------------+" c7 }. ?* ^9 z: \$ k, y
| port_id | port_security_enabled |8 H, ?+ h2 q* J# c+ m1 h; f. S/ `0 u
+--------------------------------------+-----------------------+
( l* `$ m* G+ s1 A5 j- A5 v# v| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 1 |% D# ?* e( p+ Z* }
| 1a864374-7926-44d4-b047-4fe182b9788b | 1 |
: K( e8 {/ s0 o7 ]| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 1 |* j9 z; w, U5 c0 T1 g: M5 @
| 26c2b56d-03ba-4679-8b38-241cf3949645 | 1 |
' i: [$ |' X; Y| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 1 |
3 ^* ~( _6 a1 x* d1 G| 2f511e86-c37f-462c-9ece-54de4ff411ac | 1 |( g& l" n7 [ J* N
| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 1 |/ [2 Q$ g/ I4 K
| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 1 |
$ \9 k3 |5 e! D% p- {| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 1 | K( O+ i% }# n4 d4 \) C, E
| 6076391e-e731-49ca-a807-947f488eafc4 | 0 |
2 P% k: N5 G) ?. b. S| 673ba259-1e09-446c-b401-a5d648709010 | 1 |- r5 _5 Z7 F+ V& W
| 69feb745-1f87-4756-9783-018378eb93cb | 1 |7 n! ~3 d; D1 J+ s
| 6a163325-9ca4-4aab-813a-34936495498e | 1 |2 v% K9 j# Z% I( y
| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 1 |. m4 ~8 e+ U6 J4 k
| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 1 |, ^& D/ p9 z# S' J2 q
| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 1 |
* G$ D' V" W& \1 {" j/ P| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 1 |! f1 a" S4 T$ y5 r- C$ B8 t- D
| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 1 |
* w' Q6 {6 X* H% c# F4 E| 885290f6-c90e-4733-acac-ffc26bc03385 | 1 |
/ N# \. h. O6 \. ?7 H| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 1 |9 { X$ e4 U" U/ P; I
| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 1 |) z% H7 I, u5 p. i$ W
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 1 |+ l9 \7 [0 P$ D B8 c! p2 n
| a996f2df-611b-4a17-8698-155998df9638 | 1 |
6 o1 F1 K# q i; d0 U9 e! i* Y. |& A| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 1 |+ o6 _5 I4 X. y, {
| aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 1 |
4 r( g. j9 Q9 b! }| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 1 |. S$ r* T+ d( S+ Q! S
| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 1 |
% c0 t9 i6 o/ M0 E/ X& D$ f, i. ^, v| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 1 |: ~* k. J) s- o0 ?+ V
| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 1 |7 d# m% S$ D- r0 V
| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 1 |
& h1 f3 {- q! A/ ^4 o* d" q" T| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 0 |
u4 e% j' S2 x4 C! ?| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 1 |: s( {9 k% y/ i# r% ?7 Q/ r
| ea70424f-f8cc-4129-8447-5f94c30af872 | 1 |: A) t3 E2 n/ M2 w6 g
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 1 |
( t1 t3 C8 a+ U6 f$ G7 K( X- q! U| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 1 |
3 z. n. T& b6 n- j; q+--------------------------------------+-----------------------+ c) O- f0 X5 T; F+ m* M4 i
35 rows in set (0.00 sec)* w1 O: \3 X2 d1 h
MariaDB [neutron]> select * from ipallocations ;
' F" C) R0 p" j% s! e0 Z1 Y+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
; X6 I' c" o r+ N# O! j| port_id | ip_address | subnet_id | network_id |
1 X- a& m8 w6 K {& l! a* E+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
+ I: g# C* X5 p+ Y2 D| 1a59c4c7-4bb7-426e-8582-9fe89545d8ca | 10.101.102.3 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
2 B% |2 U3 @; k1 F/ q/ v| 1a864374-7926-44d4-b047-4fe182b9788b | 10.101.103.13 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 82c02dbf-e2ca-48ec-9c3f-d106ba789347 |
! S4 q8 T& j7 ^0 S1 m| 2211edd4-a042-4615-9a1a-db40fa4a1bd9 | 10.101.102.10 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |0 T) F9 x) e1 a5 t/ s. V( |+ c
| 26c2b56d-03ba-4679-8b38-241cf3949645 | 10.101.104.105 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |, ~; L' {9 u' i+ Q0 {! p6 t
| 2efa123d-7866-4ef0-a7f0-93c7a0bdac70 | 10.101.102.28 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |# J1 B' B8 M9 c* b% A0 T& B/ K
| 2f511e86-c37f-462c-9ece-54de4ff411ac | 10.101.102.9 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
o, |* r# E( Q# W7 g3 o: g| 310f600c-751c-46a8-a7bc-dcfb0c730c51 | 10.101.102.5 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |; k5 E; T, y# e+ \, p" s. T0 z
| 369dbe0e-03b6-4bf4-badb-2edb49afa7f3 | 10.101.102.6 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |. M. R; ]' F$ D) p
| 53a87f50-41af-446c-ae4a-ef7ef0484877 | 10.101.102.17 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |. q7 j. L, k4 Q3 `. G
| 6076391e-e731-49ca-a807-947f488eafc4 | 10.101.104.2 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |& e: h2 V+ S8 Z, s4 t) Q. w
| 673ba259-1e09-446c-b401-a5d648709010 | 10.101.102.34 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |3 i+ s2 u' P) i4 R, G
| 69feb745-1f87-4756-9783-018378eb93cb | 10.101.102.23 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
! l0 h" k0 n. u' D6 s| 6a163325-9ca4-4aab-813a-34936495498e | 10.101.102.14 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
5 N# P9 n D* W2 ^8 P; s6 |) A w7 z| 72247f1c-a9fa-4d61-ac9b-458f44756796 | 10.101.102.26 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |7 k# S2 |* p, t$ p; H
| 73378cf5-f15c-4069-93d5-5db03f7a5091 | 10.101.102.7 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |6 V: E. d2 i" B4 H4 [2 i9 _
| 77113585-e4ac-4d66-b9ad-4e322a6816ce | 10.101.102.20 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |% {" e6 z- C1 Y
| 7a8b7879-570b-41b9-ab9e-a79d646bd4bf | 10.101.102.33 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
' b! G' e% p1 M, @- K' w| 7b80e8b8-f8e4-41fa-ae47-27a881f0479b | 10.101.102.32 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |9 q# A& t& c3 k# R, z9 d: t# R; ]
| 885290f6-c90e-4733-acac-ffc26bc03385 | 10.101.102.19 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
3 p; ?0 ?+ n1 B| 890982f2-6e46-41e5-9a25-5fe7ae07c5cc | 10.101.102.4 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |9 a5 T3 S6 C5 b! ~4 Q
| 988c16f3-f19e-425c-a802-aa1fba05e3f8 | 10.101.102.2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |: `' p4 Q. e! ?7 b5 u
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |1 D( V2 ]- D; c5 r! n$ P
| a996f2df-611b-4a17-8698-155998df9638 | 10.101.102.24 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |- b; |9 L2 Y' T$ Y1 ]% o) T7 q
| ab8ec6f5-8a6d-45ff-991c-e1377390a6b5 | 10.101.102.27 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
) L( a3 m( L/ `, x) p. V. n5 m8 E) || aeaa59bb-9ac4-45d2-8f25-554e03cfab02 | 10.101.102.12 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |/ X( e7 A' s. n! j# l
| b3b27b26-aa0b-497c-8d3a-79b0bd82f13c | 10.101.102.15 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
$ I6 j( T6 [4 w$ t; h| b9f24864-3b73-4101-91a1-3ddba78c3bf7 | 10.101.102.18 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
7 L! k! q- S6 L# }| c8fe6aa2-a1a5-4d1f-9d34-29c896af4dc0 | 10.101.102.21 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |$ P7 \( m$ L1 Y8 M; o: e, ?
| cb36d037-520b-4f18-bf0e-d3816be7cbf4 | 10.101.102.8 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
: w& w1 V/ P2 I; i& V( \! X- F| cbd4c2e5-5c22-419a-ac98-ce686d1cedf9 | 10.101.102.22 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
, g* q9 ~: o" h( q| da93c706-fccc-4400-a3a4-e3ca1b388c29 | 10.101.104.14 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 4b14fc2b-c8b7-4c2b-afdf-5e7c655bc87e |3 ^$ `$ C! D% w( g
| e5004e00-a1ea-42e0-ab7e-212d1eae5189 | 10.101.102.25 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
1 N! ~6 h+ m6 m| ea70424f-f8cc-4129-8447-5f94c30af872 | 10.101.102.13 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d | T5 Q' X5 j" ?$ |4 U6 L) ]. k
| ee67a9bd-c41b-4bcd-a030-a5ad59c6a6e2 | 10.101.102.30 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |+ s2 h/ p* ?3 v9 Z* {2 c) f: P
| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |2 X0 t: N; s' P* Q. @3 q5 f
+--------------------------------------+----------------+--------------------------------------+--------------------------------------+
. g. w5 P" p1 [( _' e, I, T# s35 rows in set (0.00 sec)
/ @# G* |: x, JMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;7 _+ m( Q. b/ \. \% i8 K/ a2 Q( n
Empty set (0.01 sec)+ ^) i5 h$ `3 @+ u
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1' ;$ e3 S3 h2 Y/ c5 B' k* s( n
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+8 }! p- z* q u
| port_id | ip_address | subnet_id | network_id |
2 h- V' C" e. F- [+--------------------------------------+--------------+--------------------------------------+--------------------------------------+
0 w5 e6 R+ P, J$ Y. K% `/ x0 }| f8c71615-8862-47d9-b8c3-0d3966e01e5e | 10.101.102.1 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |; L( _8 [1 b- x7 \
+--------------------------------------+--------------+--------------------------------------+--------------------------------------+# G; M& J! D" T# w" V; S' B* }
1 row in set (0.00 sec)
3 T1 M, Y" j6 t1 ^# t2 JMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.11' ;6 _ V# O- | j/ y
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+5 C6 M6 [. l3 z7 e2 G2 ]- N" q# q( G8 L
| port_id | ip_address | subnet_id | network_id |% l, [( Y. X# j
+--------------------------------------+---------------+--------------------------------------+--------------------------------------+. Q% v6 r6 G& l/ n# e/ k# D$ }+ f$ N
| 99a74380-7faf-40ff-bddc-6d5e341f47c1 | 10.101.102.11 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 450187cb-d1db-4125-a105-740c64d2fc2d |
* W$ n; {1 A4 V. r7 F+--------------------------------------+---------------+--------------------------------------+--------------------------------------+
0 m7 Y7 z1 v. J! i8 o- y; h$ e1 row in set (0.00 sec): G8 k0 z' z% K; T3 N7 ~
MariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.1*' ;8 H( Y: S6 \8 c& ^/ A1 c: c& C0 P
Empty set (0.00 sec)
# i5 H p4 s2 {, b- t+ vMariaDB [neutron]> select * from ipallocations where ip_address='10.101.102.16' ;& O0 n' H0 }" j
Empty set (0.00 sec)7 n, p( x: ^0 V$ I5 B
MariaDB [neutron]> select * from ipavailabilityrange where ip_address='10.101.102.16' ;! C! Q) ]6 i. \0 U3 m
ERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist7 w$ ?# V0 R4 k) d8 F4 E
MariaDB [neutron]> select * from ipavailabilityrange ;
/ v7 f5 g' u: [, c+ d3 bERROR 1146 (42S02): Table 'neutron.ipavailabilityrange' doesn't exist/ n! i- G& F4 y: g& W. C3 H0 O
MariaDB [neutron]> select * from ipamallocationpools ;
- C, M' F- g& R* R+--------------------------------------+--------------------------------------+----------------+----------------+
; W2 O: w; B1 _; M7 b| id | ipam_subnet_id | first_ip | last_ip |
/ ^$ A+ H) i1 u+--------------------------------------+--------------------------------------+----------------+----------------+3 c3 A& L% s) b, D! p( l' Z# o
| 9797b147-8198-4de9-9e5c-d16d84a56825 | 5711d030-3af4-48ef-8843-543af61a3cd7 | 10.101.104.1 | 10.101.104.253 |! v# s) E% B; s' K5 b% e8 w# D
| c5cf06df-3015-4685-b2e3-4e21850a1012 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.1 | 10.101.103.99 |
6 z7 C' `" N* O v0 i" Q| ca29d040-54c6-4621-a457-ac430c20d3f1 | 3cc1af54-fe51-40fe-9578-b5910554568b | 10.101.103.200 | 10.101.103.253 |' P# a* O* s& L
| d9474fb4-2a6a-4d84-86ae-283b06185857 | f4879db9-c192-4208-be21-2384929abaf3 | 10.101.102.1 | 10.101.102.253 |+ \ ?, A2 h2 f0 V* R; S- J
+--------------------------------------+--------------------------------------+----------------+----------------+$ i& @8 V7 g- z0 B1 M8 S+ m
4 rows in set (0.00 sec). o9 H( t4 @; ?
MariaDB [neutron]> select * from ipallocationpools ;
6 c# E8 f8 \: y+--------------------------------------+--------------------------------------+----------------+----------------+, L# n4 k+ s. m$ f* B E8 L
| id | subnet_id | first_ip | last_ip |" a- a/ U3 d9 w( D5 ^
+--------------------------------------+--------------------------------------+----------------+----------------+
, [. R# g/ X! h| 221fd87b-0556-401a-9130-dcbf45107e15 | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.200 | 10.101.103.253 |2 h; |% j) v% \
| 78fe6a3c-1ccf-4e29-9574-1942a2dd10ed | eca1d0d7-d618-44ac-8af3-32f72240fee2 | 10.101.103.1 | 10.101.103.99 |& Z( l5 K7 D- }& v5 q$ G
| e2587070-8def-4e55-9ffe-55a2e51cd9c1 | 3cdd6fbc-800f-4660-aed6-b97fec64a5af | 10.101.104.1 | 10.101.104.253 |4 F; y5 ~0 p2 i9 w# `8 i
| fad83ad2-378a-47d7-aa30-bc8234cceff2 | 22829d91-da35-49f2-b63f-9cb5d6a9455f | 10.101.102.1 | 10.101.102.253 |
4 N* s& ~) J8 d+--------------------------------------+--------------------------------------+----------------+----------------+
8 \ P$ b3 p) n6 D/ x9 V9 K4 rows in set (0.00 sec)
+ S( n" f( M# F# s |
|
/4 
窥视卡
雷达卡
发表于 2021-11-25 00:00:08
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
照妖镜
