Topic: MariaDB 10.4 not creating iRedMail databases
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.1
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: FreeBSD 12.1
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Brought over from the 1.1 Release Announcement:
Due to the way MariaDB 10.4 changed how the root account accesses the database, and how MariaDB stores users (mysql.user is now a view of mysql.global_priv), changing the root password in functions/mysql.sh doesn't work:
# MySQL 5.7
ECHO_DEBUG "Setting password for MySQL root user: ${MYSQL_ROOT_USER}
."
#if [ X"${LOCAL_ADDRESS}" == X'127.0.0.1' ]; then
# # Get initial random root password from /root/.mysql-secret
# export _mysql_root_pw="$(tail -1 /root/.mysql_secret)"
# mysqladmin -h ${MYSQL_SERVER_ADDRESS} -u${MYSQL_ROOT_USER} -p${
_mysql_root_pw} password ${MYSQL_ROOT_PASSWD} >> ${INSTALL_LOG} 2>&1
#else
# # Jail
mysql -h ${MYSQL_SERVER_ADDRESS} -u${MYSQL_ROOT_USER} --connect-
expired-password mysql -e "UPDATE user SET host='${LOCAL_ADDRESS}',authenticatio
n_string=PASSWORD('${MYSQL_ROOT_PASSWD}'),password_expired='N' WHERE User='root'
AND Host='localhost'; FLUSH PRIVILEGES;" >> ${INSTALL_LOG} 2>&1
# The above code doesn't work anymore, root has to connect via socketHere's the relevant error from runtime/install.log (ERROR 1348 (HY000) at line 1: Column 'authentication_string' is not updatable:
[ INFO ] Configure MariaDB database server.
+ < DEBUG > Initialize MySQL server.
+ < DEBUG > Stop MySQL service before initializing database or updating my.cnf.
+ < DEBUG > Enable mysql service when system start up.
mysql_enable: -> YES
mysql_optfile: -> /var/db/mysql/my.cnf
+ < DEBUG > Copy sample MySQL config file: /usr/local/share/mysql/my-large.cnf
-> /var/db/mysql/my.cnf.
+ < DEBUG > Disable 'skip-networking' in my.cnf.
+ < DEBUG > Set max_connections to 1024.
+ < DEBUG > Enable 'skip_grant_tables' option, so that we can reset password.
+ < DEBUG > Enable 'bind-address = 192.168.0.3' in my.cnf.
+ < DEBUG > Restart service: mysql-server.
mysql not running? (check /var/db/mysql/mx.peakbias.com.pid).
2020-03-20 21:33:20 0 [Warning] WSREP: Failed to guess base node address. Set it
explicitly via wsrep_node_address.
2020-03-20 21:33:20 0 [Warning] WSREP: Failed to guess base node address. Set it
explicitly via wsrep_node_address.
2020-03-20 21:33:20 0 [Warning] WSREP: Guessing address for incoming client conn
ections failed. Try setting wsrep_node_incoming_address explicitly.
+ < DEBUG > Sleep 10 seconds for MySQL daemon initialization ...
+ < DEBUG > Setting password for MySQL root user: root.
ERROR 1348 (HY000) at line 1: Column 'authentication_string' is not updatable
+ < DEBUG > Remove 'skip_grant_tables'.
+ < DEBUG > Restart service: mysql-server.
+ < DEBUG > Sleep 10 seconds for MySQL daemon initialization ...
+ < DEBUG > Generate defauts file for MySQL client option --defaults-file: /roo
t/.my.cnf.
+ < DEBUG > Delete anonymous database user.As root I connected to the MariaDB server, via localhost, and you can see no databases were created.
[root@mx ~]# mysql
ERROR 1130 (HY000): Host '192.168.0.3' is not allowed to connect to this MariaDB server
[root@mx ~]# mysql -h localhost
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 64
Server version: 10.4.12-MariaDB FreeBSD Ports
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.003 sec)
MariaDB [(none)]> In my previous install, I installed MariaDB 10.4 in a separate jail and used the "install with remote MySQL" instructions. This worked. Here I'm installing on another host, and I wanted to make a proper post and not muddy up the 1.1 announcement thread.
As suggested I will try again with the master branch from GitHub and will update this thread on how it goes.
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.
