Hello,
Digikam stopped connecting to the external database after the last upgrade of openSuse Tumbleweed. The connection ends with the error:
Database connection test failed.
An error occurred: TLS/SSL error: Certificate verification failure: The certificate is NOT trusted
The problem will be related to the client side. From another PC with a different OS version, Digikam connects to the db correctly.
Digikam version: 8.6.0-3.1
Mariadb version (on server openSuse Leap): mysql Ver 15.1 Distrib 10.11.9-MariaDB, for Linux (x86_64) using EditLine wrapper
openSUSE Tumbleweed VERSION= 20250503
Show this certificate. Something like
curl -Lsw '%{certs}\n' -o /dev/null https://yout-server-address/
I accidentally didn’t copy the whole error message. It should have been:
Database connection test was not successful.
Error was: TLS/SSL error: Certificate verification failure: The certificate is NOT trusted. QMYSQL: Unable to connect
The command curl -Lsw '%{certs}\n' -o /dev/null https://192.168.188.24:3306doesn’t return anything. The mariadb is hosted on home server in local network.
I’ve set up the ssl, so I can now connect to db (more info here 503894 – Unable to connect to MySQL database from Digikam on openSUSE Tumbleweed after update).
I guess this is a new Mariadb feature and not a bug. Thank you for your time and help.