Month: March 2016

Force HTTPS in htaccess and wp-config.php

Force HTTPS in WordPress by adding this to your htaccess-file, before the line “# BEGIN WordPress”.

Apache
1
2
3
RewriteEngine On
RewriteCond %{HTTP:X-Forwarded-Proto} !https
RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

 

Also, add this to your wp-config.php. FORCE_SSL_ADMIN is there to make sure there’s no redirect loop in wp-admin.

PHP
1
2
3
4
$_SERVER['HTTPS'] = 'on';
define('FORCE_SSL_ADMIN', true);
define('WP_SITEURL', 'https://henriksson.me'); // replace with your sitename
define('WP_HOME', 'https://henriksson.me'); // replace with your sitename

 

Automatically start MySQL if apache kills the process or sacrifice children on Ubuntu Server

There are several ways to solve the problem of Apache running wild and killing MySQL. It the problem occurs very infrequently, there’s a easy way of restarting MySQL with the use of the crontab. The script even sends a notification email so you know what just happened.

First, SSH into your server:

Shell
1
ssh root@server-ip

Create a script file:

Shell
1
nano mysqlfix.sh

Paste the following:

Shell
1
2
3
4
5
6
7
#!/bin/bash
PATH=/usr/sbin:/usr/bin:/sbin:/bin
if [[ ! "$(/usr/sbin/service mysql status)" =~ "start/running" ]]
then
    echo "MySQL restarted for henriksson.me on Digital Ocean" | mail -s "MySQL restarted" markus@henriksson.me
    sudo service mysql start
fi

Press CTRL + O to save, and CTRL + X to exit.

Give execute permission to your script:

1
chmod +x mysqlfix.sh

Edit the Crontab:

Shell
1
crontab -e

Paste the following:

Shell
1
* * * * * /root/mysqlfix.sh

Press CTRL + O to save, and CTRL + X to exit.

To see if it works, type the following:

Shell
1
service mysql stop

In case the service doesn’t start, just start it manually with the following:

Shell
1
service mysql start

 

Remove query strings from static resources in WordPress

Remove query strings from static resources in WordPress by adding this to your functions.php. You can also change the substring “?ver” to anything else you want to remove.

PHP
1
2
3
4
5
6
7
function _remove_script_version( $src ){
    $parts = explode( '?ver', $src );
    return $parts[0];
}
 
add_filter( 'script_loader_src', '_remove_script_version', 15, 1 );
add_filter( 'style_loader_src', '_remove_script_version', 15, 1 );