+ PKG_PATH=/nfs/packages/SmartOS/trunk/x86_64/All
+ /opt/tools/sbin/pkg_add -K /opt/local/pkg mktools-20220614 cwrappers-20220403 p5-DBD-percona57-cluster-4.050nb6 percona-xtrabackup-2.4.25 quickbackup-percona-8.0 gcc13-libs-13.2.0 percona-cluster-5.7.43
pkg_add: package `mktools-20220614' already recorded as installed
pkg_add: package `cwrappers-20220403' already recorded as installed
gettext-lib-0.22.3: copying /opt/local/share/examples/gettext/locale.alias to /opt/local/lib/locale/locale.alias
openssl-3.1.4: copying /opt/local/share/examples/openssl/openssl.cnf to /opt/local/etc/openssl/openssl.cnf
xmlcatmgr-2.2nb1: copying /opt/local/share/examples/xmlcatmgr/catalog.etc.sgml to /opt/local/etc/sgml/catalog
xmlcatmgr-2.2nb1: copying /opt/local/share/examples/xmlcatmgr/catalog.etc.xml to /opt/local/etc/xml/catalog
xmlcatmgr-2.2nb1: copying /opt/local/share/examples/xmlcatmgr/catalog.share.sgml to /opt/local/share/sgml/catalog
xmlcatmgr-2.2nb1: copying /opt/local/share/examples/xmlcatmgr/catalog.share.xml to /opt/local/share/xml/catalog
cyrus-sasl-2.1.28nb1: Creating user ``cyrus''
passwd: password information changed for cyrus
openldap-client-2.6.6nb1: copying /opt/local/share/examples/openldap/ldap.conf to /opt/local/etc/openldap/ldap.conf
percona-cluster-5.7.43: Creating group ``mysql''
percona-cluster-5.7.43: Creating user ``mysql''
passwd: password information changed for mysql
percona-cluster-5.7.43: copying /opt/local/share/mysql/my-joyent.cnf to /opt/local/etc/my.cnf
2023-12-27T15:31:17.261581Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2023-12-27T15:31:17.261858Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-12-27T15:31:17.261928Z 0 [Note] Ignoring --secure-file-priv value as server is running with --initialize(-insecure) or --bootstrap.
2023-12-27T15:31:17.261966Z 0 [Warning] WSREP: Node is running in bootstrap/initialize mode. Disabling pxc_strict_mode checks
2023-12-27T15:31:17.261994Z 0 [Note] /opt/local/sbin/mysqld (mysqld 5.7.43-47-log) starting as process 69329 ...
2023-12-27T15:31:17.264618Z 0 [Note] Creating the data directory /var/mysql/
2023-12-27T15:31:17.270983Z 0 [ERROR] Could not open file '/var/log/mysql/error.log' for error logging: Permission denied
2023-12-27T15:31:17.271018Z 0 [ERROR] Aborting

2023-12-27T15:31:17.271064Z 0 [Note] Binlog end
2023-12-27T15:31:17.271215Z 0 [Note] /opt/local/sbin/mysqld: Shutdown complete

===========================================================================
This package has SMF support.  You may use svcadm(1M) to 'enable', 'disable'
or 'restart' services.  To enable the instance(s) for this package, run:

	/usr/sbin/svcadm enable -r svc:/pkgsrc/percona:default

Use svcs(1) to check on service status.  See smf(5) for more information.

The PKG_SKIP_SMF variable was set or automatic import of SMF manifests
failed.  You must import the SMF manifest manually with:

	/usr/sbin/svccfg import /opt/local/lib/svc/manifest/percona.xml

projadd: Validation error on line 6, User "www" does not exist
projadd: Validation error on line 6, Group "www" does not exist
===========================================================================
pkg_add: A different version of percona-xtrabackup-2.4.25 is already installed: percona-xtrabackup-8.0.34
===========================================================================
This package has SMF support.  You may use svcadm(1M) to 'enable', 'disable'
or 'restart' services.  To enable the instance(s) for this package, run:

	/usr/sbin/svcadm enable -r svc:/pkgsrc/quickbackup-percona:default

Use svcs(1) to check on service status.  See smf(5) for more information.

The PKG_SKIP_SMF variable was set or automatic import of SMF manifests
failed.  You must import the SMF manifest manually with:

	/usr/sbin/svccfg import /opt/local/lib/svc/manifest/quickbackup-percona.xml

===========================================================================
pkg_add: package `gcc13-libs-13.2.0' was already installed as dependency, now marked as installed manually
pkg_add: package `percona-cluster-5.7.43' was already installed as dependency, now marked as installed manually
pkg_add: 1 package addition failed
===========================================================================
$NetBSD: MESSAGE,v 1.4 2017/07/26 09:21:10 hauke Exp $

cyrus-sasl-2.1.28nb1 by default does *not* install any authentication plugin
modules.  Until the necessary authentication plugin modules are
installed, e.g. security/cy2-crammd5 or security/cy2-gssapi, you
will probably get errors about "no appropriate mechs available".

The configuration files for applications using the sasl2 libraries
used to be in /opt/local/lib/sasl2/, but are now expected in
/opt/local/etc/sasl2/. You need to move them after upgrading the pkg.

cyrus-sasl-2.1.28nb1 will use the following directory as the default
path to its plugin modules:

	/opt/local/lib/sasl2

The search path for plugin modules can be customized by setting the
SASL_PATH variable to a colon-delimted list of directories in the shell
environment.

To allow plaintext authentication without using the auxprop mechanism, the
package security/cyrus-saslauthd should be installed.

===========================================================================
===========================================================================
$NetBSD$

After the tables are set up and the MySQL server is running,
please remember to set a password for the MySQL root user!
This is done by running both:

  /opt/local/bin/mysqladmin -u root -p password 'new-password'
  /opt/local/bin/mysqladmin -h `hostname` -u root -p password 'new-password'

The "Enter password:" prompt is asking for the existing password.
As there is no existing password, just press the Return key.

There is a script distributed with MySQL that can help you lock down
an installation.  This script has been installed to

  /opt/local/bin/mysql_secure_installation.

Please see the manual and the MySQL web site for more instructions.

===========================================================================