[Digikam-users] Fix for MySQl problems.

[upscope]

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