Moving from sqlite to mysql failure

[daniel bip]

Hi there,

May someone assist me in moving from sqlite to mysql internal?

I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also installed mysql-server-5.7. I did nothing else (mysql is not setup in any way, I mean).

In the migration windows mysql_install_db is shown as a green tick, and also is mysqld. But when I click on Migrate I get a pop up warning stating "Error while opening the target database" and command line says

"digikam.dbengine: Error while opening the database. Error was QSqlError("", "Driver not loaded", "Driver not loaded")"

mysql is up and running so I guess I am just missing something important, may someone give me a clue?

Thx.

BR,

d.

[Simon Frei]

Hi,

Do you have the libqt5sql5-mysql package installed?
Or more generally, where do you install digiKam from?

Cheers,
Simon


On 03/04/17 19:11, daniel bip wrote:

> Hi there,
>
> May someone assist me in moving from sqlite to mysql internal?
>
> I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also installed
> mysql-server-5.7. I did nothing else (mysql is not setup in any way, I
> mean).
>
> In the migration windows mysql_install_db is shown as a green tick,
> and also is mysqld. But when I click on Migrate I get a pop up warning
> stating "Error while opening the target database" and command line says
>
> "digikam.dbengine: Error while opening the database. Error was
> QSqlError("", "Driver not loaded", "Driver not loaded")"
>
> mysql is up and running so I guess I am just missing something
> important, may someone give me a clue?
>
> Thx.
>
> BR,
>
>
> d.

[daniel bip]

Hi Simon,

I installed DK from Philip Johnsson's PPA.

If I try lo locate libqt5sql5-mysql I get this:

/usr/share/doc/libqt5sql5-mysql
/var/cache/apt/archives/libqt5sql5-mysql_5.5.1+dfsg-16ubuntu7.2_amd64.deb
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.list
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.md5sums

So, I tried apt-get install libqt5sql5-mysql and it did install something but it continues to crash, in a different way:

digikam.general: scan mode: ScanDeferredFiles
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.dbengine: ConnectOptions  "UNIX_SOCKET=/home/daniel/.local/share/digikam/db_misc/mysql.socket"
digikam.dbengine: Error while opening the database. Error was QSqlError("2002", "QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/daniel/.local/share/digikam/db_misc/mysql.socket' (2)")
digikam.general: total scan value :  97076

Thanks for helping!

BR,

d.

On 3 April 2017 at 20:43, Simon Frei <[hidden email]> wrote:

Hi,

Do you have the libqt5sql5-mysql package installed?
Or more generally, where do you install digiKam from?

Cheers,
Simon

On 03/04/17 19:11, daniel bip wrote:
> Hi there,
>
> May someone assist me in moving from sqlite to mysql internal?
>
> I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also installed
> mysql-server-5.7. I did nothing else (mysql is not setup in any way, I
> mean).
>
> In the migration windows mysql_install_db is shown as a green tick,
> and also is mysqld. But when I click on Migrate I get a pop up warning
> stating "Error while opening the target database" and command line says
>
> "digikam.dbengine: Error while opening the database. Error was
> QSqlError("", "Driver not loaded", "Driver not loaded")"
>
> mysql is up and running so I guess I am just missing something
> important, may someone give me a clue?
>
> Thx.
>
> BR,
>
>
> d.

[Simon Frei]

Cool, I remembered the first issue correctly :)
The error you get now I do seldomly get as well, when I manage to damage the database (outside of digikam). So as you said you are migrating, I would suggest removing everything related to the new mysql database and start a new clean migration from sqlite.

On 03/04/17 21:05, daniel bip wrote:

Hi Simon,

I installed DK from Philip Johnsson's PPA.

If I try lo locate libqt5sql5-mysql I get this:

/usr/share/doc/libqt5sql5-mysql
/var/cache/apt/archives/libqt5sql5-mysql_5.5.1+dfsg-16ubuntu7.2_amd64.deb
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.list
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.md5sums

So, I tried apt-get install libqt5sql5-mysql and it did install something but it continues to crash, in a different way:

digikam.general: scan mode: ScanDeferredFiles
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.dbengine: ConnectOptions  "UNIX_SOCKET=/home/daniel/.local/share/digikam/db_misc/mysql.socket"
digikam.dbengine: Error while opening the database. Error was QSqlError("2002", "QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/daniel/.local/share/digikam/db_misc/mysql.socket' (2)")
digikam.general: total scan value :  97076

Thanks for helping!

BR,

d.

On 3 April 2017 at 20:43, Simon Frei <[hidden email]> wrote:

Hi,

Do you have the libqt5sql5-mysql package installed?
Or more generally, where do you install digiKam from?

Cheers,
Simon

On 03/04/17 19:11, daniel bip wrote:
> Hi there,
>
> May someone assist me in moving from sqlite to mysql internal?
>
> I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also installed
> mysql-server-5.7. I did nothing else (mysql is not setup in any way, I
> mean).
>
> In the migration windows mysql_install_db is shown as a green tick,
> and also is mysqld. But when I click on Migrate I get a pop up warning
> stating "Error while opening the target database" and command line says
>
> "digikam.dbengine: Error while opening the database. Error was
> QSqlError("", "Driver not loaded", "Driver not loaded")"
>
> mysql is up and running so I guess I am just missing something
> important, may someone give me a clue?
>
> Thx.
>
> BR,
>
>
> d.

[daniel bip]

Hi Simon,

I'm not sure I really get it, may you explain that in a different way?

Thanks for you support.

BR,

d.

On 3 April 2017 at 21:18, Simon Frei <[hidden email]> wrote:

Cool, I remembered the first issue correctly :)
The error you get now I do seldomly get as well, when I manage to damage the database (outside of digikam). So as you said you are migrating, I would suggest removing everything related to the new mysql database and start a new clean migration from sqlite.

On 03/04/17 21:05, daniel bip wrote:

Hi Simon,

I installed DK from Philip Johnsson's PPA.

If I try lo locate libqt5sql5-mysql I get this:

/usr/share/doc/libqt5sql5-mysql
/var/cache/apt/archives/libqt5sql5-mysql_5.5.1+dfsg-16ubuntu7.2_amd64.deb
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.list
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.md5sums

So, I tried apt-get install libqt5sql5-mysql and it did install something but it continues to crash, in a different way:

digikam.general: scan mode: ScanDeferredFiles
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.dbengine: ConnectOptions  "UNIX_SOCKET=/home/daniel/.local/share/digikam/db_misc/mysql.socket"
digikam.dbengine: Error while opening the database. Error was QSqlError("2002", "QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/daniel/.local/share/digikam/db_misc/mysql.socket' (2)")
digikam.general: total scan value :  97076

Thanks for helping!

BR,

d.

On 3 April 2017 at 20:43, Simon Frei <[hidden email]> wrote:

Hi,

Do you have the libqt5sql5-mysql package installed?
Or more generally, where do you install digiKam from?

Cheers,
Simon

On 03/04/17 19:11, daniel bip wrote:
> Hi there,
>
> May someone assist me in moving from sqlite to mysql internal?
>
> I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also installed
> mysql-server-5.7. I did nothing else (mysql is not setup in any way, I
> mean).
>
> In the migration windows mysql_install_db is shown as a green tick,
> and also is mysqld. But when I click on Migrate I get a pop up warning
> stating "Error while opening the target database" and command line says
>
> "digikam.dbengine: Error while opening the database. Error was
> QSqlError("", "Driver not loaded", "Driver not loaded")"
>
> mysql is up and running so I guess I am just missing something
> important, may someone give me a clue?
>
> Thx.
>
> BR,
>
>
> d.

[Simon Frei]

Sorry, but in that case I need more information first: What do you want to do and what exactly are the steps you perform, before you get that error?

On 03/04/17 21:33, daniel bip wrote:

Hi Simon,

I'm not sure I really get it, may you explain that in a different way?

Thanks for you support.

BR,

d.

On 3 April 2017 at 21:18, Simon Frei <[hidden email]> wrote:

Cool, I remembered the first issue correctly :)
The error you get now I do seldomly get as well, when I manage to damage the database (outside of digikam). So as you said you are migrating, I would suggest removing everything related to the new mysql database and start a new clean migration from sqlite.

On 03/04/17 21:05, daniel bip wrote:

Hi Simon,

I installed DK from Philip Johnsson's PPA.

If I try lo locate libqt5sql5-mysql I get this:

/usr/share/doc/libqt5sql5-mysql
/var/cache/apt/archives/libqt5sql5-mysql_5.5.1+dfsg-16ubuntu7.2_amd64.deb
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.list
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.md5sums

So, I tried apt-get install libqt5sql5-mysql and it did install something but it continues to crash, in a different way:

digikam.general: scan mode: ScanDeferredFiles
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.dbengine: ConnectOptions  "UNIX_SOCKET=/home/daniel/.local/share/digikam/db_misc/mysql.socket"
digikam.dbengine: Error while opening the database. Error was QSqlError("2002", "QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/daniel/.local/share/digikam/db_misc/mysql.socket' (2)")
digikam.general: total scan value :  97076

Thanks for helping!

BR,

d.

On 3 April 2017 at 20:43, Simon Frei <[hidden email]> wrote:

Hi,

Do you have the libqt5sql5-mysql package installed?
Or more generally, where do you install digiKam from?

Cheers,
Simon

On 03/04/17 19:11, daniel bip wrote:
> Hi there,
>
> May someone assist me in moving from sqlite to mysql internal?
>
> I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also installed
> mysql-server-5.7. I did nothing else (mysql is not setup in any way, I
> mean).
>
> In the migration windows mysql_install_db is shown as a green tick,
> and also is mysqld. But when I click on Migrate I get a pop up warning
> stating "Error while opening the target database" and command line says
>
> "digikam.dbengine: Error while opening the database. Error was
> QSqlError("", "Driver not loaded", "Driver not loaded")"
>
> mysql is up and running so I guess I am just missing something
> important, may someone give me a clue?
>
> Thx.
>
> BR,
>
>
> d.

[daniel bip]

Hi Simon,

I'm trying to migrate from sqlite to mysql internal. What I do is just open Settings > Database migration, setup the right half of the screen accordingly and then press on Migrate. And then the error pops up...

Thx.

BR,
 

On 3 April 2017 at 21:36, Simon Frei <[hidden email]> wrote:

Sorry, but in that case I need more information first: What do you want to do and what exactly are the steps you perform, before you get that error?

On 03/04/17 21:33, daniel bip wrote:

Hi Simon,

I'm not sure I really get it, may you explain that in a different way?

Thanks for you support.

BR,

d.

On 3 April 2017 at 21:18, Simon Frei <[hidden email]> wrote:

Cool, I remembered the first issue correctly :)
The error you get now I do seldomly get as well, when I manage to damage the database (outside of digikam). So as you said you are migrating, I would suggest removing everything related to the new mysql database and start a new clean migration from sqlite.

On 03/04/17 21:05, daniel bip wrote:

Hi Simon,

I installed DK from Philip Johnsson's PPA.

If I try lo locate libqt5sql5-mysql I get this:

/usr/share/doc/libqt5sql5-mysql
/var/cache/apt/archives/libqt5sql5-mysql_5.5.1+dfsg-16ubuntu7.2_amd64.deb
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.list
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.md5sums

So, I tried apt-get install libqt5sql5-mysql and it did install something but it continues to crash, in a different way:

digikam.general: scan mode: ScanDeferredFiles
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.dbengine: ConnectOptions  "UNIX_SOCKET=/home/daniel/.local/share/digikam/db_misc/mysql.socket"
digikam.dbengine: Error while opening the database. Error was QSqlError("2002", "QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/daniel/.local/share/digikam/db_misc/mysql.socket' (2)")
digikam.general: total scan value :  97076

Thanks for helping!

BR,

d.

On 3 April 2017 at 20:43, Simon Frei <[hidden email]> wrote:

Hi,

Do you have the libqt5sql5-mysql package installed?
Or more generally, where do you install digiKam from?

Cheers,
Simon

On 03/04/17 19:11, daniel bip wrote:
> Hi there,
>
> May someone assist me in moving from sqlite to mysql internal?
>
> I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also installed
> mysql-server-5.7. I did nothing else (mysql is not setup in any way, I
> mean).
>
> In the migration windows mysql_install_db is shown as a green tick,
> and also is mysqld. But when I click on Migrate I get a pop up warning
> stating "Error while opening the target database" and command line says
>
> "digikam.dbengine: Error while opening the database. Error was
> QSqlError("", "Driver not loaded", "Driver not loaded")"
>
> mysql is up and running so I guess I am just missing something
> important, may someone give me a clue?
>
> Thx.
>
> BR,
>
>
> d.

[Simon Frei]

Ok, so go to the location that you select on the right half of the database migration window. Then delete everything there (except of course if you have other data than the mysql database there). Then try again.

On 03/04/17 21:41, daniel bip wrote:

Hi Simon,

I'm trying to migrate from sqlite to mysql internal. What I do is just open Settings > Database migration, setup the right half of the screen accordingly and then press on Migrate. And then the error pops up...

Thx.

BR,
 

On 3 April 2017 at 21:36, Simon Frei <[hidden email]> wrote:

Sorry, but in that case I need more information first: What do you want to do and what exactly are the steps you perform, before you get that error?

On 03/04/17 21:33, daniel bip wrote:

Hi Simon,

I'm not sure I really get it, may you explain that in a different way?

Thanks for you support.

BR,

d.

On 3 April 2017 at 21:18, Simon Frei <[hidden email]> wrote:

Cool, I remembered the first issue correctly :)
The error you get now I do seldomly get as well, when I manage to damage the database (outside of digikam). So as you said you are migrating, I would suggest removing everything related to the new mysql database and start a new clean migration from sqlite.

On 03/04/17 21:05, daniel bip wrote:

Hi Simon,

I installed DK from Philip Johnsson's PPA.

If I try lo locate libqt5sql5-mysql I get this:

/usr/share/doc/libqt5sql5-mysql
/var/cache/apt/archives/libqt5sql5-mysql_5.5.1+dfsg-16ubuntu7.2_amd64.deb
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.list
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.md5sums

So, I tried apt-get install libqt5sql5-mysql and it did install something but it continues to crash, in a different way:

digikam.general: scan mode: ScanDeferredFiles
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.dbengine: ConnectOptions  "UNIX_SOCKET=/home/daniel/.local/share/digikam/db_misc/mysql.socket"
digikam.dbengine: Error while opening the database. Error was QSqlError("2002", "QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/daniel/.local/share/digikam/db_misc/mysql.socket' (2)")
digikam.general: total scan value :  97076

Thanks for helping!

BR,

d.

On 3 April 2017 at 20:43, Simon Frei <[hidden email]> wrote:

Hi,

Do you have the libqt5sql5-mysql package installed?
Or more generally, where do you install digiKam from?

Cheers,
Simon

On 03/04/17 19:11, daniel bip wrote:
> Hi there,
>
> May someone assist me in moving from sqlite to mysql internal?
>
> I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also installed
> mysql-server-5.7. I did nothing else (mysql is not setup in any way, I
> mean).
>
> In the migration windows mysql_install_db is shown as a green tick,
> and also is mysqld. But when I click on Migrate I get a pop up warning
> stating "Error while opening the target database" and command line says
>
> "digikam.dbengine: Error while opening the database. Error was
> QSqlError("", "Driver not loaded", "Driver not loaded")"
>
> mysql is up and running so I guess I am just missing something
> important, may someone give me a clue?
>
> Thx.
>
> BR,
>
>
> d.

[daniel bip]

Hi there,

In the "Database migration" screen, right side, I set Type: "MySQL internal" and then, for whatever I write in the input field below (the one for the directory), I get the very same error (even if I leave it empty): the one I pasted below. DK just can't connect to MySQL.

How do I setup DK or MySQL to make them work smoothly together?

Thanks.

d.

On 3 April 2017 at 21:43, Simon Frei <[hidden email]> wrote:

Ok, so go to the location that you select on the right half of the database migration window. Then delete everything there (except of course if you have other data than the mysql database there). Then try again.

On 03/04/17 21:41, daniel bip wrote:

Hi Simon,

I'm trying to migrate from sqlite to mysql internal. What I do is just open Settings > Database migration, setup the right half of the screen accordingly and then press on Migrate. And then the error pops up...

Thx.

BR,
 

On 3 April 2017 at 21:36, Simon Frei <[hidden email]> wrote:

Sorry, but in that case I need more information first: What do you want to do and what exactly are the steps you perform, before you get that error?

On 03/04/17 21:33, daniel bip wrote:

Hi Simon,

I'm not sure I really get it, may you explain that in a different way?

Thanks for you support.

BR,

d.

On 3 April 2017 at 21:18, Simon Frei <[hidden email]> wrote:

Cool, I remembered the first issue correctly :)
The error you get now I do seldomly get as well, when I manage to damage the database (outside of digikam). So as you said you are migrating, I would suggest removing everything related to the new mysql database and start a new clean migration from sqlite.

On 03/04/17 21:05, daniel bip wrote:

Hi Simon,

I installed DK from Philip Johnsson's PPA.

If I try lo locate libqt5sql5-mysql I get this:

/usr/share/doc/libqt5sql5-mysql
/var/cache/apt/archives/libqt5sql5-mysql_5.5.1+dfsg-16ubuntu7.2_amd64.deb
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.list
/var/lib/dpkg/info/libqt5sql5-mysql:amd64.md5sums

So, I tried apt-get install libqt5sql5-mysql and it did install something but it continues to crash, in a different way:

digikam.general: scan mode: ScanDeferredFiles
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.general: Testing  "mysql_install_db" ...
digikam.general: Found  "mysql_install_db"
digikam.general: Testing  "mysqld" ...
digikam.general: Found  "mysqld"
digikam.dbengine: ConnectOptions  "UNIX_SOCKET=/home/daniel/.local/share/digikam/db_misc/mysql.socket"
digikam.dbengine: Error while opening the database. Error was QSqlError("2002", "QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/daniel/.local/share/digikam/db_misc/mysql.socket' (2)")
digikam.general: total scan value :  97076

Thanks for helping!

BR,

d.

On 3 April 2017 at 20:43, Simon Frei <[hidden email]> wrote:

Hi,

Do you have the libqt5sql5-mysql package installed?
Or more generally, where do you install digiKam from?

Cheers,
Simon

On 03/04/17 19:11, daniel bip wrote:
> Hi there,
>
> May someone assist me in moving from sqlite to mysql internal?
>
> I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also installed
> mysql-server-5.7. I did nothing else (mysql is not setup in any way, I
> mean).
>
> In the migration windows mysql_install_db is shown as a green tick,
> and also is mysqld. But when I click on Migrate I get a pop up warning
> stating "Error while opening the target database" and command line says
>
> "digikam.dbengine: Error while opening the database. Error was
> QSqlError("", "Driver not loaded", "Driver not loaded")"
>
> mysql is up and running so I guess I am just missing something
> important, may someone give me a clue?
>
> Thx.
>
> BR,
>
>
> d.