Firebird.spec

   1 # TODO:
   2 # - check running
   3 # - 2.5 -> 3.0 migration?
   4 # - more docs from http://www.firebirdsql.org/en/reference-manuals/ ?
   5 # - kill unaligned accesses (create_db,gpre_current,gbak_static,isql_static) on alpha
   6 #   - check if it's fixed now (RISC_ALIGNMENT is defined)
   7 # - check classic subpackage pre/post scripts
   8 # - logrotate script
   9 # - create SYSDBA user with initial password before first firebird start
  10 #   eg.:
  11 #     su firebird
  12 #     echo "create user SYSDBA password 'masterkey';"|fb_isql -u SYSDBA /var/lib/firebird/security3.fdb
  13 #
  14 Summary:        Firebird SQL Database Server and Client tools
  15 Summary(de.UTF-8):      Firebird - relationalen Open-Source- Datenbankmanagementsystems
  16 Summary(pl.UTF-8):      Firebird - serwer baz danych SQL oraz narzędzia klienckie
  17 Name:           Firebird
  18 Version:        3.0.2.32703
  19 Release:        1
  20 License:        Interbase Public License 1.0, Initial Developer's Public License 1.0
  21 Group:          Applications/Databases
  22 Source0:        http://downloads.sourceforge.net/firebird/%{name}-%{version}-0.tar.bz2
  23 # Source0-md5:  1fdc121ab04d2c2772d778e45ecd5689
  24 Source1:        http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-3-QuickStart.pdf
  25 # Source1-md5:  8e029d449e9cb3e1da8213ac6c11ad02
  26 # distfiles refuses this, would require some audit to allow '('/')' chars
  27 #Source2:       http://www.firebirdsql.org/pdfmanual/Using-Firebird_(wip).pdf
  28 ## Source2-md5: 9eb90583c200bdd7292a80ecc1df1178
  29 Source3:        http://www.firebirdsql.org/pdfmanual/%{name}-Null-Guide.pdf
  30 # Source3-md5:  d1f8ba75fe3bb9eb9d203ce3f82a1a1a
  31 Source4:        http://www.firebirdsql.org/pdfmanual/%{name}-Generator-Guide.pdf
  32 # Source4-md5:  44e7568ef477072a8ad5f381c3e12a75
  33 Source5:        http://www.firebirdsql.org/pdfmanual/MSSQL-to-%{name}.pdf
  34 # Source5-md5:  1bd4a168e550910fc899e2aa125d83a3
  35 Source6:        http://www.firebirdsql.org/pdfmanual/%{name}-nbackup.pdf
  36 # Source6-md5:  7ef8a8b9a899d06bec2a5da0bb5fea0e
  37 Source7:        http://www.firebirdsql.org/pdfmanual/%{name}-Utils-WIP.pdf
  38 # Source7-md5:  39b9a4f3c9d9e27d985e9277ae163ceb
  39 Source8:        http://www.firebirdnews.org/docs/fb2min.pdf
  40 # Source8-md5:  ebac312c0afbe97b1850bdc74c553c28
  41 Source9:        http://www.firebirdsql.org/doc/contrib/fb_2_1_errorcodes.pdf
  42 # Source9-md5:  9ab392dc349657dbcf9a9c35acd8e8db
  43 Source100:      firebird.init
  44 Source101:      firebird.sysconfig
  45 Source102:      firebird.inetd
  46 Source103:      firebird.tmpfiles
  47 Source104:      firebird.service
  48 Source105:      firebird-classic.service
  49 Source106:      firebird-classic.socket
  50 Source107:      server_mode-ss.conf
  51 Source108:      server_mode-classic.conf
  52 Patch0:         %{name}-chmod.patch
  53 Patch1:         %{name}-editline.patch
  54 Patch2:         %{name}-va.patch
  55 Patch3:         %{name}-FHS.patch
  56 Patch4:         %{name}-opt.patch
  57 Patch5:         %{name}-gcc-icu.patch
  58 Patch6:         %{name}-libpath.patch
  59 Patch7:         Make-the-generated-code-compatible-with-gcc-6-in-C-1.patch
  60 Patch8:         Provide-sized-global-delete-operators-when-compiled.patch
  61 Patch9:         parallel-build.patch
  62 Patch10:        no-copy-from-icu.patch
  63 Patch11:        config.patch
  64 URL:            http://www.firebirdsql.org/
  65 BuildRequires:  autoconf >= 2.67
  66 BuildRequires:  automake
  67 BuildRequires:  bison
  68 BuildRequires:  libatomic_ops
  69 BuildRequires:  libedit-devel
  70 BuildRequires:  libicu-devel
  71 BuildRequires:  libstdc++-devel
  72 BuildRequires:  libtommath-devel
  73 BuildRequires:  libtool >= 2:2
  74 # for lockfile
  75 BuildRequires:  procmail
  76 BuildRequires:  rpmbuild(macros) >= 1.268
  77 BuildRequires:  sed >= 4.0
  78 BuildRequires:  zlib-devel
  79 Requires:       %{name}-dirs = %{version}-%{release}
  80 Requires:       %{name}-lib = %{version}-%{release}
  81 # official ports are x86, x86_64, ppc, sparc, arm, mips/mipsel, ia64
  82 # alpha is added in morearchs patch
  83 # see morearchs patch if you want more
  84 ExclusiveArch:  %{ix86} %{x8664} x32 arm ia64 mips mipsel ppc sparc sparcv9 alpha
  85 BuildRoot:      %{tmpdir}/%{name}-%{version}-root-%(id -u -n)
  86
  87 %define         ibdir   %{_libdir}/interbase
  88 %define         specflags       -fno-strict-aliasing
  89 %define         debugcflags     -O1 -g -Wall -fno-strict-aliasing
  90 %define         Werror_cflags   ''
  91
  92 %description
  93 Firebird is a powerful, high-performance relational database designed
  94 to be embedded into applications on multiple platforms.
  95
  96 %description -l pl.UTF-8
  97 Firebird jest potężnym, wysoko wydajnym systemem relacyjnych baz
  98 danych zaprojektowanym do osadzania w aplikacjach na wielu
  99 platformach.
 100
 101 %description -l de.UTF-8
 102 Firebird ist der Open-Source-Spin-Off des weiterhin kommerziell von
 103 Borland vertriebenen relationalen Datenbankmanagementsystemes
 104 InterBase. Die Abspaltung erfolgte im Jahre 2000 als kurz vor Freigabe
 105 der Version 6 des kommerziellen Vorgängers Interbase bei Borland
 106 ernsthafte Überlegungen im Gange waren, die Weiterentwicklung
 107 einzustellen.
 108
 109 Aus Interbase 6.0 wurde Firebird 1.0, wobei dies als eine
 110 Bugfix-Version mit nur wenigen Erweiterungen angesehen werden kann.
 111 Eine Erweiterung von Firebird 1.0 ist der 64-Bit File I/O, so dass
 112 auch Datenbankdateien über 2GB erzeugt werden können.
 113
 114 %package dirs
 115 Summary:        Firebird SQL Database common directories
 116 Summary(pl.UTF-8):      Firebird - wspólne katalogi
 117 Group:          Applications/Databases
 118
 119 %description dirs
 120 Firebird SQL Database common directories.
 121
 122 %description dirs -l pl.UTF-8
 123 Firebird - wspólne katalogi.
 124
 125 %package lib
 126 Summary:        Firebird shared library
 127 Summary(pl.UTF-8):      Biblioteka współdzielona Firebird
 128 Group:          Libraries
 129
 130 %description lib
 131 Firebird shared library (libgds).
 132
 133 %description lib -l pl.UTF-8
 134 Biblioteka współdzielona Firebird (libgds).
 135
 136 %package devel
 137 Summary:        Header files for Firebird library
 138 Summary(pl.UTF-8):      Pliki nagłówkowe biblioteki Firebird
 139 Group:          Development/Libraries
 140 Requires:       %{name}-dirs = %{version}-%{release}
 141 Requires:       %{name}-lib = %{version}-%{release}
 142 Requires:       libstdc++-devel
 143 Obsoletes:      Firebird-static
 144
 145 %description devel
 146 Header files for Firebird library.
 147
 148 %description devel -l pl.UTF-8
 149 Pliki nagłówkowe biblioteki Firebird.
 150
 151 %package doc
 152 Summary:        Extensive InterBase and Firebird documentation
 153 Summary(pl.UTF-8):      Obszerna dokumentacja do baz InterBase i Firebird
 154 Group:          Documentation
 155
 156 %description doc
 157 Extensive InterBase and Firebird documentation.
 158
 159 %description doc -l pl.UTF-8
 160 Obszerna dokumentacja do baz InterBase i Firebird.
 161
 162 %package ss
 163 Summary:        Firebird Superserver init scripts
 164 Group:          Applications/Databases
 165 Requires:       %{name} = %{version}-%{release}
 166 Requires(post,preun):   /sbin/chkconfig
 167 Requires:       rc-scripts
 168
 169 %description ss
 170 Firebird Superserver init scripts.
 171
 172 %package classic
 173 Summary:        Firebird Classic init scripts
 174 Group:          Applications/Databases
 175 Requires:       %{name} = %{version}-%{release}
 176
 177 %description classic
 178 Firebird Classic init scripts.
 179
 180 %prep
 181 %setup -q -n %{name}-%{version}-0
 182 %patch0 -p1
 183 %patch1 -p1
 184 %patch2 -p1
 185 %patch3 -p1
 186 %patch4 -p1
 187 %patch5 -p0
 188 %patch6 -p1
 189 %patch7 -p1
 190 %patch8 -p1
 191 %patch9 -p1
 192 %patch10 -p1
 193 %patch11 -p1
 194
 195 mkdir docs
 196 cp %{SOURCE1} %{SOURCE3} %{SOURCE4} %{SOURCE5} %{SOURCE6} %{SOURCE7} %{SOURCE8} %{SOURCE9} docs
 197
 198 # not processed by configure
 199 %{__sed} -i -e 's/^CFLAGS.*$/& %{rpmcflags} %{rpmcppflags}/' extern/btyacc/Makefile
 200 %{__sed} -i -e 's/^\(CC\|LINKER\)\(.*= \)gcc$/\1\2 %{__cc}/' extern/btyacc/Makefile
 201
 202 %build
 203 %{__libtoolize}
 204 %{__aclocal}
 205 %{__autoconf}
 206
 207 %configure \
 208         CFLAGS="%{rpmcflags} -fno-delete-null-pointer-checks" \
 209         --prefix=%{ibdir} \
 210         --with-system-editline \
 211         --with-fbconf=%{_sysconfdir}/firebird \
 212         --with-fbinclude=%{_includedir} \
 213         --with-fblib=%{_libdir} \
 214         --with-fblog=/var/log \
 215         --with-fbsecure-db=/var/lib/firebird \
 216         --with-fbglock=/var/lib/firebird \
 217         --with-gnu-ld \
 218         --with-gpre-pascal \
 219         --with-system-editline \
 220         %{?debug:--enable-debug} \
 221         --disable-rpath \
 222         --disable-binreloc
 223
 224 %{__make} -j1
 225
 226 %install
 227 rm -rf $RPM_BUILD_ROOT
 228
 229 %{__make} -C src -f ../gen/Makefile.install buildImageDir
 230
 231 install -d $RPM_BUILD_ROOT%{_sysconfdir}/{firebird{,/conf.d},rc.d/init.d,sysconfig/rc-inetd}
 232 install -d $RPM_BUILD_ROOT{%{_bindir},%{ibdir},%{_libdir},%{_includedir}} \
 233 install -d $RPM_BUILD_ROOT/var/{log,lib/firebird} \
 234         $RPM_BUILD_ROOT%{_examplesdir}/%{name}-%{version}
 235 install -d $RPM_BUILD_ROOT%{_sysconfdir}/tmpfiles.d
 236 install -d $RPM_BUILD_ROOT%{systemdunitdir}
 237 cp -p %{SOURCE103} $RPM_BUILD_ROOT%{_sysconfdir}/tmpfiles.d/firebird.conf
 238 touch $RPM_BUILD_ROOT/var/log/firebird.log
 239
 240 cd gen/buildroot
 241 cp -p var/lib/firebird/security3.fdb $RPM_BUILD_ROOT/var/lib/firebird
 242 cp -p etc/firebird/*.conf $RPM_BUILD_ROOT%{_sysconfdir}/firebird
 243 chmod 755 usr/include/firebird/impl
 244 cp -pr usr/include/* $RPM_BUILD_ROOT%{_includedir}
 245 cp -dp usr/%{_lib}/*.so* $RPM_BUILD_ROOT%{_libdir}
 246 cd .%{ibdir}
 247 cp -a UDF bin help intl plugins firebird.msg $RPM_BUILD_ROOT%{ibdir}
 248 ln -s %{ibdir}/intl $RPM_BUILD_ROOT%{_sysconfdir}/firebird
 249 ln -s %{ibdir}/{UDF,bin,plugins,firebird.msg} $RPM_BUILD_ROOT%{_sysconfdir}/firebird
 250 chmod u+w -R examples # allow further cleaning
 251 cp -rf examples/* $RPM_BUILD_ROOT%{_examplesdir}/%{name}-%{version}
 252
 253 ln -sf libfbclient.so.2 $RPM_BUILD_ROOT%{_libdir}/libgds.so.0
 254 ln -sf libfbclient.so.2 $RPM_BUILD_ROOT%{_libdir}/libgds.so
 255
 256 for f in bin/{fb_lock_print,gbak,gfix,gpre,gsec,gsplit,gstat,nbackup}; do
 257         ln -sf %{ibdir}/$f $RPM_BUILD_ROOT%{_bindir}/${f#bin/}
 258 done
 259 ln -sf %{ibdir}/bin/isql $RPM_BUILD_ROOT%{_bindir}/fb_isql
 260
 261 rm -f $RPM_BUILD_ROOT%{ibdir}/bin/{FirebirdUninstall.sh,changeServerMode.sh}
 262
 263 sed -e 's|/usr/lib|%{_libdir}|' %{SOURCE100} >$RPM_BUILD_ROOT/etc/rc.d/init.d/firebird
 264 cp -p %{SOURCE101} $RPM_BUILD_ROOT/etc/sysconfig/firebird
 265 sed -e 's|/usr/lib|%{_libdir}|' %{SOURCE104} >$RPM_BUILD_ROOT%{systemdunitdir}/firebird.service
 266 install -d $RPM_BUILD_ROOT/var/run/firebird
 267
 268 sed -e 's|/usr/lib|%{_libdir}|' %{SOURCE102} >$RPM_BUILD_ROOT/etc/sysconfig/rc-inetd/firebird
 269 sed -e 's|/usr/lib|%{_libdir}|' %{SOURCE105} >$RPM_BUILD_ROOT%{systemdunitdir}/firebird-classic@.service
 270 cp -p %{SOURCE106} $RPM_BUILD_ROOT%{systemdunitdir}/firebird-classic.socket
 271
 272 cp -p %{SOURCE107} $RPM_BUILD_ROOT%{_sysconfdir}/firebird/conf.d/
 273 cp -p %{SOURCE108} $RPM_BUILD_ROOT%{_sysconfdir}/firebird/conf.d/
 274
 275 %clean
 276 rm -rf $RPM_BUILD_ROOT
 277
 278 %pre
 279 %groupadd -g 145 firebird
 280 %useradd -u 145 -d %{ibdir} -s /bin/sh -g firebird -c "Firebird Server" firebird
 281
 282 %postun
 283 if [ "$1" = "0" ]; then
 284         %userremove firebird
 285         %groupremove firebird
 286 fi
 287
 288 %post   lib -p /sbin/ldconfig
 289 %postun lib -p /sbin/ldconfig
 290
 291 %post ss
 292 /sbin/chkconfig --add firebird
 293 %service firebird restart
 294 %systemd_post firebird.service
 295
 296 %preun ss
 297 if [ "$1" = "0" ]; then
 298         %service firebird stop
 299         /sbin/chkconfig --del firebird
 300 fi
 301 %systemd_preun firebird.service
 302
 303 %postun ss
 304 %systemd_reload
 305
 306 %post classic
 307 %systemd_post firebird-classic@.service firebird-classic.socket
 308
 309 %preun classic
 310 %systemd_preun firebird-classic@.service firebird-classic.socket
 311
 312 %postun classic
 313 %systemd_reload
 314
 315 %triggerpostun -- %{name} < 2.1.1.17910-2
 316 if [ -f %{ibdir}/firebird.conf.rpmsave ]; then
 317         mv -f %{ibdir}/firebird.conf.rpmsave %{_sysconfdir}/firebird/firebird.conf
 318 fi
 319
 320 %files
 321 %defattr(644,root,root,755)
 322 %doc doc/{license,sql.extensions,Firebird_conf.txt,README.user*,WhatsNew,fb2-todo.txt}
 323 %dir %{_sysconfdir}/firebird
 324 %dir %{_sysconfdir}/firebird/conf.d
 325 %attr(640,root,firebird) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/firebird/databases.conf
 326 %attr(640,root,firebird) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/firebird/fbtrace.conf
 327 %attr(640,root,firebird) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/firebird/firebird.conf
 328 %attr(640,root,firebird) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/firebird/plugins.conf
 329 %{_sysconfdir}/firebird/intl
 330 %{_sysconfdir}/firebird/UDF
 331 %{_sysconfdir}/firebird/bin
 332 %{_sysconfdir}/firebird/firebird.msg
 333 %{_sysconfdir}/firebird/plugins
 334 %attr(755,root,root) %{_bindir}/fb_isql
 335 %attr(755,root,root) %{_bindir}/fb_lock_print
 336 %attr(755,root,root) %{_bindir}/gbak
 337 %attr(755,root,root) %{_bindir}/gfix
 338 %attr(755,root,root) %{_bindir}/gsec
 339 %attr(755,root,root) %{_bindir}/gsplit
 340 %attr(755,root,root) %{_bindir}/gstat
 341 %attr(755,root,root) %{_bindir}/nbackup
 342 %attr(755,root,root) %{_libdir}/libib_util.so
 343 %attr(755,root,root) %{ibdir}/UDF
 344 %attr(755,root,root) %{ibdir}/bin/*
 345 %exclude %{ibdir}/bin/fb_config
 346 %exclude %{ibdir}/bin/gpre
 347 %exclude %{ibdir}/bin/fbguard
 348 %{ibdir}/help
 349 %dir %attr(770,root,firebird) %{ibdir}/intl
 350 %attr(755,root,root) %{ibdir}/intl/fbintl
 351 # should it be moved to %{_sysconfdir} and marked as config?
 352 %{ibdir}/intl/fbintl.conf
 353 %dir %{ibdir}/plugins
 354 %attr(755,root,root) %{ibdir}/plugins/libfbtrace.so
 355 %attr(755,root,root) %{ibdir}/plugins/libCryptKeyHolder_example.so
 356 %attr(755,root,root) %{ibdir}/plugins/libDbCrypt_example.so
 357 %attr(755,root,root) %{ibdir}/plugins/libEngine12.so
 358 %attr(755,root,root) %{ibdir}/plugins/libLegacy_Auth.so
 359 %attr(755,root,root) %{ibdir}/plugins/libLegacy_UserManager.so
 360 %attr(755,root,root) %{ibdir}/plugins/libSrp.so
 361 %attr(755,root,root) %{ibdir}/plugins/libudr_engine.so
 362 %dir %{ibdir}/plugins/udr
 363 %attr(755,root,root) %{ibdir}/plugins/udr/libudrcpp_example.so
 364 %{ibdir}/plugins/udr_engine.conf
 365
 366 %{ibdir}/firebird.msg
 367 %dir %attr(770,root,firebird) /var/lib/firebird
 368 %attr(660,root,firebird) %config(noreplace) %verify(not md5 mtime size) /var/lib/firebird/security3.fdb
 369 %attr(660,root,firebird) %config(noreplace) %verify(not md5 mtime size) /var/log/firebird.log
 370
 371
 372 %files dirs
 373 %defattr(644,root,root,755)
 374 %dir %{ibdir}
 375 %dir %{ibdir}/bin
 376
 377 %files lib
 378 %defattr(644,root,root,755)
 379 %attr(755,root,root) %{_libdir}/libfbclient.so.*.*.*
 380 %attr(755,root,root) %ghost %{_libdir}/libfbclient.so.2
 381
 382 # InterBase/old Firebird compatibility symlinks
 383 %attr(755,root,root) %{_libdir}/libgds.so.0
 384 # needed here - original libgds.so.0 didn't have soname, so some old
 385 # (possibly not open-source) apps may be linked with libgds.so
 386 %attr(755,root,root) %{_libdir}/libgds.so
 387
 388 %files devel
 389 %defattr(644,root,root,755)
 390 %attr(755,root,root) %{_libdir}/libfbclient.so
 391 %attr(755,root,root) %{ibdir}/bin/fb_config
 392 %attr(755,root,root) %{ibdir}/bin/gpre
 393 %attr(755,root,root) %{_bindir}/gpre
 394 %{_includedir}/firebird
 395 %{_includedir}/ib_util.h
 396 %{_includedir}/ibase.h
 397 %{_includedir}/iberror.h
 398 %{_includedir}/perf.h
 399 %{_examplesdir}/%{name}-%{version}
 400
 401 %files doc
 402 %defattr(644,root,root,755)
 403 %doc docs/*
 404
 405 %files ss
 406 %defattr(644,root,root,755)
 407 %attr(640,root,firebird) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/firebird/conf.d/server_mode-ss.conf
 408 %attr(754,root,root) /etc/rc.d/init.d/firebird
 409 %attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/sysconfig/firebird
 410 %attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/tmpfiles.d/firebird.conf
 411 %attr(755,root,root) %{ibdir}/bin/fbguard
 412 %dir %attr(770,root,firebird) /var/run/firebird
 413 %{systemdunitdir}/firebird.service
 414
 415 %files classic
 416 %defattr(644,root,root,755)
 417 %attr(640,root,firebird) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/firebird/conf.d/server_mode-classic.conf
 418 %attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/sysconfig/rc-inetd/firebird
 419 %{systemdunitdir}/firebird-classic@.service
 420 %{systemdunitdir}/firebird-classic.socket