Replace IP address across multiple SPF records in a MySQL server.
Just had to do this for a PowerDNS server.
1 | UPDATE `records` SET `content` = replace(content, 'old_ip', 'new_ip'); |
MySQL constraints preventing import of single table
One of those doh!! moments when you do something quickly to get it working and didn’t think through the consequences. I had 3 linked tables […]
Laravel 5.6 With Typescript.
Please note these directions are just my struggle to get this working. I am on my first day with Laravel and Typescript and haven’t used […]
Dependency Injection finally makes sense.
How I learned to love Dependency Injections in PHP. Practical uses for them and how to use them in Codeigniter 3.
ERROR: The certificate of ‘ftp.drupal.org’ is not trusted.
When installing Drupal on a fresh Debian 8 server I received this error from wget.
1 2 3 | Connecting to ftp.drupal.org (ftp.drupal.org)|151.101.45.175|:443... connected. ERROR: The certificate of ‘ftp.drupal.org’ is not trusted. ERROR: The certificate of ‘ftp.drupal.org’ hasn't got a known issuer. |
The fix is;
1 | apt-get install ca-certificates |
Re Indent a whole page in Sublime Edit 3 with Key Binding
In Sublime Edit 3, I got fed up of having to go to the Command pallet ever time I want to re-indent my file. To […]
Install and Automate LetsEncrypt SSL on your Plesk Login
When you use the LetsEncrypt module it handles the renewals of your encrypted domains without any issue. However it doesn’t appear to have any method […]
Unable to find backend willing to host … for potential supermaster
Fixing the “Unable to find backend willing to host hostname for potential supermaster” Error. I had set up many PowerDNS master slave nameserver clusters before […]
Bash Scripting Random Numbers
I needed to create a script that would pick a random line from a file. The $RANDOM variable isn’t the easiest to use as it […]
My Site is now encrypted using letsencrypt ssl cert on plesk 12.5 and Centos 6.7.
This server is now running a Free SSL Certificate from LetsEncrypt. I am running this server on Centos 6.7 and have plesk 12.5 installed. Now […]