Firebird is a relational database offering many ANSI SQL-99 features
that runs on Linux, Windows, and a variety of Unix platforms. Firebird
offers excellent concurrency, high performance, and powerful language
support for stored procedures and triggers. It has been used in
production systems, under a variety of names since 1981.
Firebird is completely free of any registration, licensing or deployment
fees. It may be deployed freely for use with any third-party software,
whether commercial or not.
See also: https://sourceforge.net/projects/firebird/
Firebird 3 was installed.
1) Before start the server ensure that the following line exists in /etc/services:
gds_db 3050/tcp #InterBase Database Remote Protocol
2) If you use inetd (Classic Server) then add the following line to /etc/inetd.conf
gds_db stream tcp nowait firebird /usr/local/sbin/firebird firebird
And finally restart inetd.
3) If you want to use change firebird modes then you must modify the ServerMode
variable into /usr/local/etc/firebird/firebird.conf file.
ServerMode="Super"
# ServerMode="SuperClassic"
# ServerMode="Classic"
4) It is STRONGLY recommended that you change the SYSDBA
password with:
# gsec -user SYSDBA -pass masterkey
GSEC> modify SYSDBA -pw newpassword
GSEC> quit
before doing anything serious with Firebird.
5) See documentation in /usr/local/share/doc/firebird/ for more information.
6) Some firebird tools were renamed for avoid conflicts with some other ports
/usr/local/bin/isql -> /usr/local/bin/isql-fb
/usr/local/bin/gstat -> /usr/local/bin/fbstat
/usr/local/bin/gsplit -> /usr/local/bin/fbsplit
6) Enjoy it ;)
*/*: Sunset 12.4-RELEASE/12-STABLE from ports tree
- Remove all references to defunct ARCH arm
- Remove all references to defunct ARCH sparc64
- Remove x11-drivers/xf86-video-sunffb which requires defunct sparc64
ARCH
- Remove sysutils/afbinit requires defunct sparc64 ARCH
- Remove all references to bktr driver
- Remove all references to defunct FreeBSD_12
- Remove all references to OSVERSION/OSREL corresponding to 12
- Remove conditionals in Mk/Uses/cabal.mk
- Remove sparc reference from Mk/Uses/qt-dist.mk
- Remove BROKEN_sparc64/NOT_FOR_ARCH=sparc64
- Remove BROKEN_FreeBSD_12* from:
- Remove OpenSSL patches from:
- Remove conditional flags for OSVERSION >= 1300000 to fixed flags.
Also move conditional flags for non sparc64/arm ARCH to fixed flags.
Reviewed by: brooks, jbeich, rene, salvadore
Differential Revision: https://reviews.freebsd.org/D42068
databases/firebird30-server: fix build with lld 17
Building databases/firebird30-server with lld 17 results in the
following link error:
c++ -O2 -pipe -DAMD64 -fstack-protector-strong -isystem /usr/local/include
-fno-strict-aliasing -isystem /usr/local/include -std=gnu++03
-fstack-protector-strong -L/usr/local/lib -D_THREAD_SAFE
-Wl,-rpath,/usr/local/lib -Wl,-rpath,/usr/local/libexec/firebird/intl
-Wl,--version-script,empty.vers -Wl,-rpath,../gen/firebird/lib
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/c_cxx.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/cmd.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/cme.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/cmp.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/exp.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/gpre.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/hsh.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/int_cxx.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/jrdmet.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/movg.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/msc.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/obj_cxx.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/par.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/pat.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/sqe.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/sql.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/gpre/boot/gpre_meta_boot.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/yvalve/gds.o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/temp/Release/common.a
-o
/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/gen/Release/firebird/bin/gpre_boot
-L/wrkdirs/share/dim/ports/databases/firebird30-client/work/Firebird-3.0.10.33601-0/gen/Release/firebird/lib
-liconv -lm -lpthread -lcurses
ld: error: version script assignment of 'global' to symbol '_IO_stdin_used'
failed: symbol not defined
c++: error: linker command failed with exit code 1 (use -v to see invocation)
The mentioned symbol is only relevant for Linux. Remove it from the
builds/posix/vers.sh.in script that generates the linker version script.
PR: 274335
Approved by: maintainer timeout (2 weeks)
MFH: 2023Q4
databases/firebird30-*: Fix consumers build
After firebird25-* was removed from the tree firebird30-* bacem the new
default. And some consumers of firebird started failing to build with
the error "/usr/local/include/ibase.h:6:10: fatal error:
'../jrd/ibase.h' file not found".
In previous the src headers files were installed which were not
sanitized and required other header files from the source tree. This
patch properly installs the sanitized header files and fixes the
consumer builds.
While I am here fix the patches to be makepatch compatible.
Approved by: portmgr(just-fix-it)
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner)
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above )
*/*: Remove redundant '-*' from CONFLICTS definitions
The conflict checks compare the patterns first against the package
names without version (as reported by "pkg query "%n"), then - if
there was no match - agsinst the full package names including the
version (as reported by "pkg query "%n-%v").
Approved by: portmgr (blanket)
databases/fireird30-[client|server]: New port: Firebird-3 relational database
Firebird is a relational database offering many ANSI SQL-99 features
that runs on Linux, Windows, and a variety of Unix platforms. Firebird
offers excellent concurrency, high performance, and powerful language
support for stored procedures and triggers. It has been used in
production systems, under a variety of names since 1981.
Firebird is completely free of any registration, licensing or deployment
fees. It may be deployed freely for use with any third-party software,
whether commercial or not.
WWW: https://sourceforge.net/projects/firebird/
WWW: http://www.firebirdsql.org/
PR: 254387
