PHP-Script for sending personalized html newsletters

I searched for a simple solution to send some personalized html e-mails with embedded pictures. However I didn't find one. Thus I created the following script:

Find out what library is missing Fedora 22

Sometimes some libraries are missing. This leads to the following error message:

./command: error while loading shared libraries: cannot open shared object file: No such file or directory

It will only display the first missing library. So first you can use the following command to identify them:

ldd idaq | grep found

This might lead to the following output, where you can see a list of all missing libraries:


Run IDA Disassembler on x64 Fedora 22

When executing idaq I got the following error message:

./idaq: error while loading shared libraries: cannot open shared object file: No such file or directory

This error appeared because I lacked some libraries (32-Bit version). To fix it I had to run the following commands:

dnf install glib2-devel.i686
dnf install freetype.i686
dnf install libSM.i686
dnf install libXrender.i686
dnf install libXext.i686
dnf install fontconfig.i686


DevArt Bulk Data Insertion into an Oracle Database

There are some possibilities to bulk insert data. For my tests I inserted 1'500 rows containing some strings.

  • Use the Context: 50 seconds
  • Use ArrayBinding: 43 seconds
  • Use the OracleLoader class: 14 seconds

It seems that the OracleLoader is the fastes way to do this.


Oracle SQL Fast Retrieval of CLOBS

If a table contains CLOBS, depending on the method you use to connect, usually the CLOB-columns just return a handle that will trigger another connection/query to the database in order to retrieve the value. This makes it really slow. An easy way to speed it up is to retrieve everything which is small enough as string value. A string value however is limited to 4'000 characters. Thus you need to issue two queries:


Import local subversion repository to git

If you want to import a local subversion repository (maybe a dump) to git you can do this quite easily:

First you need to map the Subversion commit authors to Git commiters. For you just create a textfile author-mapping.txt:


And then you run the following commands:


Mangled Names on Synology Diskstation

From time to time I noticed strange filenames on the Synology Diskstation. Names like BGELMF~0. They always had a tilde. Those strange names are called mangled names. Samba has a feature to provide them to bad clients. Unfortunately this can also lead to "renaming" those files.

It is better to prevent this behavior altogether. To do this you need to connect over SSH to your diskstation and then you need to login as root.

Issue the following commands:

cd /usr/syno/etc
vi smb.conf

Now insert the following line in the section global:


Exact Copies for Backups

In order to create a backup you should first of all make an exact copy

rsync -aHAX --delete /srcfolder /dstfolder

And then also check if the copy is indeed complete and exact:

diff -r /srcfolder /dstfolder


Drupal PHP Fatal error Call to a member function getElementsByTagName()

I suddenly started getting the following error:

PHP Fatal error:  Call to a member function getElementsByTagName() on a non-object in public_html/drupal/modules/filter/filter.module on line 1122

I checked what there is on line 1122. I could clearly see that the error needs to happen because $body_node was null. For a quick fix I just implemented a null check as follows:


Create a pdf from pictures

Sometimes I receive scanned documents as numbered jpeg pictures. It would be a lot more handy to have a single pdf file containing all those images. This can easily be done using bash:

convert PartOfTheDocument*.jpg WholeDocument.pdf



Subscribe to RSS