Category: Hosting
-
Cloudflare and WordPress multisite
•
Issue: Site uses Cloudflare and uses flexible SSL to serve pages. However, within WordPress, any http:// referenced sources are being referenced as http:// instead of https:// Solution 1: For the site in question, you can force resources to automatically upgrade. Put the following line in your .htaccess file: Header always…
-
WordPress/MySQL change URLs
•
Connect to MySQL and view tables to see what you need USE <DB_NAME>; SHOW TABLES; Grab site URLs SELECT * FROM wp_options WHERE option_name = ‘home’; SELECT * FROM wp_options WHERE option_name = ‘siteurl’; **NOTE** Multisite setups are different. Each site has their own set of wp_options, depending on your…
-
Malware/Hack on website, what to check?
•
Issue: Site hacked, payload dropped, compromised. How, where to go, and what to do. FIRST: Resolve and remove the offending content– Restore your website from good backups– Double-check your files, if it’s a CMS (like WordPress), try to restore from the original install files and ONLY bring in necessary files…
-
WordPress can’t connect to database after MySQL move to new datadir
•
Resolution: The problem is related to your moving the mysql.sock file to a new location. PHP needs to know where it is, changing the location will fix the problem and reload apache/httpd (if you are using php-fpm, restart the service) Easy fix: Edit your php.ini file and make sure you…
-
Moving mysql datadir in Redhat (don’t forget SELinux!)
•
Issue: You have moved /var/lib/mysql data files to their new destinations, but mysql will not start up. Resolution(s): 1. Review and verify configurations (in this example, MySQL 8) – /etc/my.cnf.d/mysql-server.cnf datadir=/ & socket=/ set to the right folder? – /etc/my.cnf.d/client.cnf add the following lines under [client]: datadir=/path/to/your/files port=3306 2. Grant…
-
Connection errors from WordPress to Azure MySQL database
•
Issue: You are getting connection issues to your hosted Azure MySQL database server. You are putting the correct information in, but still WordPress is showing Error Connecting to Database. Error: After some investigation, you most likely are getting this error: mysqli_real_connect(): (HY000/9002): SSL connection is required. Please specify SSL options…
-
WordPress troubleshooting
•
Issue: You are having trouble with your WordPress installation and can’t figure out exactly the issue. It may be that you are on a server and have limited visibility. Resolution: Save the following four lines, these are a MUST for those who are moving sites across platforms or to another…
-
Rewrite rule – Force HTTPS / Linux
•
Forcing HTTPS is very easy to do in Apache. The common command is to force everything to HTTPS. In your host file, under :80 make sure you have the following. At the same time, make sure you have :443 open and that your configuration is ready to host the new…
-
Script for Chrome cache multiple users
•
I found a script this very useful script. It does a good job of cleaning the Chrome cache in user profiles on a terminal server. Original Post: https://community.spiceworks.com/topic/1425012-clear-chrome-cache-for-multiple-users-on-file-server Thanks! ======== @ECHO On TASKKILL /F /IM Chrome.exe /T for /f %%a in (‘dir c:\users /b’) do ( rd “c:\users\%%a\AppData\Local\Google\Chrome\User Data\Default\Cache” /s…
-
Script for disk cleanup
•
@echo off REM Install Disk Cleanup based on Windows Version ver | findstr /i “6\.0\.” > nul IF %ERRORLEVEL% EQU 0 goto ver_2008 ver | findstr /i “6\.1\.” > nul IF %ERRORLEVEL% EQU 0 goto ver_2008R2 goto warn_and_exit :ver_2008 :Run Windows 2008 specific commands here echo OS Version: Windows 2008…