DigiKam with MySQL

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

DigiKam with MySQL

Johannes Kapune
Hello,

I'm using DigiKam 4.7.0 on a opensuse 13.1

first I use the SQLite as back end for storing metadata but now I want
to change to MySQL or MariaDB.

I started the database server but if I try to choose in DigiKam type of
database I only can choose SQLite.

Do I miss something? I have to prepare something before choosing other
database than SQLite?


How I can do further tests?


ps -A | grep my
  5533 ?        00:00:00 mysqld_safe
  5764 ?        00:00:01 mysqld
11764 ?        00:05:09 mysqld


Johannes
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: DigiKam with MySQL

Philip Johnsson

DigiKam need to be built with mysql support which is a experimental feature due to lack of maintenance. If you can't select it maybe the Suse package maintainer haven't turned it on when they built it. If you really want it anyway you need to rebuild DigiKam with mysql support.

Regards,

Philip

On Feb 27, 2015 11:55 AM, "Johannes Kapune" <[hidden email]> wrote:
Hello,

I'm using DigiKam 4.7.0 on a opensuse 13.1

first I use the SQLite as back end for storing metadata but now I want to change to MySQL or MariaDB.

I started the database server but if I try to choose in DigiKam type of database I only can choose SQLite.

Do I miss something? I have to prepare something before choosing other database than SQLite?


How I can do further tests?


ps -A | grep my
 5533 ?        00:00:00 mysqld_safe
 5764 ?        00:00:01 mysqld
11764 ?        00:05:09 mysqld


Johannes
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: DigiKam with MySQL

Johannes Kapune
Thanks for quick answer.

I installed from:

  http://download.opensuse.org/repositories/KDE:/Extra/openSUSE_13.1/


is there a repository where the mysql support is built in?

Building myself is not what I want, and maybe not what I can do anyway
because lack of experience


Regards

Johannes

Am 27.02.2015 um 12:42 schrieb Philip Johnsson:

> DigiKam need to be built with mysql support which is a experimental
> feature due to lack of maintenance. If you can't select it maybe the
> Suse package maintainer haven't turned it on when they built it. If you
> really want it anyway you need to rebuild DigiKam with mysql support.
>
> Regards,
>
> Philip
>
> On Feb 27, 2015 11:55 AM, "Johannes Kapune" <[hidden email]
> <mailto:[hidden email]>> wrote:
>
>     Hello,
>
>     I'm using DigiKam 4.7.0 on a opensuse 13.1
>
>     first I use the SQLite as back end for storing metadata but now I
>     want to change to MySQL or MariaDB.
>
>     I started the database server but if I try to choose in DigiKam type
>     of database I only can choose SQLite.
>
>     Do I miss something? I have to prepare something before choosing
>     other database than SQLite?
>
>
>     How I can do further tests?
>
>
>     ps -A | grep my
>       5533 ?        00:00:00 mysqld_safe
>       5764 ?        00:00:01 mysqld
>     11764 ?        00:05:09 mysqld
>
>
>     Johannes
>     _________________________________________________
>     Digikam-users mailing list
>     [hidden email] <mailto:[hidden email]>
>     https://mail.kde.org/mailman/__listinfo/digikam-users
>     <https://mail.kde.org/mailman/listinfo/digikam-users>
>
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: DigiKam with MySQL

Anders Stedtlund
Hi Johannes,

Maybe you could ask on the opensuse-kde mailing list:
http://lists.opensuse.org/opensuse-kde/

/Anders

2015-02-27 14:47 GMT+01:00 Johannes Kapune <[hidden email]>:

> Thanks for quick answer.
>
> I installed from:
>
>  http://download.opensuse.org/repositories/KDE:/Extra/openSUSE_13.1/
>
>
> is there a repository where the mysql support is built in?
>
> Building myself is not what I want, and maybe not what I can do anyway
> because lack of experience
>
>
> Regards
>
> Johannes
>
> Am 27.02.2015 um 12:42 schrieb Philip Johnsson:
>>
>> DigiKam need to be built with mysql support which is a experimental
>> feature due to lack of maintenance. If you can't select it maybe the
>> Suse package maintainer haven't turned it on when they built it. If you
>> really want it anyway you need to rebuild DigiKam with mysql support.
>>
>> Regards,
>>
>> Philip
>>
>> On Feb 27, 2015 11:55 AM, "Johannes Kapune" <[hidden email]
>> <mailto:[hidden email]>> wrote:
>>
>>     Hello,
>>
>>     I'm using DigiKam 4.7.0 on a opensuse 13.1
>>
>>     first I use the SQLite as back end for storing metadata but now I
>>     want to change to MySQL or MariaDB.
>>
>>     I started the database server but if I try to choose in DigiKam type
>>     of database I only can choose SQLite.
>>
>>     Do I miss something? I have to prepare something before choosing
>>     other database than SQLite?
>>
>>
>>     How I can do further tests?
>>
>>
>>     ps -A | grep my
>>       5533 ?        00:00:00 mysqld_safe
>>       5764 ?        00:00:01 mysqld
>>     11764 ?        00:05:09 mysqld
>>
>>
>>     Johannes
>>     _________________________________________________
>>     Digikam-users mailing list
>>     [hidden email] <mailto:[hidden email]>
>>     https://mail.kde.org/mailman/__listinfo/digikam-users
>>     <https://mail.kde.org/mailman/listinfo/digikam-users>
>>
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: DigiKam with MySQL [solved]

Johannes Kapune
Hi Anders,

first I found in:
https://userbase.kde.org/Digikam/Tutorials
  - Advanced Features
      - Using digiKam with MySQL - how to migrate your data to MySQL so
that you can use a server for your photos.

from 2013.

(https://userbase.kde.org/Digikam/Using_digiKam_with_MySQL)  from 2010


First release I used had included MySQL support, but at that time I did
not use. Now I'm happy about not using because otherwise all my work in
metadata had gone to waste by upgrading.



https://techbase.kde.org/Projects/Digikam/CodingSprint2014

yes, after some search I found this article where near at the end in
"Task Details" they write:

"MySQL support is now disabled by default because it's not fully
functional and still experimental. MySQL support is still fully
available of course, but as an optional feature."


This makes my work on pictures now a little more difficult because it
was planned to work from some different computer by different people on
same collection of pictures (but not at same time), so server based data
would help a lot. (Family use here)

Now we will try to write all metadata always into the pictures (exif or
...?) but I'm sure there will come up some trouble.


I still hope that MySQL support will come back ASAP.
For me it would be also OK if I can save SQLite on same server where
pictures are stored.


Johannes

Am 28.02.2015 um 08:22 schrieb Anders Stedtlund:

> Hi Johannes,
>
> Maybe you could ask on the opensuse-kde mailing list:
> http://lists.opensuse.org/opensuse-kde/
>
> /Anders
>
> 2015-02-27 14:47 GMT+01:00 Johannes Kapune <[hidden email]>:
>> Thanks for quick answer.
>>
>> I installed from:
>>
>>   http://download.opensuse.org/repositories/KDE:/Extra/openSUSE_13.1/
>>
>>
>> is there a repository where the mysql support is built in?
>>
>> Building myself is not what I want, and maybe not what I can do anyway
>> because lack of experience
>>
>>
>> Regards
>>
>> Johannes
>>
>> Am 27.02.2015 um 12:42 schrieb Philip Johnsson:
>>>
>>> DigiKam need to be built with mysql support which is a experimental
>>> feature due to lack of maintenance. If you can't select it maybe the
>>> Suse package maintainer haven't turned it on when they built it. If you
>>> really want it anyway you need to rebuild DigiKam with mysql support.
>>>
>>> Regards,
>>>
>>> Philip
>>>
>>> On Feb 27, 2015 11:55 AM, "Johannes Kapune" <[hidden email]
>>> <mailto:[hidden email]>> wrote:
>>>
>>>      Hello,
>>>
>>>      I'm using DigiKam 4.7.0 on a opensuse 13.1
>>>
>>>      first I use the SQLite as back end for storing metadata but now I
>>>      want to change to MySQL or MariaDB.
>>>
>>>      I started the database server but if I try to choose in DigiKam type
>>>      of database I only can choose SQLite.
>>>
>>>      Do I miss something? I have to prepare something before choosing
>>>      other database than SQLite?
>>>
>>>
>>>      How I can do further tests?
>>>
>>>
>>>      ps -A | grep my
>>>        5533 ?        00:00:00 mysqld_safe
>>>        5764 ?        00:00:01 mysqld
>>>      11764 ?        00:05:09 mysqld
>>>
>>>
>>>      Johannes
>>>      _________________________________________________
>>>      Digikam-users mailing list
>>>      [hidden email] <mailto:[hidden email]>
>>>      https://mail.kde.org/mailman/__listinfo/digikam-users
>>>      <https://mail.kde.org/mailman/listinfo/digikam-users>
>>>
>> _______________________________________________
>> Digikam-users mailing list
>> [hidden email]
>> https://mail.kde.org/mailman/listinfo/digikam-users
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: DigiKam with MySQL [solved]

Guido von Thun


Hi to all,

>>
>> I still hope that MySQL support will come back ASAP.

Me too!!!!


Regards
Guido


Guido von Thun
Ingenieurbüro für Energieberatung
& Gebäude- und Anlagensimulation
Amselweg 4
91460 Baudenbach
Tel.: +49 (9164) 99 81 489
[hidden email]
www.gvt-consulting.de

Am 28.02.2015 um 09:13 schrieb Johannes Kapune:

> Hi Anders,
>
> first I found in:
> https://userbase.kde.org/Digikam/Tutorials
>   - Advanced Features
>       - Using digiKam with MySQL - how to migrate your data to MySQL so
> that you can use a server for your photos.
>
> from 2013.
>
> (https://userbase.kde.org/Digikam/Using_digiKam_with_MySQL)  from 2010
>
>
> First release I used had included MySQL support, but at that time I did
> not use. Now I'm happy about not using because otherwise all my work in
> metadata had gone to waste by upgrading.
>
>
>
> https://techbase.kde.org/Projects/Digikam/CodingSprint2014
>
> yes, after some search I found this article where near at the end in
> "Task Details" they write:
>
> "MySQL support is now disabled by default because it's not fully
> functional and still experimental. MySQL support is still fully
> available of course, but as an optional feature."
>
>
> This makes my work on pictures now a little more difficult because it
> was planned to work from some different computer by different people on
> same collection of pictures (but not at same time), so server based data
> would help a lot. (Family use here)
>
> Now we will try to write all metadata always into the pictures (exif or
> ...?) but I'm sure there will come up some trouble.
>
>
> I still hope that MySQL support will come back ASAP.
> For me it would be also OK if I can save SQLite on same server where
> pictures are stored.
>
>
> Johannes
>
> Am 28.02.2015 um 08:22 schrieb Anders Stedtlund:
>> Hi Johannes,
>>
>> Maybe you could ask on the opensuse-kde mailing list:
>> http://lists.opensuse.org/opensuse-kde/
>>
>> /Anders
>>
>> 2015-02-27 14:47 GMT+01:00 Johannes Kapune <[hidden email]>:
>>> Thanks for quick answer.
>>>
>>> I installed from:
>>>
>>>   http://download.opensuse.org/repositories/KDE:/Extra/openSUSE_13.1/
>>>
>>>
>>> is there a repository where the mysql support is built in?
>>>
>>> Building myself is not what I want, and maybe not what I can do anyway
>>> because lack of experience
>>>
>>>
>>> Regards
>>>
>>> Johannes
>>>
>>> Am 27.02.2015 um 12:42 schrieb Philip Johnsson:
>>>>
>>>> DigiKam need to be built with mysql support which is a experimental
>>>> feature due to lack of maintenance. If you can't select it maybe the
>>>> Suse package maintainer haven't turned it on when they built it. If you
>>>> really want it anyway you need to rebuild DigiKam with mysql support.
>>>>
>>>> Regards,
>>>>
>>>> Philip
>>>>
>>>> On Feb 27, 2015 11:55 AM, "Johannes Kapune" <[hidden email]
>>>> <mailto:[hidden email]>> wrote:
>>>>
>>>>      Hello,
>>>>
>>>>      I'm using DigiKam 4.7.0 on a opensuse 13.1
>>>>
>>>>      first I use the SQLite as back end for storing metadata but now I
>>>>      want to change to MySQL or MariaDB.
>>>>
>>>>      I started the database server but if I try to choose in DigiKam
>>>> type
>>>>      of database I only can choose SQLite.
>>>>
>>>>      Do I miss something? I have to prepare something before choosing
>>>>      other database than SQLite?
>>>>
>>>>
>>>>      How I can do further tests?
>>>>
>>>>
>>>>      ps -A | grep my
>>>>        5533 ?        00:00:00 mysqld_safe
>>>>        5764 ?        00:00:01 mysqld
>>>>      11764 ?        00:05:09 mysqld
>>>>
>>>>
>>>>      Johannes
>>>>      _________________________________________________
>>>>      Digikam-users mailing list
>>>>      [hidden email] <mailto:[hidden email]>
>>>>      https://mail.kde.org/mailman/__listinfo/digikam-users
>>>>      <https://mail.kde.org/mailman/listinfo/digikam-users>
>>>>
>>> _______________________________________________
>>> Digikam-users mailing list
>>> [hidden email]
>>> https://mail.kde.org/mailman/listinfo/digikam-users
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users