Summary:	Database Firewall
Name:		greensql-fw
Version:	1.1.0
Release:	%mkrel 1
License:	GPL
Group:		System/Servers
URL:		http://sourceforge.net/projects/greensql/
Source0:	http://dfn.dl.sourceforge.net/sourceforge/greensql/%{name}-%{version}.tar.gz
Source1:	%{name}.init
Source2:	%{name}.sysconfig
Source3:	%{name}.logrotate
Patch0:		greensql-fw-logdir.diff
Patch1:		greensql-fw-1.0.0-gcc43.diff
Requires(post): rpm-helper
Requires(preun): rpm-helper
BuildRequires:	libevent-devel
BuildRequires:	mysql-devel
BuildRequires:	pcre-devel
BuildRequires:	flex
BuildRequires:	bison
BuildRoot:	%{_tmppath}/%{name}-%{version}-%{release}-buildroot

%description
GreenSQL is a database firewall engine used to protect Open Source Databases
from SQL injection attacks. It works in proxy mode. Application logics is based
on evaluating of SQL commands using risk score factors, as well as blocking of
sensitive commands.

%prep

%setup -q -n %{name}-%{version}
%patch0 -p1
%patch1 -p1

cp %{SOURCE1} %{name}.init
cp %{SOURCE2} %{name}.sysconfig
cp %{SOURCE3} %{name}.logrotate

# fix attribs
find -type f | xargs chmod 644

%build
%serverbuild

make CXXFLAGS="$CXXFLAGS `mysql_config --include` -Wall -D_REENTRANT"

%install
rm -rf %{buildroot}

install -d %{buildroot}%{_sysconfdir}/greensql
install -d %{buildroot}%{_sysconfdir}/sysconfig
install -d %{buildroot}%{_sysconfdir}/logrotate.d
install -d %{buildroot}%{_initrddir}
install -d %{buildroot}%{_sbindir}
install -d %{buildroot}/var/log/greensql


install -m0755 src/%{name} %{buildroot}%{_sbindir}/%{name}

install -m0644 conf/greensql.conf %{buildroot}%{_sysconfdir}/greensql/
install -m0644 conf/mysql.conf %{buildroot}%{_sysconfdir}/greensql/

install -m0755 %{name}.init %{buildroot}%{_initrddir}/%{name}
install -m0644 %{name}.sysconfig %{buildroot}/%{_sysconfdir}/sysconfig/%{name}
install -m0644 %{name}.logrotate %{buildroot}%{_sysconfdir}/logrotate.d/%{name}

%post
%_post_service %{name}

%preun
%_preun_service %{name}

%postun
if [ "$1" -ge "1" ]; then
    %{_initrddir}/%{name} condrestart > /dev/null 2>&1 ||:
fi

%clean
rm -rf %{buildroot}

%files
%defattr(-,root,root,0755)
%doc db docs scripts license.txt mem-test.sh readme.txt
%dir %{_sysconfdir}/greensql
%attr(0640,root,root) %config(noreplace) %{_sysconfdir}/greensql/greensql.conf
%attr(0640,root,root) %config(noreplace) %{_sysconfdir}/greensql/mysql.conf
%config(noreplace) %{_sysconfdir}/sysconfig/%{name}
%config(noreplace) %{_sysconfdir}/logrotate.d/%{name}
%{_initrddir}/%{name}
%{_sbindir}/%{name}
%dir /var/log/greensql


%changelog
* Tue Oct 20 2009 Oden Eriksson <oeriksson@mandriva.com> 1.1.0-1mdv2010.0
+ Revision: 458394
- 1.1.0

* Sun Oct 04 2009 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-3mdv2010.0
+ Revision: 453629
- fix build
- rebuild

  + Thierry Vignaud <tvignaud@mandriva.com>
    - rebuild

* Mon Apr 13 2009 Oden Eriksson <oeriksson@mandriva.com> 1.0.0-1mdv2009.1
+ Revision: 366738
- 1.0.0
- rediffed P0

* Sat Dec 06 2008 Oden Eriksson <oeriksson@mandriva.com> 0.9.6-2mdv2009.1
+ Revision: 311303
- rebuilt against mysql-5.1.30 libs

* Wed Nov 26 2008 Oden Eriksson <oeriksson@mandriva.com> 0.9.6-1mdv2009.1
+ Revision: 306959
- 0.9.6

* Mon Nov 03 2008 Oden Eriksson <oeriksson@mandriva.com> 0.9.4-2mdv2009.1
+ Revision: 299492
- fix the initscript (duh!)

* Sat Oct 25 2008 Oden Eriksson <oeriksson@mandriva.com> 0.9.4-1mdv2009.1
+ Revision: 297082
- 0.9.4
- drop P1, a different fix is implemented

* Thu Oct 16 2008 Oden Eriksson <oeriksson@mandriva.com> 0.9.2-1mdv2009.1
+ Revision: 294283
- 0.9.2
- rediffed P1

* Thu Aug 07 2008 Thierry Vignaud <tvignaud@mandriva.com> 0.8.4-2mdv2009.0
+ Revision: 266952
- rebuild early 2009.0 package (before pixel changes)

* Sat May 31 2008 Oden Eriksson <oeriksson@mandriva.com> 0.8.4-1mdv2009.0
+ Revision: 213669
- added P1 to fix build with gcc43
- 0.8.4 (Major security fixes)

* Wed May 14 2008 Oden Eriksson <oeriksson@mandriva.com> 0.8.2-2mdv2009.0
+ Revision: 207044
- rebuilt against libevent-1.4.4

* Tue Mar 18 2008 Oden Eriksson <oeriksson@mandriva.com> 0.8.2-1mdv2008.1
+ Revision: 188467
- fix build deps (bison)
- 0.8.2
- drop one upstream implemented patch
- fix build deps (flex)
- don't start it per default

* Mon Feb 18 2008 Thierry Vignaud <tvignaud@mandriva.com> 0.6.8-2mdv2008.1
+ Revision: 170875
- rebuild
- kill re-definition of %%buildroot on Pixel's request

  + Olivier Blin <oblin@mandriva.com>
    - restore BuildRoot

* Thu Dec 06 2007 Oden Eriksson <oeriksson@mandriva.com> 0.6.8-1mdv2008.1
+ Revision: 115900
- import greensql-fw


* Thu Dec 06 2007 Oden Eriksson <oeriksson@mandriva.com> 0.6.8-1mdv2008.1
- initial Mandriva package