[Digikam-users] Re: Database on Mysql on localhost.

[upscope]

On Sunday, May 15, 2011 11:37:16 PM Gilles Caulier wrote:
> I can only said that a lots of problem with Mysql support have been
> fixed in current implementation from git master (next 2.0.0-beta6),
> by Francesco...
> 
> i can only recommend to compile and test this version on your
> computer, if you want to use MySql in production...
Just downloaded and tried to compile the latest Digikam git versionI 
found on your site. The cmake command gave me errors on several 
libraries that it said were not installed. In checking they are 
installed but have different version numbers in there name.

Example
<Code>
----------
rpm -q libkipi
package libkipi is not installed

rpm -q libkipi8
libkipi8-4.6.3-4.2.x86_64
</Code>
------------

<Code>
----------

libkipi8 - KDE Image Plug-In Interface

/usr/lib64/libkipi.so.8
/usr/lib64/libkipi.so.8.0.0
/usr/share/icons/hicolor/128x128/apps/kipi.png
/usr/share/icons/hicolor/16x16/apps/kipi.png
/usr/share/icons/hicolor/22x22/apps/kipi.png
/usr/share/icons/hicolor/32x32/apps/kipi.png
/usr/share/icons/hicolor/48x48/apps/kipi.png
/usr/share/kde4/apps/kipi
/usr/share/kde4/apps/kipi/data
/usr/share/kde4/apps/kipi/data/kipi-icon.svg
/usr/share/kde4/apps/kipi/data/kipi-logo.svg
/usr/share/kde4/apps/kipi/data/kipi-plugins_logo.png
/usr/share/kde4/servicetypes/kipiplugin.desktop

13 files total
</Code>
-----------


I have not done much compiling and what I ahve done did not use git 
versions. Do I need to change something in the CMakeLists.txt or 
CMakeFiles.txt?

I used  cmake .. -DCMAKE_INSTALL_PREFIX=/usr/

Remember I am on openSUSE 11.4 (2.6.37.6-0.5-desktop)

Any help is appreciated. I want to see if this will correct my problem 
accessing the mysql database on localhost. 

Thanks for your responses so far.

> Gilles Caulier
> 
> 2011/5/16 upscope <upscope at nwi.net>:
> > digikam-1.9.0-77.26.x86_64
> > 
> > digikam-lang-1.9.0-77.26.noarch
> > 
> > digikam-debuginfo-1.9.0-77.26.x86_64
> > 
> > See Signature for rest of Hardware/Software configuration.
> > 
> > I cannot connect to the MySQL database I have installed on
> > local-host.
> > 
> > When I first start digikam I get an error. After checking
> > configuration, and clicking test connection I get the following
> > error:
> > 
> > <Code>
> > 
> > -------------
> > 
> > Database connection test was not successful.
> > 
> > Error was: Can't connect to local MySQL server through socket
> > '/home/finemanruss/.kde4/share/apps/digikam/db_misc/mysql.socket'
> > (2) MYSQL: Unable to connect
> > 
> > </Code>
> > 
> > -------------
> > 
> > <Code>
> > 
> > -------------
> > 
> > Internal Server: unchecked
> > 
> > Database Settings are:
> > 
> > Type: MySQL
> > 
> > Host Name: local-host
> > 
> > Port: 3306
> > 
> > Schema Name: digikam
> > 
> > Thumbnails: digikam
> > 
> > user: xxxxxxxxxx
> > 
> > Password: xxxxxxxxxx
> > 
> > where xxxxxxxx is actual user name and password for MySQL server.
> > 
> > Database Connection options:
> > UNIX_SOCKET=/home/finemanruss/.kde4/share/apps/digikam/db_misc/MySQ
> > L.socket
> > 
> > <Code>
> > 
> > ----------------
> > 
> > Questions:
> > 
> > 1) If I check the above folder, there is no MySQL.socket in the
> > location shown. Should the install put a MySQL socket there?
> > 
> > (Not Amarok puts one in there location).
> > 
> > 2) Is the port correct? Its the one Amarok and KMyMoney use
> > successfully.
> > 
> > If I check Internal Sever on the database configuration screen in
> > digikam, it connect to it a local database and works fine.
> > 
> > I've looked at the Digikam website and searched for information on
> > configuring the database but found very little.
> > 
> > Any help would be appreciated.
> > 
> > Thank you!
> > 
> > Russ
> > 
> > openSUSE 11.4 MS1 (2.6.37.6-0.5-desktop)|Platform Version 4.6.3
> > (4.6.3) "release 4"|Intel core2duo 2.5 MHZ,|8GB DDR3|GeForce
> > 8400GS (NVIDIA-Linux-x86_64-270.41.06,
> > 
> > _______________________________________________
> > Digikam-users mailing list
> > Digikam-users at kde.org
> > https://mail.kde.org/mailman/listinfo/digikam-users
> 
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20110519/e7cac038/attachment.html>