Roundcube: "Unable to connect to the database!"

Please add -l like

systemctl status rh-mariadb105-mariadb@roundcubemail -l

We need to find out why mariadb isn’t starting. Is it still about the same socket?

1 Like

After reinstalling and manually enabling the service (to avoid deactivating after reboot):

# systemctl status rh-mariadb105-mariadb@roundcubemail -l
● rh-mariadb105-mariadb@roundcubemail.service - MariaDB 10.5 database server
   Loaded: loaded (/etc/systemd/system/rh-mariadb105-mariadb@.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/rh-mariadb105-mariadb@roundcubemail.service.d
           └─nethserver.conf
   Active: active (running) since Sat 2022-04-02 00:17:53 CEST; 9h ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 1992 (mysqld)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/system-rh\x2dmariadb105\x2dmariadb.slice/rh-mariadb105-mariadb@roundcubemail.service
           └─1992 /opt/rh/rh-mariadb105/root/usr/libexec/mysqld --defaults-group-suffix=.roundcubemail --basedir=/opt/rh/rh-mariadb105/root/usr

Apr 02 00:17:51 MDOL-NethServer.dargels.de systemd[1]: Starting MariaDB 10.5 database server...
Apr 02 00:17:52 MDOL-NethServer.dargels.de mysqld-scl-helper[1992]: 2022-04-02  0:17:52 0 [Note] /opt/rh/rh-mariadb105/root/usr/libexec/mysqld (mysqld 10.5.9-MariaDB) starting as process 1992 ...
Apr 02 00:17:53 MDOL-NethServer.dargels.de systemd[1]: Started MariaDB 10.5 database server.

and after reboot:

[root@MDOL-NethServer ~]# systemctl status rh-mariadb105-mariadb@roundcubemail -l
● rh-mariadb105-mariadb@roundcubemail.service - MariaDB 10.5 database server
   Loaded: loaded (/etc/systemd/system/rh-mariadb105-mariadb@.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/rh-mariadb105-mariadb@roundcubemail.service.d
           └─nethserver.conf
   Active: active (running) since Sat 2022-04-02 10:00:19 CEST; 18s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 2359 ExecStartPost=/usr/bin/scl enable $RH_MARIADB105_SCLS_ENABLED -- /opt/rh/rh-mariadb105/root/usr/libexec/mysql-check-upgrade --defaults-group-suffix=.%I (code=exited, status=0/SUCCESS)
  Process: 1442 ExecStartPre=/usr/bin/scl enable $RH_MARIADB105_SCLS_ENABLED -- /opt/rh/rh-mariadb105/root/usr/libexec/mysql-prepare-db-dir --defaults-group-suffix=.%I %n (code=exited, status=0/SUCCESS)
  Process: 1219 ExecStartPre=/usr/bin/scl enable $RH_MARIADB105_SCLS_ENABLED -- /opt/rh/rh-mariadb105/root/usr/libexec/mysql-check-socket --defaults-group-suffix=.%I (code=exited, status=0/SUCCESS)
  Process: 1093 ExecStartPre=/usr/bin/scl enable $RH_MARIADB105_SCLS_ENABLED -- /usr/bin/scl_enabled rh-mariadb105 (code=exited, status=0/SUCCESS)
 Main PID: 1784 (mysqld)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/system-rh\x2dmariadb105\x2dmariadb.slice/rh-mariadb105-mariadb@roundcubemail.service
           └─1784 /opt/rh/rh-mariadb105/root/usr/libexec/mysqld --defaults-group-suffix=.roundcubemail --basedir=/opt/rh/rh-mariadb105/root/usr

Apr 02 10:00:17 MDOL-NethServer.dargels.de systemd[1]: Starting MariaDB 10.5 database server...
Apr 02 10:00:18 MDOL-NethServer.dargels.de scl[1442]: Database MariaDB is probably initialized in /var/opt/rh/rh-mariadb105/lib/mysql-roundcubemail already, nothing is done.
Apr 02 10:00:18 MDOL-NethServer.dargels.de scl[1442]: If this is not the case, make sure the /var/opt/rh/rh-mariadb105/lib/mysql-roundcubemail is empty before running mysql-prepare-db-dir.
Apr 02 10:00:18 MDOL-NethServer.dargels.de mysqld-scl-helper[1784]: 2022-04-02 10:00:18 0 [Note] /opt/rh/rh-mariadb105/root/usr/libexec/mysqld (mysqld 10.5.9-MariaDB) starting as process 1784 ...
Apr 02 10:00:19 MDOL-NethServer.dargels.de

You have to dive in log to understand, we use the same way with nextcloud, so we know it works.