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:

[root@jager:/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:

[root@jager:/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:

[root@jager:/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”:

[root@jager:/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!

[root@jager:/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

Corporate critics feel the stinging lash of DMCA misuse

I use to work for an ISP and was head of the Abuse Department. We only really received legitimate DCMA's that were then handled by legal. We didn't really seem to get that many DMCA notices, maybe its because we're a Canadian organization?
Corporate critics feel the stinging lash of DMCA misuse -

Two recent cases show that companies aren't always fans of criticism, and some will file misguided DMCA notices and defamation cases to scrub it from the Internet.


Microsoft Offers Further Open Source Patent Threats

Again Microsoft is trying to bully open source distributions and projects to buy into their patent protection that Novell has already sank money into.
Microsoft Offers Further Open Source Patent Threats - An anonymous reader writes "Via Groklaw comes comments from Microsoft's Steve Ballmer at a UK event, in which the company once again threatens Linux distributions that haven't signed up with their program. '"People who use Red Hat, at least with respect to our intellectual property, in a sense have an obligation to compensate us," Ballmer said last week ... Ballmer praised Novell at the UK event for valuing intellectual property, and suggested that open source vendors will be forced to strike similar deals with other patent holders. He predicted that firms like Eolas will soon come after open source vendors or users. Microsoft paid $521m to settle a patent claim by Eolas in August.'"

Read more of this story at Slashdot.


New Zealand teenager arrested as Botnet Leader

A New Zealand teenager was arrested and then freed of charges today for allegedly being the Leader of a Bot/Spybot network. The New Zealand E-crime unit arrested the teenager on suspicion of stealing over 9.7 Million Pounds from bank accounts around the world and breaking into an estimated 1.3 Million computers. The full quote from the Guardian..

Annoyed, hospitalized teen unplugs neighbor’s life support

Annoyed, hospitalized teen unplugs neighbor's life support -

Filed under:

It should probably go without saying that anything connected to a power source within the confines of a hospital has a fair shot at being pertinent to the livelihood of at least one individual, but obviously a 17-year old teenager in Germany needed the memo. After the perpetual noise of what would prove to be his neighbor's life support machine "got on his nerves," he proceeded to simply unplug the device without precaution in order to ensure that "he got his peace and quiet." Of course, we can only assume that the sirens and squeals that were emitted due to his misreckoning were immensely louder than the prior hum, but some folks just love to learn the hard way. Thankfully, medical personnel stepped in and saved the man from perishing, but the teen at fault lost a lot more sleep after that whilst being questioned by police.

[Via El Reg, image courtesy of NAIAD]


Read | Permalink | Email this | Comments

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


Site dedicated to the collection of LOL/LULZ/LAWL Cats!

I found this site through Hoose, who should be posting on this site anyways. This site houses submitted LOL Cats from users on the web, there are some already famous ones located on the site already. They have a random page, that will display random LOL Cat's.