WordPress SQLite to MySQL Migration Complete

Just finished migrating my website from SQLite to MySQL. What a rush. (lol) It was actually not as bad as I thought. A lot of sed, grep and other sorcery involved; especially in transforming of SQLite statements to MySQL. Some quick commands I used: sqlite techish.db .dump > production_2018-08-23.dump.sql I found that it used quotes … [Read more...]

GoFileRoom Error: The service you are trying to reach is unavailable. Please try again later.

TL;DR GoFileRoom made changes to their encryption by using TLS1.2. In order for GFR add-on to work in Windows Server, you must modify 2 registry entries for .NET enforcing strong encryption. For GFR website to operate, you need to ensure TLS1.2 is enabled as well. Here's the GoFileRoom technical notes on enabling this via Registry: … [Read more...]

GoFileRoom Installation hangs on “Windows Installer Coordinator”

Installing GoFileRoom on Server 2016 Remote Desktop Session Host and during install it hangs on the window titled Windows Installer Coordinator and the message is please wait while the application is preparing for the first use. To resolve this, I modified Group Policy for the Remote Desktop Services Host Application Compatibility I set the … [Read more...]

Allow ActiveX Controls Automatically over Group Policy

To enable and not prompt for ActiveX controls to download and run, use the following Group Policy settings at the Computer or User level. Caution:  This can be dangerous! Administrative Templates > Windows Components > Internet Explorer > Internet Control Panel > Security Page Then select the zone the webpage loads from: Local … [Read more...]

GPO Set Trusted Zone Websites

To add websites to Trusted Zones via Group Policy, follow the below in Group Policy Editor. Computer Configuration > Administrative Tools > Windows Components > Internet Explorer > Internet Control Panel > Security Page and then double click to the "Site to zone assignment list". Enable it, click Show, add website as value name and … [Read more...]