| Server IP : 172.67.201.108 / Your IP : 216.73.216.11 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /opt/sisimai/ |
Upload File : |
#!/bin/bash
read STARTDATE ENDDATE a b TOTAL c <<<$( /usr/sbin/mailstats -p | /bin/awk 'BEGIN { ORS=" " }; {print $1" "$2" "$4'})
Emails="[email protected],[email protected]"
read a count <<< $(/usr/bin/mysql -uadmin -hamazonaurora.cluster-ro-cemzxojvmybt.us-east-1.rds.amazonaws.com -pxxatN6Lb8Kbwb9MiU1At sisimai -e 'SELECT COUNT(DISTINCT `recipient`) AS count FROM `bounces` WHERE reason <> "vacation" and reason <> "networkerror" and reason <> "blocked" and reason <> "mailboxfull" AND `timestamp` BETWEEN '$STARTDATE' AND '$ENDDATE'')
if [ $TOTAL -gt 0 ]
then
bounce_ratio=`/bin/echo "scale = 5; $count * 1000 / $TOTAL" | /usr/bin/bc`
echo `/bin/date` " -- Bounce ratio between" `/bin/date +"%Y-%m-%d %H:%m:%S" -d @$STARTDATE`" and "`/bin/date +"%Y-%m-%d %H:%m:%S" -d @$ENDDATE`" is $bounce_ratio" >> /var/log/bounce-ratio.log
if (( $(echo "$bounce_ratio > 10.0" | /usr/bin/bc -l) )); then
echo "Bounce ratio between" `/bin/date +"%Y-%m-%d %H:%m:%S" -d @$STARTDATE`" and "`/bin/date +"%Y-%m-%d %H:%m:%S" -d @$ENDDATE`" is $bounce_ratio" | /bin/mail -s "Alert: Updates Bounce ratio" $Emails
fi
else
echo "No data to process"
fi