databases/sqlrelay: Moved man to share/man

*/*: 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

databases/sqlrelay: update 1.7.0 -> 1.9.3

Changes:
	http://software.firstworks.com/2021/06/sql-relay-193-release.html
	http://software.firstworks.com/2021/09/sql-relay-192-release-announcement.html
	http://software.firstworks.com/2021/06/sql-relay-191-release.html
	http://software.firstworks.com/2021/04/sql-relay-190-release.html
	http://software.firstworks.com/2020/08/sql-relay-180-release-announcement.html

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.

databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>

Remove # $FreeBSD$ from Makefiles.

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.

Also enable on powerpc64le.

Approved by:	portmgr (tier-2 blanket)

databases/py-sqlrelay: unbreak, take maintainer

- databases/sqlrelay uses a very old config.sub which needs to be replaced

devel/rudiments: upgrade 1.1.0 -> 1.2.2
databases/sqlrelay: upgrade 1.4.0 -> 1.7.0

 http://software.firstworks.com/2019/03/rudiments-120-release-announcement.html
 http://software.firstworks.com/2019/08/rudiments-121-release-announcement.html
 http://software.firstworks.com/2020/01/rudiments-122-release-announcement.html
 http://software.firstworks.com/2019/03/sql-relay-150-release-announcement.html
 http://software.firstworks.com/2019/04/sql-relay-151-release-announcement.html
 http://software.firstworks.com/2019/08/sql-relay-160-release-announcement.html
 http://software.firstworks.com/2020/01/sql-relay-170-release-announcement.html

Move remaining USE_MYSQL, WANT_MYSQL_VER to USES=mysql

Update devel/readline to 8.0

- Bump PORTREVISION of dependent ports for shlib change

Changes:	https://tiswww.case.edu/php/chet/readline/CHANGES
PR:		236156
Exp-run by:	antoine

devel/rudiments: upgrade 1.0.7 -> 1.1.0
databases/sqlrelay: upgrade 1.3.0 -> 1.4.0

- dbase="mariadb" works now

 http://software.firstworks.com/2018/09/rudiments-110-release-announcement.html
 http://software.firstworks.com/2018/09/sql-relay-140-release-announcement.html

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.6 -> 1.0.7
databases/sqlrelay: update 1.2.0 -> 1.3.0

 http://software.firstworks.com/2018/05/rudiments-107-release-announcement.html
 http://software.firstworks.com/2018/05/sql-relay-130-release-announcement.html

databases/sqlrelay: update 1.1.0 -> 1.2.0

- The main focus of this release is ODBC improvements.

Relnotes:
http://software.firstworks.com/2017/11/sql-relay-120-release-announcement.html

Remove WANT_GNOME and HAVE_GNOME.

Approved by:	bapt kwm
Sponsored by:	Absolight
Differential Revision:	  https://reviews.freebsd.org/D12643

Update devel/readline to 7.0 patch 3

- Bump PORTREVISION for shlib change

Changes:	https://cnswww.cns.cwru.edu/php/chet/readline/CHANGES
		https://lists.gnu.org/archive/html/bug-bash/2016-09/msg00107.html
		https://lists.gnu.org/archive/html/bug-readline/2017-01/msg00002.html
Differential Revision:	https://reviews.freebsd.org/D11172
PR:		219947
Exp-run by:	antoine

devel/rudiments: update 1.0.4 -> 1.0.5
databases/sqlrelay: update 1.0.1 -> 1.1.0

 http://software.firstworks.com/2017/05/rudiments-105-release-announcement.html
 http://software.firstworks.com/2017/05/sql-relay-110-release-announcement.html

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

Remove ${PORTSDIR} from databases/py-sqlrelay dependencies.

devel/rudiments: update 0.57.0 -> 1.0.2
databases/sqlrelay: update 0.67.0 -> 1.0.0

Recommended reading:
 http://software.firstworks.com/2016/12/benchmarking-sql-relay-100.html

 http://software.firstworks.com/2016/12/rudiments-100-release-announcement.html
 http://software.firstworks.com/2016/12/rudiments-102-release-announcement.html
 http://software.firstworks.com/2016/12/sql-relay.html

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

devel/rudiments: update 0.56.0 -> 0.57.0
databases/sqlrelay: update 0.66.0 -> 0.67.0

http://software.firstworks.com/2016/11/rudiments-0570-release-announcement.html
http://software.firstworks.com/2016/11/sql-relay-0670-release-announcement.html

Use USES=pathfix where applicable.

PR:		213195
Submitted by:	mat
Exp-run by:	antoine
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D8093

devel/rudiments: 0.55.0 -> 0.56.0
databases/sqlrelay: 0.65.0 -> 0.66.0

Changes:	http://software.firstworks.com/2016/09/version-0.html
		http://software.firstworks.com/2016/09/sql-relay-0660-release-announcement.html

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

Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight

devel/rudiments: 0.53 -> 0.54
databases/sqlrelay: 0.63 -> 0.64

Changes rudiments:
http://software.firstworks.com/2015/10/rudiments-054-release-announcement.html

Changes sqlrelay:
http://software.firstworks.com/2015/10/sql-relay-064-release-announcement.html

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

databases/sqlrelay: ignore strip error if file was not build

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

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

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.56 -> 0.58

Changes:
http://software.firstworks.com/2014/10/sql-relay-057-is-out.html
http://software.firstworks.com/2014/12/sql-relay-058-is-out.html

PR:		196366

Finally retire USE_PGSQL

Cleanup plist

Remove some unneeded patches and other bits so USES=autoreconf can be
removed (avoids a problem with upcoming devel/libtool update)

PR:		194068

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

Remove optional dependency on BROKEN and unstaged databases/msql

Remove now useless @cwd

- Chase database/sqlite3 slib bump

Approved by:	portmgr (myself)

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

This port is staged.

devel/rudiments: update to 0.44.1

- Update to 0.44.1 [1]
- Bump dependent ports revision

PR:		ports/184228 [1]
Submitted by:	KATO Tsuguru <tkato432 yahoo.com>

databases/sqlrelay: add oracle option and disable staging

- Add ORACLE option
- Disable staging for now, the port is far from stage ready

databases/sqlrelay: ubreak build

Reported by:	marino

databases/sqlrelay: update to 0.53.1

- Update to 0.53.1
- Unbreak build due to librudiments update

Reported by:	marino

devel/rudiments: update to 0.44

- Update to 0.44
- Add SSL and PCRE options
- Use options helpers
- Allow staging

PR:		ports/183558
Submitted by:	KATO Tsuguru <tkato432 yahoo.com>

Fix make index

- 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>

Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)

Fix error in PORT_OPTIONS conversion.

- Fix build compile errors
- Remove BROKEN

Approved by:	culot / jpaetzel (mentors, implicit)

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

Reassign skv@ ports to the heap

Feature safe:	yes

Convert to new options framework left unconverted ports in databases category

- 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

- Update to 0.44
- unbreak and undeprecate

PR:     ports/166409
Submitted by:   m.tsatsenko@gmail.com
Approved by:    maintainer timeout ( 19 days )

Mark as deprecated and set expiration to 2012-05-10 for ports that are mark as
broken for more than 6 month

- Chase unixODBC shlib bump

- 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

- Track dependencies after databases/gdbm update

- Get Rid MD5 support

Sync to new bsd.autotools.mk

Punt autoconf267->autoconf268

Autotools update.   Read ports/UPDATING 20100915 for details.

Approved by:    portmgr (for Mk/bsd.port.mk part)
Tested by:      Multiple -exp runs

- Update to 0.41
- Add WANT_GNOME [1]
- Be PREFIX-neutral [2]

Changes:
PR:             ports/137491 [1], ports/138912 [1], ports/139472 [2],
Submitted by:   Pavel Gubin <pg xx 2lazy.ru> [1],
                Anatoly Borodin <anatoly.borodin xx gmail.com> [1],
                Sahil Tandon <sahil xx tandon.net> [2]

- Switch SourceForge ports to the new File Release System: categories starting
with D

-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

Fix plist with -DNOPORT*.

Prompted by:    QAT QA run
Approved by:    maintainer timeout on QATMail

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

Conversion from (now defunct) autoconf-2.61 to autoconf-2.62

Tested by:      exp build run (erwin)

- Add sample rc.d script to package

Reported by:    pointyhat

Update to 0.39.4

- Remove unneeded dependency from gtk12/gtk20 [1]
- Remove USE_XLIB/USE_X_PREFIX/USE_XPM in favor of USE_XORG
- Remove X11BASE support in favor of LOCALBASE or PREFIX
- Use USE_LDCONFIG instead of INSTALLS_SHLIB
- Remove unneeded USE_GCC 3.4+

Thanks to all Helpers:
        Dmitry Marakasov, Chess Griffin, beech@, dinoex, rafan, gahr,
        ehaupt, nox, itetcu, flz, pav

PR:             116263
Tested on:      pointyhat
Approved by:    portmgr (pav)

Switch autoconf dependencies from 2.53 or 2.59 to 2.61.

PR:             ports/116639
Submitted by:   aDe

- Chase databases/freetds update: ct.3 -> ct.4, tds.4 -> tds.5
- Bump PORTREVISION where necessary

Fix pkg-plist

Pointed by:     pointyhat (kris)

* update to 0.38
* take maintainership (approved by demon@)

Fix plist.

Approved by:    maintainer (demon)
Pointed by:     pointyhat (kris)

Update to 0.37.1

Approved by:    maintainer (demon)

BROKEN: Does not compile

Remove USE_REINPLACE from all categories starting with D

Conversion to a single libtool environment.

Approved by:    portmgr (kris)

SHA256ify

Approved by:    krion@

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.

Update to version 0.36.4.

Upgrade to version 0.36.2.

- Fix build on 4.11

Reported by:    kris via pointyhat
Approved by:    demon (maintainer)

- Fix after spliting firebird
- Bump PORTREVISION

PR:             ports/79337
Submitted by:   Renato Botelho <freebsd@galle.com.br> (firebird maintainer)

Update to version 0.36.1.

BROKEN: Installs file in /etc

No response from:       maintainer

At Kris's request, back out the MACHINE_ARCH spelling correction until
after 5.4-RELEASE.

- Chase freetds shlib bump

Assist getting more ports working on AMD64 by obeying the
Ports Collection documentation and use 'ARCH' rather than 'MACHINE_ARCH'.