<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Since I'm just starting out with digikam I thought this was the time to experiment with migrating to mysql. On the configuration screen digiKam can find the binary for mysql_install_db but not mysqld. mysqld is installed and when I use 'find' to tell it that the binary is in /usr/sbin/mysqld it looks promising.</p>
<p>However, trying to migrate the database gives the pop-up error window:
</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
An error occurred during the internal server start.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Details: Could not start database initialiser.</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Executable: mysql_install_db</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Arguments: --datadir=/store1/images/.mysql.digikam/db_data, --defaults-file=/tmp/.mount_digikaJbT7bS/usr/share/digikam/database/mysql-global.conf</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Process error: Unknown error</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">and on the command line I see:</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Digikam::DatabaseServer::processErrorLog: Arguments: "--datadir=/store1/images/.mysql.digikam/db_data, --defaults-file=/tmp/.mount_digikaJbT7bS/usr/share/digikam/database/mysql-global.conf"
Digikam::DatabaseServer::processErrorLog: Stdout: "Neither host 'office' nor 'localhost' could be looked up with\n'/usr/sbin/resolveip'\nPlease configure the 'hostname' command to return a correct\nhostname.\nIf you want to solve this at a later stage, restart this script\nwith the --force option\n\nThe latest information about mysql_install_db is available at\nhttps://mariadb.com/kb/en/installing-system-tables-mysql_install_db\n"</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">which is a bit off. resolveip is a command I didn't know existed but running it returns a local IP address for my host.</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Performance using sqlite seems ok, and at just over 100k images I'm probably a borderline case so I thought I would try the mysql database option out of curiosity.
</p>
<p style=" margin-top:12px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<p><style type="text/css">
p, li { white-space: pre-wrap; }
</style></p>
</body>
</html>