Moving from sqlite to mysql failure

[Simon Frei]

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
> <mailto: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
>>     <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/561eefa5/attachment.html>