[Digikam-users] Fix for MySQl problems.

[Piter Dias]

I moved my installation to mysql weeks ago and I am very happy with results.

The use is both local (Ubuntu 13.10) and remote (Windows 8 and 8.1).

What we can compare to understand why it seems to work ok for me and not for other people?

--- Mensagem Original ---

De: "upscope" <upscope at nwi.net>
Enviado: 8 de outubro de 2014 18:09
Para: digikam-users at kde.org
Assunto: Re: [Digikam-users] Fix for MySQl problems.

On Wednesday, October 08, 2014 07:21:22 PM eric wrote:
> Hello,
>
> Should you monitoring your mysql server with mytop and see whats
> happening when you open digikam ?
>
> mytop : http://linux.die.net/man/1/mytop
>
> It should hang because of the number of connection (I have had the
> things when tuning mysql)
>
> Greatings,
>
> Eric
>
> Le mercredi 08 octobre 2014 à 09:02 -0700, upscope a écrit :
> > Doses anyone know if there is a fix for the 4.X versions of digikam
> > so they will work with MySQL?. I've been having trouble since 4.0.
> > On start up Digikam starts and as soon as it tries to access the
> > DB, it hangs the whole system.
> >
> > No error messages, only way to restart is by the power button. Here
> > is what I have installed:
> >
> > [CODE]
> > ~> rpm -qa |grep mysql
> > libmysqlclient18-5.5.33-2.2.x86_64
> > libmysqld18-5.5.33-2.2.x86_64
> > php5-mysql-5.6.0-248.3.x86_64
> > libqt5-sql-mysql-5.1.1-6.7.x86_64
> > libmysqlclient_r18-5.5.33-2.2.x86_64
> > libmysqlcppconn6-1.1.2-40.1.x86_64
> > libmysqlclient-devel-5.5.33-2.2.x86_64
> > libqt4-sql-mysql-4.8.5-5.13.1.x86_64
> > libreoffice-base-drivers-mysql-4.2.6.2-17.1.x86_64
> > [/CODE]
> >
> > My sql itself is working fine. I can log in through phpMyAdmin or
> > from the command line and see all the data that was put into the
> > database prior to digikam 4.0. Also all other databases I have are
> > also working.
> >
> > I've checked the password and user privileges. All correct.
> >
> > I can tell you I've been using mysql with digikam since it was first
> > made available with know problems. Also I know a bug report was
> > opened on this problem by someone else.
> >
> > I run mysql on localhost, no network access. Let me know what other
> > information I can provide or tests I can run.
> >
> > Thanks
> >
> > Russ
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users

Thanks for the responses. As I am the only user at this time have all
privileges including grant. I don't think the number of sessions is a
problem. I have set Digikam to use my idea for the testing. Since 4.0 it
even hangs trying to set the user and password from Digikam.
3.5 was working fine.

I'll look into the above moniyor and see if that shows anything. Are
there any Digikam error logs?

Is there some way to transfer a mysql dump to sqlite and then change
Digikam to use it?

Thanks again.

Russ
--
openSUSE 13.1(Linux 3.11.10-21-desktop x86_64|
Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3|
GeForce 8400GS (NVIDIA-Linux-x86_64-340.32)|KDE 4.14.1

_______________________________________________
Digikam-users mailing list
Digikam-users at kde.org
https://mail.kde.org/mailman/listinfo/digikam-users