+# TODO:
+# - kill unaligned accesses (create_db,gpre_current,gbak_static,isql_static) on alpha
+# - create classic server/super server subpackages and drop bcond
+# (see firebird2 on debian how to do it)
+#
+# Conditional build:
+%bcond_with ss # Super Server (standalone daemon instead of inetd service)
+#
Summary: Firebird SQL Database Server and Client tools
-Summary(pl): Firebird - serwer baz danych SQL oraz narzêdzia klienckie
+Summary(de.UTF-8): Firebird - relationalen Open-Source- Datenbankmanagementsystems
+Summary(pl.UTF-8): Firebird - serwer baz danych SQL oraz narzędzia klienckie
Name: Firebird
# FirebirdCS/FirebirdSS (Classic Server/Super Server)?
-Version: 1.0.0.796
-Release: 1
+Version: 2.1.0.17735
+Release: 0.1
License: Interbase Public License 1.0
Group: Applications/Databases
-Source0: ftp://ftp.sourceforge.net/pub/sourceforge/firebird/%{name}-%{version}.src.tar.gz
-Source1: ftp://ftp.sourceforge.net/pub/sourceforge/firebird/bootkit-%{version}.tar.gz
-# missing isc4.gbak generated by: make isql || : ; make gdef gsec secutity_db
-Source2: %{name}-isc4.gbak
-# missing save.c generated by gpre after building pixar w/o save.o and then other stuff
-Patch0: %{name}-bootkit-missing.patch
-# dirty "fixes" for missing error contants and conflict with isql from unixODBC
-Patch1: %{name}-fix.patch
-# ksh supports only [! ] globs, not [^ ]
-Patch2: %{name}-ksh.patch
-URL: http://firebird.sourceforge.net/
-Requires: %{name}-lib = %{version}
+Source0: http://dl.sourceforge.net/firebird/Firebird-%{version}-ReleaseCandidate1.tar.bz2
+# Source0-md5: 69c0fff7c4022e430df6e1eb842e5aaa
+Source1: http://www.firebirdsql.org/pdfmanual/Firebird-2.0-QuickStart.pdf
+# Source1-md5: 1ded6a5f6c1ec36a2b8a8b06370afc1a
+Source2: http://www.firebirdsql.org/pdfmanual/Using-Firebird_(wip).pdf
+# Source2-md5: 9eb90583c200bdd7292a80ecc1df1178
+Source3: http://www.firebirdsql.org/pdfmanual/Firebird-Null-Guide.pdf
+# Source3-md5: d1f8ba75fe3bb9eb9d203ce3f82a1a1a
+Source4: http://www.firebirdsql.org/pdfmanual/Firebird-Generator-Guide.pdf
+# Source4-md5: 44e7568ef477072a8ad5f381c3e12a75
+Source5: http://www.firebirdsql.org/pdfmanual/MSSQL-to-Firebird.pdf
+# Source5-md5: 1bd4a168e550910fc899e2aa125d83a3
+Source6: http://www.firebirdsql.org/pdfmanual/Firebird-nbackup.pdf
+# Source6-md5: 7883243a5685560330430d8b423d2eba
+Source7: http://www.firebirdsql.org/pdfmanual/Firebird-Utils-WIP.pdf
+# Source7-md5: 39b9a4f3c9d9e27d985e9277ae163ceb
+Source8: http://www.firebirdnews.org/docs/fb2min.pdf
+# Source8-md5: ebac312c0afbe97b1850bdc74c553c28
+Source9: http://www.firebirdsql.org/doc/contrib/fb_2_0_errorcodes.pdf
+# Source9-md5: 2acf2ff63c4ba3a1c590989e19bb253e
+Source100: firebird.init
+Source101: firebird.sysconfig
+Source102: firebird.inetd
+Patch0: %{name}-chmod.patch
+Patch1: %{name}-editline.patch
+Patch2: %{name}-va.patch
+Patch3: %{name}-morearchs.patch
+Patch4: %{name}-gcc4.patch
+Patch5: %{name}-fix-os-detection.dpatch
+Patch6: %{name}-fix-pthreads-detect.dpatch
+Patch7: %{name}-link-with-g++.dpatch
+Patch8: %{name}-no-custom-errno-and-sys_XXerrXX.dpatch
+Patch9: %{name}-opt-bypass-redundant-sort.dpatch
+Patch10: %{name}-security-remote-preauth-crash.dpatch
+Patch11: %{name}-separate-file-and-sem-perms.dpatch
+Patch12: %{name}-ppc.patch
+Patch13: %{name}-64bit.patch
+URL: http://www.firebirdsql.org/
+BuildRequires: autoconf
+BuildRequires: automake
+BuildRequires: bison
+BuildRequires: libstdc++-devel
+BuildRequires: libtool
+BuildRequires: ncurses-devel
+BuildRequires: psmisc >= 22.5-2
+BuildRequires: rpmbuild(macros) >= 1.268
+Requires: %{name}-lib = %{version}-%{release}
+%if %{with ss}
+Requires(post,preun): /sbin/chkconfig
+Requires: rc-scripts
+%endif
+# official ports are x86, sparc and x86_64
+# alpha and ppc added in morearchs patch
+# see morearchs patch if you want to add support for more archs
+ExclusiveArch: %{ix86} %{x8664} sparc sparcv9 alpha ppc
BuildRoot: %{tmpdir}/%{name}-%{version}-root-%(id -u -n)
%define ibdir %{_libdir}/interbase
+%define specflags -fno-strict-aliasing
+%define debugcflags -O1 -g -Wall -fno-strict-aliasing
%description
Firebird is a powerful, high-performance relational database designed
to be embedded into applications on multiple platforms.
-%description -l pl
-Firebird jest potê¿nym, wysoko wydajnym systemem relacyjnych baz
+%description -l pl.UTF-8
+Firebird jest potężnym, wysoko wydajnym systemem relacyjnych baz
danych zaprojektowanym do osadzania w aplikacjach na wielu
platformach.
+%description -l de.UTF-8
+Firebird ist der Open-Source-Spin-Off des weiterhin kommerziell von
+Borland vertriebenen relationalen Datenbankmanagementsystemes
+InterBase. Die Abspaltung erfolgte im Jahre 2000 als kurz vor Freigabe
+der Version 6 des kommerziellen Vorgängers Interbase bei Borland
+ernsthafte Überlegungen im Gange waren, die Weiterentwicklung
+einzustellen.
+
+Aus Interbase 6.0 wurde Firebird 1.0, wobei dies als eine
+Bugfix-Version mit nur wenigen Erweiterungen angesehen werden kann.
+Eine Erweiterung von Firebird 1.0 ist der 64-Bit File I/O, so dass
+auch Datenbankdateien über 2GB erzeugt werden können.
+
%package lib
Summary: Firebird shared library
-Summary(pl): Biblioteka wspó³dzielona Firebird
+Summary(pl.UTF-8): Biblioteka współdzielona Firebird
Group: Libraries
%description lib
Firebird shared library (libgds).
-%description lib -l pl
-Biblioteka wspó³dzielona Firebird (libgds).
+%description lib -l pl.UTF-8
+Biblioteka współdzielona Firebird (libgds).
%package devel
Summary: Header files for Firebird library
-Summary(pl): Pliki nag³ówkowe biblioteki Firebird
+Summary(pl.UTF-8): Pliki nagłówkowe biblioteki Firebird
Group: Development/Libraries
-Requires: %{name}-lib = %{version}
+Requires: %{name}-lib = %{version}-%{release}
+Requires: libstdc++-devel
%description devel
Header files for Firebird library.
-%description devel -l pl
-Pliki nag³ówkowe biblioteki Firebird.
+%description devel -l pl.UTF-8
+Pliki nagłówkowe biblioteki Firebird.
%package static
Summary: Static Firebird library
-Summary(pl): Statyczna biblioteka Firebird
+Summary(pl.UTF-8): Statyczna biblioteka Firebird
Group: Development/Libraries
-Requires: %{name}-devel = %{version}
+Requires: %{name}-devel = %{version}-%{release}
%description static
Static Firebird library (libgds).
-%description static -l pl
+%description static -l pl.UTF-8
Statyczna biblioteka Firebird (libgds).
+%package doc
+Summary: Extensive InterBase and Firebird documentation
+Summary(pl.UTF-8): Obszerna dokumentacja do baz InterBase i Firebird
+Group: Documentation
+
+%description doc
+Extensive InterBase and Firebird documentation.
+
+%description doc -l pl.UTF-8
+Obszerna dokumentacja do baz InterBase i Firebird.
+
%prep
-%setup -q -n firebird-%{version} -a1
+%setup -q -n Firebird-%{version}-ReleaseCandidate1
%patch0 -p1
-%patch1 -p1
-%patch2 -p1
+# OBSOLETE?
+# %patch1 -p1
+# ???
+# %patch2 -p1
+# looks obsolete (but not fully)
+# %patch3 -p1
+# %patch4 -p1
+# %patch5 -p1
+# %patch6 -p1
+# %patch7 -p1
+# %patch8 -p1
+# %patch9 -p1
+# %patch10 -p1
+# %patch11 -p1
+# %patch12 -p1
+# %patch13 -p1
-chmod u+w -R .
-cp -f %{SOURCE2} misc/isc4.gbak
+# force rebuild
+rm -f src/dsql/parse.cpp
%build
-INTERBASE=/usr/lib/interbase; export INTERBASE
-echo 'y' | ./Configure.sh PROD
-. ./Configure_SetupEnv.sh
+%{__libtoolize}
+%{__aclocal}
+%{__autoconf}
+
+%configure \
+ --with-editline \
+ --with-system-editline \
+ --with-system-icu \
+ --with-gnu-ld \
+ %{?with_ss:--enable-superserver} \
+ --prefix=%{ibdir} \
+ %{?debug:--enable-debug}
-%{__make} firebird \
+# OPTFLAGS for editline
+export OPTFLAGS="%{rpmcflags}"
+DARCH=""
+%ifarch %{x8664}
+DARCH="-DAMD64"
+%endif
+%ifarch sparc sparcv9
+DARCH="-Dsparc"
+%endif
+%ifarch ppc
+DARCH="-DPPC"
+%endif
+
+%{__make} -j1 \
CC="%{__cc}" \
- PROD_CFLAGS="%{rpmcflags} -fpic -DFLINTSTONE"
+ CXX="%{__cxx}" \
+ PROD_FLAGS="%{rpmcflags} -DNDEBUG -DLINUX -pipe -MMD -fPIC $DARCH" \
+ DEV_FLAGS="%{rpmcflags} -DLINUX -DDEBUG_GDS_ALLOC -pipe -MMD -fPIC -Wall -Wno-switch $DARCH" \
+ LIB_LINK_RPATH_LINE= \
+ LIB_CLIENT_LINK_OPTIONS="-lpthread"
-# classic/super - what's the difference?
-#%{__make} super_firebird
+# my name is hack. dirty hack.
+# why isn't that build in previous make call?
+%{__make} -C src -f ../gen/Makefile.libfbembed libfbembed \
+ CC="%{__cc}" \
+ CXX="%{__cxx}" \
+ PROD_FLAGS="%{rpmcflags} -DNDEBUG -DLINUX -pipe -MMD -fPIC $DARCH" \
+ DEV_FLAGS="%{rpmcflags} -DLINUX -DDEBUG_GDS_ALLOC -pipe -MMD -fPIC -Wall -Wno-switch $DARCH" \
+ LIB_LINK_RPATH_LINE= \
+ LIB_CLIENT_LINK_OPTIONS="-lpthread"
-#-Isource/interbase/include"
+# fb_lock_mgr is started during build - try to stop it (if /proc is mounted...)
+fuser -k gen/firebird/bin/fb_lock_mgr 2>/dev/null || :
%install
rm -rf $RPM_BUILD_ROOT
-INTERBASE=/usr/lib/interbase; export INTERBASE
-. ./Configure_SetupEnv.sh
-%{__make} buildclassicimage -f firebird/install/linux/Makefile
+%{__make} -C src -f ../gen/Makefile.install buildImageDir
+install -d $RPM_BUILD_ROOT/etc/{rc.d/init.d,sysconfig/rc-inetd}
install -d $RPM_BUILD_ROOT{%{ibdir},%{_libdir},%{_includedir}} \
$RPM_BUILD_ROOT%{_examplesdir}/%{name}-%{version}
-cd buildroot/opt/interbase
-rm -f bin/isc4.gbak
-cp -af UDF bin help intl interbase.msg isc4.gdb isc_config \
+
+install gen/firebird/lib/libfb*.a $RPM_BUILD_ROOT%{_libdir}
+install gen/firebird/lib/libfbembed.so* $RPM_BUILD_ROOT%{_libdir}
+cd gen/buildroot/%{ibdir}
+
+cp -af UDF bin help intl aliases.conf firebird.conf firebird.msg security.fdb \
$RPM_BUILD_ROOT%{ibdir}
install include/* $RPM_BUILD_ROOT%{_includedir}
-install lib/* $RPM_BUILD_ROOT%{_libdir}
+cp -df lib/* $RPM_BUILD_ROOT%{_libdir}
install examples/* $RPM_BUILD_ROOT%{_examplesdir}/%{name}-%{version}
+# or libfbembed?
+ln -sf libfbclient.so.1 $RPM_BUILD_ROOT%{_libdir}/libgds.so.0
+ln -sf libfbclient.so.1 $RPM_BUILD_ROOT%{_libdir}/libgds.so
+
+ln -sf libfbstatic.a $RPM_BUILD_ROOT%{_libdir}/libgds.a
+
+%if %{with ss}
+install %{SOURCE100} $RPM_BUILD_ROOT/etc/rc.d/init.d/firebird
+install %{SOURCE101} $RPM_BUILD_ROOT/etc/sysconfig/firebird
+%else
+install %{SOURCE102} $RPM_BUILD_ROOT/etc/sysconfig/rc-inetd/firebird
+%endif
+
%clean
rm -rf $RPM_BUILD_ROOT
+%pre
+%groupadd -g 145 firebird
+%useradd -u 145 -d %{ibdir} -s /bin/sh -g firebird -c "Firebird Server" firebird
+
+%if %{with ss}
+%post
+/sbin/chkconfig --add firebird
+%service firebird restart
+
+%preun
+if [ "$1" = "0" ]; then
+ %service firebird stop
+ /sbin/chkconfig --del firebird
+fi
+%endif
+
+%postun
+if [ "$1" = "0" ]; then
+ %userremove firebird
+ %groupremove firebird
+fi
+
+%post lib -p /sbin/ldconfig
+%postun lib -p /sbin/ldconfig
+
%files
%defattr(644,root,root,755)
-%doc builds_win32/install/{*License,Readme}.txt
+%doc doc/{sql.extensions,Firebird_conf.txt,README.user*,WhatsNew,fb2-todo.txt}
%attr(755,root,root) %{_libdir}/libib_util.so
-%dir %{ibdir}
+%dir %attr(770,root,firebird) %{ibdir}
%attr(755,root,root) %{ibdir}/UDF
%attr(755,root,root) %{ibdir}/bin
%{ibdir}/help
-%{ibdir}/intl
-%{ibdir}/interbase.msg
-# following two files should be in /var and /etc resp.?
-%{ibdir}/isc4.gdb
-%{ibdir}/isc_config
+%dir %attr(770,root,firebird) %{ibdir}/intl
+%attr(755,root,root) %{ibdir}/intl/fbintl
+%{ibdir}/firebird.msg
+# following files should be in /var (*.fdb) and /etc (*.conf)?
+%attr(660,root,firebird) %config(noreplace) %verify(not md5 mtime size) %{ibdir}/security.fdb
+%attr(640,root,firebird) %config(noreplace) %verify(not md5 mtime size) %{ibdir}/aliases.conf
+%attr(640,root,firebird) %config(noreplace) %verify(not md5 mtime size) %{ibdir}/firebird.conf
+%if %{with ss}
+%attr(754,root,root) /etc/rc.d/init.d/firebird
+%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/sysconfig/firebird
+%else
+%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/sysconfig/rc-inetd/firebird
+%endif
%files lib
%defattr(644,root,root,755)
-# .so link needed here - library doesn't have SONAME
-%attr(755,root,root) %{_libdir}/libgds.so*
+%attr(755,root,root) %{_libdir}/libfbclient.so.*.*.*
+%attr(755,root,root) %ghost %{_libdir}/libfbclient.so.[0-9]
+%attr(755,root,root) %{_libdir}/libfbembed.so.*.*.*
+%attr(755,root,root) %ghost %{_libdir}/libfbembed.so.[0-9]
+
+# InterBase/old Firebird compatibility symlinks
+%attr(755,root,root) %{_libdir}/libgds.so.0
+# needed here - original libgds.so.0 didn't have soname, so some old
+# (possibly not open-source) apps may be linked with libgds.so
+%attr(755,root,root) %{_libdir}/libgds.so
%files devel
%defattr(644,root,root,755)
-%{_includedir}/*
+%attr(755,root,root) %{_libdir}/libfbclient.so
+%attr(755,root,root) %{_libdir}/libfbembed.so
+%{_includedir}/*.h
%{_examplesdir}/%{name}-%{version}
%files static
%defattr(644,root,root,755)
+%{_libdir}/libfbcommon.a
+%{_libdir}/libfbstatic.a
+# compat link
%{_libdir}/libgds.a
+
+%files doc
+%defattr(644,root,root,755)
+%doc docs/*