From today, commentfields are now disabled by default. So regular visitors are not threaten by a permanent ip-ban.

At this point every 15 minutes a script runs to filter out all the comments and put the ip-address in to ban-list and removes all the comments out of the database.

So at this point their are about 6500 ip-address in the ban-list and their are more to come!

I have often to deal with ClieOp-files. ClieOp-files are files which are used by telebankingsystems in the Netherlands to load transactions from an administration application into the telebanking application.

Yesterday I wrote a tiny perl-script to convert a ClieOp-file into a pipe-seperated-values (|) file.

The script I wrote is published under the GPLv2 license (I wrote it on my own!) and kan be downloaded from
www.adslweb.net/tools/clieop2psv/clieop2psv-0.0.2.zip

Some nice details... it converts 279.236 lines with 69.016 transactions within 1 minute!.

More information regarding ClieOp can be found at the website of Interpay (Dutch).

**UPDATE** The website of this tool can ben found here.

At this moment I am connect to a brand new project, one of the goals of this project is to find out if their is any fraud. For this investigation I received a dump of a SAP-database, with the next data:

• Transactions payable
• Authorisation levels
• Usernames

Only the "accounts payable" are up to 9.200.000 transactions

But the data was not converted in a proper format, so I wrote a tiny PERL script. The code was something like:


And it generates after a while an "Application error".


During the proces, the memory-usage was rising:


After phoning with a good friend of mine he suggested another method...


While I was running it, the memory usage and CPU-load are stable...


And it works nice and fast

And imho... this is the real cool stuff to do

Once up on a time somewhere in the Netherlands, there was a guy who gave me all his usernames and passwords to enter the systems he has access to.

Their was an application accessable via the Internet, although you need a personal SSL-certificate before you can even enter your username and password

But... no problems... just copy the personal certificate out of MS IE... and load it on another machine... log in... and you've entered the matrix.

As you can see... the human is the critical factor in security!

_{Note: The case as described above was a bet with a good friend of mine, no illegal actions did happen!!!}

In november I had a lot of visitors on my blog (and a lot of spammers, there are at this moment 3415 ip-address blocked).