%define build_java 0
%define build_autotools 1
# commandline overrides:
# rpm -ba|--rebuild --with 'xxx'
%{?_with_java: %{expand: %%global build_java 1}}
%{?_without_java: %{expand: %%global build_java 0}}
%{?_with_autotools: %{expand: %%global build_autotools 1}}
%{?_without_autotools: %{expand: %%global build_autotools 0}}
%define r_ver r12
%define ma_realversion 1.2.12
%define qb_realversion 1.2.12
%define wb_realversion 1.1.10
%define libname %mklibname 0
Summary: GUI Tools for MySQL 5.0 - common files
Name: mysql-gui-tools
Group: Databases
Version: 5.0
Release: %mkrel 1.%{r_ver}.2
License: GPL
URL: http://www.mysql.com/products/tools/
Source: ftp://ftp.sunet.se/pub/databases/relational/mysql/Downloads/MySQLGUITools/%{name}-%{version}%{r_ver}.tar.gz
Patch0: mysql-gui-tools-mdv_conf.diff
Patch1: mysql-gui-tools-pcre_fix.diff
Patch2: mysql-administrator-1.1.5-shellbang.patch
Patch3: mysql-administrator-help.patch
Patch4: mysql-query-browser.patch
Patch5: mysql-query-browser-gcc4.patch
Patch6: mysql-gui-common-pkg-config.patch
Patch7: mysql-gui-common-unused-func.patch
Patch8: mysql-gui-common-warnings.patch
Patch9: mysql-gui-tools-warnings.patch
Patch10: mysql-gui-tools-gcc42.patch
Patch11: mysql-gui-tools-bash.patch
Patch12: mysql-gui-tools-global.patch
Patch13: mysql-gui-tools-workbench.patch
Patch14: mysql-gui-tools-sigc_2.1.1_api_fixes.diff
BuildRequires: autoconf2.5
BuildRequires: libtool
BuildRequires: expat-devel
BuildRequires: file
BuildRequires: gettext-devel
BuildRequires: glib2-devel
BuildRequires: glibmm2.4-devel
BuildRequires: gtk2-devel
BuildRequires: gtkmm2.4-devel >= 2.6
BuildRequires: ImageMagick
BuildRequires: libext2fs-devel
BuildRequires: libglade2.0-devel >= 2.5
BuildRequires: libsigc++2.0-devel
BuildRequires: libslang-devel
BuildRequires: libxml2-devel
%if %mdkversion < 200700
BuildRequires: libgtkhtml-3.6-devel
BuildRequires: liblua-devel >= 5.0.2
BuildRequires: Mesa-devel
BuildRequires: MesaGLU-devel
%else
BuildRequires: libfcgi-devel
BuildRequires: libgtkhtml-3.14-devel
BuildRequires: lua5.0-devel
BuildRequires: mesagl-devel
BuildRequires: mesaglu-devel
%endif
%if %{build_java}
BuildRequires: junit
BuildRequires: java-gcj-compat-devel
BuildRequires: jpackage-utils
%endif
BuildRequires: mysql-devel >= 5.0
BuildRequires: ncurses-devel
BuildRequires: pcre-devel >= 5.0
BuildRequires: pkgconfig
BuildRequires: python-devel
BuildRequires: readline-devel
BuildRequires: termcap-devel
BuildRequires: libgnomeprint-devel >= 2.2.0
BuildRequires: openssl-devel
BuildRequires: gettext
BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root
%description
GUI Tools for MySQL 5.0 is a suite of applications written for developing and
managing MySQL servers.
This package contains data files and libraries for MySQL GUI Tools. Actual
applications are in packages mysql-administrator, mysql-query-browser and
mysql-workbench
%package -n mysql-administrator
Summary: Administration tool for MySQL 5.0
Group: Databases
Requires: mysql-gui-tools = %{version}
%description -n mysql-administrator
MySQL Administrator is a powerful graphical 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.
This is MySQL Administrator %{ma_realversion}.
%package -n mysql-query-browser
Summary: Query shell for MySQL 5.0
Group: Databases
Requires: mysql-gui-tools = %{version}
%description -n mysql-query-browser
MySQL Query Browser is a GUI tool for executing SQL queries. It will display
the result in a list where you can edit its contents and save. It has several
auxiliar features to facilitate work, such as query "bookmarking", query
history, syntax highlighting and online help.
This is MySQL QueryBrowser %{qb_realversion}.
%package -n mysql-workbench
Summary: Extensible modeling tool for MySQL 5.0
Group: Databases
Requires: mysql-gui-tools = %{version}
%description -n mysql-workbench
MySQL Workbench is modeling tool that allows you to design and generate MySQL
databases graphically.
MySQL Workbench requires OpenGL and a 3D accelerated graphics card with at
least 16MB of memory.
This is MySQL Workbench %{wb_realversion}.
%prep
%setup -q -n %{name}-%{version}%{r_ver}
%patch0 -p1
%patch1 -p0
%patch2 -p1
pushd mysql-administrator
%patch3
popd
pushd mysql-query-browser
%patch4
%patch5
popd
pushd mysql-gui-common
%patch6
%patch7
%patch8
popd
%patch9
%patch10 -p1
%patch11 -p1
%patch12 -p1
%patch13 -p1
%patch14 -p1
%if %{build_java}
%if %mdkversion >= 200700
# remove binary-only jars from filesystem
%{__rm} mysql-gui-common/res/java/jtds-1.2.jar
%{__rm} mysql-gui-common/res/java/junit.jar
%{__ln_s} %{_javadir}/junit.jar mysql-gui-common/res/java/junit.jar
%{__rm} mysql-gui-common/res/java/mysql-connector-java-5.0.4-bin.jar
%{__rm} mysql-gui-common/res/java/sapdbc-7_6_00_12_4339.jar
# remove references to binary jars from java Makefile
%{__perl} -pi -e 's/^javalib_DATA=.*/javalib_DATA=/' mysql-gui-common/source/java/Makefile.{am,in}
%endif
%endif
# strip away annoying ^M
find . -type f|xargs file|grep 'CRLF'|cut -d: -f1|xargs perl -p -i -e 's/\r//'
find . -type f|xargs file|grep 'text'|cut -d: -f1|xargs perl -p -i -e 's/\r//'
%build
pushd mysql-gui-common
%if %{build_autotools}
sh ./autogen.sh \
--prefix=%{_prefix} \
--bindir=%{_bindir} \
--sbindir=%{_sbindir} \
--sysconfdir=%{_sysconfdir} \
--datadir=%{_datadir} \
--includedir=%{_includedir} \
--libdir=%{_libdir} \
--libexecdir=%{_libexecdir} \
--localstatedir=%{_localstatedir} \
--mandir=%{_mandir} \
--enable-grt \
--enable-python-modules \
%if %mdkversion >= 200700
--enable-fastcgi \
%if %{build_java}
--enable-java-modules \
--with-java-includes=%{java_home}/include \
%else
--disable-java-modules \
%endif
%endif
--enable-readline \
--enable-canvas \
--with-bonobo
%endif
%configure2_5x \
--enable-grt \
--enable-python-modules \
%if %mdkversion >= 200700
--enable-fastcgi \
%if %{build_java}
--enable-java-modules \
--with-java-includes=%{java_home}/include \
%else
--disable-java-modules \
%endif
%endif
--enable-readline \
--enable-canvas \
--with-bonobo
%make
popd
# administrator
pushd mysql-administrator
%if %{build_autotools}
sh ./autogen.sh \
--prefix=%{_prefix} \
--bindir=%{_bindir} \
--sbindir=%{_sbindir} \
--sysconfdir=%{_sysconfdir} \
--datadir=%{_datadir} \
--includedir=%{_includedir} \
--libdir=%{_libdir} \
--libexecdir=%{_libexecdir} \
--localstatedir=%{_localstatedir} \
--mandir=%{_mandir} \
--with-bonobo
%endif
%configure2_5x \
--with-bonobo
%make
popd
# query-browser
pushd mysql-query-browser
%if %{build_autotools}
sh ./autogen.sh \
--prefix=%{_prefix} \
--bindir=%{_bindir} \
--sbindir=%{_sbindir} \
--sysconfdir=%{_sysconfdir} \
--datadir=%{_datadir} \
--includedir=%{_includedir} \
--libdir=%{_libdir} \
--libexecdir=%{_libexecdir} \
--localstatedir=%{_localstatedir} \
--mandir=%{_mandir} \
%if %mdkversion < 200700
--with-gtkhtml=libgtkhtml-3.6 \
%else
--with-gtkhtml=libgtkhtml-3.14 \
%endif
%endif
--with-bonobo
%configure2_5x \
%if %mdkversion < 200700
--with-gtkhtml=libgtkhtml-3.6 \
%else
--with-gtkhtml=libgtkhtml-3.14 \
%endif
--with-bonobo
%make
popd
# workbench
pushd mysql-workbench
%if %{build_autotools}
sh ./autogen.sh \
--prefix=%{_prefix} \
--bindir=%{_bindir} \
--sbindir=%{_sbindir} \
--sysconfdir=%{_sysconfdir} \
--datadir=%{_datadir} \
--includedir=%{_includedir} \
--libdir=%{_libdir} \
--libexecdir=%{_libexecdir} \
--localstatedir=%{_localstatedir} \
--mandir=%{_mandir} \
--with-bonobo
%endif
%configure2_5x \
--with-bonobo
%make
popd
%install
rm -rf %{buildroot}
%makeinstall_std -C mysql-gui-common
# fix some menu entries and stuff...
install -d %{buildroot}%{_miconsdir}
install -d %{buildroot}%{_iconsdir}
install -d %{buildroot}%{_liconsdir}
install -d %{buildroot}%{_menudir}
################################################################################
# mysql-administrator
%makeinstall_std -C mysql-administrator
cat > %{buildroot}%{_menudir}/mysql-administrator <<EOF
?package(mysql-administrator): \
command="%{_bindir}/mysql-administrator" \
section="More Applications/Databases" \
icon="mysql-administrator.png" \
needs="x11" \
kde_filename="mysql-administrator" \
title="MySQL Administrator" \
longtitle="Administration tool for MySQL 5.0" \
xdg="true"
EOF
rm -f %{buildroot}%{_datadir}/applications/MySQLAdministrator.desktop
cat > %{buildroot}%{_datadir}/applications/mysql-administrator.desktop << EOF
[Desktop Entry]
Name=MySQL Administrator
Comment=MySQL Administration Tool
Exec=%{_bindir}/mysql-administrator
Terminal=false
Type=Application
Icon=mysql-administrator
Categories=X-MandrivaLinux-MoreApplications-Databases;GTK;Database;Development;Application;
EOF
# make some icons
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Admin_48x48.png -resize 16x16 %{buildroot}%{_miconsdir}/mysql-administrator.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Admin_48x48.png -resize 32x32 %{buildroot}%{_iconsdir}/mysql-administrator.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Admin_48x48.png -resize 48x48 %{buildroot}%{_liconsdir}/mysql-administrator.png
%find_lang mysql-administrator --all-name
################################################################################
# mysql-query-browser
%makeinstall_std -C mysql-query-browser
cat > %{buildroot}%{_menudir}/mysql-query-browser <<EOF
?package(mysql-query-browser): \
command="%{_bindir}/mysql-query-browser" \
section="More Applications/Databases" \
icon="mysql-query-browser.png" \
needs="x11" \
kde_filename="mysql-query-browser" \
title="MySQL Query Browser" \
longtitle="Query shell for MySQL 5.0" \
xdg="true"
EOF
rm -f %{buildroot}%{_datadir}/applications/MySQLQueryBrowser.desktop
cat > %{buildroot}%{_datadir}/applications/mysql-query-browser.desktop << EOF
[Desktop Entry]
Name=MySQL Query Browser
Comment=MySQL Query Tool
Exec=%{_bindir}/mysql-query-browser
Terminal=false
Type=Application
Icon=mysql-query-browser
Categories=X-MandrivaLinux-MoreApplications-Databases;GTK;Database;Development;Application;
EOF
# make some icons
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_QueryBrowser_48x48.png -resize 16x16 %{buildroot}%{_miconsdir}/mysql-query-browser.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_QueryBrowser_48x48.png -resize 32x32 %{buildroot}%{_iconsdir}/mysql-query-browser.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_QueryBrowser_48x48.png -resize 48x48 %{buildroot}%{_liconsdir}/mysql-query-browser.png
%find_lang mysql-query-browser --all-name
################################################################################
# mysql-workbench
%makeinstall_std -C mysql-workbench
cat > %{buildroot}%{_menudir}/mysql-workbench <<EOF
?package(mysql-workbench): \
command="%{_bindir}/mysql-workbench" \
section="More Applications/Databases" \
icon="mysql-workbench.png" \
needs="x11" \
kde_filename="mysql-workbench" \
title="MySQL Workbench" \
longtitle="MySQL Database Design Tool" \
xdg="true"
EOF
rm -f %{buildroot}%{_datadir}/applications/MySQLWorkbench.desktop
cat > %{buildroot}%{_datadir}/applications/mysql-workbench.desktop << EOF
[Desktop Entry]
Name=MySQL Workbench
Comment=MySQL Database Design Tool
Exec=%{_bindir}/mysql-workbench
Terminal=false
Type=Application
Icon=mysql-workbench
Categories=X-MandrivaLinux-MoreApplications-Databases;GTK;Database;Development;Application;
EOF
# make some icons
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Workbench_48x48.png -resize 16x16 %{buildroot}%{_miconsdir}/mysql-workbench.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Workbench_48x48.png -resize 32x32 %{buildroot}%{_iconsdir}/mysql-workbench.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Workbench_48x48.png -resize 48x48 %{buildroot}%{_liconsdir}/mysql-workbench.png
%post -n mysql-administrator
%update_menus
%postun -n mysql-administrator
%clean_menus
%post -n mysql-query-browser
%update_menus
%postun -n mysql-query-browser
%clean_menus
%post -n mysql-workbench
%update_menus
%postun -n mysql-workbench
%clean_menus
%clean
rm -rf %{buildroot}
%files
%defattr(-, root, root)
%doc mysql-gui-common/COPYING
%doc mysql-gui-common/README
%doc mysql-gui-common/README.translating
%dir %{_datadir}/mysql-gui
%{_datadir}/mysql-gui/common/*
%if %mdkversion >= 200700
%if %{build_java}
%{_libdir}/mysql-gui/libmyx_grt_java*
%endif
%endif
%files -n mysql-administrator -f mysql-administrator.lang
%defattr(-, root, root)
%doc mysql-administrator/ChangeLog
%doc mysql-administrator/COPYING
%doc mysql-administrator/res/FAQ
%attr(0755,root,root) %{_bindir}/mabackup
%attr(0755,root,root) %{_bindir}/mysql-administrator
%attr(0755,root,root) %{_bindir}/mysql-administrator-bin
%dir %{_datadir}/mysql-gui/administrator
%{_datadir}/mysql-gui/MySQLIcon_Admin*
%{_datadir}/mysql-gui/administrator/*
%{_datadir}/applications/mysql-administrator.desktop
%{_menudir}/mysql-administrator
%{_iconsdir}/mysql-administrator.png
%{_liconsdir}/mysql-administrator.png
%{_miconsdir}/mysql-administrator.png
%files -n mysql-query-browser -f mysql-query-browser.lang
%defattr(-, root, root)
%doc mysql-query-browser/COPYING
%doc mysql-query-browser/res/ChangeLog
%dir %{_datadir}/mysql-gui/query-browser
%{_datadir}/mysql-gui/query-browser/*
%attr(0755,root,root) %{_bindir}/mysql-query-browser
%attr(0755,root,root) %{_bindir}/mysql-query-browser-bin
%{_datadir}/mysql-gui/MySQLIcon_Query*
%{_datadir}/applications/mysql-query-browser.desktop
%{_menudir}/mysql-query-browser
%{_iconsdir}/mysql-query-browser.png
%{_liconsdir}/mysql-query-browser.png
%{_miconsdir}/mysql-query-browser.png
%files -n mysql-workbench
%defattr(-, root, root)
%doc mysql-workbench/COPYING
%doc mysql-workbench/ChangeLog
%doc mysql-workbench/README.linux
%attr(0755,root,root) %{_bindir}/mysql-workbench
%attr(0755,root,root) %{_bindir}/mysql-workbench-bin
%dir %{_datadir}/mysql-gui/workbench
%{_datadir}/mysql-gui/MySQLIcon_Workbench*
%{_datadir}/mysql-gui/workbench/*
%{_datadir}/applications/mysql-workbench.desktop
%{_menudir}/mysql-workbench
%{_iconsdir}/mysql-workbench.png
%{_liconsdir}/mysql-workbench.png
%{_miconsdir}/mysql-workbench.png
%changelog
* Thu Nov 08 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-1.r12.2mdv2008.0
+ Revision: 106942
- new upstream P1 that hopefully fixes #33291 (mysql-query-browser becomes read only after libmysql upgrade)
- added patches from suse and pld (P2-P13)
- added P14 to make it build with latest sigc++-2.1.1 (G?\195?\182tz Waschk)
- fix deps
+ Thierry Vignaud <tvignaud@mandriva.com>
- do not harcode icon extension
- kill desktop-file-validate's error: string list key "Categories" in group "Desktop Entry" does not have a semicolon (";") as trailing character
* Tue May 15 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-1.r12.1mdv2008.0
+ Revision: 26869
- 5.0r12
* Wed Apr 04 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-1.r11.1mdv2007.1
+ Revision: 150588
- 5.0r11
* Wed Mar 14 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-1.r10.2mdv2007.1
+ Revision: 143621
- build it against libgtkhtml-3.14
* Sun Mar 04 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-1.r10.1mdv2007.1
+ Revision: 132103
- make it build (P1) and make it possible to skip the autopoo mangling
- 5.0r10
* Sun Jan 21 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-0.3.r9.1mdv2007.1
+ Revision: 111409
- increase release (0.3.x)
- 5.0r9
- rediffed P0
- make it backportable again (java)
* Sun Jan 07 2007 David Walluck <walluck@mandriva.org> 5.0-0.2.r8.4mdv2007.1
+ Revision: 105121
- BuildRequires: java-gcj-compat-devel
- enable java support
* Thu Dec 21 2006 Oden Eriksson <oeriksson@mandriva.com> 5.0-0.2.r8.3mdv2007.1
+ Revision: 101086
- make it backportable for cs4
- use www-browser instead of gnome-www-browser in MAdministrator.cc
* Thu Dec 21 2006 Oden Eriksson <oeriksson@mandriva.com> 5.0-0.2.r8.2mdv2007.1
+ Revision: 101004
- fix release
- 5.0r8
* Fri Dec 08 2006 Oden Eriksson <oeriksson@mandriva.com> 5.0-0.2.r6.1mdv2007.1
+ Revision: 93645
- added the remaining missing build deps
- rebuilt due to build system flux
- added libext2fs-devel as a build dep
- fix deps
- added mysql-gui-tools-mdv_conf.diff (P0) to set some mdv defaults
- Import mysql-gui-tools
* Thu Dec 07 2006 Oden Eriksson <oeriksson@mandriva.com> 5.0-0.1.r6.1mdv2007.1
- 5.0r6
- initial Mandriva package
- merged spec file stuff from the mysql-administrator and mysql-query-browser packages
