how to migrate to mysql
Locked
 
|
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 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 _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
On Saturday, August 16, 2014 11:37:54 AM Wybo 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 > > 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? I migrated a while back and if i remember right I had to: 1. Create databases using phpMyAdmin (digikam4.db and thumbnails- digikam.db 2. Create a digikam user and give proper permissions. 3. Go into digikam and select digikam settings -->database a. Create the necessary information (Hostname, Port, Schema (digikam4.db), thumbnails (thumbnails-digikam.db, User Id and password). Since version 4.0 came out I have not been able to access the database and digikam eventually tells me the application is not responding. my digikam version is now: still fails. It does pass the connection test, OK. If I drop back to version 3.5.0. everything was working with mysql located on localhost. Don't know if this will help. Russ -- openSUSE 13.1(Linux 3.11.10-21-desktop x86_64| Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3| GeForce 8400GS (NVIDIA-Linux-x86_64-331.79)|KDE 4.13.3 _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
On 08/16/2014 07:33 PM, upscope wrote:
> On Saturday, August 16, 2014 11:37:54 AM Wybo 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 >> >> 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? > I migrated a while back and if i remember right I had to: > 1. Create databases using phpMyAdmin (digikam4.db and thumbnails- > digikam.db > 2. Create a digikam user and give proper permissions. > 3. Go into digikam and select digikam settings -->database > a. Create the necessary information (Hostname, Port, Schema > (digikam4.db), thumbnails (thumbnails-digikam.db, User Id > and password). > > Since version 4.0 came out I have not been able to access the database > and digikam eventually tells me the application is not responding. > > my digikam version is now: still fails. It does pass the connection > test, OK. If I drop back to version 3.5.0. everything was working with > mysql located on localhost. > > Don't know if this will help. > > Russ DK still was working but if I tried to change something in the settings, DK occupied one core completely and hung. After all I reinstalled DK from scratch using an sqlite database, which works fine. So I suppose something is wrong with the mysql schema in DK since 4.1.0 _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
We will review all works to do in database interface at next Coding
sprint planed in automn. The goal is to propose a project for next GoSC 2015 to improve and stabilize MySQL/MariaDB support and perhaps add Postgresql support. I already triaged all reports about database. I have a clear vision of the problems : https://bugs.kde.org/buglist.cgi?bug_status=UNCONFIRMED&bug_status=CONFIRMED&bug_status=ASSIGNED&bug_status=REOPENED&component=database&list_id=1114379&product=digikam&query_format=advanced In other words, use Sqlite in priority, and host database files to an SSD. It run perfectly here to manage an huge collection (around 143000 items). Collection are hosted locally in Raid HDD and duplicated all night to a NAS. I never use remote collections. Gilles Caulier 2014-08-17 11:03 GMT+02:00 Robert Zeller <[hidden email]>: > On 08/16/2014 07:33 PM, upscope wrote: >> On Saturday, August 16, 2014 11:37:54 AM Wybo 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 >>> >>> 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? >> I migrated a while back and if i remember right I had to: >> 1. Create databases using phpMyAdmin (digikam4.db and thumbnails- >> digikam.db >> 2. Create a digikam user and give proper permissions. >> 3. Go into digikam and select digikam settings -->database >> a. Create the necessary information (Hostname, Port, Schema >> (digikam4.db), thumbnails (thumbnails-digikam.db, User Id >> and password). >> >> Since version 4.0 came out I have not been able to access the database >> and digikam eventually tells me the application is not responding. >> >> my digikam version is now: still fails. It does pass the connection >> test, OK. If I drop back to version 3.5.0. everything was working with >> mysql located on localhost. >> >> Don't know if this will help. >> >> Russ > I had a similar problem with the mysql-Database since v. 4.1.0 came out. > DK still was working but if I tried to change something in the settings, > DK occupied one core completely and hung. After all I reinstalled DK > from scratch using an sqlite database, which works fine. So I suppose > something is wrong with the mysql schema in DK since 4.1.0 > > _______________________________________________ > 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 |
|
|
On Sunday, August 17, 2014 12:01:12 PM Gilles Caulier wrote:
> We will review all works to do in database interface at next Coding > sprint planed in automn. The goal is to propose a project for next > GoSC 2015 to improve and stabilize MySQL/MariaDB support and perhaps > add Postgresql support. > > I already triaged all reports about database. I have a clear vision of > the problems : > > https://bugs.kde.org/buglist.cgi?bug_status=UNCONFIRMED&bug_status=CON > FIRMED&bug_status=ASSIGNED&bug_status=REOPENED&component=database&list > _id=1114379&product=digikam&query_format=advanced > > In other words, use Sqlite in priority, and host database files to an > SSD. It run perfectly here to manage an huge collection (around 143000 > items). Collection are hosted locally in Raid HDD and duplicated all > night to a NAS. I never use remote collections. > > Gilles Caulier > > 2014-08-17 11:03 GMT+02:00 Robert Zeller <robert.zeller@robert- > > On 08/16/2014 07:33 PM, upscope wrote: > >> On Saturday, August 16, 2014 11:37:54 AM Wybo 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 > >>> > >>> 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? > >> > >> I migrated a while back and if i remember right I had to: > >> 1. Create databases using phpMyAdmin (digikam4.db and > >> thumbnails- > >> > >> digikam.db > >> > >> 2. Create a digikam user and give proper permissions. > >> 3. Go into digikam and select digikam settings -->database > >> > >> a. Create the necessary information (Hostname, Port, > >> Schema > >> > >> (digikam4.db), thumbnails (thumbnails-digikam.db, > >> User Id > >> and password). > >> > >> Since version 4.0 came out I have not been able to access the > >> database and digikam eventually tells me the application is not > >> responding. > >> > >> my digikam version is now: still fails. It does pass the connection > >> test, OK. If I drop back to version 3.5.0. everything was working > >> with mysql located on localhost. > >> > >> Don't know if this will help. > >> > >> Russ > > > > I had a similar problem with the mysql-Database since v. 4.1.0 came > > out. DK still was working but if I tried to change something in the > > settings, DK occupied one core completely and hung. After all I > > reinstalled DK from scratch using an sqlite database, which works > > fine. So I suppose something is wrong with the mysql schema in DK > > since 4.1.0 > > > > _______________________________________________ > > 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 That a great idea but how can I use digikam now? I do have room to install another database. Is 3.5 secure enough to use? I can drop back to it except my distro is distributing 4.X with all new os releases. An also updates the old release. Is there anything I can check, etc. I am now test openSUSE 13.2 and every time I open digikam it hang the system and requires a power reset to escape. It always fails with a message "Image failed to load" Will install the debug info later today. Russ -- openSUSE 13.1(Linux 3.11.10-21-desktop x86_64| Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3| GeForce 8400GS (NVIDIA-Linux-x86_64-331.79)|KDE 4.13.3 _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
In reply to this post by Gilles Caulier-4
TIA Gilles!
This is most welcome as my db is growing and is becoming increasingly slow on sqlite. Why not have MySQL as default db if available at installation of dk? I use SSD disk, Intel i7 cpu and 32GBRAM. A copy of my db statistic might give a hint of why I would like better support for mysql : Digikam version 4.2.0 Bilder: BMP: 95 GIF: 74 JP2: 10 JPEG: 1 JPG: 818349 PNG: 68 PPM: 12 RAW-ARW: 2087 RAW-CR2: 183111 RAW-DNG: 304 RAW-HDR: 1 RAW-NEF: 327 TIFF: 2587 XCF: 114 totalt: 1007140 : : Videor: 3GP: 133 AVI: 746 MOV: 403 MP4: 20 totalt: 1302 : : Totalt antal objekt: 1008442 Album: 20619 Etiketter: 548 Databasgränssnitt: QSQLITE /David söndagen den 17 augusti 2014 12.01.12 skrev Gilles Caulier: > We will review all works to do in database interface at next Coding > sprint planed in automn. The goal is to propose a project for next > GoSC 2015 to improve and stabilize MySQL/MariaDB support and perhaps > add Postgresql support. > > I already triaged all reports about database. I have a clear vision of > the problems : > > https://bugs.kde.org/buglist.cgi?bug_status=UNCONFIRMED&bug_status=CONFIRMED > &bug_status=ASSIGNED&bug_status=REOPENED&component=database&list_id=1114379& > product=digikam&query_format=advanced > > In other words, use Sqlite in priority, and host database files to an > SSD. It run perfectly here to manage an huge collection (around 143000 > items). Collection are hosted locally in Raid HDD and duplicated all > night to a NAS. I never use remote collections. > > Gilles Caulier > > 2014-08-17 11:03 GMT+02:00 Robert Zeller <[hidden email]>: > > On 08/16/2014 07:33 PM, upscope wrote: > >> On Saturday, August 16, 2014 11:37:54 AM Wybo 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 > >>> > >>> 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? > >> > >> I migrated a while back and if i remember right I had to: > >> 1. Create databases using phpMyAdmin (digikam4.db and thumbnails- > >> > >> digikam.db > >> > >> 2. Create a digikam user and give proper permissions. > >> 3. Go into digikam and select digikam settings -->database > >> > >> a. Create the necessary information (Hostname, Port, Schema > >> > >> (digikam4.db), thumbnails (thumbnails-digikam.db, User > >> Id > >> and password). > >> > >> Since version 4.0 came out I have not been able to access the database > >> and digikam eventually tells me the application is not responding. > >> > >> my digikam version is now: still fails. It does pass the connection > >> test, OK. If I drop back to version 3.5.0. everything was working with > >> mysql located on localhost. > >> > >> Don't know if this will help. > >> > >> Russ > > > > I had a similar problem with the mysql-Database since v. 4.1.0 came out. > > DK still was working but if I tried to change something in the settings, > > DK occupied one core completely and hung. After all I reinstalled DK > > from scratch using an sqlite database, which works fine. So I suppose > > something is wrong with the mysql schema in DK since 4.1.0 > > > > _______________________________________________ > > 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 |
|
|
2014-08-19 22:48 GMT+02:00 David Lindblad <[hidden email]>:
> TIA Gilles! > This is most welcome as my db is growing and is becoming increasingly slow on > sqlite. Why not have MySQL as default db if available at installation of dk? Because Mysql support still experimental and not finalized... Gilles Caulier _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
Ok, I was not totally clear in my question, I meant when finalised.
/David tisdagen den 19 augusti 2014 23.05.58 skrev Gilles Caulier: > 2014-08-19 22:48 GMT+02:00 David Lindblad <[hidden email]>: > > TIA Gilles! > > This is most welcome as my db is growing and is becoming increasingly slow > > on sqlite. Why not have MySQL as default db if available at installation > > of dk? > Because Mysql support still experimental and not finalized... > > Gilles Caulier > _______________________________________________ > 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 |
|
|
The goal is to have a common DB interface including compatible schema for
1 SQlite 2 Mysql 3 MariaDb 4 Postgresql 1 is for local DB. stable 2,3, is for local and remote DB. Not finalized and bugous. 4 is for local and remote DB. Not yet implemented. 1 is for non shared DB between computers 2,3,4 can be shared between computers. So, when DB interface code will be ready, we can plan a new page in first run assistant to select right DB engine. Gilles Caulier 2014-08-19 23:12 GMT+02:00 David Lindblad <[hidden email]>: > Ok, I was not totally clear in my question, I meant when finalised. > /David > tisdagen den 19 augusti 2014 23.05.58 skrev Gilles Caulier: >> 2014-08-19 22:48 GMT+02:00 David Lindblad <[hidden email]>: >> > TIA Gilles! >> > This is most welcome as my db is growing and is becoming increasingly slow >> > on sqlite. Why not have MySQL as default db if available at installation >> > of dk? >> Because Mysql support still experimental and not finalized... >> >> Gilles Caulier >> _______________________________________________ >> 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 |
|
|
This sounds great! As I understand this will be implemented at the earliest next autumn (2015). /David 2014-08-19 23:18 GMT+02:00 Gilles Caulier <[hidden email]>: The goal is to have a common DB interface including compatible schema for _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
In reply to this post by 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 [hidden email], 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 _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
«
Return to digikam-users
|
1 view|%1 views
| Free forum by Nabble | Edit this page |