[Digikam-users] [party solved] how to migrate to mysql

[Wybo]

On 2014-08-16 11:37, I wrote:
> I want to migrate my frequently crashing digikam sqlite database to my
> mysql database on my Synology station, but the migration tool says:
>
> Database connection test was not successful.
> Error was: Access denied for user 'wybo'@'wybo.fritz.box' (using
> password: YES) QMYSQL: Unable to connect

I finally found out, via the mysql at lists.mysql.com, that the problem was that I 
had to grant access to the database for 'wybo'@'wybo.fritz.box'  by executing an 
sql command via phpMysqlAdmin:

GRANT <the permissions you want to give> on *.* to
'wybo'@'wybo.fritz.box' IDENTIFIED BY 'password goes here in plain text'

This solved my access problems, although database migration did not work.
I simply removed all sqlite stuff and made a fresh start by first changing the 
database to mysql (without any albums) and then adding new albums.

However: the system seems to be completely useless, because after leaving the 
digikam window alone for some time (maybe the 24 minute timeout of the database) 
all thumbnails and even the albums disappear, and digikam has to be restarted 
and begins the image/thumbnail scan again, which can take hours.
Perhaps I'm doing something wrong again...

> My Synology station is on 192.168.178.27,
> the database listens to port 3306,
> on my FritzBox I forwarded port 3306 to 192.168.178.27,
> I can connect to the database on http://192.168.178.27/phpMyAdmin/
> I specified dk for the Schema name and dktn for the thumbnails Schema
> name, and whether or not I created those (empty) mysql databases makes
> no difference.
>
> What am I doing wrong?
>

-- 
Wybo