[digiKam-users] How to install/uninstall digikam with internal MySQL database Mariadb?

[zwyklydigikam]

This is my third topic, sorry, but cannot find answers.

1. First of all, problem with UNINSTALL mariadb and digikam.
Windows 10 uninstall Digikam + uninstall MariaDB (for fresh new
installation).
After uninstall i installed again Digikam, but when started i got message
about missing mysql.exe, and info path to my program files/Mariadb
10.3.10...thet i just uninstalled etc.
So i quess something left after uninstallation, so i uninstalled again, and
deleted all, databases folders. But still asking for maria DB insted of
staring wizzard.
I had to find manualy all digikam related files, and "maria" files in
program files, local, appdata ect.
After that, i could make fresh install.
Is it a bug? Is it MariaDB unistall problem or digikam, or both? If it is
good practice to leave files in system after unistallation (maybe config
files), i think it should ask if user want to save it.


2. Second problem(topic). Installing digikam is quite simple and with
pictures/tooltip. No problem when you pick default with SQLite, it just
works.
But if you have more than 100.000 pictures, you have to pick MySQL internal
experimantal database.
I have to download mariadb and install, the "Download" button redirected to
mariadb website.
a) Why there is no autodownload or autoinstall with default settings just
for digikam?

But ok, lets say i'm not afraid of installing databases on my computer. I go
to mariadb, download, and i have 2 versions of mariaDB for windows 64:
mariadb-10.3.11-winx64-debugsymbols.zip
mariadb-10.3.11-winx64.zip
b) Why there is no information what version to download for digikam?

But ok, there is HELP button at the bottom of wizzard, lets click it and
find "database" - nothing, lets find "install" - nothing, lets find "mysql"
- nothing, "SQL" - nothing. So lets go and read all help file, from getting
started - nothing (just somehing about SQLite).
I have to download PDF from website support, and find some info about mysql,
but still no answer.
c) Why HELP doesn't help? I quess it assumes we are SQL experts for DK.

But let's say i'm brave, and pick.... smaller file! Maybe it is enough for
digikam, maybe both are good i don't know, there is MariaDB version 5, and
10, dunno. So i start to install MariaDB 10.
Simple, next next, agree.
Then "features to be installed".
d) Do i need all feature during installation wizzard of MariaDB for digikam,
or just one, or two?

But ok, i'm got big HDD so lets overkill just in case, and select all, and
click "NEXT".
Modify password for database use root?
e) Do i have to check modify passord for database?
f) Do i have to enter password?
g) Does it change anything? Why do i need it anyway, and wthere to use it in
digikam?

I quess i dont need for remote machines, so i didnt check "remote machines".
h) Do i have to pick utf8? i think i'ts compatible with linux and windows,
but what digikam think about it?

Ok, I will leave it default, unchecked then, I think default is quite smart
most of cases, and go NEXT.
Another window.
i) should i install as service, or not? If not a service what then?

But ok, i will leave it defalt, lest try.
j) Enable networking.....I dont use networking, its local, but few users
checked this while installing some other software, cannot find answer about
digikam.

But ok, flip a coin, and leave it default, port 3306 sounds perfect to me
for my internal offline database.
k) Innnob engine settings with buffer pool size and page size good for my
digikam database?

Where is my coin, where is my coin... default again.

THE END.
This was my first installation. There is no help in digikam HELP and support
PDF. I was trying to use MariaDB help, but it was like reading a bible so i
tried some noob questions on google, but all of them installing apache,
linux, and some weird networking stuff with ports, and i just want my local
simple two exe files for my digikam MySQL.

I've checked like 50 pages of google with "install digikam database mysl",
"installing database", "why god why", and many more, all pdf's and help,
maybe i type something wrong.

And after i start digikam, there should be information that it will check
for new elements and it will take 10 hours for 1tb images: " OK" "Do it
later".

Thank you for reading my TLDR wishes and help
Digikam 6.0.0 beta3.
Windows 10x64
MariaDB 10.2 (testing for errors right now)

- Digikam noob




--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

[SkyDiver]

Hey zwyklydigikam,

Reading between the lines, I'm getting the feeling that you're not a
MySQL/MariaDB expert :)

Anyways, I'm not sure if in the end of your sad saga you got Digikam
up and running with MySQL/MariaDB or not.
If the point of your email is a complaint about poor documentation,
then this should be directed to the developers.

If you didn't manage to make things work, then I can offer you two options:
1. I'm not sure why MySQL is needed for 100,000 images. Did you try
running with the SQLite database?
   If not, then this is the first option to try - at least you'll be
able to get a feel of what Digikam is like.

2. In case you do want MySQL after all, and in case you don't insist
on it being internal Digikam MySQL, rather an external installation,
then I suggest that you'll take a look at pre-configured AMP-based
installation bundles (AMP = Apache MySQL PHP).
Two that I can think of are WAMP and XAMPP. Others exist as well.
I used XAMPP for quite a while so I can suggest it as a good bundle to try.
The point of the bundle is to give you an already set-up configured
set of software, including MySQL.
XAMPP has a control panel which you can use in order to enable/disable
various components.
In your case, you can disable everything except for the MySQL instance.
This way you'll gain a ready-made MySQL server which will run on your
local machine at IP address: 127.0.0.1 (a.k.a. localhost)

If you choose to go down that path - make sure to uninstall the
MariaDB software you previously installed.
Again, all this - just in case you don't already have a happily up and
running Digikam + MySQL currently.

Either way - you sound very brave for getting as far as you already
got. Thumbs up!




On Sat, Dec 15, 2018 at 10:08 AM zwyklydigikam <[hidden email]> wrote:

>
> This is my third topic, sorry, but cannot find answers.
>
> 1. First of all, problem with UNINSTALL mariadb and digikam.
> Windows 10 uninstall Digikam + uninstall MariaDB (for fresh new
> installation).
> After uninstall i installed again Digikam, but when started i got message
> about missing mysql.exe, and info path to my program files/Mariadb
> 10.3.10...thet i just uninstalled etc.
> So i quess something left after uninstallation, so i uninstalled again, and
> deleted all, databases folders. But still asking for maria DB insted of
> staring wizzard.
> I had to find manualy all digikam related files, and "maria" files in
> program files, local, appdata ect.
> After that, i could make fresh install.
> Is it a bug? Is it MariaDB unistall problem or digikam, or both? If it is
> good practice to leave files in system after unistallation (maybe config
> files), i think it should ask if user want to save it.
>
>
> 2. Second problem(topic). Installing digikam is quite simple and with
> pictures/tooltip. No problem when you pick default with SQLite, it just
> works.
> But if you have more than 100.000 pictures, you have to pick MySQL internal
> experimantal database.
> I have to download mariadb and install, the "Download" button redirected to
> mariadb website.
> a) Why there is no autodownload or autoinstall with default settings just
> for digikam?
>
> But ok, lets say i'm not afraid of installing databases on my computer. I go
> to mariadb, download, and i have 2 versions of mariaDB for windows 64:
> mariadb-10.3.11-winx64-debugsymbols.zip
> mariadb-10.3.11-winx64.zip
> b) Why there is no information what version to download for digikam?
>
> But ok, there is HELP button at the bottom of wizzard, lets click it and
> find "database" - nothing, lets find "install" - nothing, lets find "mysql"
> - nothing, "SQL" - nothing. So lets go and read all help file, from getting
> started - nothing (just somehing about SQLite).
> I have to download PDF from website support, and find some info about mysql,
> but still no answer.
> c) Why HELP doesn't help? I quess it assumes we are SQL experts for DK.
>
> But let's say i'm brave, and pick.... smaller file! Maybe it is enough for
> digikam, maybe both are good i don't know, there is MariaDB version 5, and
> 10, dunno. So i start to install MariaDB 10.
> Simple, next next, agree.
> Then "features to be installed".
> d) Do i need all feature during installation wizzard of MariaDB for digikam,
> or just one, or two?
>
> But ok, i'm got big HDD so lets overkill just in case, and select all, and
> click "NEXT".
> Modify password for database use root?
> e) Do i have to check modify passord for database?
> f) Do i have to enter password?
> g) Does it change anything? Why do i need it anyway, and wthere to use it in
> digikam?
>
> I quess i dont need for remote machines, so i didnt check "remote machines".
> h) Do i have to pick utf8? i think i'ts compatible with linux and windows,
> but what digikam think about it?
>
> Ok, I will leave it default, unchecked then, I think default is quite smart
> most of cases, and go NEXT.
> Another window.
> i) should i install as service, or not? If not a service what then?
>
> But ok, i will leave it defalt, lest try.
> j) Enable networking.....I dont use networking, its local, but few users
> checked this while installing some other software, cannot find answer about
> digikam.
>
> But ok, flip a coin, and leave it default, port 3306 sounds perfect to me
> for my internal offline database.
> k) Innnob engine settings with buffer pool size and page size good for my
> digikam database?
>
> Where is my coin, where is my coin... default again.
>
> THE END.
> This was my first installation. There is no help in digikam HELP and support
> PDF. I was trying to use MariaDB help, but it was like reading a bible so i
> tried some noob questions on google, but all of them installing apache,
> linux, and some weird networking stuff with ports, and i just want my local
> simple two exe files for my digikam MySQL.
>
> I've checked like 50 pages of google with "install digikam database mysl",
> "installing database", "why god why", and many more, all pdf's and help,
> maybe i type something wrong.
>
> And after i start digikam, there should be information that it will check
> for new elements and it will take 10 hours for 1tb images: " OK" "Do it
> later".
>
> Thank you for reading my TLDR wishes and help
> Digikam 6.0.0 beta3.
> Windows 10x64
> MariaDB 10.2 (testing for errors right now)
>
> - Digikam noob
>
>
>
>
> --
> Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

[zwyklydigikam]

SkyDiver wrote
> If you didn't manage to make things work, then I can offer you two
> options:
> 1. I'm not sure why MySQL is needed for 100,000 images. Did you try
> running with the SQLite database?

SQLite for 200k images is slow, don't know why. Generating thumbnails can
take a week. I've no idea why it is so slow. About 3 second for one picture,
so with 200k photos its 7 days. With MySQL it's 1 day.


SkyDiver wrote
> 2. In case you do want MySQL after all, and in case you don't insist
> on it being internal Digikam MySQL, rather an external installation,
> then I suggest that you'll take a look at pre-configured AMP-based
> installation bundles (AMP = Apache MySQL PHP).
> Two that I can think of are WAMP and XAMPP.

I use local/online WAMP XAMP LAMP for webdesign, so you say I can use it for
digikam same time? Any tutorials how to configure? or just path to exe files
in digikam wizzard?

I will try with MariaDB. It's good for many users, so why not for me. Just
need few answers a) b) c) d).....


SkyDiver wrote
> Either way - you sound very brave for getting as far as you already
> got. Thumbs up!

I am!
Thanks!



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

[SkyDiver]

zwyklydigikam wrote:
> I use local/online WAMP XAMP LAMP for webdesign, so you say I can use it for
> digikam same time? Any tutorials how to configure? or just path to exe files
> in digikam wizzard?

Yes. I you already have a *AMP up and running with MySQL enabled, then
you're server installation episode is over.
Just for completeness, here the Digikam>MySQL setup instructions:
https://userbase.kde.org/Digikam/Using_digiKam_with_MySQL

zwyklydigikam wrote:
> I will try with MariaDB. It's good for many users, so why not for me. Just
> need few answers a) b) c) d).....

I. personally, tried it a year back and got all my tags disappearing on me.
Luckily I was able to dig into the database and resurrect them, but I
decided to switch back to SQLite.
I do, however, have two separate databases - each having ~35K images,
which works fine on SQLite.

A lot has changed since then and the developers say the MySQL version
is much more stable now, so go ahead and give it a go (just make sure
to backup first).

[digikam-2]

Take a look at:

https://scribblesandsnaps.com/2018/10/19/use-digikam-with-a-nas-and-mariadb/

from Dmitri Popov. He knows digikam, he wrote the recipe book.

sknahT

vyS


On Mon, 17 Dec 2018 16:45:53 +0200
Sky Diver <[hidden email]> wrote:

> zwyklydigikam wrote:
> > I use local/online WAMP XAMP LAMP for webdesign, so you say I can
> > use it for digikam same time? Any tutorials how to configure? or
> > just path to exe files in digikam wizzard?  
>
> Yes. I you already have a *AMP up and running with MySQL enabled,
> then you're server installation episode is over.
> Just for completeness, here the Digikam>MySQL setup instructions:
> https://userbase.kde.org/Digikam/Using_digiKam_with_MySQL
>
> zwyklydigikam wrote:
> > I will try with MariaDB. It's good for many users, so why not for
> > me. Just need few answers a) b) c) d).....  
>
> I. personally, tried it a year back and got all my tags
> disappearing on me. Luckily I was able to dig into the database and
> resurrect them, but I decided to switch back to SQLite.
> I do, however, have two separate databases - each having ~35K
> images, which works fine on SQLite.
>
> A lot has changed since then and the developers say the MySQL
> version is much more stable now, so go ahead and give it a go (just
> make sure to backup first).

--
sknahT

vyS