[digikam] [Bug 462736] Connection to external Mysql-Server fails

[bugzilla_noreply at kde.org]

https://bugs.kde.org/show_bug.cgi?id=462736

--- Comment #55 from caulier.gilles at gmail.com ---
Maik,

Under macOS i use now the standard mariadb port to compile qt mysql database
plugin.

(1) https://ports.macports.org/port/mariadb/

Look well the release number : 5.5.68

Previously, i used this one:

(2) https://ports.macports.org/port/mariadb-10.5/

...with the release number: 10.5.18 

(1) do not work with an internal server database where (2) works as expected.
The error messages from a console are :

digikam.databaseserver: Database Parameters:
   Type:                      "QMYSQL"
   DB Core Name:              "digikam"
   DB Thumbs Name:            "digikam"
   DB Face Name:              "digikam"
   DB Similarity Name:        "digikam"
   Connect Options:           "UNIX_SOCKET=/Users/gilles/Library/Application
Support/digikam/digikam/db_misc/mysql.socket"
   Host Name:                 ""
   Host port:                 -1
   Internal Server:           true
   Internal Server Path:      "/Users/gilles/Pictures/"
   Internal Server Admin Cmd:
"/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqladmin"
   Internal Server Serv Cmd: 
"/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld"
   Internal Server Init Cmd: 
"/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysql_install_db"
   Username:                  "root"
   Password:                  ""

digikam.databaseserver: Internal Server data path:
"/Users/gilles/Pictures/.mysql.digikam/db_data"
digikam.databaseserver: The mysql configuration was already up-to-date:
"/Users/gilles/Library/Application Support/digikam/digikam/mysql.conf"
digikam.databaseserver: Database server:
"/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld"
("--defaults-file=/Users/gilles/Library/Application
Support/digikam/digikam/mysql.conf",
"--datadir=/Users/gilles/Pictures/.mysql.digikam/db_data",
"--basedir=/Applications/digiKam.org/digikam.app/Contents//lib/mariadb/",
"--socket=/Users/gilles/Library/Application
Support/digikam/digikam/db_misc/mysql.socket")
digikam.databaseserver: "Database process exited unexpectedly during initial
connection."
digikam.databaseserver: Executable:
"/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld"
digikam.databaseserver: Arguments:
"--defaults-file=/Users/gilles/Library/Application
Support/digikam/digikam/mysql.conf,
--datadir=/Users/gilles/Pictures/.mysql.digikam/db_data,
--basedir=/Applications/digiKam.org/digikam.app/Contents//lib/mariadb/,
--socket=/Users/gilles/Library/Application
Support/digikam/digikam/db_misc/mysql.socket"
digikam.databaseserver: Stdout: ""
digikam.databaseserver: Stderr: "230216  7:30:01 [Warning] options
--log-slow-admin-statements, --log-queries-not-using-indexes and
--log-slow-slave-statements have no effect if --log_slow_queries is not
set\n230216  7:30:01 [Note]
/Applications/digiKam.org/digikam.app/Contents/lib/mariadb/bin/mysqld (mysqld
5.5.68-MariaDB) starting as process 25388 ...\n230216  7:30:01 [Warning]
Setting lower_case_table_names=2 because file system for
/Users/gilles/Pictures/.mysql.digikam/db_data/ is case insensitive\n"
digikam.databaseserver: Exit code: 1
digikam.databaseserver: Process error: "Unknown error"
digikam.databaseserver: Cannot start internal database server

I can conclude that mariadb 5 is not compatible with Qt5.15.8 currently
available in macports.

What i found strange is the rules to compile qt mysql plugin: by default
macports use mariadb 5, not 10. Why if 5 is not compatible ? (i suspect that
nobody has already tested this from macports team).

Note : the Alex problem is different as it use a remote mysql server as
database.

Gilles

-- 
You are receiving this mail because:
You are watching all bug changes.