Re-compiling MySQL 5.0 with OpenSSL support under Debian

If you’ve ever required OpenSSL support enabled for MySQL Server 5.0 under debian, then you will need to recompile MySQL. Under Debian this is very easy.

If you’ve ever required OpenSSL support enabled for MySQL Server 5.0 under debian, then you will need to recompile MySQL. Under Debian this is very easy.

First you will need to download the package source, as root type the following:

cd /root
mkdir build
cd build
apt-get source mysql-source-5.0

The above commands will create a folder called ‘build’, enter the directory and then download the mysql-server-5.0 package source. The following are the results under an Ubuntu server:

[[email protected]:/root/builds]# apt-get source mysql-server-5.0
Reading package lists... Done
Building dependency tree
Reading state information... Done
Need to get 16.8MB of source archives.
Get:1 feisty-security/main mysql-dfsg-5.0 5.0.38-0ubuntu1.1 (dsc) [1209B] Get:2 feisty-security/main mysql-dfsg-5.0 5.0.38-0ubuntu1.1 (tar) [16.6MB] Get:3 feisty-security/main mysql-dfsg-5.0 5.0.38-0ubuntu1.1 (diff) [149kB] Fetched 16.8MB in 17s (957kB/s)
dpkg-source: extracting mysql-dfsg-5.0 in mysql-dfsg-5.0-5.0.38
dpkg-source: unpacking mysql-dfsg-5.0_5.0.38.orig.tar.gz
dpkg-source: applying ./mysql-dfsg-5.0_5.0.38-0ubuntu1.1.diff.gz

If you list the directory contents you should have something like this:

[[email protected]:/root/builds]# ls -al
total 16408K
drwxr-xr-x 3 root root 4096 2007-10-30 13:08 ./
drwxr-xr-x 15 root root 4096 2007-10-30 13:06 ../
drwxr-xr-x 39 root root 4096 2007-10-30 13:08 mysql-dfsg-5.0-5.0.38/
-rw-r--r-- 1 root root 148883 2007-10-10 14:11 mysql-dfsg-5.0_5.0.38-0ubuntu1.1.diff.gz
-rw-r--r-- 1 root root 1209 2007-10-10 14:11 mysql-dfsg-5.0_5.0.38-0ubuntu1.1.dsc
-rw-r--r-- 1 root root 16602385 2007-04-03 05:03 mysql-dfsg-5.0_5.0.38.orig.tar.gz

Before we proceed we need to make sure that we have all of the necessary tools to compile the new packages and create the .deb:

apt-get install devscripts build-essential fakeroot

You will also want to make sure that you have any dependencies that the package would require:

apt-get build-dep mysql-server-5.0

Now that we have everything we need, we just need to make a modification to the file “mysql-dfsg-5.0-5.0.38/debian/rules” with your favorite editor. Search for the following lines within the file:


And change the lines to the below:


Basically you’re enabling OpenSSL and disabling YaSSL, make sure that you have OpenSSL installed (apt-get install openssl). Once you’ve finished editing the file, save it and exit out of the editor.

You will then want to start the compiling and build of the Debian packages, run the following command within the “mysql-dfsg-5.0-5.0.3” directory like so:

[[email protected]:/root/builds/mysql-dfsg-5.0-5.0.3]# debuild -us -uc

Everything should process properly, and you should end up with a handful of .deb packages within “/root/builds”:

[[email protected]:/root/builds]# ls -al
total 57628K
drwxr-xr-x 3 root root 4096 2007-10-30 14:02 ./
drwxr-xr-x 15 root root 4096 2007-10-30 14:35 ../
-rw-r--r-- 1 root root 6411178 2007-10-30 14:02 libmysqlclient15-dev_5.0.38-0ubuntu1.1_i386.deb
-rw-r--r-- 1 root root 1426470 2007-10-30 14:01 libmysqlclient15off_5.0.38-0ubuntu1.1_i386.deb
-rw-r--r-- 1 root root 45756 2007-10-30 14:01 mysql-client_5.0.38-0ubuntu1.1_all.deb
-rw-r--r-- 1 root root 6794738 2007-10-30 14:02 mysql-client-5.0_5.0.38-0ubuntu1.1_i386.deb
-rw-r--r-- 1 root root 54466 2007-10-30 14:01 mysql-common_5.0.38-0ubuntu1.1_all.deb
drwxr-xr-x 40 root root 4096 2007-10-30 14:00 mysql-dfsg-5.0-5.0.38/
-rw-r--r-- 1 root root 148883 2007-10-30 13:34 mysql-dfsg-5.0_5.0.38-0ubuntu1.1.diff.gz
-rw-r--r-- 1 root root 972 2007-10-30 13:34 mysql-dfsg-5.0_5.0.38-0ubuntu1.1.dsc
-rw-r--r-- 1 root root 1761484 2007-10-30 14:02
-rw-r--r-- 1 root root 3136 2007-10-30 14:02 mysql-dfsg-5.0_5.0.38-0ubuntu1.1_i386.changes
-rw-r--r-- 1 root root 16602385 2007-04-03 05:03 mysql-dfsg-5.0_5.0.38.orig.tar.gz
-rw-r--r-- 1 root root 47854 2007-10-30 14:02 mysql-server-4.1_5.0.38-0ubuntu1.1_i386.deb
-rw-r--r-- 1 root root 47828 2007-10-30 14:01 mysql-server_5.0.38-0ubuntu1.1_all.deb
-rw-r--r-- 1 root root 25522626 2007-10-30 14:02 mysql-server-5.0_5.0.38-0ubuntu1.1_i386.deb

Just run dpkg -i *.deb and all should be good!

[[email protected]:/root/builds]# dpkg -i *.deb
(Reading database ... 48209 files and directories currently installed.)
Preparing to replace libmysqlclient15-dev 5.0.38-0ubuntu1.1 (using libmysqlclient15-dev_5.0.38-0ubuntu1.1_i386.deb) ...
Unpacking replacement libmysqlclient15-dev ...
Preparing to replace libmysqlclient15off 5.0.38-0ubuntu1.1 (using libmysqlclient15off_5.0.38-0ubuntu1.1_i386.deb) ...
Unpacking replacement libmysqlclient15off ...
Preparing to replace mysql-client 5.0.38-0ubuntu1.1 (using mysql-client_5.0.38-0ubuntu1.1_all.deb) ...
Unpacking replacement mysql-client ...
Preparing to replace mysql-client-5.0 5.0.38-0ubuntu1.1 (using mysql-client-5.0_5.0.38-0ubuntu1.1_i386.deb) ...
Unpacking replacement mysql-client-5.0 ...
Preparing to replace mysql-common 5.0.38-0ubuntu1.1 (using mysql-common_5.0.38-0ubuntu1.1_all.deb) ...
Unpacking replacement mysql-common ...
Preparing to replace mysql-server-4.1 5.0.38-0ubuntu1.1 (using mysql-server-4.1_5.0.38-0ubuntu1.1_i386.deb) ...
* Stopping MySQL database server mysqld [ OK ] Unpacking replacement mysql-server-4.1 ...
Preparing to replace mysql-server 5.0.38-0ubuntu1.1 (using mysql-server_5.0.38-0ubuntu1.1_all.deb) ...
* Stopping MySQL database server mysqld [ OK ] Unpacking replacement mysql-server ...
Preparing to replace mysql-server-5.0 5.0.38-0ubuntu1.1 (using mysql-server-5.0_5.0.38-0ubuntu1.1_i386.deb) ...
* Stopping MySQL database server mysqld [ OK ] * Stopping MySQL database server mysqld [ OK ] Unpacking replacement mysql-server-5.0 ...
Setting up mysql-common (5.0.38-0ubuntu1.1) ...
Setting up libmysqlclient15off (5.0.38-0ubuntu1.1) ...
Setting up mysql-client-5.0 (5.0.38-0ubuntu1.1) ...
Setting up mysql-server-5.0 (5.0.38-0ubuntu1.1) ...
* Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [ OK ] * Checking for corrupt, not cleanly closed and upgrade needing tables.
Setting up libmysqlclient15-dev (5.0.38-0ubuntu1.1) ...
Setting up mysql-client (5.0.38-0ubuntu1.1) ...
Setting up mysql-server-4.1 (5.0.38-0ubuntu1.1) ...
Setting up mysql-server (5.0.38-0ubuntu1.1) ...

You May Also Like

Dubious 1980’s in-home nuclear reactor ad from Japan

Dubious 1980's in-home nuclear reactor ad from Japan -

Filed under:

Back in the carefree but confusing days of the 1980's, chicks and dudes were looking for all kinds of new ways to lessen their need for oil-based energy. If you believe anything you see in this ad mockup (and that's a big "if"), a company in Japan was working on a tiny, in-home nuclear reactor -- pleasantly named Chernobyl. We'll have to assume for the moment that this was pre-catastrophic meltdown, when the Russian power-plant was considered a feat of modern engineering instead of just a big, mutant-making hellride. The device supposedly would have been "simple to operate, even for children and the elderly", but carried an ominous warning to "discontinue use" if you experience "dizziness or a tingling sensation". Was this for real? Read the translation and judge for yourself.


Read | Permalink | Email this | Comments

Office Depot Featured Gadget: Xbox 360 Platinum System Packs the power to bring games to life!


AMD considering getting out of fabrication business

This is something I saw over at Ars Technica. This is a big and ugly move for AMD, no chip fabrication and just straight up design might put them in a hard place. Intel at the moment does both, and has many fabrication production facilities. Here are some facts about AMD:

AMD has planned expansions in their production capacity. In addition to the completion of Fab 36 in Dresden (300 mm 90 nmSOI), AMD is planning to upgrade Fab 30 (adjacent to Fab 36) in Dresden from 200 mm 90 nm process SOI to a 300 mm 65 nm process SOI facility and rename it Fab 38, and open a new facility at the Luther Park Technology Campus in Stillwater, New York (likely 300 mm 32 nm process SOI production) between years 2009 to 2010. process

And here is some information about Intel:

Intel currently operates four 300-mm fabs that provide the equivalent manufacturing capacity of about eight 200-mm factories. Those factories are located in Oregon, Ireland and New Mexico. The company also has an additional 300-mm fab currently under construction in Arizona (Fab 12) scheduled to begin operations later this year, and one expansion in Ireland (Fab 24-2) scheduled to begin operations in the first quarter of next year.

It was hard to find a lot of detail about Intels Facilities. Even WikiPedia and a 4 page google search turned up nothing.

AMD considering getting out of fabrication business -
Reports are surfacing that AMD is seriously considering a move out of the chip fabrication business, focusing its efforts entirely on chip design. It would be a risky move on AMD's part, even if it would ameliorate some of the company's cash flow problems.
Read More... [Ars Technica]

Goverment Employee uses On Call IT firm to destroy Goverment data

A Goverment Employee used an On Call IT service to perform a "seven level" format on his hard drive that possibly contained federal evidence.
Scott Bloch runs the Office of Special Counsel, an agency charged with protecting government whistleblowers and enforcing a ban on federal employees engaging in partisan political activity.

10 Really Useful Flickr Grease Monkey Userscripts.

I'm sure a lot of people are familiar with the FireFox extension called GreaseMonkey. The extension allows you to manipulate the JavaScript present on any website you visit. For instance, if you want to displaying text is a specific way, you can. You can also change the colour or look of site with your own custom JavaScript.
9. Flickr Follow Comments - This useful script helps you to view images that you have commented on - but only those that interest you. If you are writing lots of comments every day you know how hard it is not to get distracted by the overload of images when you click “Comments You’ve made”. With this userscript you have 4 different options to see only certain types of comments.

Must have Thunderbird/Seamonkey Addons

If you don't know about Thunderbird, then you've been living under a rock. Its a small, lightweight, Email application provided free by the Mozilla foundation. I was looking around for Thunderbird add-ons this evening and found a couple that I found to be a "Must Have" for anyone that uses Thunderbird as their primary email client. I'll list them off in no particular order: Enigmail - OpenPGP message encryption and authentication for Thunderbird and Seamonkey.