From: onlylunix <onlylunix@users.noreply.github.com>
To: ml@inbox.vuxu.org
Subject: Re: [PR PATCH] [Updated] firebird3: update to 3.0.12.33717
Date: Sat, 14 Oct 2023 16:23:59 +0200 [thread overview]
Message-ID: <20231014142359.xa3lwGnas5pBmSVM9ynwohixaJf7jld8IIXOIvZuEm8@z> (raw)
In-Reply-To: <gh-mailinglist-notifications-41a7ca26-5023-4802-975b-f1789d68868e-void-packages-46672@inbox.vuxu.org>
[-- Attachment #1: Type: text/plain, Size: 1148 bytes --]
There is an updated pull request by onlylunix against master on the void-packages repository
https://github.com/onlylunix/void-packages firebird3upd
https://github.com/void-linux/void-packages/pull/46672
firebird3: update to 3.0.12.33717
<!-- Uncomment relevant sections and delete options which are not applicable -->
#### Testing the changes
- I tested the changes in this PR: **YES**
<!--
#### New package
- This new package conforms to the [package requirements](https://github.com/void-linux/void-packages/blob/master/CONTRIBUTING.md#package-requirements): **YES**|**NO**
-->
<!-- Note: If the build is likely to take more than 2 hours, please add ci skip tag as described in
https://github.com/void-linux/void-packages/blob/master/CONTRIBUTING.md#continuous-integration
and test at least one native build and, if supported, at least one cross build.
Ignore this section if this PR is not skipping CI.
-->
#### Local build testing
- I built this PR locally for my native architecture, (x86_64-LIBC, i686-LIBC, x86_64-musl)
A patch file from https://github.com/void-linux/void-packages/pull/46672.patch is attached
[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #2: github-pr-firebird3upd-46672.patch --]
[-- Type: text/x-diff, Size: 8282 bytes --]
From 4bee5dcdba29ddb8b9cc81d7ebad46653394a541 Mon Sep 17 00:00:00 2001
From: onlylunix <userpc2021@yandex.ru>
Date: Sat, 14 Oct 2023 05:34:41 +0300
Subject: [PATCH] firebird3: update to 3.0.12.33717
---
srcpkgs/firebird3/INSTALL | 9 ++++
srcpkgs/firebird3/files/firebird-fix-perm-fdb | 27 ++++++++++++
srcpkgs/firebird3/files/firebird.xinetd | 16 +++++++
srcpkgs/firebird3/files/firebird3/run | 3 ++
.../patches/fix-databases-conf.patch | 15 +++++++
srcpkgs/firebird3/patches/fix-std-isnan.patch | 13 ------
srcpkgs/firebird3/template | 42 ++++++++++++-------
7 files changed, 98 insertions(+), 27 deletions(-)
create mode 100644 srcpkgs/firebird3/INSTALL
create mode 100755 srcpkgs/firebird3/files/firebird-fix-perm-fdb
create mode 100644 srcpkgs/firebird3/files/firebird.xinetd
create mode 100755 srcpkgs/firebird3/files/firebird3/run
create mode 100644 srcpkgs/firebird3/patches/fix-databases-conf.patch
delete mode 100644 srcpkgs/firebird3/patches/fix-std-isnan.patch
diff --git a/srcpkgs/firebird3/INSTALL b/srcpkgs/firebird3/INSTALL
new file mode 100644
index 0000000000000..f8863ec6163d8
--- /dev/null
+++ b/srcpkgs/firebird3/INSTALL
@@ -0,0 +1,9 @@
+case "${ACTION}" in
+post)
+ if [ "$UPDATE" = "no" ]
+ then
+ gsec -add sysdba -pw masterkey || true
+ firebird-fix-perm-fdb
+ fi
+ ;;
+esac
diff --git a/srcpkgs/firebird3/files/firebird-fix-perm-fdb b/srcpkgs/firebird3/files/firebird-fix-perm-fdb
new file mode 100755
index 0000000000000..54b3e9749a7f6
--- /dev/null
+++ b/srcpkgs/firebird3/files/firebird-fix-perm-fdb
@@ -0,0 +1,27 @@
+#!/bin/sh
+bn=$(basename $0)
+ECHO(){ echo "$bn: $@"; }
+
+RunUser=_firebird
+RunGroup=_firebird
+databasesconf='/etc/firebird/databases.conf'
+
+# A number of predefined macros (syntax $(name)) is available for use in the configuration files
+# to substitute for a directory name (src: https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rlsnotes30.html#rnfb30-configparams-macrosubs)
+# dir_sampledb='/usr/examples/empbuild' # employee.fdb
+dir_secdb='/var/lib/firebird/system'
+
+chkperm(){
+[ -e "$1" ] || { ECHO "Warning! No exists: $1" && return; }
+chpst -u $RunUser test -w "$1" && ECHO "Ok: $1" || { ECHO "Fix permissions: $1"; chown $RunUser:$RunGroup "$1" && chmod 660 "$1"; }
+}
+
+for i in $(grep '^[^#]*=.*\.fdb.*$' "$databasesconf" |
+sed "s|#.*||; s|^\(.*=\s*\)\(.*\)$|\2|;
+# s|\$(dir_sampledb)|$dir_sampledb|i;
+s|\$(dir_secdb)|$dir_secdb|i") # need more testing
+do
+ chkperm "$i"
+done
+
+ECHO 'Done.'
diff --git a/srcpkgs/firebird3/files/firebird.xinetd b/srcpkgs/firebird3/files/firebird.xinetd
new file mode 100644
index 0000000000000..f8f1f7fa348c4
--- /dev/null
+++ b/srcpkgs/firebird3/files/firebird.xinetd
@@ -0,0 +1,16 @@
+# default: off
+# description: FirebirdSQL v3.0
+service gds-db
+{
+ disable = yes
+ flags = REUSE NODELAY
+ socket_type = stream
+ wait = no
+ user = _firebird
+# These lines cause problems with Windows XP SP2 clients
+# using default firewall configuration (SF#1065511)
+# log_on_success += USERID
+# log_on_failure += USERID
+# Need ServerMode = Classic in /etc/firebird/firebird.conf
+ server = /usr/lib/firebird/bin/firebird
+}
diff --git a/srcpkgs/firebird3/files/firebird3/run b/srcpkgs/firebird3/files/firebird3/run
new file mode 100755
index 0000000000000..f9e37a7a38291
--- /dev/null
+++ b/srcpkgs/firebird3/files/firebird3/run
@@ -0,0 +1,3 @@
+#!/bin/sh
+chpst -u _firebird:_firebird test -w /etc/firebird/fb_guard || install /dev/null -m 644 -o _firebird -g _firebird /etc/firebird/fb_guard
+exec chpst -u _firebird:_firebird /usr/lib/firebird/bin/fbguard -forever
diff --git a/srcpkgs/firebird3/patches/fix-databases-conf.patch b/srcpkgs/firebird3/patches/fix-databases-conf.patch
new file mode 100644
index 0000000000000..3a9a55fc1c00a
--- /dev/null
+++ b/srcpkgs/firebird3/patches/fix-databases-conf.patch
@@ -0,0 +1,15 @@
+--- a/builds/install/misc/databases.conf.in
++++ b/builds/install/misc/databases.conf.in
+@@ -17,8 +17,9 @@
+ #
+ # Example Database:
+ #
+-employee.fdb = $(dir_sampleDb)/employee.fdb
+-employee = $(dir_sampleDb)/employee.fdb
++# employee.fdb = $(dir_sampleDb)/employee.fdb
++# employee = $(dir_sampleDb)/employee.fdb
++help = /usr/share/doc/firebird/help/help.fdb
+
+ #
+ # Master security database specific setup.
+
diff --git a/srcpkgs/firebird3/patches/fix-std-isnan.patch b/srcpkgs/firebird3/patches/fix-std-isnan.patch
deleted file mode 100644
index 9da229bdc86f1..0000000000000
--- a/srcpkgs/firebird3/patches/fix-std-isnan.patch
+++ /dev/null
@@ -1,13 +0,0 @@
---- a/src/common/classes/FpeControl.h 2020-06-26 12:02:51.000000000 +0200
-+++ b/src/common/classes/FpeControl.h 2020-09-17 06:04:30.516565361 +0200
-@@ -42,6 +42,10 @@
- #include <ieeefp.h>
- #endif
-
-+#if !defined(__GLIBC__)
-+#define isinf std::isinf
-+#endif
-+
- namespace Firebird
- {
-
diff --git a/srcpkgs/firebird3/template b/srcpkgs/firebird3/template
index 575415d2128f1..c0c90aa8a7b69 100644
--- a/srcpkgs/firebird3/template
+++ b/srcpkgs/firebird3/template
@@ -1,9 +1,10 @@
# Template file for 'firebird3'
pkgname=firebird3
-version=3.0.6.33328
-revision=2
-_build=0
-_uver=${version//./_}
+version=3.0.12.33717
+revision=1
+_commit=af555f74ad07b7359aae1df69ea27ae44fc7e33b
+#_build=0
+#_uver=${version//./_}
build_style=gnu-configure
build_helper="qemu"
configure_args="--prefix=/usr
@@ -23,23 +24,37 @@ configure_args="--prefix=/usr
--with-fbmisc
--without-fbsample
--without-fbsample-db
- --with-system-icu
--with-system-editline"
-hostmakedepends="automake libtool pkg-config icu"
+# unrecognized options: --with-system-icu
+hostmakedepends="automake libtool pkg-config icu rsync"
makedepends="boost-devel libedit-devel icu-devel ncurses-devel libatomic_ops-devel
libtommath-devel zlib-devel"
short_desc="Relational database offering many ANSI SQL standard features (V3)"
maintainer="Orphaned <orphan@voidlinux.org>"
license="custom:IDPL-1.0, Interbase-1.0"
homepage="https://www.firebirdsql.org/en/start/"
-distfiles="https://github.com/FirebirdSQL/firebird/releases/download/R${_uver%_*}/Firebird-${version}-${_build}.tar.bz2"
-checksum=34c1d2a29bbaf288e682cd1b5f8083f2baf73f351062245ace0bee35a3f7d35f
+#distfiles="https://github.com/FirebirdSQL/firebird/releases/download/R${_uver%_*}/Firebird-${version}-${_build}.tar.bz2"
+distfiles="https://github.com/FirebirdSQL/firebird/archive/${_commit}.tar.gz"
+checksum=1f230ff03fb734c4d406729e69420ce400a9e53273dbc5dd550993e9d745c615
replaces="firebird>=0"
nocross="Fails to build gpre_boot for host but builds for target"
CFLAGS="-fno-strict-aliasing"
CXXFLAGS="-fno-delete-null-pointer-checks -Wno-deprecated -Wno-deprecated-declarations"
+# Create firebird system user/group
+system_accounts="_firebird _firebird"
+_firebird_homedir="/var/lib/firebird"
+_firebird_descr="Firebird Database Owner"
+triggers="system-accounts"
+
+conf_files="
+ /etc/firebird/databases.conf
+ /etc/firebird/fbtrace.conf
+ /etc/firebird/firebird.conf
+ /etc/firebird/plugins.conf
+ /var/lib/firebird/system/security3.fdb"
+
if [ "$CROSS_BUILD" ]; then
configure_args+=" --enable-binreloc"
configure_args+=" ac_cv_func_sem_init=no"
@@ -97,8 +112,6 @@ pre_configure() {
}
do_install() {
- local _lib _v0=${version%.*} _v1=${version%.*.*} _v2=${version%.*.*.*}
-
cd ${wrksrc}/gen
./install/makeInstallImage.sh
@@ -111,14 +124,15 @@ do_install() {
vlicense doc/license/IDPL.txt IDPL
vlicense doc/license/README.license.usage.txt LICENSE
- cp -pR gen/buildroot/* ${DESTDIR}/
+ rsync -a --exclude '*.sh' gen/buildroot/ ${DESTDIR}/ # exclude old broken scripts
# Conflicts with isql from unixodbc.
mv ${DESTDIR}/usr/bin/isql{,-fb}
- # TODO: create superserver?
- # system account?
- # runit service?
+ vsv firebird3 # runit service, default ServerMode = Super, see: /etc/firebird/firebird.conf
+ vinstall ${FILESDIR}/firebird.xinetd 644 etc/xinetd.d firebird3 # xinetd, need ServerMode = Classic
+ vinstall ${FILESDIR}/firebird-fix-perm-fdb 755 usr/lib/firebird/bin
+ ln -sf /usr/lib/firebird/bin/firebird-fix-perm-fdb ${DESTDIR}/usr/bin/firebird-fix-perm-fdb
# Example https://aur.archlinux.org/cgit/aur.git/tree/PKGBUILD?h=firebird-superserver
}
next prev parent reply other threads:[~2023-10-14 14:24 UTC|newest]
Thread overview: 29+ messages / expand[flat|nested] mbox.gz Atom feed top
2023-10-14 2:38 [PR PATCH] " onlylunix
2023-10-14 14:23 ` onlylunix [this message]
2023-10-23 9:57 ` mhmdanas
2023-11-03 2:05 ` [PR PATCH] [Updated] " onlylunix
2023-11-19 2:32 ` [PR PATCH] [Updated] firebird3: update to 3.0.12.33721 onlylunix
2024-01-24 0:40 ` firebird3: update to 3.0.12.33724 onlylunix
2024-01-24 0:40 ` onlylunix
2024-01-24 0:42 ` onlylunix
2024-01-24 0:44 ` onlylunix
2024-01-24 0:58 ` onlylunix
2024-01-24 1:00 ` onlylunix
2024-01-24 1:02 ` onlylunix
2024-01-24 2:01 ` [PR PATCH] [Updated] " onlylunix
2024-01-24 12:03 ` [PR PATCH] [Updated] firebird3: update to 3.0.12.33727~5a2babe onlylunix
2024-01-25 14:16 ` onlylunix
2024-01-25 14:30 ` onlylunix
2024-02-22 2:15 ` onlylunix
2024-03-30 1:35 ` [PR PATCH] [Updated] firebird3: update to 3.0.12.33731~44e1337 onlylunix
2024-04-05 2:52 ` [PR PATCH] [Updated] firebird3: update to 3.0.12.33740~da67df2 onlylunix
2024-07-05 1:49 ` github-actions
2024-07-17 0:05 ` [PR PATCH] [Updated] " onlylunix
2024-08-02 21:58 ` [PR PATCH] [Updated] firebird3: update to 3.0.12.33766~b50861b onlylunix
2024-08-09 15:53 ` [PR PATCH] [Updated] firebird3: update to 3.0.12.33784~cd85743 onlylunix
2024-08-09 15:55 ` onlylunix
2024-08-23 2:24 ` [PR PATCH] [Updated] firebird3: update to 3.0.12.33787 onlylunix
2024-10-08 16:19 ` [PR PATCH] [Updated] firebird3: update to 3.0.13.33791~c8a36d9 onlylunix
2024-10-16 1:31 ` [PR PATCH] [Updated] firebird3: update to 3.0.13.33793~3e62713 onlylunix
2024-10-17 23:00 ` [PR PATCH] [Updated] firebird3: update to 3.0.13.33793 onlylunix
-- strict thread matches above, loose matches on Subject: below --
2023-07-10 21:49 [PR PATCH] firebird3: update to 3.0.10 onlylunix
2023-10-14 2:09 ` [PR PATCH] [Updated] firebird3: update to 3.0.12.33717 onlylunix
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=20231014142359.xa3lwGnas5pBmSVM9ynwohixaJf7jld8IIXOIvZuEm8@z \
--to=onlylunix@users.noreply.github.com \
--cc=ml@inbox.vuxu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).