Okay machine ‘I am behind a VPN’ can be accessed locally:, with OpenVPN it is behind an external IP address, not mine
I set up a VPN to my local network: is my IP when I am behind a VPN, when I try to access it is not allowed, where other machines in the same network are ok.
This is due to the OpenVPN connection being active (when disabling OpenVPN, than all is ok), so trying to be able to allow the remote VPN access the machine.

Now I did 2 things and I believe the first command did it.

1. used a new route:
ip route add (VPN) via (router) dev eth0

and I used
2. iptables -A INPUT -s -j ACCEPT (but this one did not work, but I will mention it .. you never know)

There is a nice tool for updating your db (mine is MySQL) with a tool called texturecache

this info is for my own purpose if useful use it

Crontab in place

0 */2 * * * sh /home/kodi/kodiupdate.sh > /dev/null 2>&1

echo “Start Scanning Video Library vscan”
/home/kodi/texturecache.py vscan
sleep 5
echo “Start Cleaning Video Library vclean”
/home/kodi/texturecache.py vclean
sleep 5
echo “Start update with qax”
/home/kodi/texturecache.py qax
echo “Start scanning texturecache with function C”
/home/kodi/texturecache.py c
sleep 5
echo “Prune data missing on disk P”
/home/kodi/texturecache.py P
sleep 5
echo “Start update with Xd”
/home/kodi/texturecache.py Xd
sleep 3
echo “Start update with ./texturecache.py R”
/home/dennis/kodi/texturecache.py R
sleep 3
echo “end”

Make sure that there is a connection with your “Master Kodi”
create a samba link in /etc/fstab ie. example
// /media/kodi cifs guest,uid=1000,iocharset=utf8 0 0
now the thumbnails can be saved correctly


A number of Windows 2008 server installations where designed to have 1 DISK with 100GB deviced in 50GB C and 50GB D. Unfortunately 50GB is too less if you run a server and want to apply all patches. (Previous downloaded patches are kept in a ‘storage’ and cannot be deleted, finally consuming a lot of HDD space.

To solve this: add a DATA DISK to the instance in Cloudstack. Please note: the DATA DISK will not be found / seen or identified automatically by the Windows Server

Through the managment panel within Cloudstack you need to attach an ISO: VIRTIO (Leaseweb does provide this)

Within the Device Manager an SCSI device has been found, but no drivers can be applied, therefore the ISO you need to attach so that the VIRTIO drivers can be applied to your machine.

Now the drive will become available and you can format etc..

To expand the C drive: remove all data from the partitions/drives not needed (D, E etc.) You can also copy the content to the new DATADISK you now have.

By default through the DISK MANAGER (under Server Manager) you  CANNOT expand the root / boot disk. You can try all kinds of freeware stuff: no go, it will all point you to version you have to pay $$ for.

The solution is to use DISKPART. As Administrator open a CMD window and enter:

List Disk <Enter>
Select Disk 0 <Enter> (Assuming that Disk 0 is your boot/root disk)
Detail Disk <Enter>
Information about your disk is given, you see the volumes
Select Volume 1 <Enter> (or 2 depends what is your Volume with C)
Extend Size = 20000 (20000 gives you an expand of 20GB for your C drive).

Repeat some commands if not all storage is given to C ..

Exit <Enter>

upgraded ESXI to 6.5 U1 which is version 6.5.0 build 5969303

You are running HPE Customized Image ESXi 6.5.0 version 650. released on July 2017 and based on ESXi 6.5.0 Vmkernel Release Build 5310538

unfortunately the HP Microserserver Gen8 is than running with: HPE_bootbank_scsi-hpvsa_5.5.0.102-1OEM.550.0.0.1331820

As I was (and still am but as of writing I am in maintenance mode) seeing spikes in my CPU usages. It might be caused by the bad performance

checking with:
cd /vmfs/volumes/datastore1
time dd if=/dev/zero of=tempfile bs=8k count=1000000

It took a very long time to see some output. (Very long time!)

than I tried to downgrade to the hpvsa-5.5.0-88.zip driver


  1. enter maintenance mode
  2. I do a reboot, but you can do it probably without
  3. copy the downloaded driver to /tmp/ and run the following command
  4. esxcli software vib install -d /tmp/hpvsa-5.5.0-88.zip
  5. the old driver will be removed and the 5.5.0-88 driver installed
  6. Now important: if you do reboot this way: you will not see your DataStores anymore, only your NFS datastores (in my situation) this is caused by VMWARE ESXI as it will be using vmw_ahci driver for the datastore.
  7. so disable the usage of this ‘default’ driver: esxcli system module set –enabled=false –module=vmw_ahci
  8. now you can reboot and your device will be using the 5.5.0-88 driver
  9. you can see this by using; cat /proc/driver/hpvsa/hpvsa0

the speed should have been returned.


Wauw ..

yesterday and today I tried to upgrade my HP Microserver Gen8 from VMWARE ESXI 6.0.0 to 6.5
what a trouble ..

shut down all vms (hosts) and enter maintenance mode. If you do this there are a number of online blogs with help to install from online depots but in all my tests it was too slow or I was to impatient to wait to end. But in the end I always ended up with an system with errors:

the transaction is not supported: VIB Hewlett-Packard_bootbank_scsi-hpvsa_5.5.0-88OEM.550.0.0.1331820

Do not try to force the installation. You will end up with an system where it seems that your EXSI is updated to 6.5 but actually is is running in a ramdisk environment. Easy to see cause you have lost your datastores (NFS datastores are still mounted).

If you than reboot: you are back to 6.0.0 .. so how to solve this:

easy: when entering maintenance mode: reboot your machine. In many guidelines this part is not mentioned.

After I rebooted I first tried the online depot installation documentation but ended up waiting and waiting. I got a VMWARE image for update from VMWARE but I got all kinds of different issues again:

“The upgrade contains the following set of conflicting VIB” When using the standard image of VMWARE: many conflicting vibs a no go for me. So I read some blogs and I found out that it is best to keep using your HPE image vmware files. (So in short: if you used the HPE VMWARE ESXI ISO installing Esxi onto your HP Microserver Gen8 keep using the update files with HPE in it and not the plain VMWARE onces. It can give issues !

After I used the HPE image I only got 1 issue: one vib was still complaining. On this blog I read what I needed to do: remove this vib (partner supported, so not native).

After removing this VIB I could upload the various ZIP bundle files like


with the command:
esxcli software vib install -d “/vmfs/volumes/datastore1/patch-directory/VMware-ESXi-6.5.0-5310538-HPE-650.”

I was able to install finally the 6.5 version. Due to issues of Storage driver I immediately updated to the U1 update
with the command:

esxcli software vib update -d “/vmfs/volumes/datastore1/patch-directory/VMware-ESXi-6.5.0-Update1-5969303-HPE-650.U1.”

the blog nxhut showed me some info that with the U1 version the storage speed performance issues should be over.

A simple test downloading a file towards a VM showed me a 18MB/s so the 10MB/s barrier was not seen.

A last reboot and get the machine out of maintenance mode. Finally I have a running 6.5U1.


Yeah .. wierd title

So in my case: I am at location A and I am making a VPN to my local network what is at location B

I can access all my local servers and computers, but one !

“The One” is a server which has a dedicated openvpn connection to location C, when this is active my VPN from location A cannot access “The One” at location B. Only when the OpenVPN connection is terminated

Solution: add a static route on “The One”

check with: ip route show

and add the route like this: ip route add via dev eth0

where is the VPN IP range what your local network is giving VPN users and via is the IP of your gateway (router)

… easy peacy ..

Google zegt dat deze site mogelijk gehacked is ..

en laat dat nu eens niet het geval zijn

Deze site is mogelijk gehackt., zegt Google. Ja maar …. en dan ga je zoeken, testen en je weet me god niet waar je moet zoeken. Want .. tsja je krijgt wel een link, maar als je link naar de weblog sectie van deze site verwijst dan staan daar een x aantal berichten onder met wat ‘technisch’ karakter, maar dat is het dan wel .. heb dus totaal geen idee waar ik moet zoeken of wel stukje code wat ik getikt hebt een trigger is voor Alphabet’s Google ..

Mocht je iets vreemds bemerken, ik hoor het wel, tot die tijd blijven we ons afvragen wat er mis zou zijn .. (Ik heb het theme is al veranderd .. ) dus een theme hack sluit ik even uit


update: Na eerst 1 pagina aan te merken als iets wat niet goed zou zijn, vond Google dat dan de gehele site wel even geïnfecteerd was. Maar echte duiding wat er dan mis is: nope ..

Dus ..

update: diep in de spelonken van dit weblog was wel wat aan de hand met wat gemodificeerde bestanden maar zou niet zo 1-2-3 kunnen zien of dat Google zou signaleren .. maar goed , WordPress maar even waar nodig geheel verwijderd en opnieuw geïnstalleerd zodat er geen ‘historie’ van oude bestanden meer aanwezig was.

Tevens een aantal folders die niet meer gebruikt werden ook verwijderd zodat dat ook geen belemmering zou kunnen geven ..Zie hier . site is weer ok .. zegt Google dan ;)

For many years I am using PGOffline, a tool to get all the content from yahoogroups.

PGOffline was using up to version 3 an Access Database but with the release of version  4 they went to an SQLite database.  Here came my problem.

For years I was inserting the data from the Access Database into an MySQL database so that with an PHP script I could search through more than 100.00 messages.

But after PGOffline went to SQLite I had an issue cause my ODBC connection was not working anymore. Due to some change in PC’s and notebooks I lost my access database with the ODBC and Queries as well (damn .. )

Altough the mailinglist is not that active anymore, there were some 6000 messages submitted in around 1,5 to 2 years. and I want to have them inserted in the MySQL database still ..

The issue I had was that the SQLite database of PGOffline contains a BLOB (Binary Object)  with the message and is not ‘simply’ readable.

for months I was trying and there was no solution for me to fix that. Until last weekend. And actually it was pretty easy. And I fixed it ..

1. Microsoft Access

2. Make sure you have access to your MySQL database and able to connect to it (do check my.cnf for the bind address (if you are on Linux) make sure you can connect to it from other machines) and make sure the firewall does not block its port (which I noticed after 15 minutes of trying or so)

3. install MySQL ODBC drivers in your environment

4. install SQLite ODBC drivers in your environment

In Access make sure you link to the database with linked tables.

the SQLite database is just the file. In my example its on the same computer as the Access database

The issue I had with the SQLite database and its linked tables was that the ODBC driver did not allow me to search with wildcards (select * from person  where person is like ‘a%’) . To make sure I have all subscribers I made an update query to a local table with all the persons, but in fact that is not needed.

Than I made sure I could read the messages

with this query: ‘StrConv([content],64)’ I was able to decode the BLOB.  and with some other InStr queries I removed the beginning and end of the start of the message as this is ‘garbage’ not needed, I added some HTML breaks.

Finally I created an update query inserting all the new messages from the SQL database not in the MySQL database, I even found that very old messages were not imported at all they were forgotten, now they were inserted as my Query statement request to insert all YahooMessageID’s not in the MySQL database ..




Gisteren de website overgezet naar https, gewoon omdat het kan en omdat ik eea wilde uittesten met een certificaat op de website. Het werkt. Ik ben er dus blij mee. Certificaat werkt voor een jaar dus daarna zien we wel verder ;0)

Alleen krijg ik momenteel het niet voor elkaar om die www  eraf te halen (too many redirects) .. uhmm zal wel een foute plugin zijn ..

[nerd mode] this article includes the update with solution ;-)

Does someone know how to configure Munin to change or rename graph titles of a smart switch with SNMP?

I have a smart Ethernet switch and I get my SNMP data, but the interface ports are called: interface port 1, interface port 2, interface port 3 etc.. But I want to have this renamed so that I can identify the various interface ports as: router, NAS, uplink, wireless, server1, server 2 etc.

Is it possible to configure this with munin?

I’ve looked in the docs, but cannot find anything about how to rename something.

Update, after long searching and looking through manuals/guides/how-to I have found what does the job [this was the entry telling me: hey that could be the solution]

in munin.conf select the config part where the device / node is configured

use_node_name no

Under use_node_name no you can put your manual ‘overrides’

Port one of my smart switch is called:

  • snmp_highway1_if_err_1 (for errors)
  • snmp_highway1_if_1.graph_title (for traffic)

So here I define the names of the interfaces:

snmp_highway1_if_err_1.graph_title [P1] Cable/Router Errors
snmp_highway1_if_1.graph_title [P1] Cable/Router Traffic
snmp_highway1_if_err_2.graph_title [P2] Smart Switch Boven Errors
snmp_highway1_if_2.graph_title [P2] Smart Switch Boven Traffic
snmp_highway1_if_err_3.graph_title [P3] AccessPoint/Switch Kamer Errors
snmp_highway1_if_3.graph_title [P3] AccessPoint/Switch Kamer Traffic


The magic is done with .graph_title, per interface you can define the graph title.

After 5 minutes of waiting my graphs are being updated and generated with the correct interface names so that you can remember what you have connected to which port of your smart switch (in my case).