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

 #!/bin/bash
-# $Id: alcasar-sms.sh 2631 2018-09-12 21:16:42Z rexy $
+# $Id: alcasar-sms.sh 2875 2020-11-01 10:50:57Z rexy $
 # alcasar-sms.sh
 # by Nicolas Aubry & Rexy
 # This script is distributed under the Gnu General Public License (GPL)
 # This script manages the 'gammu-smsd' service when a GSM adapter is detected
 # Ce script gère le service 'gammu-smsd' quand un adaptateur GSM est détecté
 CONF_FILE='/usr/local/etc/alcasar.conf'
-#########################################
 #######	VARIABLES ########
 nb_essais=3
 time_account=1
 time_ban=2
-#########################################
 ####### IDs DB ##########################
 PASSWD_FILE="/root/ALCASAR-passwords.txt"
 u_db=$(grep '^db_user='     $PASSWD_FILE | cut -d'=' -f2-)
 p_db=$(grep '^db_password=' $PASSWD_FILE | cut -d'=' -f2-)
 #########################################
-#########################################
 rad="radcheck"
 radgp="radusergroup"
 radgpck="radgroupcheck"
 radinf="userinfo"
 sms_p="SMS_ban_perm"
 sms_t="SMS_ban_temp"
 inb="inbox"
 SMS_c="SMS_country"
 config="/etc/gammu_smsd_conf"
 config2="/etc/gammurc"
 logfile="/var/log/gammu-smsd/gammu-smsd.log"
 script="/usr/local/bin/alcasar-sms.sh"
 separator="########## START ##########"
 end="%%%%%%%%%% STOP %%%%%%%%%%"
 usage="Usage: alcasar-gammu.sh
 Start Gammu-smsd   : --start
 Stop Gammu-smsd    : --stop
 Process on new sms : --new_sms"
 nb_args=$#
 args=$1
 # Functions
 function mode_huawei() {
 	couple=$(lsusb | grep -i huawei | cut -d ' ' -f6)
 	vendor=$(echo $couple | cut -d ':' -f1)
 	product=$(echo $couple | cut -d ':' -f2)
 	echo "******** Modeswitch *************" >> $logfile
 	echo $vendor >> $logfile
 	echo $product >> $logfile
 	/usr/sbin/usb_modeswitch -I -H -v 0x$vendor -p 0x$product -V 0x$vendor -P 0x$product -W -n >> $logfile
-}
+} # end function mode_huawei
 function start_gammu() {
-	# Check phone number is set
-	if [ -z "$(grep '^SMS_NUM=' $CONF_FILE | cut -d'=' -f2-)" ]; then
-		echo 'The phone number is not set.'
-		# exit 2
-	fi
-	#On truncate la table phones (informations signal / IMEI / batterie / sms recu et envoyé)
+	# Truncate phones table (informations signal/IMEI/battery/sent et reveived sms)
 	mysql --user=$u_db --password=$p_db --database=gammu -Bs -e 'TRUNCATE phones;'
-	#On verifie que le groupe sms est créé
+	# Verify the sms group is created
 	if [ $(mysql --user=$u_db --password=$p_db --database=radius -Bs -e "SELECT COUNT(*) FROM $radgp WHERE username='sms' AND groupname='sms';") -eq 0 ]; then
 		sql_add_gp="INSERT INTO $radgp (username,groupname) VALUES ('sms','sms'); INSERT INTO $radgpck (groupname,attribute,op,value) VALUES ('sms','Simultaneous-Use',':=',1);"
 		mysql --user=$u_db --password=$p_db --database=radius -Bs -e "$sql_add_gp"
 	fi
-	#Start gammu
+	# Start gammu
 	echo $separator >> $logfile
 	/usr/bin/systemctl -q start gammu-smsd.service
 	/usr/bin/systemctl -q enable gammu-smsd.service
 } # end function start_gammu
 function stop_gammu() {
-	#Stop gammu
 	/usr/bin/systemctl -q stop gammu-smsd.service
 	/usr/bin/systemctl -q disable gammu-smsd.service
-	sleep 10
 	echo $end >> $logfile
 } # end function stop_gammu
 function unlock() {
-	#Suppression du numero dans la table SMS_ban_perm
+	# Remove phone number in SMS_ban_perm table
 		sql_remove_ban_perm="connect gammu; DELETE FROM $sms_p"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_remove_ban_perm WHERE SenderNumber=$1;"
-	# Ajout au groupe sms
+	# Add sms group
 		sql_remove_gp="connect radius; DELETE FROM $radgp WHERE username='$1';"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_remove_gp"
-	# Suppression du compte dans Radcheck
+	# Remove account in Radcheck table
 		sql_remove_compte="connect radius; DELETE FROM $rad WHERE username='$1';"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_remove_compte"
 } # end function unlock
 function change_country() {
-	# recupère le status du pays
 		sql_status_country="connect gammu; SELECT status FROM SMS_country WHERE name='$1'"
 		stat=$(mysql --user=$u_db --password=$p_db -B -se "$sql_status_country")
 		if [ $stat -eq 0 ]
 		then
 			sql_change_country="connect gammu; UPDATE $SMS_c SET status=1 WHERE name='$1'"
 			mysql --user=$u_db --password=$p_db -B -se "$sql_change_country"
 		else
 			sql_change_country="connect gammu; UPDATE $SMS_c SET status=0 WHERE name='$1'"
 			mysql --user=$u_db --password=$p_db -B -se "$sql_change_country"
 		fi
 } # end change_country
 function supp_acc_rad() {
-	# Suppression du compte dans Radcheck
+	# Remove account in Radcheck table
 		sql_del_compte="connect radius; DELETE FROM $rad WHERE username='$1';"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_del_compte"
 } # end function supp_acc_rad()
 function add_acc_rad() {
-	# Ajout table RadCheck : creation du compte
+	# Add accoubt in RadCheck table
 		sql_add_pass="connect radius; INSERT INTO $rad (username,attribute,op,value) VALUES ('$1','Crypt-Password',':=','$2');"
 		sql_add_expe="connect radius; INSERT INTO $rad (username,attribute,op,value) VALUES ('$1','Expiration',':=','$3');"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_add_pass"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_add_expe"
-	# Ajout au groupe sms
+	# Add this account to sms group
 		sql_add_gp="connect radius; INSERT INTO $radgp (username,groupname) VALUES ('$1','sms');"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_add_gp"
 } # end function add_acc_rad()
 function supp_num_temp() {
-	# Suppression du numéro dans table SMS_ban_temp
+	# Remove phone number in SMS_ban_temp table
 		sql_remove_ban_temp="connect gammu; DELETE FROM $sms_t"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_remove_ban_temp WHERE SenderNumber=$1;"
 } # end function supp_num_temp()
 function add_num_perm() {
-	# Ajout du numero table SMS_ban_perm, 0 : creation du compte
+	# Add phone number in SMS_ban_perm table
 		sql_add_ban_perm="connect gammu; INSERT INTO $sms_p (SenderNumber,Perm,Expiration) VALUES ('$1',0,'$2');"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_add_ban_perm"
 } # end function add_num_perm()
 function supp_num_perm() {
-	#Suppression du numero dans la table SMS_ban_perm
+	# Remove phone number in SMS_ban_perm table
 		sql_remove_ban_perm="connect gammu; DELETE FROM $sms_p"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_remove_ban_perm WHERE SenderNumber=$1;"
 } # end function add_num_perm()
 function new_sms() {
 	# Check Inbox table, manage Ban temp and perm, create account
 		export salt='$5$passwd$'
 		sql_select_inbox="connect gammu; SELECT ID, SenderNumber, TextDecoded FROM $inb;"
 		sql_delete_inbox="connect gammu; DELETE FROM $inb"
 		mysql --user=$u_db --password=$p_db -B -se "$sql_select_inbox" | while read result;
 		do
-		# On recupère le nombre de mots (resultat)
+		# Retrieve the number of words (result)
 			nb=$(echo $result | wc -w)
-		# On récupère le numéro de l'ID
+		# Retrive the ID
-				id=$(echo $result | cut -d ' ' -f1)
+			id=$(echo $result | cut -d ' ' -f1)
-		numero=$(echo $result | cut -d ' ' -f2)
+			numero=$(echo $result | cut -d ' ' -f2)
-		if [[ $numero =~ ^\+ ]]
+			if [[ $numero =~ ^\+ ]]
-		then
+			then
-			# On vérifie si le pays est bloqué
+			# Check if country is blocked
 				sql_select_countries="connect gammu; SELECT id FROM $SMS_c WHERE status=1"
 				mysql --user=$u_db --password=$p_db -B -se "$sql_select_countries" | while read result_c;
 				do
-				if [[ $numero =~ ^"$result_c" ]]
+					if [[ $numero =~ ^"$result_c" ]]
-				then
-				numero=$(echo $numero | cut -d '+' -f2)
-				# On vérifie que le numéro n'est pas Ban Perm
-					sql_ban_perm="connect gammu; SELECT * FROM $sms_p WHERE SenderNumber=$numero"
-					result_bp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_ban_perm")
-					if test -z "$result_bp"
 					then
-						# Test sur le nombre de mots (resultat)
+						numero=$(echo $numero | cut -d '+' -f2)
-						if [ $nb -eq 2 ]	# Si 2 mots : le mot de passe est manquant
+				# Check if GSM number is nabbed
-						then
-							# On incrémente de 1 dans la table des bans temp // NO PASSWORD
-							sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');"
+						sql_ban_perm="connect gammu; SELECT * FROM $sms_p WHERE SenderNumber=$numero"
-							mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp"
+						result_bp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_ban_perm")
-						elif [ $nb -eq 3 ]	# Si 3 mots : id + mot de passe + numero
+						if test -z "$result_bp"
 						then
-							export pass=$(echo $result | cut -d ' ' -f3)
-							pass_salt=$(perl -e'print crypt($ARGV[0],$ARGV[1])' $pass $salt)
-							export LC_TIME="en_US.UTF-8"
-							expir=$(date '+%d %B %Y' -d "$time_account days")
-							supp_acc_rad "$numero"
-							add_acc_rad "$numero" "$pass_salt" "$expir"
-							supp_num_temp "$numero"
-							add_num_perm "$numero" "$expir"
-						else
-						# Autrement, le mot de passe est trop grand ( > un mot )
-							# On incrémente d'un 1 dans la table des bans temp
-								sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');"
-								mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp"
-						fi
-						# On gère les bans temp en ban perm
-							sql_select_temp="connect gammu; SELECT ID FROM $sms_t WHERE SenderNumber='$numero'"
-							r_select_temp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_select_temp")
-							nb_ban_t=$(echo $r_select_temp| wc -w)
-						if [ $nb_ban_t -ge $nb_essais ]
-						then
-							supp_num_temp "$numero"
-								export LC_TIME="en_US.UTF-8"
-								expir_f=$(date '+%d %B %Y' -d "$time_ban days")
-							# Ajout du numero table SMS_ban_perm, 1 : flood
-								sql_add_ban_perm="connect gammu; INSERT INTO $sms_p (SenderNumber,Perm,Expiration) VALUES ('$numero',1,'$expir_f');"
-								mysql --user=$u_db --password=$p_db -B -se "$sql_add_ban_perm"
-						fi
-					else
-						date_expiration=$(echo $result_bp | cut -d ' ' -f2,3,4)
-						perm=$(echo $result_bp | cut -d ' ' -f5)
-						export LC_TIME="en_US.UTF-8"
-						date_script=$(date '+%d %B %Y' -d "now")
-					# On converti les deux dates en secondes, pour les comparer.
-						d_exp=$(date --date "$date_expiration" +%s)
-						d_scr=$(date --date "$date_script" +%s)
-						if test $d_scr -ge $d_exp		# Si le ban à expiré
-						then
-							# Test sur le nombre de mots (resultat)
+						# Test the number of word (result)
-							if [ $nb -eq 2 ]	# Si 2 mots : le mot de passe est manquant
+							if [ $nb -eq 2 ] # if only 2 words : lack of password
 							then
-							# On incrémente de 1 dans la table des bans temp
+							# Add "1" in bans_temp table // NO PASSWORD
 								sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');"
 								mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp"
-							elif [ $nb -eq 3 ]	# Si 3 mots : id + mot de passe + numero
+							elif [ $nb -eq 3 ] # if 3 words (id + password + phone numbere)
 							then
-								date_expiration=$(echo $result_bp | cut -d ' ' -f2,3,4)
-								perm=$(echo $result_bp | cut -d ' ' -f5)
-								date_script=$(date '+%d %B %Y' -d "now")
-							# On converti les deux dates en secondes, pour les comparer.
-								d_exp=$(date --date "$date_expiration" +%s)
-								d_scr=$(date --date "$date_script" +%s)
 								export pass=$(echo $result | cut -d ' ' -f3)
 								pass_salt=$(perl -e'print crypt($ARGV[0],$ARGV[1])' $pass $salt)
 								export LC_TIME="en_US.UTF-8"
 								expir=$(date '+%d %B %Y' -d "$time_account days")
 								supp_acc_rad "$numero"
 								add_acc_rad "$numero" "$pass_salt" "$expir"
 								supp_num_temp "$numero"
-								supp_num_perm "$numero"
 								add_num_perm "$numero" "$expir"
+							else # more then 3 words --> Add "1" in ban_temp table
+								sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');"
+								mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp"
+							fi
+							# manage ban perm
+							sql_select_temp="connect gammu; SELECT ID FROM $sms_t WHERE SenderNumber='$numero'"
+							r_select_temp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_select_temp")
+							nb_ban_t=$(echo $r_select_temp| wc -w)
+							if [ $nb_ban_t -ge $nb_essais ]
+							then
+								supp_num_temp "$numero"
+								export LC_TIME="en_US.UTF-8"
+								expir_f=$(date '+%d %B %Y' -d "$time_ban days")
+							# Add "1" in SMS_ban_perm table : flood
+								sql_add_ban_perm="connect gammu; INSERT INTO $sms_p (SenderNumber,Perm,Expiration) VALUES ('$numero',1,'$expir_f');"
+								mysql --user=$u_db --password=$p_db -B -se "$sql_add_ban_perm"
+							fi
-							else
+						else
+							date_expiration=$(echo $result_bp | cut -d ' ' -f2,3,4)
+							perm=$(echo $result_bp | cut -d ' ' -f5)
+							export LC_TIME="en_US.UTF-8"
+							date_script=$(date '+%d %B %Y' -d "now")
-							# Autrement, le mot de passe est trop grand ( > un mot )
+							# convert in seconds in order to be able to compare
+							d_exp=$(date --date "$date_expiration" +%s)
+							d_scr=$(date --date "$date_script" +%s)
+							if test $d_scr -ge $d_exp		# Si le ban à expiré
+							then
+							# Test the number of words (result)
+								if [ $nb -eq 2 ]	# Si 2 mots : le mot de passe est manquant
+								then
+								# Add "1" in ban temp table
+								sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');"
+								mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp"
+								elif [ $nb -eq 3 ]	# Si 3 mots : id + mot de passe + numero
+									then
+									date_expiration=$(echo $result_bp | cut -d ' ' -f2,3,4)
+									perm=$(echo $result_bp | cut -d ' ' -f5)
+									date_script=$(date '+%d %B %Y' -d "now")
-								# On incrémente d'un 1 dans la table des bans temp
+									# convert in seconds in order to be able to compare
+									d_exp=$(date --date "$date_expiration" +%s)
+									d_scr=$(date --date "$date_script" +%s)
+									export pass=$(echo $result | cut -d ' ' -f3)
+									pass_salt=$(perl -e'print crypt($ARGV[0],$ARGV[1])' $pass $salt)
+									export LC_TIME="en_US.UTF-8"
+									expir=$(date '+%d %B %Y' -d "$time_account days")
+									supp_acc_rad "$numero"
+									add_acc_rad "$numero" "$pass_salt" "$expir"
+									supp_num_temp "$numero"
+									supp_num_perm "$numero"
+									add_num_perm "$numero" "$expir"
+								else
+								# number of words to big (> 3)
+								# Add "1" in bans temp table
 									sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');"
 									mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp"
 									echo "Mot de passe incorrect, ajout du numero en ban temporaire"
-							fi
+								fi
-							# On gère les bans temp en ban perm
+							# manage bans_temp & ban_perm
 								sql_select_temp="connect gammu; SELECT ID FROM $sms_t WHERE SenderNumber='$numero'"
 								r_select_temp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_select_temp")
 								nb_ban_t=$(echo $r_select_temp| wc -w)
-							if [ $nb_ban_t -ge $nb_essais ]
+								if [ $nb_ban_t -ge $nb_essais ]
-							then
+								then
-								supp_num_perm "$numero"
+									supp_num_perm "$numero"
-								supp_num_temp "$numero"
+									supp_num_temp "$numero"
 									export LC_TIME="en_US.UTF-8"
 									expir_f=$(date '+%d %B %Y' -d "$time_ban days")
-								# Ajout du numero table SMS_ban_perm, 1 : flood
+									# Add phne number in ban_perm : flood
-									sql_add_ban_perm="connect gammu; INSERT INTO $sms_p (SenderNumber,Perm,Expiration) VALUES ('$numero',1,'$expir_f');"							mysql --user=$u_db --password=$p_db -B -se "$sql_add_ban_perm"
+									sql_add_ban_perm="connect gammu; INSERT INTO $sms_p (SenderNumber,Perm,Expiration) VALUES ('$numero',1,'$expir_f');"
+									mysql --user=$u_db --password=$p_db -B -se "$sql_add_ban_perm"
+								fi
+							else
+									echo "Le ban de $numero est encore valide"
 							fi
-						else
-							echo "Le ban de $numero est encore valide"
-						fi
 						break
-					fi
+						fi
-				#else
+					#else
 					#echo "Pays bloqué"
-				fi
+					fi
-			done
+				done
-		else
+			else
-			echo "Numero non autorisé (ex: 36665)"
+				echo "Numero non autorisé (ex: 36665)"
-		fi
+			fi
-				# On supprime la ligne d'ID=$id dans inbox
+			# On supprime la ligne d'ID=$id dans inbox
-				mysql --user=$u_db --password=$p_db -B -e "$sql_delete_inbox WHERE ID=$id;"
+			mysql --user=$u_db --password=$p_db -B -e "$sql_delete_inbox WHERE ID=$id;"
 		done
 } # end function new_sms
 # CORE
 	-h | --help)
 		echo "$usage"
 		exit 0
 		;;
 	--start)
+		failed="0"
+		comports=`ls -l /dev/ttyUSB* 2>/dev/null | wc -l`
+		if [ $comports == "0" ]
+		then
+			echo "No GSM modem found."
+			failed="1"
+		fi
+		if [ -z "$(grep '^SMS_NUM=' $CONF_FILE | cut -d'=' -f2-)" ]; then
+			echo 'The phone number is not set.'
+			failed="1"
+		fi
+		if [ $failed == "1" ]
+		then
+			sed -i "s/^SMS=.*/SMS=off/" $CONF_FILE
+			exit 0
+		fi
 		gammu_pid=`/usr/sbin/pidof gammu-smsd|wc -l`
 		if [ $gammu_pid != "0" ]
-			then
+		then
-			echo "gammu is already started"
+			echo "Gammu is already started"
 		else
 			start_gammu
+			sleep 1
+			is_active=`systemctl is-active gammu-smsd`
+			if [ $is_active == "active" ]
+			then
+				sed -i "s/^SMS=.*/SMS=on/" $CONF_FILE
+			else
+				sed -i "s/^SMS=.*/SMS=off/" $CONF_FILE
+			fi
 		fi
-		sed -i "s/^SMS=.*/SMS=on/" $CONF_FILE
 		exit 0
 		;;
 	--stop)
 		gammu_pid=`/usr/sbin/pidof gammu-smsd|wc -l`
 		if [ $gammu_pid != "0" ]
-			then
+		then
 			stop_gammu
 		else
-			echo "gammu is already stopped"
+			echo "Gammu is already stopped"
 		fi
 		sed -i "s/^SMS=.*/SMS=off/" $CONF_FILE
 		exit 0
 		;;
 	--pidof)

Subversion Repositories ALCASAR

(root)/scripts/alcasar-sms.sh – Rev 2631 → 2875