1 (edited by Sukhster 2025-04-03 04:43:18)

Topic: MariaDB 10.11.8 to 10.11.11 Upgrade - Database Server Fails to Start

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): v1.7.1
- Deployed with iRedMail Easy or the downloadable installer? Downloaded Installer
- Linux/BSD distribution name and version: Ubuntu 24.04.2 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB 10.11.8
- Web server (Apache or Nginx): nginx/1.24.0 (Ubuntu)
- Manage mail accounts with iRedAdmin-Pro? No

- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
× mariadb.service - MariaDB 10.11.11 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: enabled)
    Drop-In: /etc/systemd/system/mariadb.service.d
             └─override.conf
     Active: failed (Result: exit-code) since Wed 2025-04-02 17:07:10 UTC; 43s ago
   Duration: 14min 53.814s
       Docs: man:mariadbd(8)
// Removed URL
   Main PID: 27698 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"
        CPU: 229ms

Apr 02 17:07:10 some-server mariadbd[27698]: 2025-04-02 17:07:10 0 [Note] InnoDB: log sequence number 3496107597; transaction id 6364558
Apr 02 17:07:10 some-server mariadbd[27698]: 2025-04-02 17:07:10 0 [Note] Plugin 'FEEDBACK' is disabled.
Apr 02 17:07:10 some-server mariadbd[27698]: 2025-04-02 17:07:10 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Apr 02 17:07:10 some-server mariadbd[27698]: 2025-04-02 17:07:10 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Apr 02 17:07:10 some-server mariadbd[27698]: 2025-04-02 17:07:10 0 [ERROR] Failed to setup SSL
Apr 02 17:07:10 some-server mariadbd[27698]: 2025-04-02 17:07:10 0 [ERROR] SSL error: SSL_CTX_set_default_verify_paths failed
Apr 02 17:07:10 some-server mariadbd[27698]: 2025-04-02 17:07:10 0 [ERROR] Aborting
Apr 02 17:07:10 some-server systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Apr 02 17:07:10 some-server systemd[1]: mariadb.service: Failed with result 'exit-code'.
Apr 02 17:07:10 some-server systemd[1]: Failed to start mariadb.service - MariaDB 10.11.11 database server.

Before Upgrade
===========

mysql  Ver 15.1 Distrib 10.11.8-MariaDB, for debian-linux-gnu (x86_64) using  EditLine wrapper
MariaDB [(none)]> show global variables like '%ssl%';
+---------------------+-------------------------------+
| Variable_name       | Value                         |
+---------------------+-------------------------------+
| have_openssl        | YES                           |
| have_ssl            | YES                           |
| ssl_ca              | /etc/ssl/certs/iRedMail.crt   |
| ssl_capath          |                               |
| ssl_cert            | /etc/ssl/certs/iRedMail.crt   |
| ssl_cipher          |                               |
| ssl_crl             |                               |
| ssl_crlpath         |                               |
| ssl_key             | /etc/ssl/private/iRedMail.key |
| version_ssl_library | OpenSSL 3.0.13 30 Jan 2024    |
+---------------------+-------------------------------+
10 rows in set (0.001 sec)

====

I used the Downloaded Installer on Jan 23rd, 2025 to install v1.7.1 (if l had waited another day, l would be on v1.7.2).

Everything has been working amazing since then, until l did an upgrade of packages including MariaDB components. Once l move from MariaDB 10.11.8 to 10.11.11, l get an exception with the SSL Certificates Not being found.

The /etc/my.cnf doesn't have the Certificate Settings, so am assuming that they were added as part of the Installer. Settings are below before the Upgrade.

However, since MariaDB 10.11.11 doesn't start AFTER the upgrade, so l cannot access the database to check the variable settings.

I wouldn't mind getting input before l a) post something on the MariaDB Forum b) set has_ssl to No - and then doing the upgrade.

Has anybody else experienced this issue, or suggestions on what to try?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 (edited by Sukhster 2025-04-03 04:44:21)

Re: MariaDB 10.11.8 to 10.11.11 Upgrade - Database Server Fails to Start

An update to this question. Somehow, MariaDB upgraded itself to v10.11.11 and stopped running. Restarts with the same error above regarding the SSL Path.

Note: l followed the MariaDB instructions to create local self-signed certificates, and same error.

However, when I added "ssl=0" to the /etc/mysql/my.cnf file under the "[mysqld]" section, and l was then was able to restart the database.


MariaDB [(none)]> show global variables like '%ssl%';
+---------------------+-------------------------------+
| Variable_name       | Value                         |
+---------------------+-------------------------------+
| have_openssl        | YES                           |
| have_ssl            | DISABLED                      |
| ssl_ca              | /etc/ssl/certs/iRedMail.crt   |
| ssl_capath          |                               |
| ssl_cert            | /etc/ssl/certs/iRedMail.crt   |
| ssl_cipher          |                               |
| ssl_crl             |                               |
| ssl_crlpath         |                               |
| ssl_key             | /etc/ssl/private/iRedMail.key |
| version_ssl_library | OpenSSL 3.0.13 30 Jan 2024    |
+---------------------+-------------------------------+
10 rows in set (0.001 sec)

I would like to put ssl back on again.

Could the issue be that the crt/key values point to a symbolic link?

Has anybody else faced this issue with MariaDB after the iRedAdmin installation?