Gecko [ sacpinlaptop.com ]

Name	Size	Permission	Date
checkdisk2	[ DIR ]	drwxr-xr-x	2026-07-26 09:09
check_all_mysql_db_sizes.sh	1.77 KB	-rwxr-xr-x	2025-07-24 18:31
check_avail_backup.sh	2.34 KB	-rwx------	2026-03-19 00:44
check_disk.sh	3.45 KB	-rwxr-xr-x	2025-10-27 01:19
check_disk.sh.1108902.2025-08-23@08:17:25~	8.85 KB	-rwxr-xr-x	2025-08-11 17:34
check_disk.sh.3561032.2025-08-12@00:34:45~	8.94 KB	-rwxr-xr-x	2025-07-25 01:10
check_disk.sh.531086.2025-10-27@08:19:41~	8.85 KB	-rwxr-xr-x	2025-08-23 01:17
check_disk_health.sh	2.87 KB	-rwx------	2026-03-13 03:59
checkbk.sh	1.84 KB	-rwx------	2025-12-29 06:46
collect_cpanel_full_info.sh	5.38 KB	-rwx------	2026-01-29 03:47
get_the_domains.sh	398 B	-rwx------	2026-06-25 10:02
hosting_full.json	179.97 KB	-rw-------	2026-09-25 18:00
report-backup.sh	1.9 KB	-rwxr-xr-x	2025-05-24 03:57
sync_backup.sh	2.18 KB	-rwxr-xr-x	2026-04-09 01:39

Rename

#!/bin/bash

# === CẤU HÌNH ===
THRESHOLD=100
NOW=$(date +%Y%m%d_%H%M%S)
HOSTNAME=$(hostname)
SERVER_IP=$(curl -s ifconfig.me || curl -s ipinfo.io/ip)
REPORT="/tmp/disk_quota_$NOW.csv"
WARN_LOG_DIR="/root/quota_warnings"
mkdir -p "$WARN_LOG_DIR"

# === TELEGRAM CONFIG ===
BOT_TOKEN="7890861654:AAHycMrSoVHiOGgNdxfNxDbNOsFIAq-B_-U"
CHAT_ID="-4815715104"

# === EMAIL SMTP CONFIG ===
SMTP_SERVER="smtp.gmail.com"
SMTP_PORT="587"
USERNAME="manhdh@nhanhoa.com.vn"
PASSWORD="vwrc iorm efbn ymjz"

FROM_NAME="Đặng Hồng Mạnh"
FROM_EMAIL="manhdh@nhanhoa.com.vn"
#FROM="${FROM_NAME} <${FROM_EMAIL}>"
FROM="manhdh@nhanhoa.com.vn"
CC1="salesgroup@nhanhoa.com.vn"
CC2="hn.cskh@nhanhoa.com.vn"
CC3="daily@nhanhoa.com.vn"
CC4=""
HTML_TEMPLATE="/opt/nhanhoa/warning_template.html"
TEMPLATE_PATH="/opt/nhanhoa/warning_template.html"
USER_WARN_FILE="/tmp/mail_${USER}.html"

# === BẮT ĐẦU KIỂM TRA ===
echo "User;Domain;Used (MB);Quota (MB);Percent Used;IP Server;Email" > "$REPORT"

for USER in $(ls /var/cpanel/users); do

# Bỏ qua nếu tài khoản đã bị suspend
    suspended=$(whmapi1 accountsummary user=$USER | grep -i suspended | awk '{print $2}')
    if [[ "$suspended" == "1" ]]; then
        echo "🔕 Bỏ qua $USER vì đã bị suspend."
        continue
    fi

DOMAIN=$(grep "^DNS=" /var/cpanel/users/$USER | cut -d= -f2)
    EMAIL_TO=$(grep "^CONTACTEMAIL=" /var/cpanel/users/$USER | cut -d= -f2)
    #Email test
    #EMAIL_TO="info@thichnoitro.com"

PLAN=$(grep "^PLAN=" /var/cpanel/users/$USER | cut -d= -f2)

# Tính dung lượng
    HOME_MB=$(du -sm /home/$USER 2>/dev/null | awk '{print $1}')
    MYSQL_MB=0
    # Lấy danh sách tất cả database
    ALL_DBS=$(mysql -N -B -e "SHOW DATABASES;" | grep -Ev "^(information_schema|performance_schema|mysql|sys)$")

for DB in $ALL_DBS; do
        # Nếu DB thuộc user (kiểu prefix giống user)
        if [[ "$DB" == ${USER}_* ]]; then
            size_bytes=$(mysql -N -B -e "SELECT SUM(data_length + index_length) FROM information_schema.tables WHERE table_schema='$DB';")          
            # Nếu có dữ liệu
            if [[ "$size_bytes" =~ ^[0-9]+$ && "$size_bytes" -gt 0 ]]; then
                size_mb=$(awk "BEGIN {printf \"%.0f\", $size_bytes / 1024 / 1024}")
                MYSQL_MB=$((MYSQL_MB + size_mb))
            fi
        fi
    done

TOTAL_MB=$((HOME_MB + MYSQL_MB))

# Lấy quota
    QUOTA_LINE=$(quota -u "$USER" 2>/dev/null | grep "/dev/sdb1")
    LIMIT_BLOCKS=$(echo "$QUOTA_LINE" | awk '{print $4}')

if [[ "$LIMIT_BLOCKS" =~ ^[0-9]+$ && "$LIMIT_BLOCKS" -gt 0 ]]; then
        QUOTA_MB=$((LIMIT_BLOCKS / 1024))
        PERCENT=$(awk "BEGIN {printf \"%.2f\", ($TOTAL_MB/$QUOTA_MB)*100}")
        
        #echo "$USER;$DOMAIN;$TOTAL_MB;$QUOTA_MB;$PERCENT%;$SERVER_IP;$EMAIL_CUS"

fi
    fi
done

# === GỬI BÁO CÁO QUA TELEGRAM ===
if [ $(wc -l < "$REPORT") -gt 1 ]; then
    MSG="🚨 *Cảnh báo vượt ${THRESHOLD}% DUNG LƯỢNG!* 🖥️ Server: \`$HOSTNAME\` 🌐 IP: \`$SERVER_IP\`"
    curl -s -X POST "https://api.telegram.org/bot$BOT_TOKEN/sendMessage" \
         -d chat_id="$CHAT_ID" \
         -d parse_mode="Markdown" \
         --data-urlencode "text=$MSG"

curl -s -X POST "https://api.telegram.org/bot$BOT_TOKEN/sendDocument" \
         -F chat_id="$CHAT_ID" \
         -F document=@"$REPORT" \
         -F caption="📄 Danh sách user vượt dung lượng ngày: $NOW"
else
    echo "✅ Không có user nào vượt quota."
fi