Moving from sqlite to mysql failure

[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 <freisim93 at gmail.com> 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.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20170403/413d7c7c/attachment.html>