Database on Mysql on localhost.
Locked
 
|
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/MySQL.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 [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: Database on Mysql on localhost.
|
|
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... Gilles Caulier 2011/5/16 upscope <[hidden email]>: > 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/MySQL.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 > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > > Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
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> ----------
/usr/lib64/libkipi.so.8 </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 <[hidden email]>: > > 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 > > [hidden email] > > https://mail.kde.org/mailman/listinfo/digikam-users > > _______________________________________________ > Digikam-users mailing list > https://mail.kde.org/mailman/listinfo/digikam-users _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
| Free forum by Nabble | Edit this page |