Summary: MySQL performance logging daemon Name: mysqlard Version: 1.0.0 Release: %mkrel 8 Group: System/Servers License: GPL URL: http://gert.sos.be/en/ Source0: http://www.sos.be/projects/%{name}/dist/%{name}-%{version}.tar.bz2 Patch0: mysqlard-1.0.0-mdv_conf.diff Requires(post): rpm-helper Requires(preun): rpm-helper Requires(pre): apache-mod_php php-mysql Requires: apache-mod_php php-mysql Requires: mysql Requires: rrdtool BuildRequires: ImageMagick BuildRequires: apache-base >= 2.0.54 BuildRequires: mysql-devel BuildRequires: rrdtool BuildRequires: librrdtool-devel BuildRoot: %{_tmppath}/%{name}-%{version}-root %description mysqlard daemon collects MySQL(TM) performance data in a Round Robin Database. The package also contains example graphing and php scripts. %prep %setup -q %patch0 -p0 chmod 644 AUTHORS ChangeLog COPYING INSTALL NEWS README TODO %build %serverbuild %configure2_5x \ --sysconfdir=%{_sysconfdir}/%{name} \ --localstatedir=/var/run/%{name} \ --datadir=/var/lib %make %install rm -rf %{buildroot} # don't fiddle with the initscript! export DONT_GPRINTIFY=1 %makeinstall_std install -d %{buildroot}%{_initrddir} install -d %{buildroot}%{_sysconfdir}/%{name} install -d %{buildroot}%{_sysconfdir}/cron.d install -d %{buildroot}%{_sysconfdir}/cron.daily install -d %{buildroot}%{_sysconfdir}/cron.weekly install -d %{buildroot}%{_sysconfdir}/cron.monthly install -d %{buildroot}%{_sysconfdir}/httpd/conf/webapps.d install -d %{buildroot}/var/lib/%{name}/archive install -d %{buildroot}/var/run/%{name} mv %{buildroot}/var/lib/%{name}/*.cnf %{buildroot}%{_sysconfdir}/%{name}/ mv %{buildroot}/var/lib/%{name}/*.server %{buildroot}%{_initrddir}/%{name} mv %{buildroot}/var/lib/%{name}/mysqlar.daily %{buildroot}%{_sysconfdir}/cron.daily/%{name} mv %{buildroot}/var/lib/%{name}/mysqlar.weekly %{buildroot}%{_sysconfdir}/cron.weekly/%{name} mv %{buildroot}/var/lib/%{name}/mysqlar.monthly %{buildroot}%{_sysconfdir}/cron.monthly/%{name} mv %{buildroot}/var/lib/%{name}/mysqlar.php %{buildroot}/var/lib/%{name}/index.php cat > %{name}.crond << EOF #!/bin/sh */5 * * * * root hourly=1 daily=1 weekly=1 monthly=1 %{_bindir}/mysqlar_graph > /dev/null EOF install -m0755 %{name}.crond %{buildroot}%{_sysconfdir}/cron.d/%{name} cat > %{buildroot}/%{_sysconfdir}/httpd/conf/webapps.d/%{name}.conf << EOF Alias /%{name} /var/lib/%{name} <Directory /var/lib/%{name}> Order Deny,Allow Deny from All Allow from 127.0.0.1 ErrorDocument 403 "Access denied per %{_sysconfdir}/httpd/conf/webapps.d/%{name}.conf" </Directory> #<LocationMatch /%{name}> # Options FollowSymLinks # RewriteEngine on # RewriteCond %{SERVER_PORT} !^443$ # RewriteRule ^.*$ https://%{SERVER_NAME}%{REQUEST_URI} [L,R] #</LocationMatch> EOF # Mandriva Icons install -d %{buildroot}%{_iconsdir} install -d %{buildroot}%{_miconsdir} install -d %{buildroot}%{_liconsdir} convert src/mysql.gif -resize 16x16 %{buildroot}%{_miconsdir}/%{name}.png convert src/mysql.gif -resize 32x32 %{buildroot}%{_iconsdir}/%{name}.png convert src/mysql.gif -resize 48x48 %{buildroot}%{_liconsdir}/%{name}.png # install menu entry. # XDG menu install -d %{buildroot}%{_datadir}/applications cat > %{buildroot}%{_datadir}/applications/mandriva-%{name}.desktop << EOF [Desktop Entry] Name=mysqlard Comment=%{summary} Exec="%{_bindir}/www-browser http://localhost/%{name}/" Icon=%{name} Terminal=false Type=Application Categories=X-MandrivaLinux-MoreApplications-Databases; EOF %post %_post_service %{name} %_post_webapp %if %mdkversion < 200900 %update_menus %endif %preun %_preun_service %{name} %postun %_postun_webapp %if %mdkversion < 200900 %clean_menus %endif %clean [ "%{buildroot}" != "/" ] && rm -rf %{buildroot} %files %defattr(0755,root,root) %doc AUTHORS ChangeLog COPYING INSTALL NEWS README TODO %attr(0644,root,root) %config(noreplace) %{_sysconfdir}/%{name}/*.cnf %attr(0644,root,root) %config(noreplace) %{_sysconfdir}/httpd/conf/webapps.d/%{name}.conf %attr(0755,root,root) %{_initrddir}/mysqlard %attr(0755,root,root) %{_sysconfdir}/cron.d/%{name} %attr(0755,root,root) %{_sysconfdir}/cron.daily/%{name} %attr(0755,root,root) %{_sysconfdir}/cron.weekly/%{name} %attr(0755,root,root) %{_sysconfdir}/cron.monthly/%{name} %{_bindir}/* %{_sbindir}/* /var/lib/%{name} %dir /var/run/%{name} %{_mandir}/man1/* %{_mandir}/man8/* %{_iconsdir}/%{name}.png %{_miconsdir}/%{name}.png %{_liconsdir}/%{name}.png %{_datadir}/applications/*.desktop %changelog * Tue Jun 17 2008 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-8mdv2009.0 + Revision: 222499 - rebuilt against new rrdtool-devel + Pixel <pixel@mandriva.com> - rpm filetriggers deprecates update_menus/update_scrollkeeper/update_mime_database/update_icon_cache/update_desktop_database/post_install_gconf_schemas - %clean_menus and %%_postun_webapp must be in %%postun, not %%preun + Thierry Vignaud <tvignaud@mandriva.com> - drop old menu - kill re-definition of %%buildroot on Pixel's request + Olivier Blin <oblin@mandriva.com> - restore BuildRoot * Tue Aug 07 2007 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-7mdv2008.0 + Revision: 59816 - Import mysqlard * Tue Aug 07 2007 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-7mdv2008.0 - use the www-browser command instead of constructed one - xdg cleanups * Mon Sep 04 2006 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-6mdv2007.0 - fix xdg menu * Mon Sep 04 2006 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-5mdv2007.0 - rebuilt against MySQL-5.0.24a-1mdv2007.0 due to ABI changes * Sun May 14 2006 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-4mdk - fix a menuentry - add mod_rewrite rules to enforce ssl connections - fix deps * Sat May 13 2006 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-3mdk - fix a better initscript (P0) * Fri May 05 2006 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-2mdk - fix the cron syntax * Wed May 03 2006 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-1mdk - initial Mandriva package