devel/boost: bump consu,ers after update Boost to 1.86 release

Sponsored by:	Future Crew, LLC

*/*: bump consumers after devel/boost* update

With hat:	office
Sponsored by:	Future Crew, LLC

devel/boost: bump consumers after library update

*/*: Bump PORTREVISION. databases/firebird30-client was update to 3.0.11

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

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

devel/boost*: bump all consumers after 1.83.0

*/*: bump all direct Boost cunsumers

databases/soci: fix build with libc++ 15

During an exp-run for llvm 15 (see bug 265425), it turned out that
databases/soci failed to build with clang 15:

  In file included from
/wrkdirs/usr/ports/databases/soci/work/soci-4.0.3/tests/empty/test-empty.cpp:8:
  In file included from
/wrkdirs/usr/ports/databases/soci/work/soci-4.0.3/include/soci/soci.h:12:
  In file included from
/wrkdirs/usr/ports/databases/soci/work/soci-4.0.3/include/soci/soci-platform.h:18:
  In file included from /usr/include/c++/v1/string:551:
  In file included from /usr/include/c++/v1/string_view:222:
  In file included from /usr/include/c++/v1/algorithm:1851:
  In file included from /usr/include/c++/v1/__algorithm/ranges_sample.h:13:
  In file included from /usr/include/c++/v1/__algorithm/sample.h:18:
  /usr/include/c++/v1/__random/uniform_int_distribution.h:235:5: error: static
assertion failed due to requirement
'__libcpp_random_is_valid_urng<Catch::RandomNumberGenerator, void>::value':
      static_assert(__libcpp_random_is_valid_urng<_URNG>::value, "");

*/*:	bump libboost*.so libraries consumert after Boost upgrade

databases: bump more direct firebird consumers

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.

*/*: bump all consumers after recent boost upgrade

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>

databases/soci: Fix pkg-plist errors

PR:		264720
Reported by:	p5B2EA84B3@t-online.de
Approved by:	nc@ (maintainer)

databases/soci: Fix packaging errors on no ODBC

PR:		264537
Reported by:	Stéphane D'Alu <sdalu@sdalu.com>

devel/boost-all: bump all library consumers after boost upgrade

PR:	246106

databases/soci: disable FIREBIRD also on riscv64

databases/soci: restore FIREBIRD PLIST_SUB to fix build on non-x86

databases/soci: Adopt port

databases/soci: Update to 4.0.3

databases/firebird25-*: Bump PORTREVISION of dependant ports

Remove # $FreeBSD$ from Makefiles.

Maintainer reset for jlaffaye

Reason: Many bug reports (including bug#253256) related to jlaffaye's ports
timed out in the period from April 2020 to now.

PR:		253256
Approved by:	jlaffaye (maintainer's timeout 14 days)

databases/soci: 3.2.2 -> 4.0.1

PR:		252784
Approved by:	jlaffaye (maintainer's timeout 18 days)

Allow building on powerpc64le.

Approved by:	portmgr (tier-2 blanket)

Partially revert r530801

The maintainer reset rule was not applied correctly. jlaffaye's ports
are reassigned back to him, with the exception of lang/go where both
quantity and length of timeouts made the reset appropriate and
necessary.

With hat:	portmgr

Reset maintainer for ports maintaned by jlaffaye@.

As per policy, based on timeouts on
* www/py-scgi: bug#244982
* textproc/discount: bug#244981
* devel/py-python-gflags: bug#244965
* lang/go: bug#244783, https://reviews.freebsd.org/D24122
* news/py-yenc: bug#239309
* irc/libircclient: bug#221567

devel/boost-*: update to 1.72.0

Changes:	http://www.boost.org/users/history/version_1_72_0.html
PR:		241449
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D22136

Move remaining USE_MYSQL, WANT_MYSQL_VER to USES=mysql

devel/boost-*: update to 1.71.0

Changes:	http://www.boost.org/users/history/version_1_71_0.html
PR:		238827
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D20774

Convert to UCL & cleanup pkg-message (categories d)

Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330

databases/soci: fix build with GCC-based architectures

Add USES=compiler:c++11-lang to fix linking issue against libmysqlclient.so:
/usr/local/lib/mysql/libmysqlclient.so: undefined reference to
`std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char>
>::_M_create(unsigned long&, unsigned long)@GLIBCXX_3.4.21'

Approved by:	mentors (implicit approval)

devel/boost-*: update to 1.70.0

Changes:	http://www.boost.org/users/history/version_1_70_0.html
PR:		235956
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D19303

Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590

devel/boost-*: update to 1.69.0

Changes:	http://www.boost.org/users/history/version_1_69_0.html
PR:		232525
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D17645

devel/boost-*: update to 1.68.0

- Switch to C++14 for libboost_system to support C++14 consumers

Changes:	http://www.boost.org/users/history/version_1_68_0.html
PR:		229569
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D16165

For ports in `databases' category: remove redundant PKGMESSAGE assignment,
which is set appropriately by the b.p.m when `pkg-message' appears on the
SUB_FILES list.

- Bump PORTREVISION. databases/firebird25-* ports were updated

devel/boost-*: update to 1.67.0

Changes:	http://www.boost.org/users/history/version_1_67_0.html
PR:		227427
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D15030

Pre-emptively fix databases/soci for CMake 3.11.

With CMake 3.11, configure fails with this error:

  CMake Error: The following variables are used in this project, but they are
set to NOTFOUND.
  Please set them or make sure they are set and tested correctly in the CMake
files:
  MYSQL_EMBEDDED_LIBRARIES
      linked by target "cmTC_ec547" in directory
/wrkdirs/usr/ports/databases/soci/work/soci-3.2.2/CMakeFiles/CMakeTmp

  CMake Error at /usr/local/share/cmake/Modules/CheckIncludeFile.cmake:60
(try_compile):
    Failed to configure test project build system.
  Call Stack (most recent call first):
    /usr/local/share/cmake/Modules/FindThreads.cmake:121 (CHECK_INCLUDE_FILE)
    core/CMakeLists.txt:17 (include)

The underlying issue is that the test for MySQL embedded leaks the
library into CMAKE_REQUIRED_LIBRARIES, which are then picked up in
other feature tests. If the library wasn't found (which is normal,
it's not a dependency in the port) then those later tests fail.
CMake 3.11 is somehow stricter about this than CMake 3.10.

No PORTREVISION bump because it's a pre-emptive build fix and nothing
changes on the port.

Approved by:	tcberner (mentor, implicit)

devel/boost-*: update to 1.66.0

Changes:	http://www.boost.org/users/history/version_1_66_0.html
PR:		223922
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D13279

Fix build of databases/soci w/ clang 4.0 and later and on arm6, arm7.
Adds upstream patch to fix

backends/mysql/session.cpp:202:22: error: ordered comparison between pointer and
zero ('int *' and 'int')
            if (port < 0)

PR:		222651 216074
Reported by:	jbeich, Neel Chauhan
Reviewed by:	jlaffaye
Approved by:	tcberner (mentor)
Obtained from:	upstream
Differential Revision:	https://reviews.freebsd.org/D13769

Switch databases/soci to <opt>_CMAKE_BOOL.

This simplifies the Makefile somewhat -- it is only a cosmetic change.
While here, massage COMMENT to satisfy portlint.

PR:		224422
Reviewed by:	jlaffaye (maintainer)
Approved by:	rakuco (mentor)
Differential Revision:	https://reviews.freebsd.org/D12957

Mark more ports broken that fail on both armv6 and armv7.

Approved by:	portmgr (tier-2 blanket)

Bump PORTREVISION, which I should have done in r453379 when I changed
the options. As mat@ pointed out, that must be done also when
non-default options are changed.

See also https://reviews.freebsd.org/D12919

Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D12941

{opt}_CMAKE_ARGS_ON isn't a valid syntax. Use {opt}_CMAKE_ON instead.
This makes the soci port obey the FIREBIRD option (otherwise it always
looks for Firebird, even when you don't want it to).

Submitted by yuri@ in PR 209530, maintainer timeout (17 months).

PR:		209530
Submitted by:	yuri@FreeBSD.org
Reviewed by:	yuri (submitter)
Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D12919

For ports that are explicitly enabled on armv6, also enable them
on armv7.  This has not been tested with an -exp run but should
"do no harm".

PR:		221894 (partial)

devel/boost-*: update to 1.65.1

Changes:	http://www.boost.org/users/history/version_1_65_1.html
PR:		218835
Approved by:	maintainer timeout (1.65.1: 2 weeks; 1.65.0: 1 month)
Tested by:	jhibbits (on powerpc64, earlier version)
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D11582

devel/boost-*: enable C++11 features

PR:		218835
Obtained from:	https://github.com/DragonFlyBSD/DeltaPorts/pull/690
Approved by:	maintainer timeout (2 months)
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D11582

Disable dependency on firebird for tier-2 archs.  There is work underway
to fix firebird on those archs but it is not complete.

This unbreaks several dozen ports on tier-2.

PR:		216943
Submitted by:	linimon
Reviewed by:	mat (only this file)

devel/boost-*: update to 1.64.0

Changes:	http://www.boost.org/users/history/version_1_64_0.html
PR:		218835
Approved by:	office (bapt)
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D10472

devel/boost-*: update to 1.63.0

Changes:	http://www.boost.org/users/history/version_1_63_0.html
PR:		215598
Exp-run by:	antoine
Approved by:	office (bapt)
MFH:		2017Q1

devel/boost-*: update to 1.62.0

- Enable `long double` C99 math usage
- Switch 9.x back to building with GCC

Changes:	http://www.boost.org/users/history/
PR:		199601
Submitted by:	Chen Xu, bapt, amdmi3, truckman (based on)
Reviewed by:	rakuco (kde) (earlier version)
Exp-run by:	antoine (3 tries), truckman (consumers only, earlier versions)
Approved by:	bapt (office)

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

Remove USE_SQLITE from bsd.databases.mk, replaced by USES=sqlite.

While there replace USE_SQLITE=x by USES=sqlite:x.

PR:		208971
Submitted by:	mat
Exp-run by:	antoine
With hat:	portmgr
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D5951

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

With hat:	portmgr
Sponsored by:	Absolight

MASTER_SITES cleanup.

- Replace ${MASTER_SITE_FOO} with FOO.
- Merge MASTER_SITE_SUBDIR into MASTER_SITES when possible. (This means 99.9%
  of the time.)
- Remove occurrences of MASTER_SITE_LOCAL when no subdirectory was present and
  no hint of what it should be was present.
- Fix some logic.
- And generally, make things more simple and easy to understand.

While there, add magic values to the FESTIVAL, GENTOO, GIMP, GNUPG, QT and
SAMBA macros.

Also, replace some EXTRACT_SUFX occurences with USES=tar:*.

Checked by:	make fetch-urlall-list
With hat:	portmgr
Sponsored by:	Absolight

Cleanup plist

Bump more ports that depend on libsqlite3.so:
- ports that set USE_SQLITE with the *_USE option helper
- ports that depend on libsqlite3 indirectly as reported by pkg rquery

Approved by:	portmgr (implicit)

Fix unixODBC vs libiodbc conflicts

Always rely on unixODBC each time a port is looking for libodbc.so
Remove odbc compat from libiodbc
This allows to install both kde and gnome at the same time

While here:
- Convert libiodbc to USES=libtool
- Convert a bunch of libiodbc dependencies to USES=libtool
- Chase libiodbc.so shlib change
- Stagify some ports
- Convert some ports to USES=pgsql

Discussed with:	rakuco (kde)
With hat:	portmgr

Convert d* to USES=zip

Chase boost and icu bump
While here convert some LIB_DEPENDS

In preparation for making libtool generate libraries with a sane name, fix all
LIB_DEPENDS in databases

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

- Remove MAKE_JOBS_SAFE variable

Approved by:	portmgr (bdrewery)

- convert USE_CMAKE to USES
- while here clean up some ports from CMAKE_VERBOSE, which is intended
  for users

Approved by:	portmgr (miwi)

- Update to 3.1.0

PR:             ports/175735
Submitted by:   avg

Convert jlaffayes's ports to new options framework

Approved by:	jlaffaye

Update my e-mail to my FreeBSD one.
While I am here, use GOOGLE_CODE instead of ${MASTER_SITE_GOOGLE_CODE}

Approved by:    bapt (mentor)

- Get Rid MD5 support

Bump PORTREVISION for ports linking to default libmysqlclient.

Remove duplicated category 'databases' to quiet a complaint on pointyhat.
(Apparently the original PR had 'devel databases'.)

Hat:            portmgr

SOCI is a database access library for C++ that makes the illusion of embedding
SQL queries in the regular C++ code, staying entirely within the Standard C++.
The idea is to provide C++ programmers a way to access SQL databases in the most
natural and intuitive way. If you find existing libraries too difficult for your
needs or just distracting, SOCI can be a good alternative.

WWW:    http://soci.sourceforge.net/

PR:             ports/150527
Submitted by:   Julien Laffaye <kimelto at gmail.com>