Stop data retention! Click here & act! Are you a webmaster and want to participate? Here you can find all necessary material for your website - Willst du auch an der Aktion teilnehmen? Hier findest du alle relevanten Infos und Materialien:
Chris Karakas Online Forum Index Karakas Online
 FAQFAQ   Forum SearchForum Search   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
How to compile MySQL Administrator in SuSE 9.0



 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
   Chris Karakas Online Forum Index -> Database Forum RSS Feed of this Forum
Share this page: These icons link to social bookmarking sites where readers can share and discover new web pages.Digg  del.icio.us  tc.eserver.org  Blinklist  Furl  Reddit  Blogmarks  Magnolia  Sphere  Yahoo!  Google  Windows Live  Technorati  Blue Dot  Simpy  Newsvine  Stumble Upon  co.mments.com  Blinkbits  BlogMemes  Connotea  View previous topic :: View next topic  
Author Message
chris
Dark Lord of the Sith


Joined: 10 May 2003
Posts: 6267
Location: Outer Space

PostPosted: Wed Aug 09, 2006 2:46 pm    Post subject: How to compile MySQL Administrator in SuSE 9.0
Reply with quote

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.
Image

For MySQL Administrator, I have created binary and source RPM packages for SuSE 9.0:

Source RPM:




Binary RPM:



Use the command

Code:

rpm -Uhv xxx.rpm


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:

Code:

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...):

Code:

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:

  • atk-1.9.1-4.i586.rpm
  • atk-devel-1.9.1-4.i586.rpm
  • freetype2-2.1.9-4.i586.rpm (optional, but recommended)
  • freetype2-devel-2.1.9-4.i586.rpm (optional, but recommended)
  • libglade2-2.5.1-6.i586.rpm
  • libglade2-devel-2.5.1-6.i586.rpm
  • libglade2-doc-2.5.1-6.i586.rpm (optional, but recommended)
  • libsigc++2-2.0.6-3.i586.rpm
  • libsigc++2-devel-2.0.6-3.i586.rpm
  • glibmm24-2.4.7-3.i586.rpm
  • glibmm24-devel-2.4.7-3.i586.rpm
  • gtkmm24-2.4.11-3.i586.rpm
  • gtkmm24-devel-2.4.11-3.i586.rpm
  • glib2-2.6.3-4.i586.rpm
  • glib2-devel-2.6.3-4.i586.rpm
  • glib2-doc-2.6.3-4.i586.rpm (optional, but recommended)
  • pango-1.8.1-4.i586.rpm
  • pango-devel-1.8.1-4.i586.rpm


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. Wink

To compile MySQL Administrator on a SuSE 9.0 system, you need a "base Linux system" comprising of the following packages:

  • fillup
  • attr
  • acl
  • aaa_base
  • filesystem
  • autoconf
  • automake
  • bash
  • bind-utils
  • binutils
  • bison
  • bzip2
  • cpio
  • cpp
  • cracklib
  • cyrus-sasl
  • db
  • devs
  • diffutils
  • e2fsprogs
  • file
  • coreutils
  • findutils
  • flex
  • gawk
  • gcc
  • gdbm
  • gdbm-devel
  • gettext
  • glibc
  • glibc-devel
  • glibc-locale
  • gpm
  • grep
  • groff
  • gzip
  • kbd
  • less
  • libgcc
  • libstdc++
  • libtool
  • libxcrypt
  • zlib
  • m4
  • make
  • man
  • mktemp
  • modutils
  • ncurses
  • ncurses-devel
  • net-tools
  • netcfg
  • pam
  • pam-devel
  • pam-modules
  • patch
  • perl
  • permissions
  • ps
  • rcs
  • readline
  • rpm
  • sed
  • sendmail
  • sharutils
  • shadow
  • strace
  • syslogd
  • sysvinit
  • tar
  • texinfo
  • timezone
  • unzip
  • util-linux
  • vim
  • zlib-devel


AND also the following "extra packages", needed specifically by MySQL Administrator:

  • pcre
  • pcre-devel
  • libglade2
  • libglade2-devel
  • libsigc++2
  • libsigc++2-devel
  • glibmm24
  • glibmm24-devel
  • gtkmm24
  • gtkmm24-devel
  • pkgconfig
  • glib2
  • glib2-devel
  • libxml2
  • libxml2-devel
  • gtk2
  • gtk2-devel
  • pango
  • pango-devel
  • atk
  • atk-devel
  • freetype2
  • freetype2-devel
  • mysql-client
  • mysql-devel
  • mysql-shared
  • gcc-c++
  • libstdc++
  • libstdc++-devel
  • XFree86-devel
  • XFree86-libs
  • XFree86-Mesa
  • XFree86-Mesa-devel
  • mesaglut
  • mesaglut-devel
  • expat
  • fontconfig
  • fontconfig-devel


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! Very Happy
_________________
Regards

Chris Karakas
www.karakas-online.de
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Share this page: These icons link to social bookmarking sites where readers can share and discover new web pages.Digg  del.icio.us  tc.eserver.org  Blinklist  Furl  Reddit  Blogmarks  Magnolia  Sphere  Yahoo!  Google  Windows Live  Technorati  Blue Dot  Simpy  Newsvine  Stumble Upon  co.mments.com  Blinkbits  BlogMemes  Connotea 
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
   Chris Karakas Online Forum Index -> Database Forum
Page 1 of 1
This page contains valid HTML 4.01 Transitional - click here to check it!
This page contains a valid CSS - click here to check it!

 

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group