Subversion Repositories ALCASAR

Rev

Rev 2141 | Rev 2190 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log

Rev 2141 Rev 2189
Line -... Line 1...
- 
 
 1 
#!/bin/bash
- 
 
 2 
# $Id: alcasar-activity_report.sh 2189 2017-04-28 21:34:19Z tom.houdayer $
- 
 
 3 
#
1 
# Create an activity report for ALCASAR every week (sunday at 5.35 pm --> see cron.d).
 4 
# Create an activity report for ALCASAR every week (sunday at 5.35 pm --> see cron.d).
2 
# We read configuration files and logs to create cool charts.
 5 
# We read configuration files and logs to create cool charts.
3 
# Written by Raphaël PION & Rexy
 6 
# Written by Raphaël PION & Rexy
4 
 
 7 
 
5 
# files
 8 
# files
Line 69... Line 72...
69 
fi
 72 
fi
70 
 
 73 
 
71 
echo "<!doctype html>" >> $HTML_REPORT
 74 
echo "<!doctype html>" >> $HTML_REPORT
72 
echo "<html>" >> $HTML_REPORT
 75 
echo "<html>" >> $HTML_REPORT
73 
echo "<head>" >> $HTML_REPORT
 76 
echo "<head>" >> $HTML_REPORT
74 
echo "<meta http-equiv='Content-Type' content='text/html; charset=UTF-8'>" >> $HTML_REPORT
 77 
echo "<meta charset=\"utf-8\">" >> $HTML_REPORT
75 
echo "<title>ALCASAR report</title>" >> $HTML_REPORT
 78 
echo "<title>ALCASAR report</title>" >> $HTML_REPORT
76 
echo "<link rel='stylesheet' type='text/css' href='../../../css/bootstrap.min.css'>" >> $HTML_REPORT
 79 
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../../../css/bootstrap.min.css\">" >> $HTML_REPORT
77 
echo "<link rel='stylesheet' type='text/css' href='../../../css/report.css'>" >> $HTML_REPORT
 80 
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../../../css/report.css\">" >> $HTML_REPORT
78 
echo "<script src='../../../js/Chart.bundle.js'></script>" >> $HTML_REPORT
 81 
echo "<script src=\"../../../js/Chart.bundle.js\"></script>" >> $HTML_REPORT
79 
echo "<script src='../../../js/jquery.min.js'></script>" >> $HTML_REPORT
 82 
echo "<script src=\"../../../js/jquery.min.js\"></script>" >> $HTML_REPORT
80 
echo "</head>" >> $HTML_REPORT
 83 
echo "</head>" >> $HTML_REPORT
81 
echo "<body>" >> $HTML_REPORT
 84 
echo "<body>" >> $HTML_REPORT
82 
echo "<h1><center>Rapport d'activité de l'ALCASAR-$(cat /usr/local/etc/alcasar.conf | grep ORGANISM | cut -d'=' -f2)</center></h1>" >> $HTML_REPORT
 85 
echo "<h1><center>Rapport d'activité de l'ALCASAR-$(cat /usr/local/etc/alcasar.conf | grep ORGANISM | cut -d'=' -f2)</center></h1>" >> $HTML_REPORT
83 
echo "<i><p style='text-align: right;'>Date de création $(date +%F)</p></i>" >> $HTML_REPORT
 86 
echo "<i><p style=\"text-align: right;\">Date de création $(date +%F)</p></i>" >> $HTML_REPORT
84 
echo "<font size='1'>" >> $HTML_REPORT
 87 
echo "<font size=\"1\">" >> $HTML_REPORT
85 
 
 88 
 
86 
######################TABINFO######################
 89 
######################TABINFO######################
87 
echo "Create information about system and ALCASAR"
 90 
echo "Create information about system and ALCASAR"
88 
#contain every information about ALCASAR configuration, system and last update
 91 
#contain every information about ALCASAR configuration, system and last update
89 
 
 92 
 
Line 174... Line 177...
174 
			echo "<td>$RPM_DATE</td>" >> $HTML_REPORT
 177 
			echo "<td>$RPM_DATE</td>" >> $HTML_REPORT
175 
			echo "<td>$RPM_VERSION</td>" >> $HTML_REPORT
 178 
			echo "<td>$RPM_VERSION</td>" >> $HTML_REPORT
176 
			echo "</tr>" >> $HTML_REPORT
 179 
			echo "</tr>" >> $HTML_REPORT
177 
		done
 180 
		done
178 
	else
 181 
	else
179 
		echo "<tr><td colspan=3>Pas de RPM mis à jour cette semaine</td></tr>" >> $HTML_REPORT
 182 
		echo "<tr><td colspan=\"3\">Pas de RPM mis à jour cette semaine</td></tr>" >> $HTML_REPORT
180 
	fi
 183 
	fi
181 
else
 184 
else
182 
	echo $LINE_HTML >> $HTML_REPORT
 185 
	echo $LINE_HTML >> $HTML_REPORT
183 
fi
 186 
fi
184 
done
 187 
done
Line 353... Line 356...
353 
		LABEL=$(echo $LINE | cut -d':' -f1)
 356 
		LABEL=$(echo $LINE | cut -d':' -f1)
354 
		if [ $DATA -ne 0 ]
 357 
		if [ $DATA -ne 0 ]
355 
		then
 358 
		then
356 
		        VALUE_BL_DATA="$VALUE_BL_DATA $DATA, "
 359 
			VALUE_BL_DATA="$VALUE_BL_DATA $DATA, "
357 
		        VALUE_BL_LABEL="$VALUE_BL_LABEL '$LABEL ($DATA)',"
 360 
			VALUE_BL_LABEL="$VALUE_BL_LABEL '$LABEL ($DATA)',"
358
- 
 
359 
		fi
 361 
		fi
360 
	done
 362 
	done
361 
 
 363 
 
362 
	#get other categories (sum them all)
 364 
	#get other categories (sum them all)
363 
        if [ $(cat $TMP_BL_WEEK_CAT | cut -d':' -f2 | sort -k1 -rn | tail -n+$(($(echo $VALUE_BL_DATA | wc -w)+1)) |  paste -sd+ | bc) -gt 0 ]
 365 
	if [ $(cat $TMP_BL_WEEK_CAT | cut -d':' -f2 | sort -k1 -rn | tail -n+$(($(echo $VALUE_BL_DATA | wc -w)+1)) |  paste -sd+ | bc) -gt 0 ]
Line 452... Line 454...
452 
	do
 454 
	do
453 
		DATE_1=$TS
 455 
		DATE_1=$TS
454 
		DATE_2=$((TS-$STEP_TS))
 456 
		DATE_2=$((TS-$STEP_TS))
455 
		COUNT_AV=0
457 
		COUNT_AV=0
456
458 
 
457 
 
 - 
 
458 
		for TS_FILE in $(cat $TMP_AV)
 459 
		for TS_FILE in $(cat $TMP_AV)
459 
		do
 460 
		do
460 
			if [ "$TS_FILE" -le "$DATE_1" -a "$TS_FILE" -ge "$DATE_2" ]
 461 
			if [ "$TS_FILE" -le "$DATE_1" -a "$TS_FILE" -ge "$DATE_2" ]
461 
			then
462 
			then
462 
				COUNT_AV=$((COUNT_AV+1))
 463 
				COUNT_AV=$((COUNT_AV+1))
463 
 
 - 
 
464 
			fi
 464 
			fi
465 
		done
 465 
		done
466
466 
 
467 
		VALUE_AV_LABEL="'$(date -d @$DATE_2 "+%Y-%m-%d" )', $VALUE_AV_LABEL"
 467 
		VALUE_AV_LABEL="'$(date -d @$DATE_2 "+%Y-%m-%d" )', $VALUE_AV_LABEL"
468 
		VALUE_AV_DATA="$COUNT_AV, $VALUE_AV_DATA"
 468 
		VALUE_AV_DATA="$COUNT_AV, $VALUE_AV_DATA"
Line 525... Line 525...
525 
	echo "</script>" >> $HTML_REPORT
 525 
	echo "</script>" >> $HTML_REPORT
526 
else
 526 
else
527 
	echo "<h3>Aucune menace virale.</h3>" >> $HTML_REPORT
 527 
	echo "<h3>Aucune menace virale.</h3>" >> $HTML_REPORT
528 
fi
 528 
fi
529 
 
 529 
 
530 
######################AUTHORIZED CONNECTIONS######################
 - 
 
531 
 
 - 
 
532 
echo "Create authorized connections since the installation of ALCASAR"
 - 
 
533 
#get number of authorized, forbidden and fail2ban connections :
 - 
 
534 
PASSWD_FILE="/root/ALCASAR-passwords.txt"
 - 
 
535 
QUERY="SELECT COUNT(acctterminatecause) FROM radacct WHERE acctterminatecause=\"User-Request\" ORDER BY acctstarttime"
 - 
 
536 
AUTHORIZED=$(mysql -D radius -u root -p$(cat $PASSWD_FILE | grep "root /" | rev | cut -d' '  -f1 | rev) -e "$QUERY" | cut -d')' -f2)
 - 
 
537 
QUERY="SELECT COUNT(acctterminatecause) FROM radacct WHERE acctterminatecause=\"Admin-Reset\" ORDER BY acctstarttime"
 - 
 
538 
FORBIDDEN=$(mysql -D radius -u root -p$(cat $PASSWD_FILE | grep "root /" | rev | cut -d' '  -f1 | rev) -e "$QUERY" | cut -d')' -f2)
 - 
 
539 
FAIL2BAN=$(strings /var/log/fail2ban.log | grep " Ban " | wc -l)
 - 
 
540 
 
 - 
 
541 
VALUE_AUTH="$AUTHORIZED, $FORBIDDEN, $FAIL2BAN"
 - 
 
542 
LABEL_AUTH="'Autorisées ($AUTHORIZED) ', 'Interdites ($FORBIDDEN)', 'fail2ban($FAIL2BAN)'"
 - 
 
543 
 
 - 
 
544 
#create chart pie in html file with javascript (chartjs.com)
 - 
 
545 
NAME_AUTH='chart_auth'
 - 
 
546 
CONF_AUTH='config_auth'
 - 
 
547 
echo "<center>" >> $HTML_REPORT
 - 
 
548 
echo "<canvas id='$NAME_AUTH' width='450' height='450' ></canvas>" >> $HTML_REPORT
 - 
 
549 
echo "</center>" >> $HTML_REPORT
 - 
 
550 
echo "<script>" >> $HTML_REPORT
 - 
 
551
- 
 
552 
cat $MODEL_CHARTJS | while read LINE_JS
 - 
 
553 
do
 - 
 
554 
	#variable name
 - 
 
555 
	if [ $(echo $LINE_JS | grep 'XXCONFXX' | wc -l) -eq 1 ]
- 
 
556 
	then
 - 
 
557 
		echo ${LINE_JS/XXCONFXX/$CONF_AUTH} >> $HTML_REPORT
 - 
 
558 
	#chart type
 - 
 
559 
	elif [ $(echo $LINE_JS | grep 'XXTYPEXX' | wc -l) -eq 1 ]
- 
 
560 
	then
 - 
 
561 
		echo ${LINE_JS/XXTYPEXX/pie} >> $HTML_REPORT
 - 
 
562 
	#graph title
 - 
 
563 
	elif [ $(echo $LINE_JS | grep 'XXTITLEXX' | wc -l) -eq 1 ]
 - 
 
564 
	then
 - 
 
565 
	        echo ${LINE_JS/XXTITLEXX/"Connexions des utilisateurs"} >> $HTML_REPORT
 - 
 
566 
	#chart data
 - 
 
567 
	elif [ $(echo $LINE_JS | grep 'XXDATAXX' | wc -l) -eq 1 ]
- 
 
568 
	then
 - 
 
569 
		echo ${LINE_JS/XXDATAXX/$VALUE_AUTH} >> $HTML_REPORT
 - 
 
570 
	#color
 - 
 
571 
	elif [ $(echo $LINE_JS | grep 'XXCOLORXX' | wc -l) -eq 1 ]
- 
 
572 
	then
 - 
 
573 
		echo ${LINE_JS/XXCOLORXX/"'#000099','#ff6600','#ff0000'"} >> $HTML_REPORT
 - 
 
574 
	#labels
 - 
 
575 
	elif [ $(echo $LINE_JS | grep 'XXLABELSXX' | wc -l) -eq 1 ]
- 
 
576 
	then
 - 
 
577 
		echo ${LINE_JS/XXLABELSXX/$LABEL_AUTH} >> $HTML_REPORT
 - 
 
578 
	#display legend, only useful for chart pie
 - 
 
579 
	elif [ $(echo $LINE_JS | grep 'XXLEGENDXX' | wc -l) -eq 1 ]
- 
 
580 
	then
 - 
 
581 
		echo ${LINE_JS/XXLEGENDXX/true} >> $HTML_REPORT
 - 
 
582 
	#display value of Y axis, only useful for chart bar
 - 
 
583 
	elif [ $(echo $LINE_JS | grep 'XXCOMMENT-BEGINXX' | wc -l) -eq 1 ]
- 
 
584 
	then
 - 
 
585 
		echo "/*" >> $HTML_REPORT
 - 
 
586 
	#display value of Y axis, only useful for chart bar
 - 
 
587 
	elif [ $(echo $LINE_JS | grep 'XXCOMMENT-ENDXX' | wc -l) -eq 1 ]
- 
 
588 
	then
 - 
 
589 
		echo "*/" >> $HTML_REPORT
 - 
 
590 
	else
 - 
 
591 
		echo $LINE_JS >> $HTML_REPORT
 - 
 
592 
	fi
 - 
 
593 
done
 - 
 
594 
echo "</script>" >> $HTML_REPORT
 - 
 
595 
 
 - 
 
596 
 
 530 
 
597 
######################ALCASAR : DAILY USE######################
 531 
######################ALCASAR : DAILY USE######################
598 
echo "Get daily use connection of the week"
 532 
echo "Get daily use connection of the week"
599 
#create html document
 533 
#create html document
600 
echo "<h3>Statistiques volumétrie connexions</h3>" >> $HTML_REPORT
 534 
echo "<h3>Statistiques volumétrie connexions</h3>" >> $HTML_REPORT
Line 647... Line 581...
647 
if [ $ENABLE_AV -eq "1" ]
 581 
if [ $ENABLE_AV -eq "1" ]
648 
then
 582 
then
649 
	echo "var ctx_$NAME_AV = document.getElementById('$NAME_AV').getContext('2d');" >> $HTML_REPORT
 583 
	echo "var ctx_$NAME_AV = document.getElementById('$NAME_AV').getContext('2d');" >> $HTML_REPORT
650 
	echo "var $NAME_AV = new Chart(ctx_$NAME_AV, $CONF_AV);" >> $HTML_REPORT
 584 
	echo "var $NAME_AV = new Chart(ctx_$NAME_AV, $CONF_AV);" >> $HTML_REPORT
651 
fi
 585 
fi
652 
#CONNEXIONS AUTHORIZED
 - 
 
653 
echo "var ctx_$NAME_AUTH = document.getElementById('$NAME_AUTH').getContext('2d');" >> $HTML_REPORT
 - 
 
654 
echo "var $NAME_AUTH = new Chart(ctx_$NAME_AUTH, $CONF_AUTH);" >> $HTML_REPORT
 - 
 
655 
echo "};</script>" >> $HTML_REPORT
 586 
echo "};</script>" >> $HTML_REPORT
656 
echo "</body>" >> $HTML_REPORT
 587 
echo "</body>" >> $HTML_REPORT
657 
echo "</html>" >> $HTML_REPORT
 588 
echo "</html>" >> $HTML_REPORT
658 
 
 589 
 
659 
#convert html document to PDF
 590 
#convert html document to PDF