WebSVN – ALCASAR – Diff – /scripts/alcasar-generate_log.sh


#!/bin/bash
#
# $Id: alcasar-generate_log.sh 2532 2018-04-30 03:55:35Z tom.houdayer $
#
#Corrélation et Generation des logs d'imputabilité au format PDF.
#Ce script permet de générer un fichier HTML qui sera converti en PDF a l'aide du RPM wkhtmltopdf.
#Ce PDF sera placé dans une archive protégé par un mot de passe.
#Pour extraire ce fichier PDF, il faudra installer le paquet p7zip.
#La génération de ce document préviendra les utilisateurs lors de leur prochaine connection. (utilisateur flagué dans le 4ème 'bit' de l'attribut FilterID de la BDD radius.
#
 
 
 
 
 
 
 
 
 
#Il est possible de demander les logs d'imputabilité :
#-depuis le début (pas d'argument)
#-à partir d'une date (un seul argument)
#-en spécifiant un intervale (deux arguments correspondant aux bornes respectives)
#Par Raphaël Pion
 
 
 
usage="Usage: alcasar-generate_log.sh PASSWORD && ({ '' } | { 'YYYY-MM-DD HH:MM:SS' } | { 'YYYY-MM-DD HH:MM:SS' 'YYYY-MM-DD HH:MM:SS' })"
nb_args=$#
DIR='/var/www/html/acc/backup/'
TMP_SQL="/tmp/log_sql.csv"
TMP_USERS="/tmp/log_users"
TMP_HTML="$DIR/log_nf.html"
TMP_PDF="$DIR/imputabilities_logs-$(date +%F).pdf"
PASSWD_FILE="/root/ALCASAR-passwords.txt"
DB_ROOT_PW=$(grep '^db_root=' $PASSWD_FILE | cut -d'=' -f 2-)
ARCHIVE_LOCATION="$DIR/imputabilities_logs.zip"
 
 
if [ $nb_args -eq 1 ]
then
	QUERY="SELECT username,callingstationid,framedipaddress,acctstarttime,acctstoptime,acctinputoctets,acctoutputoctets,acctterminatecause FROM radacct ORDER BY acctstarttime INTO OUTFILE '$TMP_SQL' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';"
	SECTION_LOG="Extraction de tous les journaux"
fi
 
if [ $nb_args -eq 2 ]
then
	QUERY="SELECT username,callingstationid,framedipaddress,acctstarttime,acctstoptime,acctinputoctets,acctoutputoctets,acctterminatecause FROM radacct WHERE acctstarttime >= '$2' ORDER BY acctstarttime INTO OUTFILE '$TMP_SQL' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';"
 
	SECTION_LOG="Extraction des journaux à partir du $2"
fi
 
if [ $nb_args -eq 3 ]
then
	QUERY="SELECT username,callingstationid,framedipaddress,acctstarttime,acctstoptime,acctinputoctets,acctoutputoctets,acctterminatecause FROM radacct WHERE acctstarttime >= '$2' AND acctstarttime <= '$3' ORDER BY acctstoptime INTO OUTFILE '$TMP_SQL' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';"
	SECTION_LOG="Extraction des journaux entre $2 et $3"
fi
 
if [ $nb_args -eq 0 ]
then
	echo $usage
	exit
fi
 
 
if [ $nb_args -gt 3 ]
then
	echo $usage
	exit
fi
 
if [ -e $TMP_SQL ]
then
	rm $TMP_SQL
fi
 
if [ -e $TMP_PDF ]
then
	rm $TMP_PDF
fi
 
if [ -e $ARCHIVE_LOCATION ]
then
	rm $ARCHIVE_LOCATION
fi
 
 
#get log information for each users
mysql -u root -p"$DB_ROOT_PW" -D radius -e "$QUERY"
 
#Create HTML document which contains every informations about users
echo "<!DOCTYPE html>" > $TMP_HTML
echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>" >> $TMP_HTML
echo "<TITLE>ALCASAR Report</TITLE>" >> $TMP_HTML
echo "<link rel='stylesheet' type='text/css' href='../../css/bootstrap.min.css'>" >> $TMP_HTML
echo "<link rel='stylesheet' type='text/css' href='../../css/report.css'>" >> $TMP_HTML
echo "</HEAD>" >> $TMP_HTML
echo "<body>" >> $TMP_HTML
echo "<h1>$SECTION_LOG</h1>" >> $TMP_HTML
 
echo "<i><p style='text-align: right;'>Date de création $(date +%F)</p></i>" >> $TMP_HTML
echo "<font size='1'>" >> $TMP_HTML
cat $TMP_SQL | while read LIGNE_SQL
do
	LOG_IP=$(echo $LIGNE_SQL | cut -d',' -f3)
	LOG_DATE1=$(echo $LIGNE_SQL | cut -d',' -f4)
	LOG_DATE2=$(echo $LIGNE_SQL | cut -d',' -f5)
 
	LOG_Y1=$(echo $LOG_DATE1 | cut -d'-' -f1)
	LOG_M1=$(echo $LOG_DATE1 | cut -d'-' -f2)
	LOG_D1=$(echo $LOG_DATE1 | cut -d'-' -f3 | cut -d' ' -f1)
	LOG_H1=$(echo $LOG_DATE1 | cut -d'-' -f3 | cut -d' ' -f2)
	
	LOG_Y2=$(echo $LOG_DATE2 | cut -d'-' -f1)
	LOG_M2=$(echo $LOG_DATE2 | cut -d'-' -f2)
	LOG_D2=$(echo $LOG_DATE2 | cut -d'-' -f3 | cut -d' ' -f1)
	LOG_H2=$(echo $LOG_DATE2 | cut -d'-' -f3 | cut -d' ' -f2)
	
	DUMP=$(nfdump -O tstart -R /var/log/nfsen/profiles-data/live/alcasar_netflow/ -t $LOG_Y1/$LOG_M1/$LOG_D1.$LOG_H1-$LOG_Y2/$LOG_M2/$LOG_D2.$LOG_H2 -o "fmt:<tr><td class='numberLine'></td><td>%sa</td><td>%sp</td><td>%da</td><td>%dp</td><td>%ts</td></tr>" | tail -n +2 | head -n -4 | grep "$LOG_IP")
	if [ ! -z "$DUMP" ]
	then
		echo "<div class='container'> " >> $TMP_HTML
		echo "<table class='table table-striped'>" >> $TMP_HTML
		echo "<thead>" >> $TMP_HTML
		echo "<tr>" >> $TMP_HTML
		echo "<th>Username</th>" >> $TMP_HTML
		echo "<th>Client @MAC</th>" >> $TMP_HTML
		echo "<th>Client @IP</th>" >> $TMP_HTML
		echo "<th>Login Time</th>" >> $TMP_HTML
		echo "<th>Logout Time</th>" >> $TMP_HTML
		echo "<th>Upload</th>" >> $TMP_HTML
		echo "<th>Download</th>" >> $TMP_HTML
		echo "<th>Cause</th>" >> $TMP_HTML
		echo "</tr></thead><tbody><tr>" >> $TMP_HTML
		echo "<td>" $(echo $LIGNE_SQL | cut -d',' -f1) "</td>" >> $TMP_HTML
		echo "<td>" $(echo $LIGNE_SQL | cut -d',' -f2) "</td>" >> $TMP_HTML
		echo "<td>" $(echo $LIGNE_SQL | cut -d',' -f3) "</td>" >> $TMP_HTML
		echo "<td>" $(echo $LIGNE_SQL | cut -d',' -f4) "</td>" >> $TMP_HTML
		echo "<td>" $(echo $LIGNE_SQL | cut -d',' -f5) "</td>" >> $TMP_HTML
		echo "<td>" $(echo $LIGNE_SQL | cut -d',' -f7) "</td>" >> $TMP_HTML
		echo "<td>" $(echo $LIGNE_SQL | cut -d',' -f6) "</td>" >> $TMP_HTML
		echo "<td>" $(echo $LIGNE_SQL | cut -d',' -f8) "</td>" >> $TMP_HTML
		echo "</tr></tbody></table></div>" >> $TMP_HTML
		echo "<div class='container mySpace'> " >> $TMP_HTML
		echo "<table class='table table-striped'>" >> $TMP_HTML
		echo "<thead>" >> $TMP_HTML
		echo "<tr>" >> $TMP_HTML
		echo "<th>N°</th>" >> $TMP_HTML
		echo "<th>@IP src</th>" >> $TMP_HTML
		echo "<th>Port src</th>" >> $TMP_HTML
		echo "<th>@IP dst</th>" >> $TMP_HTML
		echo "<th>Port dst</th>" >> $TMP_HTML
		echo "<th>Date</th>" >> $TMP_HTML
		echo "</tr></thead><tbody>" >> $TMP_HTML
		echo $DUMP >> $TMP_HTML
		echo "</tbody></table></div>" >> $TMP_HTML
	fi
done
echo "</font>" >> $TMP_HTML
echo "</body>" >> $TMP_HTML
echo "</HTML>" >> $TMP_HTML
 
# inform users about that by setting the Alcasar-Imputability-Warning attribute
QUERY="INSERT INTO radreply (username, attribute, value, op) SELECT ui.username, 'Alcasar-Imputability-Warning', '1' , '=' FROM userinfo ui LEFT JOIN radreply rr ON rr.username = ui.username AND rr.attribute = 'Alcasar-Imputability-Warning' WHERE rr.username IS NULL;"
mysql -u root -p"$DB_ROOT_PW" -D radius -e "$QUERY"
 
/usr/bin/wkhtmltopdf $TMP_HTML $TMP_PDF
 
 
/usr/bin/7za a -tzip -p"$1" -mem=AES256 $ARCHIVE_LOCATION $TMP_PDF
chown apache:apache $ARCHIVE_LOCATION
 
 
rm $TMP_HTML
rm $TMP_SQL
rm $TMP_PDF
 

Rev 2506	Rev 2532
-		1	`#!/bin/bash`
-		2	`#`
-		3	`# $Id: alcasar-generate_log.sh 2532 2018-04-30 03:55:35Z tom.houdayer $`
-		4	`#`
1	`#Corrélation et Generation des logs d'imputabilité au format PDF.`	5	`#Corrélation et Generation des logs d'imputabilité au format PDF.`
2	`#Ce script permet de générer un fichier HTML qui sera converti en PDF a l'aide du RPM wkhtmltopdf.`	6	`#Ce script permet de générer un fichier HTML qui sera converti en PDF a l'aide du RPM wkhtmltopdf.`
3	`#Ce PDF sera placé dans une archive protégé par un mot de passe.`	7	`#Ce PDF sera placé dans une archive protégé par un mot de passe.`
4	`#Pour extraire ce fichier PDF, il faudra installer le paquet p7zip.`	8	`#Pour extraire ce fichier PDF, il faudra installer le paquet p7zip.`
5	`#La génération de ce document préviendra les utilisateurs lors de leur prochaine connection. (utilisateur flagué dans le 4ème 'bit' de l'attribut FilterID de la BDD radius.`	9	`#La génération de ce document préviendra les utilisateurs lors de leur prochaine connection. (utilisateur flagué dans le 4ème 'bit' de l'attribut FilterID de la BDD radius.`
6	`#`	10	`#`
7	`#Attribut FilterID dans la table radreply: 12345678`	-
8	`#1-> profile1`	-
9	`#2-> profile2`	-
10	`#3-> profile3`	-
11	`#4-> warn_user (if imputability report has been generated)`	-
12	`#6-> WL`	-
13	`#7-> BL`	-
14	`#8-> HAVP`	-
15	`#`	-
16	`#Il est possible de demander les logs d'imputabilité :`	11	`#Il est possible de demander les logs d'imputabilité :`
17	`#-depuis le début (pas d'argument)`	12	`#-depuis le début (pas d'argument)`
18	`#-à partir d'une date (un seul argument)`	13	`#-à partir d'une date (un seul argument)`
19	`#-en spécifiant un intervale (deux arguments correspondant aux bornes respectives)`	14	`#-en spécifiant un intervale (deux arguments correspondant aux bornes respectives)`
20	`#Par Raphaël Pion`	15	`#Par Raphaël Pion`
21		16
22		17
23		18
24	`usage="Usage: alcasar-generate_log.sh PASSWORD && ({ '' } \| { 'YYYY-MM-DD HH:MM:SS' } \| { 'YYYY-MM-DD HH:MM:SS' 'YYYY-MM-DD HH:MM:SS' })"`	19	`usage="Usage: alcasar-generate_log.sh PASSWORD && ({ '' } \| { 'YYYY-MM-DD HH:MM:SS' } \| { 'YYYY-MM-DD HH:MM:SS' 'YYYY-MM-DD HH:MM:SS' })"`
25	`nb_args=$#`	20	`nb_args=$#`
26	`DIR='/var/www/html/acc/backup/'`	21	`DIR='/var/www/html/acc/backup/'`
27	`TMP_SQL="/tmp/log_sql.csv"`	22	`TMP_SQL="/tmp/log_sql.csv"`
28	`TMP_USERS="/tmp/log_users"`	23	`TMP_USERS="/tmp/log_users"`
29	`TMP_HTML="$DIR/log_nf.html"`	24	`TMP_HTML="$DIR/log_nf.html"`
30	`TMP_PDF="$DIR/imputabilities_logs-$(date +%F).pdf"`	25	`TMP_PDF="$DIR/imputabilities_logs-$(date +%F).pdf"`
31	`PASSWD_FILE="/root/ALCASAR-passwords.txt"`	26	`PASSWD_FILE="/root/ALCASAR-passwords.txt"`
32	`DB_ROOT_PW=$(grep '^db_root=' $PASSWD_FILE \| cut -d'=' -f 2-)`	27	`DB_ROOT_PW=$(grep '^db_root=' $PASSWD_FILE \| cut -d'=' -f 2-)`
33	`ARCHIVE_LOCATION="$DIR/imputabilities_logs.zip"`	28	`ARCHIVE_LOCATION="$DIR/imputabilities_logs.zip"`
34		29
35		30
36	`if [ $nb_args -eq 1 ]`	31	`if [ $nb_args -eq 1 ]`
37	`then`	32	`then`
38	`QUERY="SELECT username,callingstationid,framedipaddress,acctstarttime,acctstoptime,acctinputoctets,acctoutputoctets,acctterminatecause FROM radacct ORDER BY acctstarttime INTO OUTFILE '$TMP_SQL' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';"`	33	`QUERY="SELECT username,callingstationid,framedipaddress,acctstarttime,acctstoptime,acctinputoctets,acctoutputoctets,acctterminatecause FROM radacct ORDER BY acctstarttime INTO OUTFILE '$TMP_SQL' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';"`
39	`SECTION_LOG="Extraction de tous les journaux"`	34	`SECTION_LOG="Extraction de tous les journaux"`
40	`fi`	35	`fi`
41		36
42	`if [ $nb_args -eq 2 ]`	37	`if [ $nb_args -eq 2 ]`
43	`then`	38	`then`
44	`QUERY="SELECT username,callingstationid,framedipaddress,acctstarttime,acctstoptime,acctinputoctets,acctoutputoctets,acctterminatecause FROM radacct WHERE acctstarttime >= '$2' ORDER BY acctstarttime INTO OUTFILE '$TMP_SQL' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';"`	39	`QUERY="SELECT username,callingstationid,framedipaddress,acctstarttime,acctstoptime,acctinputoctets,acctoutputoctets,acctterminatecause FROM radacct WHERE acctstarttime >= '$2' ORDER BY acctstarttime INTO OUTFILE '$TMP_SQL' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';"`
45	`echo $QUERY`	-
46	`SECTION_LOG="Extraction des journaux à partir du $2"`	40	`SECTION_LOG="Extraction des journaux à partir du $2"`
47	`fi`	41	`fi`
48		42
49	`if [ $nb_args -eq 3 ]`	43	`if [ $nb_args -eq 3 ]`
50	`then`	44	`then`
51	`QUERY="SELECT username,callingstationid,framedipaddress,acctstarttime,acctstoptime,acctinputoctets,acctoutputoctets,acctterminatecause FROM radacct WHERE acctstarttime >= '$2' AND acctstarttime <= '$3' ORDER BY acctstoptime INTO OUTFILE '$TMP_SQL' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';"`	45	`QUERY="SELECT username,callingstationid,framedipaddress,acctstarttime,acctstoptime,acctinputoctets,acctoutputoctets,acctterminatecause FROM radacct WHERE acctstarttime >= '$2' AND acctstarttime <= '$3' ORDER BY acctstoptime INTO OUTFILE '$TMP_SQL' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';"`
52	`SECTION_LOG="Extraction des journaux entre $2 et $3"`	46	`SECTION_LOG="Extraction des journaux entre $2 et $3"`
53	`fi`	47	`fi`
54		48
55	`if [ $nb_args -eq 0 ]`	49	`if [ $nb_args -eq 0 ]`
56	`then`	50	`then`
57	`echo $usage`	51	`echo $usage`
58	`exit`	52	`exit`
59	`fi`	53	`fi`
60		54
61		55
62	`if [ $nb_args -gt 3 ]`	56	`if [ $nb_args -gt 3 ]`
63	`then`	57	`then`
64	`echo $usage`	58	`echo $usage`
65	`exit`	59	`exit`
66	`fi`	60	`fi`
67		61
68	`if [ -e $TMP_SQL ]`	62	`if [ -e $TMP_SQL ]`
69	`then`	63	`then`
70	`rm $TMP_SQL`	64	`rm $TMP_SQL`
71	`fi`	65	`fi`
72		66
73	`if [ -e $TMP_PDF ]`	67	`if [ -e $TMP_PDF ]`
74	`then`	68	`then`
75	`rm $TMP_PDF`	69	`rm $TMP_PDF`
76	`fi`	70	`fi`
77		71
78	`if [ -e $ARCHIVE_LOCATION ]`	72	`if [ -e $ARCHIVE_LOCATION ]`
79	`then`	73	`then`
80	`rm $ARCHIVE_LOCATION`	74	`rm $ARCHIVE_LOCATION`
81	`fi`	75	`fi`
82		76
83		77
84	`#get log information for each users`	78	`#get log information for each users`
85	`mysql -u root -p"$DB_ROOT_PW" -D radius -e "$QUERY"`	79	`mysql -u root -p"$DB_ROOT_PW" -D radius -e "$QUERY"`
86		80
87	`#Create HTML document which contains every informations about users`	81	`#Create HTML document which contains every informations about users`
88	`echo "<!DOCTYPE html>" > $TMP_HTML`	82	`echo "<!DOCTYPE html>" > $TMP_HTML`
89	`echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>" >> $TMP_HTML`	83	`echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>" >> $TMP_HTML`
90	`echo "<TITLE>ALCASAR Report</TITLE>" >> $TMP_HTML`	84	`echo "<TITLE>ALCASAR Report</TITLE>" >> $TMP_HTML`
91	`echo "<link rel='stylesheet' type='text/css' href='../../css/bootstrap.min.css'>" >> $TMP_HTML`	85	`echo "<link rel='stylesheet' type='text/css' href='../../css/bootstrap.min.css'>" >> $TMP_HTML`
92	`echo "<link rel='stylesheet' type='text/css' href='../../css/report.css'>" >> $TMP_HTML`	86	`echo "<link rel='stylesheet' type='text/css' href='../../css/report.css'>" >> $TMP_HTML`
93	`echo "</HEAD>" >> $TMP_HTML`	87	`echo "</HEAD>" >> $TMP_HTML`
94	`echo "<body>" >> $TMP_HTML`	88	`echo "<body>" >> $TMP_HTML`
95	`echo "<h1>$SECTION_LOG</h1>" >> $TMP_HTML`	89	`echo "<h1>$SECTION_LOG</h1>" >> $TMP_HTML`
96		90
97	`echo "<i><p style='text-align: right;'>Date de création $(date +%F)</p></i>" >> $TMP_HTML`	91	`echo "<i><p style='text-align: right;'>Date de création $(date +%F)</p></i>" >> $TMP_HTML`
98	`echo "<font size='1'>" >> $TMP_HTML`	92	`echo "<font size='1'>" >> $TMP_HTML`
99	`cat $TMP_SQL \| while read LIGNE_SQL`	93	`cat $TMP_SQL \| while read LIGNE_SQL`
100	`do`	94	`do`
101	`LOG_IP=$(echo $LIGNE_SQL \| cut -d',' -f3)`	95	`LOG_IP=$(echo $LIGNE_SQL \| cut -d',' -f3)`
102	`LOG_DATE1=$(echo $LIGNE_SQL \| cut -d',' -f4)`	96	`LOG_DATE1=$(echo $LIGNE_SQL \| cut -d',' -f4)`
103	`LOG_DATE2=$(echo $LIGNE_SQL \| cut -d',' -f5)`	97	`LOG_DATE2=$(echo $LIGNE_SQL \| cut -d',' -f5)`
104		98
105	`LOG_Y1=$(echo $LOG_DATE1 \| cut -d'-' -f1)`	99	`LOG_Y1=$(echo $LOG_DATE1 \| cut -d'-' -f1)`
106	`LOG_M1=$(echo $LOG_DATE1 \| cut -d'-' -f2)`	100	`LOG_M1=$(echo $LOG_DATE1 \| cut -d'-' -f2)`
107	`LOG_D1=$(echo $LOG_DATE1 \| cut -d'-' -f3 \| cut -d' ' -f1)`	101	`LOG_D1=$(echo $LOG_DATE1 \| cut -d'-' -f3 \| cut -d' ' -f1)`
108	`LOG_H1=$(echo $LOG_DATE1 \| cut -d'-' -f3 \| cut -d' ' -f2)`	102	`LOG_H1=$(echo $LOG_DATE1 \| cut -d'-' -f3 \| cut -d' ' -f2)`
109		103
110	`LOG_Y2=$(echo $LOG_DATE2 \| cut -d'-' -f1)`	104	`LOG_Y2=$(echo $LOG_DATE2 \| cut -d'-' -f1)`
111	`LOG_M2=$(echo $LOG_DATE2 \| cut -d'-' -f2)`	105	`LOG_M2=$(echo $LOG_DATE2 \| cut -d'-' -f2)`
112	`LOG_D2=$(echo $LOG_DATE2 \| cut -d'-' -f3 \| cut -d' ' -f1)`	106	`LOG_D2=$(echo $LOG_DATE2 \| cut -d'-' -f3 \| cut -d' ' -f1)`
113	`LOG_H2=$(echo $LOG_DATE2 \| cut -d'-' -f3 \| cut -d' ' -f2)`	107	`LOG_H2=$(echo $LOG_DATE2 \| cut -d'-' -f3 \| cut -d' ' -f2)`
114		108
115	`DUMP=$(nfdump -O tstart -R /var/log/nfsen/profiles-data/live/alcasar_netflow/ -t $LOG_Y1/$LOG_M1/$LOG_D1.$LOG_H1-$LOG_Y2/$LOG_M2/$LOG_D2.$LOG_H2 -o "fmt:<tr><td class='numberLine'></td><td>%sa</td><td>%sp</td><td>%da</td><td>%dp</td><td>%ts</td></tr>" \| tail -n +2 \| head -n -4 \| grep "$LOG_IP")`	109	`DUMP=$(nfdump -O tstart -R /var/log/nfsen/profiles-data/live/alcasar_netflow/ -t $LOG_Y1/$LOG_M1/$LOG_D1.$LOG_H1-$LOG_Y2/$LOG_M2/$LOG_D2.$LOG_H2 -o "fmt:<tr><td class='numberLine'></td><td>%sa</td><td>%sp</td><td>%da</td><td>%dp</td><td>%ts</td></tr>" \| tail -n +2 \| head -n -4 \| grep "$LOG_IP")`
116	`if [ ! -z "$DUMP" ]`	110	`if [ ! -z "$DUMP" ]`
117	`then`	111	`then`
118	`echo "<div class='container'> " >> $TMP_HTML`	112	`echo "<div class='container'> " >> $TMP_HTML`
119	`echo "<table class='table table-striped'>" >> $TMP_HTML`	113	`echo "<table class='table table-striped'>" >> $TMP_HTML`
120	`echo "<thead>" >> $TMP_HTML`	114	`echo "<thead>" >> $TMP_HTML`
121	`echo "<tr>" >> $TMP_HTML`	115	`echo "<tr>" >> $TMP_HTML`
122	`echo "<th>Username</th>" >> $TMP_HTML`	116	`echo "<th>Username</th>" >> $TMP_HTML`
123	`echo "<th>Client @MAC</th>" >> $TMP_HTML`	117	`echo "<th>Client @MAC</th>" >> $TMP_HTML`
124	`echo "<th>Client @IP</th>" >> $TMP_HTML`	118	`echo "<th>Client @IP</th>" >> $TMP_HTML`
125	`echo "<th>Login Time</th>" >> $TMP_HTML`	119	`echo "<th>Login Time</th>" >> $TMP_HTML`
126	`echo "<th>Logout Time</th>" >> $TMP_HTML`	120	`echo "<th>Logout Time</th>" >> $TMP_HTML`
127	`echo "<th>Upload</th>" >> $TMP_HTML`	121	`echo "<th>Upload</th>" >> $TMP_HTML`
128	`echo "<th>Download</th>" >> $TMP_HTML`	122	`echo "<th>Download</th>" >> $TMP_HTML`
129	`echo "<th>Cause</th>" >> $TMP_HTML`	123	`echo "<th>Cause</th>" >> $TMP_HTML`
130	`echo "</tr></thead><tbody><tr>" >> $TMP_HTML`	124	`echo "</tr></thead><tbody><tr>" >> $TMP_HTML`
131	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f1) "</td>" >> $TMP_HTML`	125	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f1) "</td>" >> $TMP_HTML`
132	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f2) "</td>" >> $TMP_HTML`	126	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f2) "</td>" >> $TMP_HTML`
133	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f3) "</td>" >> $TMP_HTML`	127	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f3) "</td>" >> $TMP_HTML`
134	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f4) "</td>" >> $TMP_HTML`	128	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f4) "</td>" >> $TMP_HTML`
135	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f5) "</td>" >> $TMP_HTML`	129	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f5) "</td>" >> $TMP_HTML`
136	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f7) "</td>" >> $TMP_HTML`	130	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f7) "</td>" >> $TMP_HTML`
137	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f6) "</td>" >> $TMP_HTML`	131	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f6) "</td>" >> $TMP_HTML`
138	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f8) "</td>" >> $TMP_HTML`	132	`echo "<td>" $(echo $LIGNE_SQL \| cut -d',' -f8) "</td>" >> $TMP_HTML`
139	`echo "</tr></tbody></table></div>" >> $TMP_HTML`	133	`echo "</tr></tbody></table></div>" >> $TMP_HTML`
140	`echo "<div class='container mySpace'> " >> $TMP_HTML`	134	`echo "<div class='container mySpace'> " >> $TMP_HTML`
141	`echo "<table class='table table-striped'>" >> $TMP_HTML`	135	`echo "<table class='table table-striped'>" >> $TMP_HTML`
142	`echo "<thead>" >> $TMP_HTML`	136	`echo "<thead>" >> $TMP_HTML`
143	`echo "<tr>" >> $TMP_HTML`	137	`echo "<tr>" >> $TMP_HTML`
144	`echo "<th>N°</th>" >> $TMP_HTML`	138	`echo "<th>N°</th>" >> $TMP_HTML`
145	`echo "<th>@IP src</th>" >> $TMP_HTML`	139	`echo "<th>@IP src</th>" >> $TMP_HTML`
146	`echo "<th>Port src</th>" >> $TMP_HTML`	140	`echo "<th>Port src</th>" >> $TMP_HTML`
147	`echo "<th>@IP dst</th>" >> $TMP_HTML`	141	`echo "<th>@IP dst</th>" >> $TMP_HTML`
148	`echo "<th>Port dst</th>" >> $TMP_HTML`	142	`echo "<th>Port dst</th>" >> $TMP_HTML`
149	`echo "<th>Date</th>" >> $TMP_HTML`	143	`echo "<th>Date</th>" >> $TMP_HTML`
150	`echo "</tr></thead><tbody>" >> $TMP_HTML`	144	`echo "</tr></thead><tbody>" >> $TMP_HTML`
151	`echo $DUMP >> $TMP_HTML`	145	`echo $DUMP >> $TMP_HTML`
152	`echo "</tbody></table></div>" >> $TMP_HTML`	146	`echo "</tbody></table></div>" >> $TMP_HTML`
153	`fi`	147	`fi`
154	`done`	148	`done`
155	`echo "</font>" >> $TMP_HTML`	149	`echo "</font>" >> $TMP_HTML`
156	`echo "</body>" >> $TMP_HTML`	150	`echo "</body>" >> $TMP_HTML`
157	`echo "</HTML>" >> $TMP_HTML`	151	`echo "</HTML>" >> $TMP_HTML`
158		152
159	`# inform users about that by setting the Alcasar-Imputability-Warning attribute`	153	`# inform users about that by setting the Alcasar-Imputability-Warning attribute`
160	`QUERY="INSERT INTO radreply (username, attribute, value, op) SELECT ui.username, 'Alcasar-Imputability-Warning', '1' , '=' FROM userinfo ui LEFT JOIN radreply rr ON rr.username = ui.username AND rr.attribute = 'Alcasar-Imputability-Warning' WHERE rr.username IS NULL;"`	154	`QUERY="INSERT INTO radreply (username, attribute, value, op) SELECT ui.username, 'Alcasar-Imputability-Warning', '1' , '=' FROM userinfo ui LEFT JOIN radreply rr ON rr.username = ui.username AND rr.attribute = 'Alcasar-Imputability-Warning' WHERE rr.username IS NULL;"`
161	`mysql -u root -p"$DB_ROOT_PW" -D radius -e "$QUERY"`	155	`mysql -u root -p"$DB_ROOT_PW" -D radius -e "$QUERY"`
162		156
163	`/usr/bin/wkhtmltopdf $TMP_HTML $TMP_PDF`	157	`/usr/bin/wkhtmltopdf $TMP_HTML $TMP_PDF`
164		158
165		159
166	`/usr/bin/7za a -tzip -p"$1" -mem=AES256 $ARCHIVE_LOCATION $TMP_PDF`	160	`/usr/bin/7za a -tzip -p"$1" -mem=AES256 $ARCHIVE_LOCATION $TMP_PDF`
167	`chown apache:apache $ARCHIVE_LOCATION`	161	`chown apache:apache $ARCHIVE_LOCATION`
168		162
169		163
170	`rm $TMP_HTML`	164	`rm $TMP_HTML`
171	`rm $TMP_SQL`	165	`rm $TMP_SQL`
172	`rm $TMP_PDF`	166	`rm $TMP_PDF`
173		167

Subversion Repositories ALCASAR

(root)/scripts/alcasar-generate_log.sh – Rev 2506 → 2532