Subversion Repositories ALCASAR

Rev

Rev 2644 | Rev 2840 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 2644 Rev 2688
1 
#!/bin/bash
 1 
#!/bin/bash
2 
# $Id: alcasar-activity_report.sh 2644 2018-10-29 14:09:33Z lucas.echard $
 2 
# $Id: alcasar-activity_report.sh 2688 2019-01-18 23:15:49Z lucas.echard $
3 
#
 3 
#
4 
# 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).
5 
# We read configuration files and logs to create cool charts.
 5 
# We read configuration files and logs to create cool charts.
6 
# Written by Raphaël PION, Rexy & Tom HOUDAYER
 6 
# Written by Raphaël PION, Rexy & Tom HOUDAYER
7 
 
 7 
 
8 
CONF_FILE='/usr/local/etc/alcasar.conf'
 8 
CONF_FILE='/usr/local/etc/alcasar.conf'
9 
# files
 9 
# files
10 
DIR_TMP="/var/tmp"
 10 
DIR_TMP="/var/tmp"
11 
TMP_AV="$DIR_TMP/av_count.txt"
 11 
TMP_AV="$DIR_TMP/av_count.txt"
12 
TMP_BL="$DIR_TMP/bl_count.txt"
 12 
TMP_BL="$DIR_TMP/bl_count.txt"
13 
TMP_BL_WEEK="$DIR_TMP/bl_count_week.txt"
 13 
TMP_BL_WEEK="$DIR_TMP/bl_count_week.txt"
14 
TMP_BL_WEEK_CAT="$DIR_TMP/bl_count_week_cat.txt"
 14 
TMP_BL_WEEK_CAT="$DIR_TMP/bl_count_week_cat.txt"
15 
 
 15 
 
16 
# Model loaded to create charts
 16 
# Model loaded to create charts
17 
DIR_BUILD="/var/www/html/acc/manager/activity_report/"
 17 
DIR_BUILD="/var/www/html/acc/manager/activity_report/"
18 
MODEL_CHARTJS="$DIR_BUILD/models/Chart.report.js"
 18 
MODEL_CHARTJS="$DIR_BUILD/models/Chart.report.js"
19 
MODEL_TABINFO="$DIR_BUILD/models/tabinfo.html"
 19 
MODEL_TABINFO="$DIR_BUILD/models/tabinfo.html"
20 
 
 20 
 
21 
# Where the report will be created.
 21 
# Where the report will be created.
22 
HTML_REPORT="$DIR_BUILD/alcasar-report-$(date +%F).html"
 22 
HTML_REPORT="$DIR_BUILD/alcasar-report-$(date +%F).html"
23 
 
 23 
 
24 
# TIME VALUE
 24 
# TIME VALUE
25 
C_TS=$(date +"%s") #current timestamp
 25 
C_TS=$(date +"%s") #current timestamp
26 
MAX_DAY_AGO=7
 26 
MAX_DAY_AGO=7
27 
SECS_AGO=$(date --date="$MAX_DAY_AGO days ago" +"%s") #timestamp ago
 27 
SECS_AGO=$(date --date="$MAX_DAY_AGO days ago" +"%s") #timestamp ago
28 
STEP_TS=$((C_TS-$SECS_AGO)) #timestamp between current timestamp and SECS_AGO
 28 
STEP_TS=$((C_TS-$SECS_AGO)) #timestamp between current timestamp and SECS_AGO
29 
 
 29 
 
30 
# PRIVATE IP OF ALCASAR
 30 
# PRIVATE IP OF ALCASAR
31 
PRIVATE_IP=$(grep ^PRIVATE_IP= $CONF_FILE | cut -d'=' -f2 | cut -d'/' -f1)
 31 
PRIVATE_IP=$(grep ^PRIVATE_IP= $CONF_FILE | cut -d'=' -f2 | cut -d'/' -f1)
32 
 
 32 
 
33 
# COLOR for charts
 33 
# COLOR for charts
34 
COLOR="'#ff0000','#3333cc','#009933','#993300','#1720EE','#D30229','#8D726D','#41C4E4','#8574F4','#A0BC1A','#BFDC1F','#5ADDC3','#B05744','#CD9319','#8CA39B','#D4AA1C','#A76752','#B03088','#445E87','#70424D','#D118C3','#46ABEF','#E9F197','#AEC0D4','#755C79','#94BBD7','#E2E9DC','#8B68D0','#F7EC7C','#1F16B8','#F4DA0A','#2EC17A','#E06483','#48B342','#F510CD','#9B2662','#180E98','#988FC1','#209E4E','#034240','#FDB142','#36B445','#CDD5C9','#6FA0DE','#EE2206','#204E19','#15FC93','#161ECE','#83D33B','#11A44A','#B7BF6C','#87274C','#B52C4F','#AD2805','#427E6C','#91341A','#191315','#FCB290','#13D3CD','#90F0E6','#C870C9','#AD2C14','#201D2A','#E4DB79','#90A919','#FE17FE','#09B35C','#88D950','#3440FC','#A9D42F','#E2DFAC','#DA69EC','#67430A','#43E94E','#5F7349','#22CF16','#CF038F','#0F6427','#F7AD0F','#C5E382','#DB49B6','#F760BF','#0BE701','#EF88D8','#79E6D7','#8A2D3D','#435A30','#A3C8AC','#99B118','#A929FF','#08A36D','#0A1654','#6F8283','#E1CA3E','#3E8577','#580FB6','#DB0E16','#386CBE','#FA0C43','#B713C9'"
 34 
COLOR="'#ff0000','#3333cc','#009933','#993300','#1720EE','#D30229','#8D726D','#41C4E4','#8574F4','#A0BC1A','#BFDC1F','#5ADDC3','#B05744','#CD9319','#8CA39B','#D4AA1C','#A76752','#B03088','#445E87','#70424D','#D118C3','#46ABEF','#E9F197','#AEC0D4','#755C79','#94BBD7','#E2E9DC','#8B68D0','#F7EC7C','#1F16B8','#F4DA0A','#2EC17A','#E06483','#48B342','#F510CD','#9B2662','#180E98','#988FC1','#209E4E','#034240','#FDB142','#36B445','#CDD5C9','#6FA0DE','#EE2206','#204E19','#15FC93','#161ECE','#83D33B','#11A44A','#B7BF6C','#87274C','#B52C4F','#AD2805','#427E6C','#91341A','#191315','#FCB290','#13D3CD','#90F0E6','#C870C9','#AD2C14','#201D2A','#E4DB79','#90A919','#FE17FE','#09B35C','#88D950','#3440FC','#A9D42F','#E2DFAC','#DA69EC','#67430A','#43E94E','#5F7349','#22CF16','#CF038F','#0F6427','#F7AD0F','#C5E382','#DB49B6','#F760BF','#0BE701','#EF88D8','#79E6D7','#8A2D3D','#435A30','#A3C8AC','#99B118','#A929FF','#08A36D','#0A1654','#6F8283','#E1CA3E','#3E8577','#580FB6','#DB0E16','#386CBE','#FA0C43','#B713C9'"
35 
 
 35 
 
36 
# Values to create new htdigest user to consult statistique of ACC
 36 
# Values to create new htdigest user to consult statistique of ACC
37 
DIR_KEY="/usr/local/etc/digest"
 37 
DIR_KEY="/usr/local/etc/digest"
38 
tmp_account="tmp_activityreport"
 38 
tmp_account="tmp_activityreport"
39 
realm="ALCASAR Control Center (ACC)"
 39 
realm="ALCASAR Control Center (ACC)"
40 
password=$(openssl rand -base64 32) #random password (length : 32)
 40 
password=$(openssl rand -base64 32) #random password (length : 32)
41 
SED="/usr/bin/sed -i "
 41 
SED="/usr/bin/sed -i "
42 
TMP_STATS="$DIR_TMP/stats.html"
 42 
TMP_STATS="$DIR_TMP/stats.html"
43 
TMP_STATS_2="$DIR_TMP/stats2.html"
 43 
TMP_STATS_2="$DIR_TMP/stats2.html"
44 
 
 44 
 
45 
# if empty logs, replace charts by text.
 45 
# if empty logs, replace charts by text.
46 
ENABLE_BL=0
 46 
ENABLE_BL=0
47 
ENABLE_BL_WEEK=0
 47 
ENABLE_BL_WEEK=0
48 
ENABLE_AV=0
 48 
ENABLE_AV=0
49 
 
 49 
 
50 
if [ -e $TMP_AV ]
 50 
if [ -e $TMP_AV ]
51 
then
 51 
then
52 
	rm $TMP_AV
 52 
	rm $TMP_AV
53 
fi
 53 
fi
54 
 
 54 
 
55 
if [ -e $TMP_BL ]
 55 
if [ -e $TMP_BL ]
56 
then
 56 
then
57 
	rm $TMP_BL
 57 
	rm $TMP_BL
58 
fi
 58 
fi
59 
 
 59 
 
60 
if [ -e $TMP_BL_WEEK ]
 60 
if [ -e $TMP_BL_WEEK ]
61 
then
 61 
then
62 
	rm $TMP_BL_WEEK
 62 
	rm $TMP_BL_WEEK
63 
fi
 63 
fi
64 
 
 64 
 
65 
if [ -e $TMP_BL_WEEK_CAT ]
 65 
if [ -e $TMP_BL_WEEK_CAT ]
66 
then
 66 
then
67 
	rm $TMP_BL_WEEK_CAT
 67 
	rm $TMP_BL_WEEK_CAT
68 
fi
 68 
fi
69 
 
 69 
 
70 
if [ -e $HTML_REPORT ]
 70 
if [ -e $HTML_REPORT ]
71 
then
 71 
then
72 
	rm $HTML_REPORT
 72 
	rm $HTML_REPORT
73 
fi
 73 
fi
74 
 
 74 
 
75 
echo "<!doctype html>" >> $HTML_REPORT
 75 
echo "<!doctype html>" >> $HTML_REPORT
76 
echo "<html>" >> $HTML_REPORT
 76 
echo "<html>" >> $HTML_REPORT
77 
echo "<head>" >> $HTML_REPORT
 77 
echo "<head>" >> $HTML_REPORT
78 
echo "<meta charset=\"utf-8\">" >> $HTML_REPORT
 78 
echo "<meta charset=\"utf-8\">" >> $HTML_REPORT
79 
echo "<title>ALCASAR report</title>" >> $HTML_REPORT
 79 
echo "<title>ALCASAR report</title>" >> $HTML_REPORT
80 
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../../../css/bootstrap.min.css\">" >> $HTML_REPORT
 80 
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../../../css/bootstrap.min.css\">" >> $HTML_REPORT
81 
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../../../css/report.css\">" >> $HTML_REPORT
 81 
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../../../css/report.css\">" >> $HTML_REPORT
82 
echo "<script src=\"../../../js/Chart.bundle.min.js\"></script>" >> $HTML_REPORT
 82 
echo "<script src=\"../../../js/Chart.bundle.min.js\"></script>" >> $HTML_REPORT
83 
echo "<script src=\"../../../js/jquery.min.js\"></script>" >> $HTML_REPORT
 83 
echo "<script src=\"../../../js/jquery.min.js\"></script>" >> $HTML_REPORT
84 
echo "</head>" >> $HTML_REPORT
 84 
echo "</head>" >> $HTML_REPORT
85 
echo "<body>" >> $HTML_REPORT
 85 
echo "<body>" >> $HTML_REPORT
86 
echo "<h1><center>Rapport d'activité de l'ALCASAR-$(grep ^ORGANISM= $CONF_FILE | cut -d'=' -f2-)</center></h1>" >> $HTML_REPORT
 86 
echo "<h1><center>Rapport d'activité de l'ALCASAR-$(grep ^ORGANISM= $CONF_FILE | cut -d'=' -f2-)</center></h1>" >> $HTML_REPORT
87 
echo "<i><p style=\"text-align: right;\">Date de création $(date +%F)</p></i>" >> $HTML_REPORT
 87 
echo "<i><p style=\"text-align: right;\">Date de création $(date +%F)</p></i>" >> $HTML_REPORT
88 
echo "<font size=\"1\">" >> $HTML_REPORT
 88 
echo "<font size=\"1\">" >> $HTML_REPORT
89 
 
 89 
 
90 
######################TABINFO######################
 90 
######################TABINFO######################
91 
echo "Create information about system and ALCASAR"
 91 
echo "Create information about system and ALCASAR"
92 
#contain every information about ALCASAR configuration, system and last update
 92 
#contain every information about ALCASAR configuration, system and last update
93 
 
 93 
 
94 
cat $MODEL_TABINFO | while read LINE_HTML
 94 
cat $MODEL_TABINFO | while read LINE_HTML
95 
do
 95 
do
- 
 
 96 
	if [ "$(echo $LINE_HTML | grep 'XXORGXX' | wc -l)" -eq 1 ]
- 
 
 97 
	then
- 
 
 98 
		VALUE=$(grep ^ORGANISM= $CONF_FILE | cut -d'=' -f2-)
- 
 
 99 
		echo ${LINE_HTML/XXORGXX/$VALUE} >> $HTML_REPORT
96 
 
 100 
 
97 
if [ $(echo $LINE_HTML | grep 'XXORGXX' | wc -l) -eq 1 ]
 - 
 
98 
then
 - 
 
99 
	VALUE=$(grep ^ORGANISM= $CONF_FILE | cut -d'=' -f2-)
 - 
 
100 
	echo ${LINE_HTML/XXORGXX/$VALUE} >> $HTML_REPORT
 - 
 
101
- 
 
102 
elif [ $(echo $LINE_HTML | grep 'XXINSTALLXX' | wc -l) -eq 1 ]
 101 
	elif [ "$(echo $LINE_HTML | grep 'XXINSTALLXX' | wc -l)" -eq 1 ]
103 
then
 - 
 
104 
	VALUE=$(grep ^INSTALL_DATE= $CONF_FILE | cut -d'=' -f2)
 - 
 
105 
	echo ${LINE_HTML/XXINSTALLXX/$VALUE} >> $HTML_REPORT
 - 
 
106
- 
 
107 
elif [ $(echo $LINE_HTML | grep 'XXAVERSIONXX' | wc -l) -eq 1 ]
 - 
 
108 
then
 - 
 
109 
	VALUE=$(grep ^VERSION= $CONF_FILE | cut -d'=' -f2)
 - 
 
110 
	echo ${LINE_HTML/XXAVERSIONXX/$VALUE} >> $HTML_REPORT
 - 
 
111
- 
 
112 
elif [ $(echo $LINE_HTML | grep 'XXIP_PUBLICXX' | wc -l) -eq 1 ]
 - 
 
113 
then
 - 
 
114 
	VALUE=$(grep ^PUBLIC_IP= $CONF_FILE | cut -d'=' -f2)
 - 
 
115 
	echo ${LINE_HTML/XXIP_PUBLICXX/$VALUE} >> $HTML_REPORT
 - 
 
116
- 
 
117 
elif [ $(echo $LINE_HTML | grep 'XXIP_PRIVEXX' | wc -l) -eq 1 ]
 - 
 
118 
then
 - 
 
119 
	VALUE=$(grep ^PRIVATE_IP= $CONF_FILE | cut -d'=' -f2)
 - 
 
120 
	echo ${LINE_HTML/XXIP_PRIVEXX/$VALUE} >> $HTML_REPORT
 - 
 
121
- 
 
122 
elif [ $(echo $LINE_HTML | grep 'XXGWXX' | wc -l) -eq 1 ]
 - 
 
123 
then
 - 
 
124 
	VALUE=$(grep ^GW= $CONF_FILE | cut -d'=' -f2)
 - 
 
125 
	echo ${LINE_HTML/XXGWXX/$VALUE} >> $HTML_REPORT
 - 
 
126
- 
 
127 
elif [ $(echo $LINE_HTML | grep 'XXDNS1XX' | wc -l) -eq 1 ]
 - 
 
128 
then
 - 
 
129 
	VALUE=$(grep ^DNS1= $CONF_FILE | cut -d'=' -f2)
 - 
 
130 
	echo ${LINE_HTML/XXDNS1XX/$VALUE} >> $HTML_REPORT
 - 
 
131
- 
 
132 
elif [ $(echo $LINE_HTML | grep 'XXDNS2XX' | wc -l) -eq 1 ]
 - 
 
133 
then
 - 
 
134 
	VALUE=$(grep ^DNS2= $CONF_FILE | cut -d'=' -f2)
 - 
 
135 
	echo ${LINE_HTML/XXDNS2XX/$VALUE} >> $HTML_REPORT
 - 
 
136
- 
 
137 
elif [ $(echo $LINE_HTML | grep 'XXHOSTXX' | wc -l) -eq 1 ]
 - 
 
138 
then
 - 
 
139 
	VALUE=$(hostname)
 - 
 
140 
	echo ${LINE_HTML/XXHOSTXX/$VALUE} >> $HTML_REPORT
 - 
 
141
- 
 
142 
elif [ $(echo $LINE_HTML | grep 'XXOS_VERSIONXX' | wc -l) -eq 1 ]
 - 
 
143 
then
 - 
 
144 
	VALUE=$( echo $(uname -r) [ $(uname -m) ] )
 - 
 
145 
	echo ${LINE_HTML/XXOS_VERSIONXX/$VALUE} >> $HTML_REPORT
 - 
 
146
- 
 
147 
elif [ $(echo $LINE_HTML | grep 'XXREBOOTXX' | wc -l) -eq 1 ]
 - 
 
148 
then
 - 
 
149 
	VALUE=$(echo $(who -b | cut -d' ' -f12-))
 - 
 
150 
	echo ${LINE_HTML/XXREBOOTXX/$VALUE} >> $HTML_REPORT
 - 
 
151
- 
 
152 
elif [ $(echo $LINE_HTML | grep 'XXMAJCLAMAVXX' | wc -l) -eq 1 ]
 - 
 
153 
then
 - 
 
154 
	VALUE=$(date -d @$(rpm -qa --queryformat "%{installtime} %{name}\n" | grep -E "clamav-db" | cut -d' ' -f1 ) "+%Y-%m-%d %H:%M:%S")
 - 
 
155 
	echo ${LINE_HTML/XXMAJCLAMAVXX/$VALUE} >> $HTML_REPORT
 - 
 
156
- 
 
157 
elif [ $(echo $LINE_HTML | grep 'XXMAJBLXX' | wc -l) -eq 1 ]
 - 
 
158 
then
 - 
 
159 
	VALUE=$(cat /etc/e2guardian/lists/blacklists/README | grep 'Last version' | cut -d' ' -f4-6)
 - 
 
160 
	echo ${LINE_HTML/XXMAJBLXX/$VALUE} >> $HTML_REPORT
 - 
 
161
- 
 
162 
elif [ $(echo $LINE_HTML | grep 'XXRPMXX' | wc -l) -eq 1 ]
 - 
 
163 
then
 - 
 
164 
	#show every ALCASAR RPM updated since X day ago
 - 
 
165 
	#get timestamp of X day ago. Then we get every packets chich have been updated since this date.
 - 
 
166 
	if [ $(rpm -qa --queryformat '%{installtime} %{name} %{version}\n' | awk -v seuil="$SECS_AGO" '$1 > seuil' | sort -n | grep -E "$PACKAGE" | wc -l) -gt 1 ]
 - 
 
167 
	then
 102 
	then
- 
 
 103 
		VALUE=$(grep ^INSTALL_DATE= $CONF_FILE | cut -d'=' -f2)
- 
 
 104 
		echo ${LINE_HTML/XXINSTALLXX/$VALUE} >> $HTML_REPORT
- 
 
 105 
 
- 
 
 106 
	elif [ "$(echo $LINE_HTML | grep 'XXAVERSIONXX' | wc -l)" -eq 1 ]
- 
 
 107 
	then
- 
 
 108 
		VALUE=$(grep ^VERSION= $CONF_FILE | cut -d'=' -f2)
- 
 
 109 
		echo ${LINE_HTML/XXAVERSIONXX/$VALUE} >> $HTML_REPORT
- 
 
 110 
 
- 
 
 111 
	elif [ "$(echo $LINE_HTML | grep 'XXIP_PUBLICXX' | wc -l)" -eq 1 ]
- 
 
 112 
	then
- 
 
 113 
		VALUE=$(grep ^PUBLIC_IP= $CONF_FILE | cut -d'=' -f2)
- 
 
 114 
		echo ${LINE_HTML/XXIP_PUBLICXX/$VALUE} >> $HTML_REPORT
- 
 
 115 
 
- 
 
 116 
	elif [ "$(echo $LINE_HTML | grep 'XXIP_PRIVEXX' | wc -l)" -eq 1 ]
- 
 
 117 
	then
- 
 
 118 
		VALUE=$(grep ^PRIVATE_IP= $CONF_FILE | cut -d'=' -f2)
- 
 
 119 
		echo ${LINE_HTML/XXIP_PRIVEXX/$VALUE} >> $HTML_REPORT
- 
 
 120 
 
- 
 
 121 
	elif [ "$(echo $LINE_HTML | grep 'XXGWXX' | wc -l)" -eq 1 ]
- 
 
 122 
	then
- 
 
 123 
		VALUE=$(grep ^GW= $CONF_FILE | cut -d'=' -f2)
- 
 
 124 
		echo ${LINE_HTML/XXGWXX/$VALUE} >> $HTML_REPORT
- 
 
 125 
 
- 
 
 126 
	elif [ "$(echo $LINE_HTML | grep 'XXDNS1XX' | wc -l)" -eq 1 ]
- 
 
 127 
	then
- 
 
 128 
		VALUE=$(grep ^DNS1= $CONF_FILE | cut -d'=' -f2)
- 
 
 129 
		echo ${LINE_HTML/XXDNS1XX/$VALUE} >> $HTML_REPORT
- 
 
 130 
 
- 
 
 131 
	elif [ "$(echo $LINE_HTML | grep 'XXDNS2XX' | wc -l)" -eq 1 ]
- 
 
 132 
	then
- 
 
 133 
		VALUE=$(grep ^DNS2= $CONF_FILE | cut -d'=' -f2)
- 
 
 134 
		echo ${LINE_HTML/XXDNS2XX/$VALUE} >> $HTML_REPORT
- 
 
 135 
 
- 
 
 136 
	elif [ "$(echo $LINE_HTML | grep 'XXHOSTXX' | wc -l)" -eq 1 ]
- 
 
 137 
	then
- 
 
 138 
		VALUE=$(hostname)
- 
 
 139 
		echo ${LINE_HTML/XXHOSTXX/$VALUE} >> $HTML_REPORT
- 
 
 140 
 
- 
 
 141 
	elif [ "$(echo $LINE_HTML | grep 'XXOS_VERSIONXX' | wc -l)" -eq 1 ]
- 
 
 142 
	then
- 
 
 143 
		VALUE=$(echo "$(uname -r) [ $(uname -m) ]")
- 
 
 144 
		echo ${LINE_HTML/XXOS_VERSIONXX/$VALUE} >> $HTML_REPORT
- 
 
 145 
 
- 
 
 146 
	elif [ "$(echo $LINE_HTML | grep 'XXREBOOTXX' | wc -l)" -eq 1 ]
- 
 
 147 
	then
- 
 
 148 
		VALUE=$(who -b | cut -d' ' -f12-)
- 
 
 149 
		echo ${LINE_HTML/XXREBOOTXX/$VALUE} >> $HTML_REPORT
- 
 
 150 
 
- 
 
 151 
	elif [ "$(echo $LINE_HTML | grep 'XXMAJCLAMAVXX' | wc -l)" -eq 1 ]
- 
 
 152 
	then
- 
 
 153 
		VALUE=$(date -d "@$(rpm -qa --queryformat "%{installtime} %{name}\n" | grep -E "clamav-db" | cut -d' ' -f1 )" "+%Y-%m-%d %H:%M:%S")
- 
 
 154 
		echo ${LINE_HTML/XXMAJCLAMAVXX/$VALUE} >> $HTML_REPORT
- 
 
 155 
 
- 
 
 156 
	elif [ "$(echo $LINE_HTML | grep 'XXMAJBLXX' | wc -l)" -eq 1 ]
- 
 
 157 
	then
- 
 
 158 
		VALUE=$(cat /etc/e2guardian/lists/blacklists/README | grep 'Last version' | cut -d' ' -f4-6)
- 
 
 159 
		echo ${LINE_HTML/XXMAJBLXX/$VALUE} >> $HTML_REPORT
- 
 
 160 
 
- 
 
 161 
	elif [ "$(echo $LINE_HTML | grep 'XXRPMXX' | wc -l)" -eq 1 ]
- 
 
 162 
	then
- 
 
 163 
		#show every ALCASAR RPM updated since X day ago
- 
 
 164 
		#get timestamp of X day ago. Then we get every packets chich have been updated since this date.
- 
 
 165 
		if [ "$(rpm -qa --queryformat '%{installtime} %{name} %{version}\n' | awk -v seuil="$SECS_AGO" '$1 > seuil' | sort -n | grep -E "$PACKAGE" | wc -l)" -gt 1 ]
- 
 
 166 
		then
168 
		PACKAGE='php|lighttpd|iptables|dnsmasq|radius|tinyproxy|nfdump|e2guardian|clamav|ulogd|chilli|fail2ban|openssh|havp|ipt-netflow|wget'
 167 
			PACKAGE='php|lighttpd|iptables|dnsmasq|unbound|radius|tinyproxy|nfdump|e2guardian|clamav|ulogd|chilli|fail2ban|openssh|havp|ipt-netflow|wget'
169 
		rpm -qa --queryformat '%{installtime} %{name} %{version}\n' | awk -v seuil="$SECS_AGO" '$1 > seuil' | sort -n | grep -E "$PACKAGE" | while read RPM_ALCASAR
 168 
			rpm -qa --queryformat '%{installtime} %{name} %{version}\n' | awk -v seuil="$SECS_AGO" '$1 > seuil' | sort -n | grep -E "$PACKAGE" | while read RPM_ALCASAR
170 
		do
 169 
			do
171 
			RPM_TIMESTAMP=$(echo $RPM_ALCASAR | cut -d' ' -f1)
 170 
				RPM_TIMESTAMP=$(echo $RPM_ALCASAR | cut -d' ' -f1)
172 
			RPM_DATE=$(date -d @$(echo $RPM_TIMESTAMP) "+%Y-%m-%d %H:%M:%S")
 171 
				RPM_DATE=$(date -d "@$(echo $RPM_TIMESTAMP)" "+%Y-%m-%d %H:%M:%S")
173 
			RPM_NAME=$(echo $RPM_ALCASAR | cut -d' ' -f2)
 172 
				RPM_NAME=$(echo $RPM_ALCASAR | cut -d' ' -f2)
174 
			RPM_VERSION=$(echo $RPM_ALCASAR | cut -d' ' -f3)
 173 
				RPM_VERSION=$(echo $RPM_ALCASAR | cut -d' ' -f3)
175 
 
 174 
 
176 
			echo "<tr>" >> $HTML_REPORT
 175 
				echo "<tr>" >> $HTML_REPORT
177 
			echo "<td>$RPM_NAME</td>" >> $HTML_REPORT
 176 
				echo "<td>$RPM_NAME</td>" >> $HTML_REPORT
178 
			echo "<td>$RPM_DATE</td>" >> $HTML_REPORT
 177 
				echo "<td>$RPM_DATE</td>" >> $HTML_REPORT
179 
			echo "<td>$RPM_VERSION</td>" >> $HTML_REPORT
 178 
				echo "<td>$RPM_VERSION</td>" >> $HTML_REPORT
180 
			echo "</tr>" >> $HTML_REPORT
 179 
				echo "</tr>" >> $HTML_REPORT
181 
		done
 180 
			done
- 
 
 181 
		else
- 
 
 182 
			echo "<tr><td colspan=\"3\">Pas de RPM mis à jour cette semaine</td></tr>" >> $HTML_REPORT
- 
 
 183 
		fi
182 
	else
 184 
	else
183 
		echo "<tr><td colspan=\"3\">Pas de RPM mis à jour cette semaine</td></tr>" >> $HTML_REPORT
 185 
		echo $LINE_HTML >> $HTML_REPORT
184 
	fi
 186 
	fi
185 
else
 - 
 
186 
	echo $LINE_HTML >> $HTML_REPORT
 - 
 
187 
fi
 - 
 
188 
done
 187 
done
189 
 
 188 
 
190 
######################BL WEBSITE SINCE INSTALLATION######################
 189 
######################BL WEBSITE SINCE INSTALLATION######################
191 
echo "Create BL website since the installation of ALCASAR"
 190 
echo "Create BL website since the installation of ALCASAR"
192 
#find data
 191 
#find data
193 
 
 192 
 
194 
#decompress every logs
 193 
#decompress every logs
195 
if [ $(ls -1 /var/log/dnsmasq/dnsmasq-blacklist.log.*.gz 2>/dev/null | wc -l) -ge 1 ]
 194 
if [ "$(ls -1 /var/log/unbound/unbound-blacklist.log.*.gz 2>/dev/null | wc -l)" -ge 1 ]
196 
then
 195 
then
197 
	gunzip -d dnsmasq-blacklist.log.*.gz
 196 
	gunzip -d unbound-blacklist.log.*.gz
198 
fi
 197 
fi
199 
 
 198 
 
200 
#convert logs date in timestamp and find categories of blacklisted website
 199 
#convert logs date in timestamp and find categories of blacklisted website
- 
 
 200 
tmp_log=$(mktemp)
201 
for FILE in $(ls -1 /var/log/dnsmasq/ | grep 'dnsmasq-blacklist.log')
 201 
for FILE in /var/log/unbound/unbound-blacklist.log*
202 
do
 202 
do
- 
 
 203 
	grep -E "info: [^ ]+ typetransparent $PRIVATE_IP" /var/log/unbound/unbound-blacklist.log > $tmp_log
203 
	while read LOG_BL
 204 
	while read LOG_BL
204 
	do
 205 
	do
205 
		if [ $(echo $LOG_BL | grep config | grep $PRIVATE_IP | wc -c) -ge 1 ]
 - 
 
206 
		then
 - 
 
207 
			#find the current blacklisted category
 206 
		# find the current blacklisted category
208 
			website_bl=$(echo $LOG_BL | cut -d' ' -f6)
 207 
		website_bl=$(echo $LOG_BL | cut -d' ' -f4)
209
- 
 
210 
			#we convert www.test.co.uk => test.co.uk to find the category of this website
 - 
 
211 
			if [ $(grep -o '\.' <<< "$website_bl" | wc -l) -ge "2" ]
 - 
 
212 
			then
 - 
 
213 
					website_bl=$(echo $website_bl | cut -d'.' -f2-)
 208 
		website_bl=${website_bl%?} # remove the last character
214 
			fi
 - 
 
215 
 
 209 
 
216 
			#get BL category
 - 
 
217 
			categorie_bl=$(grep -R "$website_bl/" /usr/local/share/dnsmasq-bl-enabled/ | cut -d':' -f1 | cut -d'/' -f6 | cut -d' ' -f1)
 210 
		#we convert www.test.co.uk => test.co.uk to find the category of this website
218 
			if [ $(echo $categorie_bl | wc -w) -gt 1 ]
 211 
		if [ "$(grep -o '\.' <<< "$website_bl" | wc -l)" -ge "2" ]
219 
			then
 212 
		then
220 
				categorie_bl=$(grep -R "/$website_bl/" /usr/local/share/dnsmasq-bl-enabled/ | cut -d':' -f1 | cut -d'/' -f6 | cut -d' ' -f1 | head -1)
 - 
 
221 
			fi
 - 
 
222
- 
 
223 
			#Calculate its timestamp
 - 
 
224 
			Y=$(date -R | cut -d' ' -f4)
 - 
 
225 
			M=$(echo $LOG_BL | cut -d' ' -f1)
 - 
 
226 
			D=$(echo $LOG_BL | cut -d' ' -f2)
 213 
			website_bl=$(echo $website_bl | cut -d'.' -f2-)
227 
			H=$(echo $LOG_BL | cut -d' ' -f3)
 - 
 
228 
			CURRENT_TS=$(date -d "$M $D $Y $H" +"%s")
 - 
 
229 
			echo "$CURRENT_TS:$categorie_bl:" >> $TMP_BL
 - 
 
230 
		fi
 214 
		fi
- 
 
 215 
 
- 
 
 216 
		#get BL category
- 
 
 217 
		categorie_bl=$(grep -Rl "$website_bl" /usr/local/share/unbound-bl-enabled/ | cut -d'/' -f6 | head -1)
231
218 
 
- 
 
 219 
		CURRENT_TS=$(echo $LOG_BL | cut -d '[' -f2 | cut -d ']' -f1)
- 
 
 220 
		echo "$CURRENT_TS:$categorie_bl:" >> $TMP_BL
232 
	done < /var/log/dnsmasq/$FILE
 221 
	done < $tmp_log
233 
done
 222 
done
- 
 
 223 
rm $tmp_log
234 
 
 224 
 
235 
#if data exists, create this section in html document
 225 
#if data exists, create this section in html document
236 
if [ -e $TMP_BL ]
 226 
if [ -e $TMP_BL ]
237 
then
 227 
then
238 
	ENABLE_BL=1
 228 
	ENABLE_BL=1
239 
	#count every BL website consulted since installation (maximum 1 year)
 229 
	#count every BL website consulted since installation (maximum 1 year)
240 
	DATE_END=$(cat $TMP_BL | cut -d':' -f1 | sort -n | head -1 )
 230 
	DATE_END=$(cat $TMP_BL | cut -d':' -f1 | sort -n | head -1 )
241 
 
 231 
 
242 
 
 232 
 
243 
	for TS in $(seq $C_TS -$STEP_TS $DATE_END)
 233 
	for TS in $(seq $C_TS -$STEP_TS $DATE_END)
244 
	do
 234 
	do
245 
		DATE_1=$TS
 235 
		DATE_1=$TS
246 
		DATE_2=$((TS-$STEP_TS))
 236 
		DATE_2=$((TS-$STEP_TS))
247 
		COUNT_BL_INSTALLATION=0
237 
		COUNT_BL_INSTALLATION=0
248
238 
 
249 
		for LINE in $(cat $TMP_BL)
 239 
		for LINE in $(cat $TMP_BL)
250 
		do
 240 
		do
251 
			TS_FILE=$(echo $LINE | cut -d':' -f1)
 241 
			TS_FILE=$(echo $LINE | cut -d':' -f1)
252
242 
 
253 
			if [ "$TS_FILE" -le "$DATE_1" -a "$TS_FILE" -ge "$DATE_2" ]
 243 
			if [ "$TS_FILE" -le "$DATE_1" ] && [ "$TS_FILE" -ge "$DATE_2" ]
254 
			then
 244 
			then
255 
				COUNT_BL_INSTALLATION=$((COUNT_BL_INSTALLATION+1))
 245 
				COUNT_BL_INSTALLATION=$((COUNT_BL_INSTALLATION+1))
256 
 
 - 
 
257 
			fi
 246 
			fi
258 
		done
 247 
		done
259
248 
 
260 
		VALUE_BL_INSTALLATION_LABEL="'$(date -d @$DATE_2 "+%Y-%m-%d" )', $VALUE_BL_INSTALLATION_LABEL"
 249 
		VALUE_BL_INSTALLATION_LABEL="'$(date -d @$DATE_2 "+%Y-%m-%d" )', $VALUE_BL_INSTALLATION_LABEL"
261 
		VALUE_BL_INSTALLATION_DATA="$COUNT_BL_INSTALLATION, $VALUE_BL_INSTALLATION_DATA"
 250 
		VALUE_BL_INSTALLATION_DATA="$COUNT_BL_INSTALLATION, $VALUE_BL_INSTALLATION_DATA"
262 
	done
 251 
	done
263 
 
 252 
 
264 
	#create Antivirus section in html document
 253 
	#create Antivirus section in html document
265 
	NAME_BL_INSTALLATION='chart_bl_installation'
 254 
	NAME_BL_INSTALLATION='chart_bl_installation'
266 
	CONF_BL_INSTALLATION='config_bl_installation'
 255 
	CONF_BL_INSTALLATION='config_bl_installation'
267 
	echo "<center>" >> $HTML_REPORT
 256 
	echo "<center>" >> $HTML_REPORT
268 
	echo "<canvas id='$NAME_BL_INSTALLATION' width='450' height='450'></canvas>" >> $HTML_REPORT
 257 
	echo "<canvas id='$NAME_BL_INSTALLATION' width='450' height='450'></canvas>" >> $HTML_REPORT
269 
	echo "</center>" >> $HTML_REPORT
 258 
	echo "</center>" >> $HTML_REPORT
270 
 
 259 
 
271 
	#create chart bar in html file with javascript (chartjs.com)
 260 
	#create chart bar in html file with javascript (chartjs.com)
272 
	echo "<script>" >> $HTML_REPORT
 261 
	echo "<script>" >> $HTML_REPORT
273 
	cat $MODEL_CHARTJS | while read LINE_JS
 262 
	cat $MODEL_CHARTJS | while read LINE_JS
274 
	do
 263 
	do
275 
		#name of variable
 264 
		#name of variable
276 
		if [ $(echo $LINE_JS | grep 'XXCONFXX' | wc -l) -eq 1 ]
 265 
		if [ "$(echo $LINE_JS | grep 'XXCONFXX' | wc -l)" -eq 1 ]
277 
		then
 266 
		then
278 
			echo ${LINE_JS/XXCONFXX/$CONF_BL_INSTALLATION} >> $HTML_REPORT
 267 
			echo ${LINE_JS/XXCONFXX/$CONF_BL_INSTALLATION} >> $HTML_REPORT
279 
		#chart type
 268 
		#chart type
280 
		elif [ $(echo $LINE_JS | grep 'XXTYPEXX' | wc -l) -eq 1 ]
 269 
		elif [ "$(echo $LINE_JS | grep 'XXTYPEXX' | wc -l)" -eq 1 ]
281 
		then
 270 
		then
282 
			echo ${LINE_JS/XXTYPEXX/bar} >> $HTML_REPORT
 271 
			echo ${LINE_JS/XXTYPEXX/bar} >> $HTML_REPORT
283 
		#chart title
 272 
		#chart title
284 
		elif [ $(echo $LINE_JS | grep 'XXTITLEXX' | wc -l) -eq 1 ]
 273 
		elif [ "$(echo $LINE_JS | grep 'XXTITLEXX' | wc -l)" -eq 1 ]
285 
		then
 274 
		then
286 
			echo ${LINE_JS/XXTITLEXX/"Sites bloqués au total"} >> $HTML_REPORT
 275 
			echo ${LINE_JS/XXTITLEXX/"Sites bloqués au total"} >> $HTML_REPORT
287 
		#chart data
 276 
		#chart data
288 
		elif [ $(echo $LINE_JS | grep 'XXDATAXX' | wc -l) -eq 1 ]
 277 
		elif [ "$(echo $LINE_JS | grep 'XXDATAXX' | wc -l)" -eq 1 ]
289 
		then
 278 
		then
290 
			echo ${LINE_JS/XXDATAXX/$VALUE_BL_INSTALLATION_DATA} >> $HTML_REPORT
 279 
			echo ${LINE_JS/XXDATAXX/$VALUE_BL_INSTALLATION_DATA} >> $HTML_REPORT
291 
		#color
 280 
		#color
292 
		elif [ $(echo $LINE_JS | grep 'XXCOLORXX' | wc -l) -eq 1 ]
 281 
		elif [ "$(echo $LINE_JS | grep 'XXCOLORXX' | wc -l)" -eq 1 ]
293 
		then
 282 
		then
294 
			echo ${LINE_JS/XXCOLORXX/$COLOR} >> $HTML_REPORT
 283 
			echo ${LINE_JS/XXCOLORXX/$COLOR} >> $HTML_REPORT
295 
		#labels
 284 
		#labels
296 
		elif [ $(echo $LINE_JS | grep 'XXLABELSXX' | wc -l) -eq 1 ]
 285 
		elif [ "$(echo $LINE_JS | grep 'XXLABELSXX' | wc -l)" -eq 1 ]
297 
		then
 286 
		then
298 
			echo ${LINE_JS/XXLABELSXX/$VALUE_BL_INSTALLATION_LABEL} >> $HTML_REPORT
 287 
			echo ${LINE_JS/XXLABELSXX/$VALUE_BL_INSTALLATION_LABEL} >> $HTML_REPORT
299 
		elif [ $(echo $LINE_JS | grep 'XXLEGENDXX' | wc -l) -eq 1 ]
 288 
		elif [ "$(echo $LINE_JS | grep 'XXLEGENDXX' | wc -l)" -eq 1 ]
300 
		then
 289 
		then
301 
			echo ${LINE_JS/XXLEGENDXX/false} >> $HTML_REPORT
 290 
			echo ${LINE_JS/XXLEGENDXX/false} >> $HTML_REPORT
302 
		#display value of Y axis, only useful for chart bar
 291 
		#display value of Y axis, only useful for chart bar
303 
		elif [ $(echo $LINE_JS | grep 'XXCOMMENT-BEGINXX' | wc -l) -eq 1 ]
 292 
		elif [ "$(echo $LINE_JS | grep 'XXCOMMENT-BEGINXX' | wc -l)" -eq 1 ]
304 
		then
 293 
		then
305 
			echo "" >> $HTML_REPORT
 294 
			echo "" >> $HTML_REPORT
306 
		#display value of Y axis, only useful for chart bar
 295 
		#display value of Y axis, only useful for chart bar
307 
		elif [ $(echo $LINE_JS | grep 'XXCOMMENT-ENDXX' | wc -l) -eq 1 ]
 296 
		elif [ "$(echo $LINE_JS | grep 'XXCOMMENT-ENDXX' | wc -l)" -eq 1 ]
308 
		then
 297 
		then
309 
			echo "" >> $HTML_REPORT
 298 
			echo "" >> $HTML_REPORT
310 
		elif [ $(echo $LINE_JS | grep 'XXYLABELXX' | wc -l) -eq 1 ]
 299 
		elif [ "$(echo $LINE_JS | grep 'XXYLABELXX' | wc -l)" -eq 1 ]
311 
		then
 300 
		then
312 
			echo "\"Nombre de site bloqué par la blacklist\"" >> $HTML_REPORT
 301 
			echo "\"Nombre de site bloqué par la blacklist\"" >> $HTML_REPORT
313 
		else
 302 
		else
314 
			echo $LINE_JS >> $HTML_REPORT
 303 
			echo $LINE_JS >> $HTML_REPORT
315 
		fi
 304 
		fi
316 
	done
 305 
	done
317 
	echo "</script>" >> $HTML_REPORT
 306 
	echo "</script>" >> $HTML_REPORT
318 
else
 307 
else
319 
	echo "<h2>Aucune activité de la Blacklist depuis l'installation.</h2>" >> $HTML_REPORT
 308 
	echo "<h2>Aucune activité de la Blacklist depuis l'installation.</h2>" >> $HTML_REPORT
320 
fi
 309 
fi
321 
 
 310 
 
322 
 
 311 
 
323 
 
 312 
 
324 
######################DNSMASQ BLACKLIST######################
 313 
######################Unbound BLACKLIST######################
325 
echo "Create BL website since $MAX_DAY_AGO days"
 314 
echo "Create BL website since $MAX_DAY_AGO days"
326 
 
 315 
 
327 
#if data exists, create BL section in html document
 316 
#if data exists, create BL section in html document
328 
if [ -e $TMP_BL ]
 317 
if [ -e $TMP_BL ]
329 
then
 318 
then
330 
	ENABLE_BL_WEEK=1
 319 
	ENABLE_BL_WEEK=1
331 
	#find data
 320 
	#find data
332 
	#count every BL website consulted since DAYS_AGO
 321 
	#count every BL website consulted since DAYS_AGO
333 
	DATE_1=$C_TS
 322 
	DATE_1=$C_TS
334 
	DATE_2=$((DATE_1-$STEP_TS))
 323 
	DATE_2=$((DATE_1-$STEP_TS))
335 
 
 324 
 
336 
	touch $TMP_BL_WEEK
 325 
	touch $TMP_BL_WEEK
337 
 
 326 
 
338 
	for LINE in $(cat $TMP_BL)
 327 
	for LINE in $(cat $TMP_BL)
339 
	do
 328 
	do
340 
		TS_FILE=$(echo $LINE | cut -d':' -f1)
 329 
		TS_FILE=$(echo $LINE | cut -d':' -f1)
341 
		#select only elements between DATE_1 and DATE_2
 330 
		#select only elements between DATE_1 and DATE_2
342 
		if [ "$TS_FILE" -le "$DATE_1" -a "$TS_FILE" -ge "$DATE_2" ]
 331 
		if [ "$TS_FILE" -le "$DATE_1" ] && [ "$TS_FILE" -ge "$DATE_2" ]
343 
		then
 332 
		then
344 
			echo $LINE >> $TMP_BL_WEEK
 333 
			echo $LINE >> $TMP_BL_WEEK
345 
		fi
 334 
		fi
346 
	done
 335 
	done
347 
 
 336 
 
348 
	#then we count every occurence for each category in TMP_BL_WEEK
 337 
	#then we count every occurence for each category in TMP_BL_WEEK
349 
	for CAT in $(ls /usr/local/share/dnsmasq-bl/ -1 | cut -d'.' -f1)
 338 
	for CAT in $(ls /usr/local/share/unbound-bl/ -1 | cut -d'.' -f1)
350 
	do
 339 
	do
351 
		echo "$CAT:$(grep -o ":$CAT:" <<< "$(cat $TMP_BL_WEEK)" | wc -l):" >> $TMP_BL_WEEK_CAT
 340 
		echo "$CAT:$(grep -o ":$CAT:" <<< "$(cat $TMP_BL_WEEK)" | wc -l):" >> $TMP_BL_WEEK_CAT
352 
	done
 341 
	done
353 
 
 342 
 
354 
	#we sort by number of occurence and we take the top 10 BL categories
 343 
	#we sort by number of occurence and we take the top 10 BL categories
355 
	for LINE in $(sort -t':' -k2 -rn $TMP_BL_WEEK_CAT | head -n 10)
 344 
	for LINE in $(sort -t':' -k2 -rn $TMP_BL_WEEK_CAT | head -n 10)
356 
	do
 345 
	do
357
346 
 
358 
		DATA=$(echo $LINE | cut -d':' -f2)
 347 
		DATA=$(echo $LINE | cut -d':' -f2)
359 
		LABEL=$(echo $LINE | cut -d':' -f1)
 348 
		LABEL=$(echo $LINE | cut -d':' -f1)
360 
		if [ $DATA -ne 0 ]
 349 
		if [ $DATA -ne 0 ]
361 
		then
 350 
		then
362 
			VALUE_BL_DATA="$VALUE_BL_DATA $DATA, "
 351 
			VALUE_BL_DATA="$VALUE_BL_DATA $DATA, "
363 
			VALUE_BL_LABEL="$VALUE_BL_LABEL '$LABEL ($DATA)',"
 352 
			VALUE_BL_LABEL="$VALUE_BL_LABEL '$LABEL ($DATA)',"
364 
		fi
 353 
		fi
365 
	done
 354 
	done
366 
 
 355 
 
367 
	#get other categories (sum them all)
 356 
	#get other categories (sum them all)
368 
	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 ]
 357 
	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 ]
369 
	then
 358 
	then
370 
		VALUE_BL_DATA="$VALUE_BL_DATA $(cat $TMP_BL_WEEK_CAT | cut -d':' -f2 | sort -k1 -rn | tail -n+$(($(echo $VALUE_BL_DATA | wc -w)+1)) | paste -sd+ | bc)"
 359 
		VALUE_BL_DATA="$VALUE_BL_DATA $(cat $TMP_BL_WEEK_CAT | cut -d':' -f2 | sort -k1 -rn | tail -n+$(($(echo $VALUE_BL_DATA | wc -w)+1)) | paste -sd+ | bc)"
371 
		VALUE_BL_LABEL="$VALUE_BL_LABEL 'autre ($(cat $TMP_BL_WEEK_CAT | cut -d':' -f2 | sort -k1 -rn | tail -n+$(($(echo $VALUE_BL_DATA | wc -w)+1)) | paste -sd+ | bc))'"
 360 
		VALUE_BL_LABEL="$VALUE_BL_LABEL 'autre ($(cat $TMP_BL_WEEK_CAT | cut -d':' -f2 | sort -k1 -rn | tail -n+$(($(echo $VALUE_BL_DATA | wc -w)+1)) | paste -sd+ | bc))'"
372 
	fi
 361 
	fi
373 
 
 362 
 
374 
	#create chart pie in html file with javascript (chartjs.com)
 363 
	#create chart pie in html file with javascript (chartjs.com)
375 
	NAME_BL='chart_bl'
 364 
	NAME_BL='chart_bl'
376 
	CONF_BL='config_bl'
 365 
	CONF_BL='config_bl'
377 
	echo "<center>" >> $HTML_REPORT
 366 
	echo "<center>" >> $HTML_REPORT
378 
	echo "<canvas id='$NAME_BL' width='450' height='450' ></canvas>" >> $HTML_REPORT
 367 
	echo "<canvas id='$NAME_BL' width='450' height='450' ></canvas>" >> $HTML_REPORT
379 
	echo "</center>" >> $HTML_REPORT
 368 
	echo "</center>" >> $HTML_REPORT
380 
	echo "<script>" >> $HTML_REPORT
 369 
	echo "<script>" >> $HTML_REPORT
381 
 
 370 
 
382 
	cat $MODEL_CHARTJS | while read LINE_JS
 371 
	cat $MODEL_CHARTJS | while read LINE_JS
383 
	do
 372 
	do
384 
		#variable name
 373 
		#variable name
385 
		if [ $(echo $LINE_JS | grep 'XXCONFXX' | wc -l) -eq 1 ]
 374 
		if [ "$(echo $LINE_JS | grep 'XXCONFXX' | wc -l)" -eq 1 ]
386 
		then
 375 
		then
387 
			echo ${LINE_JS/XXCONFXX/$CONF_BL} >> $HTML_REPORT
 376 
			echo ${LINE_JS/XXCONFXX/$CONF_BL} >> $HTML_REPORT
388 
		#chart type
 377 
		#chart type
389 
		elif [ $(echo $LINE_JS | grep 'XXTYPEXX' | wc -l) -eq 1 ]
 378 
		elif [ "$(echo $LINE_JS | grep 'XXTYPEXX' | wc -l)" -eq 1 ]
390 
		then
 379 
		then
391 
			echo ${LINE_JS/XXTYPEXX/pie} >> $HTML_REPORT
 380 
			echo ${LINE_JS/XXTYPEXX/pie} >> $HTML_REPORT
392 
		#graph title
 381 
		#graph title
393 
		elif [ $(echo $LINE_JS | grep 'XXTITLEXX' | wc -l) -eq 1 ]
 382 
		elif [ "$(echo $LINE_JS | grep 'XXTITLEXX' | wc -l)" -eq 1 ]
394 
		then
 383 
		then
395 
			echo ${LINE_JS/XXTITLEXX/"Sites bloqués cette semaine"} >> $HTML_REPORT
 384 
			echo ${LINE_JS/XXTITLEXX/"Sites bloqués cette semaine"} >> $HTML_REPORT
396 
		#chart data
 385 
		#chart data
397 
		elif [ $(echo $LINE_JS | grep 'XXDATAXX' | wc -l) -eq 1 ]
 386 
		elif [ "$(echo $LINE_JS | grep 'XXDATAXX' | wc -l)" -eq 1 ]
398 
		then
 387 
		then
399 
			echo ${LINE_JS/XXDATAXX/$VALUE_BL_DATA} >> $HTML_REPORT
 388 
			echo ${LINE_JS/XXDATAXX/$VALUE_BL_DATA} >> $HTML_REPORT
400 
		#color
 389 
		#color
401 
		elif [ $(echo $LINE_JS | grep 'XXCOLORXX' | wc -l) -eq 1 ]
 390 
		elif [ "$(echo $LINE_JS | grep 'XXCOLORXX' | wc -l)" -eq 1 ]
402 
		then
 391 
		then
403 
			echo ${LINE_JS/XXCOLORXX/$COLOR} >> $HTML_REPORT
 392 
			echo ${LINE_JS/XXCOLORXX/$COLOR} >> $HTML_REPORT
404 
		#labels
 393 
		#labels
405 
		elif [ $(echo $LINE_JS | grep 'XXLABELSXX' | wc -l) -eq 1 ]
 394 
		elif [ "$(echo $LINE_JS | grep 'XXLABELSXX' | wc -l)" -eq 1 ]
406 
		then
 395 
		then
407 
			echo ${LINE_JS/XXLABELSXX/$VALUE_BL_LABEL} >> $HTML_REPORT
 396 
			echo ${LINE_JS/XXLABELSXX/$VALUE_BL_LABEL} >> $HTML_REPORT
408 
		#display legend, only useful for chart pie
 397 
		#display legend, only useful for chart pie
409 
		elif [ $(echo $LINE_JS | grep 'XXLEGENDXX' | wc -l) -eq 1 ]
 398 
		elif [ "$(echo $LINE_JS | grep 'XXLEGENDXX' | wc -l)" -eq 1 ]
410 
		then
 399 
		then
411 
			echo ${LINE_JS/XXLEGENDXX/true} >> $HTML_REPORT
 400 
			echo ${LINE_JS/XXLEGENDXX/true} >> $HTML_REPORT
412 
		#display value of Y axis, only useful for chart bar
 401 
		#display value of Y axis, only useful for chart bar
413 
		elif [ $(echo $LINE_JS | grep 'XXCOMMENT-BEGINXX' | wc -l) -eq 1 ]
 402 
		elif [ "$(echo $LINE_JS | grep 'XXCOMMENT-BEGINXX' | wc -l)" -eq 1 ]
414 
		then
 403 
		then
415 
			echo "/*" >> $HTML_REPORT
 404 
			echo "/*" >> $HTML_REPORT
416 
		#display value of Y axis, only useful for chart bar
 405 
		#display value of Y axis, only useful for chart bar
417 
		elif [ $(echo $LINE_JS | grep 'XXCOMMENT-ENDXX' | wc -l) -eq 1 ]
 406 
		elif [ "$(echo $LINE_JS | grep 'XXCOMMENT-ENDXX' | wc -l)" -eq 1 ]
418 
		then
 407 
		then
419 
			echo "*/" >> $HTML_REPORT
 408 
			echo "*/" >> $HTML_REPORT
420 
		else
 409 
		else
421 
			echo $LINE_JS >> $HTML_REPORT
 410 
			echo $LINE_JS >> $HTML_REPORT
422 
		fi
 411 
		fi
423 
	done
 412 
	done
424 
	echo "</script>" >> $HTML_REPORT
 413 
	echo "</script>" >> $HTML_REPORT
425 
else
 414 
else
426 
	echo "<h2>Aucune activité de la Blacklist cette semaine.</h2>" >> $HTML_REPORT
 415 
	echo "<h2>Aucune activité de la Blacklist cette semaine.</h2>" >> $HTML_REPORT
427 
fi
 416 
fi
428 
 
 417 
 
429 
######################VIRUS THREAT######################
 418 
######################VIRUS THREAT######################
430 
echo "Create AV logs since the installation of ALCASAR"
 419 
echo "Create AV logs since the installation of ALCASAR"
431 
 
 420 
 
432 
#decompress every logs, if they exist
 421 
#decompress every logs, if they exist
433 
if [ $(ls -1 /var/log/havp/access.log.*.gz 2>/dev/null | wc -l) -ge 1 ]
 422 
if [ "$(ls -1 /var/log/havp/access.log.*.gz 2>/dev/null | wc -l)" -ge 1 ]
434 
then
 423 
then
435 
	gunzip -d access.log.*.gz
 424 
	gunzip -d access.log.*.gz
436 
fi
 425 
fi
437 
 
 426 
 
438 
for FILE in $(ls -1 /var/log/havp/ | grep 'access.log')
 427 
for FILE in /var/log/havp/access.log*
439 
do
 428 
do
440 
	while read LINE_AV
 429 
	while read LINE_AV
441 
	do
 430 
	do
442 
		Y=$(echo $LINE_AV | cut -d' ' -f1)
 431 
		Y=$(echo $LINE_AV | cut -d' ' -f1)
443 
		M=$(echo $LINE_AV | cut -d' ' -f2)
 432 
		M=$(echo $LINE_AV | cut -d' ' -f2)
444 
		D=$(echo $LINE_AV | cut -d' ' -f3)
 433 
		D=$(echo $LINE_AV | cut -d' ' -f3)
445 
		H=$(echo $LINE_AV | cut -d' ' -f4)
 434 
		H=$(echo $LINE_AV | cut -d' ' -f4)
446 
		CURRENT_TS=$(date -d "$M $D $Y $H" +"%s")
 435 
		CURRENT_TS=$(date -d "$M $D $Y $H" +"%s")
447 
		echo $CURRENT_TS >> $TMP_AV
 436 
		echo $CURRENT_TS >> $TMP_AV
448 
	done < /var/log/havp/$FILE
 437 
	done < $FILE
449
- 
 
450 
done
 438 
done
451 
 
 439 
 
452 
if [ -e $TMP_AV ]
 440 
if [ -e $TMP_AV ]
453 
then
 441 
then
454 
	ENABLE_AV=1
 442 
	ENABLE_AV=1
455 
	DATE_END=$(cat $TMP_AV | sort -n | head -1)
 443 
	DATE_END=$(cat $TMP_AV | sort -n | head -1)
456 
	for TS in $(seq $C_TS -$STEP_TS $DATE_END)
 444 
	for TS in $(seq $C_TS -$STEP_TS $DATE_END)
457 
	do
 445 
	do
458 
		DATE_1=$TS
 446 
		DATE_1=$TS
459 
		DATE_2=$((TS-$STEP_TS))
 447 
		DATE_2=$((TS-$STEP_TS))
460 
		COUNT_AV=0
 448 
		COUNT_AV=0
461 
 
 449 
 
462 
		for TS_FILE in $(cat $TMP_AV)
 450 
		for TS_FILE in $(cat $TMP_AV)
463 
		do
 451 
		do
464 
			if [ "$TS_FILE" -le "$DATE_1" -a "$TS_FILE" -ge "$DATE_2" ]
 452 
			if [ "$TS_FILE" -le "$DATE_1" ] && [ "$TS_FILE" -ge "$DATE_2" ]
465 
			then
 453 
			then
466 
				COUNT_AV=$((COUNT_AV+1))
 454 
				COUNT_AV=$((COUNT_AV+1))
467 
			fi
 455 
			fi
468 
		done
 456 
		done
469 
 
 457 
 
470 
		VALUE_AV_LABEL="'$(date -d @$DATE_2 "+%Y-%m-%d" )', $VALUE_AV_LABEL"
 458 
		VALUE_AV_LABEL="'$(date -d @$DATE_2 "+%Y-%m-%d" )', $VALUE_AV_LABEL"
471 
		VALUE_AV_DATA="$COUNT_AV, $VALUE_AV_DATA"
 459 
		VALUE_AV_DATA="$COUNT_AV, $VALUE_AV_DATA"
472 
	done
 460 
	done
473
461 
 
474 
	#create Antivirus section in html document
 462 
	#create Antivirus section in html document
475 
	NAME_AV='chart_av'
 463 
	NAME_AV='chart_av'
476 
	CONF_AV='config_av'
 464 
	CONF_AV='config_av'
477 
	echo "<center>" >> $HTML_REPORT
 465 
	echo "<center>" >> $HTML_REPORT
478 
	echo "<canvas id='$NAME_AV' width='450' height='450' ></canvas>" >> $HTML_REPORT
 466 
	echo "<canvas id='$NAME_AV' width='450' height='450' ></canvas>" >> $HTML_REPORT
479 
	echo "</center>" >> $HTML_REPORT
 467 
	echo "</center>" >> $HTML_REPORT
480 
 
 468 
 
481 
 
 469 
 
482 
	#create chart bar in html file with javascript (chartjs.com)
 470 
	#create chart bar in html file with javascript (chartjs.com)
483 
	echo "<script>" >> $HTML_REPORT
 471 
	echo "<script>" >> $HTML_REPORT
484 
	cat $MODEL_CHARTJS | while read LINE_JS
 472 
	cat $MODEL_CHARTJS | while read LINE_JS
485 
	do
 473 
	do
486 
		#name of variable
 474 
		#name of variable
487 
		if [ $(echo $LINE_JS | grep 'XXCONFXX' | wc -l) -eq 1 ]
 475 
		if [ "$(echo $LINE_JS | grep 'XXCONFXX' | wc -l)" -eq 1 ]
488 
		then
 476 
		then
489 
			echo ${LINE_JS/XXCONFXX/$CONF_AV} >> $HTML_REPORT
 477 
			echo ${LINE_JS/XXCONFXX/$CONF_AV} >> $HTML_REPORT
490 
		#chart type
 478 
		#chart type
491 
		elif [ $(echo $LINE_JS | grep 'XXTYPEXX' | wc -l) -eq 1 ]
 479 
		elif [ "$(echo $LINE_JS | grep 'XXTYPEXX' | wc -l)" -eq 1 ]
492 
		then
 480 
		then
493 
			echo ${LINE_JS/XXTYPEXX/bar} >> $HTML_REPORT
 481 
			echo ${LINE_JS/XXTYPEXX/bar} >> $HTML_REPORT
494 
		#graph title
 482 
		#graph title
495 
		elif [ $(echo $LINE_JS | grep 'XXTITLEXX' | wc -l) -eq 1 ]
 483 
		elif [ "$(echo $LINE_JS | grep 'XXTITLEXX' | wc -l)" -eq 1 ]
496 
		then
 484 
		then
497 
			echo ${LINE_JS/XXTITLEXX/"Menaces bloqués par l\'antivirus"} >> $HTML_REPORT
 485 
			echo ${LINE_JS/XXTITLEXX/"Menaces bloqués par l\'antivirus"} >> $HTML_REPORT
498 
		#chart data
 486 
		#chart data
499 
		elif [ $(echo $LINE_JS | grep 'XXDATAXX' | wc -l) -eq 1 ]
 487 
		elif [ "$(echo $LINE_JS | grep 'XXDATAXX' | wc -l)" -eq 1 ]
500 
		then
 488 
		then
501 
			echo ${LINE_JS/XXDATAXX/$VALUE_AV_DATA} >> $HTML_REPORT
 489 
			echo ${LINE_JS/XXDATAXX/$VALUE_AV_DATA} >> $HTML_REPORT
502 
		#color
 490 
		#color
503 
		elif [ $(echo $LINE_JS | grep 'XXCOLORXX' | wc -l) -eq 1 ]
 491 
		elif [ "$(echo $LINE_JS | grep 'XXCOLORXX' | wc -l)" -eq 1 ]
504 
		then
 492 
		then
505 
			echo ${LINE_JS/XXCOLORXX/$COLOR} >> $HTML_REPORT
 493 
			echo ${LINE_JS/XXCOLORXX/$COLOR} >> $HTML_REPORT
506 
		#labels
 494 
		#labels
507 
		elif [ $(echo $LINE_JS | grep 'XXLABELSXX' | wc -l) -eq 1 ]
 495 
		elif [ "$(echo $LINE_JS | grep 'XXLABELSXX' | wc -l)" -eq 1 ]
508 
		then
 496 
		then
509 
			echo ${LINE_JS/XXLABELSXX/$VALUE_AV_LABEL} >> $HTML_REPORT
 497 
			echo ${LINE_JS/XXLABELSXX/$VALUE_AV_LABEL} >> $HTML_REPORT
510 
		elif [ $(echo $LINE_JS | grep 'XXLEGENDXX' | wc -l) -eq 1 ]
 498 
		elif [ "$(echo $LINE_JS | grep 'XXLEGENDXX' | wc -l)" -eq 1 ]
511 
		then
 499 
		then
512 
			echo ${LINE_JS/XXLEGENDXX/false} >> $HTML_REPORT
 500 
			echo ${LINE_JS/XXLEGENDXX/false} >> $HTML_REPORT
513 
		#display value of Y axis, only useful for chart bar
 501 
		#display value of Y axis, only useful for chart bar
514 
		elif [ $(echo $LINE_JS | grep 'XXCOMMENT-BEGINXX' | wc -l) -eq 1 ]
 502 
		elif [ "$(echo $LINE_JS | grep 'XXCOMMENT-BEGINXX' | wc -l)" -eq 1 ]
515 
		then
 503 
		then
516 
			echo "" >> $HTML_REPORT
 504 
			echo "" >> $HTML_REPORT
517 
		#display value of Y axis, only useful for chart bar
 505 
		#display value of Y axis, only useful for chart bar
518 
		elif [ $(echo $LINE_JS | grep 'XXCOMMENT-ENDXX' | wc -l) -eq 1 ]
 506 
		elif [ "$(echo $LINE_JS | grep 'XXCOMMENT-ENDXX' | wc -l)" -eq 1 ]
519 
		then
 507 
		then
520 
			echo "" >> $HTML_REPORT
 508 
			echo "" >> $HTML_REPORT
521 
		elif [ $(echo $LINE_JS | grep 'XXYLABELXX' | wc -l) -eq 1 ]
 509 
		elif [ "$(echo $LINE_JS | grep 'XXYLABELXX' | wc -l)" -eq 1 ]
522 
		then
 510 
		then
523 
			echo "\"Nombre de menaces virales bloqués par l'antivirus\"" >> $HTML_REPORT
 511 
			echo "\"Nombre de menaces virales bloqués par l'antivirus\"" >> $HTML_REPORT
524 
		else
 512 
		else
525 
			echo $LINE_JS >> $HTML_REPORT
 513 
			echo $LINE_JS >> $HTML_REPORT
526 
		fi
 514 
		fi
527 
	done
 515 
	done
528 
	echo "</script>" >> $HTML_REPORT
 516 
	echo "</script>" >> $HTML_REPORT
529 
else
 517 
else
530 
	echo "<h2>Aucune menace virale.</h2>" >> $HTML_REPORT
 518 
	echo "<h2>Aucune menace virale.</h2>" >> $HTML_REPORT
531 
fi
 519 
fi
532 
 
 520 
 
533 
 
 521 
 
534 
######################ALCASAR : DAILY USE######################
 522 
######################ALCASAR : DAILY USE######################
535 
echo "Get daily use connection of the week"
 523 
echo "Get daily use connection of the week"
536 
#create html document
 524 
#create html document
537 
echo "<h2>Statistiques volumétrie connexions</h2>" >> $HTML_REPORT
 525 
echo "<h2>Statistiques volumétrie connexions</h2>" >> $HTML_REPORT
538 
 
 526 
 
539 
#create new htdigest user to consult statistique of ACC
 527 
#create new htdigest user to consult statistique of ACC
540 
#if user does not exist, we create him
 528 
#if user does not exist, we create him
541 
if [ $(grep "$tmp_account:" $DIR_KEY/key_only_manager | wc -l) -lt 1 ]
 529 
if [ "$(grep "$tmp_account:" $DIR_KEY/key_only_manager | wc -l)" -lt 1 ]
542 
then
 530 
then
543 
	(echo -n "$tmp_account:$realm:" && echo -n "$tmp_account:$realm:$password" | md5sum | awk '{print $1}' ) >> $DIR_KEY/key_only_manager
 531 
	(echo -n "$tmp_account:$realm:" && echo -n "$tmp_account:$realm:$password" | md5sum | awk '{print $1}' ) >> $DIR_KEY/key_only_manager
544 
	(echo -n "$tmp_account:$realm:" && echo -n "$tmp_account:$realm:$password" | md5sum | awk '{print $1}' ) >> $DIR_KEY/key_manager
 532 
	(echo -n "$tmp_account:$realm:" && echo -n "$tmp_account:$realm:$password" | md5sum | awk '{print $1}' ) >> $DIR_KEY/key_manager
545 
	(echo -n "$tmp_account:$realm:" && echo -n "$tmp_account:$realm:$password" | md5sum | awk '{print $1}' ) >> $DIR_KEY/key_all
 533 
	(echo -n "$tmp_account:$realm:" && echo -n "$tmp_account:$realm:$password" | md5sum | awk '{print $1}' ) >> $DIR_KEY/key_all
546 
	chown -R root:apache $DIR_KEY
 534 
	chown -R root:apache $DIR_KEY
547 
	chmod 640 $DIR_KEY/key_*
 535 
	chmod 640 $DIR_KEY/key_*
548 
fi
 536 
fi
549 
 
 537 
 
550 
#get stats.php from ACC
 538 
#get stats.php from ACC
551 
wget -q -nv --user $tmp_account --password $password https://alcasar/acc/manager/htdocs/stats.php -O $TMP_STATS --no-check-certificate
 539 
wget -q -nv --user $tmp_account --password $password https://alcasar/acc/manager/htdocs/stats.php -O $TMP_STATS --no-check-certificate
552 
 
 540 
 
553 
#clean this file to include it in html report.
 541 
#clean this file to include it in html report.
554 
DELIM_1="<td colspan=10 height=20><img src=\"images\/pixel.gif\"><\/td>"
 542 
DELIM_1="<td colspan=10 height=20><img src=\"images\/pixel.gif\"><\/td>"
555 
DELIM_2="<\/td><\/tr> <\/table> <\/td><\/tr> <\/table> <\/td><\/tr> <\/table> <p>"
 543 
DELIM_2="<\/td><\/tr> <\/table> <\/td><\/tr> <\/table> <\/td><\/tr> <\/table> <p>"
556 
cat $TMP_STATS | sed -n "/$DELIM_1/,/$DELIM_2/p" | tail -n+3 | head -n-2 >> $TMP_STATS_2
 544 
cat $TMP_STATS | sed -n "/$DELIM_1/,/$DELIM_2/p" | tail -n+3 | head -n-2 >> $TMP_STATS_2
557 
cat $TMP_STATS_2 | sed -e 's:images/pixel.gif:../../manager/htdocs/images/pixel.gif:g' >> $HTML_REPORT
 545 
cat $TMP_STATS_2 | sed -e 's:images/pixel.gif:../../manager/htdocs/images/pixel.gif:g' >> $HTML_REPORT
558 
 
 546 
 
559 
#we delete our user if he still exists
 547 
#we delete our user if he still exists
560 
if [ $(grep "$tmp_account:" $DIR_KEY/key_only_manager | wc -l) -ge 1 ]
 548 
if [ "$(grep "$tmp_account:" $DIR_KEY/key_only_manager | wc -l)" -ge 1 ]
561 
then
 549 
then
562 
	$SED "/^$tmp_account:/d" $DIR_KEY/key_only_manager
 550 
	$SED "/^$tmp_account:/d" $DIR_KEY/key_only_manager
563 
	$SED "/^$tmp_account:/d" $DIR_KEY/key_manager
 551 
	$SED "/^$tmp_account:/d" $DIR_KEY/key_manager
564 
	$SED "/^$tmp_account:/d" $DIR_KEY/key_all
 552 
	$SED "/^$tmp_account:/d" $DIR_KEY/key_all
565 
fi
 553 
fi
566 
 
 554 
 
567 
 
 555 
 
568 
###################### ALCASAR : LOG ACCESS ######################
 556 
###################### ALCASAR : LOG ACCESS ######################
569 
echo "Get ACC log access of the week"
 557 
echo "Get ACC log access of the week"
570 
 
 558 
 
571 
ROWS=""
 559 
ROWS=""
572 
while read -r access ; do
 560 
while read -r access ; do
573 
	access_datas=(${access//|/ })
 561 
	access_datas=(${access//|/ })
574 
 
 562 
 
575 
	accces_date_intl=$(echo "${access_datas[0]} ${access_datas[1]}" | sed -E 's@^([0-9]{2})+/+([0-9]{2})+/+([0-9]{4})+@\3-\2-\1@') # Convert date format DD/MM/YYYY to YYYY-MM-DD
 563 
	accces_date_intl=$(echo "${access_datas[0]} ${access_datas[1]}" | sed -E 's@^([0-9]{2})+/+([0-9]{2})+/+([0-9]{4})+@\3-\2-\1@') # Convert date format DD/MM/YYYY to YYYY-MM-DD
576 
	access_date=$(date -d "$accces_date_intl" +%s)
 564 
	access_date=$(date -d "$accces_date_intl" +%s)
577 
	access_user=${access_datas[2]}
 565 
	access_user=${access_datas[2]}
578 
	access_ip=${access_datas[3]}
 566 
	access_ip=${access_datas[3]}
579 
	access_agent=$(echo "$access" | cut -d'|' -f4)
 567 
	access_agent=$(echo "$access" | cut -d'|' -f4)
580 
	if [ $access_date -lt $SECS_AGO ]; then
 568 
	if [ $access_date -lt $SECS_AGO ]; then
581 
		break
 569 
		break
582 
	fi
 570 
	fi
583 
 
 571 
 
584 
	access_date_formatted=$(date -d @$access_date +"%x %X")
 572 
	access_date_formatted=$(date -d @$access_date +"%x %X")
585 
 
 573 
 
586 
	ROWS="$ROWS<tr><td>$access_date_formatted</td><td>$access_user</td><td>$access_ip</td><td>$access_agent</td></tr>"
 574 
	ROWS="$ROWS<tr><td>$access_date_formatted</td><td>$access_user</td><td>$access_ip</td><td>$access_agent</td></tr>"
587 
done < <(cat /var/Save/security/acc_access.log | sort -r)
 575 
done < <(cat /var/Save/security/acc_access.log | sort -r)
588 
# TODO: Read archives if necessary
 576 
# TODO: Read archives if necessary
589 
 
 577 
 
590 
if [ -z "$ROWS" ]; then
 578 
if [ -z "$ROWS" ]; then
591 
	ROWS="<tr><td colspan=\"4\" style=\"text-align: center;\">Aucune connexion</td></tr>"
 579 
	ROWS="<tr><td colspan=\"4\" style=\"text-align: center;\">Aucune connexion</td></tr>"
592 
fi
 580 
fi
593 
 
 581 
 
594 
# Create HTML document
 582 
# Create HTML document
595 
echo "<h2>Connexion à l'ALCASAR Control Center (ACC)</h2>" >> $HTML_REPORT
 583 
echo "<h2>Connexion à l'ALCASAR Control Center (ACC)</h2>" >> $HTML_REPORT
596 
echo "<table class=\"table table-striped\">" >> $HTML_REPORT
 584 
echo "<table class=\"table table-striped\">" >> $HTML_REPORT
597 
echo "<thead><tr><th>Date</th><th>Utilisateur</th><th>Adresse IP</th><th>Agent</th></tr></thead><tbody>" >> $HTML_REPORT
 585 
echo "<thead><tr><th>Date</th><th>Utilisateur</th><th>Adresse IP</th><th>Agent</th></tr></thead><tbody>" >> $HTML_REPORT
598 
echo $ROWS >> $HTML_REPORT
 586 
echo "$ROWS" >> $HTML_REPORT
599 
echo "</tbody></table>" >> $HTML_REPORT
 587 
echo "</tbody></table>" >> $HTML_REPORT
600 
 
 588 
 
601 
 
 589 
 
602 
###################### ALCASAR : GLOBAL TRAFFIC ######################
 590 
###################### ALCASAR : GLOBAL TRAFFIC ######################
603 
echo "Get Global traffic of the last 30 days"
 591 
echo "Get Global traffic of the last 30 days"
604 
 
 592 
 
605 
ROWS=""
 593 
ROWS=""
606 
EXTIF=$(grep ^EXTIF= $CONF_FILE | cut -d'=' -f2)
 594 
EXTIF=$(grep ^EXTIF= $CONF_FILE | cut -d'=' -f2)
607 
for day in $(vnstat --exportdb -i $EXTIF | grep '^d;' | sort -t";" -k3 -r); do
 595 
for day in $(vnstat --exportdb -i $EXTIF | grep '^d;' | sort -t";" -k3 -r); do
608 
	day_datas=(${day//;/ })
 596 
	day_datas=(${day//;/ })
609 
	day_date=${day_datas[2]}
 597 
	day_date=${day_datas[2]}
610 
	day_rxMio=${day_datas[3]}
 598 
	day_rxMio=${day_datas[3]}
611 
	day_txMio=${day_datas[4]}
 599 
	day_txMio=${day_datas[4]}
612 
	day_rxKio=${day_datas[5]}
 600 
	day_rxKio=${day_datas[5]}
613 
	day_txKio=${day_datas[6]}
 601 
	day_txKio=${day_datas[6]}
614 
	day_act=${day_datas[7]}
 602 
	day_act=${day_datas[7]}
615 
 
 603 
 
616 
	if [ $day_act -ne 1 ]; then
 604 
	if [ $day_act -ne 1 ]; then
617 
		continue
 605 
		continue
618 
	fi
 606 
	fi
619 
 
 607 
 
620 
	if [ $day_date -lt $SECS_AGO ]; then
 608 
	if [ $day_date -lt $SECS_AGO ]; then
621 
		break
 609 
		break
622 
	fi
 610 
	fi
623 
 
 611 
 
624 
	day_date_formatted=$(date -d @$day_date +%x)
 612 
	day_date_formatted=$(date -d @$day_date +%x)
625 
	day_rx=$(($day_rxMio * 1048576 + $day_rxKio * 1024))
 613 
	day_rx=$(($day_rxMio * 1048576 + $day_rxKio * 1024))
626 
	day_tx=$(($day_txMio * 1048576 + $day_txKio * 1024))
 614 
	day_tx=$(($day_txMio * 1048576 + $day_txKio * 1024))
627 
	day_total=$(($day_rx + $day_tx))
 615 
	day_total=$(($day_rx + $day_tx))
628 
	day_rx_formatted=$(numfmt --from=iec --to=iec --suffix=B $day_rx)
 616 
	day_rx_formatted=$(numfmt --from=iec --to=iec --suffix=B $day_rx)
629 
	day_tx_formatted=$(numfmt --from=iec --to=iec --suffix=B $day_tx)
 617 
	day_tx_formatted=$(numfmt --from=iec --to=iec --suffix=B $day_tx)
630 
	day_total_formatted=$(numfmt --from=iec --to=iec --suffix=B $day_total)
 618 
	day_total_formatted=$(numfmt --from=iec --to=iec --suffix=B $day_total)
631 
 
 619 
 
632 
	ROWS="$ROWS<tr><td>$day_date_formatted</td><td>$day_rx_formatted</td><td>$day_tx_formatted</td><td>$day_total_formatted</td></tr>"
 620 
	ROWS="$ROWS<tr><td>$day_date_formatted</td><td>$day_rx_formatted</td><td>$day_tx_formatted</td><td>$day_total_formatted</td></tr>"
633 
done
 621 
done
634 
 
 622 
 
635 
if [ -z "$ROWS" ]; then
 623 
if [ -z "$ROWS" ]; then
636 
	ROWS="<tr><td colspan=\"4\" style=\"text-align: center;\">Aucun jour capturé</td></tr>"
 624 
	ROWS="<tr><td colspan=\"4\" style=\"text-align: center;\">Aucun jour capturé</td></tr>"
637 
fi
 625 
fi
638 
 
 626 
 
639 
# Create html document
 627 
# Create html document
640 
echo "<h2>Trafic global</h2>" >> $HTML_REPORT
 628 
echo "<h2>Trafic global</h2>" >> $HTML_REPORT
641 
echo "<table class=\"table table-striped\">" >> $HTML_REPORT
 629 
echo "<table class=\"table table-striped\">" >> $HTML_REPORT
642 
echo "<thead><tr><th>Date</th><th>Entrant</th><th>Sortant</th><th>Total</th></tr></thead><tbody>" >> $HTML_REPORT
 630 
echo "<thead><tr><th>Date</th><th>Entrant</th><th>Sortant</th><th>Total</th></tr></thead><tbody>" >> $HTML_REPORT
643 
echo $ROWS >> $HTML_REPORT
 631 
echo "$ROWS" >> $HTML_REPORT
644 
echo "</tbody></table>" >> $HTML_REPORT
 632 
echo "</tbody></table>" >> $HTML_REPORT
645 
 
 633 
 
646 
 
 634 
 
647 
###################### ALCASAR : FAIL2BAN ######################
 635 
###################### ALCASAR : FAIL2BAN ######################
648 
echo "Get fail2ban log of the week"
 636 
echo "Get fail2ban log of the week"
649 
 
 637 
 
650 
ROWS=""
 638 
ROWS=""
651 
dateDaysAgo_formatted=$(date --date="$MAX_DAY_AGO days ago" +'%Y-%m-%d %H:%M:%S,%N' | rev | cut -c 7- | rev)
 639 
dateDaysAgo_formatted=$(date --date="$MAX_DAY_AGO days ago" +'%Y-%m-%d %H:%M:%S,%N' | rev | cut -c 7- | rev)
652 
while read -r log ; do
 640 
while read -r log ; do
653 
	log_datas=($log)
 641 
	log_datas=($log)
654 
	log_date="${log_datas[0]} ${log_datas[1]}"
 642 
	log_date="${log_datas[0]} ${log_datas[1]}"
655 
	log_type=${log_datas[4]:1:-1}
 643 
	log_type=${log_datas[4]:1:-1}
656 
	log_ip=${log_datas[6]}
 644 
	log_ip=${log_datas[6]}
657 
	log_date_formatted=$(date -d "$log_date" +"%x %X")
 645 
	log_date_formatted=$(date -d "$log_date" +"%x %X")
658 
 
 646 
 
659 
	ROWS="$ROWS<tr><td>$log_date_formatted</td><td>$log_ip</td><td>$log_type</td></tr>"
 647 
	ROWS="$ROWS<tr><td>$log_date_formatted</td><td>$log_ip</td><td>$log_type</td></tr>"
660 
done < <(grep " Ban " /var/log/fail2ban.log | sort -r | awk -v dateDaysAgo="$dateDaysAgo_formatted" '($1 " " $2) >= dateDaysAgo')
 648 
done < <(grep " Ban " /var/log/fail2ban.log | sort -r | awk -v dateDaysAgo="$dateDaysAgo_formatted" '($1 " " $2) >= dateDaysAgo')
661 
 
 649 
 
662 
if [ -z "$ROWS" ]; then
 650 
if [ -z "$ROWS" ]; then
663 
	ROWS="<tr><td colspan=\"3\" style=\"text-align: center;\">Aucune adresse IP bloquée</td></tr>"
 651 
	ROWS="<tr><td colspan=\"3\" style=\"text-align: center;\">Aucune adresse IP bloquée</td></tr>"
664 
fi
 652 
fi
665 
 
 653 
 
666 
# Create html document
 654 
# Create html document
667 
echo "<h2>Adresse(s) IP bloquée(s) (Fail2Ban)</h2>" >> $HTML_REPORT
 655 
echo "<h2>Adresse(s) IP bloquée(s) (Fail2Ban)</h2>" >> $HTML_REPORT
668 
echo "<table class=\"table table-striped\">" >> $HTML_REPORT
 656 
echo "<table class=\"table table-striped\">" >> $HTML_REPORT
669 
echo "<thead><tr><th>Date</th><th>Adresse IP</th><th>Règle</th></tr></thead><tbody>" >> $HTML_REPORT
 657 
echo "<thead><tr><th>Date</th><th>Adresse IP</th><th>Règle</th></tr></thead><tbody>" >> $HTML_REPORT
670 
echo $ROWS >> $HTML_REPORT
 658 
echo $ROWS >> $HTML_REPORT
671 
echo "</tbody></table>" >> $HTML_REPORT
 659 
echo "</tbody></table>" >> $HTML_REPORT
672 
 
 660 
 
673 
 
 661 
 
674 
######################FIN HTML######################
 662 
######################FIN HTML######################
675 
 
 663 
 
676 
#Execute our javascript function to print charts
 664 
#Execute our javascript function to print charts
677 
echo "<script>window.onload = function() {" >> $HTML_REPORT
 665 
echo "<script>window.onload = function() {" >> $HTML_REPORT
678 
#BL SINCE INSTALLATION
 666 
#BL SINCE INSTALLATION
679 
if [ $ENABLE_BL -eq "1" ]
 667 
if [ $ENABLE_BL -eq "1" ]
680 
then
 668 
then
681 
	echo "var ctx_$NAME_BL_INSTALLATION = document.getElementById('$NAME_BL_INSTALLATION').getContext('2d');" >> $HTML_REPORT
 669 
	echo "var ctx_$NAME_BL_INSTALLATION = document.getElementById('$NAME_BL_INSTALLATION').getContext('2d');" >> $HTML_REPORT
682 
	echo "var $NAME_BL_INSTALLATION = new Chart(ctx_$NAME_BL_INSTALLATION, $CONF_BL_INSTALLATION);" >> $HTML_REPORT
 670 
	echo "var $NAME_BL_INSTALLATION = new Chart(ctx_$NAME_BL_INSTALLATION, $CONF_BL_INSTALLATION);" >> $HTML_REPORT
683 
fi
 671 
fi
684 
#BL WEEK
 672 
#BL WEEK
685 
if [ $ENABLE_BL_WEEK -eq "1" ]
 673 
if [ $ENABLE_BL_WEEK -eq "1" ]
686 
then
 674 
then
687 
	echo "var ctx_$NAME_BL = document.getElementById('$NAME_BL').getContext('2d');" >> $HTML_REPORT
 675 
	echo "var ctx_$NAME_BL = document.getElementById('$NAME_BL').getContext('2d');" >> $HTML_REPORT
688 
	echo "var $NAME_BL = new Chart(ctx_$NAME_BL, $CONF_BL);" >> $HTML_REPORT
 676 
	echo "var $NAME_BL = new Chart(ctx_$NAME_BL, $CONF_BL);" >> $HTML_REPORT
689 
fi
 677 
fi
690 
#VIRUS THREAT
 678 
#VIRUS THREAT
691 
if [ $ENABLE_AV -eq "1" ]
 679 
if [ $ENABLE_AV -eq "1" ]
692 
then
 680 
then
693 
	echo "var ctx_$NAME_AV = document.getElementById('$NAME_AV').getContext('2d');" >> $HTML_REPORT
 681 
	echo "var ctx_$NAME_AV = document.getElementById('$NAME_AV').getContext('2d');" >> $HTML_REPORT
694 
	echo "var $NAME_AV = new Chart(ctx_$NAME_AV, $CONF_AV);" >> $HTML_REPORT
 682 
	echo "var $NAME_AV = new Chart(ctx_$NAME_AV, $CONF_AV);" >> $HTML_REPORT
695 
fi
 683 
fi
696 
echo "};</script>" >> $HTML_REPORT
 684 
echo "};</script>" >> $HTML_REPORT
697 
echo "</body>" >> $HTML_REPORT
 685 
echo "</body>" >> $HTML_REPORT
698 
echo "</html>" >> $HTML_REPORT
 686 
echo "</html>" >> $HTML_REPORT
699 
 
 687 
 
700 
#convert html document to PDF
 688 
#convert html document to PDF
701 
/usr/bin/wkhtmltopdf $HTML_REPORT $(echo $HTML_REPORT | cut -d'.' -f1).pdf
 689 
/usr/bin/wkhtmltopdf $HTML_REPORT "$(echo $HTML_REPORT | cut -d'.' -f1).pdf"
702 
chown apache:apache $(echo $HTML_REPORT | cut -d'.' -f1).pdf
 690 
chown apache:apache "$(echo $HTML_REPORT | cut -d'.' -f1).pdf"
703 
chmod 644 $(echo $HTML_REPORT | cut -d'.' -f1).pdf
 691 
chmod 644 "$(echo $HTML_REPORT | cut -d'.' -f1).pdf"
704 
mv $(echo $HTML_REPORT | cut -d'.' -f1).pdf /var/Save/activity_report/
 692 
mv "$(echo $HTML_REPORT | cut -d'.' -f1).pdf" /var/Save/activity_report/
705 
 
 693 
 
706 
#compress every logs, if they exist
 694 
#compress every logs, if they exist
707 
if [ $(ls -1 /var/log/havp/access.log.* 2>/dev/null | wc -l) -ge 1 ]
 695 
if [ "$(ls -1 /var/log/havp/access.log.* 2>/dev/null | wc -l)" -ge 1 ]
708 
then
 696 
then
709 
	gzip /var/log/havp/access.log.*
 697 
	gzip /var/log/havp/access.log.*
710 
fi
 698 
fi
711 
 
 699 
 
712 
#compress every logs
 700 
#compress every logs
713 
if [ $(ls -1 /var/log/dnsmasq/dnsmasq-blacklist.log.* 2>/dev/null | wc -l) -ge 1 ]
 701 
if [ "$(ls -1 /var/log/unbound/unbound-blacklist.log.* 2>/dev/null | wc -l)" -ge 1 ]
714 
then
 702 
then
715 
	gzip /var/log/dnsmasq/dnsmasq-blacklist.log.*
 703 
	gzip /var/log/unbound/unbound-blacklist.log.*
716 
fi
 704 
fi
717 
 
 705 
 
718 
#remove our files
 706 
#remove our files
719 
rm -f $TMP_BL
 707 
rm -f $TMP_BL
720 
rm -f $TMP_BL_WEEK
 708 
rm -f $TMP_BL_WEEK
721 
rm -f $TMP_BL_WEEK_CAT
 709 
rm -f $TMP_BL_WEEK_CAT
722 
rm -f $TMP_STATS
 710 
rm -f $TMP_STATS
723 
rm -f $TMP_STATS_2
 711 
rm -f $TMP_STATS_2
724 
rm -f $HTML_REPORT
 712 
rm -f $HTML_REPORT
725 
 
 713