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 […]

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 […]

Windows 7 – Windows Update error 8007000D

The following fixed this for me 8007000D – Error_invalid_data. Corruption in the SoftwareDistribution folder. Please rename %windir%/Softwaredistribution folder. To rename the Windows Update temporary SoftwareDistribution directory follow these steps: 1. Start an administrative command prompt. 2. Run the following commands hitting enter after each line: Net stop wuauserv cd %systemroot% Ren SoftwareDistribution SoftwareDistribution.old Net start […]

Hendy Bodyshop – How many attempts does it take??

We had the unfortunate to need to have our virtually new Mazda 3 repaired after an accident in which it sustained some quite bad damage When we got the car we were told all about the Mazda Accident Aftercare and so thought this would be the time to put it into action. Our insurer wanted […]

Mosquitto 1.0 python changes

Looks like there have been some changes to the Mosquitto v1.0.1 python libraries. So far only hit the one but it was quite a major one. The connect method has been changed. If you try and run your code you will get Traceback (most recent call last): File “test.py”, line 13, in <module> mqttc.connect(broker, port, […]

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 wget http://mosquitto.org/files/source/mosquitto-1.0.1.tar.gz tar -zxvf mosquitto-1.0.1.tar.gz cd mosquitto-1.0.1 make sudo make install sudo ldconfig Jobs a goodun. It can be checked by running “moqsuitto -v”. If you […]

Using node.js WebSockets to get live MQTT updates

To keep some of my pages up to date with the live sensor data I am using websockets to get MQTT publications. On the server there are two parts. A Python script which is monitoring a serial port for data and then publishing it accordingly. Information about this can be found at  XRF Temperature Sensor -> […]