Fix WordPress / IIS Unable To Get Local Issuer Certificate Error

SSL certificate problem: unable to get local issuer certificate” is an error message WordPress kept presenting to me when i was trying to integrate my Instagram / Twitter feed in to this blog. The good news is the fix is really easy, once you know how!

Basically the problem was a PHP configuration issue on my server, i needed to have a list of up to date public Certificate Authorities defined in my php.ini file.

I found a list of public Certificate Authorities that were extracted from Mozilla’s root certificates file, these are used in the FireFox webbrowser.

This list contained the certificates in PEM format, therefore could be directly used with curl / libcurl / php_curl, or with an Apache+mod_ssl webserver for SSL client authentication.

How to fix the unable to get local issuer certificate problem:

  1. Downloaded the cacert.pem (mirror) which has been extracted from Mozilla’s root certificates file
  2. Opened your PHP.ini file, the location of this will vary depending on your configuration.
  3. Then added the following line: curl.cainfo=C:\inetpub\cacert.pem

Remember to change C:\inetpub\ to the path of your cacert.pem file.

As my webserver is IIS i placed the cacert.pem in C:\inetpub so IIS had access to it.

After the PHP configuration has been updated re-start your webserver, you should then no longer get errors such as “SSL certificate problem: unable to get local issuer certificate”

A simple fix once you know how.

Ebay File Exchange – Update Listings With Variations

This tutorial will teach you how to update listings with variations on Ebay, using Ebay File Exchange. This task will be completed with one simple upload to Ebay File Exchange. If you have been re stocking your item quantity or revising prices manually, this is guaranteed to save you a lot of time.

If you have found this tutorial and are new to Ebay File Exchange have a look at my previous tutorial which covers

  1. What is Ebay File Exchange
  2. Creating a template for Ebay File Exchange uploads
  3. Revising the price and quantity of multiple single item listings
  4. Uploading to Ebay File Exchange

Read: How To Update Product Quantities and Prices Using Ebay File Exchange

 

How to update listings with variations using Ebay File Exchange

Presuming you have followed my previous tutorial linked to above it is actually quite easy to advance your Ebay spreadsheet to update the quantity and prices of listing which have variations, and even multiple variations.

First i will show you how to update an item with a single variation, for example multiple colour choices, then after that i will show you how to update an item with multiple variations, for example colour and size variations.

Updating an Ebay listing with a single variation using Ebay File Exchange:

Again i will presume you have a basic template setup from reading my previus tutorial, if not you can download my Example Ebay File Exchange Excel XLS Template which you can open in Microsoft Excel.

To get started our spreadsheet should be setup as follows:

ebay-file-exchange-variation-template-1

In this example our Ebay listing with variations is as follows:

ebay-file-exchange-variation-template-2
So nice an easy, our variation is called Colour

And our variation choices are:

  • Red
  • Blue
  • Yellow
  • Green

So to set this up in our spreadsheet we would enter the following

  • Action = Revise (We are revising an existing listing)
  • ItemID = 100916777364 (obviously this vary for every item you wish to revise, your item must already be listed on Ebay)
  • Relationship = Leave this empty for now, you will see why in a minute
  • RelationshipDetails = Colour=Red;Blue;Yellow;Green (Here you must enter the variation name, so for this example it is Colour, you then want = followed by the name of each variation. Each variation must be separated by a ; (semicolon) you do not need to put a semicolon after the last variation however.
  • Title = Matts Single Variation Example (This is the title of the item as listed on Ebay)
  • Quantity = Leave this empty for now, you will see why in a minute
  • StartPrice = Leave this empty for now, you will see why in a minute

If you follow the above you will end up with the following:

ebay-file-exchange-variation-template-03

The important bit here is that you have all your variations in the RelationshipDetails column.

Now all we need to do is add each variation to its own row below, if we do it for the first variation we will end up with the following:

ebay-file-exchange-variation-template-05

Here ebay already knows we are looking at item 190811999538 so we simply need to enter the following for each variation

  • Relationship:Variation
  • RelationshipDetails: Colour=Red (Here you always need the variation name, which in this example is colour, then the = (equals sign) along with the name of the variation
  • Quantity: This is how many of the particular variation you have to sell
  • StartPrice: Again this is unique to that variation, the price you wish to update the variation to

You simply need to repeat the above for all the variations a product has and you would end up with the following:

ebay-file-exchange-variation-template-04

That it, when uploaded to Ebay that would update the price and quantity for all the colour variations in that Ebay listing.

Updating an Ebay listing with multiple variation using Ebay File Exchange:

Now you have learned how to update a listing with a single variation, we can expand upon this and update an Ebay listing that has multiple variations, for example colour and size.

In this example our first variation is called Colour and the second variation is called Size

Our Colour variation choices are:

  • Red
  • Blue
  • Yellow
  • Green

Our Size variation choices are:

  • 1
  • 2
  • 3
  • 4

So to set this up in our spreadsheet we would set this up very similar to doing a single variation, however we would use a vertical bar (|) to separate each variation choice.

ebay-file-exchange-multiple-variation-template-1

 

So basically as can be seen about all that has changed is that the relationship details have the additional options from the second variation, separated by a vertical bar: Colour=Red;Blue;Yellow;Green|Size=1;2;3;4

As before when we set details up for the variations we need to do this again, however we must now do it for every possible combination of your variations, e.g. Red in size 1,2,3 and 4.

So for example that would then look like this:

ebay-file-exchange-multiple-variation-template-2

We now basically have to repeat that for all the other variations in your listing, so we would end up with the following:

ebay-file-exchange-multiple-variation-template-3

As you can see from the above screenshot the spreadsheet has an entry for every possible colour variation, in every possible size variation.

That is basically it, you should now be able to create a spreadsheet that can be uploaded through Ebay File Exchange, that will automatically re stock all your listed items to a specific quantity, and allow you to update the price of items and variations with ease.

Ebay File Exchange Example Downloads:

Here are XLS (Microsoft Excel) downloads of the examples from above, this might be a good starting point to work from, or to reference if you are having problems.

Ebay File Exchange Single Variation Example Download
Ebay File Exchange Multiple Variation Example Download
Ebay File Exchange Single Listing, Single Variation and Multiple Variation Example Download (This shows how you can revise different types of listing all from the same spreadsheet)

Remember in part one of this blog post I talked about setting the spreadsheet up in more detail and actually uploading to Ebay using File Exchange.

I hope this blog post is useful anyway, it her certainly saved me a lot of time updating Ebay listings like this, if you have any questions i’ll try my best to assist you.

Create a VMware ESXi Bootable Flash Drive on Windows

Why create a ESXi Bootable Flash Drive on Windows?

Lets be honest, I personally find burning a disc to install something a waste these days, chances are you might not even have an optical drive in your main computer any more if your anything like me.

Creating a bootable usb flash drive to install VMware ESXi from on Windows is easy thanks to UNetbootin. UNetbootin allows you to create bootable usb drives for Linux distributions without burning a CD. I find this tool very handy now as more computers and servers are running without CD drives, plus its a lot quicker to transfer the contents of an ISO to a USB drive then it is to burn a disc!

Creating a VMware ESXi Bootable Flash Drive on Windows:

  1. Firstly Download UNetBootin
  2. Connect the usb flash drive you wish to use as your VMware ESXi Bootable Flash to your computer, note this process will erase the contents of the flash drive.
  3. Load UNetBootin and select the diskimage radiobox, choose ISO, then select the ISO you want to use.
  4. Below select the type as a USB Drive, then finally choose the drive letter of your USB Memory stick, for myself this was F:\
  5. Click Go

Create a VMware ESXi Bootable Flash Drive on Windows

 The end result will be a bootable flash drive that can be used to install VMware ESXi.