[2026-05-25 Mon 04:30:02] : *********************** START **************************
[2026-05-25 Mon 04:30:02] : select id, ssl_status_code from ssl_status_code where status='Active'
[2026-05-25 Mon 04:30:02] : SSL Status Code Result: 8
[2026-05-25 Mon 04:30:02] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active'
[2026-05-25 Mon 04:30:02] : SSL Info Result: 2
[2026-05-25 Mon 04:30:02] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:02] : Batch ID: 2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : Misc Test: 2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-25 Mon 04:30:03] : VALID_FROM
[2026-05-25 Mon 04:30:03] : 2026-05-16 11:56:05
[2026-05-25 Mon 04:30:03] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,1,'2026-05-16 11:56:05','2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:03] : 1
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : Misc Test: 2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-25 Mon 04:30:03] : VALID_TO
[2026-05-25 Mon 04:30:03] : 2026-08-14 11:56:04
[2026-05-25 Mon 04:30:03] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,2,'2026-08-14 11:56:04','2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:03] : 1
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : Misc Test: 2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-25 Mon 04:30:03] : CNAME
[2026-05-25 Mon 04:30:03] : citybankplc.com
[2026-05-25 Mon 04:30:03] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,3,'citybankplc.com','2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:03] : 1
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : Misc Test: 2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-25 Mon 04:30:03] : SIGNATURE
[2026-05-25 Mon 04:30:03] : RSA-SHA256
[2026-05-25 Mon 04:30:03] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,4,'RSA-SHA256','2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:03] : 1
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : Misc Test: 2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-25 Mon 04:30:03] : SIGNATURE_DESC
[2026-05-25 Mon 04:30:03] : sha256WithRSAEncryption
[2026-05-25 Mon 04:30:03] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,5,'sha256WithRSAEncryption','2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:03] : 1
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : Misc Test: 2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-25 Mon 04:30:03] : ISSUER_NAME
[2026-05-25 Mon 04:30:03] : Let's Encrypt
[2026-05-25 Mon 04:30:03] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,6,'Let\'s Encrypt','2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:03] : 1
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : Misc Test: 2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-25 Mon 04:30:03] : ISSUER_COUNTRY
[2026-05-25 Mon 04:30:03] : US
[2026-05-25 Mon 04:30:03] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,7,'US','2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:03] : 1
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : Misc Test: 2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-25 Mon 04:30:03] : ISSUER_CNAME
[2026-05-25 Mon 04:30:03] : R13
[2026-05-25 Mon 04:30:03] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,8,'R13','2026-05-25 04:30:02#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:03] : 1
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:03] : Batch ID: 2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : Misc Test: 2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-25 Mon 04:30:05] : VALID_FROM
[2026-05-25 Mon 04:30:05] : 2025-06-22 06:00:00
[2026-05-25 Mon 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,1,'2025-06-22 06:00:00','2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:05] : 1
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : Misc Test: 2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-25 Mon 04:30:05] : VALID_TO
[2026-05-25 Mon 04:30:05] : 2026-06-22 05:59:59
[2026-05-25 Mon 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,2,'2026-06-22 05:59:59','2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:05] : 1
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : Misc Test: 2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-25 Mon 04:30:05] : CNAME
[2026-05-25 Mon 04:30:05] : www.citytouch.com.bd
[2026-05-25 Mon 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,3,'www.citytouch.com.bd','2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:05] : 1
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : Misc Test: 2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-25 Mon 04:30:05] : SIGNATURE
[2026-05-25 Mon 04:30:05] : RSA-SHA256
[2026-05-25 Mon 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,4,'RSA-SHA256','2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:05] : 1
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : Misc Test: 2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-25 Mon 04:30:05] : SIGNATURE_DESC
[2026-05-25 Mon 04:30:05] : sha256WithRSAEncryption
[2026-05-25 Mon 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,5,'sha256WithRSAEncryption','2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:05] : 1
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : Misc Test: 2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-25 Mon 04:30:05] : ISSUER_NAME
[2026-05-25 Mon 04:30:05] : DigiCert Inc
[2026-05-25 Mon 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,6,'DigiCert Inc','2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:05] : 1
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : Misc Test: 2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-25 Mon 04:30:05] : ISSUER_COUNTRY
[2026-05-25 Mon 04:30:05] : US
[2026-05-25 Mon 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,7,'US','2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:05] : 1
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : Misc Test: 2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-25 Mon 04:30:05] : ISSUER_CNAME
[2026-05-25 Mon 04:30:05] : DigiCert EV RSA CA G2
[2026-05-25 Mon 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,8,'DigiCert EV RSA CA G2','2026-05-25 04:30:02#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 04:30:02','2026-05-24 22:30:02','get-ssl-info.php')
[2026-05-25 Mon 04:30:05] : 1
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 04:30:05] : Connection closed
[2026-05-25 Mon 04:30:05] : ************************ END ***************************
[2026-05-25 Mon 05:00:02] : SELECT DISTINCT si.id, si.website_name, si.website_url, si.`website_port`, si.`website_org`, sis.`executed_date` AS date_bd
		FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
		LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
		WHERE sis.`status`='Active' AND sis.`executed_date` = '2026-05-25' AND sis.status_value = ''
[2026-05-25 Mon 05:00:03] : *********************** START **************************
[2026-05-25 Mon 05:00:03] : There is no empty or blank record!!!
[2026-05-25 Mon 05:00:03] : SSL Info Recheck Result: 0
[2026-05-25 Mon 05:00:03] : ************************ END ***************************
[2026-05-25 Mon 05:19:21] : *********************** START Test Script Checking**************************
[2026-05-25 Mon 05:19:21] : Script Executed Successfully
[2026-05-25 Mon 05:19:21] : ************************ END ***************************
[2026-05-25 Mon 05:23:21] : *********************** START Test Script Checking**************************
[2026-05-25 Mon 05:23:21] : Script Executed Successfully
[2026-05-25 Mon 05:23:21] : ************************ END ***************************
[2026-05-25 Mon 06:30:03] : *********************** START Send Deviation Alert**************************
[2026-05-25 Mon 06:30:03] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT si.id, si.website_name, si.website_url, si.`website_port`, si.`website_org`, ssc.ssl_status_code, ssc.ssl_status_code_desc, sis.status_value, sis.`executed_date` AS date_bd
				FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
				LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
				WHERE sis.`status`='Active' AND sis.`executed_date` = '2026-05-25'
				) t1
				LEFT OUTER JOIN
				(
				SELECT si.id AS id_1, si.website_name AS website_name_1, si.website_url AS website_url_1, si.website_port AS website_port_1, si.`website_org` AS website_org_1, ssc.ssl_status_code AS ssl_status_code_1, ssc.ssl_status_code_desc AS ssl_status_code_desc_1, 
				sis.status_value AS status_value_1, sis.`executed_date` AS date_bd_1
				FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
				LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
				WHERE sis.`status`='Active' AND sis.`executed_date` = '2026-05-24'

				) t2 ON t1.id=t2.id_1 AND t1.ssl_status_code=t2.ssl_status_code_1
				ORDER BY t1.`website_org`, t1.`website_name`, t1.`ssl_status_code`, t1.`date_bd` DESC
[2026-05-25 Mon 06:30:03] : Total Record Fetch: 16
[2026-05-25 Mon 06:30:03] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-05-25 Mon 06:30:04] : Mail sent on 2026-05-25 06:30:03
[2026-05-25 Mon 06:30:04] : Connection closed
[2026-05-25 Mon 06:30:04] : ************************ END ***************************
[2026-05-25 Mon 09:42:02] : *********************** START Data Parsing Error Checker**************************
[2026-05-25 Mon 09:42:02] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-05-25'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-05-25 Mon 09:42:02] : Total Record Fetch: 8
[2026-05-25 Mon 09:42:02] : 2026-05-25 04:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-05-25 Mon 09:42:02] : 2026-05-25 04:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-05-25 Mon 09:42:02] : 2026-05-25 04:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-05-25 Mon 09:42:02] : 2026-05-25 04:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-05-25 Mon 09:42:02] : 2026-05-25 04:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2025-11-12<br />
[2026-05-25 Mon 09:42:02] : 2026-05-25 04:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-05-25 Mon 09:42:02] : 2026-05-25 04:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-02-26<br />
[2026-05-25 Mon 09:42:02] : 2026-05-25 04:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-05-25 Mon 09:42:02] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-05-25 Mon 09:42:02] : Connection closed
[2026-05-25 Mon 09:42:02] : ************************ END ***************************
[2026-05-25 Mon 12:14:06] : *********************** START Send Deviation Alert**************************
[2026-05-25 Mon 12:14:06] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-05-25'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-05-24'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-05-25 Mon 12:14:06] : Total Record Fetch: 8
[2026-05-25 Mon 12:14:06] : <table width="200" border="1" cellspacing="0" cellpadding="0" style="border: 1px solid #000;font-family: Cambria, 'Hoefler Text', 'Liberation Serif', Times, 'Times New Roman', 'serif';font-size: 14px;">
  <tbody style="border: 1px solid #000;">
    <tr>
      <th style="width: 30px">SL</th>
      <th style="width: 180px">App Store</th>
      <th style="width: 300px">App Name</th>
	  <th style="width: 225px">App Organization</th>
	  <th style="width: 160px">App Status Type</th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #00FFFF">2026-05-25</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-05-24</span></th>
	  <th style="width: 160px">Deviation Status</th>
    </tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">1</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">4</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">5</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2025-11-12</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2025-11-12</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">6</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">7</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-02-26</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-02-26</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">8</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr></tbody></table>
[2026-05-25 Mon 12:14:06] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-05-25 Mon 12:14:06] : Connection closed
[2026-05-25 Mon 12:14:06] : ************************ END ***************************
[2026-05-25 Mon 12:14:45] : *********************** START Test Script Checking**************************
[2026-05-25 Mon 12:14:45] : Script Executed Successfully
[2026-05-25 Mon 12:14:45] : ************************ END ***************************
[2026-05-25 Mon 12:16:37] : *********************** START **************************
[2026-05-25 Mon 12:16:37] : select id, ssl_status_code from ssl_status_code where status='Active'
[2026-05-25 Mon 12:16:37] : SSL Status Code Result: 8
[2026-05-25 Mon 12:16:37] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active'
[2026-05-25 Mon 12:16:37] : SSL Info Result: 2
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : Batch ID: 2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : Misc Test: 2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-25 Mon 12:16:37] : VALID_FROM
[2026-05-25 Mon 12:16:37] : 2026-05-16 11:56:05
[2026-05-25 Mon 12:16:37] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,1,'2026-05-16 11:56:05','2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:37] : 1
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : Misc Test: 2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-25 Mon 12:16:37] : VALID_TO
[2026-05-25 Mon 12:16:37] : 2026-08-14 11:56:04
[2026-05-25 Mon 12:16:37] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,2,'2026-08-14 11:56:04','2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:37] : 1
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : Misc Test: 2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-25 Mon 12:16:37] : CNAME
[2026-05-25 Mon 12:16:37] : citybankplc.com
[2026-05-25 Mon 12:16:37] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,3,'citybankplc.com','2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:37] : 1
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : Misc Test: 2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-25 Mon 12:16:37] : SIGNATURE
[2026-05-25 Mon 12:16:37] : RSA-SHA256
[2026-05-25 Mon 12:16:37] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,4,'RSA-SHA256','2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:37] : 1
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : Misc Test: 2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-25 Mon 12:16:37] : SIGNATURE_DESC
[2026-05-25 Mon 12:16:37] : sha256WithRSAEncryption
[2026-05-25 Mon 12:16:37] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,5,'sha256WithRSAEncryption','2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:37] : 1
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : Misc Test: 2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-25 Mon 12:16:37] : ISSUER_NAME
[2026-05-25 Mon 12:16:37] : Let's Encrypt
[2026-05-25 Mon 12:16:37] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,6,'Let\'s Encrypt','2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:37] : 1
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : Misc Test: 2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-25 Mon 12:16:37] : ISSUER_COUNTRY
[2026-05-25 Mon 12:16:37] : US
[2026-05-25 Mon 12:16:37] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,7,'US','2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:37] : 1
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : Misc Test: 2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-25 Mon 12:16:37] : ISSUER_CNAME
[2026-05-25 Mon 12:16:37] : R13
[2026-05-25 Mon 12:16:37] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,8,'R13','2026-05-25 12:16:37#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:37] : 1
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:37] : Batch ID: 2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443
[2026-05-25 Mon 12:16:39] : SELECT DISTINCT si.id, si.website_name, si.website_url, si.`website_port`, si.`website_org`, sis.`executed_date` AS date_bd
		FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
		LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
		WHERE sis.`status`='Active' AND sis.`executed_date` = '2026-05-25' AND sis.status_value = ''
[2026-05-25 Mon 12:16:39] : *********************** START **************************
[2026-05-25 Mon 12:16:39] : There is no empty or blank record!!!
[2026-05-25 Mon 12:16:39] : SSL Info Recheck Result: 0
[2026-05-25 Mon 12:16:39] : ************************ END ***************************
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : Misc Test: 2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-25 Mon 12:16:40] : VALID_FROM
[2026-05-25 Mon 12:16:40] : 2025-06-22 06:00:00
[2026-05-25 Mon 12:16:40] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,1,'2025-06-22 06:00:00','2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:40] : 1
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : Misc Test: 2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-25 Mon 12:16:40] : VALID_TO
[2026-05-25 Mon 12:16:40] : 2026-06-22 05:59:59
[2026-05-25 Mon 12:16:40] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,2,'2026-06-22 05:59:59','2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:40] : 1
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : Misc Test: 2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-25 Mon 12:16:40] : CNAME
[2026-05-25 Mon 12:16:40] : www.citytouch.com.bd
[2026-05-25 Mon 12:16:40] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,3,'www.citytouch.com.bd','2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:40] : 1
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : Misc Test: 2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-25 Mon 12:16:40] : SIGNATURE
[2026-05-25 Mon 12:16:40] : RSA-SHA256
[2026-05-25 Mon 12:16:40] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,4,'RSA-SHA256','2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:40] : 1
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : Misc Test: 2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-25 Mon 12:16:40] : SIGNATURE_DESC
[2026-05-25 Mon 12:16:40] : sha256WithRSAEncryption
[2026-05-25 Mon 12:16:40] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,5,'sha256WithRSAEncryption','2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:40] : 1
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : Misc Test: 2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-25 Mon 12:16:40] : ISSUER_NAME
[2026-05-25 Mon 12:16:40] : DigiCert Inc
[2026-05-25 Mon 12:16:40] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,6,'DigiCert Inc','2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:40] : 1
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : Misc Test: 2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-25 Mon 12:16:40] : ISSUER_COUNTRY
[2026-05-25 Mon 12:16:40] : US
[2026-05-25 Mon 12:16:40] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,7,'US','2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:40] : 1
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : Misc Test: 2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-25 Mon 12:16:40] : ISSUER_CNAME
[2026-05-25 Mon 12:16:40] : DigiCert EV RSA CA G2
[2026-05-25 Mon 12:16:40] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,8,'DigiCert EV RSA CA G2','2026-05-25 12:16:37#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 12:16:37','2026-05-25 12:16:37','get-ssl-info.php')
[2026-05-25 Mon 12:16:40] : 1
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 12:16:40] : Connection closed
[2026-05-25 Mon 12:16:40] : ************************ END ***************************
[2026-05-25 Mon 12:16:41] : *********************** START Data Parsing Error Checker**************************
[2026-05-25 Mon 12:16:41] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-05-25'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-05-25 Mon 12:16:41] : Total Record Fetch: 8
[2026-05-25 Mon 12:16:41] : 2026-05-25 04:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-05-25 Mon 12:16:41] : 2026-05-25 04:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-05-25 Mon 12:16:41] : 2026-05-25 04:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-05-25 Mon 12:16:41] : 2026-05-25 04:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-05-25 Mon 12:16:41] : 2026-05-25 04:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2025-11-12<br />
[2026-05-25 Mon 12:16:41] : 2026-05-25 04:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-05-25 Mon 12:16:41] : 2026-05-25 04:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-02-26<br />
[2026-05-25 Mon 12:16:41] : 2026-05-25 04:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-05-25 Mon 12:16:41] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-05-25 Mon 12:16:41] : Connection closed
[2026-05-25 Mon 12:16:41] : ************************ END ***************************
[2026-05-25 Mon 12:18:43] : *********************** START Send Deviation Alert**************************
[2026-05-25 Mon 12:18:43] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT si.id, si.website_name, si.website_url, si.`website_port`, si.`website_org`, ssc.ssl_status_code, ssc.ssl_status_code_desc, sis.status_value, sis.`executed_date` AS date_bd
				FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
				LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
				WHERE sis.`status`='Active' AND sis.`executed_date` = '2026-05-25'
				) t1
				LEFT OUTER JOIN
				(
				SELECT si.id AS id_1, si.website_name AS website_name_1, si.website_url AS website_url_1, si.website_port AS website_port_1, si.`website_org` AS website_org_1, ssc.ssl_status_code AS ssl_status_code_1, ssc.ssl_status_code_desc AS ssl_status_code_desc_1, 
				sis.status_value AS status_value_1, sis.`executed_date` AS date_bd_1
				FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
				LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
				WHERE sis.`status`='Active' AND sis.`executed_date` = '2026-05-24'

				) t2 ON t1.id=t2.id_1 AND t1.ssl_status_code=t2.ssl_status_code_1
				ORDER BY t1.`website_org`, t1.`website_name`, t1.`ssl_status_code`, t1.`date_bd` DESC
[2026-05-25 Mon 12:18:44] : Total Record Fetch: 16
[2026-05-25 Mon 12:18:44] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-05-25 Mon 12:18:44] : Mail sent on 2026-05-25 12:18:43
[2026-05-25 Mon 12:18:44] : Connection closed
[2026-05-25 Mon 12:18:44] : ************************ END ***************************
[2026-05-25 Mon 16:59:18] : *********************** START Send Deviation Alert**************************
[2026-05-25 Mon 16:59:18] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-05-25'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-05-24'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-05-25 Mon 16:59:18] : Total Record Fetch: 8
[2026-05-25 Mon 16:59:18] : <table width="200" border="1" cellspacing="0" cellpadding="0" style="border: 1px solid #000;font-family: Cambria, 'Hoefler Text', 'Liberation Serif', Times, 'Times New Roman', 'serif';font-size: 14px;">
  <tbody style="border: 1px solid #000;">
    <tr>
      <th style="width: 30px">SL</th>
      <th style="width: 180px">App Store</th>
      <th style="width: 300px">App Name</th>
	  <th style="width: 225px">App Organization</th>
	  <th style="width: 160px">App Status Type</th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #00FFFF">2026-05-25</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-05-24</span></th>
	  <th style="width: 160px">Deviation Status</th>
    </tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">1</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">4</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">5</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2025-11-12</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2025-11-12</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">6</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">7</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-02-26</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-02-26</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">8</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr></tbody></table>
[2026-05-25 Mon 16:59:18] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-05-25 Mon 16:59:18] : Connection closed
[2026-05-25 Mon 16:59:18] : ************************ END ***************************
[2026-05-25 Mon 18:05:44] : *********************** START **************************
[2026-05-25 Mon 18:05:44] : select id, ssl_status_code from ssl_status_code where status='Active'
[2026-05-25 Mon 18:05:44] : SSL Status Code Result: 8
[2026-05-25 Mon 18:05:44] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active'
[2026-05-25 Mon 18:05:44] : SSL Info Result: 2
[2026-05-25 Mon 18:05:44] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:44] : Batch ID: 2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : Misc Test: 2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-25 Mon 18:05:45] : VALID_FROM
[2026-05-25 Mon 18:05:45] : 2026-05-16 11:56:05
[2026-05-25 Mon 18:05:45] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,1,'2026-05-16 11:56:05','2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:45] : 1
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : Misc Test: 2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-25 Mon 18:05:45] : VALID_TO
[2026-05-25 Mon 18:05:45] : 2026-08-14 11:56:04
[2026-05-25 Mon 18:05:45] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,2,'2026-08-14 11:56:04','2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:45] : 1
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : Misc Test: 2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-25 Mon 18:05:45] : CNAME
[2026-05-25 Mon 18:05:45] : citybankplc.com
[2026-05-25 Mon 18:05:45] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,3,'citybankplc.com','2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:45] : 1
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : Misc Test: 2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-25 Mon 18:05:45] : SIGNATURE
[2026-05-25 Mon 18:05:45] : RSA-SHA256
[2026-05-25 Mon 18:05:45] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,4,'RSA-SHA256','2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:45] : 1
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : Misc Test: 2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-25 Mon 18:05:45] : SIGNATURE_DESC
[2026-05-25 Mon 18:05:45] : sha256WithRSAEncryption
[2026-05-25 Mon 18:05:45] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,5,'sha256WithRSAEncryption','2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:45] : 1
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : Misc Test: 2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-25 Mon 18:05:45] : ISSUER_NAME
[2026-05-25 Mon 18:05:45] : Let's Encrypt
[2026-05-25 Mon 18:05:45] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,6,'Let\'s Encrypt','2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:45] : 1
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : Misc Test: 2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-25 Mon 18:05:45] : ISSUER_COUNTRY
[2026-05-25 Mon 18:05:45] : US
[2026-05-25 Mon 18:05:45] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,7,'US','2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:45] : 1
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : Misc Test: 2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-25 Mon 18:05:45] : ISSUER_CNAME
[2026-05-25 Mon 18:05:45] : R13
[2026-05-25 Mon 18:05:45] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (8,8,'R13','2026-05-25 18:05:44#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:45] : 1
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:45] : Batch ID: 2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : Misc Test: 2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-25 Mon 18:05:46] : VALID_FROM
[2026-05-25 Mon 18:05:46] : 2025-06-22 06:00:00
[2026-05-25 Mon 18:05:46] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,1,'2025-06-22 06:00:00','2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:46] : 1
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : Misc Test: 2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-25 Mon 18:05:46] : VALID_TO
[2026-05-25 Mon 18:05:46] : 2026-06-22 05:59:59
[2026-05-25 Mon 18:05:46] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,2,'2026-06-22 05:59:59','2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:46] : 1
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : Misc Test: 2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-25 Mon 18:05:46] : CNAME
[2026-05-25 Mon 18:05:46] : www.citytouch.com.bd
[2026-05-25 Mon 18:05:46] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,3,'www.citytouch.com.bd','2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:46] : 1
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : Misc Test: 2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-25 Mon 18:05:46] : SIGNATURE
[2026-05-25 Mon 18:05:46] : RSA-SHA256
[2026-05-25 Mon 18:05:46] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,4,'RSA-SHA256','2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:46] : 1
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : Misc Test: 2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-25 Mon 18:05:46] : SIGNATURE_DESC
[2026-05-25 Mon 18:05:46] : sha256WithRSAEncryption
[2026-05-25 Mon 18:05:46] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,5,'sha256WithRSAEncryption','2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:46] : 1
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : Misc Test: 2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-25 Mon 18:05:46] : ISSUER_NAME
[2026-05-25 Mon 18:05:46] : DigiCert Inc
[2026-05-25 Mon 18:05:46] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,6,'DigiCert Inc','2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:46] : 1
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : Misc Test: 2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-25 Mon 18:05:46] : ISSUER_COUNTRY
[2026-05-25 Mon 18:05:46] : US
[2026-05-25 Mon 18:05:46] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,7,'US','2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:46] : 1
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : Misc Test: 2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-25 Mon 18:05:46] : ISSUER_CNAME
[2026-05-25 Mon 18:05:46] : DigiCert EV RSA CA G2
[2026-05-25 Mon 18:05:46] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (9,8,'DigiCert EV RSA CA G2','2026-05-25 18:05:44#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-25','2026-05-25 18:05:44','2026-05-25 18:05:44','get-ssl-info.php')
[2026-05-25 Mon 18:05:46] : 1
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-25 Mon 18:05:46] : Connection closed
[2026-05-25 Mon 18:05:46] : ************************ END ***************************
[2026-05-25 Mon 18:07:08] : SELECT DISTINCT si.id, si.website_name, si.website_url, si.`website_port`, si.`website_org`, sis.`executed_date` AS date_bd
		FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
		LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
		WHERE sis.`status`='Active' AND sis.`executed_date` = '2026-05-25' AND sis.status_value = ''
[2026-05-25 Mon 18:07:08] : *********************** START **************************
[2026-05-25 Mon 18:07:08] : There is no empty or blank record!!!
[2026-05-25 Mon 18:07:08] : SSL Info Recheck Result: 0
[2026-05-25 Mon 18:07:08] : ************************ END ***************************