19 comments on “Using digiKam with MySQL

  1. Does that really move the data and not just copy? The original would be good to kept untouched if there comes problems.

  2. This would be more useful if it supported the actually raw files itself. I could see digiKam fitting a nice market set where you need multiple people doing work on photos where you could “check out” an image, work on it and return it.

    Just putting the metadata and thumbnails up isn’t as useful unless you are looking at tying this into a website or some type of simple client preview system.

  3. MySQL support is all very well, but it seems like Digikam since 1.3 or 1.4 requires it, so I have to build it even if I don’t want to use MySQL backend. I don’t mind optional dependencies, vast majority of KDE people has to have MySQL installed anyway, but not me. Is it intended behaviour (“feature”) or some kind of undesired bug?

  4. What about a PostgreSQL support to ?
    Personally I prefer PostgreSQL to Mysql, and I don’t want to install a new SQL server.
    This is a very good news but it a could be very very good news if I can use Digikam with my PostgreSQL server

  5. Do you have any quantitative comparison of performance between the two database back-ends?

  6. By doing this will i achieve any performance enhancements. Cause the thumbnail database loading speed is very slow even with all the thumbnails generated!

  7. Hi,

    I try to setup this for digikam2.0
    I created to databases in my mysql dikigamdb and digikamthumdb and grant all the privileages to some user digikamuser

    as: mysql -u root -p

    CREATE DATABASE digikamdb;
    GRANT ALL PRIVILEGES ON digikamdb.* TO ‘digikamuser’ IDENTIFIED BY ‘password'; FLUSH PRIVILEGES;
    CREATE DATABASE digikamthumbdb;
    GRANT ALL PRIVILEGES ON digikamthumbdb.* TO ‘digikamuser’ IDENTIFIED BY ‘password'; FLUSH PRIVILEGES;

    now I setup digikam to use these databases…

    [Database Settings]
    Database Connectoptions=
    Database Hostname=localhost
    Database Name=digikamdb
    Database Name Thumbnails=digikamthumbdb
    Database Password=password
    Database Port=3306
    Database Type=QMYSQL
    Database Username=digikamuser
    Internal Database Server=false

    however with this config I get an error at startup about CREATE and TRIGGER privileages not given to user… I checked the password and it is ok…

    of course if I setup it to use the root user I have no problems in accessing it… Because some other kde apps share the same mysql server I would prefer digikam to be restricted at accessing only these to databases. Is this possible do I miss somthing?

    Alin

    • Hi Alin,

      I had the same problem. I solved it by GRANT ALL ON *.* to… So, I did not only grant all privileges on digikam and digikam_thumbnails but also to other databases (like mysql?). This solved it.

      • thank you smith.
        I did more or less something similar

        https://bugs.kde.org/show_bug.cgi?id=262321

        I would prefer digikamuser to be able to access only its databases and nothing more.
        I had a discussion with Bruno see bugs link #c1 and it seems that some changes in digikam are needed to achive this.

        Alin

      • I tried this, and a number of other things. On a MySQL 5.0.24a server (on a ReadyNAS Duo). But I’m still getting privilege errors. In particular I get “digikam(3416)/digikam (core): Insufficient rights on databse.”

        Any idea what I can do?

  8. Very nice! Thank you. After loosing my database about the 4th time (my own fault, I had the database on my nfs-server since my home-dir is over nfs) I decided to give it a try!
    I’d advise everyone to store all the metadata directly in the images. It is painfully slow sometimes, but the first time you kill your database you’ll be happy (sometimes my paranoia pays out :-) )

  9. Thank you for bringing me close to solving the problem, but… I use phpMyAdmin as MySQL server on a NAS Synology 212+. Checking the connexion to the database is succesfull. Migrating the database from my computer to the network server is done without a problem. But when I try to add a collection from the directory where are my photo collection on the NAS (through Network>Samba shares), I get the answer “The selected folder does not exist or is not readable”.
    Any idea for a solution ?

  10. But you have a Problem when you want use a Linux and Windows. Because the “Mountpoint” is different.

  11. Thanks for your description.

    But it doesn’t work with host name “192.168.1.1” – I’ve the error:
    “Der Datenbankverbindungstest ist nicht erfolgreich gewesen.
    Der Fehler lautet: Access denied for user ‘digikam_user’@’192.168.1.120′ (using password: YES) QMYSQL: Verbindungsaufbau nicht möglich” (in EN – no connection possible)

    (Information 192.168.1.120 is the IP from local PC not from server which have .1)

    If I change the IP to a other value then 1 – the error is with the right IP – but I can’t change the IP of the server in the moment.

    Any suggestions?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s