databases/mysql80-server: fix build with libc++ 19

As noted in the libc++ 19 release notes [1], std::char_traits<> is now
only provided for char, char8_t, char16_t, char32_t and wchar_t, and any
instantiation for other types will fail.

This causes databases/mysql80-client to fail to compile with clang 19
and libc++ 19, resulting in errors similar to:

    /usr/include/c++/v1/string:820:42: error: implicit instantiation of
undefined template 'std::char_traits<unsigned char>'
      820 |   static_assert(is_same<_CharT, typename
traits_type::char_type>::value,
          |                                          ^
   
/wrkdirs/usr/ports/databases/mysql80-client/work/mysql-8.0.39/sql/rpl_log_encryption.h:821:14:

databases/mysql80-server: fix build for i386

--- storage/innobase/CMakeFiles/innodb_zipdecompress.dir/all ---
/usr/tmp/net/hal/z/SRC/FreeBSD/ports/MBi/main/databases/mysql80-server/work/mysql-8.0.39/storage/innobase/include/detail/ut/aligned_alloc.h:466:39:
error: no member named 'meta_1' in
'ut::detail::Aligned_alloc_metadata<unsigned int, unsigned int>'
  466 |     auto offset = allocator_metadata::meta_1(data);
      |                   ~~~~~~~~~~~~~~~~~~~~^
/usr/tmp/net/hal/z/SRC/FreeBSD/ports/MBi/main/databases/mysql80-server/work/mysql-8.0.39/storage/innobase/include/detail/ut/aligned_alloc.h:593:25:
error: no member named 'meta_1' in
'ut::detail::Aligned_alloc_metadata<unsigned int, unsigned int>'
  593 |     allocator_metadata::meta_1(ret.first, ret.second);
      |     ~~~~~~~~~~~~~~~~~~~~^
/usr/tmp/net/hal/z/SRC/FreeBSD/ports/MBi/main/databases/mysql80-server/work/mysql-8.0.39/storage/innobase/include/detail/ut/aligned_alloc.h:594:25:
error: no member named 'meta_2' in

databases/mysql80-server: Fix SIGILL on aarch64

We want to check HWCAP_PMULL not HWCAP_CRC32.

Approved by:	portmgr (trivial runtime fix)
PR:		280165

databases/mysql80-server: Update to 8.0.39

- fixes multiple CVEs
- fixed startup error with large table set

PR: 280455

databases/mysql80-server databases/mysql81-server: fix build with libc++ 18 on
i386

When building against libc++ 18, several iostream classes now get
inlined into C++ binaries for efficiency. But because the mysql ports
use -malign-double on non-powerpc architectures, this causes an ABI
problem with libc++.so, which has not been built with that flag, at
least on i386. This can cause segfaults during the build of the port.

If it is not the architecture default, as it is on amd64, -malign-double
should not be used without recompiling basically the entire userspace
runtime. Quoting the gcc docs:

> Warning: if you use the -malign-double switch, structures containing
> the above types are aligned differently than the published application
> binary interface specifications for the x86-32 and are not binary
> compatible with structures in code compiled without that switch.

Hence, remove -malign-double from CXXFLAGS for these ports.

PR:		277896
Approved by:    maintainer timeout (2 weeks)
MFH:		2024Q1

databases/mysql80-server: fix build with clang 16

Similar to bug 272295, building databases/mysql80-server with clang 16
or higher can result in an error:

 
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.35/boost/boost_1_77_0/boost/mpl/aux_/integral_wrapper.hpp:73:31:
error: integer value -1 is outside the valid range of values [0, 3] for the
enumeration type 'udt_builtin_mixture_enum' [-Wenum-constexpr-conversion]
     73 |     typedef AUX_WRAPPER_INST(
BOOST_MPL_AUX_STATIC_CAST(AUX_WRAPPER_VALUE_TYPE, (value - 1)) ) prior;
        |                               ^
 
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.35/boost/boost_1_77_0/boost/mpl/aux_/static_cast.hpp:24:47:
note: expanded from macro 'BOOST_MPL_AUX_STATIC_CAST'
     24 | #   define BOOST_MPL_AUX_STATIC_CAST(T, expr) static_cast<T>(expr)
        |                                               ^

This is because the vendored copy of boost in mysql80-server is using
undefined behavior in a possibly constexpr context.

Fix this by unconditionally enabling the "boost workaround" for aux
wrapper value types in integral_wrapper.hpp.

PR:		276749
Approved by:	joneum (maintainer)
MFH:		2024Q1

*/*: 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/mysql80-server: Fix client patch phase

This is to fix the patch phase of databases/mysql80-client on i386,
where the extra-patch file could not be located because the relative
path was hardcoded in databases/mysql80-server.

===>  Patching for mysql80-client-8.0.35
===>  Applying extra patch
files/extra-patch-boost-boost_1_77_0-boost-move-detail-type_traits.hpp
cat: files/extra-patch-boost-boost_1_77_0-boost-move-detail-type_traits.hpp: No
such file or directory
===>  FAILED Applying extra patch
files/extra-patch-boost-boost_1_77_0-boost-move-detail-type_traits.hpp
*** Error code 1

Approved by:	portmgr (blanket)

databases/mysql80-server: Fix build with libressl

Upstream commit d737d2a [1] introduced three code paths for OpenSSL
<1.1, >=3.0 and between, none of which currently works with LibreSSL.
3.x APIs are not yet supported, and the code path for <1.1 directly
accesses struct members that were made opaque in LibreSSL as well.
Finally, the code path for >=1.1 uses DH_new_by_nid() which is missing
from LibreSSL.

Therefore add a patch introducing a fourth code path, doing essentially
the same as the version for OpenSSL <1.1, but using the accessor methods
instead of directly accessing struct members.

Also remove patches for viossl[factories].cc, which aren't needed any
more for current LibreSSL.

[1]
https://github.com/mysql/mysql-server/commit/d737d2a3ef6fc82d933a2345769835e8c2e4f700

Approved by:		joneum (maintainer, via private mail)
Differential Revision:	https://reviews.freebsd.org/D42922

databases/mysql80-server: Fix build

Fix aarch64 (1) and i386 (2) build

Reported by:	fluffy (1)
PR:	274918 (2) Martin Birgmeier <d8zNeCFG@aon.at>

Sponsored by:	Netzkommune GmbH

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

Changelogs:
8.0.34: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-34.html
8.0.35: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-35.html

Sponsored by:	Netzkommune GmbH

devel/icu: update to 74.1

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

databases/mysql80-server: fix build with clang/libc++ 17

Building databases/mysql80-server with clang and libc++ 17 results in
the following errors:

  In file included from
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.33/sql/auth/sql_authorization.cc:23:
  In file included from
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.33/sql/auth/sql_authorization.h:26:
  In file included from /usr/include/c++/v1/functional:515:
  In file included from /usr/include/c++/v1/__algorithm/search.h:23:
  /usr/include/c++/v1/__utility/pair.h:613:22: error: invalid operands to binary
expression ('const Auth_id' and 'const MYSQL_LEX_CSTRING')
    613 |     return __x.first == __y.first && __x.second == __y.second;
        |            ~~~~~~~~~ ^  ~~~~~~~~~
  /usr/include/c++/v1/__algorithm/find.h:34:41: note: in instantiation of
function template specialization 'std::__1::operator==<const Auth_id, Auth_id,
MYSQL_LEX_CSTRING, MYSQL_LEX_CSTRING>' requested here
     34 |     if (std::__invoke(__proj, *__first) == __value)
        |                                         ^

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

Bugs Fixed

    NDB Cluster: Occasional temporary errors which could occur when
opening a table from the NDB dictionary while repeatedly performing
concurrent schema operations were not retried. (Bug #34843889)

    NDB Cluster: During iteration, ordered index scans retain a cursor
position within each concurrently scanned ordered index fragment.
Ordered index fragments are modified and balanced as a result of
committing DML transactions, which can require scan cursors to be moved
within the tree. When running with query threads configured
(AutomaticThreadConfig set to 1), multiple threads can access the same
index fragment tree structure, and the scans of multiple threads can

databases/mysql80-client: Fix mysqlclient.pc

- Bump PORTREVISION for package change

Not all supported FreeBSD releases has openssl.pc in base system. This patch
adds a check for openssl.pc. It helps to build databases/py-mysqlclient.

If you do not have openssl.pc from your SSL provider.

Before the fix:
% grep Requires.private: /usr/local/libdata/pkgconfig/mysqlclient.pc
Requires.private: openssl

After the fix:
% grep Requires.private: /usr/local/libdata/pkgconfig/mysqlclient.pc

databases/mysql80-server: fix a issue with protobuf

PR:	270289
Reported by: Ting-Wei Lan <lantw44@gmail.com>
Sponsored by:	Netzkommune GmbH

databases/mysql80-server: enable libunwind on powerpc

devel/icu: update to 73.1

- Temporarily switch to GitHub auto archive (release artifacts are N/A atm)

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

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