Installing mysql for digikam

[David Lyon]

Well, I guess I have created another conundrum. The reference you  
provided, I erroneously assumed that the Host Name was the one associated  
with the port # (3306) you provided. So I, after failing with  
"localhost",  entered 192.168.1.11 as the Host Name but apparently it is  
not correct, as digikam is not opening and provided the error message  
below.

I think if I can find the correct items for Host Name; Port: my user name:  
and my password; digikam should work. When I was configuring mysql last  
evening, I received an indication that my mysql ID was "10". I reset the  
password successfully and was confirmed. Any suggestions or guidance will  
be appreciated.
thanks,
David
Error Message
bash-3.2$ /Applications/MacPorts/KDE4/digikam.app/COntents/MacOS/digikam
digikam(4634)/digikam (core) Digikam::AlbumWatch::connectToKDirWatch:  
KDirWatch method =  "FAM"
digikam(4634)/digikam (core) Digikam::AlbumManager::setDatabase:  
DatabaseParameters: [ Type "QMYSQL", Name "digikam" (Thumbnails Name  
"thumbnails-digikam"); Host Name and Port: "192.168.1.11" 3306; Username  
and Password: "10", "selkirk"]
digikam(4634)/digikam (core): Error while opening the database. Error  
details [ QSqlError(2003, "QMYSQL: Unable to connect", "Can't connect to  
MySQL server on '192.168.1.11' (60)") ]
2013-12-12 09:59:41.189 digikam[4634:507] modalSession has been exited  
prematurely - check for a reentrant call to endModalSession:
digikam(4634)/digikam (core): Error while opening the database. Error  
details [ QSqlError(2003, "QMYSQL: Unable to connect", "Can't connect to  
MySQL server on '192.168.1.11' (60)") ]
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still  
in use, all queries will cease to work.




On Wed, 11 Dec 2013 20:36:25 -0500, Ryan Schmidt <ryandesign at macports.org>  
wrote:

>
> On Dec 11, 2013, at 17:58, David Lyon wrote:
>
>> OK-- one small step which is probably the critical one has been  
>> missing. I have attached the log from XQuartx and a screen shot of the  
>> set up within digikam once it's opened which requires the mysql server  
>> set up.
>> I have never made it to this point and saw the necessity of setting the  
>> preferences for mysql server. If someone can help me understand the  
>> answers to: Host Name:
>> 		           Port:
>> my user ID for mysql is known as is my pssword
>> Anything required in the "Datbase Connections Options"?
>> I think that will provide a stable program.
>
> If the MySQL server is running on the same computer on which you want to  
> run digikam, then the hostname should be “localhost”, otherwise the  
> hostname should be the hostname or IP address of the computer running  
> the MySQL server. The port should be the default MySQL server port,  
> which is 3306.
>
> The username should be a valid MySQL username on your MySQL server; the  
> server comes preconfigured with a single user, “root”, with its password  
> set to the empty string. Since the root account is the administrator  
> account which can be used to do anything on your server, including  
> reading or deleting all data, you should secure it against unauthorized  
> access by changing the MySQL server’s root password to something else  
> (the MAMP page includes instructions for doing so). Having done this,  
> you could fill “root” and the MySQL root account’s password into  
> digikam. Alternately, if you’re going to use your MySQL server for other  
> things as well, you may want to make a separate MySQL account for  
> digikam and use that.
>
> I don’t know what kind of “database connection options” they’re  
> referring to. I’d try leaving them blank, or finding the digikam  
> documentation to see what kinds of options you can use and if any of  
> them would be useful to you.
>
> Your screen shot showed you filled in the value  
> “/Users/David/Desktop/PICS TO PRACTICS” into the two fields “Schema  
> Name” and “Thumbnails Schema Name”. This is probably not correct. A  
> schema name in MySQL is a database name; it’s asking you what names you  
> want it to use when creating the databases in your MySQL server.  
> Alternately, you might need to create them yourself, and then tell it  
> here what names you used; I’m not sure; you’d have to consult the  
> digikam documentation. I would make up two database names and fill them  
> in and see what happens. Either it’ll create them and use them, or it’ll  
> complain that they don’t exist, in which case you’ll need to create them.
>
>
> You should probably read a digikam-specific tutorial about this. I found  
> this one about setting it up to use MySQL:
>
> http://userbase.kde.org/Digikam/Using_digiKam_with_MySQL
>
> It also says it’s not necessary, and that usually it uses SQLite  
> instead, which requires no setup. It says:
>
> “Of course, you might wonder why you’d want to switch to MySQL when  
> SQLite already does a good job of managing the data? Using MySQL as  
> digiKam’s database back-end allows you to store the data on a remote  
> server. This way, you can use multiple digiKam installations (e.g., on  
> your notebook and desktop machine) to access and manage your photo  
> collections.”
>
> So if that’s something you want to do, then using MySQL is a good idea.
>


-- 
Using Opera's mail client: http://www.opera.com/mail/

-------------------------------------------------

VFEmail.net - http://www.vfemail.net
ONLY AT VFEmail! - Use our Metadata Mitigator to keep your email out of the NSA's hands!
$24.95 ONETIME Lifetime accounts with Privacy Features!  
15GB disk! No bandwidth quotas!
Commercial and Bulk Mail Options!