Moving from sqlite to mysql failure

[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 <freisim93 at gmail.com> 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 <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/0e7a5529/attachment.html>