Escape from boredom

The past few weeks there has been a boost in comment spamming in my blog. Quite annoying when I have to delete 5 to 10 spam comments each day. So I decided to disable comments on old posts, but it was not as straight forward as I wanted. It is possible to disable pr. post, but with 10 years of blogging doing it manually is no option. But luckily I found this SQL statement

UPDATE evo_items__item SE T post_comment_status = "closed" WHERE NOW() > DATE_ADD(post_datecreated, INTERVAL 10 DAY)  

Solution found on the B2Evolution forum. Must admit that even though it is a one liner, it goes way above my head 🙂

There might be several reasons for that, most of them revealing themselves by information in the startServer.log. But earlier today when trying to start the deployment manager it just would not start, saying that I had to look into the startServer.log, but even if I tried several times no new info was to be found. “ps -ef | grep java” revealed no WebSphere processes running, so still no clues. So I gave up and wanted to create a PMR, thus needing to zip the logs-folder, but that process failed. So then I ended up issuing a df-command, realizing that due to some previous heap dumps there was no more disk space left, which caused the dmgr not being able to start. Cleared the disk and voila, back on track.

Then later I got a problem when applications would not install, the error message was

WASX7114E: Cannot create temporary file in directory “null”

Found this technote http://www-01.ibm.com/support/docview.wss?uid=swg21300016 which mentions the same message, but the solution is simpler than in this case. In fact the /tmp-folder was full with dump-files as well. So when cleaned up, application installation worked as a charm again.

Last week I attended the IBM WebSphere Technical Conference in Düsseldorf, Germany. As always a good event when it comes to the stuff I’m working with, and also good for networking.

Some pictures – first two from the airport train to Gardermoen

The first hotel room I got, missing something important…the bed

At Saturn trying 3D-TV. A bit cool, but if you ask me “Do you want it?” the question is no, just look how stupid the glasses are 🙂

Monday evening at Brauerei Schumacher trying the Schumacher Alt-beer

Traditional German food

Out walking next to the Rhein river

I have had it with a menu in Build Forge – could not understand why the elements where not alphabetically sorted even though the Perl script generating the menu had a line like this

sort( @entries );

So Google to the rescue, I found this article about Perl Sorting Techniques http://www.perlfect.com/articles/sorting.shtml and just had to change the line of code to

@entries = sort { $a cmp $b } @entries;

Problem solved!