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 4 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
7) Enjoy it ;)
databases/firebird40-server: Add missing header file
iberror.h file includes another file called gen/iberror.h which was not
installed by the pkg. This cannot be easily spotted unless other ports
tries to use the header.
Approved by: portmgr (just-fix-it)
databases/firebird40-*: Update to 4.0.5
- Switch to c++17. It could fix some issues with new version of devel/icu [1]
PR: 283543
Reported by: diizzy [1]
*/*: 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/firebird40-server: fix build with lld 17
Building databases/firebird40-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=c++11 -std=c++11
-std=c++11 -std=c++11 -static-libstdc++ -Wl,--version-script,firebird.vers
-fstack-protector-strong -L/usr/local/lib -D_THREAD_SAFE -shared
-Wl,-soname,libfbclient.so.4 -Wl,-rpath,/usr/local/lib -o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/gen/Release/firebird/lib/libfbclient.so.4.0.2
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/DistributedTransaction.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/MasterImplementation.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/PluginManager.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/alt.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/array.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/blob.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/gds.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/keywordsStub.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/perf.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/preparse.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/user_dsql.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/utl.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/why.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/config/os/posix/binreloc.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/yvalve/config/os/posix/config_root.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/remote/inet.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/remote/merge.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/remote/parser.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/remote/protocol.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/remote/remote.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/auth/SecureRemotePassword/srp.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/remote/client/BlrFromMessage.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/remote/client/interface.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/auth/SecureRemotePassword/client/SrpClient.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/auth/SecurityDatabase/LegacyClient.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/plugins/crypt/arc4/Arc4.o
/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/temp/Release/common.a
-L/wrkdirs/share/dim/ports/databases/firebird40-client/work/Firebird-4.0.2.2816-0/gen/Release/firebird/lib
-liconv -lm -lpthread -ldecFloat -lre2 -ltommath -ltomcrypt
c++: warning: argument unused during compilation: '-static-libstdc++'
[-Wunused-command-line-argument]
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: 274336
Approved by: maintainer timeout (2 weeks)
MFH: 2023Q4
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/firebird40-[client|server]: New port: Firebird-4 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/
