SQL Relay is a persistent database connection pooling, proxying and
load balancing system for Unix and Linux supporting ODBC, Oracle,
MySQL, mSQL, PostgreSQL, Sybase, MS SQL Server, IBM DB2, Interbase,
Lago and SQLite with C, C++, Perl, Perl-DBD, Python, Python-DB, Zope,
PHP, Ruby and Java APIs, command line clients, a GUI configuration
tool and extensive documentation. The APIs support advanced database
operations such as bind variables, multi-row fetches, client side
result set caching and suspended transactions. It is ideal for
speeding up database-driven web-based applications, accessing
databases from unsupported platforms, migrating between databases,
distributing access to replicated databases and throttling database
access.
===> The following configuration options are available for sqlrelay-1.9.3_1:
DOCS=on: Build and/or install documentation
FIREBIRD=off: Firebird (Interbase) database support
FREETDS=off: FreeTDS library support
MYSQL=off: MySQL database support
ODBC=off: ODBC database backend
ORACLE=off: Oracle database support
PGSQL=off: PostgreSQL database support
SQLITE3=off: SQLite 3 database support
===> Use 'make config' to modify these settings
Templates/config.(guess|sub): Update to 2026-05-17
Also remove our local changes that replaced x86_64 with amd64 because
these complicate porting by forcing port maintainers to replace x86_64
with amd64 in configure scripts.
Additional changes:
bsd.port.mk: Apply S/amd64/x86_64/ to CONFIGURE_TARGET. This is not
required to run configure but some ports need to use this in pkg-plist.
comms/qico, news/fidogate:
CONFIGURE_TARGET shouldn't contain "--build". Just remove it altogether
because the default value is fine.
(Only the first 15 lines of the commit message are shown above )
*/*: Update WWW to use HTTPS for sourceforge.net projects
Homepage link is permanent redirected to its HTTPS counterpart
Issue reported by repology : https://repology.org/repository/freebsd/problems
Approved by: portmgr (blanket)
PR: 274888
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 ONLY_FOR_ARCHS restriction for i386: the port currently builds fine
on it with all options enabled, and this is generally wrong way to account
for breakages in dependencies.
Update `databases/gdbm' to version 1.18.1, an important bugfix release
which restores compatibility with old databases (version 1.8) and some
later versions which were built without mmap(2) support. Due to shlib
version change, bump port revisions of the consumer ports.
PR: 233059
Exp-run by: antoine
Approved by: maintainer (johans, numerous timeouts)
devel/rudiments: update 1.0.2 -> 1.0.4
databases/sqlrelay: update 1.0.0 -> 1.0.1
rudiments:
- added support for EOT to codetree
- added loop-avoidance to xmldomevents class
- added alias support to codetree class
- replaced readline with libedit
- included implementation of history_truncate_file for versions of
libedit that don't provide it
- added --disable-wall and --disable-werror configure options
sqlrelay:
- updated sqlr-bench to create "db"-bench.png
- added edoc-generated API docs for the Erlang API
(Only the first 15 lines of the commit message are shown above )
Do not use post-stage. Use post-install instead.
The only reason to use post-stage is because the port needs to do
"things" at a later time, like some plist manipulation.
While there, fold post-install in do-install targets when they are
defined.
PR: 214780
Submitted by: mat
Exp-run by: antoine
Sponsored by: Absolight
Use USES=pathfix where applicable.
PR: 213195
Submitted by: mat
Exp-run by: antoine
Sponsored by: Absolight
Differential Revision: https://reviews.freebsd.org/D8093
Remove USE_FIREBIRD from bsd.databases.mk, replaced by USES=firebird.
Also:
- replace USE_FIREBIRD by USES=firebird.
- convert ports depending on databases/firebird25-client directly to
USES=firebird.
PR: 208971
Submitted by: mat
Exp-run by: antoine
With hat: portmgr
Sponsored by: Absolight
Differential Revision: https://reviews.freebsd.org/D5951
devel/rudiments: 0.54 -> 0.55.0
databases/sqlrelay: 0.64 -> 0.65.0
rudiments:
- file::open sets errno=ENOENT if the file or path wasn't found on
Windows now
- fixed a bug with filedescriptor::printf when printing to non-buffered
files on Windows and Solaris 11
- fixed a bug that caused a crash in codetree if codeposition is NULL
- added missing dll export clause to codetreegrammar class
- added xmldomevents class
- added namespace discrimination in codetree::write
- fixed a codetree end-of-string-during-concatenation bug
- fixed a codetree tree reset bug
- fixed an xmlsax bug that caused text nodes with empty values to be
(Only the first 15 lines of the commit message are shown above )
devel/rudiments: 0.52 -> 0.53
databases/sqlrelay: 0.62 -> 0.63
0.53 - exposed codetreegrammar class and updated codetree class so that
successive parses/writes can use the same grammar without
having to reload it
added insert/appendXml(File) methods to xmldomnode to parse and
insert/append xml strings or files to a node
fixed FILE->fileno detection for solaris 11.2,
which doesn't have it at all
llabs() is detected and preferred to abs()
added partial xml namespace support (namespaces for tags)
added partial support for extended ascii character set to character
class
added setgroups() call before setuid() call to drop extraneous groups
(Only the first 15 lines of the commit message are shown above )
databases/sqlrelay: 0.60 -> 0.62
- added query filter plugin framework
- added regex, string and pattern filters
- added normalization translation
- added reformatdatetime result set translation
- fixed error in sqlrconfigfile class that could cause sqlr-start to
- crash if one instance defines addresses but the next doesn't
- added query status flag to sqlrservercursor
- tweaked odbc driver's SQLGetTypeInfo()
- field name is passed into runResultSetTranslations() now
- added support for maxitembuffersize, maxselectlistsize,
- and maxbindcount for firebird
- added native api for node.js
- added recognition of bigint, ubigint and uniqueidentifier fields in
(Only the first 15 lines of the commit message are shown above )
devel/rudiments: 0.50 -> 0.51
databases/sqlrelay: 0.59 -> 0.60
- Both packages are updated together.
- Lots of changes in devel/rudiments, see ChangeLog
- Fixes in sqlrelay:
o fixed true->false transposition in sqlrservercontroller::interceptQuery
that could lead to a reLogIn loop
o applied George Carrette's patch to fix PDO connectstring options
o migrated directory/file paths info into sqlrpaths class
o removed undocumented and not-so-relevent-these-days
o MAX_CONNECTIONS/overridemaxconnections failsafe in sqlr-start
o fixed java header detection for javac located in /usr/bin
o updated java api to support non-null-tolerant implementations of
environment::NewStringUTF()
o the perl api builds correctly on OSR5 again
o the postgresql sslmode is omitted entirely from the connect string now,
if it's disabled, to prevent problems with older versions of
postgresql that don't support the parameter at all
o mono 2.8 or greater is required now
o added a datedelimiters attribute to the instance tag in sqlrelay.conf
to limit what date delimiters are used when translating dates
o re-added mssqlserver detection, which had been accidentally removed
o fixed statically-linked build
o fixed mysql lob field bug that could cause a crash
databases/sqlrelay: 0.58.1 -> 0.59
0.59 - updated docs, removed some Cygwin-specific info
added support for login warnings
made bind variable buffers dynamic on the client side
added maxbindvars parameter on the server side
binding a NULL to an integer works with db2 now
moved getting started with DB docs into the cloud
added a semaphore to ensure that the listener doesn't hand off the
client to the connection until the connection is ready,
elimiating a race condition on the handoff socket that could
occur if the connection timed out waiting for the listener
just after the listener had decided to use that connection
oracle temp tables that need to be truncated at the end of the session
are truncated with "truncate table xxx" now rather than
(Only the first 15 lines of the commit message are shown above )
databases/sqlrelay: 0.58 -> 0.58.1
- fixed bugs that could cause sqlr-start with no id to crash and
sqlr-start on an id with neither port nor socket defined to crash
databases/sqlrelay: 0.53.1 -> 0.56, unbreak, take maintainership
- Long list of changes since 0.53.1, see ChangeLog
- unbreak
- many of the options need to be tested and fine-tuned
PR: 193846
Mark BROKEN: Does not build
libtool: compile: c++ -O2 -pipe -fno-strict-aliasing -Wall -pipe
-I/usr/local/include -DDEFAULT_CONFIG_FILE=\"/usr/local/etc/sqlrelay.conf\"
-DCACHE_DIR=\"/var/sqlrelay/cache\" -I./ -I../../ -I../../src/common
-I../../src/util -I/usr/local/include -I/usr/include
-DLIBEXECDIR=\"/usr/local/libexec/sqlrelay\" -c sqlrlistener.cpp -fPIC -DPIC -o
.libs/sqlrlistener.o
sqlrlistener.cpp: In member function 'bool
sqlrlistener::createSharedMemoryAndSemaphores(const char*)':
sqlrlistener.cpp:441: error: no matching function for call to
'sharedmemory::attach(key_t&)'
Reported by: pkg-fallout
- Update devel/rudiments to 0.43 [1]
- Add support for STAGEDIR [1]
- Update databases/sqlrelay to 0.52 (fixes build with new devel/rudiments)
- Remove leading article from COMMENT
- Add support for STAGEDIR
- Remove GTK1 option - no longer available feature
- Rename INTERBASE option to FIREBIRD (globally defined)
- Rename SQLITE2 to SQLITE3 as dependency changed to databases/sqlite3
- Use options substitutions, sort plist
PR: ports/181880 [1]
Submitted by: KATO Tsuguru <tkato432@yahoo.com>
For some unmaintained ports:
- fix format for pkg-descr
- convert to OptionsNG
- remove logic for older versions of python which we no longer support
- remove option for old versions of FreeBSD
- unconditionally set PORTDOCS
- etc.
Reviewed by: jgh
- Mark BROKEN: does not compile
debugfile.C: In member function 'bool debugfile::openDebugFile()':
debugfile.C:50: error: 'umask' was not declared in this scope
Reported by: pointyhat
- Mark BROKEN: does not compile
sqlrlistener.C: In member function 'void sqlrlistener::blockSignals()':
sqlrlistener.C:755: error: 'class rudiments::signalset' has no member named
'getSignalSet'
sqlrlistener.C:758: error: invalid conversion from 'void*' to 'void (*)(int)'
sqlrlistener.C:758: error: initializing argument 1 of 'void
rudiments::signalhandler::setHandler(void (*)(int))'
Reported by: pointyhat
Feature safe: yes
- Add LDFLAGS to CONFIGURE_ENV and MAKE_ENV (as it was done with LDFLAGS)
- Fix all ports that add {CPP,LD}FLAGS to *_ENV to modify flags instead
PR: 157936
Submitted by: myself
Exp-runs by: pav
Approved by: pav
-Repocopy devel/libtool15 -> libtool22 and libltdl15 -> libltdl22.
-Update libtool and libltdl to 2.2.6a.
-Remove devel/libtool15 and devel/libltdl15.
-Fix ports build with libtool22/libltdl22.
-Bump ports that depend on libltdl22 due to shared library version change.
-Explain what to do update in the UPDATING.
It has been tested with GNOME2, XFCE4, KDE3, KDE4 and other many wm/desktop
and applications in the runtime.
With help: marcus and kwm
Pointyhat-exp: a few times by pav
Tested by: pgollucci, "Romain Tartière" <romain@blogreen.org>, and
a few MarcusCom CVS users. Also, I might have missed a few.
Repocopy by: marcus
Approved by: portmgr
Update CONFIGURE_ARGS for how we pass CONFIGURE_TARGET to configure script.
Specifically, newer autoconf (> 2.13) has different semantic of the
configure target. In short, one should use --build=CONFIGURE_TARGET
instead of CONFIGURE_TARGET directly. Otherwise, you will get a warning
and the old semantic may be removed in later autoconf releases.
To workaround this issue, many ports hack the CONFIGURE_TARGET variable
so that it contains the ``--build='' prefix.
To solve this issue, under the fact that some ports still have
configure script generated by the old autoconf, we use runtime detection
in the do-configure target so that the proper argument can be used.
Changes to Mk/*:
- Add runtime detection magic in bsd.port.mk
(Only the first 15 lines of the commit message are shown above )
Mass-conversion to the USE_AUTOTOOLS New World Order. The code present
in bsd.autotools.mk essentially makes this a no-op given that all the
old variables set a USE_AUTOTOOLS_COMPAT variable, which is parsed in
exactly the same way as USE_AUTOTOOLS itself.
Moreover, USE_AUTOTOOLS has already been extensively tested by the GNOME
team -- all GNOME 2.12.x ports use it.
Preliminary documentation can be found at:
http://people.FreeBSD.org/~ade/autotools.txt
which is in the process of being SGMLized before introduction into the
Porters Handbook.
Light blue touch-paper. Run.