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 Query Browser 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 4:31 pm    Post subject: How to compile MySQL Query Browser in SuSE 9.0
Reply with quote

MySQL Query Browser is the easiest visual tool for creating, executing, and optimizing SQL queries for your MySQL Database Server. The MySQL Query Browser gives you a complete set of drag-and-drop tools to visually build, analyze and manage your queries. Plus, the integrated environment provides:

  • Query Toolbar to easily create and execute queries and navigate query history
  • Script Editor giving you control to manually create or edit SQL statements
  • Results Window so you can also easily compare and work with multiple queries
  • Object Browser enabling you to manage your databases, bookmarks, and history using a Web Browser like interface
  • Database Explorer where you can select tables and fields to query, as well as create and delete tables
  • Table Editor allows you easily create, modify and delete tables
  • Inline Help giving you instant help access to selected objects, parameters, and functions


Here is a screenshot of MySQL Query Browser:

See MySQL Query Browser for an enlargement.
Image

For MySQL Query Browser, 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 Query Browser 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.

You will also need gtkhtml2 and gtkhtml2-devel. However, you cannot take them from the SuSE 9.3 DVD, as gtkhtml2 is compiled against a newer glibc - and you should NOT even dare to think of upgrading your glibc, you are going to get relocation errors and make your system useless! So you will need my RPM package for gtkhtml2 and SuSE 9.0. Install both gtkhtml2 and gtkhtml2-devel.

Further down the road, I had to install (or upgrade) 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)
  • libgnomeprint-2.10.1-5.i586.rpm
  • libgnomeprint-devel-2.10.1-5.i586.rpm
  • libgnomeprint-doc-2.10.1-5.i586.rpm (optional, but recommended)
  • libgnomeprintui-2.10.1-3.i586.rpm
  • libgnomeprintui-devel-2.10.1-3.i586.rpm
  • libgnomeprintui-doc-2.10.1-3.i586.rpm
  • libgnomecups-0.2.0-4.i586.rpm
  • libgnomecups-devel-0.2.0-4.i586.rpm
  • popt-1.7-207.i586.rpm
  • popt-devel-1.7-207.i586.rp
  • libsoup-2.2.2-5.i586.rpm
  • libsoup-devel-2.2.2-5.i586.rpm
  • libgcrypt-1.2.1-3.i586.rpm
  • libgcrypt-devel-1.2.1-3.i586.rpm
  • libgpg-error-1.0-3.i586.rpm
  • libgpg-error-devel-1.0-3.i586.rpm
  • gnutls-1.2.0-3.i586.rpm
  • gnutls-devel-1.2.0-3.i586.rpm
  • lzo-1.08-107.i586.rpm
  • lzo-devel-1.08-107.i586.rpm
  • libopencdk-0.5.5-3.i586.rpm
  • libopencdk-devel-0.5.5-3.i586.rpm
  • gail-1.8.2-4.i586.rpm
  • gail-devel-1.8.2-4.i586.rpm
  • gail-doc-1.8.2-4.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

Also, the compilation process will not force you to upgrade the libgnomeprintui-* packages. However, you should probably do it, since you have to upgrade the libgnomeprint-* packages.

To compile MySQL Query Browser 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 Query Browser:

  • 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
  • gtkhtml2
  • gtkhtml2-devel
  • libgnome
  • libgnome-devel
  • libgnomeui
  • libgnomeui-devel
  • orbit2
  • orbit2-devel
  • linc
  • linc-devel
  • libbonobo
  • libbonobo-devel
  • libbonoboui
  • libbonoboui-devel
  • bonobo-activation
  • bonobo-activation-devel
  • gconf2
  • gconf2-devel
  • gnome-vfs2
  • gnome-vfs2-devel
  • libgnomecanvas
  • libgnomecanvas-devel
  • libart_lgpl
  • libart_lgpl-devel
  • libgnomeprint
  • libgnomeprint-devel
  • libgnomeprintui
  • libgnomeprintui-devel
  • libgnomecups
  • libgnomecups-devel
  • popt
  • popt-devel
  • libsoup
  • libsoup-devel
  • libgcrypt
  • libgcrypt-devel
  • libgpg-error
  • libgpg-error-devel
  • gnutls
  • gnutls-devel
  • lzo
  • lzo-devel
  • libopencdk
  • libopencdk-devel
  • perl-XML-Parser
  • libjpeg
  • esound
  • esound-devel
  • audiofile
  • openssl
  • openssl-devel
  • gail
  • gail-devel
  • alsa
  • alsa-devel
  • resmgr


You should also make sure that your installed versions satisfy the following minimum version requirements:

  • gtk2 >= 2.6
  • pango >= 1.8
  • atk >= 1.9
  • pcre >= 3.9
  • libglade2 >= 2.0.0
  • glibmm24 >= 2.4.0
  • gtkmm24 >= 2.4.0
  • gtkhtml2 >= 3.6
  • libxml2 >= 2.6.2
  • libsoup >= 2.1.6
  • gail >= 1.8


Install these, take care to upgrade the ones I showed you above with those from a SuSE 9.3 DVD, have an eye on the minimum version requirements 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
chris
Dark Lord of the Sith


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

PostPosted: Sun Aug 13, 2006 9:25 am    Post subject:
Reply with quote

Wenn I say, you have to install

  • 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)
  • libgnomeprint-2.10.1-5.i586.rpm
  • libgnomeprint-devel-2.10.1-5.i586.rpm
  • libgnomeprint-doc-2.10.1-5.i586.rpm (optional, but recommended)
  • libgnomeprintui-2.10.1-3.i586.rpm
  • libgnomeprintui-devel-2.10.1-3.i586.rpm
  • libgnomeprintui-doc-2.10.1-3.i586.rpm
  • libgnomecups-0.2.0-4.i586.rpm
  • libgnomecups-devel-0.2.0-4.i586.rpm
  • popt-1.7-207.i586.rpm
  • popt-devel-1.7-207.i586.rp
  • libsoup-2.2.2-5.i586.rpm
  • libsoup-devel-2.2.2-5.i586.rpm
  • libgcrypt-1.2.1-3.i586.rpm
  • libgcrypt-devel-1.2.1-3.i586.rpm
  • libgpg-error-1.0-3.i586.rpm
  • libgpg-error-devel-1.0-3.i586.rpm
  • gnutls-1.2.0-3.i586.rpm
  • gnutls-devel-1.2.0-3.i586.rpm
  • lzo-1.08-107.i586.rpm
  • lzo-devel-1.08-107.i586.rpm
  • libopencdk-0.5.5-3.i586.rpm
  • libopencdk-devel-0.5.5-3.i586.rpm
  • gail-1.8.2-4.i586.rpm
  • gail-devel-1.8.2-4.i586.rpm
  • gail-doc-1.8.2-4.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


it may seem daunting at first. However, you can copy the whole list from your browser to a decent text editor, delete the spaces and stars on each line (in vi, I would do it with a command like:

Code:

:1,$s/^ *\* //


, join all lines in a single one (in vi, just type a capital J, for "join"), change to the DVD directory where all those RPMs are located and issue the one-line command (as root):

Code:

rpm -Uhv atk-1.9.1-4.i586.rpm atk-devel-1.9.1-4.i586.rpm freetype2-2.1.9-4.i586.rpm freetype2-devel-2.1.9-4.i586.rpm  libglade2-2.5.1-6.i586.rpm libglade2-devel-2.5.1-6.i586.rpm libglade2-doc-2.5.1-6.i586.rpm  libgnomeprint-2.10.1-5.i586.rpm libgnomeprint-devel-2.10.1-5.i586.rpm libgnomeprint-doc-2.10.1-5.i586.rpm  libgnomeprintui-2.10.1-3.i586.rpm libgnomeprintui-devel-2.10.1-3.i586.rpm libgnomeprintui-doc-2.10.1-3.i586.rpm libgnomecups-0.2.0-4.i586.rpm libgnomecups-devel-0.2.0-4.i586.rpm popt-1.7-207.i586.rpm popt-devel-1.7-207.i586.rp libsoup-2.2.2-5.i586.rpm libsoup-devel-2.2.2-5.i586.rpm libgcrypt-1.2.1-3.i586.rpm libgcrypt-devel-1.2.1-3.i586.rpm libgpg-error-1.0-3.i586.rpm libgpg-error-devel-1.0-3.i586.rpm gnutls-1.2.0-3.i586.rpm gnutls-devel-1.2.0-3.i586.rpm lzo-1.08-107.i586.rpm lzo-devel-1.08-107.i586.rpm libopencdk-0.5.5-3.i586.rpm libopencdk-devel-0.5.5-3.i586.rpm gail-1.8.2-4.i586.rpm gail-devel-1.8.2-4.i586.rpm gail-doc-1.8.2-4.i586.rpm  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  pango-1.8.1-4.i586.rpm pango-devel-1.8.1-4.i586.rpm


You will get some dependency errors, but you can continue from there, either by reissuing the command a few times (some packages at the start of the list may be dependent on ones at the rear, which will have to be installed first), or rearranging terms. Finally, you can always use the "--nodeps" option to rpm, if you know that all dependencies are fullfilled.
_________________
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