Error 1348 hy000 column password is not updatable

            # 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 socket

[ 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.

[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)]> 

===>  Checking if dbus-glib is already installed
===>   Registering installation for dbus-glib-0.110 as automatic
pkg-static: Cannot get an exclusive lock on a database, it is locked by another process
*** Error code 75

Stop.
make[3]: stopped in /basejail/usr/ports/devel/dbus-glib
*** Error code 1

Stop.
make[2]: stopped in /basejail/usr/ports/net/avahi-app
*** Error code 1

Stop.
make[1]: stopped in /basejail/usr/ports/lang/gnustep-base
*** Error code 1

Stop.
make: stopped in /basejail/usr/ports/devel/sope4
<< ERROR >> Port was not successfully installed, please fix it manually and then re-execute this script.

rogwynn wrote:

pkg-static: Cannot get an exclusive lock on a database, it is locked by another process

ZhangHuangbin wrote:

rogwynn wrote:

pkg-static: Cannot get an exclusive lock on a database, it is locked by another process

— Did you modify «functions/packages_freebsd.sh» to build/install ports concurrently?
— Does re-running iRedMail installer trigger this issue again?

[ 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.DOMAIN.com.pid).
2020-03-30 20:36:30 0 [Warning] WSREP: Failed to guess base node address. Set it
 explicitly via wsrep_node_address.
2020-03-30 20:36:30 0 [Warning] WSREP: Failed to guess base node address. Set it
 explicitly via wsrep_node_address.
2020-03-30 20:36:30 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.

    if [ X"${BACKEND}" == X'OPENLDAP' ]; then
        ALL_PORTS="${ALL_PORTS} net/openldap${PREFERRED_OPENLDAP_VER}-sasl-client net/openldap${PREFERRED_OPENLDAP_VER}-server"
        ALL_PORTS="${ALL_PORTS} databases/mariadb${PREFERRED_MARIADB_VER}-server"
 
    elif [ X"${BACKEND}" == X'MYSQL' ]; then
        # Install client before server.
        ALL_PORTS="${ALL_PORTS} databases/mariadb${PREFERRED_MARIADB_VER}-client"

        if [ X"${USE_EXISTING_MYSQL}" != X'YES' ]; then
            ALL_PORTS="${ALL_PORTS} databases/mariadb${PREFERRED_MARIADB_VER}-server"   
        fi
    
    elif [ X"${BACKEND}" == X'PGSQL' ]; then
        ALL_PORTS="${ALL_PORTS} databases/postgresql${PGSQL_VERSION}-server databases/postgresql${PGSQL_VERSION}-contrib"
    fi

    if [ X"${BACKEND}" == X'OPENLDAP' ]; then
        ALL_PORTS="${ALL_PORTS} net/openldap${PREFERRED_OPENLDAP_VER}-sasl-client net/openldap${PREFERRED_OPENLDAP_VER}-server"
        if [ X"${USE_EXISTING_MYSQL}" != X'YES' ]; then
            ALL_PORTS="${ALL_PORTS} databases/mariadb${PREFERRED_MARIADB_VER}-server"   
        fi
 
    elif [ X"${BACKEND}" == X'MYSQL' ]; then

GenZod wrote:

The installation went well and installed everything except the db is empty

GenZod wrote:

So is there a script or scripts to re-create the necessary databases again ?

GenZod wrote:

I got the database up and running. However it’s still empty after re-running the install script.