Moving from sqlite to mysql failure

[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 <freisim93 at gmail.com> 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 <freisim93 at gmail.com> 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 <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-16ubuntu
>>> 7.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/.loc
>>> al/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/a69a4d52/attachment.html>