Moving from sqlite to mysql failure

[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 <freisim93 at gmail.com
> <mailto: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/e19d1837/attachment.html>