%define majversion %(echo %version | cut -d. -f 1-2) %define MAJversion %(echo %version | cut -d. -f 1) %define groupid 65018 %define userid 65018 Name: mysql5 Version: 5.1.33 Release: 1mamba Summary: A very fast and reliable SQL database engine Group: Applications/Databases Vendor: openmamba Distribution: openmamba Packager: Silvan Calarco URL: http://www.mysql.com Source: ftp://mysql.mirror.kangaroot.net/pub/mysql/Downloads/MySQL-%{majversion}/mysql-%{version}.tar.gz Source2: mysql-logrotate Source3: mysql_convert_db_format_to_mysql41.sh Source4: mysql5-initscript Patch0: mysql-4.1.19-CVE-2006-0903.patch License: GPL ## AUTOBUILDREQ-BEGIN BuildRequires: glibc-devel BuildRequires: libgcc BuildRequires: libncurses-devel BuildRequires: libopenssl-devel BuildRequires: libstdc++6-devel BuildRequires: libz-devel BuildRequires: lsb BuildRequires: perl-DBI BuildRequires: perl-devel ## AUTOBUILDREQ-END BuildRequires: libdb47-devel >= 4.2.52 BuildRequires: ORBit-devel >= 2.12.0 BuildRequires: perl >= 5.8.0 BuildRequires: bison BuildRequires: doxygen BuildRequires: tetex BuildRequires: tetex-latex PreReq: %{__install_info} Requires: %{name}-common = %{version}-%{release} Requires: lsb BuildRoot: %{_tmppath}/%{name}-%{version}-root %description The MySQL(TM) software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. MySQL is a trademark of MySQL AB. The MySQL software has Dual Licensing, which means you can use the MySQL software free of charge under the GNU General Public License (http://www.gnu.org/licenses/). You can also purchase commercial MySQL licenses from MySQL AB if you do not wish to be bound by the terms of the GPL. See the chapter "Licensing and Support" in the manual for further info. The MySQL web site (http://www.mysql.com/) provides the latest news and information about the MySQL software. Also please see the documentation and the manual for more information. %package client Summary: MySQL client Group: Applications/Databases Requires: %{name}-common = %{version} %description client The MySQL(TM) software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. This package contains the standard MySQL clients. %package bench Summary: MySQL benchmarks and test system Group: Applications/Databases Requires: %{name} = %{version} %description bench The MySQL(TM) software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. This package contains MySQL benchmark scripts and data. %package common Summary: Common files for the MySQL(TM) database server Group: Applications/Databases %description common The MySQL(TM) software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. Common files for the MySQL(TM) database server. %package -n libmysql%{MAJversion} Summary: Shared libraries need to dynamically load and use MySQL Group: System/Libraries Requires: %{name}-common = %{version} %description -n libmysql%{MAJversion} The MySQL(TM) software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. This package contains the shared libraries (*.so*) which certain languages and applications need to dynamically load and use MySQL. %package -n libmysql%{MAJversion}-devel Summary: Development header files and static libraries for MySQL Group: Development/Libraries Requires: libmysql%{MAJversion} = %{version}-%{release} %description -n libmysql%{MAJversion}-devel The MySQL(TM) software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. This package contains the development header files and libraries necessary to develop MySQL client applications. %prep %setup -q -n mysql-%{version} #%patch0 -p1 -b .CVE-2006-0903 %build %configure \ --libexecdir=%{_sbindir} \ --localstatedir=/var/lib/mysql%{MAJversion} \ --with-berkeley-db \ --with-ssl \ --without-debug \ --with-bench \ --with-extra-charsets=all \ --with-named-thread-libs="-lpthread" \ --enable-shared \ --enable-thread-safe-client \ --program-suffix=%{MAJversion} \ --with-embedded-server %make \ pkglibdir=%{_libdir} \ pkgdatadir=%{_datadir}/mysql5 \ pkgsuppdir=%{_datadir}/mysql5 %make check #make test %install [ "%{buildroot}" != / ] && rm -rf %{buildroot} %makeinstall \ libexecdir=%{_sbindir} \ pkglibdir=%{_libdir} \ pkgdatadir=%{_datadir}/mysql5 \ pkgsuppdir=%{_datadir}/mysql5 install -d %{buildroot}/var/lib/mysql%{MAJversion} #install -d %{buildroot}/var/log #touch %{buildroot}/var/log/mysqld.log install -D -m755 support-files/mysql.server %{buildroot}%{_initrddir}/mysql%{MAJversion} install -D -m644 %{SOURCE2} %{buildroot}%{_sysconfdir}/logrotate.d/mysql%{MAJversion} #install -D -m755 %{SOURCE3} \ # %{buildroot}%{_datadir}/mysql/%{name}_convert_db_format_to_mysql41 # copy default configuration file install -D -m644 support-files/my-medium.cnf %{buildroot}%{_sysconfdir}/mysql%{MAJversion}.conf install -D -m0755 %{SOURCE4} %{buildroot}%{_initrddir}/mysql5 mv %{buildroot}%{_prefix}/sql-bench %{buildroot}%{_datadir}/sql-bench mv %{buildroot}%{_infodir}/mysql.info %{buildroot}%{_infodir}/mysql%{?MAJversion}.info # delete unpackaged files #rm -f %{buildroot}%{_bindir}/make_win* rm -f %{buildroot}%{_datadir}/mysql%{?MAJversion}/mysql-*.spec rm -f %{buildroot}%{_datadir}/mysql%{?MAJversion}/MySQL-shared-compat.spec rm -f %{buildroot}%{_datadir}/mysql%{?MAJversion}/mysql-log-rotate rm -f %{buildroot}%{_datadir}/mysql%{?MAJversion}/binary-configure rm -f %{buildroot}%{_datadir}/mysql%{?MAJversion}/mi_test_all* rm -f %{buildroot}%{_datadir}/mysql%{?MAJversion}/*.cnf rm -f %{buildroot}%{_datadir}/mysql%{?MAJversion}/*.ini rm -fr %{buildroot}%{_prefix}/mysql-test %clean [ "%{buildroot}" != / ] && rm -rf %{buildroot} %pre if [ $1 -eq 1 ]; then /usr/sbin/groupadd mysql -g %{groupid} 2>/dev/null /usr/sbin/useradd -u %{userid} -c 'Mysql service' -d /dev/null \ -g mysql -s /bin/false mysql 2>/dev/null fi exit 0 %post if [ $1 -eq 1 ]; then # new install: initialize db mysql_install_db -b %{_prefix} --ldata=/var/lib/mysql%{MAJversion} /bin/chown -R mysql.mysql /var/lib/mysql%{MAJversion} /sbin/chkconfig --add mysql%{MAJversion} %{_initrddir}/mysql%{MAJversion} start fi exit 0 %preun if [ $1 -eq 0 ]; then # erase /sbin/chkconfig --del mysql%{MAJversion} %{_initrddir}/mysql%{MAJversion} stop /usr/sbin/userdel mysql /usr/sbin/groupdel mysql fi exit 0 %postun if [ $1 -eq 1 ]; then # update [ -f /var/lock/subsys/mysql ] && service mysql%{MAJversion} restart # [ -x %{_datadir}/mysql/mysql_convert_db_format_to_mysql41 ] && # %{_datadir}/mysql/mysql_convert_db_format_to_mysql41 &>/dev/null fi exit 0 %post -n libmysql%{MAJversion} -p /sbin/ldconfig %postun -n libmysql%{MAJversion} -p /sbin/ldconfig %post common %install_info %{name}.info %preun common %uninstall_info %{name}.info exit 0 %files %defattr(-,root,root) %{_sbindir}/mysqld%{?MAJversion} %{_bindir}/mysql_upgrade%{?MAJversion} #%{_bindir}/mysql_upgrade_shell %{_sysconfdir}/mysql5.conf %attr(755,root,root) %{_initrddir}/mysql5 %attr(755,mysql,mysql) %dir /var/lib/mysql%{?MAJversion} %{_mandir}/man8/mysqld%{?MAJversion}.8.gz %doc ChangeLog COPYING README #%doc Docs/manual.html %files client %defattr(-,root,root) %{_bindir}/msql2mysql%{?MAJversion} %{_bindir}/mysql%{?MAJversion} %{_bindir}/mysqlaccess%{?MAJversion} %{_bindir}/mysqladmin%{?MAJversion} %{_bindir}/mysqlbinlog%{?MAJversion} %{_bindir}/mysqlcheck%{?MAJversion} %{_bindir}/mysqldump%{?MAJversion} %{_bindir}/mysqldumpslow%{?MAJversion} %{_bindir}/mysqlimport%{?MAJversion} %{_bindir}/mysqlshow%{?MAJversion} %{_bindir}/mysql_client_test%{?MAJversion} %{_bindir}/mysql_find_rows%{?MAJversion} %{_mandir}/man1/* %files common %defattr(-,root,root) %{_bindir}/innochecksum%{?MAJversion} %{_bindir}/my_print_defaults%{?MAJversion} %{_bindir}/myisamchk%{?MAJversion} %{_bindir}/myisamlog%{?MAJversion} %{_bindir}/myisampack%{?MAJversion} %{_bindir}/mysql_convert_table_format%{?MAJversion} #%{_bindir}/mysql_explain_log%{?MAJversion} %{_bindir}/mysql_fix_extensions%{?MAJversion} %{_bindir}/mysql_fix_privilege_tables%{?MAJversion} #%{_bindir}/mysql_install%{?MAJversion} %{_bindir}/mysql_install_db%{?MAJversion} %{_bindir}/mysql_secure_installation%{?MAJversion} %{_bindir}/mysql_setpermission%{?MAJversion} #%{_bindir}/mysql_tableinfo%{?MAJversion} %{_bindir}/mysql_tzinfo_to_sql%{?MAJversion} %{_bindir}/mysql_waitpid%{?MAJversion} %{_bindir}/mysql_zap%{?MAJversion} %{_bindir}/mysqlbug%{?MAJversion} %{_bindir}/mysqld_multi%{?MAJversion} %{_bindir}/mysqld_safe%{?MAJversion} %{_bindir}/mysqlhotcopy%{?MAJversion} %{_bindir}/mysqlslap%{?MAJversion} %{_bindir}/mysqltest%{?MAJversion} #%{_bindir}/mysqltestmanager%{?MAJversion} #%{_bindir}/mysqltestmanager-pwgen%{?MAJversion} #%{_bindir}/mysqltestmanagerc%{?MAJversion} %{_bindir}/perror%{?MAJversion} %{_bindir}/replace%{?MAJversion} %{_bindir}/resolve_stack_dump%{?MAJversion} %{_bindir}/resolveip%{?MAJversion} %{_sbindir}/mysqlmanager%{?MAJversion} %config(noreplace) %{_sysconfdir}/logrotate.d/mysql%{MAJversion} %dir %{_datadir}/mysql%{?MAJversion} %exclude %{_datadir}/mysql%{?MAJversion}/ChangeLog #%{_datadir}/mysql/%{name}_convert_db_format_to_mysql41 %{_datadir}/mysql%{?MAJversion}/english %lang(cs) %{_datadir}/mysql%{?MAJversion}/czech %lang(da) %{_datadir}/mysql%{?MAJversion}/danish %lang(nl) %{_datadir}/mysql%{?MAJversion}/dutch %lang(et) %{_datadir}/mysql%{?MAJversion}/estonian %lang(fr) %{_datadir}/mysql%{?MAJversion}/french %lang(de) %{_datadir}/mysql%{?MAJversion}/german %lang(el) %{_datadir}/mysql%{?MAJversion}/greek %lang(hu) %{_datadir}/mysql%{?MAJversion}/hungarian %lang(it) %{_datadir}/mysql%{?MAJversion}/italian %lang(ja) %{_datadir}/mysql%{?MAJversion}/japanese %lang(ko) %{_datadir}/mysql%{?MAJversion}/korean %lang(no) %{_datadir}/mysql%{?MAJversion}/norwegian %lang(no) %{_datadir}/mysql%{?MAJversion}/norwegian-ny %lang(pl) %{_datadir}/mysql%{?MAJversion}/polish %lang(pt) %{_datadir}/mysql%{?MAJversion}/portuguese %lang(ro) %{_datadir}/mysql%{?MAJversion}/romanian %lang(ru) %{_datadir}/mysql%{?MAJversion}/russian %lang(sr) %{_datadir}/mysql%{?MAJversion}/serbian %lang(sk) %{_datadir}/mysql%{?MAJversion}/slovak %lang(es) %{_datadir}/mysql%{?MAJversion}/spanish %lang(sv) %{_datadir}/mysql%{?MAJversion}/swedish %lang(uk) %{_datadir}/mysql%{?MAJversion}/ukrainian %{_datadir}/mysql%{?MAJversion}/charsets %{_datadir}/mysql%{?MAJversion}/errmsg.txt %{_datadir}/mysql%{?MAJversion}/fill_help_tables.sql %{_datadir}/mysql%{?MAJversion}/mysql_fix_privilege_tables.sql %{_datadir}/mysql%{?MAJversion}/mysql_system_tables.sql %{_datadir}/mysql%{?MAJversion}/mysql_system_tables_data.sql %{_datadir}/mysql%{?MAJversion}/mysql_test_data_timezone.sql %{_datadir}/mysql%{?MAJversion}/mysql.server%{?MAJversion} %{_datadir}/mysql%{?MAJversion}/mysqld_multi.server%{?MAJversion} %exclude %{_infodir}/mysql%{?MAJversion}.info.* %{_mandir}/man8/mysqlmanager%{?MAJversion}.8.gz %files bench %defattr(-,root,root) %dir %{_datadir}/sql-bench %{_datadir}/sql-bench/* %files -n libmysql%{MAJversion} %defattr(-,root,root) %{_libdir}/libmysqlclient.so.* %{_libdir}/libmysqlclient_r.so.* %{_libdir}/plugin/ha_archive.a %{_libdir}/plugin/ha_archive.la %{_libdir}/plugin/ha_archive.so %{_libdir}/plugin/ha_archive.so.* %{_libdir}/plugin/ha_blackhole.a %{_libdir}/plugin/ha_blackhole.la %{_libdir}/plugin/ha_blackhole.so %{_libdir}/plugin/ha_blackhole.so.* %{_libdir}/plugin/ha_example.a %{_libdir}/plugin/ha_example.la %{_libdir}/plugin/ha_example.so %{_libdir}/plugin/ha_example.so.* %{_libdir}/plugin/ha_federated.a %{_libdir}/plugin/ha_federated.la %{_libdir}/plugin/ha_federated.so %{_libdir}/plugin/ha_federated.so.* %{_libdir}/plugin/ha_innodb.a %{_libdir}/plugin/ha_innodb.la %{_libdir}/plugin/ha_innodb.so %{_libdir}/plugin/ha_innodb.so.* %{_libdir}/plugin/libdaemon_example.a %{_libdir}/plugin/libdaemon_example.la %{_libdir}/plugin/libdaemon_example.so %{_libdir}/plugin/libdaemon_example.so.* %{_libdir}/plugin/mypluglib.a %{_libdir}/plugin/mypluglib.la %{_libdir}/plugin/mypluglib.so %{_libdir}/plugin/mypluglib.so.* %files -n libmysql%{MAJversion}-devel %defattr(-,root,root) %{_bindir}/mysql_client_test_embedded%{?MAJversion} %{_bindir}/mysqltest_embedded%{?MAJversion} #%{_bindir}/comp_err%{?MAJversion} %{_bindir}/mysql_config%{?MAJversion} %{_bindir}/myisam_ftdump%{?MAJversion} %{_includedir}/* %{_libdir}/*.a %{_libdir}/libmysqlclient.la %{_libdir}/libmysqlclient.so %{_libdir}/libmysqlclient_r.la %{_libdir}/libmysqlclient_r.so %{_datadir}/aclocal/mysql.m4 %changelog * Wed Apr 01 2009 Silvan Calarco 5.1.33-1mamba - automatic update to 5.1.33 by autodist * Thu Mar 05 2009 Silvan Calarco 5.1.32-1mamba - automatic update to 5.1.32 by autodist * Thu Feb 19 2009 Silvan Calarco 5.1.31-1mamba - update to 5.1.31 * Sat Dec 13 2008 Silvan Calarco 5.1.30-1mamba - update to 5.1.30 * Tue Nov 04 2008 Silvan Calarco 5.0.67-2mamba - changed datadir to /usr/lib/mysql5 - build with libdb47 * Sun Nov 02 2008 Silvan Calarco 5.0.67-1mamba - automatic update to 5.0.67 by autodist * Fri Jun 27 2008 Silvan Calarco 5.0.51b-1mamba - update to 5.0.51b [Stativa] * Fri Jan 11 2008 Silvan Calarco 4.1.22-2mamba - use default initscript - require lsb * Tue Mar 13 2007 Silvan Calarco 4.1.22-1qilnx - update to version 4.1.22 by autospec * Tue Jun 27 2006 Davide Madrisan 4.1.20-1qilnx - update to version 4.1.20 by autospec - this version also fixes CVE-2006-2753 * Mon May 15 2006 Davide Madrisan 4.1.19-1qilnx - update to version 4.1.19 by autospec - also fixes the security issues: CVE-2006-{1516,1517,3081} - security bug CVE-2006-0903 fixed * Wed Mar 01 2006 Silvan Calarco 4.1.18-1qilnx - update to version 4.1.18 by autospec * Tue Sep 20 2005 Davide Madrisan 4.1.14-1qilnx - update to version 4.1.14 by autospec - also fix the security issue: QSA-2005-108 (CAN-2005-2558) - specfile updated: install/uninstall info files - new script %{name}_convert_db_format_to_mysql41 * Wed Mar 23 2005 Davide Madrisan 4.0.24-2qilnx - restart the mysql server only when active (%%postun script) - added mising %%postun script for `libmysql' * Wed Mar 23 2005 Davide Madrisan 4.0.24-1qilnx - update to version 4.0.24 by autospec - fixes security vulnerabilities QSA-2005-032 (CAN-2005-07[09,10,11]) * Tue Feb 01 2005 Davide Madrisan 4.0.23-1qilnx - update to version 4.0.23 by autospec - fixed security vulnerability QSA-2005-011 (CAN-2005-0004) * Tue Sep 14 2004 Davide Madrisan 4.0.21-1qilnx - update to version 4.0.21 by autospec also fix: CAN-2004-0457, CAN-2004-083[5,6,7] * Fri Jul 09 2004 Silvan Calarco 4.0.20-1qilnx - new version build * Thu Feb 26 2004 Silvan Calarco 4.0.18-1qilnx - New version rebuild - groupid and userid specified according to QiLinux services rules * Wed Sep 03 2003 Silvan Calarco 4.0.12-2qilnx - Added configuration scripts and /var directories * Mon May 19 2003 Alessandro Ramazzina 4.0.12-1qilnx - creation of mysql package