<div dir="ltr"><div><div><div><div>Hi there,<br><br></div>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.<br><br></div>How do I setup DK or MySQL to make them work smoothly together?<br><br></div>Thanks.<br><br><br></div>d.<br><br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On 3 April 2017 at 21:43, Simon Frei <span dir="ltr"><<a href="mailto:freisim93@gmail.com" target="_blank">freisim93@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
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.<div><div class="h5"><br>
<br>
<div class="m_3353825213389527141moz-cite-prefix">On 03/04/17 21:41, daniel bip wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>Hi Simon,<br>
<br>
</div>
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...<br>
<br>
</div>
Thx.<br>
<br>
</div>
BR,<br>
<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 3 April 2017 at 21:36, Simon Frei <span dir="ltr"><<a href="mailto:freisim93@gmail.com" target="_blank">freisim93@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> 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?
<div>
<div class="m_3353825213389527141h5"><br>
<br>
<div class="m_3353825213389527141m_4005523021130352123moz-cite-prefix">On
03/04/17 21:33, daniel bip wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>Hi Simon,<br>
<br>
</div>
I'm not sure I really get it, may you
explain that in a different way?<br>
<br>
</div>
Thanks for you support.<br>
<br>
</div>
BR,<br>
<br>
<br>
</div>
d.<br>
<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 3 April 2017 at 21:18,
Simon Frei <span dir="ltr"><<a href="mailto:freisim93@gmail.com" target="_blank">freisim93@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Cool, I
remembered the first issue correctly :)<br>
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.
<div>
<div class="m_3353825213389527141m_4005523021130352123h5"><br>
<br>
<div class="m_3353825213389527141m_4005523021130352123m_4533405178786748195moz-cite-prefix">On
03/04/17 21:05, daniel bip wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>Hi Simon,<br>
<br>
</div>
I installed DK from Philip
Johnsson's PPA.<br>
<br>
</div>
If I try lo locate
libqt5sql5-mysql I get this:<br>
<br>
/usr/share/doc/libqt5sql5-mysq<wbr>l<br>
/var/cache/apt/archives/libqt5<wbr>sql5-mysql_5.5.1+dfsg-16ubuntu<wbr>7.2_amd64.deb<br>
/var/lib/dpkg/info/libqt5sql5-<wbr>mysql:amd64.list<br>
/var/lib/dpkg/info/libqt5sql5-<wbr>mysql:amd64.md5sums<br>
<br>
</div>
So, I tried apt-get install
libqt5sql5-mysql and it did
install something but it continues
to crash, in a different way:<br>
<br>
digikam.general: scan mode:
ScanDeferredFiles<br>
digikam.general: Testing
"mysql_install_db" ...<br>
digikam.general: Found
"mysql_install_db"<br>
digikam.general: Testing "mysqld"
...<br>
digikam.general: Found "mysqld"<br>
digikam.general: Testing
"mysql_install_db" ...<br>
digikam.general: Found
"mysql_install_db"<br>
digikam.general: Testing "mysqld"
...<br>
digikam.general: Found "mysqld"<br>
digikam.dbengine: ConnectOptions
"UNIX_SOCKET=/home/daniel/.loc<wbr>al/share/digikam/db_misc/mysql<wbr>.socket"<br>
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/dig<wbr>ikam/db_misc/mysql.socket'
(2)")<br>
digikam.general: total scan value
: 97076<br>
<br>
</div>
<br>
<div class="gmail_extra">Thanks for
helping!<br>
<br>
</div>
<div class="gmail_extra">BR,<br>
<br>
</div>
<div class="gmail_extra"><br>
</div>
<div class="gmail_extra">d.<br>
<br>
<br>
</div>
<div class="gmail_extra">
<div class="gmail_quote">On 3
April 2017 at 20:43, Simon Frei
<span dir="ltr"><<a href="mailto:freisim93@gmail.com" target="_blank">freisim93@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
Do you have the
libqt5sql5-mysql package
installed?<br>
Or more generally, where do
you install digiKam from?<br>
<br>
Cheers,<br>
Simon<br>
<div class="m_3353825213389527141m_4005523021130352123m_4533405178786748195HOEnZb">
<div class="m_3353825213389527141m_4005523021130352123m_4533405178786748195h5"><br>
<br>
On 03/04/17 19:11, daniel
bip wrote:<br>
> Hi there,<br>
><br>
> May someone assist me
in moving from sqlite to
mysql internal?<br>
><br>
> I'm running Ubuntu
16.04 LTS and DK 5.5.0. I
also installed<br>
> mysql-server-5.7. I
did nothing else (mysql is
not setup in any way, I<br>
> mean).<br>
><br>
> In the migration
windows mysql_install_db
is shown as a green tick,<br>
> and also is mysqld.
But when I click on
Migrate I get a pop up
warning<br>
> stating "Error while
opening the target
database" and command line
says<br>
><br>
> "digikam.dbengine:
Error while opening the
database. Error was<br>
> QSqlError("", "Driver
not loaded", "Driver not
loaded")"<br>
><br>
> mysql is up and
running so I guess I am
just missing something<br>
> important, may
someone give me a clue?<br>
><br>
> Thx.<br>
><br>
> BR,<br>
><br>
><br>
> d.<br>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br></div>