Locating older version of MySQL 4, MySQL 5, source code, binaries, rpm, etc.

Quite some time ago, we needed to move a customer’s MySQL 4 server from one location to another. In the process, we figured we’d update the server to use some moderately modern version like MySQL 5.0 at least. Also, if we were to have any chance of virtualizing and upgrading the actual server environment to something more modern like Ubuntu 10.04.LTS or 12.04.LTS, or Debian 6.0, we’d have to re-compile the sources regardless. Not taking other incompatibilities into account, that line of thinking ran into Chuck Norris because the Windows DLLs supplied with the application using the database were not compatible with anything but MySQL 4.

The particular version of MySQL 4 running on the customer’s server was self-compiled (by us), so I figured I’d at least locate the “most recent” version of MySQL 4. To my surprise, this turned out to be harder than I could possibly imagine. In a world where “nobody” forgets anything, I could not find a single trace of a source distribution for MySQL 4. Google, Facebook, Microsoft, and Apple probably know the size of shoes I wear, but they don’t know where MySQL 4 sources are located. This struck me as very odd as MySQL 4 was a) very popular, b) open source, and c) should at least reside on half a dozen servers on the Internet, or so I thought.

Like a core dump out of the blue skies, someone Skyped me a link today. The person had ran into a mirror archive and remembered that I was looking for this “eons ago”. I have now mirrored most of that archive into/onto my own cloud store. I’ll go through that in a few days and remove the things I don’t need, but this may very well turn out to he a lifesaver.

I wonder if Sun and/or Oracle decided that keeping old MySQL versions around was a bad idea …

If you, like me, need to find some odd version of MySQL, for whatever reason, here are two links that may be of good use to you:


Google owns your content, so by all means, use Google Drive

Your content in our Services

“When you upload or otherwise submit content to our Services, you give Google (and those we work with) a worldwide license to use, host, store, reproduce, modify, create derivative works (such as those resulting from translations, adaptations or other changes we make so that your content works better with our Services), communicate, publish, publicly perform, publicly display and distribute such content. The rights you grant in this license are for the limited purpose of operating, promoting, and improving our Services, and to develop new ones. This license continues even if you stop using our Services (for example, for a business listing you have added to Google Maps).”

Google Terms of Service

It took Google five+ years to fail in cloning Dropbox, and they didn’t want people using Linux in combination with other operating systems to switch over apparently.

Other links:


How to improve Facebook-security with a few clicks

Many social platforms have been accused of a lax approach to security. They either make it very hard for their users to enable simple security measures (why?), or they simply don’t have any enhanced levels of security (why?). Facebook does have some of these features available, and they’re not that hard to enable. Go to Account settings > Security and check them out. It’ll take you three minutes, tops, to enable some basic security features.

Of course, if you leave your Mobile Phone unprotected, or are using a phone from a manufacturer that doesn’t allow application PIN-code protection, your Facebook App in your Mobile Phone will be your weakest link. If you’re using an Android device, the awesome Perfect AppLock app will let you protect your Facebook App, and anything else you want protected with a PIN-code or unlock pattern; including Gallery, Camera, Address Book, etc.

Increasing the phpMyAdmin session timeout

When phpMyAdmin is installed, the default session timeout value is too low for many users, making your phpMyAdmin session expire too soon. One could argue that a low session timeout value is a good idea from a security perspective. If you do not think this is an issue, here are a few simple steps that’ll let you change how long phpMyAdmin will keep your session(s) alive.

Open config.inc.php in the phpMyAdmin “root” directory. Look for a line that contains this: $cfg[‘LoginCookieValidity’]. Set the value to the desired number of seconds you want the session to stay alive (3600 = one hour, which is reasonable for most users). If you do not have that line in your config.inc.php file, add it like this:

$cfg[‘LoginCookieValidity’] = 3600;

Don’t forget to save the file, and then login again to phpMyAdmin. You may need to close the browser and re-open your phpMyAdmin URL.

This also assumes that the PHP session garbage collection is set-up accordingly. This can be done in a number of ways:

  • php.ini; add a line (or change an existing) that contains session.gc_maxlifetime = <seconds>
  • Apache configuration; add a line to the appropriate <Directory> block that says “php_admin_value session.gc_maxlifetime <seconds>”
  • config.inc.php (phpMyAdmin); after the previously edited line, add a line with “ini_set(‘session.gc_maxlifetime’, <seconds>);”

The <seconds> above is the same value that you set your variable to in config.inc.php at the beginning of this post, “3600” (sans quotes) in my case. (Some of these methods may or may not work on the server you’re using.)

This isn’t the only way to circumvent phpMyAdmin sessions expiring on you in the middle of that important work; you can, of course, configure phpMyAdmin to have appropriate access directly, thus allowing you to access your MySQL database(s) without entering a username and a password. You’ll find more information about this on the phpMyAdmin website.

(phpMyAdmin is, IMHO, one of the best tools ever written in its class. My only gripe is that I’d really like to have a much less bloated visual display theme as the default, but you can accomplish this yourself quite easily.)

Opera 11, an awesome e-mail client

Quite a few people know about Opera, “the other browser”. For many years it has been lurking in the shadows of Firefox and others. Opera 11 may put an end to that, or at least shake things up a bit.

I’ve been using Opera since “I don’t know when”, on and off. Quite frequently, when I’ve tried it, I’ve been put off after a few minutes of trying to view fairly simple website that has failed to render properly in Opera.

I have never once in my years of “playing with Opera” actually checked out their e-mail client. I’ve either favored the awesome Ajax-enabled interface of Work2Go (an e-mail solution offered by my company, WebbPlatsen i Sverige AB), or turned to Mozilla’s Thunderbird or Evolution for an “aggregated view of my e-mail hell”.

A few hours ago, I decided to have a quick peek and see how Opera 11 would behave under Ubuntu 10.10 on my Lenovo X301 laptop.  If I had to sum it up in one sentence, it’d be something along the lines of “That’s pretty damn nice!”. Fortunately for you (?) and me (!), I have this blog where I can make my quick review a few words longer.

This is not a scientific review of Opera by any means. As I mentioned earlier, I’ve usually been put off from further testing Opera after it fails to render some fairly basic websites. Not so this time around. This means I kept it running long enough to think of testing the integrated e-mail client.

So I configured an IMAP account with our Work2Go service, and after having entered some account details, I was up and running with an e-mail client that easily matches Thunderbird on a “basic user experience” level. Many things “make sense”, which is something I really appreciate as a programmer. I often think thoughts like “It would be nice to have ‘this’ function here”, and I found ‘this’ function to actually be where I expected it to be quite a few times. Fascinating.

E-mail clients easily becomes a matter of principle, habit, and religion with their users. I’ve played with Eudora, Outlook, Live, theBat, Evolution, and a few that I’ve long since forgotten the name of, and now Opera 11. Each has its pros and cons, but Opera is definitely on to something here. While it won’t provide me with the total integration that I like in Work2Go (Documents, Calendar, synchronized address books, mobile sync with my HTC Wildfire, etc), I’d say I’ll keep this as an alternative.

But don’t take my word for it, try it out for yourself! And don’t go mistaking the full blown version of Opera 11 with Opera Mini available for many mobile and lightweight environments, they’re a world apart (or “fjord” as it might be).