Dark Lord of the Sith
Joined: 10 May 2003
Location: Outer Space
|Posted: Wed Aug 09, 2006 2:46 pm Post subject: How to compile MySQL Administrator in SuSE 9.0
|MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating. MySQL Administrator now integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface. By using MySQL Administrator you will be able to:
- Achieve higher database availability through improved management
- Reduce errors through visual database administration
- Lower database administration costs through improved productivity
- Deliver a more secure environment through easier privilege management
MySQL Administrator enables developers and DBAs to easily perform all the command line operations visually including configuring servers, administering users, and dynamically monitoring database health. Other common administrative tasks such as monitoring replication status, backup and restore, and viewing logs can also be performed through the MySQL Administrator graphical console. Here is a screenshot of MySQL Administrator's Health Monitoring Console:
See MySQL Administrator - Health screen for an enlargement.
For MySQL Administrator, I have created binary and source RPM packages for SuSE 9.0:
Use the command
to install the binary RPMs. I used the build package of SuSE to compile my own source RPMs from source, as described for example in Compiling SuSE Source Packages. Note that up to and including version 9.0, SuSE uses the usedforbuild string on a comment line of the spec file to list all needed files for a successful compilation of the package.
The packages are build for SuSE 9.0. To rebuild a package for your own version of (SuSE) Linux, use the source RPMs and the build and/or rpmbuild commands, as described in How to compile an older version for a newer system in RPM.
Some notes on required packages, please read carefully:
As I am using a fairly old SuSE installation (SuSE 9.0), it was clear that some needed packages would be outdated. The solution I chose was to install them from a SuSE 9.3 DVD with the above command:
rpm -Uhv /path-to-DVD/suse/i586/xxx.rpm
Here are some of the obstacles I encountered during compilation:
First, you cannot use the binary RPM supplied by MySQL to install MySQL Administrator on SuSE 9.0. You are going to have problems with the version of GTK+ (package gtk2). You will not be able to install gtk2-2.6.4-6 directly from the SuSE 9.3 DVD either (that would be the easiest option, as you may already have guessed, but...):
rpm -Uhv /cdrw/suse/i586/gtk2-2.6.4-6.i586.rpm
error: Failed dependencies:
libXfixes.so.3 is needed by gtk2-2.6.4-6
libXinerama.so.1 is needed by gtk2-2.6.4-6
gtk2 = 2.2.3 is needed by (installed) gtk2-devel-2.2.3-27
(from now, on, /cdrw will be the location of my CD-RW drive). So I tried to find which package provided libXfixes.so.3 and libXinerama.so.1. As it turned out, after a search on the Net, they are both provided by xorg-x11-libs-xxx. But I am not using Xorg! I use XFree86 - remember, this is still SuSE 9.0...
So you will have to use my gtk2 RPM package for gtk 2.6.4 and SuSE 9.0. Install both gtk2 and gtk2-devel.
Further down the road, I had to install the following packages from the SuSE 9.3 DVD:
- freetype2-2.1.9-4.i586.rpm (optional, but recommended)
- freetype2-devel-2.1.9-4.i586.rpm (optional, but recommended)
- libglade2-doc-2.5.1-6.i586.rpm (optional, but recommended)
- glib2-doc-2.6.3-4.i586.rpm (optional, but recommended)
The freetype2 packages need not be updated, strictly speaking. However you are going to get a harsh warning (and a refusal to run!) from GIMP, if you compile, install and try to run it with the SuSE 9.0 freetype2 version. So better upgrade it right now.
To compile MySQL Administrator on a SuSE 9.0 system, you need a "base Linux system" comprising of the following packages:
AND also the following "extra packages", needed specifically by MySQL Administrator:
Install these, take care to upgrade the ones I showed you above with those from a SuSE 9.3 DVD and you should up and running fine! Enjoy!