[2023-08-07 Mon 04:30:02] : *********************** START **************************
[2023-08-07 Mon 04:30:02] : select id, ssl_status_code from ssl_status_code where status='Active'
[2023-08-07 Mon 04:30:02] : SSL Status Code Result: 8
[2023-08-07 Mon 04:30:02] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active'
[2023-08-07 Mon 04:30:02] : SSL Info Result: 4
[2023-08-07 Mon 04:30:02] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:02] : Batch ID: 2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : Misc Test: 2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2023-08-07 Mon 04:30:08] : VALID_FROM
[2023-08-07 Mon 04:30:08] : 2023-07-30 09:51:41
[2023-08-07 Mon 04:30:08] : 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,'2023-07-30 09:51:41','2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:08] : 1
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : Misc Test: 2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2023-08-07 Mon 04:30:08] : VALID_TO
[2023-08-07 Mon 04:30:08] : 2023-10-28 09:51:40
[2023-08-07 Mon 04:30:08] : 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,'2023-10-28 09:51:40','2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:08] : 1
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : Misc Test: 2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2023-08-07 Mon 04:30:08] : CNAME
[2023-08-07 Mon 04:30:08] : ucb.com.bd
[2023-08-07 Mon 04:30:08] : 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','2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:08] : 1
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : Misc Test: 2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2023-08-07 Mon 04:30:08] : SIGNATURE
[2023-08-07 Mon 04:30:08] : RSA-SHA256
[2023-08-07 Mon 04:30:08] : 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','2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:08] : 1
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : Misc Test: 2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2023-08-07 Mon 04:30:08] : SIGNATURE_DESC
[2023-08-07 Mon 04:30:08] : sha256WithRSAEncryption
[2023-08-07 Mon 04:30:08] : 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','2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:08] : 1
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : Misc Test: 2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2023-08-07 Mon 04:30:08] : ISSUER_NAME
[2023-08-07 Mon 04:30:08] : Let's Encrypt
[2023-08-07 Mon 04:30:08] : 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','2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:08] : 1
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : Misc Test: 2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2023-08-07 Mon 04:30:08] : ISSUER_COUNTRY
[2023-08-07 Mon 04:30:08] : US
[2023-08-07 Mon 04:30:08] : 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','2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:08] : 1
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : Misc Test: 2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2023-08-07 Mon 04:30:08] : ISSUER_CNAME
[2023-08-07 Mon 04:30:08] : R3
[2023-08-07 Mon 04:30:08] : 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','2023-08-07 04:30:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:08] : 1
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:08] : Batch ID: 2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : Misc Test: 2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2023-08-07 Mon 04:30:13] : VALID_FROM
[2023-08-07 Mon 04:30:13] : 2022-11-27 06:00:00
[2023-08-07 Mon 04:30:13] : 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,'2022-11-27 06:00:00','2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:13] : 1
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : Misc Test: 2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2023-08-07 Mon 04:30:13] : VALID_TO
[2023-08-07 Mon 04:30:13] : 2023-12-29 05:59:59
[2023-08-07 Mon 04:30:13] : 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,'2023-12-29 05:59:59','2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:13] : 1
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : Misc Test: 2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2023-08-07 Mon 04:30:13] : CNAME
[2023-08-07 Mon 04:30:13] : unet.ucb.com.bd
[2023-08-07 Mon 04:30:13] : 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','2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:13] : 1
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : Misc Test: 2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2023-08-07 Mon 04:30:13] : SIGNATURE
[2023-08-07 Mon 04:30:13] : RSA-SHA256
[2023-08-07 Mon 04:30:13] : 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','2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:13] : 1
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : Misc Test: 2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2023-08-07 Mon 04:30:13] : SIGNATURE_DESC
[2023-08-07 Mon 04:30:13] : sha256WithRSAEncryption
[2023-08-07 Mon 04:30:13] : 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','2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:13] : 1
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : Misc Test: 2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2023-08-07 Mon 04:30:13] : ISSUER_NAME
[2023-08-07 Mon 04:30:13] : DigiCert Inc
[2023-08-07 Mon 04:30:13] : 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','2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:13] : 1
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : Misc Test: 2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2023-08-07 Mon 04:30:13] : ISSUER_COUNTRY
[2023-08-07 Mon 04:30:13] : US
[2023-08-07 Mon 04:30:13] : 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','2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:13] : 1
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : Misc Test: 2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2023-08-07 Mon 04:30:13] : ISSUER_CNAME
[2023-08-07 Mon 04:30:13] : DigiCert SHA2 Extended Validation Server CA
[2023-08-07 Mon 04:30:13] : 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 SHA2 Extended Validation Server CA','2023-08-07 04:30:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:13] : 1
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:13] : Batch ID: 2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : Misc Test: 2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2023-08-07 Mon 04:30:14] : VALID_FROM
[2023-08-07 Mon 04:30:14] : 2023-07-29 06:00:00
[2023-08-07 Mon 04:30:14] : 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,'2023-07-29 06:00:00','2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:14] : 1
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : Misc Test: 2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2023-08-07 Mon 04:30:14] : VALID_TO
[2023-08-07 Mon 04:30:14] : 2024-02-16 05:59:59
[2023-08-07 Mon 04:30:14] : 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,'2024-02-16 05:59:59','2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:14] : 1
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : Misc Test: 2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2023-08-07 Mon 04:30:14] : CNAME
[2023-08-07 Mon 04:30:14] : infosec4allz.com
[2023-08-07 Mon 04:30:14] : 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','2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:14] : 1
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : Misc Test: 2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2023-08-07 Mon 04:30:14] : SIGNATURE
[2023-08-07 Mon 04:30:14] : RSA-SHA256
[2023-08-07 Mon 04:30:14] : 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','2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:14] : 1
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : Misc Test: 2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2023-08-07 Mon 04:30:14] : SIGNATURE_DESC
[2023-08-07 Mon 04:30:14] : sha256WithRSAEncryption
[2023-08-07 Mon 04:30:14] : 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','2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:14] : 1
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : Misc Test: 2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2023-08-07 Mon 04:30:14] : ISSUER_NAME
[2023-08-07 Mon 04:30:14] : Sectigo Limited
[2023-08-07 Mon 04:30:14] : 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','2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:14] : 1
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : Misc Test: 2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2023-08-07 Mon 04:30:14] : ISSUER_COUNTRY
[2023-08-07 Mon 04:30:14] : GB
[2023-08-07 Mon 04:30:14] : 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','2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:14] : 1
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : Misc Test: 2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2023-08-07 Mon 04:30:14] : ISSUER_CNAME
[2023-08-07 Mon 04:30:14] : Sectigo RSA Domain Validation Secure Server CA
[2023-08-07 Mon 04:30:14] : 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','2023-08-07 04:30:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:14] : 1
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:14] : Batch ID: 2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : Misc Test: 2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2023-08-07 Mon 04:30:16] : VALID_FROM
[2023-08-07 Mon 04:30:16] : 2023-01-15 06:00:00
[2023-08-07 Mon 04:30:16] : 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,'2023-01-15 06:00:00','2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:16] : 1
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : Misc Test: 2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2023-08-07 Mon 04:30:16] : VALID_TO
[2023-08-07 Mon 04:30:16] : 2024-01-08 05:59:59
[2023-08-07 Mon 04:30:16] : 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,'2024-01-08 05:59:59','2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:16] : 1
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : Misc Test: 2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2023-08-07 Mon 04:30:16] : CNAME
[2023-08-07 Mon 04:30:16] : *.upaybd.com
[2023-08-07 Mon 04:30:16] : 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,'*.upaybd.com','2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:16] : 1
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : Misc Test: 2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2023-08-07 Mon 04:30:16] : SIGNATURE
[2023-08-07 Mon 04:30:16] : RSA-SHA256
[2023-08-07 Mon 04:30:16] : 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,'RSA-SHA256','2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:16] : 1
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : Misc Test: 2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2023-08-07 Mon 04:30:16] : SIGNATURE_DESC
[2023-08-07 Mon 04:30:16] : sha256WithRSAEncryption
[2023-08-07 Mon 04:30:16] : 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,'sha256WithRSAEncryption','2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:16] : 1
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : Misc Test: 2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2023-08-07 Mon 04:30:16] : ISSUER_NAME
[2023-08-07 Mon 04:30:16] : DigiCert Inc
[2023-08-07 Mon 04:30:16] : 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,'DigiCert Inc','2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:16] : 1
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : Misc Test: 2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2023-08-07 Mon 04:30:16] : ISSUER_COUNTRY
[2023-08-07 Mon 04:30:16] : US
[2023-08-07 Mon 04:30:16] : 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,'US','2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:16] : 1
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : Misc Test: 2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2023-08-07 Mon 04:30:16] : ISSUER_CNAME
[2023-08-07 Mon 04:30:16] : DigiCert TLS RSA SHA256 2020 CA1
[2023-08-07 Mon 04:30:16] : 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,'DigiCert TLS RSA SHA256 2020 CA1','2023-08-07 04:30:02#WebName_UPay#SSLInfoId_5#WebURL_https://upaybd.com#WebPort_443','2023-08-07','2023-08-07 04:30:02','2023-08-06 22:30:02','get-ssl-info.php')
[2023-08-07 Mon 04:30:16] : 1
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-07 Mon 04:30:16] : Connection closed
[2023-08-07 Mon 04:30:16] : ************************ END ***************************
[2023-08-07 Mon 06:30:02] : *********************** START Send Deviation Alert**************************
[2023-08-07 Mon 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` = '2023-08-07'
				) 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` = '2023-08-06'

				) 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
[2023-08-07 Mon 06:30:02] : Total Record Fetch: 32
[2023-08-07 Mon 06:30:02] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2023-08-07 Mon 06:30:14] : Mail sent on 2023-08-07 06:30:02
[2023-08-07 Mon 06:30:14] : Connection closed
[2023-08-07 Mon 06:30:14] : ************************ END ***************************