Skip to content

How to fix “Your PHP installation appears to be missing the MySQL extension which is required by WordPress” error on Bluehost

If you use Bluehost and tried updating PHP to counter the error messages WordPress generates indicating the version of PHP your running is out of date, you may have subsequently came across the following error message after updating PHP from V5 to 7:

“Your PHP installation appears to be missing the MySQL extension which is required by WordPress”

There’s a simple fix for this issue but its not documented anywhere on Bluehosts Support pages

Just login to the CPanel access the File Manager and rename your PHP.ini file to PHP.ini.bak

Can’t add a https search property to Googles Search Console in Google Webmaster

So you may have heard Bluehost enabled free SSL certificates for WordPress users on Shared plans and gone ahead and enabled it

But you ran into the same issue I had when adding your new fangled https:// enabled domain name into Google Webmasters Search Console

It just won’t take your new https://www.mysite.com domain name saying it’s already been added

Try adding an ending forward slash to your https://www.mysite.com domain instead

https://www.mysite.com becomes https://www.mysite.com/

Windows Store and apps failing to launch after upgrade

If you’ve been having problems launching the Windows Store or launching windows metro apps after upgrading from Windows 8 and none of the other troubleshooting suggestions have worked, this probably means the upgrade has caused registry permission issues.

The following registry path indicates a typical registry location associated with a Metro app:
HKEY_CURRENT_USER\Software\Classes\Local Settings\Software\Microsoft\Windows\CurrentVersion\AppModel\SystemAppData
\WinStore_*examplemetroapp*

What you’ll need to do is check all the “PSR” folders in any sub folders of
HKEY_CURRENT_USER\Software\Classes\Local Settings\Software\Microsoft\Windows\CurrentVersion\AppModel
\SystemAppData\WinStore_*exampleapp*\
To see if you’re denied access to any of the PSR folders
If you are go and grant yourself ownership of the PSR folders you’re denied access to

That should sort the Metro app/Windows Store launch issues.

Hopefully you don’t have lot of Metro apps installed otherwise re-granting ownership can become a bit tedious.

If you do have a lot you can of course re-grant yourself ownership of the root folder and enable inheritance so the permission change get’s applied to all folders under the following registry location and to all PSR folders as a result:
HKEY_CURRENT_USER\Software\Classes\Local Settings\Software\Microsoft\Windows\CurrentVersion\AppModel\SystemAppData

Note: Very important – If you don’t know what the registry is please don’t modify it.

Codecademy – An awesome learning platform

Just a quick post as a shout out to Codecademy which is a great site to learn how to code everything from JavaScript to CSS.

If you’re like me and could never figure out the interaction between HTML and CSS, get stuck into their interactive course and you’ll be amazed what you can do with one css and one html file

How to open corrupt or damaged PDF files

If you’re having problems opening PDF files that have been damaged or corrupted you may have some luck with MuPDF.

I found this lightweight PDF reader when a colleague at work was having trouble opening a PDF sent in via e-mail. Adobe Reader, Adobe Pro, Foxit Reader and GScript all failed to open the file in question – MuPDF was the only one to succeed.

Plus there’s nothing to install – just extract the exe from it’s zip archive and run.

iPhone – Can’t access the internet while roaming?

If you can’t access the internet while roaming outside your home country the issue may be down to a new switch enabled in iOS8.

It was supposed to allow roaming without any extra charges in any EU country but it doesn’t do exactly what it says on the tin…

Find and disable “EU Internet” in your iPhone mobile settings and this should allow you to access the internet again. Or you could just use an Android phone…

Chrome slow or failing to connect to g-mail and other sites

We had problems in work with Chrome intermittently failing or slow to connect to G-mail and other sites. I found this is down to an experimental QUIC transport layer protocol in Chrome.

Finding and disabling QUIC in Chrome by typing:
chrome://flags
into’s Chrome’s URL bar and hitting return should have you browsing the internet the way Chrome originally intended…

It doesn’t seem to be a problem if you have a direct connection to the internet (home user) but if Chrome’s throwing hissy fit’s when connecting to sites it’s worth a try disabling it.

You may also need to set the flag again if Chrome updates in the background or you update manually.

Intermittent port outages (link flaps) on Cisco 4500 series switch

Here’s a problem I initially suspected was being caused by our Cisco 4500 series switch or the software rev on the switch but it turned out to be something completely different.

Here’s the background of the problem:

Two of our office users started to have problems with their PC’s intermittently losing network connectivity for about 10 sec’s at a time, at which point the PC would reconnect to the network and behave perfectly for another couple of hours before disconnecting again.

Our new switch had been installed about a year or so ago with all new Cat6 cabling feeding through to our Comms room patch panel (or so I thought). Our PC’s had been behaving fine for a number of months and connecting fine at GB speeds.

The cabling from our patch panels out to our office floor ports is all Cat5e Gigaspeed certified.

The fact that two users were having the same problem was strange and initially had me worried as it was doubtful this was a problem with the OS build otherwise as lot more users would’ve reported the issue. It was also unlikely this was a virus as the likelihood of two PC’s being infected with the same virus at the exact same time was low.

So I started to dig some more – here’s what I found:

I was lucky to in a position where I was able to catch the network disconnect (as I’m calling it for now) on one of the floor boxes affected, at which point I unplugged the affected PC and plugged in a laptop.

The laptop displayed the same behaviour as the desktop PC – no network communication and then after a few seconds it came to life again.

This is what I was looking at on the PC’s after they experienced an outage:

Event Viewer Error Message

It turned out a number of other users where having the same problem but hadn’t noticed the issue as the network outage was so short.

The above got me worried as the issue looked to be switch based – either a problem with the line card or the software rev on the switch itself.

At this point I contacted our Network team and laid out what I found.

Problem was they couldn’t find any port outages recorded on the switch. They suggested we were having a problem with the NIC card/PC hardware and suggested that manually enabling 1GB on the NIC card and switch port should fix the problem.

I had a problem with this suggestion however as it did not resolve why my laptop would not receive traffic (not even a link light) when it was plugged into an affected floorport. Manually enabling 1Gb on the switch and PC is also not best practise.

So a lot more Event Viewer digging on a lot more office PC’s revealed the same network outage conditions with the same event viewer error message reported. I was also able to find network outages on a Mac so this was highly unlikely a OS build or hardware issue on our PC’s

The Network team where still unable to see any outages on the switch so they weren’t likely to dig further until I suggested they check switch logging is actually switched on and configured to detect disconnects and check the software revision on the switch for any bugs that match the disconnect issue…

It was at this point they found out that link state messages were disabled in the image they were using on the switch. After they got link message logging enabled they were finally able to see the port disconnects which they found to be down to link flaps.

The reason they couldn’t see the drops wasn’t down to what I thought – but I took this as a win as they were now able to see the port outages…

After much back and forth around the possible causes of issue including bpdu packets and questions about the  level of logging the Network team had enabled I then began to investigate our network cables as the cause even though I didn’t think it was possible for a cable plugged into a switch to cause a port to disable itself completely for 10 secs at a time. Especially when the PC connected to that cable behaves itself 99 percent of the time…

An incorrect assumption – but you learn something new everyday!

My checks indicated all the cables were rated for GB speeds until I found a bunch of cables that stood out from the others purely because they did not have “Gigaspeed” written at the end of the cable identifier. The cables in question were Systimax 1074D 4/24 (UL) and they ran from the switch to the patch panel.

It turned out almost all the cabling running from the switch to the patch panel had been replaced with Cat6 but not all. Some Systimax 1074D 4/24 (UL) cable – about 15% of the old cable running from the Cisco 4500 switch to the patch panel was still in place…

I couldn’t find any information about the Systimax 1074D 4/24 (UL) on the internet so I had no clue if it was Cat5, 5e or Cat6 certified. Thankfully a great guy called Alaric Jenkins from network cabling supplier Info Stor responded to my query and was able to tell me that the Systimax 1074D 4/24 (UL) cable is Cat5e but not certified for Gb ethernet.

So here’s what I learned:

1. Just because you’re able to get GB speed on your PC using a Cat5e cable 99% of the time – that doesn’t mean your Ethernet cable is GB certified…

2. Cabling can adversely affect your switch ports, even going so far as to completely disable them.

Convert Sony HD422 MXF files to MOV

This one had me stumped for a while…

A Pro Sony HD422 camcorder was purchased by one of our newspaper titles for interviews, shoots etc – problem was no one knew how to export the proprietary MXF format videos the camcorder records to a format that’s compatible with Final Cut Pro as nobody on site had any pro video camera experience…

I’m sure a lot of first time videographers have had trouble with this particular camera so here’s the absolute minimum requirements you need to get those MXF files into Final Cut Pro for editing:

I went with FCP 6 (updated to 6.0.6) as we already had a licensed copy of it available, I just wasn’t sure if FCP 6 could handle wrapping the MXF files as MOV until I found the FCP 6.0.3 release notes

The prerequisites are:

1. Final Cut Pro 6.0.6 (FCP6 is available as part of Final Cut Studio 2.0 once that’s installed an update using Apple software takes FCP up to 6.0.6)

or Final Cut Pro 7 (Install all latest updates available)

2. XDCAM Transfer 2.16. Available from the Sony website (PDZK-P1_XDCAM_Transfer_v2_13_0.zip)

The Final Cut Pro update from 6.0 to 6.0.6 installs the codecs necessary for XDCAM Transfer to read the XDCAM/HD266/MXF files the Sony HD422 creates. Once the codecs are installed XDCAM Transfer can wrap the MXF files as MOV for Final Cut Pro to read and edit if you so wish. At that point you can then export to whatever video format you want.

Once the above has been installed launch XDCAM Transfer and open up the MXF files stored on your SXS card or stored locally on your Mac and click on the “Import” button down the bottom right side of the app.

From there browse to “\Users\<username\Movies\Sony XDCAM Transfer” and you’ll find sub-folders containing the MOV wrapped MXF files which can then be opened in FCP. The only caveat we have here is that FCP6 will not install on OSX 10.8 but you’ll be fine on 10.6

Make sure Sender Policy Framework (SPF) is correctly configured

We had some issues at work recently with intermittent e-mail’s from a third party not arriving in our Google App’s mailboxes (we’ve now migrated to using Google App’s for Business as opposed to using Exchange exclusively).

This was a big problem for us as these e-mail’s are an important source for news stories.

I immediately suspected spam/DNS server issues due to my previous experience trouble-shooting our Ironport issue two years ago.

This time however the problem lay with the third parties DNS not ours.

Here are the steps I took to troubleshoot then fix the problem:

Symptoms:

The issue was first reported when one of our news reporters noted some e-mails were not arriving – sent in from this news sources distribution list.

Some e-mail not all were being dropped – this is an important factor as we’ll see below.

Troubleshooting steps:

1. I realised straight away the problem wasn’t related to any e-mail filters in the reporters inbox or SMTP blacklists since approx only 20% of the mails were not arriving. Nonetheless I ran the check’s necessary and found nothing causing mail to be filtering into the users bin.

2. I checked in on another colleague who’s mail domain address is different from the news reporter that detected the problem (We use multiple domain names for separate titles and business teams). That colleague indicated they were missing the exact same e-mails that the first reporter detected missing.

3. The distribution list in question is used by a number of other news organisations so I sent a mail out to another news organisation’s IT dept to ask if they’d noticed those particular e-mails missing – they hadn’t.

4. I then asked an ordinary user at the news sources site, (I’m calling her [email protected] here) to send me an e-mail so I could evaluate the incoming e-mail headers for anything out of place. The e-mail she sent arrived fine but the information I found in her mail header provided the light bulb moment when taken into account with the rest of the information gathered. I found two key entries in [email protected]‘s mail header:

Received-SPF: fail (google.com: domain of [email protected] does not designate 137.191.225.35 as permitted sender) client-ip=137.191.225.35

Authentication-Results: mx.google.com; 

spf=hardfail (google.com: domain of [email protected] does not designate 137.191.225.35 as permitted sender) smtp.mail=137.191.225.35;

It was time to brush up on SPF or Sender Policy Framework

SPF basically boils down to a DNS entry that indicates which SMTP servers are permitted to send e-mail on behalf of a mail domain. This prevents spammers from getting e-mail’s into a users inbox since spam prevention e-mail gateways like Ironport and Postini will perform a DNS verification check each time a particular SMTP server tries to deliver an e-mail purporting to be from a particular e-mail address (domain).

As an example say a spammer tried to deliver an e-mail to [email protected], by spoofing an innocent individuals e-mail address (let’s say [email protected]) and used their spamming SMTP server to try to send [email protected] a spam e-mail. The Ironport/Postini/Spam Gateway when it’s first contacted examines the mailing domain indicated in the e-mail address of the message – say “hotmail.com” and the accompanying IP address of the spamming SMTP server.

Ironport/Postini will then contact the DNS server (which should always be accessible on the internet) for hotmail.com  to check that DNS Server’s SPF record. If it see’s that the IP addresses listed in the SPF record doesn’t match the IP address of the SMTP server that just tried to deliver an e-mail purporting to be from [email protected] it will drop that e-mail delivery attempt to [email protected], thereby preventing the spam reaching [email protected]‘s inbox. According to hotmail.com‘s DNS SPF record the spamming SMTP server trying to deliver a message purporting to be from [email protected] is not authorized…

Now back to our problem – So our news organisations Postini gateway was designating the IP address of our third parties SMTP server 137.191.225.35 as not being permitted to send e-mail on behalf of that user.

I had two problems with that –

1. First why did the SPF fail?

2. The SPF failed but [email protected]‘s e-mail got through anyway.

It was time to probe our news sources (xxxx.ie‘s) DNS configuration. In the process of doing so I discovered it was possible to expose the SPF configuration for DNS server’s available on the internet using this tool

So I plugged in the IP Address of the 137.191.225.35 SMTP server designated not authorized in [email protected]‘s e-mail header.

The Beveridge SPF Test tool then exposed the following SPF configuration for the xxxx.ie domain (some IP addresses changed for security purposes):

v=spf1 mx ip4:137.191.xxx.x1 ip4:137.191.xxx.x2 ip4:137.191.xxx.x3 -all [TTL=86400]

But I also noticed subsequent SPF test’s also returned a different SPF configuration below:

v=spf1 mx ip4:137.191.xxx.x1 ip4:137.191.xxx.x2 ip4:137.191.xxx.x3 ip4:137.191.225.35 ip4:137.191.xxx.x5 -all

So what was I looking at?

Basically one of more DNS servers for the domain xxxx.ie which our Postini gateway was performing SPF checks against had an incorrect/out of date SPF configuration. The second SPF configuration was the correct one as it listed 5 SMTP servers that were authorized to send mail on behalf of the xxxx.ie domain

The first incorrect SPF also should not have contained the  “[TTL=86400]” reference, as this doesn’t conform to SPF standards.

Cross-referencing the IP address of the 137.191.225.35 SMTP Server in the e-mail header I found that 137.191.225.35 matched a missing IP address in the incorrect SPF record. 137.191.225.35 was present in the second SPF record but not the first.

So our Postini was hitting the DNS server with the incorrect SPF configuration about 20% of the time and therefore dropping 20% of the e-mails sent because it was determining that 137.191.225.35 wasn’t authorized to send e-mail on behalf of xxxx.ie 20% of the time.

I’d figured out the issue was was due to an incomplete SPF record on one xxxx.ie DNS server but why did the e-mail from [email protected] deliver though it was given an SPF failure while some e-mails from the distribution list [email protected] were not being at all delivered?

My guess is that our Postini gateway even though it flagged [email protected] as being an SPF failure – SPF checking for Google/Postini is evidently not that strict. There must be additional spam filtering criteria in place on our Postini that flags the [email protected] e-mails based on message content, that together with the results returned from the problem DNS server flagged the [email protected] as being spam 20% of the time. Our Postini services are provided by an outsourced company so I don’t have access to the specific spam filtering criteria to verify this.

Fix:

I contacted the IT Security department manager for the xxxx.ie, who confirmed my findings and isolated the problem DNS server. The DNS server in question was not under his dept’s direct control but was managed by another dept – I’m guessing for redundancy purposes.

He logged a change to have the SPF details applied to the problem DNS server which should eliminate our problems receiving mail from any @xxxx.ie addresses in the future.

Hopefully this has given you an insight to the complex world of spam filtering….

The Blog of Martin Birrane