Securing mysql

Everyone knows, first thing you have to do after installing mysql, is setting its root password. I used to do this using the mysqladmin tool like this:

/usr/bin/mysqladmin -u root password 'new-password'

For starters, you should not forget to do the same command for your other host names (-h option), but also there are still some other tasks like disabling anonymous access and removing the test databases. Today, having another mysql install, I noticed that the install script mentions this neat tool packaged with mysql to do just all that. :)

Just run /usr/bin/mysql_secure_installation and you’re done!

Van Dale dictionaries on linux

After several rant mails to the Vandale publishers house, I finally gave in/up. About a year ago, I complained that I couldn’t buy a linux version of my favorite Dutch dictionaries (not that there is a choice when it comes to digital Dutch dictionaries). Online dictionaries don’t cut it for me, I always need the words (or expressions) that free online ones don’t provide. ;) The answer was that there does not exist a linux version. So I asked when the linux version would be released. The communication stalled but apparently it got escalated and I got an answer by another person telling me there was no linux version planned, however he was delighted to announce the availability of a Mac version within only 3 months!

You know this smiley banging its head against the wall? That’s me, banging my head… How can they be so stupid to port to another platform and not take cross-platform toolkits into account?? I couldn’t help myself, so I started to lecture “cross-platform 101″. ;) I am not sure if I was able to get through to him, but I hope at least a few fragments stuck in his mind. :)

In the meantime, they do have a mac version. I never received a reply to my plea. So I decided to give it a try under wine. Surprise, surprise (not), it works! (using the win2k installer patch). Sometimes, wine can really be a godsend. For the occasion, I created a few desktop icons since the original ones suck badly.

I created them by drawing bezier curves with the original icon from the website in overlay. It actually sounds easier as it sounds. :) I had to tweak my beziers quite a bit to have a somewhat appealing result. Since this will probably be the last time I will take a KDE3 screenshot (still on my suse 10.3), I decided to post a screenshot of the icons with my desktop in full glory ;)

Vandale icons

Also spot the home-made icon for Cave Story, but that’s merely a rip from the game resources ;)
Here are the icons in case you want them too:
vandale icon Englishvandale icon French

Opera 10: it’s unbelievable

Opera 10 seems to bring ground-breaking news for people using Opera Mail. It seems they finally got hold of the resources needed to implement the 2 most asked features ever! Behold:

  • Rich text email composition
  • Remove mail from server after X days

Can you believe it??!! After all these years of denial? I for one surely didn’t see that one coming. :) Read the full changelog here.

AVG antivirus makes another mistake

Since AVG8 had a terrible performance on my parent’s computer, I am very glad now I moved to another AV soft as it seems AVG is suffering a major bug right now which causes your windows to stop working! Note that this problem is not affecting all versions, but guess what, Dutch is one of the affected ones!

In the meantime, I have switched to Avira Antivir, but that didn’t last long either as there came nasty popups about potential threats which scared the hell out of my mom, only because she was using the free version instead of the professional one. Also, it doesn’t have an email scanner.

So, currently, they are running Avast Home edition. It comes with a whole lot of crap (‘advanced’ antivirus shields) which you will want to disable. You might also want to disable the automatic checksumming of every file on your box, because obviously it generates a lot of I/O, especially when you don’t want it.
But it does automatically reroute pop3 and smtp connections so email traffic gets scanned automagically without any configuration (which is a relieve in comparison with AVG where you have to configure it manually if you don’t use M$ crapware like outlook). There was one catch, as it seems your free download version ‘expires’ after 30 (?) days, unless you register it. No problem, registration is free. It seems you have to reregister every year in order to be able to keep using it. Sounds fair enough to me: if you keep using the AV soft, it means you’re satisfied, so why not let them know you are using it by registering it for free.

It kinda reminds of this funny article, in which one argues Windows should become Ad-ware. :) I sure woudn’t mind using an adware version, as long as I can play my games full-screen. ;)

Even more pdf fun on linux

Who says pdf support on linux is weak? ;) Using free tools only, I can actually do more on linux than on windows.

A friend asked me to adapt a brochure which is in pdf format so that his contact data are filled in at the designated area on the last page. I didn’t have high hopes, as I know pdf editing is clumsy, even on windows using Adobe Acrobat. But I thought I’d give it a google search, and guess what, I stumbled upon pdfedit which seems to be able to do the job quite adequately! The only downside is the speed. I hope they port it to Qt 4 and fix the speed issues while they’re at it. ;) (and apparently there are some plans!)

pdfedit ftw

Converting multiple images into a pdf on linux

Update 2012-03-13
I don’t know if it was possible back in 2008, but nowadays you can simply use the convert command provided by imagemagick!

convert image1.jpg image2.jpg output.pdf

Normally, when I need to create a PDF, I can print to the PDF printer included with KDE. However, on my suse box, this only seems to work out of the box with KDE apps. Also, since I need to combine multiple images into a pdf, it is a bit cumbersome to use a PDF printer here.

I didn’t find a one-step solution, so here is how I did it:

  1. convert each image to a pdf
  2. merge all pdfs into one pdf file

For the first step I used bmeps, a tool which I recently discovered by accident :) It is strange, when searching for the tool, I didn’t find it. So that’s why I give it some extra promo on my blog. ;) Bmeps is a cross platform tool (yes, I already once used it succesfully on windows!). It used to be a (E)PS tool, but since version 2.0 it also supports PDF output (up to PDF version 1.4). As input, it accepts JPEG, netpbm and PNG (and TIFF partially).

As Bmeps doesn’t seem too popular, I wasn’t too surprised to learn my distro doesn’t have any package for it, so I had to build it from source. Bmeps has a dependency on dklibs, a collection from the same author which also needs to be compiled. But it turned out to be a pleasant experience: all prerequisites were already satisfied on my computer (except netpbm, but I don’t need that) and I just had to run the familiar “configure make install” (once for dklibs and once for bmeps of course).

After that, converting an image to a pdf is as simple as:

bmeps image.jpg image.pdf

Now we have a bunch of pdf files, we still need to merge them. For that I chose the quite popular pdftk. It wasn’t installed by default, but there does exist a package in the suse main repositories, so that was easy. Now, to combine all pdfs into one:

pdftk input*.pdf cat output output.pdf

And that’s it!

PS: there used to be a tool png2pdf from the same author for people wanting to convert PNG files, but this has been superseded by bmeps.

Boot process explained

It’s always nice to be reminded of the more important things in life, like how computers boot, *ahem* :)
Seriously, as a computer enthousiast, it’s like I _have_ to know about it, yet I don’t seem to be able to remember all the details :)
So guys like duarte chop it into nicely digestable pieces, ideally suited as bed time story material, so it can enter your subconscience when you go to sleep =)

Opera 9.5 released!

Yes, finally I will be able to use the latest flash player again in Opera on linux. :)
For me personally, the highlights in this release are:

  • Support for latest flashplayer
  • Even faster
  • Revamped mail backend. Might wanna reevaluate the newsfeed fetching performance. (It had become unacceptable with 50+ feeds)
  • Builtin bookmark syncing
  • HTML 5 support
  • Dragonfly: web dev tools

Read the full changelog here.

AVG 8

I have been a long time satisfied user of Grisoft’s Antivirus suite, for my parent’s computer actually. What’s important for me is a good configurable email scanner and a fast on-access scanner. Until 7.5 AVG seemed OK in those aspects. However, last week, I upgraded AVG 8 as I thought this was just a regular upgrade. Little did I know they vistafied the crap out of (or rather in) it. The interface is dumbed down so you always need to use the advanced options menu. They added some bloat features like the link scanner[1] and antispyware stuff. But worst of all: it slows down the entire system! When even my mother complains the system has slowed down since the upgrade, you can be sure it is a remarkable slowdown ;) I am guessing this must be a bug, maybe it does not occur on all systems. I can’t believe they would make such a jump downwards. In the meanwhile, I am looking for alternatives. Avira’s Antivir seems quite okay..?

[1] fortunately, you can remove this feature through a custom installer command