[Moscow.pm] Взрыв мозга или занимательная топология

Сб Ноя 24 12:32:58 PST 2007

> $B'*'U'V'q(B $B'!'_'U'b'V'q(B $B'R'm']'Q(B $B'g'`'b'`'j'Q(B. $B'a'b'`'S'V'b'Z'](B $B'V'W(B $B'_'Q(B $B'U'V']'V(B, $B'b'V'Y'e']'n'd'Q'd'm(B $B'e'X'V(B $B'V'c'd'n(B.
> $B'/'`(B $B'c(B $B'`'T'`'S'`'b'\'Q'^'Z(B.

$B','Q'\'Z'V(B $B'a'`']'e'i'Z']'Z'c'n(B $B'`'T'`'S'`'b'\'Z(B?

$B'*'U'V'q(B $B'!'_'U'b'V'q(B $B'g'`'b'`'j'Q(B, $B'_'`(B $B'a'b'`'g'`'U'q(B $B'a'`'c']'V'U'`'S'Q'd'V']'n'_'`(B $B'a'`(B $B'U'V'b'V'S'e(B $B'`'d(B $B'`'\'`'_'V'i'_'m'g(B
$B'e'c'd'b'`'['c'd'S(B $B'd'm(B $B'_'Z'\'`'T'U'Q(B $B'_'V(B $B'a'`']'e'i'Z'j'n(B $B'a'`']'_'`'V(B $B'U'V'b'V'S'`(B, $B'd(B.$B'\(B. $B'_'Q(B $B'a'b'Q'\'d'Z'\'V(B $B'S(B
$B'R'`']'n'j'`'[(B $B'c'V'd'Z(B $B'S'c'd'b'V'i'Q'p'd'c'q(B $B'c'Z'd'e'Q'h'Z'Z(B, $B'\'`'T'U'Q(B $B'V'c'd'n(B $B'a'b'`'a'e'c'\'Z(B. $B'4(B.$B'V(B. $B'c'`'c'V'U'_'Z'V(B
$B'\'`'^'^'e'd'Q'd'`'b'm(B $B'_'V(B $B'S'Z'U'q'd(B $B'U'b'e'T(B-$B'U'b'e'T'Q(B. $B'1'b'`'g'`'U'q(B $B'a'`'c']'V'U'`'S'Q'd'V']'n'_'`(B $B'e(B $B'S'Q'c(B $B'R'e'U'V'd(B $B'S(B
$B'o'd'`'^(B $B'^'V'c'd'V(B $B'Y'Q'd'm'\(B. $B'1'b'`'g'`'U'q(B $B'a'`(B $B'S'c'V'^(B $B'c'S'q'Y'q'^(B $B'a'`(B $B'`'i'V'b'V'U'Z(B, $B'e(B $B'S'Q'c(B $B'a'b'`'c'd'`(B
$B'a'`'c'd'b'`'Z'd'c'q(B $B'_'V'c'\'`']'n'\'`(B $B'U'V'b'V'S'n'V'S(B. $B','`'d'`'b'm'V(B $B'e'X'V(B $B'^'`'X'_'`(B $B'U'`'c'`'R'b'Q'd'n(B $B'S'b'e'i'_'e'p(B...

> > $B'A(B $B'R'm(B $B'_'Q(B $B'S'Q'j'V'^(B $B'^'V'c'd'V(B $B'U']'q(B $B'e'a'b'`'k'V'_'Z'q(B $B'c'U'V']'Q'](B $B'_'V'\'`'d'`'b'm'V(B $B'S'V'k'Z(B:
> > 1. $B'#'Y'q'](B $B'R'm(B $B'U']'q(B $B'b'Q'c'i'V'd'Q(B $B'd'`']'n'\'`(B $B'\'`'^'^'e'd'Q'd'`'b'm(B $B'Z(B $B'\'`'_'h'V'_'d'b'Q'd'`'b'm(B ($B'S'm(B $B'X'V(B
> > $B'Y'_'Q'V'd'V(B $B'^'Q'\(B-$B'Q'U'b'V'c'Q(B $B'c'S'`'Z'g(B $B'e'c'd'b'`'['c'd'S(B?).
> > 2. $B'#'m'U'V']'Z'](B $B'R'm(B $B'\'`'b'_'V'S'`'V(B $B'e'c'd'b'`'['c'd'S'`(B ($B'^'Q'\'c'Z'^'Q']'n'_'`(B $B'b'Q'S'_'`'e'U'Q']'V'_'_'`'V(B $B'`'d(B $B'`'\'`'_'V'i'V'\(B).
> > $B'/'e(B $B'V'c'd'n(B $B'X'V(B $B'e'Y'V'](B $B'c'S'q'Y'Z(B $B'U']'q(B $B'd'Q'\'`'[(B $B'd'`'a'`']'`'T'Z'Z(B, $B'S'`'d(B $B'd'Q'^(B $B'e'c'd'b'`'['c'd'S'`(B $B'Z(B
> > $B'R'V'b'Z'd'V(B. $B'/'Q(B $B'c'g'V'^'V(B - $B'e'c'd'b'`'['c'd'S'`(B $B-b(B2.
> $B'a'b'`'R']'V'^'Q(B $B'S(B $B'd'`'^(B, $B'i'd'`(B $B'\'`'b'_'V'S'm'^(B $B'e'c'd'b'`'['c'd'S'`'^(B $B'^'`'X'V'd(B $B'R'm'd'n(B $B']'p'R'`'V(B :)

$B'?'^(B. $B'#'Q'^(B $B'Z(B $B'_'e'X'_'`(B $B'-'@'"'0'&(B $B'e'c'd'b'`'['c'd'S'`(B. $B'0'_'`(B $B'd'b'V'R'e'V'd'c'q(B $B'd'`']'n'\'`(B $B'U']'q(B $B'S'm'i'Z'c']'V'_'Z'[(B.
$B',(B $B'c'Q'^'`'[(B $B'd'`'a'`']'`'T'Z'Z(B $B'c'V'd'Z(B $B'`'_'`(B $B'^'`'X'V'd(B $B'_'V(B $B'Z'^'V'd'n(B $B'`'d'_'`'j'V'_'Z'q(B, $B'd(B.$B'V(B. $B'_'V(B $B'q'S']'q'd'n'c'q(B
$B'b'V'Q']'n'_'m'^(B $B'\'`'b'_'V'^(B $B'U'V'b'V'S'Q(B. $B'1'b'`'k'V(B $B'S(B $B'\'Q'i'V'c'd'S'V(B $B'_'V'T'`(B $B'S'm'R'b'Q'd'n(B $B'e'c'd'b'`'['c'd'S'`(B,
$B'\'`'d'`'b'`'V(B $B'S'Z'U'Z'd(B $B'^'Q'\'c'Z'^'Q']'n'_'`'V(B $B'\'`']'Z'i'V'c'd'S'`(B $B'Q'U'b'V'c'`'S(B $B'\'`'^'^'e'd'Q'd'`'b'`'S(B $B'_'Q(B
$B'^'Q'\'c'Z'^'Q']'n'_'`'^(B $B'\'`']'Z'i'V'c'd'S'V(B $B'a'`'b'd'`'S(B.

> > $B','Q'\(B $B'c'd'b'`'Z'd'n(B - $B'e'X'V(B $B'a'`'U'c'\'Q'Y'Q']'Z(B: $B'`'d'\'Z'U'm'S'Q'd'n(B $B'`'\'`'_'V'i'_'m'V(B $B'Z(B $B'S'm'i'V'b'\'Z'S'Q'd'n(B $B'Z'g(B
> > $B'S'V'Y'U'V(B $B'Z'Y(B $B'S'Z'U'Z'^'`'c'd'Z(B...
> $B'S'c'W(B $B'R'm(B $B'Y'U'`'b'`'S'`(B, $B'_'`(B $B'V'c'd'n(B $B'a'b'`'R']'V'^'m(B. $B'S(B $B'd'Q'R']'Z'h'V(B 2529 $B'Y'Q'a'Z'c'V'[(B.
> $B'a'b'Z'j']'`'c'n(B $B'c'U'V']'Q'd'n(B
> delete from mactable where macaddr not in (select macaddr from mactable
> where status='private');
> $B'a'`']'e'i'Z'](B 634 $B'e'R'Z'd'm'V(B $B'Y'Q'a'Z'c'Z(B, $B'd(B.$B'V(B. $B'e'R'b'Q'](B $B'S'c'V(B $B'Y'Q'a'Z'c'Z(B $B'\'`'d'`'b'm'V(B $B'_'V(B
> $B'\']'Q'c'c'Z'f'Z'h'Z'b'`'S'Q'_'m(B $B'Z(B $B'_'V(B $B'a'b'Z'S'q'Y'Q'_'m(B $B'\(B $B'\'Q'\'`'^'e(B-$B']'Z'R'`(B $B'c'S'Z'i'e(B.
> $B'&'c'd'n(B $B'a'`'U'`'Y'b'V'_'Z'V(B, $B'i'd'`(B $B'^'`'X'_'`(B $B'c']'e'i'Q'['_'`(B $B'a'`'d'V'b'q'd'n(B $B'U'Q'_'_'m'V(B $B'`'R(B $B'e'c'd'b'`'['c'd'S'Q'g(B.
> $B'a'`'d'`'^(B $B'S'b'`'U'V(B c$B'b'Q'R'`'d'Q']'`(B

$B'?'^(B. $B'1'`'q'c'_'Z(B, $B'i'd'`(B $B'd'm(B $B'Z'^'V'_'e'V'j'n(B $B'\'Q'\(B private $B'Z(B public $B'S(B $B'U'Q'_'_'`'[(B $B'Y'Q'U'Q'i'\'V(B...

> select switch,port,count(*) from mactable where status is null group by
> switch,port;
> $B'U'Q'W'd(B $B'a'`']'_'m'[(B $B'c'a'Z'c'`'\(B $B'\'`']'Z'i'V'c'd'S'Q(B $B'e'c'd'b'`'['c'd'S(B $B'_'Q(B $B'a'`'b'd'Q'g(B up/down$B']'Z'_'\'`'S(B.
> $B'Y'Q'a'b'`'c(B
> select switch,port,count(*) from mactable where status is null and
> macaddr not in (select macaddr from mactable where switch='10.6.204.21'
> and status = 'private') group by switch,port;
> $B'e'R'Z'b'Q'V'd(B $B'Z'Y(B $B'o'd'`'T'`(B $B'c'a'Z'c'\'Q(B $B'a'`'b'd(B $B'c(B downlink$B'`'^(B.

$B'7'^(B. $B'A(B $B'd'e'd(B $B'c'd'b'e'\'d'e'b'Q'^'Z(B $B'a'V'b']'Q(B $B'`'a'V'b'Z'b'`'S'Q'](B. $B'1'b'`'k'V(B $B'S(B $B'a'Q'^'q'd'Z(B $B'a'`'b'Q'R'`'d'Q'd'n(B, $B'i'V'^(B
$B'^'e'c'\'e']'n(B $B'_'Q'a'b'q'T'Q'd'n(B. ;-)

$B'1'`'b'q'U'`'\(B $B'U'V'['c'd'S'Z'[(B:
- $B'S'm'R'Z'b'Q'V'^(B $B'\'`'b'_'V'S'`'V(B $B'e'c'd'b'`'['c'd'S'`(B
- $B'a'`']'e'i'Q'V'^(B $B'c'a'Z'c'`'\(B: $B'e'c'd'b'`'['c'd'S'`(B-$B'a'`'b'd(B = $B'c'a'Z'c'`'\(B $B'e'c'd'b'`'['c'd'S(B $B'_'Q(B $B'a'`'b'd'e(B
- $B'`'d'R'b'Q'c'm'S'Q'V'^(B $B'd'V(B $B'c'S'q'Y'\'Z(B "$B'e'c'd'b'`'['c'd'S'`(B-$B'a'`'b'd(B" $B'e(B $B'\'`'d'`'b'm'g(B $B'S(B $B'c'a'Z'c'\'V(B $B'e'c'd'b'`'['c'd'S(B
$B'a'b'Z'c'e'd'c'd'S'e'V'd(B $B'\'`'b'V'_'n(B.
$B'#(B $B'Z'd'`'T'V(B $B'a'`']'e'i'Z']'Z(B $B'c'a'Z'c'`'\(B $B'U'Q'e'_']'Z'_'\'`'S(B $B'_'Q(B $B'c'S'q'Y'\'Q'g(B "$B'e'c'd'b'`'['c'd'S'`(B-$B'a'`'b'd(B".

$B'2'Q'c'\']'Q'U'm'S'Q'V'^(B $B'a'`(B $B'o'd'`'^'e(B $B'Q']'T'`'b'd'Z'^'e(B $B'\'Q'b'd'Z'_'\'e(B $B'Z'Y(B $B'Z'Y'_'Q'i'Q']'n'_'`'T'`(B $B'a'`'c'd'Q(B
(http://zhecka.323f.net.ru/temp/topology.jpg) $B'S(B $B'c'S'q'Y'\'e(B ($B'c'i'Z'd'Q'q(B
$B'\'`'_'h'V'_'d'b'Q'd'`'b(B $B'\'Q'\(B $B'\'`'^'^'e'd'Q'd'`'b(B $B'Z(B 2 $B'e'c'd'b'`'['c'd'S'`(B $B'\'Q'\(B $B'\'`'b'_'V'S'`'V(B):
2.1: 1, d1, d2
2.2: d3
2.3: d4
2.4: d5
2.5: d6
2.8: 3, d7, d8, d9
1.1: d1
1.2: d2
1.3: - $B'S'm'\'Z'_'e']'Z(B, $B'd(B.$B'\(B. $B'S'Z'U'V']'Z(B $B'_'Q(B $B'_'V'^(B $B'e'c'd'b'`'['c'd'S'`(B 2
3.1: - $B'S'm'\'Z'_'e']'Z(B, $B'd(B.$B'\(B. $B'S'Z'U'V']'Z(B $B'_'Q(B $B'_'V'^(B $B'e'c'd'b'`'['c'd'S'`(B 2
3.2: d7
3.3: d8
3.4: d9

$B'%'Q']'n'j'V(B $B'_'Q'i'Z'_'Q'V'^(B $B'c'd'b'`'Z'd'n(B $B'c'S'q'Y'Z(B:
3 - d9 ($B'`'U'_'`'Y'_'Q'i'_'Q'q(B $B'c'S'q'Y'n(B), $B'Y'Q'a'Z'c'm'S'Q'V'^(B, $B'S'm'\'Z'U'm'S'Q'V'^(B $B'S'V'Y'U'V(B d9

$B'1'`'c']'V(B $B'a'b'`'g'`'U'Q(B $B'a'`(B $B'S'c'V'^(B $B'`'U'_'`'Y'_'Q'i'_'m'^(B $B'c'S'q'Y'q'^(B $B'a'`']'e'i'Q'V'd(B $B'\'Q'b'd'Z'_'\'Q(B:
2.8: 3
2.1: 1
$B'3'`'`'d'S'V'd'c'd'S'V'_'_'`(B $B'c'd'b'`'Z'^(B $B'o'd'Z(B $B'c'S'q'Y'Z(B $B'Z(B $B'S'c'V(B. $B'1'`']'_'`'c'd'n'p(B $B'S'c'V(B $B'c'S'q'Y'Z(B $B'a'`']'e'i'V'_'m(B.