In this case the root password of mariadb needs to be resetted:
Stop service:
systemctl stop rh-mariadb103-mariadb
Enable rh-mariadb103 scl:
scl enable rh-mariadb103 bash
Start mariadb in a way to be able to reset the password:
mysqld_safe --skip-grant-tables &
Enter mariadb103 client:
mysql103
Reset the password, replace with the password from the my.cnf:
UPDATE mysql.user SET authentication_string = PASSWORD('<PASSWORD from my.cnf>') WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;
quit
exit
Job for rh-mariadb103-mariadb.service failed because the control process exited with error code. See âsystemctl status rh-mariadb103-mariadb.serviceâ and âjournalctl -xeâ for details.
âŚ
How can I check if mariaDB103 is correctly installed?
Success! that one worked - at least I can mariadb via phpmyadmin. Also the moodle plattform is online, up and running, and it is accessible from the vhosts as expected.
However, there is just one more thing to do:
I can not log in to moodle. Obviously the DB was not transferred. The login with username admin and password Nethesis,1234 or with an AD/LDAP user does not work. Also my old admin password does not work either. Is there any regular access to the DB?
Can I simply restore the old DB from the old mariadb 5 installation?
I can not exactly remember, but to the best of my knowledge I did the installation exactly as it was given on the wiki. I am quite sure that I did not alter the password during installation. If it was Nethesis,123 intially, I changed it afterwards.
Also, you will not believe what happens here:
I can login via phpmyadmin on port 3313 using either user âadminâ or ârootâ. For both the passwort as given in /root/.my.cnf is valid. But I am not admin. I can not access the user nor can I restore the dump.
Yes, of course - but I was searching the DB (for which I have read access): It does contain all my AD users from Nethserver - which I never set up within the old moodle installation. I can not even remember that I have the the ldap access.
I tried to reinitialize mariadb 10.3 as explained here but mysql and perfomance_schema tables are not created. Does anybody know what could be the issue here?
use mysql_install_db command (backup/dump any other existing database/table beforehand).
I guess itâs advisable to run the signal event (signal-event nethserver-rh-mariadb103-update) afterwards.
We tried mysql_install_db including the signal-event and it adds the tables but theyâre empty. And after another recreate the tables are missing again.
I cannot reproduce this behaviour on one of my servers, itâs really weird. When I delete the databases dir, theyâre always recreated.
[root@testserver ~]# ls -l /var/opt/rh/rh-mariadb103/lib/mysql/
total 122940
-rw-rw---- 1 mysql mysql 16384 Apr 26 23:29 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Apr 26 23:29 aria_log_control
-rw-rw---- 1 mysql mysql 976 Apr 26 23:29 ib_buffer_pool
-rw-rw---- 1 mysql mysql 12582912 Apr 26 23:29 ibdata1
-rw-rw---- 1 mysql mysql 50331648 Apr 26 23:29 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Apr 26 23:29 ib_logfile1
-rw-rw---- 1 mysql mysql 12582912 Apr 26 23:29 ibtmp1
-rw-rw---- 1 mysql mysql 0 Apr 26 23:29 multi-master.info
drwx------ 2 mysql mysql 4096 Apr 26 23:29 mysql
-rw-rw---- 1 mysql mysql 16 Apr 26 23:29 mysql_upgrade_info
drwx------ 2 mysql mysql 20 Apr 26 23:29 performance_schema
drwx------ 2 mysql mysql 4096 Apr 26 23:29 phpmyadmin
-rw-rw---- 1 mysql mysql 24576 Apr 26 23:29 tc.log
[root@testserver ~]# ls -ld /var/opt/rh/rh-mariadb103/lib/mysql/
drwxr-xr-x 5 mysql mysql 266 Apr 26 23:29 /var/opt/rh/rh-mariadb103/lib/mysql/