Context Navigation

source: trunk/klask @ 325

Last change on this file since 325 was 325, checked in by g7moreau, 6 years ago
Stupid error
Property svn:executable set to ``* Property svn:keywords set to `Date Author Id Rev`
File size: 134.2 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 325 2017-10-31 12:30:28Z 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 325 2017-10-31 12:30:28Z 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	my $tb_computer = Text::Table->new(
2603	{align => 'left', align_title => 'left', title => 'IPv4-Address'},
2604	{align => 'left', align_title => 'left', title => 'Hostname-FQ'},
2605	{align => 'left', align_title => 'left', title => 'VLAN'},
2606	{align => 'left', align_title => 'left', title => 'Date'},
2607	);
2608
2609	#printf "%-15s %-40s %-16s %s\n", qw(IPv4-Address Hostname-FQ Date VLAN);
2610	#print "-------------------------------------------------------------------------------\n";
2611	LOOP_ON_IP_ADDRESS:
2612	for my $ip (Net::Netmask::sort_by_ip_address(keys %result_ip)) {
2613	my $vlan_nameid = $result_ip{$ip}->{'vlan'}.'('.get_current_vlan_id($result_ip{$ip}->{'vlan'}).')';
2614	#printf "%-15s %-40s %-16s %s\n", $ip, $result_ip{$ip}->{'hostname_fq'}, $result_ip{$ip}->{'date_last_detection'}, $vlan_nameid;
2615	$tb_computer->add(
2616	$ip,
2617	$result_ip{$ip}->{'hostname_fq'},
2618	$vlan_nameid,
2619	$result_ip{$ip}->{'date_last_detection'},
2620	);
2621	}
2622	print $tb_computer->title();
2623	print $tb_computer->rule('-');
2624	print $tb_computer->body();
2625	}
2626
2627	#---------------------------------------------------------------
2628	sub cmd_ip_free_html {
2629	my %result_ip = @_;
2630
2631	print <<'END_HTML';
2632	<table class="sortable" summary="Klask Free IP Database">
2633	<caption>Klask Free IP Database</caption>
2634	<thead>
2635	<tr>
2636	<th scope="col" class="klask-header-left">IPv4-Address &#8645</th>
2637	<th scope="col" class="sorttable_alpha">Hostname-FQ &#8645</th>
2638	<th scope="col" class="sorttable_alpha">VLAN &#8645</th>
2639	<th scope="col" class="klask-header-right">Date &#8645</th>
2640	</tr>
2641	</thead>
2642	<tfoot>
2643	<tr>
2644	<th scope="col" class="klask-footer-left">IPv4-Address</th>
2645	<th scope="col" class="fklask-hostname">Hostname-FQ</th>
2646	<th scope="col" class="fklask-vlan">VLAN</th>
2647	<th scope="col" class="klask-footer-right">Date</th>
2648	</tr>
2649	</tfoot>
2650	<tbody>
2651	END_HTML
2652
2653	my $typerow = 'even';
2654
2655	LOOP_ON_IP_ADDRESS:
2656	for my $ip (Net::Netmask::sort_by_ip_address(keys %result_ip)) {
2657
2658	$typerow = $typerow eq 'even' ? 'odd' : 'even';
2659
2660	my $ip_sort = sprintf '%03i%03i%03i%03i', split m/ \. /xms, $ip;
2661	my ( $host_short ) = split m/ \. /xms, $result_ip{$ip}->{'hostname_fq'};
2662
2663	my $vlan_nameid = $result_ip{$ip}->{'vlan'}.' ('.get_current_vlan_id($result_ip{$ip}->{'vlan'}).')';
2664
2665	fqdn_html_breakable(my $hostname_fq_html = $result_ip{$ip}->{'hostname_fq'});
2666
2667	print <<"END_HTML";
2668	<tr class="$typerow">
2669	<td sorttable_customkey="$ip_sort">$ip</td>
2670	<td sorttable_customkey="$host_short">$hostname_fq_html</td>
2671	<td>$vlan_nameid</td>
2672	<td>$result_ip{$ip}->{'date_last_detection'}</td>
2673	</tr>
2674	END_HTML
2675	}
2676	print <<'END_HTML';
2677	</tbody>
2678	</table>
2679	END_HTML
2680	}
2681
2682	#---------------------------------------------------------------
2683	sub cmd_enable {
2684	@ARGV = @_;
2685
2686	my $verbose;
2687
2688	GetOptions(
2689	'verbose\|v' => \$verbose,
2690	);
2691
2692	my $switch_name = shift @ARGV \|\| q{};
2693	my $port_hr = shift @ARGV \|\| q{};
2694
2695	if ($switch_name eq q{} or $port_hr eq q{}) {
2696	die "Usage: klask disable SWITCH_NAME PORT\n";
2697	}
2698
2699	if (not defined $SWITCH_DB{$switch_name}) {
2700	die "Switch $switch_name must be defined in klask configuration file\n";
2701	}
2702
2703	my $sw = $SWITCH_DB{$switch_name};
2704	my ($session, $error) = Net::SNMP->session(snmp_get_rwsession($sw));
2705	print "$error \n" if $error;
2706
2707	# Retrieve numeric port value
2708	my $port_id = snmp_get_switchport_hr2id($session, normalize_port_human_readable($port_hr), $verbose ? 'yes' : '');
2709	die "Error : Port $port_hr does not exist on switch $switch_name\n" if not $port_id =~ m/^\d+$/;
2710
2711	my $oid_search_portstatus = $OID_NUMBER{'portUpDown'} .'.'. $port_id;
2712	print "Info: switch $switch_name port $port_hr SNMP OID $oid_search_portstatus\n" if $verbose;
2713
2714	my $result = $session->set_request(
2715	-varbindlist => [$oid_search_portstatus, INTEGER, 1],
2716	);
2717	print $session->error()."\n" if $session->error_status();
2718
2719	$session->close;
2720
2721	#snmpset -v 1 -c community X.X.X.X 1.3.6.1.2.1.2.2.1.7.NoPort = 1 (up)
2722	#snmpset -v 1 -c community X.X.X.X 1.3.6.1.2.1.2.2.1.7.NoPort = 2 (down)
2723	#system "snmpset -v 1 -c public $switch 1.3.6.1.2.1.2.2.1.7.$port = 1";
2724	return;
2725	}
2726
2727	#---------------------------------------------------------------
2728	sub cmd_disable {
2729	@ARGV = @_;
2730
2731	my $verbose;
2732
2733	GetOptions(
2734	'verbose\|v' => \$verbose,
2735	);
2736
2737	my $switch_name = shift @ARGV \|\| q{};
2738	my $port_hr = shift @ARGV \|\| q{};
2739
2740	if ($switch_name eq q{} or $port_hr eq q{}) {
2741	die "Usage: klask disable SWITCH_NAME PORT\n";
2742	}
2743
2744	if (not defined $SWITCH_DB{$switch_name}) {
2745	die "Switch $switch_name must be defined in klask configuration file\n";
2746	}
2747
2748	my $sw = $SWITCH_DB{$switch_name};
2749	my ($session, $error) = Net::SNMP->session(snmp_get_rwsession($sw));
2750	print "$error \n" if $error;
2751
2752	# Retrieve numeric port value
2753	my $port_id = snmp_get_switchport_hr2id($session, normalize_port_human_readable($port_hr), $verbose ? 'yes' : '');
2754	die "Error : Port $port_hr does not exist on switch $switch_name\n" if not $port_id =~ m/^\d+$/;
2755
2756	my $oid_search_portstatus = $OID_NUMBER{'portUpDown'} .'.'. $port_id;
2757	print "Info: switch $switch_name port $port_hr SNMP OID $oid_search_portstatus\n" if $verbose;
2758
2759	my $result = $session->set_request(
2760	-varbindlist => [$oid_search_portstatus, INTEGER, 2],
2761	);
2762	print $session->error()."\n" if $session->error_status();
2763
2764	$session->close;
2765
2766	#system "snmpset -v 1 -c public $switch 1.3.6.1.2.1.2.2.1.7.$port = 2";
2767	return;
2768	}
2769
2770	#---------------------------------------------------------------
2771	sub cmd_status {
2772	@ARGV = @_;
2773
2774	my $verbose;
2775
2776	GetOptions(
2777	'verbose\|v' => \$verbose,
2778	);
2779
2780	my $switch_name = shift @ARGV \|\| q{};
2781	my $port_hr = shift @ARGV \|\| q{};
2782
2783	if ($switch_name eq q{} or $port_hr eq q{}) {
2784	die "Usage: klask status SWITCH_NAME PORT\n";
2785	}
2786
2787	if (not defined $SWITCH_DB{$switch_name}) {
2788	die "Switch $switch_name must be defined in klask configuration file\n";
2789	}
2790
2791	my $sw = $SWITCH_DB{$switch_name};
2792	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
2793	print "$error \n" if $error;
2794
2795	# Retrieve numeric port value
2796	my $port_id = snmp_get_switchport_hr2id($session, normalize_port_human_readable($port_hr), $verbose ? 'yes' : '');
2797	die "Error : Port $port_hr does not exist on switch $switch_name\n" if not $port_id =~ m/^\d+$/;
2798
2799	my $oid_search_portstatus = $OID_NUMBER{'portUpDown'} .'.'. $port_id;
2800	print "Info: switch $switch_name port $port_hr ($port_id) SNMP OID $oid_search_portstatus\n" if $verbose;
2801
2802	my $result = $session->get_request(
2803	-varbindlist => [$oid_search_portstatus]
2804	);
2805	print $session->error()."\n" if $session->error_status();
2806	if (defined $result) {
2807	print "$PORT_UPDOWN{$result->{$oid_search_portstatus}}\n";
2808	}
2809
2810	$session->close;
2811
2812	#system "snmpget -v 1 -c public $switch_name 1.3.6.1.2.1.2.2.1.7.$port";
2813	return;
2814	}
2815
2816	#---------------------------------------------------------------
2817	sub cmd_search_mac_on_switch {
2818	@ARGV = @_;
2819
2820	my $verbose;
2821	my $vlan_id = 0;
2822
2823	GetOptions(
2824	'verbose\|v' => \$verbose,
2825	'vlan\|l=i' => \$vlan_id,
2826	);
2827
2828	my $switch_name = shift @ARGV \|\| q{};
2829	my $mac_address = shift @ARGV \|\| q{};
2830
2831	if ($switch_name eq q{} or $mac_address eq q{}) {
2832	die "Usage: klask search-mac-on-switch SWITCH_NAME MAC_ADDRESS\n";
2833	}
2834
2835	$mac_address = normalize_mac_address($mac_address);
2836	$switch_name = join(',', map {$_->{'hostname'}} @SWITCH_LIST ) if $switch_name eq q{*} or $switch_name eq q{all};
2837
2838	for my $sw_name (split /,/, $switch_name) {
2839	if (not defined $SWITCH_DB{$sw_name}) {
2840	die "Switch $sw_name must be defined in klask configuration file\n";
2841	}
2842
2843	my $oid_search_port1 = $OID_NUMBER{'searchPort1'} . mac_address_hex2dec($mac_address);
2844	my $oid_search_port2 = $OID_NUMBER{'searchPort2'} .'.'. $vlan_id . mac_address_hex2dec($mac_address);
2845	print "Klask search OID $oid_search_port1 on switch $sw_name\n" if $verbose;
2846	print "Klask search OID $oid_search_port2 on switch $sw_name\n" if $verbose;
2847
2848	my $sw = $SWITCH_DB{$sw_name};
2849	my ($session, $error) = Net::SNMP->session( %{$sw->{'snmp_param_session'}} );
2850	print "$error \n" if $error;
2851
2852	my $result = $session->get_request(
2853	-varbindlist => [$oid_search_port1]
2854	);
2855	if (not defined $result) {
2856	$result = $session->get_request(
2857	-varbindlist => [$oid_search_port2]
2858	);
2859	$result->{$oid_search_port1} = $result->{$oid_search_port2} if defined $result;
2860	}
2861
2862	if (defined $result and $result->{$oid_search_port1} ne 'noSuchInstance') {
2863	my $swport_id = $result->{$oid_search_port1};
2864	my $swport_hr = snmp_get_switchport_id2hr($session, $swport_id);
2865	print "Klask find MAC $mac_address on switch $sw_name port $swport_hr\n";
2866	}
2867	else {
2868	print "Klask do not find MAC $mac_address on switch $sw_name\n" if $verbose;
2869	}
2870
2871	$session->close;
2872	}
2873	return;
2874	}
2875
2876	#---------------------------------------------------------------
2877	sub cmd_updatesw {
2878	@ARGV = @_;
2879
2880	my $verbose;
2881
2882	GetOptions(
2883	'verbose\|v' => \$verbose,
2884	);
2885
2886	update_switchdb(verbose => $verbose);
2887	}
2888
2889	#---------------------------------------------------------------
2890	sub cmd_exportsw {
2891	@ARGV = @_;
2892
2893	test_switchdb_environnement();
2894
2895	my $format = 'txt';
2896	my $graph_modulo = 0;
2897	my $graph_shift = 1;
2898
2899	GetOptions(
2900	'format\|f=s' => \$format,
2901	'modulo\|m=i' => \$graph_modulo,
2902	'shift\|s=i' => \$graph_shift,
2903	);
2904
2905	my %possible_format = (
2906	txt => \&cmd_exportsw_txt,
2907	dot => \&cmd_exportsw_dot,
2908	);
2909
2910	$format = 'txt' if not defined $possible_format{$format};
2911
2912	$possible_format{$format}->($graph_modulo, $graph_shift, @ARGV);
2913	return;
2914	}
2915
2916	#---------------------------------------------------------------
2917	sub cmd_exportsw_txt {
2918	my %args = (
2919	way => 'all',
2920	list => 0,
2921	@_);
2922
2923	my $switch_connection = YAML::Syck::LoadFile("$KLASK_SW_FILE");
2924
2925	my %db_switch_output_port = %{$switch_connection->{'output_port'}};
2926	my %db_switch_parent = %{$switch_connection->{'parent'}};
2927	my %db_switch_connected_on_port = %{$switch_connection->{'connected_on_port'}};
2928
2929	# Switch output port and parent port connection
2930	my $tb_child = Text::Table->new( # http://www.perlmonks.org/?node_id=988320
2931	{align => 'left', align_title => 'left', title => 'Child-Switch'},
2932	{align => 'right', align_title => 'right', title => 'Output-Port'},
2933	{align => 'center', align_title => 'center', title => 'Link'},
2934	{align => 'left', align_title => 'left', title => 'Input-Port'},
2935	{align => 'left', align_title => 'left', title => 'Parent-Switch'},
2936	);
2937	for my $sw (sort keys %db_switch_output_port) {
2938	my $arrow ='--->';
2939	$arrow ='===>' if $db_switch_output_port{$sw} =~ m/^(Trk\|Br\|Po)/;
2940	if (exists $db_switch_parent{$sw}) {
2941	$tb_child->add($sw, $db_switch_output_port{$sw}, $arrow, $db_switch_parent{$sw}->{'port_hr'}, $db_switch_parent{$sw}->{'switch'});
2942
2943	}
2944	else {
2945	$tb_child->add($sw, $db_switch_output_port{$sw}, $arrow, '', 'router');
2946	}
2947	}
2948	my @colrange = map { scalar $tb_child->colrange($_) } (0 .. 4); # force scaler context
2949	$tb_child->add(map { ' ' x $_ } reverse @colrange); # add empty line to force symetric table output
2950	print $tb_child->title();
2951	print $tb_child->rule('-');
2952	print $tb_child->body(0, $tb_child->body_height()-1); # remove last fake line
2953	$tb_child->clear;
2954
2955	# Switch parent and children port inter-connection
2956	print "\n";
2957	my $tb_parent = Text::Table->new( # http://www.perlmonks.org/?node_id=988320
2958	{align => 'left', align_title => 'left', title => 'Parent-Switch'},
2959	{align => 'right', align_title => 'right', title => 'Input-Port'},
2960	{align => 'center', align_title => 'center', title => 'Link'},
2961	{align => 'left', align_title => 'left', title => 'Output-Port'},
2962	{align => 'left', align_title => 'left', title => 'Child-Switch'},
2963	);
2964	for my $swport (sort keys %db_switch_connected_on_port) {
2965	my ($sw_connect, $port_connect) = split m/ $SEP_SWITCH_PORT /xms, $swport, 2;
2966	for my $sw (keys %{$db_switch_connected_on_port{$swport}}) {
2967	my $arrow ='<---';
2968	$arrow ='<===' if $port_connect =~ m/^(Trk\|Br\|Po)/;
2969	if (exists $db_switch_output_port{$sw}) {
2970	$tb_parent->add($sw_connect, $port_connect, $arrow, $db_switch_output_port{$sw}, $sw);
2971	}
2972	else {
2973	$tb_parent->add($sw_connect, $port_connect, $arrow, '', $sw);
2974	}
2975	}
2976	}
2977	@colrange = map { scalar $tb_parent->colrange($_) } (0 .. 4); # force scaler context
2978	$tb_parent->add(map { ' ' x $_ } reverse @colrange); # add empty line to force symetric table output
2979	print $tb_parent->title();
2980	print $tb_parent->rule('-');
2981	print $tb_parent->body(0, $tb_parent->body_height()-1); # remove last fake line
2982	$tb_parent->clear;
2983
2984	return;
2985	}
2986
2987	#---------------------------------------------------------------
2988	sub cmd_exportsw_dot {
2989	my $graph_modulo = shift;
2990	my $graph_shift = shift;
2991
2992	my $switch_connection = YAML::Syck::LoadFile("$KLASK_SW_FILE");
2993
2994	my %db_switch_output_port = %{$switch_connection->{'output_port'}};
2995	my %db_switch_parent = %{$switch_connection->{'parent'}};
2996	my %db_switch_connected_on_port = %{$switch_connection->{'connected_on_port'}};
2997	my %db_switch_link_with = %{$switch_connection->{'link_with'}};
2998	my %db_switch_global = %{$switch_connection->{'switch_db'}};
2999	my $timestamp = $switch_connection->{'timestamp'};
3000
3001	my $invisible_node = 0; # Count number of invisible node
3002
3003	my %db_building= ();
3004	my %db_switch_line = (); # Number of line drawed on a switch
3005	for my $sw (values %db_switch_global) {
3006	my ($building, $location) = split m/ \/ /xms, $sw->{'location'}, 2;
3007	$db_building{$building} \|\|= {};
3008	$db_building{$building}->{$location} \|\|= {};
3009	$db_building{$building}->{$location}{ $sw->{'hostname'} } = 'y';
3010
3011	$db_switch_line{$sw} = 0;
3012	}
3013
3014
3015	print "digraph G {\n";
3016	print "rankdir=LR;\n";
3017	#print "splines=polyline;\n";
3018
3019	print "site [label=\"site\", color=black, fillcolor=gold, shape=invhouse, style=filled];\n";
3020	print "internet [label=\"internet\", color=black, fillcolor=cyan, shape=house, style=filled];\n";
3021
3022	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime $timestamp;
3023	$year += 1900;
3024	$mon++;
3025	my $date = sprintf '%04i-%02i-%02i %02i:%02i', $year, $mon, $mday, $hour, $min;
3026	print "\"$date\" [label=\"MAP DATE\\n\\n$date\", color=white, fillcolor=black, shape=polygon, sides=14, style=filled, fontcolor=white];\n";
3027	print "site -> \"$date\" [style=invis];\n";
3028
3029	my $b=0;
3030	for my $building (keys %db_building) {
3031	$b++;
3032
3033	print "\"building$b\" [label=\"$building\", color=black, fillcolor=gold, style=filled];\n";
3034	print "site -> \"building$b\" [len=2, color=firebrick];\n";
3035
3036	my $l = 0;
3037	for my $loc (keys %{$db_building{$building}}) {
3038	$l++;
3039
3040	print "\"location$b-$l\" [label=\"$building" . q{/} . join(q{\n}, split(m{ / }xms, $loc)) . "\", color=black, fillcolor=orange, style=filled];\n";
3041	# print "\"location$b-$l\" [label=\"$building / $loc\", color=black, fillcolor=orange, style=filled];\n";
3042	print "\"building$b\" -> \"location$b-$l\" [len=2, color=firebrick];\n";
3043
3044	for my $sw (keys %{$db_building{$building}->{$loc}}) {
3045
3046	my $peripheries = 1;
3047	my $color = 'lightblue';
3048	if ($db_switch_output_port{$sw} =~ m/^(Trk\|Br\|Po)/) {
3049	$peripheries = 2;
3050	$color = "\"$color:$color\"";
3051	}
3052	print "\"$sw:$db_switch_output_port{$sw}\" [label=\"".format_aggregator4dot($db_switch_output_port{$sw})."\", color=black, fillcolor=lightblue, peripheries=$peripheries, style=filled];\n";
3053
3054	my $swname = $sw;
3055	$swname .= q{\n-\n} . "$db_switch_global{$sw}->{'model'}" if exists $db_switch_global{$sw} and exists $db_switch_global{$sw}->{'model'};
3056	print "\"$sw\" [label=\"$swname\", color=black, fillcolor=palegreen, shape=rect, style=filled];\n";
3057	print "\"location$b-$l\" -> \"$sw\" [len=2, color=firebrick, arrowtail=dot];\n";
3058	print "\"$sw\" -> \"$sw:$db_switch_output_port{$sw}\" [len=2, style=bold, color=$color, arrowhead=normal, arrowtail=invdot];\n";
3059
3060
3061	for my $swport (keys %db_switch_connected_on_port) {
3062	my ($sw_connect, $port_connect) = split m/ $SEP_SWITCH_PORT /xms, $swport, 2;
3063	next if not $sw_connect eq $sw;
3064	next if $port_connect eq $db_switch_output_port{$sw};
3065	my $peripheries = 1;
3066	my $color = 'plum';
3067	if ($port_connect =~ m/^(Trk\|Br\|Po)/) {
3068	$peripheries = 2;
3069	$color = "\"$color:$color\"";
3070	}
3071	print "\"$sw:$port_connect\" [label=\"".format_aggregator4dot($port_connect)."\", color=black, fillcolor=plum, peripheries=$peripheries, style=filled];\n";
3072	print "\"$sw:$port_connect\" -> \"$sw\" [len=2, style=bold, color=$color, arrowhead=normal, arrowtail=inv];\n";
3073
3074	#$db_switch_line{$sw}++;
3075	#if ($db_switch_line{$sw} % 9 == 0) {
3076	# # Create invisible node
3077	# $invisible_node++;
3078	# my $invisible = '__Invisible_' . $invisible_node;
3079	# print "$invisible [shape=none, label=\"\"]\n";
3080	# print "\"$sw:$port_connect\" -> $invisible [style=invis]\n";
3081	# print "$invisible -> \"$sw\" [style=invis]\n";
3082	# }
3083	}
3084	}
3085	}
3086	}
3087
3088	# print "Switch output port and parent port connection\n";
3089	# print "---------------------------------------------\n";
3090	for my $sw (sort keys %db_switch_output_port) {
3091	if (exists $db_switch_parent{$sw}) {
3092	# printf " \"%s:%s\" -> \"%s:%s\"\n", $sw, $db_switch_output_port{$sw}, $db_switch_parent{$sw}->{'switch'}, $db_switch_parent{$sw}->{'port_id'};
3093	}
3094	else {
3095	my $style = 'solid';
3096	my $color = 'black'; # navyblue
3097	if ($db_switch_output_port{$sw} =~ m/^(Trk\|Br\|Po)/) {
3098	$style = 'bold';
3099	$color = "\"$color:invis:$color\"";
3100	}
3101	printf " \"%s:%s\" -> internet [style=$style, color=$color];\n", $sw, $db_switch_output_port{$sw};
3102	}
3103	}
3104	print "\n";
3105
3106	# shift graph between 1 or 2 when $graph_shift = 3
3107	my $graph_breaker = 1;
3108
3109	# print "Switch parent and children port inter-connection\n";
3110	# print "------------------------------------------------\n";
3111	for my $swport (sort keys %db_switch_connected_on_port) {
3112	my ($sw_connect, $port_connect) = split m/ $SEP_SWITCH_PORT /xms, $swport, 2;
3113	for my $sw (keys %{$db_switch_connected_on_port{$swport}}) {
3114	my $style = 'solid';
3115	my $color = 'black'; # navyblue
3116	if ($port_connect =~ m/^(Trk\|Br\|Po)/) {
3117	$style = 'bold';
3118	$color = "\"$color:invis:$color\"";
3119	}
3120	if (exists $db_switch_output_port{$sw}) {
3121	printf " \"%s:%s\" -> \"%s:%s\" [style=$style, color=$color];\n", $sw, $db_switch_output_port{$sw}, $sw_connect, $port_connect;
3122
3123	next if $graph_modulo == 0; # No shift (invisible nodes) in graph
3124	$db_switch_line{$sw_connect}++;
3125	if ($db_switch_line{$sw_connect} % $graph_modulo == 0) {
3126	# Create invisible node
3127	$invisible_node++;
3128	my $invisible = '__Invisible_' . $invisible_node;
3129	print " \"$invisible.a\" [shape=none, label=\"\"];\n";
3130	printf " \"%s:%s\" -> \"$invisible.a\" [style=invis];\n", $sw, $db_switch_output_port{$sw};
3131	$graph_breaker++;
3132	if ($graph_shift == 2 or ($graph_shift == 3 and ($graph_breaker % 2) == 0)) {
3133	# Two invisible node
3134	print " \"$invisible.b\" [shape=none, label=\"\"];\n";
3135	print " \"$invisible.a\" -> \"$invisible.b\" [style=invis];\n";
3136	printf " \"$invisible.b\" -> \"%s:%s\" [style=invis];\n", $sw_connect, $port_connect;
3137	}
3138	else {
3139	# One invisible node
3140	printf " \"$invisible.a\" -> \"%s:%s\" [style=invis];\n", $sw_connect, $port_connect;
3141	}
3142	}
3143	}
3144	else {
3145	printf " \"%s\" -> \"%s:%s\" [style=$style];\n", $sw, $sw_connect, $port_connect;
3146	}
3147	}
3148	}
3149
3150	print "}\n";
3151	return;
3152	}
3153
3154
3155	################################################################
3156	# documentation
3157	################################################################
3158
3159	__END__
3160
3161	=head1 NAME
3162
3163	klask - port and search manager for switches, map management
3164
3165
3166	=head1 USAGE
3167
3168	klask version
3169	klask help
3170
3171	klask updatedb [--verbose\|-v] [--verb-description\|-d] [--chk-hostname\|-h] [--chk-location\|-l] [--no-rebuildsw\|-R]
3172	klask exportdb [--format\|-f txt\|html]
3173	klask removedb IP* computer*
3174	klask cleandb [--verbose\|-v] --day number_of_day --repair-dns
3175
3176	klask updatesw [--verbose\|-v]
3177	klask exportsw [--format\|-f txt\|dot] [--modulo\|-m XX] [--shift\|-s YY]
3178
3179	klask searchdb [--kind\|-k host\|mac] computer [mac-address]
3180	klask search computer
3181	klask search-mac-on-switch [--verbose\|-v] [--vlan\|-i vlan-id] switch mac_addr
3182
3183	klask ip-free [--verbose\|-v] [--day\|-d days-to-death] [--format\|-f txt\|html] [vlan_name]
3184
3185	klask bad-vlan-id [--day\|-d days_before_alert]
3186
3187	klask enable [--verbose\|-v] switch port
3188	klask disable [--verbose\|-v] switch port
3189	klask status [--verbose\|-v] switch port
3190
3191	klask poe-enable [--verbose\|-v] switch port
3192	klask poe-disable [--verbose\|-v] switch port
3193	klask poe-status [--verbose\|-v] switch port
3194
3195	klask vlan-getname switch vlan-id
3196	klask vlan-list switch
3197
3198
3199	=head1 DESCRIPTION
3200
3201	Klask is a small tool to find where is connected a host in a big network
3202	and on which VLAN.
3203	Klask mean search in brittany.
3204	No hight level protocol like CDL, LLDP are use.
3205	Everything is just done with SNMP request on MAC address.
3206
3207	Limitation : loop cannot be detected and could be problematic when the map is created (C<updatesw> method).
3208	If you use PVST or MSTP and create loop between VLAN,
3209	you have to use C<portignore> functionality on switch port to cut manually loop
3210	(see config file below).
3211
3212	When you use a management port to administrate a switch,
3213	it's not possible to create the map with this switch because it does not have a MAC address,
3214	so other switch cannot find the real downlink port...
3215	One way to work around this problem is, if you have a computer directly connected on the switch,
3216	to put this IP as the fake ip for the switch.
3217	The MAC address associated will be use just for the map detection.
3218	The C<fake-ip> parameter is defined in the config file.
3219
3220	Klask has now a web site dedicated for it: L<http://servforge.legi.grenoble-inp.fr/projects/klask>!
3221
3222
3223	=head1 COMMANDS
3224
3225	Some command are defined in the source code but are not documented here.
3226	Theses could be not well defined, not finished, not well tested...
3227	You can read the source code and use them at your own risk
3228	(like for all the Klask code).
3229
3230	=head2 search
3231
3232	klask search computer
3233
3234	This command takes one or more computer in argument.
3235	It search a computer on the network and give the port and the switch on which the computer is connected.
3236
3237	=head2 search-mac-on-switch
3238
3239	klask search-mac-on-switch [--verbose\|-v] [--vlan\|-i vlan-id] switch mac_addr
3240
3241	This command search a MAC address on a switch.
3242	To search on all switch, you could put C<'*'> or C<all>.
3243	The VLAN parameter could help.
3244
3245
3246	=head2 enable
3247
3248	klask enable [--verbose\|-v] switch port
3249
3250	This command activate a port (or an agrregate bridge port) on a switch by SNMP.
3251	So you need to give the switch name and a port on the command line.
3252	See L</ABBREVIATION FOR PORT>.
3253
3254	Warning: You need to have the SNMP write access on the switch in order to modify it's configuration.
3255
3256
3257	=head2 disable
3258
3259	klask disable [--verbose\|-v] switch port
3260
3261	This command deactivate a port (or an agrregate bridge port) on a switch by SNMP.
3262	So you need to give the switch name and a port on the command line.
3263	See L</ABBREVIATION FOR PORT>.
3264
3265	Warning: You need to have the SNMP write access on the switch in order to modify it's configuration.
3266
3267
3268	=head2 status
3269
3270	klask status [--verbose\|-v] switch port
3271
3272	This command return the status of a port number on a switch by SNMP.
3273	The return value could be C<enable> or C<disable> word.
3274	So you need to give the switch name and a port on the command line.
3275	See L</ABBREVIATION FOR PORT>.
3276
3277	If it's not possible to change port status with command L</enable> and L</disable>
3278	(SNMP community read write access),
3279	it's always possible to have the port status even for bridge agrregate port.
3280
3281
3282	=head2 updatedb
3283
3284	klask updatedb [--verbose\|-v] [--verb-description\|-d] [--chk-hostname\|-h] [--chk-location\|-l] [--no-rebuildsw\|-R]
3285
3286	This command will scan networks and update the computer database.
3287	To know which are the cmputer scanned, you have to configure the file F</etc/klask/klask.conf>.
3288	This file is easy to read and write because Klask use YAML format and not XML
3289	(see L</CONFIGURATION>).
3290
3291	Option are not stable and could be use manually when you have a new kind of switch.
3292	Maybe some option will be transfered in a future C<checksw> command!
3293
3294	The network parameter C<scan-mode> can have two values: C<active> or C<passive>.
3295	By default, a network is C<active>.
3296	This means that an C<fping> command is done at the beginning on all the IP of the network
3297	and the computers that was not detected in this pass, but where their Klask entry is less than one week,
3298	will have an C<arping>
3299	(some OS do not respond to C<ping> but a computer have to respond to C<arping> if it want to interact with other).
3300	In the scan mode C<passive>, no C<fping> and no C<arping> are done.
3301	It's good for big subnet with few computer (telephone...).
3302	The idea of the C<active> scan mode is to force computer to regulary send packet over the network.
3303
3304	At the beginning, the command verify that the switch map checksum is always valid.
3305	Otherwise, a rebuild procedure will ne done automatically.
3306
3307	=head2 exportdb
3308
3309	klask exportdb [--format\|-f txt\|html]
3310
3311	This command print the content of the computer database.
3312	There is actually only two format : TXT and HTML.
3313	By default, format is TXT.
3314	It's very easy to have more format, it's just need times...
3315
3316	=head2 removedb
3317
3318	klask removedb IP* computer*
3319
3320	This command remove an entry in the database.
3321	There is only one kind of parameter, the IP of the computers to be removed.
3322	You can put as many IP as you want...
3323
3324	Computer DNS names are also a valid entry because a DNS resolver is executed at the beginning.
3325
3326	=head2 cleandb
3327
3328	klask cleandb [--verbose\|-v] --day number_of_day --repair-dns
3329
3330	Remove double entry (same MAC-Address) in the computer database when the older one is older than X day (C<--day>) the new one.
3331	Computer name beginning by 'float' (regex C<^float>) are not really taken into account but could be remove.
3332	This could be configure with the global regex parameter C<float-regex> in the configuration file F</etc/klask/klask.conf>.
3333	This functionality could be use when computer define in VLAN 1
3334	could have a float IP when they are connected on VLAN 2.
3335	In the Klask database, the float DNS entries are less important.
3336
3337	When reverse DNS has not been done by the past, option C<--repair-dns> force a reverse DNS check on all unkown host.
3338
3339	=head2 updatesw
3340
3341	klask updatesw [--verbose\|-v]
3342
3343	This command build a map of your manageable switch on your network.
3344	The list of the switches must be given in the file F</etc/klask/klask.conf> (see L</CONFIGURATION>).
3345
3346	The database has a checksum which depend of all the active switches.
3347	It's use when rebuilding the database in case of change in switch configuration (one more for example).
3348
3349	=head2 exportsw
3350
3351	klask exportsw [--format\|-f txt\|dot] [--modulo\|-m XX] [--shift\|-s YY]
3352
3353	This command print the content of the switch database. There is actually two format.
3354	One is just TXT for terminal and the other is the DOT format from the graphviz environnement.
3355	By default, format is TXT.
3356
3357	klask exportsw --format dot > /tmp/map.dot
3358	dot -Tpng /tmp/map.dot > /tmp/map.png
3359
3360	In case you have too many switch connected on one switch,
3361	the graphviz result graph could be too much vertical.
3362	With C<--modulo> > 0, you can specify how many switches (connected on one switch) are on the same columns
3363	before shifting them to one column to the left and back again.
3364	The C<--shift> parameter must be 1, 2 or 3.
3365	With C<--shift> egual to 2, the shift will be to two column to the left.
3366	With 3, it will be 1 to the left and 2 to the left one time over two !
3367	In practise, we just add virtuals nodes in the dot file,
3368	that means the result graph is generated with theses virtuals but invisibles nodes...
3369
3370	=head2 ip-free
3371
3372	klask ip-free [--verbose\|-v] [--day\|-d days-to-death] [--format\|-f txt\|html] [vlan_name]
3373
3374	This command return IP address that was not use (detected by Klask) at this time.
3375	The list returned could be limited to just one VLAN.
3376	IP returned could have been never used or no computer have been detected since the number of days specified
3377	(2 years by default).
3378	This parameter could also be define in the configuration file F</etc/klask/klask.conf> (see L</CONFIGURATION>).
3379
3380	default:
3381	days-to-death: 730
3382
3383	Computer that does not have the good IP but takes a float one (see L</cleandb>) are taken into account.
3384
3385
3386	=head2 bad-vlan-id
3387
3388	klask bad-vlan-id [--day\|-d days_before_alert]
3389
3390	This command return a list of switch port that are not configure with the good VLAN.
3391	Computer which are in bad VLAN are detected with the float regex parameter (see L</cleandb>)
3392	and another prior trace where they had the good IP (good DNS name).
3393	The computer must stay connected on a bad VLAN more than XX days (15 days by default) before alert.
3394	This parameter could also define in the configuration file F</etc/klask/klask.conf> (see L</CONFIGURATION>).
3395
3396	default:
3397	days-before-alert: 15
3398
3399	This functionality is not need if your switch use RADIUS 802.1X configuration...
3400
3401
3402	=head2 poe-enable
3403
3404	klask poe-enable [--verbose\|-v] switch port
3405
3406	This command activate the PoE (Power over Ethernet) on a switch port by SNMP.
3407	So you need to give the switch name and a port on the command line.
3408	See L</ABBREVIATION FOR PORT>.
3409
3410	Warning: Only NEXANS switches are supported (we do not have other switch for testing).
3411	You need to have the SNMP write access on the switch in order to modify it's configuration.
3412
3413
3414	=head2 poe-disable
3415
3416	klask poe-disable [--verbose\|-v] switch port
3417
3418	This command deactivate the PoE (Power over Ethernet) on a switch port by SNMP.
3419	So you need to give the switch name and a port on the command line.
3420	See L</ABBREVIATION FOR PORT>.
3421
3422	Warning: Only NEXANS switches are supported (we do not have other switch for testing).
3423	You need to have the SNMP write access on the switch in order to modify it's configuration.
3424
3425
3426	=head2 poe-status
3427
3428	klask poe-status [--verbose\|-v] switch port
3429
3430	This command return the status of the PoE (Power over Ethernet) on a switch port by SNMP.
3431	The return value could be C<enable> or C<disable> word.
3432	So you need to give the switch name and a port on the command line.
3433	See L</ABBREVIATION FOR PORT>.
3434
3435	If it's not possible to change the PoE status with command L</poe-enable> and L</poe-disable>
3436	(SNMP community read write access),
3437	it's always possible to have the PoE port status.
3438
3439	Warning: Only NEXANS switches are supported (we do not have other switch for testing).
3440
3441
3442	=head1 CONFIGURATION
3443
3444	Because Klask need many parameters, it's not possible actually to use command line parameters for everything.
3445	The configuration is done in a F</etc/klask/klask.conf> YAML file.
3446	This format have many advantage over XML, it's easier to read and to write !
3447
3448	Here an example, be aware with indent, it's important in YAML, do not use tabulation !
3449
3450	default:
3451	community: public
3452	community-rw: private
3453	snmpport: 161
3454	float-regex: '(?^msx: ^float )'
3455	scan-mode: active
3456
3457	network:
3458	labnet:
3459	ip-subnet:
3460	- add: 192.168.1.0/24
3461	- add: 192.168.2.0/24
3462	interface: eth0
3463	vlan-id: 12
3464	main-router: gw1.labnet.local
3465
3466	schoolnet:
3467	ip-subnet:
3468	- add: 192.168.3.0/24
3469	- add: 192.168.4.0/24
3470	interface: eth0.38
3471	vlan-id: 13
3472	main-router: gw2.schoolnet.local
3473	scan-mode: passive
3474
3475	etunet:
3476	ip-subnet:
3477	- add: 192.168.5.0/24
3478	interface: eth2
3479	vlan-id: 14
3480	main-router: gw3.etunet.local
3481	scan-mode: passive
3482
3483	switch:
3484	- hostname: sw1.klask.local
3485	location: BatY / 1 floor / K004
3486	portignore:
3487	- 1
3488	- 2
3489
3490	- hostname: sw2.klask.local
3491	location: BatY / 2 floor / K203
3492	type: HP2424
3493	portignore:
3494	- 1
3495	- 2
3496	fake-ip: 192.168.9.14
3497
3498	- hostname: sw3.klask.local
3499	location: BatY / 2 floor / K203
3500
3501	I think it's pretty easy to understand.
3502	The default section can be overide in any section, if parameter mean something in theses sections.
3503	Network to be scan are define in the network section. You must put an add by network.
3504	Maybe I will make a delete line to suppress specific computers.
3505	The switch section define your switch.
3506	You have to write the port number to ignore, this was important if your switchs are cascades
3507	(right now, method C<updatesw> find them automatically)
3508	and is still important if you have loop (with PVST or MSTP).
3509	Just put the ports numbers between switch.
3510
3511	The C<community> parameter is use to get SNMP data on switch.
3512	It could be overload for each switch.
3513	By default, it's value is C<public> and you have to configure a readonly word for safety reason.
3514	Some few command change the switch state as the commands L</enable> and L</disable>.
3515	In theses rares cases, you need a readwrite SNMP community word define in your configuration file.
3516	Klask then use since version C<0.6.2> the C<community-rw> parameter which by default is egal to C<private>.
3517
3518
3519	=head1 ABBREVIATION FOR PORT
3520
3521	HP Procurve and Nexans switches have a simplistic numbering scheme.
3522	It's just number: 1, 2, 3... 24.
3523	On HP8000 chassis, ports names begin with an uppercase letter: A1, A2...
3524	Nothing is done on theses ports names.
3525
3526	On HP Comware and DELL, port digitization schema use a port speed word (generally a very verbose word)
3527	followed by tree number.
3528	In order to have short name,
3529	we made the following rules:
3530
3531	Bridge-Aggregation -> Br
3532	FastEthernet -> Fa
3533	Forty-GigabitEthernet -> Fo
3534	FortyGigabitEthernet -> Fo
3535	GigabitEthernet -> Gi
3536	Giga -> Gi
3537	Port-Channel -> Po
3538	Ten-GigabitEthernet -> Te
3539	TenGigabitEthernet -> Te
3540	Ten -> Te
3541
3542	All Klask command automatically normalize the port name on standart output
3543	and also on input command line.
3544
3545	In the case of use an aggregator port (Po, Tk, Br ...),
3546	the real ports used are also return.
3547
3548
3549	=head1 SWITCH SUPPORTED
3550
3551	Here is a list of switches where Klask gives or gave (for old switches) good results.
3552	We have only a few manageable switches to actually test Klask.
3553	It is quite possible that switches from other brands will work just as well.
3554	You just have to do a test on it and add the line of description that goes well in the source code.
3555	Contact us for any additional information.
3556
3557	In the following list, the names of the switch types written in parentheses are the code names returned by Klask.
3558	This makes it possible to adjust the code names of the different manufacturers!
3559
3560	HP: J3299A(HP224M), J4120A(HP1600M), J9029A(HP1800-8G), J9449A(HP1810-8G), J4093A(HP2424M), J9279A(HP2510G-24),
3561	J9280A(HP2510G-48), J4813A(HP2524), J4900A(HP2626A), J4900B(HP2626B), J4899B(HP2650), J9021A(HP2810-24G), J9022A(HP2810-48G),
3562	J8692A(HP3500-24G), J4903A(HP2824), J4110A(HP8000M), JE074A(HP5120-24G), JE069A(HP5120-48G), JD377A(HP5500-24G), JD374A(HP5500-24F).
3563
3564	BayStack: BayStack 350T HW(BS350T)
3565
3566	Nexans: GigaSwitch V3 TP SFP-I 48V ES3(NA3483-6G), GigaSwitch V3 TP.PSE.+ 48/54V ES3(NA3483-6P)
3567
3568	DELL: PC7024(DPC7024), N2048(DN2048), N4032F(DN4032F), N4064F(DN4064F)
3569
3570	H3C and 3COM switches have never not been tested but the new HP Comware switches are exactly the same...
3571
3572	H3C: H3C5500
3573
3574	3COM: 3C17203, 3C17204, 3CR17562-91, 3CR17255-91, 3CR17251-91, 3CR17571-91, 3CRWX220095A, 3CR17254-91, 3CRS48G-24S-91,
3575	3CRS48G-48S-91, 3C17708, 3C17709, 3C17707, 3CR17258-91, 3CR17181-91, 3CR17252-91, 3CR17253-91, 3CR17250-91, 3CR17561-91,
3576	3CR17572-91, 3C17702-US, 3C17700.
3577
3578
3579	=head1 FILES
3580
3581	/etc/klask/klask.conf
3582	/var/lib/klask/klaskdb
3583	/var/lib/klask/switchdb
3584
3585
3586	=head1 SEE ALSO
3587
3588	Net::SNMP, Net::Netmask, Net::CIDR::Lite, NetAddr::IP, YAML
3589
3590	=over
3591
3592	=item * L<Web site\|http://servforge.legi.grenoble-inp.fr/projects/klask>
3593
3594	=item * L<Online Manual\|http://servforge.legi.grenoble-inp.fr/pub/klask/klask.html>
3595
3596	=back
3597
3598
3599	=head1 VERSION
3600
3601	$Id: klask 325 2017-10-31 12:30:28Z g7moreau $
3602
3603
3604	=head1 AUTHOR
3605
3606	Written by Gabriel Moreau, Grenoble - France
3607
3608
3609	=head1 LICENSE AND COPYRIGHT
3610
3611	GPL version 2 or later and Perl equivalent
3612
3613	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: