Unable to get mariadb-10.2 & mariadb-10.1 or working on OS X Lion

[mav2287 (James)]

Went to install mariadb 10.2 on OS X Lion and threw quite a few error out throughout the process. During install I saw a ton of errors here are a few of them

Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/aria_ftdump.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/galera_new_cluster.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/galera_recovery.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/innochecksum.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/msql2mysql.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/my_print_defaults.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/my_safe_process.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/myisam_ftdump.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/myisamchk.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/myisamlog.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/myisampack.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/mysql-stress-test.pl.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/mysql-test-run.pl.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/mysql_client_test.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/mysql_client_test_embedded.1
Warning: reinplace s|/etc/|/opt/local/etc/mariadb-10.2/|g didn't change anything in /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.2/mariadb-10.2/work/destroot/opt/local/share/man/mariadb-10.2/man1/mysql_config.1

They were all about the same style let me know if I need to attach them all.

After that I went to set it up and ran into.

bash-3.2# /opt/local/lib/mariadb-10.2/bin/mysqld --initialize --user=_mysql
2018-01-17 17:31:47 4457433440 [Note] /opt/local/lib/mariadb-10.2/bin/mysqld (mysqld 10.2.11-MariaDB) starting as process 9188 ...
2018-01-17 17:31:47 4457433440 [Warning] Can't create test file /opt/local/var/db/mariadb-10.2/server.lower-test
/opt/local/lib/mariadb-10.2/bin/mysqld: Can't change dir to '/opt/local/var/db/mariadb-10.2/' (Errcode: 2 "No such file or directory")
2018-01-17 17:31:47 4457433440 [ERROR] Aborting

after that I decided to try and bypass the setup process and go manually setup everything since I had another mariadb database I could import so I tried to make it load and got this.

bash-3.2# sudo port select mysql mariadb-10.2
Selecting 'mariadb-10.2' for 'mysql' failed: could not create new link "/opt/local/bin/mysql_zap": target "/opt/local/lib/mariadb-10.2/bin/mysql_zap" doesn't exist

After running into this 10.2 I went back and installed 10.1 I got all the warnings and also this part

/opt/local/lib/mariadb-10.1/bin/mysqld --initialize --user=_mysql
2018-01-17 17:45:13 4355676512 [Note] /opt/local/lib/mariadb-10.1/bin/mysqld (mysqld 10.1.29-MariaDB) starting as process 24417 ...
2018-01-17 17:45:13 4355676512 [Warning] Can't create test file /opt/local/var/db/mariadb-10.1/server.lower-test
/opt/local/lib/mariadb-10.1/bin/mysqld: Can't change dir to '/opt/local/var/db/mariadb-10.1/' (Errcode: 2 "No such file or directory")
2018-01-17 17:45:13 4355676512 [ERROR] Aborting

Although it didn't throw an error when I selected it I still didn't have a working install.

[pixilla (Bradley Giesbrecht)]

The default database directories are made by the "-server" ports. Installing mariadb-10.2-server or mariadb-10.1-server should get rid of the errors resulting from missing data directories.

The "port select" error will be fixed in a Portfile update shortly.

[eirnym (Eir Nym)]

@pixilla MariaDB dropped a few binaries like mysql_zap and mysqlbug, which is understandable. We need to drop them from our repository too or make them silent on port select mysql command.

[mf2k (Frank Schima)]

See #57827

[michaelld (Michael Dickens)]

Is this still an issue with the update of MariaDB 10.2 to 10.2.28 on Nov 5? ​https://trac.macports.org/changeset/32c03448aa4061acc3ad5676fa84a834098b0615/macports-ports

[kencu (Ken)]

I just went through the process of installing and configuring mariadb-10.2-server on Lion and it went smoothly and without a hitch, following the instructions that the port notes provided along the way.

[michaelld (Michael Dickens)]

Nice! Thanks for reporting your success, @kencu!