Our script will fetch this data, parse it, store it in a database, and log operations for troubleshooting.<\/p>\n\n\n\n
Step 1: Designing the Script<\/h2>\n\n\n\n
The kannel_monitor.php script will:<\/p>\n\n\n\n
- \n
- Fetch Kannel status data using file_get_contents.<\/li>\n\n\n\n
- Parse metrics (SMSC connections, SMS, and DLR) using regular expressions.<\/li>\n\n\n\n
- Store the data in a MySQL database.<\/li>\n\n\n\n
- Log operations to \/var\/log\/kannel_monitor.log.<\/li>\n\n\n\n
- Run every 5 minutes via a cron job.
<\/li>\n<\/ul>\n\n\n\n<?php\n\n\/\/ Fetch status text\n$context = stream_context_create([\n 'ssl' => [\n 'verify_peer' => true,\n 'verify_peer_name' => true\n ]\n]);\n$statusText = @file_get_contents($kannelUrl, false, $context);\nif ($statusText === false) {\n $error = error_get_last();\n error_log(\"Failed to fetch status from $kannelUrl: \" . ($error['message'] ?? 'Unknown error'), 3, $logFile);\n exit(1);\n}\n\n\/\/ Debug: Save response to file\nfile_put_contents(__DIR__ . '\/debug_kannel_status.html', $statusText);\n\n\/\/ Validate response\nif (strpos($statusText, 'Kannel bearerbox version') === false && strpos($statusText, 'SMSC:') === false) {\n error_log(\"Invalid response: Kannel status not found. Check URL or response format.\", 3, $logFile);\n exit(1);\n}\n\n\/\/ Initialize metrics\n$smsReceivedTotal = 0;\n$smsSentTotal = 0;\n$smsQueuedReceived = 0;\n$smsQueuedSent = 0;\n$smsInboundRateAvg = 0.0;\n$smsOutboundRateAvg = 0.0;\n$dlrReceivedTotal = 0;\n$dlrSentTotal = 0;\n$dlrQueued = 0;\n$dlrInboundRateAvg = 0.0;\n$smscRecords = [];\n\n\/\/ Parse SMSC connections\npreg_match_all(\n '\/(\\w+\\[\\w+\\])\\s+(SMPP|HTTP|FAKE):([^:]+):(\\d+)\\\/(\\d+):([^:]*):?(SMPP|XCV)?\\s+\\((\\w+)[^,]+,\\s*rcvd: sms (\\d+).*?\\(([\\d.]+),([\\d.]+),([\\d.]+)\\).*?sent: sms (\\d+).*?\\(([\\d.]+),([\\d.]+),([\\d.]+)\\).*?dlr (\\d+).*?\\(([\\d.]+),([\\d.]+),([\\d.]+)\\).*?failed (\\d+), queued (\\d+)\/',\n $statusText, $smscMatches, PREG_SET_ORDER\n);\nforeach ($smscMatches as $match) {\n $smscRecords[] = [\n 'provider_name' => $match[1],\n 'protocol' => $match[2],\n 'ip_address' => $match[3] == 'generic' ? null : $match[3],'\n 'smsc_status' => $match[8],\n 'provider_sms_received' => (int) $match[9],\n 'provider_dlr_received_rate_avg' => (float) $match[19],\n 'provider_sms_failed' => (int) $match[21],\n 'provider_sms_queued' => (int) $match[22]\n ];\n}\n\n\/\/ Parse aggregate metrics\nif (preg_match('\/SMS: received (\\d+) \\((\\d+) queued\\), sent (\\d+) \\((\\d+) queued\\)\/', $statusText, $matches)) {\n $smsReceivedTotal = (int) $matches[1];\n $smsQueuedReceived = (int) $matches[2];\n $smsSentTotal = (int) $matches[3];\n $smsQueuedSent = (int) $matches[4];\n}\nif (preg_match('\/SMS: inbound \\(([\\d.]+),([\\d.]+),([\\d.]+)\\) msg\\\/sec, outbound \\(([\\d.]+),([\\d.]+),([\\d.]+)\\) msg\\\/sec\/', $statusText, $matches)) {\n $smsInboundRateAvg = (float) $matches[2];\n $smsOutboundRateAvg = (float) $matches[5];\n}\nif (preg_match('\/DLR: received (\\d+), sent (\\d+)\/', $statusText, $matches)) {\n $dlrReceivedTotal = (int) $matches[1];\n $dlrSentTotal = (int) $matches[2];\n}\nif (preg_match('\/DLR: (\\d+) queued\/', $statusText, $matches)) {\n $dlrQueued = (int) $matches[1];\n}\nif (preg_match('\/DLR: inbound \\(([\\d.]+),([\\d.]+),([\\d.]+)\\) msg\\\/sec\/', $statusText, $matches)) {\n $dlrInboundRateAvg = (float) $matches[2];\n}\n\n\/\/ Connect to database\n$db = new mysqli($dbHost, $dbUser, $dbPass, $dbName);\nif ($db->connect_error) {\n error_log(\"DB connection failed: \" . $db->connect_error, 3, $logFile);\n exit(1);\n}\n\n\/\/ Insert records\n$stmt = $db->prepare(\"\n INSERT INTO kannel_monitor (\n timestamp, provider_name, smsc_status, protocol, ip_address, port_transmit, port_receive, system_id,\n provider_sms_received, provider_sms_sent, provider_dlr_received, provider_sms_failed, provider_sms_queued,\n provider_sms_received_rate_avg, provider_sms_sent_rate_avg, provider_dlr_received_rate_avg,\n sms_received_total, sms_sent_total, sms_queued_received, sms_queued_sent,\n sms_inbound_rate_avg, sms_outbound_rate_avg, dlr_received_total, dlr_sent_total, dlr_queued,\n dlr_inbound_rate_avg\n )\n VALUES (NOW(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n\");\nif (!$stmt) {\n error_log(\"Prepare failed: \" . $db->error, 3, $logFile);\n $db->close();\n exit(1);\n}\n\nforeach ($smscRecords as $record) {\n $stmt->bind_param(\n 'ssssiiisiiiidddiiiiddiiid',\n $record['provider_name'],\n $record['smsc_status'],\n $record['protocol'],\n $record['ip_address'],\n $record['port_transmit'],\n $smsQueuedSent,\n $smsInboundRateAvg,\n $smsOutboundRateAvg,\n $dlrReceivedTotal,\n $dlrSentTotal,\n $dlrQueued,\n $dlrInboundRateAvg\n );\n if (!$stmt->execute()) {\n error_log(\"Insert failed for {$record['provider_name']}: \" . $db->error, 3, $logFile);\n break;\n } else {\n error_log(\"Inserted record for {$record['provider_name']}\", 3, $logFile);\n }\n}\n\/\/ Insert aggregate metrics if no SMSC records\nif (empty($smscRecords)) {\n $nullStr = null;\n $nullInt = null;\n $nullFloat = null;\n $stmt->bind_param(\n 'ssssiiisiiiidddiiiiddiiid',\n $nullStr,\n $nullStr,\n $nullStr,\n $nullInt,\n $nullFloat,\n $nullFloat,\n $nullFloat,\n $smsReceivedTotal,\n $smsSentTotal,\n $smsQueuedReceived,\n $smsQueuedSent,\n $smsInboundRateAvg,\n $smsOutboundRateAvg,\n $dlrReceivedTotal,\n $dlrSentTotal,\n $dlrQueued,\n $dlrInboundRateAvg\n );\n if (!$stmt->execute()) {\n error_log(\"Insert failed for aggregate metrics: \" . $db->error, 3, $logFile);\n } else {\n error_log(\"Inserted aggregate metrics\", 3, $logFile);\n }\n}\n\n$stmt->close();\n$db->close();\n\nerror_log(\"Data stored successfully\", 3, $logFile)<\/code><\/pre>\n\n\n\nStep 2: The Script<\/h2>\n\n\n\n
Complete kannel_monitor.php script, which I developed to monitor a Kannel instance at https:\/\/example.com\/?kannel<\/a>. It includes error handling, logging, and validation to avoid issues like the “Invalid response” error I encountered in production.<\/p>\n\n\n\n
Step 3: Setting Up the Environment<\/h2>\n\n\n\n
To run this script in production, follow these steps:<\/p>\n\n\n\n
- \n
- Save the Script<\/strong>: Save the script to
\/var\/www\/html\/scripts\/kannel_monitor.php<\/code>:
Paste the script above and set permissions:chmod 644 \/var\/www\/html\/scripts\/kannel_monitor.php chown www-data:www-data \/var\/www\/html\/scripts\/kannel_monitor.php<\/code><\/li>\n\n\n\n- Create .env File<\/strong>:
KANNEL_URL=https:\/\/example.com\/?<\/code>kannel DB_HOST=localhost <\/code>DB_USER=your_db_user <\/code>DB_PASS=your_db_password <\/code>DB_NAME=your_db_name<\/code><\/li>\n\n\n\n- Create the Log File<\/strong>: Set up
\/var\/log\/kannel_monitor.log<\/code>:sudo touch \/var\/log\/kannel_monitor.log sudo chmod 664 \/var\/log\/kannel_monitor.log sudo chown www-data:www-data \/var\/log\/kannel_monitor.log<\/code><\/li>\n\n\n\n- Set Up the Cron Job<\/strong>: Schedule the script to run every 5 minutes:
crontab -e<\/code> Add:*\/5 * * * * \/usr\/bin\/php \/var\/www\/html\/scripts\/kannel_monitor.php >> \/var\/log\/kannel_monitor.log 2>&1<\/code> Verify:crontab -l<\/code><\/li>\n<\/ol>\n\n\n\nStep 4: Testing the Script<\/h2>\n\n\n\n
Test the script manually:<\/strong><\/p>\n\n\n\n
\/usr\/bin\/php \/var\/www\/html\/scripts\/kannel_monitor.php<\/code><\/pre>\n\n\n\nCheck the log file:<\/strong>
cat \/var\/log\/kannel_monitor.log<\/p>\n\n\n\nExpected output:<\/strong>
Inserted record for provider1[smsc1]
Inserted aggregate metrics
Data stored successfully<\/p>\n\n\n\nIt should contain Kannel status data (e.g., SMSC:, SMS: received).<\/p>\n\n\n\n
Verify database records:<\/strong>
SELECT * FROM kannel_monitor;<\/p>\n\n\n\nWait 5 minutes to confirm the cron job runs, or temporarily set it to run every minute:
* * * * \/usr\/bin\/php \/var\/www\/html\/scripts\/kannel_monitor.php >> \/var\/log\/kannel_monitor.log 2>&1<\/p>\n\n\n\n![\"\"](\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-24-at-4.16.01\u202fPM-1024x410.png\")
<\/a><\/figure>\n\n\n\n
Conclusion<\/h2>\n\n\n\nUsing kannel_monitor.php with a cron job is an easy way to keep track of your SMS gateway. The script grabs, processes, and saves data reliably, with logs to help fix problems.<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
- Create .env File<\/strong>:
- Save the Script<\/strong>: Save the script to