Robs Blog

Blog containing all sorts of info and help from my day to day life


Macbook Air – No camera detected

If you have this problem then often the fix is to run

sudo killall VDCAssistant

After this your camera should show up in the System Information and be available to applications such as FaceTime

November 12th, 2014 by robconvery

Integration Bus – JDBC – SQLCODE=-805, SQLSTATE=51002

If you find you are hitting this SQL error when using Integration Bus with JDBC you are probably not closing off everything properly.

As documented in the Knowledge Centre, IIB maintains a connection for a given application until it idles out (default 60 seconds). As a result:

  • DO NOT close the actual connection. If you do this then IIB will have to create new connections every time which is very time and resource consuming.
  • DO  close off all statements or result sets etc.


//Connect to Stock database
Connection conn = getJDBCType4Connection(“DB_2”,JDBC_TransactionType.MB_TRANSACTION_AUTO);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

//Check current stock level
myQuery = “SELECT STOCK FROM MQPERF.STOCK WHERE ITEM = ‘” + Description + “‘”;
resultSet = stmt.executeQuery(myQuery);;
int itemStock = Integer.parseInt(resultSet.getString(1));

xp = new MbXPath(“/Body/wss:SaleRequest/SaleEnvelope/SaleList/Invoice/Item/Quantity”);
xp.addNamespacePrefix(“wss”, “”);
int orderQuantity= Integer.parseInt(((MbElement) ((List<?>)inAssembly.getMessage().evaluateXPath(xp)).get(0)).getValueAsString());
int newStock = itemStock – orderQuantity;
CallableStatement callableStatement = conn.prepareCall(“{call update_stock(?,?)}”);
callableStatement.setInt(1, newStock);
callableStatement.setString(2, Description);
progress = “CompletedUpdate”;

November 7th, 2014 by robconvery

DHCP Failing – Error 5: Access is denied starting Diagnostics Policy Service

If the DHCP stops working on your machine, this might be due to the Diagnostics Policy Service not running. If you try and start it manually you get the following error “Error 5: Access is denied ”
To fix this is simple if you know how. Run the following command from an elevated command prompt

net localgroup administrators localservice /add
net localgroup administrators networkservice /add

Then reboot and you should have DHCP back and running

October 2nd, 2014 by robconvery

Great service from Head2Heel Reflexology

Have a great reflexology session today. Very relaxing in a nice and chilled environment and best of all it was free as part of the therapists training

If you fancy a session then take a look at Head2Heel

January 25th, 2014 by robconvery

Installing Mosquitto 1.0.1 in Raspbian on Raspberry Pi

Mosquito have just released their 1.0 release..well actually its already 1.01 🙂

Currently the Raspbian repositories don’t seem to have it but its nice and easy to get working

tar -zxvf mosquitto-1.0.1.tar.gz
cd mosquitto-1.0.1
sudo make install
sudo ldconfig

Jobs a goodun. It can be checked by running “moqsuitto -v”. If you are already running a previous version you will want to restart the service using “service mosquitto restart”

August 16th, 2012 by robconvery

Heating Control System – Hardware/Software Configuration

Below is a little diagram showing some of the components of my heating Control System. This is mainly based around the monitoring side. Soon I will be adding the XRF Relay board which will be used to control the central heating.

August 1st, 2012 by robconvery

iPhone 4 – Replacement Back Panels

Well after being told by Apple its going to be £139 to replace I have been looking to see what other avenues there are. Looks like the rear panel is VERY easy to replace – Two small philips screws and then the panel slides off

Video showing this

Photo guide from

There are a few suppliers that are looking to stock replacement panels. Many from china etc but there are also some UK based traders. A couple I have found which are meant to be getting them in soon are

iPatch are looking to be able to supply just the glass (which means heating up the panel, removing the smashed glass and then sticking the new glass down) or a complete replacement panel

iPhoneFixed are looking to be able to supply OEM panels as well as Apple branded panels

So time to wait and see if these get the panels in soon. On a good note I’ve now got a case round the phone which i think would have protected it enough to avoid the smash but hey ho. Thats life. Its only a cheap effort off Ebay but its just as good as the “Bumpers” apple are selling but only cost a fraction at £4.99

June 29th, 2010 by robconvery

iPhone 4 – Back glass smashed :(

3 Days into iPhone 4 ownership……While at a wedding my jacket was knocked off a coffee table and I thought nothing of this until I took the iPhone out of my pocket and was distraught to see that the back of the phone had smashed to pieces. I was amazed such a light impact could cause such severe damage. I even still had the original protective covering on the rear as I was waiting for my protective cover to arrive.

So much for Apples – “Chemically strengthened to be 20 times stiffer and 30 times harder than plastic, the glass is ultradurable and more scratch resistant than ever”

Looks like this new iPhone 4 is more fragile than a piece of China

Removed the factory protector to see the full damage

Now we have to wait and see what Apple have to say about this “ultradurable” glass failing so catatrofically.

Update: Well Apple don’t think this is down to them and there is nothing they could have done to prevent this….well other than covering the phone in a material that didn’t smash so easily. The Apple option is to get it fixed for £139 🙁

Update 2: Well after writing a letter of complain they basicly said. Accidental damage is not covered under any circumstances. I know this is not true as it seems if your someone in a high profile position like a blogger for Gizmodo or Simon Peg they place them.

June 27th, 2010 by robconvery

How to Add Vista to Windows 7 Boot Manager

1. Invoke a command prompt with Administrator priviledge. If you don’t know how to do it. Please follow the steps in this post. The instructions are for Vista, but they are the same.

2. Type the following to list the current boot manager settings.


Windows Boot Manager
identifier              {bootmgr}
device                  partition=C:
description             Windows Boot Manager
locale                  en-US
inherit                 {globalsettings}
default                 {current}
resumeobject            {59cad9f2-de83-11dd-9d9e-c59ac6c2613b}
displayorder            {current}
toolsdisplayorder       {memdiag}
timeout                 30

Windows Boot Loader
identifier              {current}
device                  partition=C:
path                    Windowssystem32winload.exe
description             Windows 7
locale                  en-US
inherit                 {bootloadersettings}
recoverysequence        {59cad9f4-de83-11dd-9d9e-c59ac6c2613b}
recoveryenabled         Yes
osdevice                partition=C:
systemroot              Windows
resumeobject            {59cad9f2-de83-11dd-9d9e-c59ac6c2613b}
nx                      OptIn

3. Type the following to create a Boot Loader based upon the default boot loader.

C:>bcdedit /copy {current} /d "Vista"
The entry was successfully copied to {59cad9f6-de83-11dd-9d9e-c59ac6c2613b}.

4. Type the following to change the device to D: drive. Note the identifier is the one generated by step 3. This id is different for every boot loader. You have to replace it with the actual output when you create the boot loader.

C:>bcdedit /set {59cad9f6-de83-11dd-9d9e-c59ac6c2613b} device partition=D:
The operation completed successfully.

5. Type the following to change the osdevice to D: drive

C:>bcdedit /set {59cad9f6-de83-11dd-9d9e-c59ac6c2613b} osdevice partition=D:
The operation completed successfully.

When you are done, reboot the machine and you’ll see the option to boot to Vista.

CREDIT TO amida168 :

May 4th, 2009 by robconvery

Updating ESX 3.5 using esxupdate

If you have not got the VirtualCenter and thus cannot use the UpdateManager then you will have to do things the hard way and manually install all the patches. This can be a bit of a paint but the following can make like easyer

Download all the patches into a new directory ie. /files/Patches/ToApply

Untar all the files within this directory. This should produce a number of subdirectories such as  ESX350-200805501-BG etc

Run the folling command

for update in `ls`; do esxupdate –noreboot –force -r file:///files/Patches/TODO/$update update; done

This will attempt to install all the updates that have been unzipped. Check the logs to see if any failed due to the machine not being in maintenance mode. If this is the case you will have to rerun the updates.

Once finished move all the patches into a directory such as /files/Patches/Done

April 29th, 2009 by robconvery