Discovered that my most recent conversion from SQLite to MySQL seems to have screwed up my backslashes in all my posts that have backslashes. This is bad because my code snippets should not be copy & pasted and run at face value unless you verify the code! It could seriously break shit. Ugh. This is…
Read More All my backslashes are gone in WordPress. Yikes.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 WordPress SQLite to MySQL Migration CompleteTL;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 Error: The service you are trying to reach is unavailable. Please try again later.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 following…
Read More GoFileRoom Installation hangs on “Windows Installer Coordinator”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 Machine, Trusted-Sites, Internet…
Read More Allow ActiveX Controls Automatically over Group PolicyTo 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 GPO Set Trusted Zone Websites