You are not logged in.

#1 2021-09-16 14:38:02

SunDoctor
Member
Registered: 2016-10-24
Posts: 13

Firebird3/Firebird4 - need PKGBUILD

Hi!

Firebird database is very old in AUR and almost out-of-date:

https://aur.archlinux.org/packages/firebird-superserver

It would be great if someone could make fresh package file for Firebird3/Firebird4

My knowledge is not enough for this. So, I need help as many users of Arch & Firebird.

Offline

#2 2021-09-16 14:57:00

WorMzy
Forum Moderator
From: Scotland
Registered: 2010-06-16
Posts: 11,788
Website

Re: Firebird3/Firebird4 - need PKGBUILD

Mod note: moving to AUR Issues


Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

Offline

#3 2021-09-16 19:00:40

loqs
Member
Registered: 2014-03-06
Posts: 17,196

Re: Firebird3/Firebird4 - need PKGBUILD

If you replace the firebird-superserver PKGBUILD with the one below,  how much if any of it works?

# Maintainer: Benjamin Bukowski <bbukowski@posteo.de>
pkgname=firebird-superserver
_pkgver=4.0.0
pkgver=$_pkgver.2496
pkgrel=1
pkgdesc="A open source SQL relational database management system (RDMS)"
arch=('i686' 'x86_64')
url="http://www.firebirdsql.org/"
license=('custom:IPL' 'custom:IDPL')
depends=('icu' 'libedit' 'libtommath' 'libtomcrypt')
makedepends=('unzip')
provides=("libfbclient=$pkgver")
conflicts=('firebird-classicserver' 'libfbclient')
#options=('!makeflags')
install=firebird-superserver.install
backup=('etc/firebird/firebird.conf' 'etc/firebird/fbtrace.conf' 'etc/firebird/aliases.conf')

source=("https://github.com/FirebirdSQL/firebird/releases/download/v$_pkgver/Firebird-$pkgver-0.tar.xz"
        'default.password'
        'firebird-tmpfiles.conf'
        'firebird-sysusers.conf'
        'firebird.service')

md5sums=('7cb573cb41ea2fcd4c68f84d6f829199'
         'ee601f52f1ba2481fe1f05b25d000bb8'
         '79a1416e307e4dfb99640311b8defe07'
         'a43ab472f4d95e48ac21910bb33a5e86'
         '90b4631c9bff99aab08511b3a184593e')

build() {
  cd $srcdir/Firebird-$pkgver-0

  ./autogen.sh \
    --prefix=/usr \
    --with-fbbin=/usr/bin \
    --with-fbconf=/etc/firebird \
    --with-fbdoc=/usr/share/doc/firebird \
    --with-fbglock=/run/firebird \
    --with-fbhelp=/usr/share/doc/firebird/help \
    --with-fbinclude=/usr/include/firebird \
    --with-fblib=/usr/lib \
    --with-fblog=/var/log/ \
    --with-fbmsg=/usr/lib/firebird/msg \
    --with-fbplugins=/usr/lib/firebird/plugins \
    --with-fbsbin=/usr/lib/firebird/bin \
    --with-fbsecure-db=/var/lib/firebird/system \
    --with-fbintl=/usr/lib/firebird/intl \
    --without-fbmisc \
    --without-fbsample \
    --without-fbsample-db \
    --with-system-editline

    make
}

package() {
  cd $srcdir/Firebird-$pkgver-0/gen
  
  ./install/makeInstallImage.sh 
  
  cd $srcdir/Firebird-$pkgver-0
  
  cp -av gen/buildroot/* $pkgdir/

  install -Dm644 $srcdir/firebird-tmpfiles.conf $pkgdir/usr/lib/tmpfiles.d/firebird.conf
  install -Dm644 $srcdir/firebird-sysusers.conf $pkgdir/usr/lib/sysusers.d/firebird.conf
  install -Dm644 $srcdir/firebird.service $pkgdir/usr/lib/systemd/system/firebird.service
  install -Dm440 $srcdir/default.password $pkgdir/var/lib/firebird/system/SYSDBA.password
  install -Dm644 $pkgdir/etc/firebird/I{,D}PLicense.txt -t $pkgdir/usr/share/licenses/${pkgname}

  # Remove unused files and dirs
  rm $pkgdir/etc/firebird/I{,D}PLicense.txt
  rm $pkgdir/etc/firebird/README.md
  rm $pkgdir/etc/firebird/CHANGELOG.md
  rm -rf $pkgdir/var/log
  rm -rf $pkgdir/run

  mv $pkgdir/usr/bin/isql{,-fb}

  chmod -R ugo-w $pkgdir/usr/share/doc/firebird
  chmod -R o= $pkgdir/var/lib/firebird
  chown -R 184:184 $pkgdir/var/lib/firebird
}

# vim:set ts=2 sw=2 et:

Edit:
As a diff

diff --git a/PKGBUILD b/PKGBUILD
index b7322fe..ae6120b 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -1,26 +1,27 @@
 # Maintainer: Benjamin Bukowski <bbukowski@posteo.de>
 pkgname=firebird-superserver
-_pkgver=2.5.9
-pkgver=$_pkgver.27139
+_pkgver=4.0.0
+pkgver=$_pkgver.2496
 pkgrel=1
 pkgdesc="A open source SQL relational database management system (RDMS)"
 arch=('i686' 'x86_64')
 url="http://www.firebirdsql.org/"
 license=('custom:IPL' 'custom:IDPL')
-depends=('icu' 'libedit')
+depends=('icu' 'libedit' 'libtommath' 'libtomcrypt')
+makedepends=('unzip')
 provides=("libfbclient=$pkgver")
 conflicts=('firebird-classicserver' 'libfbclient')
-options=('!makeflags')
+#options=('!makeflags')
 install=firebird-superserver.install
 backup=('etc/firebird/firebird.conf' 'etc/firebird/fbtrace.conf' 'etc/firebird/aliases.conf')
 
-source=("https://github.com/FirebirdSQL/firebird/releases/download/R${_pkgver//./_}/Firebird-${pkgver}-0.tar.bz2"
+source=("https://github.com/FirebirdSQL/firebird/releases/download/v$_pkgver/Firebird-$pkgver-0.tar.xz"
         'default.password'
         'firebird-tmpfiles.conf'
         'firebird-sysusers.conf'
         'firebird.service')
 
-md5sums=('e32043e61511f53703df6c47441ff6ab'
+md5sums=('7cb573cb41ea2fcd4c68f84d6f829199'
          'ee601f52f1ba2481fe1f05b25d000bb8'
          '79a1416e307e4dfb99640311b8defe07'
          'a43ab472f4d95e48ac21910bb33a5e86'
@@ -42,14 +43,11 @@ build() {
     --with-fbmsg=/usr/lib/firebird/msg \
     --with-fbplugins=/usr/lib/firebird/plugins \
     --with-fbsbin=/usr/lib/firebird/bin \
-    --with-fbudf=/usr/lib/firebird/UDF \
     --with-fbsecure-db=/var/lib/firebird/system \
     --with-fbintl=/usr/lib/firebird/intl \
     --without-fbmisc \
     --without-fbsample \
     --without-fbsample-db \
-    --enable-superserver \
-    --with-system-icu \
     --with-system-editline
 
     make
@@ -72,8 +70,8 @@ package() {
 
   # Remove unused files and dirs
   rm $pkgdir/etc/firebird/I{,D}PLicense.txt
-  rm $pkgdir/etc/firebird/README
-  rm $pkgdir/etc/firebird/WhatsNew
+  rm $pkgdir/etc/firebird/README.md
+  rm $pkgdir/etc/firebird/CHANGELOG.md
   rm -rf $pkgdir/var/log
   rm -rf $pkgdir/run
 

Last edited by loqs (2021-09-16 19:05:11)

Offline

Board footer

Powered by FluxBB