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 <[email protected]>
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!
_______________________________________________
macports-users mailing list
[email protected]
https://lists.macosforge.org/mailman/listinfo/macports-users
