unknown Archives - New and Fresh Private + Public Proxies Lists Everyday!

Windows Installer Unknown publisher client machine

Client Machine Publisher Name didnot show

I have a number client machines
it’s not possible to install each machine CA certificate
How to install client machine CA certificate in single time ?

spam – Postfix – Relay access denied, disconnect from unknown IP, RCPT from unknown IP spameri@tiscali.it

I have Postfix installed in my cloud server. I got tons of warning in my mail log:

Nov 26 18:37:56 ubuntu-4gb-fsn1-1 postfix/smtpd(66066): warning: hostname ip-113-120.4vendeta.com does not resolve to address 78.128.113.120: Name or service not known
Nov 26 18:37:56 ubuntu-4gb-fsn1-1 postfix/smtpd(66066): connect from unknown(78.128.113.120)
Nov 26 18:37:57 ubuntu-4gb-fsn1-1 postfix/smtpd(66066): lost connection after EHLO from unknown(78.128.113.120)
Nov 26 18:37:57 ubuntu-4gb-fsn1-1 postfix/smtpd(66066): disconnect from unknown(78.128.113.120) ehlo=1 commands=1
Nov 26 18:41:17 ubuntu-4gb-fsn1-1 postfix/anvil(66068): statistics: max connection rate 1/60s for (smtp:78.128.113.120) at Nov 26 18:37:56
Nov 26 18:41:17 ubuntu-4gb-fsn1-1 postfix/anvil(66068): statistics: max connection count 1 for (smtp:78.128.113.120) at Nov 26 18:37:56
Nov 26 18:41:17 ubuntu-4gb-fsn1-1 postfix/anvil(66068): statistics: max cache size 1 at Nov 26 18:37:56
Nov 26 19:28:48 ubuntu-4gb-fsn1-1 postfix/smtpd(66634): connect from unknown(165.231.143.37)
Nov 26 19:28:50 ubuntu-4gb-fsn1-1 postfix/smtpd(66634): NOQUEUE: reject: RCPT from unknown(165.231.143.37): 454 4.7.1 <spameri@tiscali.it>: Relay access denied; from=<spameri@tiscali.it> to=<spameri@tiscali.it> proto=ESMTP helo=<WIN-QGFOVKPDT6T>
Nov 26 19:28:51 ubuntu-4gb-fsn1-1 postfix/smtpd(66634): disconnect from unknown(165.231.143.37) ehlo=1 mail=1 rcpt=0/1 rset=1 quit=1 commands=4/5
Nov 26 19:30:00 ubuntu-4gb-fsn1-1 postfix/smtpd(66634): connect from unknown(165.231.143.37)
Nov 26 19:30:02 ubuntu-4gb-fsn1-1 postfix/smtpd(66634): NOQUEUE: reject: RCPT from unknown(165.231.143.37): 454 4.7.1 <spameri@tiscali.it>: Relay access denied; from=<spameri@tiscali.it> to=<spameri@tiscali.it> proto=ESMTP helo=<WIN-QGFOVKPDT6T>
Nov 26 19:30:05 ubuntu-4gb-fsn1-1 postfix/smtpd(66634): disconnect from unknown(165.231.143.37) ehlo=1 mail=1 rcpt=0/1 rset=1 quit=1 commands=4/5
Nov 26 19:32:24 ubuntu-4gb-fsn1-1 postfix/smtpd(66651): connect from unknown(165.231.143.37)
Nov 26 19:32:27 ubuntu-4gb-fsn1-1 postfix/smtpd(66651): NOQUEUE: reject: RCPT from unknown(165.231.143.37): 454 4.7.1 <spameri@tiscali.it>: Relay access denied; from=<spameri@tiscali.it> to=<spameri@tiscali.it> proto=ESMTP helo=<WIN-QGFOVKPDT6T>
Nov 26 19:32:27 ubuntu-4gb-fsn1-1 postfix/smtpd(66651): disconnect from unknown(165.231.143.37) ehlo=1 mail=1 rcpt=0/1 rset=1 quit=1 commands=4/5
Nov 26 19:35:47 ubuntu-4gb-fsn1-1 postfix/anvil(66636): statistics: max connection rate 1/60s for (smtp:165.231.143.37) at Nov 26 19:28:48
Nov 26 19:35:47 ubuntu-4gb-fsn1-1 postfix/anvil(66636): statistics: max connection count 1 for (smtp:165.231.143.37) at Nov 26 19:28:48
Nov 26 19:35:47 ubuntu-4gb-fsn1-1 postfix/anvil(66636): statistics: max cache size 1 at Nov 26 19:28:48
Nov 26 19:37:55 ubuntu-4gb-fsn1-1 postfix/smtpd(66673): connect from unknown(165.231.143.37)
Nov 26 19:40:32 ubuntu-4gb-fsn1-1 postfix/smtpd(66673): NOQUEUE: reject: RCPT from unknown(165.231.143.37): 454 4.7.1 <spameri@tiscali.it>: Relay access denied; from=<spameri@tiscali.it> to=<spameri@tiscali.it> proto=ESMTP helo=<WIN-QGFOVKPDT6T>
Nov 26 19:42:32 ubuntu-4gb-fsn1-1 postfix/smtpd(66673): disconnect from unknown(165.231.143.37) ehlo=1 mail=1 rcpt=0/1 rset=1 quit=1 commands=4/5
Nov 26 19:45:52 ubuntu-4gb-fsn1-1 postfix/anvil(66675): statistics: max connection rate 1/60s for (smtp:165.231.143.37) at Nov 26 19:37:55
Nov 26 19:45:52 ubuntu-4gb-fsn1-1 postfix/anvil(66675): statistics: max connection count 1 for (smtp:165.231.143.37) at Nov 26 19:37:55
Nov 26 19:45:52 ubuntu-4gb-fsn1-1 postfix/anvil(66675): statistics: max cache size 1 at Nov 26 19:37:55
Nov 26 19:49:51 ubuntu-4gb-fsn1-1 postfix/smtpd(66811): warning: hostname ip-113-121.4vendeta.com does not resolve to address 78.128.113.121: Name or service not known
Nov 26 19:49:51 ubuntu-4gb-fsn1-1 postfix/smtpd(66811): connect from unknown(78.128.113.121)
Nov 26 19:49:51 ubuntu-4gb-fsn1-1 postfix/smtpd(66811): lost connection after EHLO from unknown(78.128.113.121)
Nov 26 19:49:51 ubuntu-4gb-fsn1-1 postfix/smtpd(66811): disconnect from unknown(78.128.113.121) ehlo=1 commands=1
Nov 26 19:53:11 ubuntu-4gb-fsn1-1 postfix/anvil(66813): statistics: max connection rate 1/60s for (smtp:78.128.113.121) at Nov 26 19:49:51
Nov 26 19:53:11 ubuntu-4gb-fsn1-1 postfix/anvil(66813): statistics: max connection count 1 for (smtp:78.128.113.121) at Nov 26 19:49:51
Nov 26 19:53:11 ubuntu-4gb-fsn1-1 postfix/anvil(66813): statistics: max cache size 1 at Nov 26 19:49:51

Should I do anything about this? They look like spams. How do they get into my server’s mail log?

multi factor – Received Google 2FA Code via SMS from two unknown phone numbers

I recently encountered a strange incident regarding the 2FA of my Google Account.

The user Dunois has described a very similar occurrence in this post: Functional Google 2FA code (via SMS) received from a random (but in use) mobile phone number

My experience is a bit different, in the the code itself is also suspicious.

The other day, I set up 2FA for the Google Workspace Account that I use at work. I (foolishly) chose the SMS option, and entered my phone number. The code that I received didn’t come from the usual phone number simply marked as “Google”, but from what appeared to be a regular phone number from the UK (+447907180…, apparently an O2 number). Also it didn’t come with the usual message (“G-###### is your…), it simply had six digits in it, with no further message.

I didn’t use the code, because it just freaked me out a bit. Instead I requested another code, this time receiving a message from the usual “Google” number. I had not switched websites, I literally clicked the same button twice, receiving messages from two different numbers. I can also rule out falling for a spoofed website, since I’ve navigated to my account settings from my Gmail, which I have saved as a bookmark in my browser.

The next day, I tried to reproduce the same thing with my private Google account, which already had 2FA activated. When I switched it to SMS, the same thing happened again:

enter image description here

This time the code came from a German number (I live in Germany), but had the same format as the last one. Again though, I didn’t enter the code.
On both accounts I haven’t been able to receive another message from the two numbers since. Every time I request a new code, it will come from the old “Google” number. Friends that tried it for themselves were getting the regular messages as well.

My Google account shows no suspicious activity, I am not missing any data, nor have I been locked out of either my accounts.

I called both numbers, the German one seems to be active, but goes straight to voicemail. The British one is apparently unknown by my provider T-Mobile.

So my question is: Do I have to worry about my account? And if not, what is going on here? If it is a scam of some sort, where’s the scam? Could this be some strange glitch on Google’s side? Has Google just used some third party 2FA service provider to send me the message? And if so, why would they settle for a company that make their messages look like strange phishing attempts?

rooting – fastboot oem unlock resuts in unknown command (Alcatel 1s)

I have an old Alcatel 1s 5024d with Android 9 and I wanted to try my hand at rooting it. I’ve been following a tutorial that’s supposed to let me flash a boot.img patched by Magisk Manager.
I’ve enabled USB debugging and OEM unlocking in the developer options, installed the necessary drivers and I have downloaded the official platform-tools to be able to use adb and fastboot. Additionally I also have the original cable that came with my phone.

I have zero problems finding my device with and adb with fastboot, but when I try to use fastboot oem unlock (when my phone is in fastboot mode and connected to my pc) it just shows

FAILED (remote: 'unknown cmd.')
fastboot: error: Command failed

I have also tried fastboot flashing unlock, but that shows

FAILED (remote: 'Not implemet.')
fastboot: error: Command failed

There’s frustratingly little information about rooting this 1s version, so I’d be grateful for any advice how to unlock the bootloader.

mysql – Unknown table ‘table’ in field list on referencing temporary table inside a trigger

I am creating a trigger BEFORE INSERT that checks a record from another table to see if it exists, otherwise signal sqlstate. The trigger definition shown below

DELIMITER //
DROP TRIGGER IF EXISTS pob_exists_barang_kode//
CREATE TRIGGER pob_exists_barang_kode BEFORE INSERT
ON `PURCHASE_ORDER_BARANG` FOR EACH ROW
BEGIN
    declare msg varchar(128);
    CREATE TEMPORARY TABLE kode_barang_tbl 
    SELECT ven.`KODE_BARANG`  as kode_barang
    FroM  (
            SELECT po.`REQ_VENDOR_ID` as rvid
            FROM `PURCHASE_ORDER` po,
                 `PURCHASE_ORDER_BARANG` pob
            WHERE NEW.`PURCHASE_ORDER_ID` = po.`ID`
          ) `asdf`,
          `VENDOR_BARANG` ven
    WHERE ven.`VENDOR_ID` = asdf.rvid;
    
    CREATE TEMPORARY TABLE dummy1
    SELECT po.`REQ_VENDOR_ID` as rvid
            FROM `PURCHASE_ORDER` po,
                 `PURCHASE_ORDER_BARANG` pob
            WHERE NEW.`PURCHASE_ORDER_ID` = po.`ID`;
    
    IF NEW.barang_kode not in (kode_barang_tbl.kode_barang) THEN 
        set msg = concat('Kesalahan! Tidak ada kode barang ', 
                          cast(new.barang_kode as char), 
                          ' pada vendor id ', 
                          cast(dummy1.rvid as char)
                        );
        signal sqlstate '45000' set message_text = msg;
    END IF;
    
    DROP TEMPORARY TABLE dummy1;
    DROP TEMPORARY TABLE kode_barang_tbl;
END;//

DELIMITER ;

Trigger created fine, so I ran this script below to test if the trigger works:

insert into `PURCHASE_ORDER_BARANG` values ('po2', '1', 5135, null);

but it returns an error message

Error Code: 1109. Unknown table 'kode_barang_tbl' in field list

Executing the part of the statement works as expected:

SELECT ven.`KODE_BARANG`  as kode_barang
    FroM  (
            SELECT po.`REQ_VENDOR_ID` as rvid
            FROM `PURCHASE_ORDER` po,
                 `PURCHASE_ORDER_BARANG` pob
            WHERE po.`ID` = 'po2'
          ) `asdf`,
          `VENDOR_BARANG` ven
    WHERE ven.`VENDOR_ID` = asdf.rvid;

I’m not really sure which line causes the error, but I am sure I have created the temporary tables and the trigger correctly. I also have no table kode_barang_tbl inside the database except in this trigger. Am I missing something? Any help is appreciated.

magento2 – Magento 2 – Data Migration Tool, unknown column store_id in customer_entity_varchar after data migration

I am trying to migrate a CE 1.9.4.5 site to CE 2.4.0 and have installed the data migration tool.
I managed to migrate both Settings and data successfully.
My orders, products, settings etc .. where successfully migrated
But when i try to perform reindex after successful migration, following error occurs

Catalog Search index process unknown error:
SQLSTATE(42S22): Column not found: 1054 Unknown column 't.store_id' in 'field list', query was: SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `customer_entity_varchar` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('111', '479', '113', '114', '118', '563', '533', '514', '927', '982')) AND (`store_id` IN ('2', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `customer_entity_int` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('119', '940', '941', '937', '117', '120')) AND (`store_id` IN ('2', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `customer_entity_text` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('112', '115', '116', '121', '122', '123', '926', '530')) AND (`store_id` IN ('2', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('965')) AND (`store_id` IN ('2', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `customer_entity_datetime` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('565', '566')) AND (`store_id` IN ('2', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `customer_entity_decimal` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('942')) AND (`store_id` IN ('2', 0))) ) AS `u` ORDER BY `store_id` ASC

The same sql error is shown when i take the category menu in backend admin panel.

Note. I checked in my old magento 1.9.4.5 site, there also store_id column is not present in customer_entity_varchar table, but everything is working perfectly there.
Tried migrating data again in a freshly installed magento 2, but no luck.

Thanks in advance for your help.

certificates – OpenSSL OCSP Responder “Cert Status: good” -> “Cert Status: unknown”

Summary:

Certificates calling to OCSP Responder (OCSPr) have their “Cert Status” change from “good” to “unknown” with no known to changes to environment. Completely lost on this one.

More Detail:

I have been building a simple suite for Certificate creation and OCSP handling for local and personal certificate testing and the such. Everything has been going well, and there hasn’t been any issues with the generated certs checking against the OCSPr until the past few weeks.

I have generated a variety of Server and Client Certs and spread them around to various sites for testing and they function properly except for the following:

I have generated two Server Certs and two Client Certs and placed them on their respective sites, and initially these Certs call in to the OCSPr with a Cert Status of “unknown” for a few minutes, then switch to “good” for an undetermined amount of time, and then back to “unknown” until the OCSPr and the web site are both reset, and then the cycle repeats itself.

The other Client and Server certificates that have been created and placed on other sites are still functioning properly and communicate immediately and with ease with the OCSPr.

Some Info that May be Useful:

OpenSSL Version: OpenSSL 1.1.1c 28 May 2019

The environment is setup such as: CA -> InterCA -> Device/Server/OCSP Certificates

The OCSP Responder looks like:

sudo openssl ocsp 
-url http://ocsp.address.com -port 80
-index Inter_index.txt 
-CA certs/InterCA.cert.pem 
-rkey private/ocsp.key.pem 
-rsigner certs/ocsp.cert.pem 
-out ocsp_log.txt 
-text -rm sha384 -ignore_err

I’ve also substituted -CA certs/InterCA.cert.pem with -CA certs/ca_chain.cert.pem with similar results (I heard that OpenSSl doesn’t care for CA chains, but no harm in trying)

I’m sure there is more I could add to this that would be helpful, but nothing comes to mind at the moment. 🙂

[Vn5socks.net] Auto update 24/7 – Good socks 12h00 PM

[Vn5socks.net] Auto update 24/7 – Good socks 5h30 PM

[Vn5socks.net] Auto update 24/7 – Good socks 9h40 PM