connect_error) {
die("Connection asterisk failed: " . $conn->connect_error);
}
$sql = "select userfield, count(*) as total ";
$sql .= "from cdr ";
$sql .= "where dst like '011%' and ";
$sql .= "calldate >= NOW() - INTERVAL 5 MINUTE ";
$sql .= "group by userfield ";
$sql .= "having total > " . $max_count;
print $sql . "\n";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
print "tenant: " . $row["userfield"]. "total: " . $row["total"] . "\n";
send_mail($row["userfield"], $row["total"]);
}
}
$conn->close();
function send_mail($tenant, $total) {
$to = 'support@wuyifan.com';
$subject = 'Urgent: pbx potential hacked tenant = ' . $tenant;
$message = 'over ' . $total . " international calls in last 5 mins";
$headers = 'From: no-reply@prodosec.com' . "\r\n";
mail($to, $subject, $message, $headers);
}
?>
check number of international calls in last 5 mins, if over max value, send a warning email
Reseller report
#!/bin/bash
user=root
password=hide
database=pbxconf
filename=/home/hide/tenant_report.csv
rm -f "$filename"
mysql --user="$user" --password="$password" --database="$database"<