Context Navigation

source: trunk/klask @ 323

Last change on this file since 323 was 323, checked in by g7moreau, 7 years ago
Table title update (homogeneous)
Property svn:executable set to ``* Property svn:keywords set to `Date Author Id Rev`
File size: 133.5 KB

Line
1	#!/usr/bin/perl -w
2	#
3	# Copyright (C) 2005-2017 Gabriel Moreau <Gabriel.Moreau(A)univ-grenoble-alpes.fr>
4	#
5	# $Id: klask 323 2017-10-31 10:59:46Z g7moreau $
6
7	use strict;
8	use warnings;
9	use version; our $VERSION = qv('0.7.5');
10
11	use Readonly;
12	use FileHandle;
13	use Net::SNMP;
14	#use YAML;
15	use YAML::Syck;
16	use Net::Netmask;
17	use Net::CIDR::Lite;
18	use NetAddr::IP;
19	use Getopt::Long qw(GetOptions);
20	use Socket;
21	use List::Util 'shuffle';
22	use Digest::SHA qw(sha512_base64);
23	use Text::Table; # libtext-table-perl http://blogs.perl.org/users/steven_haryanto/2014/07/benchmarking-several-ascii-table-generator-modules.html
24
25	# apt-get install snmp fping libnet-cidr-lite-perl libnet-netmask-perl libnet-snmp-perl libnetaddr-ip-perl libyaml-perl
26	# libcrypt-des-perl libcrypt-hcesha-perl libdigest-hmac-perl libtext-table-perl
27	# arping net-tools fping bind9-host arpwatch
28
29	################################################################
30	# general initialization
31	################################################################
32
33	my $KLASK_VAR = '/var/lib/klask';
34	my $KLASK_CFG_FILE = '/etc/klask/klask.conf';
35	my $KLASK_DB_FILE = "$KLASK_VAR/klaskdb";
36	my $KLASK_SW_FILE = "$KLASK_VAR/switchdb";
37
38	test_running_environnement();
39
40	my $KLASK_CFG = YAML::Syck::LoadFile("$KLASK_CFG_FILE");
41
42	my %DEFAULT = %{$KLASK_CFG->{'default'}};
43	my @SWITCH_LIST = @{$KLASK_CFG->{'switch'}};
44
45	my %SWITCH_LEVEL = ();
46	my %SWITCH_DB = ();
47	LEVEL_OF_EACH_SWITCH:
48	for my $sw (@SWITCH_LIST) {
49	$SWITCH_LEVEL{$sw->{'hostname'}} = $sw->{'level'} \|\| $DEFAULT{'switch_level'} \|\| 2;
50	$SWITCH_DB{$sw->{'hostname'}} = $sw;
51
52	# SNMP parameter initialisation
53	my %session = ( -hostname => $sw->{'hostname'} );
54	$session{-version} = $sw->{'version'} \|\| 1;
55	$session{-port} = $sw->{'snmpport'} \|\| $DEFAULT{'snmpport'} \|\| 161;
56	if (exists $sw->{'version'} and $sw->{'version'} eq '3') {
57	$session{-username} = $sw->{'username'} \|\| 'snmpadmin';
58	}
59	else {
60	$session{-community} = $sw->{'community'} \|\| $DEFAULT{'community'} \|\| 'public';
61	}
62	$sw->{'snmp_param_session'} = \%session;
63	}
64	@SWITCH_LIST = reverse sort { $SWITCH_LEVEL{$a->{'hostname'}} <=> $SWITCH_LEVEL{$b->{'hostname'}} } @{$KLASK_CFG->{'switch'}};
65
66	#my %SWITCH_PORT_COUNT = ();
67
68	my %CMD_DB = (
69	'help' => \&cmd_help,
70	'version' => \&cmd_version,
71	'exportdb' => \&cmd_exportdb,
72	'updatedb' => \&cmd_updatedb,
73	'searchdb' => \&cmd_searchdb,
74	'removedb' => \&cmd_removedb,
75	'cleandb' => \&cmd_cleandb,
76	'search' => \&cmd_search,
77	'enable' => \&cmd_enable,
78	'disable' => \&cmd_disable,
79	'status' => \&cmd_status,
80	'updatesw' => \&cmd_updatesw,
81	'exportsw' => \&cmd_exportsw,
82	'iplocation' => \&cmd_ip_location,
83	'ip-free' => \&cmd_ip_free,
84	'search-mac-on-switch' => \&cmd_search_mac_on_switch,
85	'bad-vlan-id' => \&cmd_bad_vlan_id,
86	'poe-enable' => \&cmd_poe_enable,
87	'poe-disable' => \&cmd_poe_disable,
88	'poe-status' => \&cmd_poe_status,
89	'port-setvlan' => \&cmd_port_setvlan,
90	'port-getvlan' => \&cmd_port_getvlan,
91	'vlan-setname' => \&cmd_vlan_setname,
92	'vlan-getname' => \&cmd_vlan_getname,
93	'vlan-list' => \&cmd_vlan_list,
94	'host-setlocation' => \&cmd_host_setlocation,
95	'rebootsw' => \&cmd_rebootsw,
96	);
97
98	#Readonly my %INTERNAL_PORT_MAP => (
99	# 0 => 'A',
100	# 1 => 'B',
101	# 2 => 'C',
102	# 3 => 'D',
103	# 4 => 'E',
104	# 5 => 'F',
105	# 6 => 'G',
106	# 7 => 'H',
107	# );
108	#Readonly my %INTERNAL_PORT_MAP_REV => reverse %INTERNAL_PORT_MAP;
109
110	Readonly my %SWITCH_KIND => (
111	# HP
112	J3299A => { type => 1, model => 'HP224M', match => 'HP J3299A ProCurve Switch 224M', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
113	J4120A => { type => 1, model => 'HP1600M', match => 'HP J4120A ProCurve Switch 1600M', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
114	J9029A => { type => 1, model => 'HP1800-8G', match => 'PROCURVE J9029A', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
115	J9449A => { type => 1, model => 'HP1810-8G', match => 'HP ProCurve 1810G - 8 GE', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
116	J4093A => { type => 1, model => 'HP2424M', match => 'HP J4093A ProCurve Switch 2424M', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
117	J9279A => { type => 1, model => 'HP2510G-24', match => 'ProCurve J9279A Switch 2510G-24', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
118	J9280A => { type => 1, model => 'HP2510G-48', match => 'ProCurve J9280A Switch 2510G-48', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
119	J4813A => { type => 1, model => 'HP2524', match => 'HP J4813A ProCurve Switch 2524', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
120	J4900A => { type => 1, model => 'HP2626A', match => 'HP J4900A ProCurve Switch 2626', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
121	J4900B => { type => 1, model => 'HP2626B', match => 'J4900B.+?Switch 2626', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, }, # ProCurve J4900B Switch 2626 # HP J4900B ProCurve Switch 2626
122	J4899B => { type => 1, model => 'HP2650', match => 'ProCurve J4899B Switch 2650', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
123	J9021A => { type => 1, model => 'HP2810-24G', match => 'ProCurve J9021A Switch 2810-24G', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
124	J9022A => { type => 1, model => 'HP2810-48G', match => 'ProCurve J9022A Switch 2810-48G', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
125	J8692A => { type => 1, model => 'HP3500-24G', match => 'J8692A Switch 3500yl-24G', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
126	J4903A => { type => 1, model => 'HP2824', match => 'J4903A.+?Switch 2824,', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
127	J4110A => { type => 1, model => 'HP8000M', match => 'HP J4110A ProCurve Switch 8000M', revision => qr{ProCurve .*?, revision (\w[\d\.]+?), ROM}, },
128	JE074A => { type => 2, model => 'HP5120-24G', match => 'HP Comware.+?A5120-24G EI Switch', revision => qr{Comware .*? Version (\d[\d\.]+?) Release}, },
129	JE069A => { type => 2, model => 'HP5120-48G', match => 'HP Comware.+?A5120-48G EI Switch', revision => qr{Comware .*? Version (\d[\d\.]+?) Release}, },
130	JD377A => { type => 2, model => 'HP5500-24G', match => 'HP Comware.+?A5500-24G EI Switch', revision => qr{Comware .*? Version (\d[\d\.]+?) Release}, },
131	JD374A => { type => 2, model => 'HP5500-24F', match => 'HP Comware.+?A5500-24G-SFP EI ', revision => qr{Comware .*? Version (\d[\d\.]+?) Release}, },
132	# BayStack
133	BS350T => { type => 1, model => 'BS350T', match => 'BayStack 350T HW' },
134	# Nexans
135	N3483G => { type => 2, model => 'NA3483-6G', match => 'GigaSwitch V3 TP SFP-I 48.+ ES3', revision => qr{GigaSwitch .*?/SECURITY/V(\d[\d\.]+\w?)\)}, },
136	N3483P => { type => 2, model => 'NA3483-6P', match => 'GigaSwitch V3 TP.PSE.+ 48/54V ES3', revision => qr{GigaSwitch .*?/SECURITY/V(\d[\d\.]+\w?)\)}, }, # GigaSwitch V3 TP(PSE+) SFP-I 48/54V ES3 (HW3/ENHANCED/SECURITY/V4.10C)
137	# DELL
138	PC7024 => { type => 2, model => 'DPC7024', match => 'PowerConnect 7024,.+?VxWorks', revision => qr{PowerConnect .*?, (\d[\d\.]+?), VxWorks}, },
139	N2048 => { type => 2, model => 'DN2048', match => 'Dell Networking N2048,', revision => qr{Dell Networking .*?, (\d[\d\.]+?), Linux}, },
140	N4032F => { type => 2, model => 'DN4032F', match => 'Dell Networking N4032F,', revision => qr{Dell Networking .*?, (\d[\d\.]+?), Linux}, },
141	N4064F => { type => 2, model => 'DN4064F', match => 'Dell Networking N4064F,', revision => qr{Dell Networking .*?, (\d[\d\.]+?), Linux}, },
142	# 3COM
143	'H3C5500' => { type => 1, model => 'H3C5500', match => 'H3C S5500-SI Series' },
144	'3C17203' => { type => 1, model => '3C17203', match => '3Com SuperStack 3 24-Port' },
145	'3C17204' => { type => 1, model => '3C17204', match => '3Com SuperStack 3 48-Port' },
146	'3CR17562-91' => { type => 1, model => '3CR17562-91', match => '3Com Switch 4500 50-Port' },
147	'3CR17255-91' => { type => 1, model => '3CR17255-91', match => '3Com Switch 5500G-EI 48-Port' },
148	'3CR17251-91' => { type => 1, model => '3CR17251-91', match => '3Com Switch 5500G-EI 48-Port' },
149	'3CR17571-91' => { type => 1, model => '3CR17571-91', match => '3Com Switch 4500 PWR 26-Port' },
150	'3CRWX220095A' => { type => 1, model => '3CRWX220095A', match => '3Com Wireless LAN Controller' },
151	'3CR17254-91' => { type => 1, model => '3CR17254-91', match => '3Com Switch 5500G-EI 24-Port' },
152	'3CRS48G-24S-91' => { type => 1, model => '3CRS48G-24S-91', match => '3Com Switch 4800G 24-Port' },
153	'3CRS48G-48S-91' => { type => 1, model => '3CRS48G-48S-91', match => '3Com Switch 4800G 48-Port' },
154	'3C17708' => { type => 1, model => '3C17708', match => '3Com Switch 4050' },
155	'3C17709' => { type => 1, model => '3C17709', match => '3Com Switch 4060' },
156	'3C17707' => { type => 1, model => '3C17707', match => '3Com Switch 4070' },
157	'3CR17258-91' => { type => 1, model => '3CR17258-91', match => '3Com Switch 5500G-EI 24-Port SFP' },
158	'3CR17181-91' => { type => 1, model => '3CR17181-91', match => '3Com Switch 5500-EI 28-Port FX' },
159	'3CR17252-91' => { type => 1, model => '3CR17252-91', match => '3Com Switch 5500G-EI PWR 24-Port' },
160	'3CR17253-91' => { type => 1, model => '3CR17253-91', match => '3Com Switch 5500G-EI PWR 48-Port' },
161	'3CR17250-91' => { type => 1, model => '3CR17250-91', match => '3Com Switch 5500G-EI 24-Port' },
162	'3CR17561-91' => { type => 1, model => '3CR17561-91', match => '3Com Switch 4500 26-Port' },
163	'3CR17572-91' => { type => 1, model => '3CR17572-91', match => '3Com Switch 4500 PWR 50-Port' },
164	'3C17702-US' => { type => 1, model => '3C17702-US', match => '3Com Switch 4900 SX' },
165	'3C17700' => { type => 1, model => '3C17700', match => '3Com Switch 4900' },
166	);
167
168	Readonly my %OID_NUMBER => (
169	sysDescription => '1.3.6.1.2.1.1.1.0',
170	sysName => '1.3.6.1.2.1.1.5.0',
171	sysContact => '1.3.6.1.2.1.1.4.0',
172	sysLocation => '1.3.6.1.2.1.1.6.0',
173	searchPort1 => '1.3.6.1.2.1.17.4.3.1.2', # BRIDGE-MIB (802.1D).
174	searchPort2 => '1.3.6.1.2.1.17.7.1.2.2.1.2', # Q-BRIDGE-MIB (802.1Q) add 0 if unknown vlan id
175	vlanPortDefault => '1.3.6.1.2.1.17.7.1.4.5.1.1', # dot1qPvid
176	vlanStatus => '1.3.6.1.2.1.17.7.1.4.3.1.5', # integer 4 Create, 6 Destroy
177	vlanName => '1.3.6.1.2.1.17.7.1.4.3.1.1', # string
178	HPicfReset => '1.3.6.1.4.1.11.2.14.11.1.4.1', # HP reboot switch
179	ifIndex => '1.3.6.1.2.1.17.1.4.1.2', # dot1dBasePortIfIndex - Interface index redirection
180	ifName => '1.3.6.1.2.1.31.1.1.1.1', # Interface name (give port number)
181	portUpDown => '1.3.6.1.2.1.2.2.1.7', # 1.3.6.1.2.1.2.2.1.7.NoPort = 1 (up) = 2 (down)
182	poeState => '1.3.6.1.2.1.105.1.1.1.3.1', # 1.3.6.1.2.1.105.1.1.1.3.1.NoPort = 1 (poe up) = 2 (poe down) - Cisco and Zyxel
183	NApoeState => '1.3.6.1.4.1.266.20.3.1.1.21', # .NoPort = 2 (poe off) = 8 (poe atHighPower) - Nexans
184	ifAggregator => '1.2.840.10006.300.43.1.2.1.1.12', # dot3adAggPortSelectedAggID - 0 not part of an Aggregator - Ciso Dell HP Comware - See https://stackoverflow.com/questions/14960157/how-to-map-portchannel-to-interfaces-via-snmp https://gist.github.com/bldewolf/6314435
185	);
186
187	Readonly my %PORT_UPDOWN => (
188	1 => 'enable',
189	2 => 'disable',
190	);
191
192	Readonly my $RE_MAC_ADDRESS => qr{ [0-9,A-Z]{2} : [0-9,A-Z]{2} : [0-9,A-Z]{2} : [0-9,A-Z]{2} : [0-9,A-Z]{2} : [0-9,A-Z]{2} }xms;
193	Readonly my $RE_IPv4_ADDRESS => qr{ [0-9]{1,3} \. [0-9]{1,3} \. [0-9]{1,3} \. [0-9]{1,3} }xms;
194
195	Readonly my $RE_FLOAT_HOSTNAME => $DEFAULT{'float-regex'} \|\| qr{ ^float }xms;
196
197	Readonly my $SEP_AGGREGATOR_PORT => ','; # : is already use to join switch and port
198	Readonly my $SEP_SWITCH_PORT => ':';
199
200
201	################################################################
202	# main program
203	################################################################
204
205	my $cmd = shift @ARGV \|\| 'help';
206	if (defined $CMD_DB{$cmd}) {
207	$CMD_DB{$cmd}->(@ARGV);
208	}
209	else {
210	print {*STDERR} "klask: command $cmd not found\n\n";
211	$CMD_DB{'help'}->();
212	exit 1;
213	}
214
215	exit;
216
217	################################################################
218	# subroutine
219	################################################################
220
221	#---------------------------------------------------------------
222	sub test_running_environnement {
223	die "Configuration file $KLASK_CFG_FILE does not exists. Klask need it !\n" if not -e "$KLASK_CFG_FILE";
224	die "Var folder $KLASK_VAR does not exists. Klask need it !\n" if not -d "$KLASK_VAR";
225	return;
226	}
227
228	#---------------------------------------------------------------
229	sub test_switchdb_environnement {
230	die "Switch database $KLASK_SW_FILE does not exists. Launch updatesw before this command !\n" if not -e "$KLASK_SW_FILE";
231	return;
232	}
233
234	#---------------------------------------------------------------
235	sub test_maindb_environnement {
236	die "Main database $KLASK_DB_FILE does not exists. Launch updatedb before this command !\n" if not -e "$KLASK_DB_FILE";
237	return;
238	}
239
240	#---------------------------------------------------------------
241	# fast ping dont l'objectif est de remplir la table arp de la machine
242	sub fast_ping {
243	# Launch this command without waiting...
244	system "fping -q -c 1 @_ > /dev/null 2>&1 &";
245	return;
246	}
247
248	#---------------------------------------------------------------
249	sub shell_command {
250	my $cmd = shift;
251
252	my $fh = new FileHandle;
253	my $result = '';
254	open $fh, q{-\|}, "LANG=C $cmd" or die "Can't exec $cmd\n";
255	$result .= <$fh>;
256	close $fh;
257	chomp $result;
258	return $result;
259	}
260
261	#---------------------------------------------------------------
262	# donne l'@ ip, dns, arp en fonction du dns OU de l'ip
263	sub resolve_ip_arp_host {
264	my $param_ip_or_host = shift;
265	my $interface = shift \|\| q{*};
266	my $type = shift \|\| q{fast};
267	my $already = shift \|\| q{yes};
268
269	my %ret = (
270	hostname_fq => 'unknow',
271	ipv4_address => '0.0.0.0',
272	mac_address => 'unknow',
273	);
274
275	# perl -MSocket -E 'say inet_ntoa(scalar gethostbyname("tech7meylan.hmg.inpg.fr"))'
276	my $packed_ip = scalar gethostbyname($param_ip_or_host);
277	return %ret if not defined $packed_ip;
278	$ret{'ipv4_address'} = inet_ntoa($packed_ip);
279	#if ($ret{'ipv4_address'} !~ m/$RE_IPv4_ADDRESS/) {
280	# print "Error: for computer $param_ip_or_host on interface $interface, IP $ret{'ipv4_address'} is not valide\n";
281	# return %ret;
282	# }
283
284	# perl -MSocket -E 'say scalar gethostbyaddr(inet_aton("194.254.66.240"), AF_INET)'
285	my $hostname_fq = scalar gethostbyaddr($packed_ip, AF_INET) if $already eq 'yes';
286	$ret{'hostname_fq'} = $hostname_fq if defined $hostname_fq;
287
288	# my $cmd = q{grep -he '\b} . $param_ip_or_host . q{\b' } . "/var/lib/arpwatch/$interface.dat \| sort -rn -k 3,3 \| head -1";
289	#my $cmd = q{grep -he '\b} . $ret{'ipv4_address'} . q{\b' } . "/var/lib/arpwatch/$interface.dat \| sort -rn -k 3,3 \| head -1";
290	my $cmd = q{grep -He '\b} . $ret{'ipv4_address'} . q{\b' } . "/var/lib/arpwatch/$interface.dat" . '\| sed -e \'s\|^/var/lib/arpwatch/\(.*\)\.dat:\|\1 \|;\' \| sort -rn -k 4,4 \| head -1';
291	#grep -He 194.254.66.252 /var/lib/arpwatch/.dat \| sed -e 's\|^/var/lib/arpwatch/\(.\)\.dat:\|\1\t\|;' \| sort -rn -k 4,4 \| head -1
292
293	my $cmd_arpwatch = shell_command $cmd;
294	#my ($arp, $ip, $timestamp, $host) = split m/ \s+ /xms, $cmd_arpwatch;
295	my ($interface2, $arp, $ip, $timestamp, $host) = split m/ \s+ /xms, $cmd_arpwatch;
296
297	$ret{'interface'} = $interface2 \|\| $interface;
298	$ret{'mac_address'} = $arp if $arp;
299	$ret{'timestamp'} = $timestamp if $timestamp;
300
301	my $nowtimestamp = time;
302
303	if ( $type eq 'fast' and ( not defined $timestamp or $timestamp < ( $nowtimestamp - 45 * 60 ) ) ) { # 45 min
304	$ret{'mac_address'} = 'unknow';
305	return %ret;
306	}
307
308	# ARP result
309	#
310	# LANG=C arp -a 194.254.66.62 -i eth331
311	# gw66-62.legi.grenoble-inp.fr (194.254.66.62) at 00:08:7c:bb:0f:c0 [ether] on eth331
312	#
313	# LANG=C ip neigh show to 194.254.66.62 dev eth331
314	# 194.254.66.62 lladdr 00:08:7c:bb:0f:c0 REACHABLE
315	# LANG=C ip neigh show to 194.254.66.62
316	# 194.254.66.62 dev eth331 lladdr 00:08:7c:bb:0f:c0 REACHABLE
317	# my $cmd_arp = shell_command "arp -a $param_ip_or_host -i $ret{'interface'}";
318	# if ( $cmd_arp =~ m{ (\S*) \s \( ( $RE_IPv4_ADDRESS ) \) \s at \s ( $RE_MAC_ADDRESS ) }xms ) {
319	# ( $ret{'hostname_fq'}, $ret{'ipv4_address'}, $ret{'mac_address'} ) = ($1, $2, $3);
320	# }
321	if ($ret{'mac_address'} eq 'unknow') {
322	# Last chance to have the mac_address
323	if ($ret{'interface'} eq '*') {
324	my $cmd_arp = shell_command "ip neigh show to $ret{'ipv4_address'}";
325	if ( $cmd_arp =~ m{ ^$RE_IPv4_ADDRESS \s dev \s ([\w\d\.\:]+) \s lladdr \s ( $RE_MAC_ADDRESS ) \s }xms ) {
326	($ret{'interface'}, $ret{'mac_address'}) = ($1, $2);
327	}
328	}
329	else {
330	my $cmd_arp = shell_command "ip neigh show to $ret{'ipv4_address'} dev $ret{'interface'}";
331	if ( $cmd_arp =~ m{ ^$RE_IPv4_ADDRESS \s lladdr \s ( $RE_MAC_ADDRESS ) \s }xms ) {
332	$ret{'mac_address'} = $1;
333	}
334	}
335	}
336
337	# Normalize MAC Address
338	if ($ret{'mac_address'} ne 'unknow') {
339	my @paquets = ();
340	for ( split m/ : /xms, $ret{'mac_address'} ) {
341	my @chars = split m//xms, uc "00$_";
342	push @paquets, "$chars[-2]$chars[-1]";
343	}
344	$ret{'mac_address'} = join q{:}, @paquets;
345	}
346
347	return %ret;
348	}
349
350	#---------------------------------------------------------------
351	# Find Surname of a switch
352	sub get_switch_model {
353	my $sw_snmp_description = shift \|\| 'unknow';
354	$sw_snmp_description =~ s/[\n\r]/ /g;
355
356	for my $sw_kind (keys %SWITCH_KIND) {
357	next if not $sw_snmp_description =~ m/$SWITCH_KIND{$sw_kind}->{'match'}/ms; # option xms break search, why ?
358
359	return $SWITCH_KIND{$sw_kind}->{'model'};
360	}
361
362	return $sw_snmp_description;
363	}
364
365	#---------------------------------------------------------------
366	# Find Revision Firmware of a switch
367	sub get_switch_revision {
368	my $sw_snmp_description = shift \|\| 'unknow';
369	$sw_snmp_description =~ s/[\n\r]/ /g;
370
371	for my $sw_kind (keys %SWITCH_KIND) {
372	next if not $sw_snmp_description =~ m/$SWITCH_KIND{$sw_kind}->{'match'}/ms; # option xms break search, why ?
373	last if not exists $SWITCH_KIND{$sw_kind}->{'revision'};
374
375	my ($revision) = $sw_snmp_description =~ m/$SWITCH_KIND{$sw_kind}->{'revision'}/xms;
376	return $revision \|\| 'unknow';
377	}
378
379	return 'unknow';
380	}
381
382	#---------------------------------------------------------------
383	# Get switch name and switch model
384	sub init_switch_names {
385	my ($verbose, $verb_description, $check_hostname, $check_location) = @_;
386
387	printf "%-26s %-25s %s\n",'Switch','Description','Type(Revision)' if $verbose;
388	print "----------------------------------------------------------------------------------\n" if $verbose;
389
390	INIT_EACH_SWITCH:
391	for my $sw (my @CLONE = @SWITCH_LIST) { # Make a local clone because some element can be deleted
392	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
393	print "$error \n" if $error;
394
395	my $result = $session->get_request(
396	-varbindlist => [
397	$OID_NUMBER{'sysDescription'},
398	$OID_NUMBER{'sysName'},
399	$OID_NUMBER{'sysContact'},
400	$OID_NUMBER{'sysLocation'},
401	]
402	);
403	if (!defined $result) {
404	printf {*STDERR} "ERROR: %s.\n", $session->error();
405	$session->close();
406	# Remove bad switch
407	@SWITCH_LIST = grep { $_->{'hostname'} ne $sw->{'hostname'} } @SWITCH_LIST;
408	delete $SWITCH_LEVEL{$sw->{'hostname'}} if exists $SWITCH_LEVEL{$sw->{'hostname'}};
409	delete $SWITCH_DB{$sw->{'hostname'}} if exists $SWITCH_DB{$sw->{'hostname'}};
410	next INIT_EACH_SWITCH;
411	}
412
413	$sw->{'description'} = $result->{$OID_NUMBER{'sysName'}} \|\| $sw->{'hostname'};
414	$sw->{'model'} = get_switch_model($result->{$OID_NUMBER{'sysDescription'}});
415	$sw->{'revision'} = get_switch_revision($result->{$OID_NUMBER{'sysDescription'}});
416	printf "%-26s 0--------->>>> %-25s %s\n", $sw->{'hostname'}, $sw->{'description'}, $sw->{'model'}.'('.$sw->{'revision'}.')' if $verbose;
417
418	if ($verb_description) {
419	my $desc = $result->{$OID_NUMBER{'sysDescription'}};
420	$desc =~ s/[\n\r]/ /g;
421	print " +> $sw->{'hostname'} - description: $desc\n";
422	}
423	if ($check_hostname) {
424	my ($hostname) = split /\./, $sw->{'hostname'}, 2;
425	print " +> $hostname - error internal hostname: $sw->{'hostname'}\n" if $result->{$OID_NUMBER{'sysName'}} ne $hostname;
426	}
427	if ($check_location) {
428	my $location = $result->{$OID_NUMBER{'sysLocation'}};
429	$location =~ s/^"(.+)"$/$1/;
430	print " +> $sw->{'hostname'} - error location: '$location' -> '$sw->{'location'}'\n" if $location ne $sw->{'location'};
431	}
432
433	$session->close;
434	}
435
436	print "\n" if $verbose;
437	return;
438	}
439
440	#---------------------------------------------------------------
441	# convert hexa (only 2 digits) to decimal
442	sub digit_hex2dec {
443	#00:0F:1F:43:E4:2B
444	my $car = '00' . uc shift;
445
446	return '00' if $car eq '00UNKNOW';
447	my %table = (
448	'0'=>'0', '1'=>'1', '2'=>'2', '3'=>'3', '4'=>'4',
449	'5'=>'5', '6'=>'6', '7'=>'7', '8'=>'8', '9'=>'9',
450	'A'=>'10', 'B'=>'11', 'C'=>'12', 'D'=>'13', 'E'=>'14', 'F'=>'15',
451	);
452	my @chars = split m//xms, $car;
453	return $table{$chars[-2]}*16 + $table{$chars[-1]};
454	}
455
456	#---------------------------------------------------------------
457
458	sub normalize_mac_address {
459	my $mac_address = shift;
460
461	# D07E-28D1-7AB8 or D07E.28D1.7AB8 or d07e28-d17ab8
462	if ($mac_address =~ m{^ (?: [0-9A-Fa-f]{4} [-\.]){2} [0-9A-Fa-f]{4} $}xms
463	or $mac_address =~ m{^ [0-9A-Fa-f]{6} - [0-9A-Fa-f]{6} $}xms
464	) {
465	$mac_address =~ s/[-\.]//g;
466	return join q{:}, unpack('(A2)*', uc($mac_address));
467	}
468
469	return join q{:}, map { substr( uc("00$_"), -2) } split m/ [:-] /xms, $mac_address;
470	}
471
472	#---------------------------------------------------------------
473	# convert MAC hex address to decimal
474	sub mac_address_hex2dec {
475	#00:0F:1F:43:E4:2B
476	my $mac_address = shift;
477
478	my @paquets = split m/ : /xms, $mac_address;
479	my $return = q{};
480	for (@paquets) {
481	$return .= q{.} . digit_hex2dec($_);
482	}
483	return $return;
484	}
485
486	#---------------------------------------------------------------
487	sub format_aggregator4html {
488	my $port_hr = shift;
489	$port_hr =~ s/($SEP_AGGREGATOR_PORT)/: /; # First occurence
490	$port_hr =~ s/($SEP_AGGREGATOR_PORT)/ /g; # Other occurence
491	return $port_hr;
492	}
493
494	#---------------------------------------------------------------
495	sub format_aggregator4dot {
496	my $port_hr = shift;
497	$port_hr =~ s/($SEP_AGGREGATOR_PORT)/ - /; # First occurence
498	$port_hr =~ s/($SEP_AGGREGATOR_PORT)/ /g; # Other occurence
499	return $port_hr;
500	}
501
502	#---------------------------------------------------------------
503	# fqdn_html_breakable change it's parameter, use it like chomp perl function
504
505	sub fqdn_html_breakable {
506	my $ref_fqdn = \($_[0]);
507
508	# Add HTML <wbr> before every . to permit line break
509	$$ref_fqdn =~ s{\.}{.<wbr />}g;
510	}
511
512	#---------------------------------------------------------------
513	# return the port and the switch where the computer is connected
514	sub find_switch_port {
515	my $mac_address = shift;
516	my $switch_proposal = shift \|\| q{};
517	my $vlan_id = shift \|\| 0;
518
519	my %ret;
520	$ret{'switch_description'} = 'unknow';
521	$ret{'switch_port_id'} = '0';
522
523	return %ret if $mac_address eq 'unknow';;
524
525	my @switch_search = @SWITCH_LIST;
526	if ($switch_proposal ne q{}) {
527	for my $sw (@SWITCH_LIST) {
528	next if $sw->{'hostname'} ne $switch_proposal;
529	unshift @switch_search, $sw;
530	last;
531	}
532	}
533
534	my $oid_search_port1 = $OID_NUMBER{'searchPort1'} . mac_address_hex2dec($mac_address);
535	my $oid_search_port2 = $OID_NUMBER{'searchPort2'} .'.'. $vlan_id . mac_address_hex2dec($mac_address);
536
537	LOOP_ON_SWITCH:
538	for my $sw (@switch_search) {
539	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
540	print "$error \n" if $error;
541
542	my $result = $session->get_request(
543	-varbindlist => [$oid_search_port1]
544	);
545	if (not defined $result) {
546	$result = $session->get_request(
547	-varbindlist => [$oid_search_port2]
548	);
549	$result->{$oid_search_port1} = $result->{$oid_search_port2} if defined $result;
550	}
551
552	if (not (defined $result and $result->{$oid_search_port1} ne 'noSuchInstance')) {
553	$session->close;
554	next LOOP_ON_SWITCH;
555	}
556
557	my $swport_id = $result->{$oid_search_port1};
558	my $swport_hr = snmp_get_switchport_id2hr($session, $swport_id);
559
560	$session->close;
561
562	# IMPORTANT !!
563	# ceci empeche la detection sur certains port ...
564	# en effet les switch sont relies entre eux par un cable reseau et du coup
565	# tous les arp de toutes les machines sont presentes sur ces ports (ceux choisis ici sont les miens)
566	# cette partie est a ameliore, voir a configurer dans l'entete
567	# 21->24 45->48
568	SWITCH_PORT_IGNORE:
569	for my $portignore (@{$sw->{'portignore'}}) {
570	next LOOP_ON_SWITCH if $swport_hr eq $portignore;
571	my ($swport_hr_limited) = split /$SEP_AGGREGATOR_PORT/, $swport_hr; # Beginning of the swith port (Aggregator)
572	next LOOP_ON_SWITCH if $swport_hr_limited eq $portignore;
573	}
574
575	$ret{'switch_hostname'} = $sw->{'hostname'};
576	$ret{'switch_description'} = $sw->{'description'};
577	$ret{'switch_port_id'} = $swport_id;
578	$ret{'switch_port_hr'} = $swport_hr; # human readable
579
580	last LOOP_ON_SWITCH;
581	}
582	return %ret;
583	}
584
585	#---------------------------------------------------------------
586	# search all the port on all the switches where the computer is detected
587	sub find_all_switch_port {
588	my $mac_address = shift;
589	my $vlan_id = shift \|\| 0;
590
591	my $ret = {};
592
593	return $ret if $mac_address eq 'unknow';
594
595	my $oid_search_port1 = $OID_NUMBER{'searchPort1'} . mac_address_hex2dec($mac_address);
596	my $oid_search_port2 = $OID_NUMBER{'searchPort2'} .'.'. $vlan_id . mac_address_hex2dec($mac_address);
597	LOOP_ON_ALL_SWITCH:
598	for my $sw (@SWITCH_LIST) {
599	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
600	print "$error \n" if $error;
601
602	my $result = $session->get_request(
603	-varbindlist => [$oid_search_port1]
604	);
605	if (not defined $result) {
606	$result = $session->get_request(
607	-varbindlist => [$oid_search_port2]
608	);
609	$result->{$oid_search_port1} = $result->{$oid_search_port2} if defined $result;
610	}
611
612	if (defined $result and $result->{$oid_search_port1} ne 'noSuchInstance') {
613	my $swport_id = $result->{$oid_search_port1};
614	my $swport_hr = snmp_get_switchport_id2hr($session, $swport_id);
615
616	SWITCH_PORT_IGNORE:
617	for my $portignore (@{$sw->{'portignore'}}) {
618	if ($swport_hr eq $portignore) {
619	$session->close;
620	next LOOP_ON_ALL_SWITCH
621	}
622	}
623
624	$ret->{$sw->{'hostname'}} = {};
625	$ret->{$sw->{'hostname'}}{'hostname'} = $sw->{'hostname'};
626	$ret->{$sw->{'hostname'}}{'description'} = $sw->{'description'};
627	$ret->{$sw->{'hostname'}}{'port_id'} = $swport_id;
628	$ret->{$sw->{'hostname'}}{'port_hr'} = $swport_hr;
629	}
630
631	$session->close;
632	}
633	return $ret;
634	}
635
636	#---------------------------------------------------------------
637	sub get_list_network {
638
639	return keys %{$KLASK_CFG->{'network'}};
640	}
641
642	#---------------------------------------------------------------
643	sub get_current_interface {
644	my $vlan_name = shift;
645
646	return $KLASK_CFG->{'network'}{$vlan_name}{'interface'};
647	}
648
649	#---------------------------------------------------------------
650	sub get_current_vlan_id {
651	my $vlan_name = shift;
652
653	return 0 if not exists $KLASK_CFG->{'network'}{$vlan_name};
654	return $KLASK_CFG->{'network'}{$vlan_name}{'vlan-id'};
655	}
656
657	#---------------------------------------------------------------
658	sub get_current_scan_mode {
659	my $vlan_name = shift;
660
661	return $KLASK_CFG->{'network'}{$vlan_name}{'scan-mode'} \|\| $DEFAULT{'scan-mode'} \|\| 'active';
662	}
663
664	#---------------------------------------------------------------
665	sub get_current_vlan_name_for_interface {
666	my $interface = shift;
667
668	for my $vlan_name (keys %{$KLASK_CFG->{'network'}}) {
669	next if $KLASK_CFG->{'network'}{$vlan_name}{'interface'} ne $interface;
670	return $vlan_name;
671	}
672	}
673
674	#---------------------------------------------------------------
675	# liste l'ensemble des adresses ip d'un réseau
676	sub get_list_ip {
677	my @vlan_name = @_;
678
679	my $cidrlist = Net::CIDR::Lite->new;
680
681	for my $net (@vlan_name) {
682	my @line = @{$KLASK_CFG->{'network'}{$net}{'ip-subnet'}};
683	for my $cmd (@line) {
684	for my $method (keys %{$cmd}) {
685	$cidrlist->add_any($cmd->{$method}) if $method eq 'add';
686	}
687	}
688	}
689
690	my @res = ();
691
692	for my $cidr ($cidrlist->list()) {
693	my $net = new NetAddr::IP $cidr;
694	for my $ip (@{$net}) {
695	$ip =~ s{ /32 }{}xms;
696	push @res, $ip;
697	}
698	}
699
700	return @res;
701	}
702
703	#---------------------------------------------------------------
704	# liste l'ensemble des routeurs du réseau
705	sub get_list_main_router {
706	my @vlan_name = @_;
707
708	my @res = ();
709
710	for my $net (@vlan_name) {
711	push @res, $KLASK_CFG->{'network'}{$net}{'main-router'};
712	}
713
714	return @res;
715	}
716
717	#---------------------------------------------------------------
718	sub normalize_port_human_readable {
719	my $sw_port_hr = shift;
720
721	# Manufacturer abbreviation
722	$sw_port_hr =~ s/^Bridge-Aggregation/Br/i;
723	$sw_port_hr =~ s/^Port-Channel/Po/i;
724	$sw_port_hr =~ s/^Forty-?GigabitEthernet/Fo/i;
725	$sw_port_hr =~ s/^Ten-?GigabitEthernet/Te/i;
726	$sw_port_hr =~ s/^GigabitEthernet/Gi/i;
727	$sw_port_hr =~ s/^FastEthernet/Fa/i;
728
729	# Customer abbreviation
730	$sw_port_hr =~ s/^Ten/Te/i;
731	$sw_port_hr =~ s/^Giga/Gi/i;
732
733	return ucfirst $sw_port_hr;
734	}
735
736	#---------------------------------------------------------------
737	sub snmp_get_rwsession {
738	my ($sw) = @_;
739
740	my %session = %{$sw->{'snmp_param_session'}};
741	$session{-community} = $sw->{'community-rw'} \|\| $DEFAULT{'community-rw'} \|\| 'private';
742	return %session;
743	}
744
745	#---------------------------------------------------------------
746	sub snmp_get_switchport_id2hr {
747	my ($snmp_session, $swport_id) = @_;
748
749	# On H3C, port id (port_id) and port index (port_ix) are not the same
750	# Double SNMP request to get the name
751	# First get the index, second get the name (port_hr)
752
753	my $oid_search_ix = $OID_NUMBER{'ifIndex'} .'.'. $swport_id;
754	my $result_ix = $snmp_session->get_request(
755	-varbindlist => [$oid_search_ix]
756	);
757
758	my $swport_ix = $swport_id;
759	$swport_ix = $result_ix->{$oid_search_ix} if defined $result_ix;
760
761	return snmp_get_switchport_ix2hr($snmp_session, $swport_ix);
762	}
763
764	#---------------------------------------------------------------
765	sub snmp_get_switchport_ix2hr {
766	my ($snmp_session, $swport_ix) = @_;
767
768	my $oid_search_hr = $OID_NUMBER{'ifName'} .'.'. $swport_ix;
769	my $result_hr = $snmp_session->get_request(
770	-varbindlist => [$oid_search_hr]
771	);
772	my $swport_hr = $swport_ix;
773	$swport_hr = normalize_port_human_readable($result_hr->{$oid_search_hr}) if defined $result_hr;
774
775	# Aggregator port
776	if ($swport_hr =~ m/^(Trk\|Br\|Po)/) {
777	my $oid_search_index = $OID_NUMBER{'ifAggregator'}; # base OID
778	my @args = ( -varbindlist => [$oid_search_index]);
779	LOOP_ON_OID_PORT:
780	while ( defined $snmp_session->get_next_request(@args) ) {
781	my ($oid_current) = $snmp_session->var_bind_names;
782	last LOOP_ON_OID_PORT if not Net::SNMP::oid_base_match($oid_search_index, $oid_current);
783
784	# IEEE8023-LAG-MIB::dot3adAggPortSelectedAggID.28 = INTEGER: 337
785	# IEEE8023-LAG-MIB::dot3adAggPortAttachedAggID.28 = INTEGER: 337
786	my $port_aggregator_index = $snmp_session->var_bind_list->{$oid_current};
787	my ($current_port_ix) = reverse split /\./, $oid_current; # last number
788
789	# prepare next loop item
790	@args = (-varbindlist => [$oid_current]);
791
792	next LOOP_ON_OID_PORT if $port_aggregator_index == 0;
793	next LOOP_ON_OID_PORT if not $port_aggregator_index == $swport_ix;
794
795	my $current_port_name = snmp_get_switchport_ix2hr($snmp_session, $current_port_ix);
796	$swport_hr .= "$SEP_AGGREGATOR_PORT$current_port_name";
797	}
798	}
799	return $swport_hr;
800	}
801
802	#---------------------------------------------------------------
803	# Reverse search port number
804	sub snmp_get_switchport_hr2id {
805	my ($snmp_session, $swport_hr, $verbose) = @_;
806
807	# Split for Aggregator port
808	# Keep only the Aggregator part
809	($swport_hr) = split /$SEP_AGGREGATOR_PORT/, $swport_hr;
810
811	my $swport_id = $swport_hr;
812	# direct return if already numeric (next loop is expensive) / old or simple switch
813	return $swport_id if $swport_id =~ m/^\d+$/;
814
815	my $oid_search_ix = $OID_NUMBER{'ifIndex'}; # base OID
816	my @args = ( -varbindlist => [$oid_search_ix]);
817	LOOP_ON_OID_PORT:
818	while ( defined $snmp_session->get_next_request(@args) ) {
819	my ($oid_current) = $snmp_session->var_bind_names;
820	last LOOP_ON_OID_PORT if not Net::SNMP::oid_base_match($oid_search_ix, $oid_current);
821
822	my $port_ifIndex = $snmp_session->var_bind_list->{$oid_current};
823	my ($port_ix) = reverse split /\./, $oid_current; # last number
824	printf "PORT1: %s => %s\n", $oid_current, $port_ifIndex if $verbose;
825
826	# prepare next loop item
827	@args = (-varbindlist => [$oid_current]);
828
829	my $oid_search_ifName = $OID_NUMBER{'ifName'} .'.'. $port_ifIndex;
830	my $result = $snmp_session->get_request(-varbindlist => [$oid_search_ifName]);
831	next LOOP_ON_OID_PORT if not defined $result;
832
833	my $current_port_hr = normalize_port_human_readable($result->{$oid_search_ifName});
834	printf "PORT2: $oid_search_ifName => $current_port_hr\n" if $verbose;
835	if ($current_port_hr eq $swport_hr) {
836	print "PORT3: $current_port_hr <-> $port_ix\n" if $verbose;
837
838	# return port number ifIndex need by OID portUpDown
839	$swport_id = $port_ifIndex; # other possible value could be $port_ix
840	last LOOP_ON_OID_PORT;
841	}
842	}
843	return $swport_id;
844	}
845
846	#---------------------------------------------------------------
847	# Get the list of all the VLAN define on a switch
848	sub snmp_get_vlan_list {
849	my ($snmp_session, $verbose) = @_;
850
851	my %vlandb = (); # Hash vlan number => vlan name
852
853	my $oid_search_index = $OID_NUMBER{'vlanName'}; # base OID
854	my @args = ( -varbindlist => [$oid_search_index]);
855	LOOP_ON_VLAN:
856	while ( defined $snmp_session->get_next_request(@args) ) {
857	my ($oid_current) = $snmp_session->var_bind_names;
858	last LOOP_ON_VLAN if not Net::SNMP::oid_base_match($oid_search_index, $oid_current);
859
860	my $vlan_name = $snmp_session->var_bind_list->{$oid_current};
861	my ($vlan_id) = reverse split /\./, $oid_current; # last number
862	printf "VLAN: %s => %s\n", $oid_current, $vlan_name if $verbose;
863
864	$vlandb{$vlan_id} = $vlan_name;
865
866	# prepare next loop item
867	@args = (-varbindlist => [$oid_current]);
868	}
869	return %vlandb;
870	}
871
872	#---------------------------------------------------------------
873	# Load computer database
874	sub computerdb_load {
875	my $computerdb = YAML::Syck::LoadFile("$KLASK_DB_FILE");
876
877	LOOP_ON_IP_ADDRESS:
878	for my $ip (keys %{$computerdb}) {
879
880	# Rename switch_port -> switch_port_id (2017/09/15)
881	if (not exists $computerdb->{$ip}{'switch_port_id' and exists $computerdb->{$ip}{'switch_port'}}) {
882	$computerdb->{$ip}{'switch_port_id'} = $computerdb->{$ip}{'switch_port'} if defined $computerdb->{$ip}{'switch_port'};
883	$computerdb->{$ip}{'switch_port_id'} = 0 if $computerdb->{$ip}{'switch_port_id'} !~ m/^\d+$/; # force numeric
884	}
885	delete $computerdb->{$ip}{'switch_port'} if exists $computerdb->{$ip}{'switch_port'};
886
887	next LOOP_ON_IP_ADDRESS if exists $computerdb->{$ip}{'switch_port_hr'} and defined $computerdb->{$ip}{'switch_port_hr'};
888
889	$computerdb->{$ip}{'switch_port_hr'} = $computerdb->{$ip}{'switch_port_id'};
890	}
891
892	return $computerdb;
893	}
894
895	#---------------------------------------------------------------
896	sub get_switchdb_checksum {
897	my %switch_db = @_; # same as global %SWITCH_DB
898
899	my $checksum_data = '';
900	for my $sw_name (sort keys %switch_db) { # sort to always have the same order
901	$checksum_data .= join ':',
902	$switch_db{$sw_name}->{'description'},
903	$switch_db{$sw_name}->{'model'},
904	$switch_db{$sw_name}->{'hostname'},
905	"\n";
906	}
907
908	return sha512_base64($checksum_data);
909	}
910
911	#---------------------------------------------------------------
912	sub update_switchdb {
913	my %args = (
914	verbose => 0,
915	@_);
916
917	init_switch_names('yes'); #nomme les switchs
918	print "\n";
919
920	my %where = ();
921	my %db_switch_output_port = ();
922	my %db_switch_ip_hostnamefq = ();
923
924	DETECT_ALL_ROUTER:
925	for my $one_router ( get_list_main_router(get_list_network()) ) {
926	print "Info: router loop $one_router\n" if $args{'verbose'};
927	my %resol_arp = resolve_ip_arp_host($one_router, q{*}, q{low}); # resolution arp
928
929	next DETECT_ALL_ROUTER if $resol_arp{'mac_address'} eq 'unknow';
930	print "VERBOSE_1: Router detected $resol_arp{'ipv4_address'} - $resol_arp{'mac_address'}\n" if $args{'verbose'};
931
932	my $vlan_name = get_current_vlan_name_for_interface($resol_arp{'interface'});
933	my $vlan_id = get_current_vlan_id($vlan_name);
934	$where{$resol_arp{'ipv4_address'}} = find_all_switch_port($resol_arp{'mac_address'}, $vlan_id); # retrouve les emplacements des routeurs
935	}
936
937	ALL_ROUTER_IP_ADDRESS:
938	for my $ip_router (Net::Netmask::sort_by_ip_address(keys %where)) { # '194.254.66.254')) {
939
940	next ALL_ROUTER_IP_ADDRESS if not exists $where{$ip_router}; # /a priori/ idiot car ne sers à rien...
941
942	ALL_SWITCH_CONNECTED:
943	for my $switch_detected ( keys %{$where{$ip_router}} ) {
944
945	my $switch = $where{$ip_router}->{$switch_detected};
946
947	next ALL_SWITCH_CONNECTED if $switch->{'port_id'} eq '0';
948
949	$db_switch_output_port{$switch->{'hostname'}} = $switch->{'port_hr'};
950	print "VERBOSE_2: output port $switch->{'hostname'} : $switch->{'port_hr'}\n" if $args{'verbose'};
951	}
952	}
953
954	my %db_switch_link_with = ();
955
956	my @list_all_switch = ();
957	my @list_switch_ipv4 = ();
958	for my $sw (@SWITCH_LIST) {
959	push @list_all_switch, $sw->{'hostname'};
960	}
961
962	my $timestamp = time;
963
964	ALL_SWITCH:
965	for my $one_switch (@list_all_switch) {
966	my %resol_arp = resolve_ip_arp_host($one_switch, q{*}, q{low}); # arp resolution
967	if (exists $SWITCH_DB{$one_switch}{'fake-ip'}) {
968	my $fake_ip = $SWITCH_DB{$one_switch}{'fake-ip'};
969	fast_ping($fake_ip);
970	print "WARNING: fake ip on switch $one_switch -> $fake_ip / $resol_arp{'ipv4_address'}\n" if $args{'verbose'};
971	my %resol_arp_alt = resolve_ip_arp_host($fake_ip, q{*}, q{low}); # arp resolution
972	if ($resol_arp_alt{'mac_address'} ne 'unknow') {
973	$resol_arp{'mac_address'} = $resol_arp_alt{'mac_address'};
974	$resol_arp{'interface'} = $resol_arp_alt{'interface'};
975	$resol_arp{'ipv4_address'} .= '*';
976	# Force a MAC trace on switch
977	system "arping -c 1 -w 1 -rR -i $resol_arp_alt{'interface'} $fake_ip > /dev/null 2>&1";
978	}
979	}
980	print "Info: switch loop $one_switch\n" if $args{'verbose'};
981	next ALL_SWITCH if $resol_arp{'mac_address'} eq 'unknow';
982
983	push @list_switch_ipv4, $resol_arp{'ipv4_address'};
984
985	my $vlan_name = get_current_vlan_name_for_interface($resol_arp{'interface'});
986	my $vlan_id = get_current_vlan_id($vlan_name);
987	$where{$resol_arp{'ipv4_address'}} = find_all_switch_port($resol_arp{'mac_address'}, $vlan_id); # find port on all switch
988
989	if ($args{'verbose'}) {
990	print "VERBOSE_3: $one_switch $resol_arp{'ipv4_address'} $resol_arp{'mac_address'}\n";
991	print "VERBOSE_3: $one_switch --- ",
992	join(' + ', keys %{$where{$resol_arp{'ipv4_address'}}}),
993	"\n";
994	}
995
996	$db_switch_ip_hostnamefq{$resol_arp{'ipv4_address'}} = $resol_arp{'hostname_fq'};
997	print "VERBOSE_4: db_switch_ip_hostnamefq $resol_arp{'ipv4_address'} -> $resol_arp{'hostname_fq'}\n" if $args{'verbose'};
998
999	$SWITCH_DB{$one_switch}->{'ipv4_address'} = $resol_arp{'ipv4_address'};
1000	$SWITCH_DB{$one_switch}->{'mac_address'} = $resol_arp{'mac_address'};
1001	$SWITCH_DB{$one_switch}->{'timestamp'} = $timestamp;
1002	$SWITCH_DB{$one_switch}->{'network'} = $vlan_name;
1003	}
1004
1005	ALL_SWITCH_IP_ADDRESS:
1006	for my $ip (@list_switch_ipv4) {
1007	# for my $ip (Net::Netmask::sort_by_ip_address(@list_switch_ipv4)) {
1008
1009	print "VERBOSE_5: loop on $db_switch_ip_hostnamefq{$ip}\n" if $args{'verbose'};
1010
1011	next ALL_SWITCH_IP_ADDRESS if not exists $where{$ip};
1012	# next ALL_SWITCH_IP_ADDRESS if not exists $SWITCH_PORT_COUNT{ $db_switch_ip_hostnamefq{$ip} };
1013
1014	DETECTED_SWITCH:
1015	for my $switch_detected ( keys %{$where{$ip}} ) {
1016
1017	my $switch = $where{$ip}->{$switch_detected};
1018	print "VERBOSE_6: $db_switch_ip_hostnamefq{$ip} -> $switch->{'hostname'} : $switch->{'port_hr'}\n" if $args{'verbose'};
1019
1020	next if $switch->{'port_id'} eq '0';
1021	next if $switch->{'port_hr'} eq $db_switch_output_port{$switch->{'hostname'}};
1022	next if $switch->{'hostname'} eq $db_switch_ip_hostnamefq{$ip}; # $computerdb->{$ip}{'hostname'};
1023
1024	$db_switch_link_with{ $db_switch_ip_hostnamefq{$ip} } \|\|= {};
1025	$db_switch_link_with{ $db_switch_ip_hostnamefq{$ip} }->{ $switch->{'hostname'} } = $switch->{'port_hr'};
1026	print "VERBOSE_7: +++++\n" if $args{'verbose'};
1027	}
1028
1029	}
1030
1031	my %db_switch_connected_on_port = ();
1032	my $maybe_more_than_one_switch_connected = 'yes';
1033	my $cloop = 0;
1034
1035	while ($maybe_more_than_one_switch_connected eq 'yes' and $cloop < 100) {
1036	$cloop++;
1037	print "VERBOSE_9: cloop reduction step: $cloop\n" if $args{'verbose'};
1038	for my $sw (keys %db_switch_link_with) {
1039	for my $connect (keys %{$db_switch_link_with{$sw}}) {
1040
1041	my $port_hr = $db_switch_link_with{$sw}->{$connect};
1042
1043	$db_switch_connected_on_port{"$connect$SEP_SWITCH_PORT$port_hr"} \|\|= {};
1044	$db_switch_connected_on_port{"$connect$SEP_SWITCH_PORT$port_hr"}->{$sw}++; # Just to define the key
1045	}
1046	}
1047
1048	$maybe_more_than_one_switch_connected = 'no';
1049
1050	SWITCH_AND_PORT:
1051	for my $swport (keys %db_switch_connected_on_port) {
1052
1053	next if keys %{$db_switch_connected_on_port{$swport}} == 1;
1054
1055	$maybe_more_than_one_switch_connected = 'yes';
1056
1057	my ($sw_connect, $port_connect) = split m/ $SEP_SWITCH_PORT /xms, $swport, 2;
1058	my @sw_on_same_port = keys %{$db_switch_connected_on_port{$swport}};
1059	print "VERBOSE_10: $swport -- ".$#sw_on_same_port." -- @sw_on_same_port\n" if $args{'verbose'};
1060
1061	CONNECTED:
1062	for my $sw_connected (@sw_on_same_port) {
1063
1064	next CONNECTED if not keys %{$db_switch_link_with{$sw_connected}} == 1;
1065
1066	$db_switch_connected_on_port{$swport} = {$sw_connected => 1};
1067
1068	for my $other_sw (@sw_on_same_port) {
1069	next if $other_sw eq $sw_connected;
1070
1071	delete $db_switch_link_with{$other_sw}->{$sw_connect};
1072	}
1073
1074	# We can not do better for this switch for this loop
1075	next SWITCH_AND_PORT;
1076	}
1077	}
1078	}
1079
1080	my %db_switch_parent =();
1081
1082	for my $sw (keys %db_switch_link_with) {
1083	for my $connect (keys %{$db_switch_link_with{$sw}}) {
1084
1085	my $port_hr = $db_switch_link_with{$sw}->{$connect};
1086
1087	$db_switch_connected_on_port{"$connect$SEP_SWITCH_PORT$port_hr"} \|\|= {};
1088	$db_switch_connected_on_port{"$connect$SEP_SWITCH_PORT$port_hr"}->{$sw} = $port_hr;
1089
1090	$db_switch_parent{$sw} = {switch => $connect, port_hr => $port_hr};
1091	}
1092	}
1093
1094	print "Switch output port and parent port connection\n";
1095	print "---------------------------------------------\n";
1096	for my $sw (sort keys %db_switch_output_port) {
1097	if (exists $db_switch_parent{$sw}) {
1098	printf "%-28s %2s +--> %2s %-25s\n", $sw, $db_switch_output_port{$sw}, $db_switch_parent{$sw}->{'port_hr'}, $db_switch_parent{$sw}->{'switch'};
1099	}
1100	else {
1101	printf "%-28s %2s +--> router\n", $sw, $db_switch_output_port{$sw};
1102	}
1103	}
1104	print "\n";
1105
1106	print "Switch parent and children port inter-connection\n";
1107	print "------------------------------------------------\n";
1108	for my $swport (sort keys %db_switch_connected_on_port) {
1109	my ($sw_connect, $port_connect) = split m/ $SEP_SWITCH_PORT /xms, $swport, 2;
1110	for my $sw (keys %{$db_switch_connected_on_port{$swport}}) {
1111	if (exists $db_switch_output_port{$sw}) {
1112	printf "%-28s %2s <--+ %2s %-25s\n", $sw_connect, $port_connect, $db_switch_output_port{$sw}, $sw;
1113	}
1114	else {
1115	printf "%-28s %2s <--+ %-25s\n", $sw_connect, $port_connect, $sw;
1116	}
1117	}
1118	}
1119
1120	my $switch_connection = {
1121	output_port => \%db_switch_output_port,
1122	parent => \%db_switch_parent,
1123	connected_on_port => \%db_switch_connected_on_port,
1124	link_with => \%db_switch_link_with,
1125	switch_db => \%SWITCH_DB,
1126	timestamp => $timestamp,
1127	checksum => get_switchdb_checksum(%SWITCH_DB),
1128	};
1129
1130	YAML::Syck::DumpFile("$KLASK_SW_FILE", $switch_connection);
1131	return;
1132	}
1133
1134	################################################################
1135	# command
1136	################################################################
1137
1138	#---------------------------------------------------------------
1139	sub cmd_help {
1140
1141	print <<'END';
1142	klask - port and search manager for switches, map management
1143
1144	klask version
1145	klask help
1146
1147	klask updatedb [--verbose\|-v] [--verb-description\|-d] [--chk-hostname\|-h] [--chk-location\|-l] [--no-rebuildsw\|-R]
1148	klask exportdb [--format\|-f txt\|html]
1149	klask removedb IP* computer*
1150	klask cleandb [--verbose\|-v] --day number_of_day --repair-dns
1151
1152	klask updatesw [--verbose\|-v]
1153	klask exportsw [--format\|-f txt\|dot] [--modulo\|-m XX] [--shift\|-s YY]
1154
1155	klask searchdb [--kind\|-k host\|mac] computer [mac-address]
1156	klask search computer
1157	klask search-mac-on-switch [--verbose\|-v] [--vlan\|-i vlan-id] switch mac_addr
1158
1159	klask ip-free [--verbose\|-v] [--day\|-d days-to-death] [--format\|-f txt\|html] [vlan_name]
1160
1161	klask bad-vlan-id [--day\|-d days_before_alert]
1162
1163	klask enable [--verbose\|-v] switch port
1164	klask disable [--verbose\|-v] switch port
1165	klask status [--verbose\|-v] switch port
1166
1167	klask poe-enable [--verbose\|-v] switch port
1168	klask poe-disable [--verbose\|-v] switch port
1169	klask poe-status [--verbose\|-v] switch port
1170
1171	klask vlan-getname switch vlan-id
1172	klask vlan-list switch
1173	END
1174	return;
1175	}
1176
1177	#---------------------------------------------------------------
1178	sub cmd_version {
1179
1180	print <<'END';
1181	klask - port and search manager for switches, map management
1182	Copyright (C) 2005-2017 Gabriel Moreau <Gabriel.Moreau(A)univ-grenoble-alpes.fr>
1183
1184	END
1185	print ' $Id: klask 323 2017-10-31 10:59:46Z g7moreau $'."\n";
1186	return;
1187	}
1188
1189	#---------------------------------------------------------------
1190	sub cmd_search {
1191	my @computer = @_;
1192
1193	init_switch_names(); #nomme les switchs
1194	fast_ping(@computer);
1195
1196	LOOP_ON_COMPUTER:
1197	for my $clientname (@computer) {
1198	my %resol_arp = resolve_ip_arp_host($clientname); #resolution arp
1199	my $vlan_name = get_current_vlan_name_for_interface($resol_arp{'interface'});
1200	my $vlan_id = get_current_vlan_id($vlan_name);
1201	my %where = find_switch_port($resol_arp{'mac_address'}, '', $vlan_id); #retrouve l'emplacement
1202
1203	next LOOP_ON_COMPUTER if $where{'switch_description'} eq 'unknow' or $resol_arp{'hostname_fq'} eq 'unknow' or $resol_arp{'mac_address'} eq 'unknow';
1204
1205	printf '%-22s %2s %-30s %-15s %18s',
1206	$where{'switch_hostname'},
1207	$where{'switch_port_hr'},
1208	$resol_arp{'hostname_fq'},
1209	$resol_arp{'ipv4_address'},
1210	$resol_arp{'mac_address'}."\n";
1211	}
1212	return;
1213	}
1214
1215	#---------------------------------------------------------------
1216	sub cmd_searchdb {
1217	my @ARGV = @_;
1218
1219	my $kind;
1220
1221	GetOptions(
1222	'kind=s' => \$kind,
1223	);
1224
1225	my %possible_search = (
1226	host => \&cmd_searchdb_host,
1227	mac => \&cmd_searchdb_mac,
1228	);
1229
1230	$kind = 'host' if not defined $possible_search{$kind};
1231
1232	$possible_search{$kind}->(@ARGV);
1233	return;
1234	}
1235
1236
1237	#---------------------------------------------------------------
1238	sub cmd_searchdb_host {
1239	my @computer = @_;
1240
1241	fast_ping(@computer);
1242	my $computerdb = computerdb_load();
1243
1244	LOOP_ON_COMPUTER:
1245	for my $clientname (@computer) {
1246	my %resol_arp = resolve_ip_arp_host($clientname); #resolution arp
1247	my $ip = $resol_arp{'ipv4_address'};
1248
1249	next LOOP_ON_COMPUTER unless exists $computerdb->{$ip};
1250
1251	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $computerdb->{$ip}{'timestamp'};
1252	$year += 1900;
1253	$mon++;
1254	my $date = sprintf '%04i-%02i-%02i %02i:%02i', $year, $mon, $mday, $hour, $min;
1255
1256	printf "%-22s %2s %-30s %-15s %-18s %s\n",
1257	$computerdb->{$ip}{'switch_hostname'},
1258	$computerdb->{$ip}{'switch_port_hr'},
1259	$computerdb->{$ip}{'hostname_fq'},
1260	$ip,
1261	$computerdb->{$ip}{'mac_address'},
1262	$date;
1263	}
1264	return;
1265	}
1266
1267	#---------------------------------------------------------------
1268	sub cmd_searchdb_mac {
1269	my @mac = map { normalize_mac_address($_) } @_;
1270
1271	my $computerdb = computerdb_load();
1272
1273	LOOP_ON_MAC:
1274	for my $mac (@mac) {
1275	LOOP_ON_COMPUTER:
1276	for my $ip (keys %{$computerdb}) {
1277	next LOOP_ON_COMPUTER if $mac ne $computerdb->{$ip}{'mac_address'};
1278
1279	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $computerdb->{$ip}{'timestamp'};
1280	$year += 1900;
1281	$mon++;
1282	my $date = sprintf '%04i-%02i-%02i %02i:%02i', $year, $mon, $mday, $hour, $min;
1283
1284	printf "%-22s %2s %-30s %-15s %-18s %s\n",
1285	$computerdb->{$ip}{'switch_hostname'},
1286	$computerdb->{$ip}{'switch_port_hr'},
1287	$computerdb->{$ip}{'hostname_fq'},
1288	$ip,
1289	$computerdb->{$ip}{'mac_address'},
1290	$date;
1291	#next LOOP_ON_MAC;
1292	}
1293
1294	}
1295	return;
1296	}
1297
1298	#---------------------------------------------------------------
1299	sub cmd_updatedb {
1300	@ARGV = @_;
1301
1302	my ($verbose, $verb_description, $check_hostname, $check_location, $no_rebuildsw);
1303
1304	GetOptions(
1305	'verbose\|v' => \$verbose,
1306	'verb-description\|d' => \$verb_description,
1307	'chk-hostname\|h' => \$check_hostname,
1308	'chk-location\|l' => \$check_location,
1309	'no-rebuildsw\|R' => \$no_rebuildsw,
1310	);
1311
1312	my @network = @ARGV;
1313	@network = get_list_network() if not @network;
1314
1315	test_switchdb_environnement();
1316
1317	my $computerdb = {};
1318	$computerdb = computerdb_load() if -e "$KLASK_DB_FILE";
1319	my $timestamp = time;
1320
1321	my %computer_not_detected = ();
1322	my $timestamp_last_week = $timestamp - (3600 * 24 * 7);
1323
1324	my $number_of_computer = get_list_ip(@network); # + 1;
1325	my $size_of_database = keys %{$computerdb};
1326	$size_of_database = 1 if $size_of_database == 0;
1327	my $i = 0;
1328	my $detected_computer = 0;
1329
1330	init_switch_names('yes', $verb_description, $check_hostname, $check_location); #nomme les switchs
1331
1332	{
1333	my $switch_checksum = get_switchdb_checksum(%SWITCH_DB);
1334	# Remplis le champs portignore des ports d'inter-connection pour chaque switch
1335	my $switch_connection = YAML::Syck::LoadFile("$KLASK_SW_FILE");
1336	if ($switch_checksum ne $switch_connection->{'checksum'}) { # Verify checksum
1337	if ($no_rebuildsw) {
1338	print "WARNING: switch database is outdate, please rebuild if with updatesw command\n";
1339	}
1340	else {
1341	print "WARNING: switch database is going to be rebuilt\n";
1342	update_switchdb(verbose => $verbose)
1343	}
1344	}
1345
1346	my %db_switch_output_port = %{$switch_connection->{'output_port'}};
1347	my %db_switch_connected_on_port = %{$switch_connection->{'connected_on_port'}};
1348	my %db_switch_chained_port = ();
1349	for my $swport (keys %db_switch_connected_on_port) {
1350	my ($sw_connect, $port_connect) = split m/ $SEP_SWITCH_PORT /xms, $swport, 2;
1351	$db_switch_chained_port{$sw_connect} .= "$port_connect:";
1352	}
1353	for my $sw (@SWITCH_LIST) {
1354	push @{$sw->{'portignore'}}, $db_switch_output_port{$sw->{'hostname'}} if exists $db_switch_output_port{$sw->{'hostname'}};
1355	if ( exists $db_switch_chained_port{$sw->{'hostname'}} ) {
1356	chop $db_switch_chained_port{$sw->{'hostname'}};
1357	push @{$sw->{'portignore'}}, split m/ : /xms, $db_switch_chained_port{$sw->{'hostname'}};
1358	}
1359	# print "$sw->{'hostname'} ++ @{$sw->{'portignore'}}\n";
1360	}
1361	}
1362
1363	my %router_mac_ip = ();
1364	DETECT_ALL_ROUTER:
1365	# for my $one_router ('194.254.66.254') {
1366	for my $one_router ( get_list_main_router(@network) ) {
1367	my %resol_arp = resolve_ip_arp_host($one_router);
1368	$router_mac_ip{ $resol_arp{'mac_address'} } = $resol_arp{'ipv4_address'};
1369	}
1370
1371	ALL_NETWORK:
1372	for my $current_net (@network) {
1373
1374	my @computer = get_list_ip($current_net);
1375	my $current_interface = get_current_interface($current_net);
1376
1377	fast_ping(@computer) if get_current_scan_mode($current_net) eq 'active';
1378
1379	LOOP_ON_COMPUTER:
1380	for my $one_computer (@computer) {
1381	$i++;
1382
1383	my $total_percent = int (($i*100)/$number_of_computer);
1384
1385	my $localtime = time - $timestamp;
1386	my ($sec,$min) = localtime $localtime;
1387
1388	my $time_elapse = 0;
1389	$time_elapse = $localtime * ( 100 - $total_percent) / $total_percent if $total_percent != 0;
1390	my ($sec_elapse,$min_elapse) = localtime $time_elapse;
1391
1392	printf "\rComputer scanned: %4i/%i (%2i%%)", $i, $number_of_computer, $total_percent;
1393	printf ', detected: %4i/%i (%2i%%)', $detected_computer, $size_of_database, int(($detected_computer*100)/$size_of_database);
1394	printf ' [Time: %02i:%02i / %02i:%02i]', int($localtime/60), $localtime % 60, int($time_elapse/60), $time_elapse % 60;
1395	printf ' %-8s %-14s', $current_interface, $one_computer;
1396
1397	my $already_exist = exists $computerdb->{$one_computer} ? 'yes' : 'no';
1398	my %resol_arp = resolve_ip_arp_host($one_computer, $current_interface, 'fast', $already_exist);
1399
1400	# do not search on router connection (why ?)
1401	if ( exists $router_mac_ip{$resol_arp{'mac_address'}}) {
1402	$computer_not_detected{$one_computer} = $current_net;
1403	next LOOP_ON_COMPUTER;
1404	}
1405
1406	# do not search on switch inter-connection
1407	if (exists $SWITCH_LEVEL{$resol_arp{'hostname_fq'}}) {
1408	$computer_not_detected{$one_computer} = $current_net;
1409	next LOOP_ON_COMPUTER;
1410	}
1411
1412	my $switch_proposal = q{};
1413	if (exists $computerdb->{$resol_arp{'ipv4_address'}} and exists $computerdb->{$resol_arp{'ipv4_address'}}{'switch_hostname'}) {
1414	$switch_proposal = $computerdb->{$resol_arp{'ipv4_address'}}{'switch_hostname'};
1415	}
1416
1417	# do not have a mac address
1418	if ($resol_arp{'mac_address'} eq 'unknow' or (exists $resol_arp{'timestamps'} and $resol_arp{'timestamps'} < ($timestamp - 3 * 3600))) {
1419	$computer_not_detected{$one_computer} = $current_net;
1420	next LOOP_ON_COMPUTER;
1421	}
1422
1423	my $vlan_name = get_current_vlan_name_for_interface($resol_arp{'interface'});
1424	my $vlan_id = get_current_vlan_id($vlan_name);
1425	my %where = find_switch_port($resol_arp{'mac_address'}, $switch_proposal, $vlan_id);
1426
1427	#192.168.24.156:
1428	# arp: 00:0B:DB:D5:F6:65
1429	# hostname: pcroyon.hmg.priv
1430	# port: 5
1431	# switch: sw-batH-legi:hp2524
1432	# timestamp: 1164355525
1433
1434	# do not have a mac address
1435	# if ($resol_arp{'mac_address'} eq 'unknow') {
1436	# $computer_not_detected{$one_computer} = $current_interface;
1437	# next LOOP_ON_COMPUTER;
1438	# }
1439
1440	# detected on a switch
1441	if ($where{'switch_description'} ne 'unknow') {
1442	$detected_computer++;
1443	$computerdb->{$resol_arp{'ipv4_address'}} = {
1444	hostname_fq => $resol_arp{'hostname_fq'},
1445	mac_address => $resol_arp{'mac_address'},
1446	switch_hostname => $where{'switch_hostname'},
1447	switch_description => $where{'switch_description'},
1448	switch_port_id => $where{'switch_port_id'},
1449	switch_port_hr => $where{'switch_port_hr'},
1450	timestamp => $timestamp,
1451	network => $current_net,
1452	};
1453	next LOOP_ON_COMPUTER;
1454	}
1455
1456	# new in the database but where it is ?
1457	if (not exists $computerdb->{$resol_arp{'ipv4_address'}}) {
1458	$detected_computer++;
1459	$computerdb->{$resol_arp{'ipv4_address'}} = {
1460	hostname_fq => $resol_arp{'hostname_fq'},
1461	mac_address => $resol_arp{'mac_address'},
1462	switch_hostname => $where{'switch_hostname'},
1463	switch_description => $where{'switch_description'},
1464	switch_port_id => $where{'switch_port_id'},
1465	switch_port_hr => $where{'switch_port_hr'},
1466	timestamp => $resol_arp{'timestamp'},
1467	network => $current_net,
1468	};
1469	}
1470
1471	# mise a jour du nom de la machine si modification dans le dns
1472	$computerdb->{$resol_arp{'ipv4_address'}}{'hostname_fq'} = $resol_arp{'hostname_fq'};
1473
1474	# mise à jour de la date de détection si détection plus récente par arpwatch
1475	$computerdb->{$resol_arp{'ipv4_address'}}{'timestamp'} = $resol_arp{'timestamp'} if exists $resol_arp{'timestamp'} and $computerdb->{$resol_arp{'ipv4_address'}}{'timestamp'} < $resol_arp{'timestamp'};
1476
1477	# relance un arping sur la machine si celle-ci n'a pas été détectée depuis plus d'une semaine
1478	# push @computer_not_detected, $resol_arp{'ipv4_address'} if $computerdb->{$resol_arp{'ipv4_address'}}{'timestamp'} < $timestamp_last_week;
1479	$computer_not_detected{$resol_arp{'ipv4_address'}} = $current_net if $computerdb->{$resol_arp{'ipv4_address'}}{'timestamp'} < $timestamp_last_week;
1480
1481	}
1482	}
1483
1484	# final end of line at the end of the loop
1485	printf "\n";
1486
1487	my $dirdb = $KLASK_DB_FILE;
1488	$dirdb =~ s{ / [^/]* $}{}xms;
1489	mkdir "$dirdb", 0755 unless -d "$dirdb";
1490	YAML::Syck::DumpFile("$KLASK_DB_FILE", $computerdb);
1491
1492	for my $one_computer (keys %computer_not_detected) {
1493	my $current_net = $computer_not_detected{$one_computer};
1494	my $current_interface = get_current_interface($current_net);
1495	system "arping -c 1 -w 1 -rR -i $current_interface $one_computer > /dev/null 2>&1" if get_current_scan_mode($current_net) eq 'active';
1496	}
1497	return;
1498	}
1499
1500	#---------------------------------------------------------------
1501	sub cmd_removedb {
1502	my @computer = @_;
1503
1504	test_maindb_environnement();
1505
1506	my $computerdb = computerdb_load();
1507
1508	LOOP_ON_COMPUTER:
1509	for my $one_computer (@computer) {
1510
1511	if ( $one_computer =~ m/^ $RE_IPv4_ADDRESS $/xms
1512	and exists $computerdb->{$one_computer} ) {
1513	delete $computerdb->{$one_computer};
1514	next;
1515	}
1516
1517	my %resol_arp = resolve_ip_arp_host($one_computer);
1518
1519	delete $computerdb->{$resol_arp{'ipv4_address'}} if exists $computerdb->{$resol_arp{'ipv4_address'}};
1520	}
1521
1522	my $dirdb = $KLASK_DB_FILE;
1523	$dirdb =~ s{ / [^/]* $}{}xms;
1524	mkdir "$dirdb", 0755 unless -d "$dirdb";
1525	YAML::Syck::DumpFile("$KLASK_DB_FILE", $computerdb);
1526	return;
1527	}
1528
1529	#---------------------------------------------------------------
1530	sub cmd_cleandb {
1531	my @ARGV = @_;
1532
1533	my $days_to_clean = 15;
1534	my $repairdns;
1535	my $verbose;
1536	my $database_has_changed;
1537
1538	GetOptions(
1539	'day\|d=i' => \$days_to_clean,
1540	'verbose\|v' => \$verbose,
1541	'repair-dns\|r' => \$repairdns,
1542	);
1543
1544	my @vlan_name = get_list_network();
1545
1546	my $computerdb = computerdb_load();
1547	my $timestamp = time;
1548
1549	my $timestamp_barrier = 3600 * 24 * $days_to_clean;
1550	my $timestamp_3month = 3600 * 24 * 90;
1551
1552	my %mactimedb = ();
1553	ALL_VLAN:
1554	for my $vlan (shuffle @vlan_name) {
1555
1556	my @ip_list = shuffle get_list_ip($vlan);
1557
1558	LOOP_ON_IP_ADDRESS:
1559	for my $ip (@ip_list) {
1560
1561	next LOOP_ON_IP_ADDRESS if
1562	not exists $computerdb->{$ip};
1563
1564	#&& $computerdb->{$ip}{'timestamp'} > $timestamp_barrier;
1565	my $ip_timestamp = $computerdb->{$ip}{'timestamp'};
1566	my $ip_mac = $computerdb->{$ip}{'mac_address'};
1567	my $ip_hostname_fq = $computerdb->{$ip}{'hostname_fq'};
1568
1569	$mactimedb{$ip_mac} \|\|= {
1570	ip => $ip,
1571	timestamp => $ip_timestamp,
1572	vlan => $vlan,
1573	hostname_fq => $ip_hostname_fq,
1574	};
1575
1576	if (
1577	( $mactimedb{$ip_mac}->{'timestamp'} - $ip_timestamp > $timestamp_barrier
1578	or (
1579	$mactimedb{$ip_mac}->{'timestamp'} > $ip_timestamp
1580	and $timestamp - $mactimedb{$ip_mac}->{'timestamp'} > $timestamp_3month
1581	)
1582	)
1583	and (
1584	not $mactimedb{$ip_mac}->{'hostname_fq'} =~ m/$RE_FLOAT_HOSTNAME/
1585	or $ip_hostname_fq =~ m/$RE_FLOAT_HOSTNAME/
1586	)) {
1587	print "remove ip $ip\n" if $verbose;
1588	delete $computerdb->{$ip};
1589	$database_has_changed++;
1590	}
1591
1592	elsif (
1593	( $ip_timestamp - $mactimedb{$ip_mac}->{'timestamp'} > $timestamp_barrier
1594	or (
1595	$ip_timestamp > $mactimedb{$ip_mac}->{'timestamp'}
1596	and $timestamp - $ip_timestamp > $timestamp_3month
1597	)
1598	)
1599	and (
1600	not $ip_hostname_fq =~ m/$RE_FLOAT_HOSTNAME/
1601	or $mactimedb{$ip_mac}->{'hostname_fq'} =~ m/$RE_FLOAT_HOSTNAME/
1602	)) {
1603	print "remove ip ".$mactimedb{$ip_mac}->{'ip'}."\n" if $verbose;
1604	delete $computerdb->{$mactimedb{$ip_mac}->{'ip'}};
1605	$database_has_changed++;
1606	}
1607
1608	if ( $ip_timestamp > $mactimedb{$ip_mac}->{'timestamp'}) {
1609	$mactimedb{$ip_mac} = {
1610	ip => $ip,
1611	timestamp => $ip_timestamp,
1612	vlan => $vlan,
1613	hostname_fq => $ip_hostname_fq,
1614	};
1615	}
1616	}
1617	}
1618
1619	if ($repairdns) { # Search and update unkown computer in reverse DNS
1620	LOOP_ON_IP_ADDRESS:
1621	for my $ip (keys %{$computerdb}) {
1622	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'hostname_fq'} ne 'unknow';
1623
1624	my $packed_ip = scalar gethostbyname($ip);
1625	next LOOP_ON_IP_ADDRESS if not defined $packed_ip;
1626
1627	my $hostname_fq = scalar gethostbyaddr($packed_ip, AF_INET);
1628	next LOOP_ON_IP_ADDRESS if not defined $hostname_fq;
1629
1630	$computerdb->{$ip}{'hostname_fq'} = $hostname_fq;
1631	$database_has_changed++;
1632	}
1633	}
1634
1635	if ( $database_has_changed ) {
1636	my $dirdb = $KLASK_DB_FILE;
1637	$dirdb =~ s{ / [^/]* $}{}xms;
1638	mkdir "$dirdb", 0755 unless -d "$dirdb";
1639	YAML::Syck::DumpFile("$KLASK_DB_FILE", $computerdb);
1640	}
1641	return;
1642	}
1643
1644	#---------------------------------------------------------------
1645	sub cmd_exportdb {
1646	@ARGV = @_;
1647
1648	my $format = 'txt';
1649
1650	GetOptions(
1651	'format\|f=s' => \$format,
1652	);
1653
1654	my %possible_format = (
1655	txt => \&cmd_exportdb_txt,
1656	html => \&cmd_exportdb_html,
1657	);
1658
1659	$format = 'txt' if not defined $possible_format{$format};
1660
1661	$possible_format{$format}->(@ARGV);
1662	return;
1663	}
1664
1665	#---------------------------------------------------------------
1666	sub cmd_exportdb_txt {
1667	test_maindb_environnement();
1668
1669	my $computerdb = computerdb_load();
1670
1671	my $tb_computer = Text::Table->new(
1672	{align => 'left', align_title => 'left', title => 'Switch'},
1673	{align => 'right', align_title => 'right', title => 'Port'},
1674	{align => 'center', align_title => 'center', title => 'Link'},
1675	{align => 'left', align_title => 'left', title => 'Hostname-FQ'},
1676	{align => 'left', align_title => 'left', title => 'IPv4-Address'},
1677	{align => 'left', align_title => 'left', title => 'MAC-Address'},
1678	{align => 'left', align_title => 'left', title => 'Date'},
1679	{align => 'left', align_title => 'left', title => 'VLAN'},
1680	);
1681
1682	LOOP_ON_IP_ADDRESS:
1683	for my $ip (Net::Netmask::sort_by_ip_address(keys %{$computerdb})) {
1684
1685	# to be improve in the future
1686	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'hostname_fq'} eq ($computerdb->{$ip}{'switch_hostname'} \|\| $computerdb->{$ip}{'switch_description'}); # switch on himself !
1687
1688	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $computerdb->{$ip}{'timestamp'};
1689	$year += 1900;
1690	$mon++;
1691	my $date = sprintf '%04i-%02i-%02i %02i:%02i', $year, $mon, $mday, $hour, $min;
1692
1693	my $vlan = '';
1694	$vlan = $computerdb->{$ip}{'network'}.'('.get_current_vlan_id($computerdb->{$ip}{'network'}).')' if $computerdb->{$ip}{'network'};
1695
1696	my $arrow ='<---';
1697	$arrow ='<===' if $computerdb->{$ip}{'switch_port_hr'} =~ m/^(Trk\|Br\|Po)/;
1698
1699	$tb_computer->add(
1700	$computerdb->{$ip}{'switch_hostname'} \|\| $computerdb->{$ip}{'switch_description'},
1701	$computerdb->{$ip}{'switch_port_hr'},
1702	$arrow,
1703	$computerdb->{$ip}{'hostname_fq'},
1704	$ip,
1705	$computerdb->{$ip}{'mac_address'},
1706	$date,
1707	$vlan,
1708	);
1709	}
1710
1711	print $tb_computer->title();
1712	print $tb_computer->rule('-');
1713	print $tb_computer->body();
1714
1715	return;
1716	}
1717
1718	#---------------------------------------------------------------
1719	sub cmd_exportdb_html {
1720	test_maindb_environnement();
1721
1722	my $computerdb = computerdb_load();
1723
1724	#<link rel="stylesheet" type="text/css" href="style-klask.css" />
1725	#<script src="sorttable-klask.js"></script>
1726
1727	print <<'END_HTML';
1728	<table class="sortable" summary="Klask Host Database">
1729	<caption>Klask Host Database</caption>
1730	<thead>
1731	<tr>
1732	<th scope="col" class="klask-header-left">Switch ⇅</th>
1733	<th scope="col" class="sorttable_nosort">Port</th>
1734	<th scope="col" class="sorttable_nosort">Link</th>
1735	<th scope="col" class="sorttable_alpha">Hostname-FQ ⇅</th>
1736	<th scope="col" class="hklask-ipv4">IPv4-Address ⇅</th>
1737	<th scope="col" class="sorttable_alpha">MAC-Address ⇅</th>
1738	<th scope="col" class="sorttable_alpha">VLAN ⇅</th>
1739	<th scope="col" class="klask-header-right">Date ⇅</th>
1740	</tr>
1741	</thead>
1742	<tfoot>
1743	<tr>
1744	<th scope="col" class="klask-footer-left">Switch</th>
1745	<th scope="col" class="fklask-port">Port</th>
1746	<th scope="col" class="fklask-link">Link</th>
1747	<th scope="col" class="fklask-hostname">Hostname-FQ</th>
1748	<th scope="col" class="fklask-ipv4">IPv4-Address</th>
1749	<th scope="col" class="fklask-mac">MAC-Address</th>
1750	<th scope="col" class="fklask-vlan">VLAN</th>
1751	<th scope="col" class="klask-footer-right">Date</th>
1752	</tr>
1753	</tfoot>
1754	<tbody>
1755	END_HTML
1756
1757	my %mac_count = ();
1758	LOOP_ON_IP_ADDRESS:
1759	for my $ip (keys %{$computerdb}) {
1760
1761	# to be improve in the future
1762	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'hostname_fq'} eq ($computerdb->{$ip}{'switch_hostname'} \|\| $computerdb->{$ip}{'switch_description'}); # switch on himself !
1763
1764	$mac_count{$computerdb->{$ip}{'mac_address'}}++;
1765	}
1766
1767	my $typerow = 'even';
1768
1769	LOOP_ON_IP_ADDRESS:
1770	for my $ip (Net::Netmask::sort_by_ip_address(keys %{$computerdb})) {
1771
1772	# to be improve in the future
1773	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'hostname_fq'} eq ($computerdb->{$ip}{'switch_hostname'} \|\| $computerdb->{$ip}{'switch_description'}); # switch on himself !
1774
1775	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $computerdb->{$ip}{'timestamp'};
1776	$year += 1900;
1777	$mon++;
1778	my $date = sprintf '%04i-%02i-%02i %02i:%02i', $year, $mon, $mday, $hour, $min;
1779
1780	# $odd_or_even++;
1781	# my $typerow = $odd_or_even % 2 ? 'odd' : 'even';
1782	$typerow = $typerow eq 'even' ? 'odd' : 'even';
1783
1784	#my $arrow ='←';
1785	# $arrow ='⇐' if $computerdb->{$ip}{'switch_port_hr'} =~ m/^(Trk\|Br\|Po)/;
1786	my $arrow ='⟵';
1787	$arrow ='⟸' if $computerdb->{$ip}{'switch_port_hr'} =~ m/^(Trk\|Br\|Po)/;
1788
1789	my $switch_hostname = $computerdb->{$ip}{'switch_hostname'} \|\| $computerdb->{$ip}{'switch_description'} \|\| 'unkown';
1790	chomp $switch_hostname;
1791	my $switch_hostname_sort = sprintf '%s %06i' ,$switch_hostname, $computerdb->{$ip}{'switch_port_id'}; # Take switch index
1792
1793	my $ip_sort = sprintf '%03i%03i%03i%03i', split m/ \. /xms, $ip;
1794
1795	my $mac_sort = sprintf '%04i-%s', 9999 - $mac_count{$computerdb->{$ip}{'mac_address'}}, $computerdb->{$ip}{'mac_address'};
1796
1797	$computerdb->{$ip}{'hostname_fq'} = 'unknow' if $computerdb->{$ip}{'hostname_fq'} =~ m/^ \d+ \. \d+ \. \d+ \. \d+ $/xms;
1798	my ( $host_short ) = split m/ \. /xms, $computerdb->{$ip}{'hostname_fq'};
1799
1800	my $vlan = '';
1801	$vlan = $computerdb->{$ip}{'network'}.' ('.get_current_vlan_id($computerdb->{$ip}{'network'}).')' if $computerdb->{$ip}{'network'};
1802
1803	my $parent_port_hr = format_aggregator4html($computerdb->{$ip}{'switch_port_hr'});
1804
1805	fqdn_html_breakable($switch_hostname);
1806	fqdn_html_breakable(my $hostname_fq_html = $computerdb->{$ip}{'hostname_fq'});
1807
1808	print <<"END_HTML";
1809	<tr class="$typerow">
1810	<td sorttable_customkey="$switch_hostname_sort">$switch_hostname</td>
1811	<td class="bklask-port">$parent_port_hr</td>
1812	<td class="bklask-arrow">$arrow</td>
1813	<td sorttable_customkey="$host_short">$hostname_fq_html</td>
1814	<td sorttable_customkey="$ip_sort">$ip</td>
1815	<td sorttable_customkey="$mac_sort">$computerdb->{$ip}{'mac_address'}</td>
1816	<td>$vlan</td>
1817	<td>$date</td>
1818	</tr>
1819	END_HTML
1820	}
1821
1822	my $switch_connection = YAML::Syck::LoadFile("$KLASK_SW_FILE");
1823
1824	my %db_switch_output_port = %{$switch_connection->{'output_port'}};
1825	my %db_switch_parent = %{$switch_connection->{'parent'}};
1826	my %db_switch_connected_on_port = %{$switch_connection->{'connected_on_port'}};
1827	my %db_switch = %{$switch_connection->{'switch_db'}};
1828
1829	# Output switch connection
1830	LOOP_ON_OUTPUT_SWITCH:
1831	for my $sw (sort keys %db_switch_output_port) {
1832
1833	my $switch_hostname_sort = sprintf '%s %3s' ,$sw, $db_switch_output_port{$sw};
1834
1835	$typerow = $typerow eq 'even' ? 'odd' : 'even';
1836
1837	#my $arrow ='⇾';
1838	# $arrow ='⇨' if $db_switch_output_port{$sw} =~ m/^(Trk\|Br\|Po)/;
1839	my $arrow ='⟼';
1840	$arrow ='⟾' if $db_switch_output_port{$sw} =~ m/^(Trk\|Br\|Po)/;
1841
1842	if (exists $db_switch_parent{$sw}) {
1843	# Link to uplink switch
1844	next LOOP_ON_OUTPUT_SWITCH;
1845
1846	# Do not print anymore
1847	my $mac_address = $db_switch{$db_switch_parent{$sw}->{'switch'}}->{'mac_address'};
1848	my $ipv4_address = $db_switch{$db_switch_parent{$sw}->{'switch'}}->{'ipv4_address'};
1849	my $timestamp = $db_switch{$db_switch_parent{$sw}->{'switch'}}->{'timestamp'};
1850
1851	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $timestamp;
1852	$year += 1900;
1853	$mon++;
1854	my $date = sprintf '%04i-%02i-%02i %02i:%02i', $year, $mon, $mday, $hour, $min;
1855
1856	my $ip_sort = sprintf '%03i%03i%03i%03i', split m/ [\.\] /xms, $ipv4_address; # \ for fake-ip
1857
1858	my $mac_sort = sprintf '%04i-%s', 9999, $mac_address;
1859
1860	my ( $host_short ) = sprintf '%s %3s' , split(m/ \. /xms, $db_switch_parent{$sw}->{'switch'}, 1), $db_switch_parent{$sw}->{'port_hr'};
1861
1862	my $vlan = $db_switch{$db_switch_parent{$sw}->{'switch'}}->{'network'};
1863	$vlan .= ' ('.get_current_vlan_id($db_switch{$db_switch_parent{$sw}->{'switch'}}->{'network'}).')' if $db_switch{$db_switch_parent{$sw}->{'switch'}}->{'network'};
1864
1865	my $parent_port_hr = format_aggregator4html($db_switch_output_port{$sw});
1866	my $child_port_hr = format_aggregator4html($db_switch_parent{$sw}->{'port_hr'});
1867
1868	fqdn_html_breakable($sw);
1869	fqdn_html_breakable(my $sw_child_html = $db_switch_parent{$sw}->{'switch'});
1870
1871	print <<"END_HTML";
1872	<tr class="$typerow">
1873	<td sorttable_customkey="$switch_hostname_sort">$sw</td>
1874	<td class="bklask-port">$parent_port_hr</td>
1875	<td class="bklask-arrow">$arrow $child_port_hr</td>
1876	<td sorttable_customkey="$host_short">$sw_child_html</td>
1877	<td sorttable_customkey="$ip_sort">$ipv4_address</td>
1878	<td sorttable_customkey="$mac_sort">$mac_address</td>
1879	<td>$vlan</td>
1880	<td>$date</td>
1881	</tr>
1882	END_HTML
1883	}
1884	else {
1885	# Router
1886	my $parent_port_hr = format_aggregator4html($db_switch_output_port{$sw});
1887
1888	my $host_short = sprintf '%s %3s' ,$sw, $db_switch_output_port{$sw};
1889
1890	my $mac_address = $db_switch{$sw}->{'mac_address'};
1891	my $ipv4_address = $db_switch{$sw}->{'ipv4_address'};
1892	my $timestamp = $db_switch{$sw}->{'timestamp'};
1893
1894	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $timestamp;
1895	$year += 1900;
1896	$mon++;
1897	my $date = sprintf '%04i-%02i-%02i %02i:%02i', $year, $mon, $mday, $hour, $min;
1898
1899	my $ip_sort = sprintf '%03i%03i%03i%03i', split m/ [\.\] /xms, $ipv4_address; # \ for fake-ip
1900
1901	my $mac_sort = sprintf '%04i-%s', 9999, $mac_address;
1902
1903	my $vlan = $db_switch{$sw}->{'network'};
1904	$vlan .= ' ('.get_current_vlan_id($db_switch{$sw}->{'network'}).')' if $db_switch{$sw}->{'network'};
1905
1906	my $arrow ='⟻';
1907	$arrow ='⟽' if $db_switch_output_port{$sw} =~ m/^(Trk\|Br\|Po)/;
1908
1909	fqdn_html_breakable($sw);
1910
1911	print <<"END_HTML";
1912	<tr class="$typerow">
1913	<td sorttable_customkey="router">router</td>
1914	<td class="bklask-port"></td>
1915	<td class="bklask-arrow">$arrow $parent_port_hr</td>
1916	<td sorttable_customkey="$host_short">$sw</td>
1917	<td sorttable_customkey="$ip_sort">$ipv4_address</td>
1918	<td sorttable_customkey="$mac_sort">$mac_address</td>
1919	<td>$vlan</td>
1920	<td>$date</td>
1921	</tr>
1922	END_HTML
1923	next LOOP_ON_OUTPUT_SWITCH;
1924	}
1925	}
1926
1927	# Child switch connection : parent <- child
1928	for my $swport (sort keys %db_switch_connected_on_port) {
1929	my ($sw_connect, $port_connect) = split m/ $SEP_SWITCH_PORT /xms, $swport, 2;
1930	for my $sw (keys %{$db_switch_connected_on_port{$swport}}) {
1931
1932	my $switch_hostname_sort = sprintf '%s %3s' ,$sw_connect, $port_connect;
1933
1934	my $mac_address = $db_switch{$sw}->{'mac_address'};
1935	my $ipv4_address = $db_switch{$sw}->{'ipv4_address'};
1936	my $timestamp = $db_switch{$sw}->{'timestamp'};
1937
1938	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $timestamp;
1939	$year += 1900;
1940	$mon++;
1941	my $date = sprintf '%04i-%02i-%02i %02i:%02i', $year,$mon,$mday,$hour,$min;
1942
1943	my $ip_sort = sprintf '%03i%03i%03i%03i', split m/ [\.\] /xms, $ipv4_address; # \ for fake-ip
1944
1945	my $mac_sort = sprintf '%04i-%s', 9999, $mac_address;
1946
1947	$typerow = $typerow eq 'even' ? 'odd' : 'even';
1948
1949	#my $arrow ='⇽';
1950	# $arrow ='⇦' if $port_connect =~ m/^(Trk\|Br\|Po)/;
1951	my $arrow ='⟻';
1952	$arrow ='⟽' if $port_connect =~ m/^(Trk\|Br\|Po)/;
1953
1954	my $vlan = $db_switch{$sw}->{'network'};
1955	$vlan .= ' ('.get_current_vlan_id($db_switch{$sw}->{'network'}).')' if $db_switch{$sw}->{'network'};
1956
1957	if (exists $db_switch_output_port{$sw}) {
1958
1959	my ( $host_short ) = sprintf '%s %3s' , split( m/\./xms, $sw, 1), $db_switch_output_port{$sw};
1960
1961	my $parent_port_hr = format_aggregator4html($port_connect);
1962	my $child_port_hr = format_aggregator4html($db_switch_output_port{$sw});
1963
1964	fqdn_html_breakable($sw);
1965	fqdn_html_breakable($sw_connect);
1966
1967	print <<"END_HTML";
1968	<tr class="$typerow">
1969	<td sorttable_customkey="$switch_hostname_sort">$sw_connect</td>
1970	<td class="bklask-port">$parent_port_hr</td>
1971	<td class="bklask-arrow">$arrow $child_port_hr</td>
1972	<td sorttable_customkey="$host_short">$sw</td>
1973	<td sorttable_customkey="$ip_sort">$ipv4_address</td>
1974	<td sorttable_customkey="$mac_sort">$mac_address</td>
1975	<td>$vlan</td>
1976	<td>$date</td>
1977	</tr>
1978	END_HTML
1979	}
1980	else {
1981	my $parent_port_hr = format_aggregator4html($port_connect);
1982
1983	fqdn_html_breakable($sw);
1984	fqdn_html_breakable($sw_connect);
1985
1986	print <<"END_HTML";
1987	<tr class="$typerow">
1988	<td sorttable_customkey="$switch_hostname_sort">$sw_connect</td>
1989	<td class="bklask-port">$parent_port_hr</td>
1990	<td class="bklask-arrow">$arrow</td>
1991	<td sorttable_customkey="$sw">$sw</td>
1992	<td sorttable_customkey="">$ipv4_address</td>
1993	<td sorttable_customkey="">$mac_address</td>
1994	<td>$vlan</td>
1995	<td>$date</td>
1996	</tr>
1997	END_HTML
1998	}
1999	}
2000	}
2001
2002	print <<'END_HTML';
2003	</tbody>
2004	</table>
2005	END_HTML
2006	return;
2007	}
2008
2009	#---------------------------------------------------------------
2010	sub cmd_bad_vlan_id {
2011	@ARGV = @_;
2012
2013	my $days_before_alert = $DEFAULT{'days-before-alert'} \|\| 15;
2014	my $verbose;
2015
2016	GetOptions(
2017	'day\|d=i' => \$days_before_alert,
2018	);
2019
2020	test_maindb_environnement();
2021
2022	my $computerdb = computerdb_load();
2023
2024	# create a database with the most recent computer by switch port
2025	my %switchportdb = ();
2026	LOOP_ON_IP_ADDRESS:
2027	for my $ip (keys %{$computerdb}) {
2028	# to be improve in the future
2029	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'hostname_fq'} eq ($computerdb->{$ip}{'switch_hostname'} \|\| $computerdb->{$ip}{'switch_description'}); # switch on himself !
2030	next LOOP_ON_IP_ADDRESS if ($computerdb->{$ip}{'switch_hostname'} \|\| $computerdb->{$ip}{'switch_description'}) eq 'unknow';
2031	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'switch_port_id'} eq '0';
2032
2033	my $ip_timestamp = $computerdb->{$ip}{'timestamp'};
2034	my $ip_mac = $computerdb->{$ip}{'mac_address'};
2035	my $ip_hostname_fq = $computerdb->{$ip}{'hostname_fq'};
2036
2037	my $swpt = sprintf "%-28s %2s",
2038	$computerdb->{$ip}{'switch_hostname'} \|\| $computerdb->{$ip}{'switch_description'},
2039	$computerdb->{$ip}{'switch_port_hr'};
2040	$switchportdb{$swpt} \|\|= {
2041	ip => $ip,
2042	timestamp => $ip_timestamp,
2043	vlan => $computerdb->{$ip}{'network'},
2044	hostname_fq => $ip_hostname_fq,
2045	mac_address => $ip_mac,
2046	};
2047
2048	# if float computer, set date 15 day before warning...
2049	my $ip_timestamp_mod = $ip_timestamp;
2050	my $ip_timestamp_ref = $switchportdb{$swpt}->{'timestamp'};
2051	$ip_timestamp_mod -= $days_before_alert * 24 * 3600 if $ip_hostname_fq =~ m/$RE_FLOAT_HOSTNAME/;
2052	$ip_timestamp_ref -= $days_before_alert * 24 * 3600 if $switchportdb{$swpt}->{'hostname_fq'} =~ m/$RE_FLOAT_HOSTNAME/;
2053
2054	if ($ip_timestamp_mod > $ip_timestamp_ref) {
2055	$switchportdb{$swpt} = {
2056	ip => $ip,
2057	timestamp => $ip_timestamp,
2058	vlan => $computerdb->{$ip}{'network'},
2059	hostname_fq => $ip_hostname_fq,
2060	mac_address => $ip_mac,
2061	};
2062	}
2063	}
2064
2065	# swL2-legi-1.hmg.priv Gi1/0/3 / legi-calcul +-> legi-683 (337) 2017-10-31/10:30 2017-09-08/11:02 78:24:AF:88:69:64 meige8pcsv149.legi.grenoble-inp.fr
2066	my $tb_bad = Text::Table->new(
2067	{align => 'left', align_title => 'left', title => 'Switch'},
2068	{is_sep => 1, title => ' ', body => ' '},
2069	{align => 'right', align_title => 'right', title => 'Port'},
2070	{is_sep => 1, title => ' ', body => ' !'},
2071	{align => 'left', align_title => 'left', title => 'VLAN-Bad'},
2072	{is_sep => 1, title => ' ', body => ' +-> '},
2073	{align => 'left', align_title => 'left', title => 'VLAN-Good'},
2074	{is_sep => 1, title => ' ', body => ' '},
2075	{align => 'left', align_title => 'left', title => 'VLAN-ID'},
2076	{is_sep => 1, title => ' ', body => ' '},
2077	{align => 'left', align_title => 'left', title => 'Date-Last'},
2078	{is_sep => 1, title => ' ', body => ' '},
2079	{align => 'left', align_title => 'left', title => 'Date-Good'},
2080	{is_sep => 1, title => ' ', body => ' '},
2081	{align => 'left', align_title => 'left', title => 'MAC-Address'},
2082	{is_sep => 1, title => ' ', body => ' '},
2083	{align => 'left', align_title => 'left', title => 'Hostname-FQ'},
2084	);
2085
2086	LOOP_ON_RECENT_COMPUTER:
2087	for my $swpt (keys %switchportdb) {
2088	next LOOP_ON_RECENT_COMPUTER if $swpt =~ m/^\s*0$/;
2089	next LOOP_ON_RECENT_COMPUTER if $switchportdb{$swpt}->{'hostname_fq'} !~ m/$RE_FLOAT_HOSTNAME/;
2090
2091	my $src_ip = $switchportdb{$swpt}->{'ip'};
2092	my $src_timestamp = 0;
2093	LOOP_ON_IP_ADDRESS:
2094	for my $ip (keys %{$computerdb}) {
2095	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'mac_address'} ne $switchportdb{$swpt}->{'mac_address'};
2096	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'hostname_fq'} =~ m/$RE_FLOAT_HOSTNAME/;
2097	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'timestamp'} < $src_timestamp;
2098
2099	$src_ip = $ip;
2100	$src_timestamp = $computerdb->{$ip}{'timestamp'};
2101	}
2102
2103	# keep only if float computer is the most recent
2104	next LOOP_ON_RECENT_COMPUTER if $src_timestamp == 0;
2105	next LOOP_ON_RECENT_COMPUTER if $switchportdb{$swpt}->{'timestamp'} < $src_timestamp;
2106
2107	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $switchportdb{$swpt}->{'timestamp'};
2108	$year += 1900;
2109	$mon++;
2110	my $date = sprintf '%04i-%02i-%02i/%02i:%02i', $year, $mon, $mday, $hour, $min;
2111
2112	($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $computerdb->{$src_ip}{'timestamp'};
2113	$year += 1900;
2114	$mon++;
2115	my $src_date = sprintf '%04i-%02i-%02i/%02i:%02i', $year, $mon, $mday, $hour, $min;
2116
2117	my $vlan_id = get_current_vlan_id($computerdb->{$src_ip}{'network'});
2118	my ($switch_hostname, $port_hr) = split /\s+/, $swpt, 2;
2119	$tb_bad->add(
2120	$switch_hostname,
2121	$port_hr,
2122	$switchportdb{$swpt}->{'vlan'},
2123	$computerdb->{$src_ip}{'network'},
2124	'(' . $vlan_id . ')',
2125	$date,
2126	$src_date,
2127	$computerdb->{$src_ip}{'mac_address'},
2128	$computerdb->{$src_ip}{'hostname_fq'},
2129	);
2130	}
2131	print $tb_bad->title();
2132	print $tb_bad->rule('-');
2133	print $tb_bad->body();
2134	}
2135
2136	#---------------------------------------------------------------
2137	sub cmd_poe_enable {
2138	@ARGV = @_;
2139
2140	my $verbose;
2141	GetOptions(
2142	'verbose\|v' => \$verbose,
2143	);
2144
2145	my $switch_name = shift @ARGV \|\| q{};
2146	my $switch_port = shift @ARGV \|\| q{};
2147
2148	if ($switch_name eq q{} or $switch_port eq q{}) {
2149	die "Usage: klask poe-enable SWITCH_NAME PORT\n";
2150	}
2151
2152	for my $sw_name (split /,/, $switch_name) {
2153	if (not defined $SWITCH_DB{$sw_name}) {
2154	die "Switch $sw_name must be defined in klask configuration file\n";
2155	}
2156
2157	my $oid_search = $OID_NUMBER{'NApoeState'} . ".$switch_port"; # Only NEXANS switch and low port number
2158
2159	my $sw = $SWITCH_DB{$sw_name};
2160	my ($session, $error) = Net::SNMP->session(snmp_get_rwsession($sw));
2161	print "$error \n" if $error;
2162
2163	my $result = $session->set_request(
2164	-varbindlist => [$oid_search, INTEGER, 8], # Only NEXANS
2165	);
2166	print $session->error()."\n" if $session->error_status();
2167
2168	$session->close;
2169	}
2170	cmd_poe_status($switch_name, $switch_port);
2171	return;
2172	}
2173
2174	#---------------------------------------------------------------
2175	sub cmd_poe_disable {
2176	@ARGV = @_;
2177
2178	my $verbose;
2179	GetOptions(
2180	'verbose\|v' => \$verbose,
2181	);
2182
2183	my $switch_name = shift @ARGV \|\| q{};
2184	my $switch_port = shift @ARGV \|\| q{};
2185
2186	if ($switch_name eq q{} or $switch_port eq q{}) {
2187	die "Usage: klask poe-disable SWITCH_NAME PORT\n";
2188	}
2189
2190	for my $sw_name (split /,/, $switch_name) {
2191	if (not defined $SWITCH_DB{$sw_name}) {
2192	die "Switch $sw_name must be defined in klask configuration file\n";
2193	}
2194
2195	my $oid_search = $OID_NUMBER{'NApoeState'} . ".$switch_port"; # Only NEXANS switch and low port number
2196
2197	my $sw = $SWITCH_DB{$sw_name};
2198	my ($session, $error) = Net::SNMP->session(snmp_get_rwsession($sw));
2199	print "$error \n" if $error;
2200
2201	my $result = $session->set_request(
2202	-varbindlist => [$oid_search, INTEGER, 2], # Only NEXANS
2203	);
2204	print $session->error()."\n" if $session->error_status();
2205
2206	$session->close;
2207	}
2208	cmd_poe_status($switch_name, $switch_port);
2209	return;
2210	}
2211
2212	#---------------------------------------------------------------
2213	sub cmd_poe_status {
2214	@ARGV = @_;
2215
2216	my $verbose;
2217	GetOptions(
2218	'verbose\|v' => \$verbose,
2219	);
2220
2221	my $switch_name = shift @ARGV \|\| q{};
2222	my $switch_port = shift @ARGV \|\| q{};
2223
2224	if ($switch_name eq q{} or $switch_port eq q{}) {
2225	die "Usage: klask poe-status SWITCH_NAME PORT\n";
2226	}
2227
2228	for my $sw_name (split /,/, $switch_name) {
2229	if (not defined $SWITCH_DB{$sw_name}) {
2230	die "Switch $sw_name must be defined in klask configuration file\n";
2231	}
2232
2233	my $oid_search = $OID_NUMBER{'NApoeState'} . ".$switch_port"; # Only NEXANS switch and low port number
2234
2235	my $sw = $SWITCH_DB{$sw_name};
2236	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
2237	print "$error \n" if $error;
2238
2239	my $result = $session->get_request(
2240	-varbindlist => [$oid_search],
2241	);
2242
2243	if (defined $result and $result->{$oid_search} ne 'noSuchInstance') {
2244	my $poe_status = $result->{$oid_search} \|\| 'empty';
2245	$poe_status =~ s/8/enable/;
2246	$poe_status =~ s/2/disable/;
2247	printf "%s %s poe %s\n", $sw_name, $switch_port, $poe_status;
2248	}
2249	else {
2250	print "Klask do not find PoE status on switch $sw_name on port $switch_port\n";
2251	}
2252
2253	$session->close;
2254	}
2255	return;
2256	}
2257
2258	#---------------------------------------------------------------
2259	sub cmd_host_setlocation {
2260	@ARGV = @_;
2261
2262	my ($verbose, $force);
2263	GetOptions(
2264	'verbose\|v' => \$verbose,
2265	'force\|f' => \$force,
2266	);
2267
2268	my $switch_name = shift @ARGV \|\| q{};
2269	my $switch_location = shift @ARGV \|\| q{};
2270
2271	if ($switch_name eq q{} or $switch_location eq q{}) {
2272	die "Usage: klask host-setlocation SWITCH_NAME LOCATION\n";
2273	}
2274
2275	for my $sw_name (split /,/, $switch_name) {
2276	if (not defined $SWITCH_DB{$sw_name}) {
2277	die "Switch $sw_name must be defined in klask configuration file\n";
2278	}
2279
2280	my $oid_search = $OID_NUMBER{'sysLocation'};
2281
2282	my $sw = $SWITCH_DB{$sw_name};
2283	my ($session, $error) = Net::SNMP->session(snmp_get_rwsession($sw));
2284	print "$error \n" if $error;
2285
2286	my $result = $session->set_request(
2287	-varbindlist => [$oid_search, OCTET_STRING, $switch_location],
2288	);
2289	print $session->error()."\n" if $session->error_status();
2290
2291	$session->close;
2292	}
2293	return;
2294	}
2295
2296	#---------------------------------------------------------------
2297	# not finish - do not use
2298	sub cmd_port_setvlan {
2299	my $switch_name = shift \|\| q{};
2300	my $mac_address = shift \|\| q{};
2301
2302	if ($switch_name eq q{} or $mac_address eq q{}) {
2303	die "Usage: klask search-mac-on-switch SWITCH_NAME MAC_ADDRESS\n";
2304	}
2305
2306	$switch_name = join(',', map {$_->{'hostname'}} @SWITCH_LIST ) if $switch_name eq q{*};
2307
2308	for my $sw_name (split /,/, $switch_name) {
2309	if (not defined $SWITCH_DB{$sw_name}) {
2310	die "Switch $sw_name must be defined in klask configuration file\n";
2311	}
2312
2313	my $oid_search_port1 = $OID_NUMBER{'searchPort1'} . mac_address_hex2dec($mac_address);
2314	my $oid_search_port2 = $OID_NUMBER{'searchPort2'} .'.'. 0 . mac_address_hex2dec($mac_address);
2315	print "Klask search OID $oid_search_port1 on switch $sw_name\n";
2316	print "Klask search OID $oid_search_port2 on switch $sw_name\n";
2317
2318	my $sw = $SWITCH_DB{$sw_name};
2319	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
2320	print "$error \n" if $error;
2321
2322	my $result = $session->get_request(
2323	-varbindlist => [$oid_search_port1]
2324	);
2325	if (not defined $result) {
2326	$result = $session->get_request(
2327	-varbindlist => [$oid_search_port2]
2328	);
2329	$result->{$oid_search_port1} = $result->{$oid_search_port2} if defined $result;
2330	}
2331
2332	if (defined $result and $result->{$oid_search_port1} ne 'noSuchInstance') {
2333	my $swport = $result->{$oid_search_port1};
2334	print "Klask find MAC $mac_address on switch $sw_name port $swport\n";
2335	}
2336	else {
2337	print "Klask do not find MAC $mac_address on switch $sw_name\n";
2338	}
2339
2340	$session->close;
2341	}
2342	return;
2343	}
2344
2345	#---------------------------------------------------------------
2346	sub cmd_port_getvlan {
2347	@ARGV = @_;
2348
2349	my $verbose;
2350	GetOptions(
2351	'verbose\|v' => \$verbose,
2352	);
2353
2354	my $switch_name = shift @ARGV \|\| q{};
2355	my $switch_port = shift @ARGV \|\| q{};
2356
2357	if ($switch_name eq q{} or $switch_port eq q{}) {
2358	die "Usage: klask port-getvlan SWITCH_NAME PORT\n";
2359	}
2360
2361	for my $sw_name (split /,/, $switch_name) {
2362	if (not defined $SWITCH_DB{$sw_name}) {
2363	die "Switch $sw_name must be defined in klask configuration file\n";
2364	}
2365
2366	my $oid_search = $OID_NUMBER{'vlanPortDefault'} . ".$switch_port";
2367
2368	my $sw = $SWITCH_DB{$sw_name};
2369	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
2370	print "$error \n" if $error;
2371
2372	my $result = $session->get_request(
2373	-varbindlist => [$oid_search],
2374	);
2375
2376	if (defined $result and $result->{$oid_search} ne 'noSuchInstance') {
2377	my $vlan_id = $result->{$oid_search} \|\| 'empty';
2378	print "Klask VLAN Id $vlan_id on switch $sw_name on port $switch_port\n";
2379	}
2380	else {
2381	print "Klask do not find VLAN Id on switch $sw_name on port $switch_port\n";
2382	}
2383
2384	$session->close;
2385	}
2386	return;
2387	}
2388
2389	#---------------------------------------------------------------
2390	sub cmd_vlan_setname {
2391	}
2392
2393	#---------------------------------------------------------------
2394	# snmpset -v 1 -c public sw1-batG0-legi.hmg.priv "$OID_NUMBER{'HPicfReset'}.0" i 2;
2395	sub cmd_rebootsw {
2396	@ARGV = @_;
2397
2398	my $verbose;
2399	GetOptions(
2400	'verbose\|v' => \$verbose,
2401	);
2402
2403	my $switch_name = shift @ARGV \|\| q{};
2404
2405	if ($switch_name eq q{}) {
2406	die "Usage: klask rebootsw SWITCH_NAME\n";
2407	}
2408
2409	for my $sw_name (split /,/, $switch_name) {
2410	if (not defined $SWITCH_DB{$sw_name}) {
2411	die "Switch $sw_name must be defined in klask configuration file\n";
2412	}
2413
2414	my $sw = $SWITCH_DB{$sw_name};
2415	my ($session, $error) = Net::SNMP->session(snmp_get_rwsession($sw));
2416	print "$error \n" if $error;
2417
2418	my $result = $session->set_request(
2419	-varbindlist => ["$OID_NUMBER{'HPicfReset'}.0", INTEGER, 2],
2420	);
2421
2422	$session->close;
2423	}
2424	return;
2425	}
2426
2427	#---------------------------------------------------------------
2428	sub cmd_vlan_getname {
2429	my $switch_name = shift \|\| q{};
2430	my $vlan_id = shift \|\| q{};
2431
2432	if ($switch_name eq q{} or $vlan_id eq q{}) {
2433	die "Usage: klask vlan-getname SWITCH_NAME VLAN_ID\n";
2434	}
2435
2436	$switch_name = join(',', map {$_->{'hostname'}} @SWITCH_LIST ) if $switch_name eq q{*};
2437
2438	for my $sw_name (split /,/, $switch_name) {
2439	if (not defined $SWITCH_DB{$sw_name}) {
2440	die "Switch $sw_name must be defined in klask configuration file\n";
2441	}
2442
2443	my $oid_search_vlan_name = $OID_NUMBER{'vlanName'} . ".$vlan_id";
2444
2445	my $sw = $SWITCH_DB{$sw_name};
2446	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
2447	print "$error \n" if $error;
2448
2449	my $result = $session->get_request(
2450	-varbindlist => [$oid_search_vlan_name]
2451	);
2452
2453	if (defined $result and $result->{$oid_search_vlan_name} ne 'noSuchInstance') {
2454	my $vlan_name = $result->{$oid_search_vlan_name} \|\| 'empty';
2455	print "Klask find VLAN $vlan_id on switch $sw_name with name $vlan_name\n";
2456	}
2457	else {
2458	print "Klask do not find VLAN $vlan_id on switch $sw_name\n";
2459	}
2460
2461	$session->close;
2462	}
2463	return;
2464	}
2465
2466	#---------------------------------------------------------------
2467	sub cmd_vlan_list {
2468	my $switch_name = shift \|\| q{};
2469
2470	if ($switch_name eq q{}) {
2471	die "Usage: klask vlan-list SWITCH_NAME\n";
2472	}
2473
2474	$switch_name = join(',', map {$_->{'hostname'}} @SWITCH_LIST ) if $switch_name eq q{*};
2475
2476	for my $sw_name (split /,/, $switch_name) {
2477	if (not defined $SWITCH_DB{$sw_name}) {
2478	die "Switch $sw_name must be defined in klask configuration file\n";
2479	}
2480
2481	my $sw = $SWITCH_DB{$sw_name};
2482	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
2483	print "$error \n" if $error;
2484
2485	my %vlandb = snmp_get_vlan_list($session);
2486	$session->close;
2487
2488	print "VLAN_ID - VLAN_NAME # $sw_name\n";
2489	for my $vlan_id (keys %vlandb) {
2490	printf "%7i - %s\n", $vlan_id, $vlandb{$vlan_id};
2491	}
2492	}
2493	return;
2494	}
2495
2496	#---------------------------------------------------------------
2497	sub cmd_ip_location {
2498	my $computerdb = computerdb_load();
2499
2500	LOOP_ON_IP_ADDRESS:
2501	for my $ip (Net::Netmask::sort_by_ip_address(keys %{$computerdb})) {
2502
2503	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'hostname_fq'} eq ($computerdb->{$ip}{'switch_hostname'} \|\| $computerdb->{$ip}{'switch_description'}); # switch on himself !
2504
2505	my $sw_hostname = $computerdb->{$ip}{'switch_hostname'} \|\| q{};
2506	next LOOP_ON_IP_ADDRESS if $sw_hostname eq 'unknow';
2507
2508	my $sw_location = q{};
2509	LOOP_ON_ALL_SWITCH:
2510	for my $sw (@SWITCH_LIST) {
2511	next LOOP_ON_ALL_SWITCH if $sw_hostname ne $sw->{'hostname'};
2512	$sw_location = $sw->{'location'};
2513	last;
2514	}
2515
2516	printf "%s: \"%s\"\n", $ip, $sw_location if not $sw_location eq q{};
2517	}
2518	return;
2519	}
2520
2521	#---------------------------------------------------------------
2522	sub cmd_ip_free {
2523	@ARGV = @_;
2524
2525	my $days_to_death = $DEFAULT{'days-to-death'} \|\| 365 * 2;
2526	my $format = 'txt';
2527	my $verbose;
2528
2529	GetOptions(
2530	'day\|d=i' => \$days_to_death,
2531	'format\|f=s' => \$format,
2532	'verbose\|v' => \$verbose,
2533	);
2534
2535	my %possible_format = (
2536	txt => \&cmd_ip_free_txt,
2537	html => \&cmd_ip_free_html,
2538	none => sub {},
2539	);
2540	$format = 'txt' if not defined $possible_format{$format};
2541
2542	my @vlan_name = @ARGV;
2543	@vlan_name = get_list_network() if not @vlan_name;
2544
2545	my $computerdb = {};
2546	$computerdb = computerdb_load() if -e "$KLASK_DB_FILE";
2547	my $timestamp = time;
2548
2549	my $timestamp_barrier = $timestamp - (3600 * 24 * $days_to_death);
2550
2551	my %result_ip = ();
2552
2553	ALL_NETWORK:
2554	for my $vlan (@vlan_name) {
2555
2556	my @ip_list = get_list_ip($vlan);
2557
2558	LOOP_ON_IP_ADDRESS:
2559	for my $ip (@ip_list) {
2560
2561	if (exists $computerdb->{$ip}) {
2562	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip}{'timestamp'} > $timestamp_barrier;
2563
2564	my $mac_address = $computerdb->{$ip}{'mac_address'};
2565	LOOP_ON_DATABASE:
2566	for my $ip_db (keys %{$computerdb}) {
2567	next LOOP_ON_DATABASE if $computerdb->{$ip_db}{'mac_address'} ne $mac_address;
2568	next LOOP_ON_IP_ADDRESS if $computerdb->{$ip_db}{'timestamp'} > $timestamp_barrier;
2569	}
2570	}
2571
2572	my $ip_date_last_detection = '';
2573	if (exists $computerdb->{$ip}) {
2574	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $computerdb->{$ip}{'timestamp'};
2575	$year += 1900;
2576	$mon++;
2577	$ip_date_last_detection = sprintf '%04i-%02i-%02i %02i:%02i', $year, $mon, $mday, $hour, $min;
2578	}
2579
2580	my $packed_ip = scalar gethostbyname($ip);
2581	my $hostname_fq = 'unknown';
2582	$hostname_fq = scalar gethostbyaddr($packed_ip, AF_INET) \|\| 'unknown' if defined $packed_ip and get_current_scan_mode($vlan) eq 'active';
2583
2584	next LOOP_ON_IP_ADDRESS if $hostname_fq =~ m/$RE_FLOAT_HOSTNAME/;
2585
2586	$result_ip{$ip} \|\|= {};
2587	$result_ip{$ip}->{'date_last_detection'} = $ip_date_last_detection;
2588	$result_ip{$ip}->{'hostname_fq'} = $hostname_fq;
2589	$result_ip{$ip}->{'vlan'} = $vlan;
2590
2591	printf "VERBOSE_1: %-15s %-12s %s\n", $ip, $vlan, $hostname_fq if $verbose;
2592	}
2593	}
2594
2595	$possible_format{$format}->(%result_ip);
2596	}
2597
2598	#---------------------------------------------------------------
2599	sub cmd_ip_free_txt {
2600	my %result_ip = @_;
2601
2602	printf "%-15s %-40s %-16s %s\n", qw(IPv4-Address Hostname-FQ Date VLAN);
2603	print "-------------------------------------------------------------------------------\n";
2604	LOOP_ON_IP_ADDRESS:
2605	for my $ip (Net::Netmask::sort_by_ip_address(keys %result_ip)) {
2606	my $vlan_nameid = $result_ip{$ip}->{'vlan'}.'('.get_current_vlan_id($result_ip{$ip}->{'vlan'}).')';
2607	printf "%-15s %-40s %-16s %s\n", $ip, $result_ip{$ip}->{'hostname_fq'}, $result_ip{$ip}->{'date_last_detection'}, $vlan_nameid;
2608	}
2609	}
2610
2611	#---------------------------------------------------------------
2612	sub cmd_ip_free_html {
2613	my %result_ip = @_;
2614
2615	print <<'END_HTML';
2616	<table class="sortable" summary="Klask Free IP Database">
2617	<caption>Klask Free IP Database</caption>
2618	<thead>
2619	<tr>
2620	<th scope="col" class="klask-header-left">IPv4-Address</th>
2621	<th scope="col" class="sorttable_alpha">Hostname-FQ</th>
2622	<th scope="col" class="sorttable_alpha">VLAN</th>
2623	<th scope="col" class="klask-header-right">Date</th>
2624	</tr>
2625	</thead>
2626	<tfoot>
2627	<tr>
2628	<th scope="col" class="klask-footer-left">IPv4-Address</th>
2629	<th scope="col" class="fklask-hostname">Hostname-FQ</th>
2630	<th scope="col" class="fklask-vlan">VLAN</th>
2631	<th scope="col" class="klask-footer-right">Date</th>
2632	</tr>
2633	</tfoot>
2634	<tbody>
2635	END_HTML
2636
2637	my $typerow = 'even';
2638
2639	LOOP_ON_IP_ADDRESS:
2640	for my $ip (Net::Netmask::sort_by_ip_address(keys %result_ip)) {
2641
2642	$typerow = $typerow eq 'even' ? 'odd' : 'even';
2643
2644	my $ip_sort = sprintf '%03i%03i%03i%03i', split m/ \. /xms, $ip;
2645	my ( $host_short ) = split m/ \. /xms, $result_ip{$ip}->{'hostname_fq'};
2646
2647	my $vlan_nameid = $result_ip{$ip}->{'vlan'}.'('.get_current_vlan_id($result_ip{$ip}->{'vlan'}).')';
2648
2649	print <<"END_HTML";
2650	<tr class="$typerow">
2651	<td sorttable_customkey="$ip_sort">$ip</td>
2652	<td sorttable_customkey="$host_short">$result_ip{$ip}->{'hostname_fq'}</td>
2653	<td>$vlan_nameid</td>
2654	<td>$result_ip{$ip}->{'date_last_detection'}</td>
2655	</tr>
2656	END_HTML
2657	}
2658	print <<'END_HTML';
2659	</tbody>
2660	</table>
2661	END_HTML
2662	}
2663
2664	#---------------------------------------------------------------
2665	sub cmd_enable {
2666	@ARGV = @_;
2667
2668	my $verbose;
2669
2670	GetOptions(
2671	'verbose\|v' => \$verbose,
2672	);
2673
2674	my $switch_name = shift @ARGV \|\| q{};
2675	my $port_hr = shift @ARGV \|\| q{};
2676
2677	if ($switch_name eq q{} or $port_hr eq q{}) {
2678	die "Usage: klask disable SWITCH_NAME PORT\n";
2679	}
2680
2681	if (not defined $SWITCH_DB{$switch_name}) {
2682	die "Switch $switch_name must be defined in klask configuration file\n";
2683	}
2684
2685	my $sw = $SWITCH_DB{$switch_name};
2686	my ($session, $error) = Net::SNMP->session(snmp_get_rwsession($sw));
2687	print "$error \n" if $error;
2688
2689	# Retrieve numeric port value
2690	my $port_id = snmp_get_switchport_hr2id($session, normalize_port_human_readable($port_hr), $verbose ? 'yes' : '');
2691	die "Error : Port $port_hr does not exist on switch $switch_name\n" if not $port_id =~ m/^\d+$/;
2692
2693	my $oid_search_portstatus = $OID_NUMBER{'portUpDown'} .'.'. $port_id;
2694	print "Info: switch $switch_name port $port_hr SNMP OID $oid_search_portstatus\n" if $verbose;
2695
2696	my $result = $session->set_request(
2697	-varbindlist => [$oid_search_portstatus, INTEGER, 1],
2698	);
2699	print $session->error()."\n" if $session->error_status();
2700
2701	$session->close;
2702
2703	#snmpset -v 1 -c community X.X.X.X 1.3.6.1.2.1.2.2.1.7.NoPort = 1 (up)
2704	#snmpset -v 1 -c community X.X.X.X 1.3.6.1.2.1.2.2.1.7.NoPort = 2 (down)
2705	#system "snmpset -v 1 -c public $switch 1.3.6.1.2.1.2.2.1.7.$port = 1";
2706	return;
2707	}
2708
2709	#---------------------------------------------------------------
2710	sub cmd_disable {
2711	@ARGV = @_;
2712
2713	my $verbose;
2714
2715	GetOptions(
2716	'verbose\|v' => \$verbose,
2717	);
2718
2719	my $switch_name = shift @ARGV \|\| q{};
2720	my $port_hr = shift @ARGV \|\| q{};
2721
2722	if ($switch_name eq q{} or $port_hr eq q{}) {
2723	die "Usage: klask disable SWITCH_NAME PORT\n";
2724	}
2725
2726	if (not defined $SWITCH_DB{$switch_name}) {
2727	die "Switch $switch_name must be defined in klask configuration file\n";
2728	}
2729
2730	my $sw = $SWITCH_DB{$switch_name};
2731	my ($session, $error) = Net::SNMP->session(snmp_get_rwsession($sw));
2732	print "$error \n" if $error;
2733
2734	# Retrieve numeric port value
2735	my $port_id = snmp_get_switchport_hr2id($session, normalize_port_human_readable($port_hr), $verbose ? 'yes' : '');
2736	die "Error : Port $port_hr does not exist on switch $switch_name\n" if not $port_id =~ m/^\d+$/;
2737
2738	my $oid_search_portstatus = $OID_NUMBER{'portUpDown'} .'.'. $port_id;
2739	print "Info: switch $switch_name port $port_hr SNMP OID $oid_search_portstatus\n" if $verbose;
2740
2741	my $result = $session->set_request(
2742	-varbindlist => [$oid_search_portstatus, INTEGER, 2],
2743	);
2744	print $session->error()."\n" if $session->error_status();
2745
2746	$session->close;
2747
2748	#system "snmpset -v 1 -c public $switch 1.3.6.1.2.1.2.2.1.7.$port = 2";
2749	return;
2750	}
2751
2752	#---------------------------------------------------------------
2753	sub cmd_status {
2754	@ARGV = @_;
2755
2756	my $verbose;
2757
2758	GetOptions(
2759	'verbose\|v' => \$verbose,
2760	);
2761
2762	my $switch_name = shift @ARGV \|\| q{};
2763	my $port_hr = shift @ARGV \|\| q{};
2764
2765	if ($switch_name eq q{} or $port_hr eq q{}) {
2766	die "Usage: klask status SWITCH_NAME PORT\n";
2767	}
2768
2769	if (not defined $SWITCH_DB{$switch_name}) {
2770	die "Switch $switch_name must be defined in klask configuration file\n";
2771	}
2772
2773	my $sw = $SWITCH_DB{$switch_name};
2774	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
2775	print "$error \n" if $error;
2776
2777	# Retrieve numeric port value
2778	my $port_id = snmp_get_switchport_hr2id($session, normalize_port_human_readable($port_hr), $verbose ? 'yes' : '');
2779	die "Error : Port $port_hr does not exist on switch $switch_name\n" if not $port_id =~ m/^\d+$/;
2780
2781	my $oid_search_portstatus = $OID_NUMBER{'portUpDown'} .'.'. $port_id;
2782	print "Info: switch $switch_name port $port_hr ($port_id) SNMP OID $oid_search_portstatus\n" if $verbose;
2783
2784	my $result = $session->get_request(
2785	-varbindlist => [$oid_search_portstatus]
2786	);
2787	print $session->error()."\n" if $session->error_status();
2788	if (defined $result) {
2789	print "$PORT_UPDOWN{$result->{$oid_search_portstatus}}\n";
2790	}
2791
2792	$session->close;
2793
2794	#system "snmpget -v 1 -c public $switch_name 1.3.6.1.2.1.2.2.1.7.$port";
2795	return;
2796	}
2797
2798	#---------------------------------------------------------------
2799	sub cmd_search_mac_on_switch {
2800	@ARGV = @_;
2801
2802	my $verbose;
2803	my $vlan_id = 0;
2804
2805	GetOptions(
2806	'verbose\|v' => \$verbose,
2807	'vlan\|l=i' => \$vlan_id,
2808	);
2809
2810	my $switch_name = shift @ARGV \|\| q{};
2811	my $mac_address = shift @ARGV \|\| q{};
2812
2813	if ($switch_name eq q{} or $mac_address eq q{}) {
2814	die "Usage: klask search-mac-on-switch SWITCH_NAME MAC_ADDRESS\n";
2815	}
2816
2817	$mac_address = normalize_mac_address($mac_address);
2818	$switch_name = join(',', map {$_->{'hostname'}} @SWITCH_LIST ) if $switch_name eq q{*} or $switch_name eq q{all};
2819
2820	for my $sw_name (split /,/, $switch_name) {
2821	if (not defined $SWITCH_DB{$sw_name}) {
2822	die "Switch $sw_name must be defined in klask configuration file\n";
2823	}
2824
2825	my $oid_search_port1 = $OID_NUMBER{'searchPort1'} . mac_address_hex2dec($mac_address);
2826	my $oid_search_port2 = $OID_NUMBER{'searchPort2'} .'.'. $vlan_id . mac_address_hex2dec($mac_address);
2827	print "Klask search OID $oid_search_port1 on switch $sw_name\n" if $verbose;
2828	print "Klask search OID $oid_search_port2 on switch $sw_name\n" if $verbose;
2829
2830	my $sw = $SWITCH_DB{$sw_name};
2831	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
2832	print "$error \n" if $error;
2833
2834	my $result = $session->get_request(
2835	-varbindlist => [$oid_search_port1]
2836	);
2837	if (not defined $result) {
2838	$result = $session->get_request(
2839	-varbindlist => [$oid_search_port2]
2840	);
2841	$result->{$oid_search_port1} = $result->{$oid_search_port2} if defined $result;
2842	}
2843
2844	if (defined $result and $result->{$oid_search_port1} ne 'noSuchInstance') {
2845	my $swport_id = $result->{$oid_search_port1};
2846	my $swport_hr = snmp_get_switchport_id2hr($session, $swport_id);
2847	print "Klask find MAC $mac_address on switch $sw_name port $swport_hr\n";
2848	}
2849	else {
2850	print "Klask do not find MAC $mac_address on switch $sw_name\n" if $verbose;
2851	}
2852
2853	$session->close;
2854	}
2855	return;
2856	}
2857
2858	#---------------------------------------------------------------
2859	sub cmd_updatesw {
2860	@ARGV = @_;
2861
2862	my $verbose;
2863
2864	GetOptions(
2865	'verbose\|v' => \$verbose,
2866	);
2867
2868	update_switchdb(verbose => $verbose);
2869	}
2870
2871	#---------------------------------------------------------------
2872	sub cmd_exportsw {
2873	@ARGV = @_;
2874
2875	test_switchdb_environnement();
2876
2877	my $format = 'txt';
2878	my $graph_modulo = 0;
2879	my $graph_shift = 1;
2880
2881	GetOptions(
2882	'format\|f=s' => \$format,
2883	'modulo\|m=i' => \$graph_modulo,
2884	'shift\|s=i' => \$graph_shift,
2885	);
2886
2887	my %possible_format = (
2888	txt => \&cmd_exportsw_txt,
2889	dot => \&cmd_exportsw_dot,
2890	);
2891
2892	$format = 'txt' if not defined $possible_format{$format};
2893
2894	$possible_format{$format}->($graph_modulo, $graph_shift, @ARGV);
2895	return;
2896	}
2897
2898	#---------------------------------------------------------------
2899	sub cmd_exportsw_txt {
2900	my %args = (
2901	way => 'all',
2902	list => 0,
2903	@_);
2904
2905	my $switch_connection = YAML::Syck::LoadFile("$KLASK_SW_FILE");
2906
2907	my %db_switch_output_port = %{$switch_connection->{'output_port'}};
2908	my %db_switch_parent = %{$switch_connection->{'parent'}};
2909	my %db_switch_connected_on_port = %{$switch_connection->{'connected_on_port'}};
2910
2911	# Switch output port and parent port connection
2912	my $tb_child = Text::Table->new( # http://www.perlmonks.org/?node_id=988320
2913	{align => 'left', align_title => 'left', title => 'Child-Switch'},
2914	{align => 'right', align_title => 'right', title => 'Output-Port'},
2915	{align => 'center', align_title => 'center', title => 'Link'},
2916	{align => 'left', align_title => 'left', title => 'Input-Port'},
2917	{align => 'left', align_title => 'left', title => 'Parent-Switch'},
2918	);
2919	for my $sw (sort keys %db_switch_output_port) {
2920	my $arrow ='--->';
2921	$arrow ='===>' if $db_switch_output_port{$sw} =~ m/^(Trk\|Br\|Po)/;
2922	if (exists $db_switch_parent{$sw}) {
2923	$tb_child->add($sw, $db_switch_output_port{$sw}, $arrow, $db_switch_parent{$sw}->{'port_hr'}, $db_switch_parent{$sw}->{'switch'});
2924
2925	}
2926	else {
2927	$tb_child->add($sw, $db_switch_output_port{$sw}, $arrow, '', 'router');
2928	}
2929	}
2930	my @colrange = map { scalar $tb_child->colrange($_) } (0 .. 4); # force scaler context
2931	$tb_child->add(map { ' ' x $_ } reverse @colrange); # add empty line to force symetric table output
2932	print $tb_child->title();
2933	print $tb_child->rule('-');
2934	print $tb_child->body(0, $tb_child->body_height()-1); # remove last fake line
2935	$tb_child->clear;
2936
2937	# Switch parent and children port inter-connection
2938	print "\n";
2939	my $tb_parent = Text::Table->new( # http://www.perlmonks.org/?node_id=988320
2940	{align => 'left', align_title => 'left', title => 'Parent-Switch'},
2941	{align => 'right', align_title => 'right', title => 'Input-Port'},
2942	{align => 'center', align_title => 'center', title => 'Link'},
2943	{align => 'left', align_title => 'left', title => 'Output-Port'},
2944	{align => 'left', align_title => 'left', title => 'Child-Switch'},
2945	);
2946	for my $swport (sort keys %db_switch_connected_on_port) {
2947	my ($sw_connect, $port_connect) = split m/ $SEP_SWITCH_PORT /xms, $swport, 2;
2948	for my $sw (keys %{$db_switch_connected_on_port{$swport}}) {
2949	my $arrow ='<---';
2950	$arrow ='<===' if $port_connect =~ m/^(Trk\|Br\|Po)/;
2951	if (exists $db_switch_output_port{$sw}) {
2952	$tb_parent->add($sw_connect, $port_connect, $arrow, $db_switch_output_port{$sw}, $sw);
2953	}
2954	else {
2955	$tb_parent->add($sw_connect, $port_connect, $arrow, '', $sw);
2956	}
2957	}
2958	}
2959	@colrange = map { scalar $tb_parent->colrange($_) } (0 .. 4); # force scaler context
2960	$tb_parent->add(map { ' ' x $_ } reverse @colrange); # add empty line to force symetric table output
2961	print $tb_parent->title();
2962	print $tb_parent->rule('-');
2963	print $tb_parent->body(0, $tb_parent->body_height()-1); # remove last fake line
2964	$tb_parent->clear;
2965
2966	return;
2967	}
2968
2969	#---------------------------------------------------------------
2970	sub cmd_exportsw_dot {
2971	my $graph_modulo = shift;
2972	my $graph_shift = shift;
2973
2974	my $switch_connection = YAML::Syck::LoadFile("$KLASK_SW_FILE");
2975
2976	my %db_switch_output_port = %{$switch_connection->{'output_port'}};
2977	my %db_switch_parent = %{$switch_connection->{'parent'}};
2978	my %db_switch_connected_on_port = %{$switch_connection->{'connected_on_port'}};
2979	my %db_switch_link_with = %{$switch_connection->{'link_with'}};
2980	my %db_switch_global = %{$switch_connection->{'switch_db'}};
2981	my $timestamp = $switch_connection->{'timestamp'};
2982
2983	my $invisible_node = 0; # Count number of invisible node
2984
2985	my %db_building= ();
2986	my %db_switch_line = (); # Number of line drawed on a switch
2987	for my $sw (values %db_switch_global) {
2988	my ($building, $location) = split m/ \/ /xms, $sw->{'location'}, 2;
2989	$db_building{$building} \|\|= {};
2990	$db_building{$building}->{$location} \|\|= {};
2991	$db_building{$building}->{$location}{ $sw->{'hostname'} } = 'y';
2992
2993	$db_switch_line{$sw} = 0;
2994	}
2995
2996
2997	print "digraph G {\n";
2998	print "rankdir=LR;\n";
2999	#print "splines=polyline;\n";
3000
3001	print "site [label=\"site\", color=black, fillcolor=gold, shape=invhouse, style=filled];\n";
3002	print "internet [label=\"internet\", color=black, fillcolor=cyan, shape=house, style=filled];\n";
3003
3004	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $timestamp;
3005	$year += 1900;
3006	$mon++;
3007	my $date = sprintf '%04i-%02i-%02i %02i:%02i', $year, $mon, $mday, $hour, $min;
3008	print "\"$date\" [label=\"MAP DATE\\n\\n$date\", color=white, fillcolor=black, shape=polygon, sides=14, style=filled, fontcolor=white];\n";
3009	print "site -> \"$date\" [style=invis];\n";
3010
3011	my $b=0;
3012	for my $building (keys %db_building) {
3013	$b++;
3014
3015	print "\"building$b\" [label=\"$building\", color=black, fillcolor=gold, style=filled];\n";
3016	print "site -> \"building$b\" [len=2, color=firebrick];\n";
3017
3018	my $l = 0;
3019	for my $loc (keys %{$db_building{$building}}) {
3020	$l++;
3021
3022	print "\"location$b-$l\" [label=\"$building" . q{/} . join(q{\n}, split(m{ / }xms, $loc)) . "\", color=black, fillcolor=orange, style=filled];\n";
3023	# print "\"location$b-$l\" [label=\"$building / $loc\", color=black, fillcolor=orange, style=filled];\n";
3024	print "\"building$b\" -> \"location$b-$l\" [len=2, color=firebrick];\n";
3025
3026	for my $sw (keys %{$db_building{$building}->{$loc}}) {
3027
3028	my $peripheries = 1;
3029	my $color = 'lightblue';
3030	if ($db_switch_output_port{$sw} =~ m/^(Trk\|Br\|Po)/) {
3031	$peripheries = 2;
3032	$color = "\"$color:$color\"";
3033	}
3034	print "\"$sw:$db_switch_output_port{$sw}\" [label=\"".format_aggregator4dot($db_switch_output_port{$sw})."\", color=black, fillcolor=lightblue, peripheries=$peripheries, style=filled];\n";
3035
3036	my $swname = $sw;
3037	$swname .= q{\n-\n} . "$db_switch_global{$sw}->{'model'}" if exists $db_switch_global{$sw} and exists $db_switch_global{$sw}->{'model'};
3038	print "\"$sw\" [label=\"$swname\", color=black, fillcolor=palegreen, shape=rect, style=filled];\n";
3039	print "\"location$b-$l\" -> \"$sw\" [len=2, color=firebrick, arrowtail=dot];\n";
3040	print "\"$sw\" -> \"$sw:$db_switch_output_port{$sw}\" [len=2, style=bold, color=$color, arrowhead=normal, arrowtail=invdot];\n";
3041
3042
3043	for my $swport (keys %db_switch_connected_on_port) {
3044	my ($sw_connect, $port_connect) = split m/ $SEP_SWITCH_PORT /xms, $swport, 2;
3045	next if not $sw_connect eq $sw;
3046	next if $port_connect eq $db_switch_output_port{$sw};
3047	my $peripheries = 1;
3048	my $color = 'plum';
3049	if ($port_connect =~ m/^(Trk\|Br\|Po)/) {
3050	$peripheries = 2;
3051	$color = "\"$color:$color\"";
3052	}
3053	print "\"$sw:$port_connect\" [label=\"".format_aggregator4dot($port_connect)."\", color=black, fillcolor=plum, peripheries=$peripheries, style=filled];\n";
3054	print "\"$sw:$port_connect\" -> \"$sw\" [len=2, style=bold, color=$color, arrowhead=normal, arrowtail=inv];\n";
3055
3056	#$db_switch_line{$sw}++;
3057	#if ($db_switch_line{$sw} % 9 == 0) {
3058	# # Create invisible node
3059	# $invisible_node++;
3060	# my $invisible = '__Invisible_' . $invisible_node;
3061	# print "$invisible [shape=none, label=\"\"]\n";
3062	# print "\"$sw:$port_connect\" -> $invisible [style=invis]\n";
3063	# print "$invisible -> \"$sw\" [style=invis]\n";
3064	# }
3065	}
3066	}
3067	}
3068	}
3069
3070	# print "Switch output port and parent port connection\n";
3071	# print "---------------------------------------------\n";
3072	for my $sw (sort keys %db_switch_output_port) {
3073	if (exists $db_switch_parent{$sw}) {
3074	# printf " \"%s:%s\" -> \"%s:%s\"\n", $sw, $db_switch_output_port{$sw}, $db_switch_parent{$sw}->{'switch'}, $db_switch_parent{$sw}->{'port_id'};
3075	}
3076	else {
3077	my $style = 'solid';
3078	my $color = 'black'; # navyblue
3079	if ($db_switch_output_port{$sw} =~ m/^(Trk\|Br\|Po)/) {
3080	$style = 'bold';
3081	$color = "\"$color:invis:$color\"";
3082	}
3083	printf " \"%s:%s\" -> internet [style=$style, color=$color];\n", $sw, $db_switch_output_port{$sw};
3084	}
3085	}
3086	print "\n";
3087
3088	# shift graph between 1 or 2 when $graph_shift = 3
3089	my $graph_breaker = 1;
3090
3091	# print "Switch parent and children port inter-connection\n";
3092	# print "------------------------------------------------\n";
3093	for my $swport (sort keys %db_switch_connected_on_port) {
3094	my ($sw_connect, $port_connect) = split m/ $SEP_SWITCH_PORT /xms, $swport, 2;
3095	for my $sw (keys %{$db_switch_connected_on_port{$swport}}) {
3096	my $style = 'solid';
3097	my $color = 'black'; # navyblue
3098	if ($port_connect =~ m/^(Trk\|Br\|Po)/) {
3099	$style = 'bold';
3100	$color = "\"$color:invis:$color\"";
3101	}
3102	if (exists $db_switch_output_port{$sw}) {
3103	printf " \"%s:%s\" -> \"%s:%s\" [style=$style, color=$color];\n", $sw, $db_switch_output_port{$sw}, $sw_connect, $port_connect;
3104
3105	next if $graph_modulo == 0; # No shift (invisible nodes) in graph
3106	$db_switch_line{$sw_connect}++;
3107	if ($db_switch_line{$sw_connect} % $graph_modulo == 0) {
3108	# Create invisible node
3109	$invisible_node++;
3110	my $invisible = '__Invisible_' . $invisible_node;
3111	print " \"$invisible.a\" [shape=none, label=\"\"];\n";
3112	printf " \"%s:%s\" -> \"$invisible.a\" [style=invis];\n", $sw, $db_switch_output_port{$sw};
3113	$graph_breaker++;
3114	if ($graph_shift == 2 or ($graph_shift == 3 and ($graph_breaker % 2) == 0)) {
3115	# Two invisible node
3116	print " \"$invisible.b\" [shape=none, label=\"\"];\n";
3117	print " \"$invisible.a\" -> \"$invisible.b\" [style=invis];\n";
3118	printf " \"$invisible.b\" -> \"%s:%s\" [style=invis];\n", $sw_connect, $port_connect;
3119	}
3120	else {
3121	# One invisible node
3122	printf " \"$invisible.a\" -> \"%s:%s\" [style=invis];\n", $sw_connect, $port_connect;
3123	}
3124	}
3125	}
3126	else {
3127	printf " \"%s\" -> \"%s:%s\" [style=$style];\n", $sw, $sw_connect, $port_connect;
3128	}
3129	}
3130	}
3131
3132	print "}\n";
3133	return;
3134	}
3135
3136
3137	################################################################
3138	# documentation
3139	################################################################
3140
3141	__END__
3142
3143	=head1 NAME
3144
3145	klask - port and search manager for switches, map management
3146
3147
3148	=head1 USAGE
3149
3150	klask version
3151	klask help
3152
3153	klask updatedb [--verbose\|-v] [--verb-description\|-d] [--chk-hostname\|-h] [--chk-location\|-l] [--no-rebuildsw\|-R]
3154	klask exportdb [--format\|-f txt\|html]
3155	klask removedb IP* computer*
3156	klask cleandb [--verbose\|-v] --day number_of_day --repair-dns
3157
3158	klask updatesw [--verbose\|-v]
3159	klask exportsw [--format\|-f txt\|dot] [--modulo\|-m XX] [--shift\|-s YY]
3160
3161	klask searchdb [--kind\|-k host\|mac] computer [mac-address]
3162	klask search computer
3163	klask search-mac-on-switch [--verbose\|-v] [--vlan\|-i vlan-id] switch mac_addr
3164
3165	klask ip-free [--verbose\|-v] [--day\|-d days-to-death] [--format\|-f txt\|html] [vlan_name]
3166
3167	klask bad-vlan-id [--day\|-d days_before_alert]
3168
3169	klask enable [--verbose\|-v] switch port
3170	klask disable [--verbose\|-v] switch port
3171	klask status [--verbose\|-v] switch port
3172
3173	klask poe-enable [--verbose\|-v] switch port
3174	klask poe-disable [--verbose\|-v] switch port
3175	klask poe-status [--verbose\|-v] switch port
3176
3177	klask vlan-getname switch vlan-id
3178	klask vlan-list switch
3179
3180
3181	=head1 DESCRIPTION
3182
3183	Klask is a small tool to find where is connected a host in a big network
3184	and on which VLAN.
3185	Klask mean search in brittany.
3186	No hight level protocol like CDL, LLDP are use.
3187	Everything is just done with SNMP request on MAC address.
3188
3189	Limitation : loop cannot be detected and could be problematic when the map is created (C<updatesw> method).
3190	If you use PVST or MSTP and create loop between VLAN,
3191	you have to use C<portignore> functionality on switch port to cut manually loop
3192	(see config file below).
3193
3194	When you use a management port to administrate a switch,
3195	it's not possible to create the map with this switch because it does not have a MAC address,
3196	so other switch cannot find the real downlink port...
3197	One way to work around this problem is, if you have a computer directly connected on the switch,
3198	to put this IP as the fake ip for the switch.
3199	The MAC address associated will be use just for the map detection.
3200	The C<fake-ip> parameter is defined in the config file.
3201
3202	Klask has now a web site dedicated for it: L<http://servforge.legi.grenoble-inp.fr/projects/klask>!
3203
3204
3205	=head1 COMMANDS
3206
3207	Some command are defined in the source code but are not documented here.
3208	Theses could be not well defined, not finished, not well tested...
3209	You can read the source code and use them at your own risk
3210	(like for all the Klask code).
3211
3212	=head2 search
3213
3214	klask search computer
3215
3216	This command takes one or more computer in argument.
3217	It search a computer on the network and give the port and the switch on which the computer is connected.
3218
3219	=head2 search-mac-on-switch
3220
3221	klask search-mac-on-switch [--verbose\|-v] [--vlan\|-i vlan-id] switch mac_addr
3222
3223	This command search a MAC address on a switch.
3224	To search on all switch, you could put C<'*'> or C<all>.
3225	The VLAN parameter could help.
3226
3227
3228	=head2 enable
3229
3230	klask enable [--verbose\|-v] switch port
3231
3232	This command activate a port (or an agrregate bridge port) on a switch by SNMP.
3233	So you need to give the switch name and a port on the command line.
3234	See L</ABBREVIATION FOR PORT>.
3235
3236	Warning: You need to have the SNMP write access on the switch in order to modify it's configuration.
3237
3238
3239	=head2 disable
3240
3241	klask disable [--verbose\|-v] switch port
3242
3243	This command deactivate a port (or an agrregate bridge port) on a switch by SNMP.
3244	So you need to give the switch name and a port on the command line.
3245	See L</ABBREVIATION FOR PORT>.
3246
3247	Warning: You need to have the SNMP write access on the switch in order to modify it's configuration.
3248
3249
3250	=head2 status
3251
3252	klask status [--verbose\|-v] switch port
3253
3254	This command return the status of a port number on a switch by SNMP.
3255	The return value could be C<enable> or C<disable> word.
3256	So you need to give the switch name and a port on the command line.
3257	See L</ABBREVIATION FOR PORT>.
3258
3259	If it's not possible to change port status with command L</enable> and L</disable>
3260	(SNMP community read write access),
3261	it's always possible to have the port status even for bridge agrregate port.
3262
3263
3264	=head2 updatedb
3265
3266	klask updatedb [--verbose\|-v] [--verb-description\|-d] [--chk-hostname\|-h] [--chk-location\|-l] [--no-rebuildsw\|-R]
3267
3268	This command will scan networks and update the computer database.
3269	To know which are the cmputer scanned, you have to configure the file F</etc/klask/klask.conf>.
3270	This file is easy to read and write because Klask use YAML format and not XML
3271	(see L</CONFIGURATION>).
3272
3273	Option are not stable and could be use manually when you have a new kind of switch.
3274	Maybe some option will be transfered in a future C<checksw> command!
3275
3276	The network parameter C<scan-mode> can have two values: C<active> or C<passive>.
3277	By default, a network is C<active>.
3278	This means that an C<fping> command is done at the beginning on all the IP of the network
3279	and the computers that was not detected in this pass, but where their Klask entry is less than one week,
3280	will have an C<arping>
3281	(some OS do not respond to C<ping> but a computer have to respond to C<arping> if it want to interact with other).
3282	In the scan mode C<passive>, no C<fping> and no C<arping> are done.
3283	It's good for big subnet with few computer (telephone...).
3284	The idea of the C<active> scan mode is to force computer to regulary send packet over the network.
3285
3286	At the beginning, the command verify that the switch map checksum is always valid.
3287	Otherwise, a rebuild procedure will ne done automatically.
3288
3289	=head2 exportdb
3290
3291	klask exportdb [--format\|-f txt\|html]
3292
3293	This command print the content of the computer database.
3294	There is actually only two format : TXT and HTML.
3295	By default, format is TXT.
3296	It's very easy to have more format, it's just need times...
3297
3298	=head2 removedb
3299
3300	klask removedb IP* computer*
3301
3302	This command remove an entry in the database.
3303	There is only one kind of parameter, the IP of the computers to be removed.
3304	You can put as many IP as you want...
3305
3306	Computer DNS names are also a valid entry because a DNS resolver is executed at the beginning.
3307
3308	=head2 cleandb
3309
3310	klask cleandb [--verbose\|-v] --day number_of_day --repair-dns
3311
3312	Remove double entry (same MAC-Address) in the computer database when the older one is older than X day (C<--day>) the new one.
3313	Computer name beginning by 'float' (regex C<^float>) are not really taken into account but could be remove.
3314	This could be configure with the global regex parameter C<float-regex> in the configuration file F</etc/klask/klask.conf>.
3315	This functionality could be use when computer define in VLAN 1
3316	could have a float IP when they are connected on VLAN 2.
3317	In the Klask database, the float DNS entries are less important.
3318
3319	When reverse DNS has not been done by the past, option C<--repair-dns> force a reverse DNS check on all unkown host.
3320
3321	=head2 updatesw
3322
3323	klask updatesw [--verbose\|-v]
3324
3325	This command build a map of your manageable switch on your network.
3326	The list of the switches must be given in the file F</etc/klask/klask.conf> (see L</CONFIGURATION>).
3327
3328	The database has a checksum which depend of all the active switches.
3329	It's use when rebuilding the database in case of change in switch configuration (one more for example).
3330
3331	=head2 exportsw
3332
3333	klask exportsw [--format\|-f txt\|dot] [--modulo\|-m XX] [--shift\|-s YY]
3334
3335	This command print the content of the switch database. There is actually two format.
3336	One is just TXT for terminal and the other is the DOT format from the graphviz environnement.
3337	By default, format is TXT.
3338
3339	klask exportsw --format dot > /tmp/map.dot
3340	dot -Tpng /tmp/map.dot > /tmp/map.png
3341
3342	In case you have too many switch connected on one switch,
3343	the graphviz result graph could be too much vertical.
3344	With C<--modulo> > 0, you can specify how many switches (connected on one switch) are on the same columns
3345	before shifting them to one column to the left and back again.
3346	The C<--shift> parameter must be 1, 2 or 3.
3347	With C<--shift> egual to 2, the shift will be to two column to the left.
3348	With 3, it will be 1 to the left and 2 to the left one time over two !
3349	In practise, we just add virtuals nodes in the dot file,
3350	that means the result graph is generated with theses virtuals but invisibles nodes...
3351
3352	=head2 ip-free
3353
3354	klask ip-free [--verbose\|-v] [--day\|-d days-to-death] [--format\|-f txt\|html] [vlan_name]
3355
3356	This command return IP address that was not use (detected by Klask) at this time.
3357	The list returned could be limited to just one VLAN.
3358	IP returned could have been never used or no computer have been detected since the number of days specified
3359	(2 years by default).
3360	This parameter could also be define in the configuration file F</etc/klask/klask.conf> (see L</CONFIGURATION>).
3361
3362	default:
3363	days-to-death: 730
3364
3365	Computer that does not have the good IP but takes a float one (see L</cleandb>) are taken into account.
3366
3367
3368	=head2 bad-vlan-id
3369
3370	klask bad-vlan-id [--day\|-d days_before_alert]
3371
3372	This command return a list of switch port that are not configure with the good VLAN.
3373	Computer which are in bad VLAN are detected with the float regex parameter (see L</cleandb>)
3374	and another prior trace where they had the good IP (good DNS name).
3375	The computer must stay connected on a bad VLAN more than XX days (15 days by default) before alert.
3376	This parameter could also define in the configuration file F</etc/klask/klask.conf> (see L</CONFIGURATION>).
3377
3378	default:
3379	days-before-alert: 15
3380
3381	This functionality is not need if your switch use RADIUS 802.1X configuration...
3382
3383
3384	=head2 poe-enable
3385
3386	klask poe-enable [--verbose\|-v] switch port
3387
3388	This command activate the PoE (Power over Ethernet) on a switch port by SNMP.
3389	So you need to give the switch name and a port on the command line.
3390	See L</ABBREVIATION FOR PORT>.
3391
3392	Warning: Only NEXANS switches are supported (we do not have other switch for testing).
3393	You need to have the SNMP write access on the switch in order to modify it's configuration.
3394
3395
3396	=head2 poe-disable
3397
3398	klask poe-disable [--verbose\|-v] switch port
3399
3400	This command deactivate the PoE (Power over Ethernet) on a switch port by SNMP.
3401	So you need to give the switch name and a port on the command line.
3402	See L</ABBREVIATION FOR PORT>.
3403
3404	Warning: Only NEXANS switches are supported (we do not have other switch for testing).
3405	You need to have the SNMP write access on the switch in order to modify it's configuration.
3406
3407
3408	=head2 poe-status
3409
3410	klask poe-status [--verbose\|-v] switch port
3411
3412	This command return the status of the PoE (Power over Ethernet) on a switch port by SNMP.
3413	The return value could be C<enable> or C<disable> word.
3414	So you need to give the switch name and a port on the command line.
3415	See L</ABBREVIATION FOR PORT>.
3416
3417	If it's not possible to change the PoE status with command L</poe-enable> and L</poe-disable>
3418	(SNMP community read write access),
3419	it's always possible to have the PoE port status.
3420
3421	Warning: Only NEXANS switches are supported (we do not have other switch for testing).
3422
3423
3424	=head1 CONFIGURATION
3425
3426	Because Klask need many parameters, it's not possible actually to use command line parameters for everything.
3427	The configuration is done in a F</etc/klask/klask.conf> YAML file.
3428	This format have many advantage over XML, it's easier to read and to write !
3429
3430	Here an example, be aware with indent, it's important in YAML, do not use tabulation !
3431
3432	default:
3433	community: public
3434	community-rw: private
3435	snmpport: 161
3436	float-regex: '(?^msx: ^float )'
3437	scan-mode: active
3438
3439	network:
3440	labnet:
3441	ip-subnet:
3442	- add: 192.168.1.0/24
3443	- add: 192.168.2.0/24
3444	interface: eth0
3445	vlan-id: 12
3446	main-router: gw1.labnet.local
3447
3448	schoolnet:
3449	ip-subnet:
3450	- add: 192.168.3.0/24
3451	- add: 192.168.4.0/24
3452	interface: eth0.38
3453	vlan-id: 13
3454	main-router: gw2.schoolnet.local
3455	scan-mode: passive
3456
3457	etunet:
3458	ip-subnet:
3459	- add: 192.168.5.0/24
3460	interface: eth2
3461	vlan-id: 14
3462	main-router: gw3.etunet.local
3463	scan-mode: passive
3464
3465	switch:
3466	- hostname: sw1.klask.local
3467	location: BatY / 1 floor / K004
3468	portignore:
3469	- 1
3470	- 2
3471
3472	- hostname: sw2.klask.local
3473	location: BatY / 2 floor / K203
3474	type: HP2424
3475	portignore:
3476	- 1
3477	- 2
3478	fake-ip: 192.168.9.14
3479
3480	- hostname: sw3.klask.local
3481	location: BatY / 2 floor / K203
3482
3483	I think it's pretty easy to understand.
3484	The default section can be overide in any section, if parameter mean something in theses sections.
3485	Network to be scan are define in the network section. You must put an add by network.
3486	Maybe I will make a delete line to suppress specific computers.
3487	The switch section define your switch.
3488	You have to write the port number to ignore, this was important if your switchs are cascades
3489	(right now, method C<updatesw> find them automatically)
3490	and is still important if you have loop (with PVST or MSTP).
3491	Just put the ports numbers between switch.
3492
3493	The C<community> parameter is use to get SNMP data on switch.
3494	It could be overload for each switch.
3495	By default, it's value is C<public> and you have to configure a readonly word for safety reason.
3496	Some few command change the switch state as the commands L</enable> and L</disable>.
3497	In theses rares cases, you need a readwrite SNMP community word define in your configuration file.
3498	Klask then use since version C<0.6.2> the C<community-rw> parameter which by default is egal to C<private>.
3499
3500
3501	=head1 ABBREVIATION FOR PORT
3502
3503	HP Procurve and Nexans switches have a simplistic numbering scheme.
3504	It's just number: 1, 2, 3... 24.
3505	On HP8000 chassis, ports names begin with an uppercase letter: A1, A2...
3506	Nothing is done on theses ports names.
3507
3508	On HP Comware and DELL, port digitization schema use a port speed word (generally a very verbose word)
3509	followed by tree number.
3510	In order to have short name,
3511	we made the following rules:
3512
3513	Bridge-Aggregation -> Br
3514	FastEthernet -> Fa
3515	Forty-GigabitEthernet -> Fo
3516	FortyGigabitEthernet -> Fo
3517	GigabitEthernet -> Gi
3518	Giga -> Gi
3519	Port-Channel -> Po
3520	Ten-GigabitEthernet -> Te
3521	TenGigabitEthernet -> Te
3522	Ten -> Te
3523
3524	All Klask command automatically normalize the port name on standart output
3525	and also on input command line.
3526
3527	In the case of use an aggregator port (Po, Tk, Br ...),
3528	the real ports used are also return.
3529
3530
3531	=head1 SWITCH SUPPORTED
3532
3533	Here is a list of switches where Klask gives or gave (for old switches) good results.
3534	We have only a few manageable switches to actually test Klask.
3535	It is quite possible that switches from other brands will work just as well.
3536	You just have to do a test on it and add the line of description that goes well in the source code.
3537	Contact us for any additional information.
3538
3539	In the following list, the names of the switch types written in parentheses are the code names returned by Klask.
3540	This makes it possible to adjust the code names of the different manufacturers!
3541
3542	HP: J3299A(HP224M), J4120A(HP1600M), J9029A(HP1800-8G), J9449A(HP1810-8G), J4093A(HP2424M), J9279A(HP2510G-24),
3543	J9280A(HP2510G-48), J4813A(HP2524), J4900A(HP2626A), J4900B(HP2626B), J4899B(HP2650), J9021A(HP2810-24G), J9022A(HP2810-48G),
3544	J8692A(HP3500-24G), J4903A(HP2824), J4110A(HP8000M), JE074A(HP5120-24G), JE069A(HP5120-48G), JD377A(HP5500-24G), JD374A(HP5500-24F).
3545
3546	BayStack: BayStack 350T HW(BS350T)
3547
3548	Nexans: GigaSwitch V3 TP SFP-I 48V ES3(NA3483-6G), GigaSwitch V3 TP.PSE.+ 48/54V ES3(NA3483-6P)
3549
3550	DELL: PC7024(DPC7024), N2048(DN2048), N4032F(DN4032F), N4064F(DN4064F)
3551
3552	H3C and 3COM switches have never not been tested but the new HP Comware switches are exactly the same...
3553
3554	H3C: H3C5500
3555
3556	3COM: 3C17203, 3C17204, 3CR17562-91, 3CR17255-91, 3CR17251-91, 3CR17571-91, 3CRWX220095A, 3CR17254-91, 3CRS48G-24S-91,
3557	3CRS48G-48S-91, 3C17708, 3C17709, 3C17707, 3CR17258-91, 3CR17181-91, 3CR17252-91, 3CR17253-91, 3CR17250-91, 3CR17561-91,
3558	3CR17572-91, 3C17702-US, 3C17700.
3559
3560
3561	=head1 FILES
3562
3563	/etc/klask/klask.conf
3564	/var/lib/klask/klaskdb
3565	/var/lib/klask/switchdb
3566
3567
3568	=head1 SEE ALSO
3569
3570	Net::SNMP, Net::Netmask, Net::CIDR::Lite, NetAddr::IP, YAML
3571
3572	=over
3573
3574	=item * L<Web site\|http://servforge.legi.grenoble-inp.fr/projects/klask>
3575
3576	=item * L<Online Manual\|http://servforge.legi.grenoble-inp.fr/pub/klask/klask.html>
3577
3578	=back
3579
3580
3581	=head1 VERSION
3582
3583	$Id: klask 323 2017-10-31 10:59:46Z g7moreau $
3584
3585
3586	=head1 AUTHOR
3587
3588	Written by Gabriel Moreau, Grenoble - France
3589
3590
3591	=head1 LICENSE AND COPYRIGHT
3592
3593	GPL version 2 or later and Perl equivalent
3594
3595	Copyright (C) 2005-2017 Gabriel Moreau <Gabriel.Moreau(A)univ-grenoble-alpes.fr>.

Note: See TracBrowser for help on using the repository browser.

Download in other formats: