[2024-06-01 Sat 04:15:25] : *********************** START Send Deviation Alert************************** [2024-06-01 Sat 04:15:25] : 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` = '2024-06-01' ) 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` = '2024-05-31' ) 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 [2024-06-01 Sat 04:15:25] : Total Record Fetch: 12 [2024-06-01 Sat 04:15:25] :

SL	App Store	App Name	App Organization	App Status Type	Status Value as on 2024-06-01	Status Value as on 2024-05-31	Deviation Status
1	Apple I Store	UCB Unet	United Commercial Bank PLC	APP_LAST_UPDATE	2024-05-20	2024-05-20	Matched
2	Apple I Store	UCB Unet	United Commercial Bank PLC	APP_VERSION	2.3.8	2.3.8	Matched
3	Apple I Store	UClick	United Commercial Bank PLC	APP_LAST_UPDATE	2024-03-12	2024-03-12	Matched
4	Apple I Store	UClick	United Commercial Bank PLC	APP_VERSION	1.1.5	1.1.5	Matched
5	Apple I Store	Unet Enterprise Banking	United Commercial Bank PLC	APP_LAST_UPDATE	2023-12-20	2023-12-20	Matched
6	Apple I Store	Unet Enterprise Banking	United Commercial Bank PLC	APP_VERSION	1.1.1	1.1.1	Matched
7	Google Play Store	UClick	United Commercial Bank PLC	APP_LAST_UPDATE	2024-03-11	2024-03-11	Matched
8	Google Play Store	UClick	United Commercial Bank PLC	APP_VERSION	1.1.1.4	1.1.1.4	Matched
9	Google Play Store	Unet	United Commercial Bank PLC	APP_LAST_UPDATE	2024-05-19	2024-05-19	Matched
10	Google Play Store	Unet	United Commercial Bank PLC	APP_VERSION	3.40	3.40	Matched
11	Google Play Store	Unet Enterprise Banking	United Commercial Bank PLC	APP_LAST_UPDATE	2023-12-16	2023-12-16	Matched
12	Google Play Store	Unet Enterprise Banking	United Commercial Bank PLC	APP_VERSION	1.0.21	1.0.21	Matched

[2024-06-01 Sat 04:15:25] : 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 [2024-06-01 Sat 04:15:25] : Connection closed [2024-06-01 Sat 04:15:25] : ************************ END *************************** [2024-06-01 Sat 04:30:02] : *********************** START ************************** [2024-06-01 Sat 04:30:02] : select id, ssl_status_code from ssl_status_code where status='Active' [2024-06-01 Sat 04:30:02] : SSL Status Code Result: 8 [2024-06-01 Sat 04:30:02] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active' [2024-06-01 Sat 04:30:02] : SSL Info Result: 5 [2024-06-01 Sat 04:30:02] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:02] : Batch ID: 2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : Misc Test: 2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php [2024-06-01 Sat 04:30:03] : VALID_FROM [2024-06-01 Sat 04:30:03] : 2024-05-25 00:59:08 [2024-06-01 Sat 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 (1,1,'2024-05-25 00:59:08','2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:03] : 1 [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : Misc Test: 2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php [2024-06-01 Sat 04:30:03] : VALID_TO [2024-06-01 Sat 04:30:03] : 2024-08-23 00:59:07 [2024-06-01 Sat 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 (1,2,'2024-08-23 00:59:07','2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:03] : 1 [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : Misc Test: 2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php [2024-06-01 Sat 04:30:03] : CNAME [2024-06-01 Sat 04:30:03] : ucb.com.bd [2024-06-01 Sat 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 (1,3,'ucb.com.bd','2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:03] : 1 [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : Misc Test: 2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php [2024-06-01 Sat 04:30:03] : SIGNATURE [2024-06-01 Sat 04:30:03] : RSA-SHA256 [2024-06-01 Sat 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 (1,4,'RSA-SHA256','2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:03] : 1 [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : Misc Test: 2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php [2024-06-01 Sat 04:30:03] : SIGNATURE_DESC [2024-06-01 Sat 04:30:03] : sha256WithRSAEncryption [2024-06-01 Sat 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 (1,5,'sha256WithRSAEncryption','2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:03] : 1 [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : Misc Test: 2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php [2024-06-01 Sat 04:30:03] : ISSUER_NAME [2024-06-01 Sat 04:30:03] : Let's Encrypt [2024-06-01 Sat 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 (1,6,'Let\'s Encrypt','2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:03] : 1 [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : Misc Test: 2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php [2024-06-01 Sat 04:30:03] : ISSUER_COUNTRY [2024-06-01 Sat 04:30:03] : US [2024-06-01 Sat 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 (1,7,'US','2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:03] : 1 [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : Misc Test: 2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php [2024-06-01 Sat 04:30:03] : ISSUER_CNAME [2024-06-01 Sat 04:30:03] : R3 [2024-06-01 Sat 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 (1,8,'R3','2024-06-01 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:03] : 1 [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:03] : Batch ID: 2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : VALID_FROM [2024-06-01 Sat 04:30:07] : 2023-12-07 06:00:00 [2024-06-01 Sat 04:30:07] : 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 (2,1,'2023-12-07 06:00:00','2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : VALID_TO [2024-06-01 Sat 04:30:07] : 2024-11-26 05:59:59 [2024-06-01 Sat 04:30:07] : 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 (2,2,'2024-11-26 05:59:59','2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : CNAME [2024-06-01 Sat 04:30:07] : unet.ucb.com.bd [2024-06-01 Sat 04:30:07] : 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 (2,3,'unet.ucb.com.bd','2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : SIGNATURE [2024-06-01 Sat 04:30:07] : RSA-SHA256 [2024-06-01 Sat 04:30:07] : 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 (2,4,'RSA-SHA256','2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : SIGNATURE_DESC [2024-06-01 Sat 04:30:07] : sha256WithRSAEncryption [2024-06-01 Sat 04:30:07] : 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 (2,5,'sha256WithRSAEncryption','2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_NAME [2024-06-01 Sat 04:30:07] : DigiCert Inc [2024-06-01 Sat 04:30:07] : 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 (2,6,'DigiCert Inc','2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_COUNTRY [2024-06-01 Sat 04:30:07] : US [2024-06-01 Sat 04:30:07] : 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 (2,7,'US','2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_CNAME [2024-06-01 Sat 04:30:07] : DigiCert EV RSA CA G2 [2024-06-01 Sat 04:30:07] : 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 (2,8,'DigiCert EV RSA CA G2','2024-06-01 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Batch ID: 2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : VALID_FROM [2024-06-01 Sat 04:30:07] : 2024-03-02 06:00:00 [2024-06-01 Sat 04:30:07] : 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 (4,1,'2024-03-02 06:00:00','2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : VALID_TO [2024-06-01 Sat 04:30:07] : 2025-04-03 05:59:59 [2024-06-01 Sat 04:30:07] : 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 (4,2,'2025-04-03 05:59:59','2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : CNAME [2024-06-01 Sat 04:30:07] : infosec4allz.com [2024-06-01 Sat 04:30:07] : 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 (4,3,'infosec4allz.com','2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : SIGNATURE [2024-06-01 Sat 04:30:07] : RSA-SHA256 [2024-06-01 Sat 04:30:07] : 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 (4,4,'RSA-SHA256','2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : SIGNATURE_DESC [2024-06-01 Sat 04:30:07] : sha256WithRSAEncryption [2024-06-01 Sat 04:30:07] : 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 (4,5,'sha256WithRSAEncryption','2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_NAME [2024-06-01 Sat 04:30:07] : Sectigo Limited [2024-06-01 Sat 04:30:07] : 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 (4,6,'Sectigo Limited','2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_COUNTRY [2024-06-01 Sat 04:30:07] : GB [2024-06-01 Sat 04:30:07] : 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 (4,7,'GB','2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_CNAME [2024-06-01 Sat 04:30:07] : Sectigo RSA Domain Validation Secure Server CA [2024-06-01 Sat 04:30:07] : 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 (4,8,'Sectigo RSA Domain Validation Secure Server CA','2024-06-01 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Batch ID: 2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : VALID_FROM [2024-06-01 Sat 04:30:07] : 1970-01-01 06:00:00 [2024-06-01 Sat 04:30:07] : 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 (5,1,'1970-01-01 06:00:00','2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : VALID_TO [2024-06-01 Sat 04:30:07] : 1970-01-01 06:00:00 [2024-06-01 Sat 04:30:07] : 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 (5,2,'1970-01-01 06:00:00','2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : CNAME [2024-06-01 Sat 04:30:07] : [2024-06-01 Sat 04:30:07] : 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 (5,3,'','2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : SIGNATURE [2024-06-01 Sat 04:30:07] : [2024-06-01 Sat 04:30:07] : 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 (5,4,'','2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : SIGNATURE_DESC [2024-06-01 Sat 04:30:07] : [2024-06-01 Sat 04:30:07] : 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 (5,5,'','2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_NAME [2024-06-01 Sat 04:30:07] : [2024-06-01 Sat 04:30:07] : 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 (5,6,'','2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_COUNTRY [2024-06-01 Sat 04:30:07] : [2024-06-01 Sat 04:30:07] : 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 (5,7,'','2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_CNAME [2024-06-01 Sat 04:30:07] : [2024-06-01 Sat 04:30:07] : 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 (5,8,'','2024-06-01 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Batch ID: 2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : VALID_FROM [2024-06-01 Sat 04:30:07] : 2024-05-29 19:16:25 [2024-06-01 Sat 04:30:07] : 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 (7,1,'2024-05-29 19:16:25','2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : VALID_TO [2024-06-01 Sat 04:30:07] : 2024-08-27 19:16:24 [2024-06-01 Sat 04:30:07] : 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 (7,2,'2024-08-27 19:16:24','2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : CNAME [2024-06-01 Sat 04:30:07] : www.dev.infosec4allz.com [2024-06-01 Sat 04:30:07] : 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 (7,3,'www.dev.infosec4allz.com','2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : SIGNATURE [2024-06-01 Sat 04:30:07] : RSA-SHA256 [2024-06-01 Sat 04:30:07] : 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 (7,4,'RSA-SHA256','2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : SIGNATURE_DESC [2024-06-01 Sat 04:30:07] : sha256WithRSAEncryption [2024-06-01 Sat 04:30:07] : 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 (7,5,'sha256WithRSAEncryption','2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_NAME [2024-06-01 Sat 04:30:07] : Let's Encrypt [2024-06-01 Sat 04:30:07] : 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 (7,6,'Let\'s Encrypt','2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_COUNTRY [2024-06-01 Sat 04:30:07] : US [2024-06-01 Sat 04:30:07] : 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 (7,7,'US','2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Misc Test: 2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php [2024-06-01 Sat 04:30:07] : ISSUER_CNAME [2024-06-01 Sat 04:30:07] : R3 [2024-06-01 Sat 04:30:07] : 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 (7,8,'R3','2024-06-01 04:30:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2024-06-01','2024-06-01 04:30:02','2024-05-31 22:30:02','get-ssl-info.php') [2024-06-01 Sat 04:30:07] : 1 [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 04:30:07] : Connection closed [2024-06-01 Sat 04:30:07] : ************************ END *************************** [2024-06-01 Sat 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` = '2024-06-01' AND sis.status_value = '' [2024-06-01 Sat 05:00:02] : *********************** START ************************** [2024-06-01 Sat 05:00:02] : select id, ssl_status_code from ssl_status_code where status='Active' [2024-06-01 Sat 05:00:02] : SSL Status Code Result: 8 [2024-06-01 Sat 05:00:02] : SSL Info Result: 1 [2024-06-01 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 05:00:02] : Batch ID: 2024-06-01 05:00:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 [2024-06-01 Sat 05:00:02] : Empty data fetched!!! [2024-06-01 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> [2024-06-01 Sat 05:00:02] : Connection closed [2024-06-01 Sat 05:00:02] : ************************ END *************************** [2024-06-01 Sat 06:30:02] : *********************** START Send Deviation Alert************************** [2024-06-01 Sat 06:30:02] : 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` = '2024-06-01' ) 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` = '2024-05-31' ) 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 [2024-06-01 Sat 06:30:02] : Total Record Fetch: 40 [2024-06-01 Sat 06:30:02] :

No Mismatch Found!!!

[2024-06-01 Sat 06:30:07] : Mail sent on 2024-06-01 06:30:02 [2024-06-01 Sat 06:30:07] : Connection closed [2024-06-01 Sat 06:30:07] : ************************ END ***************************