I was getting this error on Ubuntu 20.04 LTS with MySQL version 8.0.35.

Err:1 http://repo.mysql.com/apt/ubuntu focal InRelease
The following signatures couldn't be verified because the public key is not available: NO_PUBKEY B7B3B788A8D3785C

After some research, I tried several suggestions that I found at the links below, but they did not resolve the issue.

https://askubuntu.com/questions/1497140/how-to-fix-apt-update-after-to-upgrade-the-mysql-list-file

https://www.reddit.com/r/mysql/comments/18jj4hm/terminal_update_error/

https://askubuntu.com/questions/1389928/mysql-an-error-occurred-during-the-signature-verification

https://github.com/apache/airflow/issues/20911

However, finally came across this link which did have a solution:
https://askubuntu.com/questions/1498081/no-pubkey-and-some-of-the-file-has-an-unsupported-filetype

Below are the steps to quickly fix it:

1. Download an updated .deb file from the official mysql site:
   https://dev.mysql.com/downloads/repo/apt/
2. Install the deb (e.g., mysql-apt-config_0.8.29-1_all.deb):
   sudo dpkg -i <filename>
3. Then run apt-get update again and the error should not appear.

Some background: On a Windows 10 machine I had to recreate an existing user profile  due to some corruption. I followed this guide (except for the step related to ProfileGuid in the registry, since it does not exist in Windows 10):

https://community.spiceworks.com/how_to/121165-re-create-user-profile-windows

Everything worked great and I was able to log on. However I quickly realized none of the built in Windows Apps worked.  They would open and then very quickly close without any error message window.

Each of these apps could be fixed quite easily using the Start Menu -> type: Apps -> launch Apps & features.  Find the problematic app, click Advanced options. First choose the Terminate button. Then choose the Reset button. The app then worked without crashing instantly.

However this same issue occurred with Microsoft Store, but that app unfortuantely is not in the Apps & features list.

Event viewer did have information for these crashes. For example

Faulting application name: WinStore.App.ex
Faulting module name: KERNELBASE.dll, version: 10.0.19041.3758
Exception code: 0xc000027b
Fault offset: 0x000000000012db22
Faulting application start time: 0x01da427eb19954ed
Faulting application path: C:\Program Files\WindowsApps\Microsoft.WindowsStore_22311.1401.2.0_x64__8wekyb3d8bbwe\WinStore.App.exe
Faulting module path: C:\Windows\System32\KERNELBASE.dll
Faulting package full name: Microsoft.WindowsStore_22311.1401.2.0_x64__8wekyb3d8bbwe
Faulting package-relative application ID: App

I tried to reset Microsoft Store using Start menu -> type: wsreset utility.  However that failed and would generate the error -2147219196 related to PurgeCaches.

I also tried uninstalling and reinstalling Microsoft Store via PowerShell.  Each of these was successful but didn’t fix the problem.

Finally I stumbled on this article:

Microsoft Store missing in Apps & Feature – Microsoft Community

This helped me resolved the issue and you can follow these quick steps:

1. Uninstall Microsoft Store using PowerShell (admin):

   get-appxpackage *WindowsStore* | remove-appxpackage

2. Start Menu -> type: Apps -> launch Apps & features
3. Uninstall Xbox app
4. Uninstall Xbox Live app
5. Reinstall Xbox app via this link https://aka.ms/XboxInstaller
6. Launch Xbox app
7. At the top you should see a notification that Microsoft Store is needed.
8. Click it to install Microsoft Store using the Xbox App
9. Once complete, Microsoft Store should now be functional!

I tried running an old program and received this error message:

Run-time error ‘713’
Class not registered.
You need the following file to be installed on your machine.
MSSTDFMT.DLL

Here are the steps to solve it using an official dll file sourced from Microsoft:

1. Download Microsoft Visual Basic 6.0 Service Pack 6 Cumulative Update from:
   http://www.microsoft.com/download/details.aspx?familyid=cb824e35-0403-45c4-9e41-459f0eb89e36&displaylang=en
2. Extract the package to a folder using a utility such as 7zip.  Copy msstdfmt.dll to: C:\Windows\SysWOW64
3. Open a command prompt (cmd.exe) with administrator privileges.
4. Issue the command:

   regsvr32 c:\windows\syswow64\msstdfmt.dll

5. Try running the program again

References:

1. https://support.microsoft.com/en-us/topic/description-of-the-cumulative-update-rollup-for-the-visual-basic-6-0-service-pack-6-runtime-extended-files-e02acc79-217b-fc0a-6edc-540403af2081
2. https://superuser.com/questions/519841/getting-msstdfmt-dll-missing-when-starting-visual-basic-6-application

You may receive an error when trying to play a game on the EA App (Origin based games).

We’re sorry, an error has occurred
Invalid license. Reason code = Missing DLL: [gfsdk_aftermath_lib.x64.dll]
Error: 0x45A.

Clicking Exit results in another error:

Easy Anti-Cheat
Untrusted system file (C:\Windows\System32\msvcp140.dll)

Searching for a solution you may come across several threads about the issue on the EA community forums:

https://answers.ea.com/t5/Other-STAR-WARS-Games/Invalid-License-missing-DLL-gfsdk-aftermath-lib-x64-dll/td-p/9549421

https://answers.ea.com/t5/Origin-Mac-Client-Technical/MSVCP140-dll-missing-in-newly-reinstalled-Origin/m-p/7866948

https://answers.ea.com/t5/Other-STAR-WARS-Games/Missing-DLL-gfsdk-aftermath-lib-x64-dll-Error-0x7E/m-p/9907950

The suggested fixes varied from things such as changing video card drivers, rolling back Windows to a previous restore point, reinstalling the game, reinstalling the EA App and reinstalling Visual C++ 2015.

The biggest clue was found in this thread:

https://answers.ea.com/t5/Technical-Issues/Easy-Anti-Cheat-untrusted-system-file-vcruntime140-dll/m-p/12909075

The solution?  To install Visual C++ Redistributable for Visual Studio 2015, however you need the “2015-2022” Redistributable and NOT the 2015 Redistributable

Below is the 2015 version (published on 10/07/2015) suggested in one of the forum threads. It may already be on your system and will NOT fix the problem:
https://www.microsoft.com/en-gb/download/details.aspx?id=48145

This is the 2015-2022 Redistributable that WILL solve the problem and eliminate the errors.  Installing this will replace any previous versions of the 2015 Redistributable that may already be installed on your system.  Install both the x86 and the x64 versions
https://aka.ms/vs/17/release/vc_redist.x86.exe
https://aka.ms/vs/17/release/vc_redist.x64.exe

Note: For reference, the permalinks for the 2015-2022 Redistributable files listed above are sourced from this Microsoft website:
https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170#visual-studio-2015-2017-2019-and-2022

I was trying to run the latest Thaiphoon Burner on Windows 7 and was having no luck. At the time of this guide, the Thaiphoon Burner version was 17.4.1.2 build 0902 Final.

When trying to launch, the first message was:

The kernel mode driver of Thaiphoon Burner is blocked from being installed by Windows operating system or antivirus software. This exception may also occur if you do not have sufficient administrative privileges.

In this case the error message was not relevant, because Windows 7 was a fresh install without a 3rd party antivirus. I was also using the system Administrator account.

After Thaiphoon Burner loaded, a second error message was shown:

Thaiphoon Burner has not detected any SPD EEPROM device! The most possible reasons for this is an unspoported SMBus Controller, your antivirus software or the latest Windows 11 operating system with enabled Smart App Control that blocks Thaiphoon’s drive from being installed.

If this is a permanent error, please disable your antivirus software or refer to the READFIRST.txt file to get more information on this issue.

I reviewed the READFIRST.txt but it did not contain anything about Windows 7, so it was a bit of a dead end.

The next step was to try disabling Windows Defender real-time protection as well as User Account Control.  However, the result was the same.

Then at some point, Windows provided the biggest clue with a message from the Program Compatibility Assistant:

Windows requires a digitally signed driver

A recently installed program tried to install an unsigned driver. This version of Windowws requires all drivers to have a valid digital signature. The driver is unavailable and the program that uses this driver might not work correctly. Uninstall the program or device that uses this driver and check the publisher’s support website to get a digitally signed driver.

Driver: MICSYS IO driver
Service: Thaiphoon Burner Low-level Access Driver
Publisher: MICSYS Technology CO., LTd
Location: C:\Windows\SysWOW64\drivers\TbsbIo64.sys

The solution was to disable the requirement for digitally signed drivers. The steps:

1. Reboot
2. Before the Windows logo, press F8
3. Choose the option for: Disable Driver Signature Enforcement

Once Windows boots with this option enabled, Thaiphoon Burner should now load successfully. Keep in mind this is a temporary solution until the next time the system is restarted.

You might find yourself in a situation where you have an old motherboard based on a phoenixBIOS chip, and you desire to update the BIOS to the latest version.

In this example, I had a Supermicro X7DWE-O.  The motherboard is quite old and BIOS downloads are no longer available. Visiting the Supermicro website below, you are greeted with a message:  The product is archived and no longer in production. Please go to our BIOS List to locate your product BIOS/BMC Firmware/Bundled Software.

https://www.supermicro.com/en/support/resources/downloadcenter/firmware/MBD-X7DWE/BIOS

I was able to acquire the BIOS .bin / .rom file (i.e., X7DWE0.B19). However, after entering the BIOS setup on the motherboard I found it had no built in update system.  I also had no DOS flash utility for Phoenix BIOS.

I came across several Supermicro FAQs for motherboards such X7DA8, X7DWA, X7QC3, X7SBE and X7SB4 that mentioned a Phoenix BIOS and related functions:

https://www.supermicro.com/support/faqs/faq.cfm?faq=760

https://www.supermicro.com/support/faqs/faq.cfm?faq=5039

https://www.supermicro.org.cn/support/faqs/faq.cfm?faq=5860

https://www.supermicro.com/support/faqs/faq.cfm?faq=11444

https://www.supermicro.com/support/faqs/faq.cfm?faq=12512

The steps I used to flash the BIOS:

1. Create a USB bootable DOS disk (I prefer FreeDOS) using Rufus
2. Download the phflash utility
   https://www.mediafire.com/?1b2zr67o1y5v4gr
3. From that download, find and copy phflash16.exe to the bootable disk
4. Use the disk to boot into DOS
5. To update the BIOS, use the command phflash16.exe <filename>. For example:

   phflash16.exe X7DWE0.B19

6. Proceed with the directions shown to flash.

If using Microsoft Authenticator, you may receive the following error message when trying to remove an account:

You need to disable backup to delete <account>.

This can happen if you are trying to delete the account that is also acting as the Recovery Account for authenticator backups.  To resolve, go into the Microsoft Authenticator settings.  Find the section titled Backup, then disable backup.  For example, on iOS this will be via iCloud Backup.

It will then ask whether you want to delete your backup:  You will no longer be able to recover your accounts.

Click OK. You will receive confirmation that Backup successfully deleted with a Cancel button.

Go back to the main Authenticator screen. You will now be able to delete the account from Microsoft Authenticator.

One case study involved an Ubuntu 20.04 (Focal Fossa) system that was protected with Fail2fan.  However the server was also protected with Cloudflare, so there was some work needed to get the remote IP of the attacker (this topic was covered in another post). If you try to ban the offender’s real IP (not the Cloudflare IP) with that configuration, you may receive messages in the fail2ban.log that look similar to the below:

fail2ban.observer INFO [jail] Found x.x.x.x, bad
fail2ban.actions NOTICE [jail] x.x.x.x already banned

You should also see the ban in iptables:

sudo iptables -L

However with the bans in place, the offending IP can still access the resource. The root cause is because the attack is originating from Cloudflare.

The solution is to ban and unban attacker’s remote IPs using Cloudflare’s API for their firewall.  Fail2ban has a built in actions.d/cloudflare.conf to help with that.   However with the Fail2ban version (0.11.1) available in Ubuntu 20.04 , the action file included was not completely functional, especially on the unban side.  The trick is  replace it (or use an action local file) using the latest action file on GitHub:

https://github.com/fail2ban/fail2ban/blob/master/config/action.d/cloudflare.conf

Duplicate the latest action file, then:

1. Populate cftoken with your Global API key from Cloudflare
2. Populate cfuser with the email address of your Cloudflare account.

Save the new action file (e.g., cloudflare.conf or cloudflare.local).  Before proceeding further, flush out any old bans that may be present in Fail2ban from previous attempts at banning, doing one or more of the following:

sudo fail2ban-client set JAILNAME unbanip x.x.x.x

Once complete, the next step is to update your jail to have the following line (NOTE – if your action file is not called cloudflare.conf or cloudflare.local, change it below accordingly):
action = cloudflare

Save the jail and then reload Fail2ban:

sudo service fail2ban reload

Test to see if the banning works. You can monitor fail2ban in real time using the command:

sudo tail -f /var/log/fail2ban.log

As of today, you can view and manage bans in your Cloudflare account at Websites -> “Your-Site” -> Security -> WAF -> Tools.  Any bans that come in through the API will have a note “Fail2Ban JAILNAME”  under the IP address.

On Ubuntu 20.04 (Focal Fossa) running PHP 8.2, you may run into an issue after installing the latest phpMyAdmin (5.2.1) using the PPA (ppa:phpmyadmin/ppa).

When you try to log in to phpMyAdmin, you will get the following message:

 Error: Unknown named parameter $$dbi

I first found discussion about the issue on Stack Overflow, but neither solutions would result in staying on the PPA:
https://stackoverflow.com/questions/76213404/error-unknown-named-parameter-dbi-in-phpmyadmin-5-2-1

However the issue has been identified by the development team:
https://github.com/phpmyadmin/phpmyadmin/issues/16968
https://github.com/phpmyadmin/phpmyadmin/wiki/DebianUbuntu#known-issues
https://github.com/phpmyadmin/phpmyadmin/issues/18498
https://github.com/symfony/symfony/commit/8e34978e4e2c4bf7dac97e44e904368c4cfb54f8

The quick steps to fix the problem:

1. Edit the file (nano, vi, etc.)

   /usr/share/php/Symfony/Component/DependencyInjection/ContainerBuilder.php

2. Change this line

   $service = null === $r->getConstructor() ? $r->newInstance() : $r->newInstanceArgs($arguments);

   to look as follows:

   $service = null === $r->getConstructor() ? $r->newInstance() : $r->newInstanceArgs(array_values($arguments));

3. Save and close the file.  Refresh the browser (or try to log in again) and you should now have a working phpMyAdmin instance.

If you have a Sprint branded Blackberry phone (in this case a Bold 9930 running OS 7.1) that has an old phone number (MDN) on it, you may find that the number remains even after performing a Security Wipe of the data from the device. However, you can remove easily remove it with a device reset using these steps:

1. From the home screen, press the Send key.
2. Dial ##72786.
3. Tap Continue (Call ##72786)
4. You will receive a prompt: SCRTN will change to factory default value for DSS
5. Choose Continue
6. You will receive another prompt: SCRTN Successful. The device will now reset to apply the necessary changes
7. Click OK
8. The device will restart and the old phone number will have been removed.