databases/mysql80-server: fix build of client on powerpc

On powerpc, clang miscompiles comp_err, which later fails at runtime with:
->  0x102ff48c <+16>: .long  0x0006ee74                ; unknown opcode
The problem happens because of line:
frame #0: 0x10323eb4 comp_err`set_my_errno(my_errno=-10608) at
my_thr_init.cc:344:47

GCC can compile client, but without -malign-double. It also needs to link to
libatomic (so building without GCC installed wouldn't work anyway).

This only fixes client. Server still fails to build because of:
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.32/storage/innobase/include/log0sys.h:190:60:
error: static assertion failed
  190 |  
static_assert(decltype(write_to_file_requests_interval)::is_always_lock_free);

databases/mysql80-*: Update to latest release 8.0.32

Bugs Fixed

    Important Change: The implementation of the max_join_size system variable,
although documented as a maximum number of rows or disk seeks, did not check the
number of rows or disk seeks directly, but instead treated max_join_size as the
maximum estimated cost to permit. While cost and row count are correlated, they
are not the same, and this could lead to unexpected results when some large
queries were allowed to proceed.

    In this release, we change how max_join_size is used, so that it now
actually limits the maximum number of row accesses in base tables. If the
estimate indicates that a greater number of rows must be read from the base
tables, an error is raised. This makes the actual behavior better reflect what
is documented. (Bug #83885, Bug #25118903)

    InnoDB: Undetectable problems after upgrade from 8.0.28, crash and
corruption.

    Any new row inserted after upgrade will have all columns added with
ALGORITHM=INSTANT materialized and have version=0.

    In the new implementation, a column added with ALGORITHM=INSTANT will fail
if the maximum possible size of a row exceeds the row size limit. So new rows
with materialized ALGORITHM=INSTANT columns will always be within row size
limit. (Bug #34558510)

    InnoDB: No more garbled UTF characters in SHOW ENGINE INNODB STATUS

databases/mysql80-server: Fix build with LLVM15

This Patch fix an LLVM15 Problem on CURRENT

PR:	269442
Reported by:	madpilot
Sponsored by:	Netzkommune GmbH

databases/mysql80-*: Unbreak on i386

Fix a issue with i386:
--yplg_out: protoc-gen-yplg: Plugin killed by signal 11.
*** Error code 1

PR: 269203
Sponsored by: Netzkommmune GmbH

databases/mysql80-server: Fix build with libressl

PR:			267672
Approved by:		joneum (maintainer), tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D37673

databases/mysql*-{client, server}: Remove NDEBUG

As of 3c5189a0fd4c82addfb659024bf28c5006bf88f7 there shouldn't be a need
to define NDEBUG by hand when using CMake.

Reported by:	dizzy
Sponsored by:	Netzkommune GmbH

databases/mysql80-server: fix build on armv7

PR:	267422
Sponsored by:	Netzkommune GmbH

databases/mysql80-server: Update my.cnf.sample

Update deprecated configs in my.cnf.sample

Some configs in my.cnf.sample are now deprecated. These should be replaced with
their replacement, or removed if there is no replacement.

- Replace deprecated slave-load-tmpdir with replica-load-tmpdir
- Remove deprecated master-info-repository (it was set to the default)
- Remove deprecated relay-log-info-repository (it was set to the default)
- Replace deprecated expire_logs_days with binlog_expire_logs_seconds (multiply
30 days by 24 * 60 * 60)
- Replace deprecated innodb_log_file_size with innodb_redo_log_capacity
(preserving the same configured capacity, which was set to 256M * 2 log files)
- Remove deprecated skip-symbolic-links (it is the default)

PR:	266511
Sponsored by:	Netzkommune GmbH

databases/mysql80-*: Update to latest release 8.0.31

Bugs Fixed

    Incompatible Change: The service pfs_plugin_table, deprecated since MySQL
8.0.14, is removed in this release.

    Plugins or components using this service must be updated to use
pfs_plugin_table_v1 and pfs_plugin_column_* instead. (Bug #34361827)

    Important Change; Replication: Query log events filtered by the default
database whenever --replicate-do-db or --replicate-ignore-db was used included
XA START, XA END, XA COMMIT, and XA ROLLBACK (but not XA PREPARE or XA COMMIT
ONE_PHASE), regardless of the binary log format.

    This can lead to one of the issues listed here:

        When XA START or XA END was filtered out, the sequence of XA statements
within the first part of the transaction were rendered invalid, which made the
replica stop with an error.

        When XA START and XA END were preserved while XA COMMIT or XA ROLLBACK
was filtered out, then a transaction could remain in the prepared state
indefinitely on the replica.

databases/and_others: Fix rc.d script comment

I found this typo while researching something else. It seems to have
propgated around the tree.

Approved by:	blanket

devel/icu: update to 72.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-72-1
Reported by:	GitHub (watch releases)
PR:		266582
Exp-run by:	antoine

devel/protobuf: Update to 3.21.7

- Bump PORTREVISION of dependent ports for shlib change

Changes:	https://github.com/protocolbuffers/protobuf/releases

databases/mysql80-*: Update to latest release 8.0.30

PR:	265468

Bugs Fixed:
- InnoDB: A TRUNCATE TABLE operation failed to remove data dictionary entries
for columns that were dropped using ALGORITHM=INSTANT.
- InnoDB: An incorrect nullable column calculation on tables with instantly
added columns caused data to be interpreted incorrectly
- InnoDB: The read_2_bytes() function in the InnoDB sources, which reads bytes
from the log buffer, returned a null pointer.
- Replication: The COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE column in the
Performance Schema table replication_group_member_stats could persistently show
transactions related to view change events (View_change_log_event) that had
already been applied. These events are queued in the Group Replication applier
channel but applied in the Group Replication recovery channel, causing a race
condition that could result in the counter decrement being lost. The increment
of the count now takes place at a more suitable point, and the counter for
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE is also now set to zero when the
applier is not busy.
- Debug MySQL binaries can now be built using -0g and -fno-inline.

See full Changelog here:
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-30.html

Sponsored by:	Netzkommune GmbH

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>

databases/mysql*: fix pkg-plist use share/man

Approved by:	portmgr (blanket)

databases/mysql80-server: Mark als BROKEN on i386 after
10d211b655d85e31bf9b8e27d234f526cfd1e49b

cd
/wrkdirs/usr/ports/databases/mysql80-server/work/.build/plugin/x/protocol/plugin
&& /usr/local/bin/protoc
--plugin=protoc-gen-yplg=/wrkdirs/usr/ports/databases/mysql80-server/work/.build/runtime_output_directory/xprotocol_plugin
--yplg_out
/wrkdirs/usr/ports/databases/mysql80-server/work/.build/plugin/x/generated -I
/usr/local/include -I
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_connection.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_crud.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_cursor.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_datatypes.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_expect.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_expr.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_notice.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_prepare.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_resultset.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_session.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_sql.proto
--yplg_out: protoc-gen-yplg: Plugin killed by signal 11.
*** Error code 1

A solution is being worked on

Sponsored by:	Netzkommune GmbH

databases/mysql80-{client, server}: Update to latest release 8.0.29

Bugs Fixed

    InnoDB: A failure occurred when attempting to purge undo records for a table
with an instantly added column. (Bug #33924532)

    InnoDB: High-priority transactions were not permitted to stop waiting when
interrupted or to timeout while waiting for a lock, preventing deadlocks from
being resolved. In cases where the blocking transaction is also high-priority,
high-priority transactions are now permitted to stop waiting when interrupted or
timeout when exceeding the lock wait timeout period. If a blocking transaction
is not high-priority, high-priority transactions wait for the blocking
transaction to release its locks. (Bug #33856332)

    InnoDB: The AIO synchronization queue used on Windows was removed. The
synchronous file I/O read-write function (SyncFileIO::execute) was revised to
handle files opened for both normal and overlapped I/O, as it does on Linux.
(Bug #33840645)

    InnoDB: Table version metadata was not reset after truncating all partitions
of a table with an instantly added column. (Bug #33822729)

    InnoDB: The srv_error_monitor_thread() function, which prints warnings about
semaphore waits, failed to handle a long semaphore wait as expected. To address
this issue, a blocking call was moved to a more appropriate location. Related
monitor thread code was simplified and improved, and missing shutdown signals
were added for several server threads.

    Enabling and disabling of the standard monitor by InnoDB is now performed
independently of the user-settable innodb_status_output variable. This change
addresses an issue in which the monitor was enabled by InnoDB in a particular
scenario but not set back to its previous value. Thanks to Yuhui Wang for the
contribution. (Bug #33789526, Bug #93878)

devel/protobuf: Update to 3.20.0

- Bump PORTREVISION of dependent ports for shlib change

Changes:	https://github.com/protocolbuffers/protobuf/releases

databases/mysql80-server: restore indentation after 268cee3b0227

PR:		262654

devel/icu: update to 71.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-71-1
Reported by:	GitHub (watch releases)
PR:		262654
Exp-run by:	antoine
Approved by:	fluffy

databases/mysql80-*: Fix build with LibreSSL

PR:	261164
Sponsored by:	Netzkommune GmbH

devel/protobuf: Update to 3.19.4

- Bump PORTREVISION of dependent ports for shlib change

Changes:	https://github.com/protocolbuffers/protobuf/releases

databases/mysql80-server: Fix build on aarch64

  - Replace getauxval with the FreeBSD variant (elf_aux_info)
  - ifdef some gcc'ism and pass the correct cflags for clang

Approved by:	portmgr (build fix blanket)
PR:		261660

databases/mysql80-server: bring back mysql_secure_installation (+)

Typo in patchfile leads to skip mysql_secure_installation.
Bring it back.

PR:		262123
Submitted by:	amdmi3
Approved by:	joneum (implicit)

databases/mysql80-server: Fix typo

Sponsored by:	Netzkommune GmbH

databases/mysql80-*: Update to 8.0.28

Changelog: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-28.html

Sponsored by:	Netzkommune GmbH

Fix CONFLICTS entries of multiple ports

There have been lots of missing CONFLICTS_INSTALL entries, either
because conflicting ports were added without updating existing ports,
due to name changes of generated packages, due to mis-understanding
the format and semantics of the conflicts entries, or just due to
typoes in package names.

This patch is the result of a comparison of all files contained in
the official packages with each other. This comparison was based on
packages built with default options and may therefore have missed
further conflicts with optionally installed files.

Where possible, version numbers in conflicts entries have been
generalized, some times taking advantage of the fact that a port

databases/mysql80-server: add patch for malloc-lib

forked from mysql57-server: https://svnweb.freebsd.org/changeset/ports/548590
Log:
  MySQL 5.7 mysqld_safe allows malloc-lib files only in certain locations.
  google-perftools port puts libtcmalloc_minimal.so inside /usr/local/lib
  To use tcmalloc memory allocator we need mysqld_safe to load libraries from
/usr/local/lib

  More information about why to use tcmalloc instead of jemalloc here:

 
https://forums.freebsd.org/threads/freebsd-12-x-and-mysql-5-7-and-importing-file-with-lots-of-small-lines-exhaust-ram-and-swap.72733/

PR:	259816
Sponsored by:	Netzkommune GmbH

*/*: 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/mysql80-*: Update to 8.0.27

Release Notes: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-27.html

Sponsored by:	Netzkommune GmbH

devel/icu: update to 70.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-70-1
Reported by:	GitHub (watch releases)
PR:		258794
Exp-run by:	antoine

cleanup: drop support for EOL FreeBSD 11.X

Search criteria used:
- 11.4
- OSREL*
- OSVER*
- *_FreeBSD_11

Input from:
- adridg: devel/qca-legacy
- jbeich: _WITH_DPRINTF, _WITH_GETLINE, GNU bfd workarounds
- sunpoet: security/p5-*OpenSSL*

Reviewed by:	doceng, kde, multimedia, perl, python, ruby, rust
Differential Revision: https://reviews.freebsd.org/D32008
Test Plan: make index

databases/mysql80-server: Fix CPE information

Approved by:	portmgr (blanket)

databases/mysql80-*: update to 8.0.26

Release notes: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-26.html

Sponsored by:	Netzkommune GmbH

devel/protobuf: Update to 3.17.3

- Bump PORTREVISION of dependent ports for shlib change

Changes:	https://github.com/protocolbuffers/protobuf/releases
PR:		257026
Exp-run by:	antoine

databases/mysql80-server: use libunwind on armv7 now that it works

databases/mysql80-*: update to 8.0.25 GA release

Release notes:	https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-25.html
		https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-24.html

PR:		255937
Submitted by:	delphij@
Approved by	joneum@ (implicit)
MFH:		2021Q2

devel/icu: update to 69.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-69-1
Reported by:	GitHub (watch releases)

all: Remove all other $FreeBSD keywords.

Remove # $FreeBSD$ from Makefiles.

databases/mysql80-server: regen patch-client_CMakeLists.txt

PR:		253198

mysql80-server:	adjust router/harness_tls building

databases/mysql80-server:	Fix patches after rename

Pointy hat to:	fluffy

databases/mysql80*: update to 8.0.23

Disable detect of TLSv1.3 functions - it's broken with LibreSSL

Release Notes:	https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-23.html
Requested by:	joneum

Bump PORTREVISION for devel/protobuf shlib change

Fix a silly typo in the comment.

databases/mysql80-server: fix build on GCC architectures

Include sys/types.h to make u_int32_t available:
/usr/include/netinet/ip6.h:77:4: error: 'u_int32_t' does not name a type; did
you mean 'uint32_t'?

MFH:		2020Q4 (fix build blanket)

devel/icu: update to 68.1

Changes:	http://site.icu-project.org/download/68
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
Reported by:	GitHub (watch releases)

databases/mysql80-{client, server}: Update to latest release 8.0.22

Full Changelog: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-22.html

MFH:		2020Q4
Security:	4fba07ca-13aa-11eb-b31e-d4c9ef517024
Sponsored by:	Netzkommune GmbH

Fix pkg-messages

PR:		250340
Submitted by:	0mp
Sponsored by:	Netzkommune GmbH

Canonicalize *_DEPENDS for powerpc64le the same way as for powerpc64.

While here, include a change that I have had in my tree for some time, to
turn a .error message into IGNORE= as per the Porter's Handbook.

Approved by:	portmgr (tier-2 blanket)

databases/mysql80-server: add devel/libunwind to dependencies on powerpc64

Now that it works on powerpc64, add it and bump PORTREVISION.

fix build on current
- add temporary work around to use llvm from ports on recent currents

MFH:	2020Q3
Sponsored by:	Netzkommune GmbH

Bump PORTREVISION for devel/protobuf shlib change

databases/mysql80-{client, server}: Update to latest release 8.0.21

Full Changelog: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-21.html

Submitted by:	fluffy
MFH:		2020Q3
Security:	0ed71663-c369-11ea-b53c-d4c9ef517024
Sponsored by:	Netzkommune GmbH

Bump PORTREVISION for devel/protobuf shlib change

databases/mysql80-{client, server}: Update to latest release 8.0.20

- Performance: Certain queries against tables with spatial indexes were not
performed as efficiently following an upgrade from MySQL 5.7 to MySQL 8.0.
- NDB Cluster: NDB defines one SPJ worker per node owning a primary partition of
the root table. If this table used read from any replica, DBTC put all SPJ
workers in the same DBSPJ instance, which effe
- NDB Cluster: Executing the SHOW command using an ndb_mgm client binary from
NDB 8.0.16 or earlier to access a management node running NDB 8.0.17 or later
produced the error message Unknown field: is_s
- On EL7 and EL8, CMake configuration was adjusted to look for GCC 9 before GCC
8. Because libmysqlclient ships with MySQL distributions, client applications
built against libmysqlclient on those platfo
- The max_length_for_sort_data system variable is now deprecated due to
optimizer changes that make it obsolete and of no effect.

More Infos: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-20.html

Special thanks to: fluffy

MFH:		2020Q2
Security:	21d59ea3-8559-11ea-a5e2-d4c9ef517024 (MySQL - Server)
Security:       622b5c47-855b-11ea-a5e2-d4c9ef517024 (MySQL - Client)
Sponsored by:	Netzkommune GmbH

devel/icu: update to 67.1

Changes:	http://site.icu-project.org/download/67
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
Reported by:	GitHub (watch releases)

Fix up PORTREVISION style after "portedit bump-revision"

devel/icu: update to 66.1

Changes:	http://site.icu-project.org/download/66
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/

Update pkg-message

As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously
handled by mysql_upgrade. Consequently, mysql_upgrade is unneeded and is
deprecated as of that version, and will be removed in a future MySQL version.
Because mysql_upgrade no longer performs upgrade tasks, it exits with status 0
unconditionally.

Sponsored by:	Netzkommune GmbH

Some manpages require groff, for example mysqladmin

Sponsored by:	Netzkommune GmbH

Fix build on non-x86 and nun-aarch6

PR:		244073
Submitted by:	pkubaj
MFH:		2020Q1
Sponsored by:	Netzkommune GmbH

Take Maintainership

Approved by:	mmokhi (maintainer via private Mail)

Bump PORTREVISION for devel/protobuf shlib change

databases/mysql80-{client, server}: Update to latest release 8.0.19

- New FPROFILE_GENERATE and FPROFILE_USE CMake options are available for
experimenting with profile guided optimization (PGO) with GCC. See the
cmake/fprofile.cmake in a MySQL source distribution for information about using
them. These options have been tested with GCC 8 and 9, and with Clang.
- Enabling FPROFILE_USE also enables WITH_LTO (link time optimization).
- Innodb_system_rows_read, Innodb_system_rows_inserted,
Innodb_system_rows_deleted status variables were added for counting row
operations on InnoDB tables that belong to system-created schemas. The new
status variables are similar to the existing Innodb_rows_read,
Innodb_rows_inserted, Innodb_rows_deleted status variables, which count
operations on InnoDB tables that belong to both user-created and system-created
schemas.
- The new status variables are useful in replication environments where
relay_log_info_repository and master_info_repository variables are set to TABLE,
resulting in higher row operation counts on slaves due to operations performed
on the slave_master_info, slave_replay_log_info, and slave_worker_info tables,
which belong to the system-created mysql schema. For a valid comparison of
master and slave row operation counts, operations on tables in system-created
schemas can now be excluded using the count data provided by the new status
variables.

More infos: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-19.html

Submitted by:	fluffy
Approved by:	mmokhi (maintainer, implicit)
Sponsored by:	Netzkommune GmbH

databases/mysql80-{client, server}: Update to latest release 8.0.18

switch patch-files to mysql80-server to make it easy for maintain.

Bugfix:
- CMake now enables use of fastcov if it is available. fastcov is faster than
lcov or gcov. This requires GCC and gcov versions of 9 or higher.
- The DISABLE_SHARED CMake option was unused and has been removed.
- The CMake code to find Protobuf executables now works on platforms that split
these into multiple packages.
- The new ADD_GDB_INDEX CMake option determines whether to enable generation of
a .gdb_index section in binaries, which makes loading them in a debugger faster.
The option is disabled by default. It has no effect if a linker other than lld
or GNU gold is used.
- For the INSTALL_LAYOUT CMake option, the SLES and WIN option values were not
used and have been removed.
- The max_prepared_stmt_count system variable maximum value has been increased
from 1 million (1,048,576) to 4 million (4,194,304). The default value remains
unchanged at 16,382.
- MySQL 8.0 no longer supports building using wolfSSL. All MySQL builds now use
OpenSSL.
- The RE2 library is no longer used by MySQL. The library is no longer bundled
with source distributions and the WITH_RE2 CMake option is obsolete.

More Infos: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-18.html

A big thanks to @fluffy for his help with this update

MFH:		2020Q1
Security:	fc91f2ef-fd7b-11e9-a1c7-b499baebfeaf
Sponsored by:	Netzkommune GmbH

Get rid of useless and unfilled
libdata/pkgconfig/LIBMYSQL_OS_OUTPUT_NAME-NOTFOUND.pc
for server bundle, right .pc file is already installed by client package

PR:		242488
Reported by:	fluffy
Approved by:	mmokhi (maintainer, implicit)
Sponsored by:	Netzkommune GmbH

Drop the ipv6 virtual category for d* category as it is not relevant anymore

devel/icu: update to 65.1

Changes:	http://site.icu-project.org/download/65
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/

databases/mysql80-{client, server}: Update to latest release 8.0.17
This update includes security fixes on issues that are
mentioned on upstream critical patch report.
Further info:
https://www.oracle.com/technetwork/security-advisory/cpujul2019-5072835.html#AppendixMSQL

Delete upstream-merged patches
Change other local-patches according upstream changes

PR:		239272
Reported by:	Markus Kohlmeyer <rootservice@gmail.com>
Sponsored by:	EuroBSDCon 2019 DevSummit

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

devel/libevent2: update to 2.1.11

Changes:	https://github.com/libevent/libevent/releases/tag/release-2.1.11-stable
ABI:		https://abi-laboratory.pro/tracker/timeline/libevent/
PR:		239599
Reported by:	GitHub (watch releases)
Approved by:	zeising (maintainer)
MFH:		2019Q3 (maybe security, partially restores 2.1.8 ABI)
Differential Revision:	https://reviews.freebsd.org/D21133

Bump PORTREVISION for devel/protobuf shlib change

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

Update devel/protobuf to 3.8.0

- Bump PORTREVISION of dependent ports for shlib change

Changes:	https://github.com/protocolbuffers/protobuf/releases
PR:		238808
Exp-run by:	antoine

databases/mysql80-{client, server}: Update to latest release 8.0.16

This update includes:
Bugfixes:
- InnoDB: Undo tablespaces remained unencrypted after enabling
    undo tablespace encryption at startup. (Bug #29477795)
- InnoDB: Problematic macros introduced with undo tablespace DDL support
    (Bug #29324132, Bug #94243).
- InnoDB: Static thread local variables defined at the wrong scope
    were not released at thread exit. (Bug #29305186)
-  Memory leaks discovered in the innochecksum  (Bug #28917614, Bug #93164).

New features:
- MySQL C API now supports asynchronous functions for
    nonblocking communication with the MySQL server.

Update devel/protobuf to 3.7.1

- Bump PORTREVISION of dependent ports for shlib change

Changes:	https://github.com/protocolbuffers/protobuf/releases
PR:		236157
Exp-run by:	antoine

devel/icu: update to 64.1

Changes:	http://site.icu-project.org/download/64
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
PR:		236325
Exp-run by:	antoine
Differential Revision:	https://reviews.freebsd.org/D19479

databases/mysql80-{client, server}: Update to new release 8.0.15
This is a quick release after 8.0.14 which fixes Bug #29249542, Bug #94004
on upstream (Group repl. doesn't work when IPv6 is disabled on OS)
More info on upstream:
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-15.html

While here, delete the no-more-needed warning from "pkg-message" since MySQL8.0
is GA.

Sponsored by:	The FreeBSD Foundation

databases/mysql80-{client, server}: Update to latest release 8.0.14
This update (released on Jan 21st) includes:
Bugs Fixed:
  Important Change: Fix importing a dump from a MySQL 5.7 server 8.0 failure.
    (ER_WRONG_VALUE_FOR_VAR, when an unsupported [by 8.0] SQL mode was used).
    The behavior of the server in such circumstances now depends on the setting
of the
    `pseudo_slave_mode` system variable.
    If this is false, the server rejects the mode setting with
ER_UNSUPPORTED_SQL_MODE.
    Otherwise, server just gives a warning. (Bug #90337, Bug #27828236).

  InnoDB: Properly initialize the static thread-local 'tables' variable in
    the TempTable storage engine (on Solaris X86) was not properly initialized.
    (Bug #28987365)

  InnoDB: Fix incorrect lock order caused a deadlock when one thread attempted
to
    drop a table while another created an encrypted tablespace. (Bug #28774259)

More info from upstream:
  https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-14.html

While here, Adapt some local patches with new upstream changes.

PR:		234984
Sponsored by:	The FreeBSD Foundation

databases/mysql80-{client, server}: Update ports to latest version 8.0.13
This update fixes several issues including CVEs.
Bug-fixes:
	- Return better error messages for OpenSSL errors
	- Incorrect copying of an integer value by X Plugin caused an
	    error relating to misaligned memory access
Improvement:
	- Important Change: X Protocol now provides a connection pooling option

Upstream notes: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-13

While here, fix the build with GCC-based architectures too (ported from fix on
MySQL57)

Sponsored by:	The FreeBSD Foundation

Change cmake default behaviour to outsource.

Ports that build out of source now simply can use "USES=cmake"
instead of "USES=cmake:outsource". Ports that fail to build
out of source now need to specify "USES=cmake:insource".

I tried to only set insource where explictely needed.

PR:		232038
Exp-run by:	antoine

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

- Update WWW

Approved by:	portmgr blanket

Update devel/protobuf to 3.6.1

- Bump PORTREVISION of dependent ports for shlib change

Changes:	https://github.com/protocolbuffers/protobuf/releases
PR:		231008
Exp-run by:	antoine

devel/icu: update to 63.1

Changes:	http://site.icu-project.org/download/63
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
PR:		232300
Exp-run by:	antoine

databases/mysql80-server: Delete no-longer-needed patch for sse4.2

Reported by:	jbeich
Sponsored by:	The FreeBSD Foundation

databases/mysql80-server: Use c++14-lang instead of `msse-4.2 in CXXFLAG`
As suggested via replies to r477036 using `-msse-4.2` may break build on other
platforms.

Reported by:	linimon danfe jbeich
Sponsored by:	The FreeBSD Foundation

databases/mysql80-server: Fix build on default Clang of 10.4-base
Add sse4.2 flag to CXXFLAGS on 10.4 case.
The build-script needs it when using intrin lib on crc32

Sponsored by:	The FreeBSD Foundation

databases/mysql80-{client, server}: Update ports to 8.0.12
This update includes Oracle Critical Patch Advisory published on July 2018
More info:
http://www.oracle.com/technetwork/security-advisory/cpujul2018-4258247.html#AppendixMSQL
Also:
Delete upstreamed hunks of patches.
Change local patches regarding upstream changes.

PR:		229861
Reported by:	Markus Kohlmeyer <rootservice@gmail.com>
Sponsored by:	The FreeBSD Foundation

Bump PORTREVISION for ports depending on the canonical version of GCC
in the ports tree (via Mk/bsd.default-versions.mk and lang/gcc) which
has now moved from GCC 6 to GCC 7 by default.

This includes ports
 - featuring USE_GCC=yes or USE_GCC=any,
 - featuring USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and those
 - with USES=compiler specifying one of openmp, nestedfct, c11, c++0x,
   c++11-lib, c++11-lang, c++14-lang, c++17-lang, or gcc-c++11-lib.

PR:		222542

devel/icu: update to 62.1

Changes:	http://site.icu-project.org/download/62
ABI:		https://abi-laboratory.pro/tracker/timeline/icu4c/
PR:		229359
Exp-run by:	antoine (only 10.4)

databases/mysql80-{client,server}: Upgrade the ports to GA version 8.0.11
Fix build with LibreSSL and OpenSSL-devel ports as well

MySQL 8.0.11 is the General Availability (GA) version of MySQL 8.
MySQL since this version supports FIPS-mode, if compiled using OpenSSL, AND
    an OpenSSL library and FIPS Object Module are available at runtime.
    FIPS mode imposes conditions on cryptographic operations such as
    restrictions on acceptable encryption algorithms or requirements for longer
key lengths.
    The --ssl-fips-mode client option enables control of FIPS mode on the client
side for:
    mysql, mysqladmin, mysqlbinlog, mysqlcheck, mysqldump, mysqlimport,
mysqlpump, ...
This update includes bugfixes including (not limited to):
-InnoDB: The server was stopped before a fatal error message
    was written to the error log.
-InnoDB: An incorrect GROUP BY result was returned when using the
    TempTable storage engine and a NO PAD collation.
-InnoDB: The data retrieved from INFORMATION_SCHEMA.INNODB_COLUMNS was
    incorrect for tables containing a virtual column.

Full Release-Notes are available at:
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html

- Remove obsolete OSVERSION condition

Approved by:	portmgr blanket

Adjust __cxa_thread_atexit conditional

databases/mysql80-server: Fix ${name}_limits regression on 11-STABLE
This is port of r467049 (that was done on mysql56-server)

PR:		227435
Reported by:	0mp

databases/mysql80-server: Adapt ${name}_limits to the new mechanism
Regarding to the changes to rc.subr(8) it is no longer necessary to
define a resource limiting logic in service scripts.
limits(1) is now run by default and its configuration is handled
via the "${name}_limits" variable.
This however causes collision of variable names and also is not
compatible with the old mechanism.
This fixes the rc-script of mysql80 for the bases with both
old and new mechanism.
(This is port of the r466505 [and r466506])

PR:		227231
Submitted by:	0mp
Reported by:	0mp
Sponsored by:	Netzkommune GmbH