digikam and mysql

Zitat von uwe_harz

hallo, i am using digikam for windows and omv with mysql plugin. it works fine with the web interface on the omv.
in the digikam configuration you can use an external database for the picture details. i cannot connect to the mysql with the digikam software.
can everyone help me?
best regards uwe

Hm! I don't use either, but under their documentation it tells you how to set this up and to test the connection.....but it also tells you within that same documentation to use MariaDB

Snip from that documentation

MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry.


MariaDB has actually overtaken MySQL, ‘cause of few basic reasons:


MariaDB development is more open and vibrant.


More cutting edge features.


More storage engines.


Better performance.


Compatible and easy to migrate.

If you check the Video guides by @TechnoDadLife he explains how to install MariaDB for use with Nextcloud and I could see no reason why that would not be of use.

If the software can't connect then the problem is either with the set up of the plugin or the information entered into Settings>>>Configure digiKam

Zitat von uwe_harz

I can with the Web Interface all with the MySql - DB what i want, new DB, new tables ...

I've just installed the mysql plugin, from what I can see it's all configured from the Web Interface.

So for the plugin, Enabled it, changed the Bind to 0.0.0.0, left the port as the default and enabled SQL management site and reset the password Save>>>Apply
Then from a web browser <ip address of server>:3360 user, login user:omvadmin password:the one I changed in the plugin

That's it I'm now greeted with a web page, then from the menu Database>>>Create New then from the drop down menu under select the newly created database, you can then go to Tools User Manager for that database.

TBH once the database is created and the user or users and their roles set up, that should be it unless you have to set up the whole DB in the MySQL web interface

If you have done that, all digikam requires is the server ip, user, password and the default port of 3306.

Zitat von uwe_harz

that i have done too, but when i try to connect with the win64 version of digikam, the connection has no function and it get an error...

could it be better to try the 32 bit version of digikam?

best regards uwe

I don't know why I do this, perhaps it's because I like a challenge

What has thrown me, and it's partly my fault you haven't specified the error! the error being your host can't connect (your computer)

So this is what I have done.

Installed digikam
Installed MySQL Plugin

From web interface of mysql created a new database digikam, select that database from the drop down

Now that this is selected go to Tools>>>Add User add a user name, in host add the ip address of the computer you are going to connect from, (where digikam is installed) this is the important part!! Add a password, then set the privileges (for this I set all for the user and global)

Then ssh into omv and execute systemctl restart mysql

Now go back to digikam and enter omv's host name or ip address the user name and password you created and check connection, this should now display Database connection test successful.