[digiKam-users] mysql for mac os

[Maik Qualmann]

Gilles,

this console log is not starting a session with non-existent MySQL data 
directory. Can you clean everything up again and post the log? Here already a 
corrupt digiKam database must have been created and an attempt is made to 
update from version 0, which of course fails because such an update procedure 
does not exist.

Maik

Am Samstag, 19. Mai 2018, 07:47:48 CEST schrieb Gilles Caulier:
> Maik,
> 
> All is in place now to run Mariadb internal server under MacOS.
> 
> The missing files are fixed, the crash is fixed, but the database init fail
> at first run :
> 
> bash-3.2$ ./digikam
> 
> digikam.widgets: Breeze icons resource file found
> 
> digikam.general: "/Users/gilles/Pictures"
> 
> digikam.general: Testing  "mysql_install_db" ...
> 
> digikam.general: Testing  "mysqld" ...
> 
> digikam.general: Testing  "mysql_install_db" ...
> 
> digikam.general: Testing  "mysqld" ...
> 
> digikam.general: Testing  "/opt/local/bin/mysql_install_db" ...
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/local/bin/mysqld" ...
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/local/sbin/mysql_install_db" ...
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/local/sbin/mysqld" ...
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysql_install_db" ...
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/local/lib/mariadb/bin/mysqld" ...
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/digikam/bin/mysql_install_db" ...
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/digikam/bin/mysqld" ...
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/digikam/sbin/mysql_install_db" ...
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/digikam/sbin/mysqld" ...
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/digikam/lib/mariadb/bin/mysql_install_db"
> ...
> 
> digikam.general: Found  "/opt/digikam/lib/mariadb/bin/mysql_install_db"
> 
> digikam.general: All Binaries Found :  false
> 
> digikam.general: Testing  "/opt/digikam/lib/mariadb/bin/mysqld" ...
> 
> digikam.general: Found  "/opt/digikam/lib/mariadb/bin/mysqld"
> 
> digikam.general: All Binaries Found :  true
> 
> digikam.general: Root album is :  "/Users/gilles/Pictures"
> 
> digikam.database: Database directory is :  "/Users/gilles/Pictures"
> 
> digikam.dbengine: Loading SQL code from config file
> "/opt/digikam/Applications/KF5/digikam.app/Contents/Resources//digikam/datab
> ase/dbconfig.xml"
> 
> digikam.dbengine: Checking XML version ID => expected:  3  found:  3
> 
> digikam.dbengine: ConnectOptions
> "UNIX_SOCKET=/Users/gilles/Library/Application
> Support/digikam/digikam/db_misc/mysql.socket"
> 
> digikam.dbengine: ConnectOptions
> "UNIX_SOCKET=/Users/gilles/Library/Application
> Support/digikam/digikam/db_misc/mysql.socket"
> 
> digikam.general: AlbumWatch use QFileSystemWatcher
> 
> digikam.general: Database Parameters:
> 
>    Type:                     "QMYSQL"
> 
>    DB Core Name:             "digikam"
> 
>    DB Thumbs Name:           "digikam"
> 
>    DB Face Name:             "digikam"
> 
>    DB Similyritiy 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 Serv Cmd: "/opt/digikam/lib/mariadb/bin/mysqld"
> 
>    Internal Server Init Cmd: "/opt/digikam/lib/mariadb/bin/mysql_install_db"
> 
>    Username:                 "root"
> 
>    Password:                 ""
> 
> 
> digikam.databaseserver: Database Parameters:
> 
>    Type:                     "QMYSQL"
> 
>    DB Core Name:             "digikam"
> 
>    DB Thumbs Name:           "digikam"
> 
>    DB Face Name:             "digikam"
> 
>    DB Similyritiy 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 Serv Cmd: "/opt/digikam/lib/mariadb/bin/mysqld"
> 
>    Internal Server Init Cmd: "/opt/digikam/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 is outdated,
> "/Users/gilles/Library/Application Support/digikam/digikam/mysql.conf" will
> be updated.
> 
> digikam.databaseserver: Updated mysql configuration with
> "/opt/digikam/Applications/KF5/digikam.app/Contents/Resources//digikam/datab
> ase/mysql-global.conf"
> 
> digikam.databaseserver: Fixed permissions of mysql configuration file.
> 
> digikam.databaseserver: Database server:
> "/opt/digikam/lib/mariadb/bin/mysqld"
> ("--defaults-file=/Users/gilles/Library/Application
> Support/digikam/digikam/mysql.conf",
> "--datadir=/Users/gilles/Pictures/.mysql.digikam/db_data",
> "--socket=/Users/gilles/Library/Application
> Support/digikam/digikam/db_misc/mysql.socket")
> 
> digikam.databaseserver: Internal database server started
> 
> digikam.databaseserver: Running 0 seconds...
> 
> digikam.coredb: Core database: running schema update
> 
> digikam.coredb: Core database: have a structure version  0
> 
> digikam.coredb: Core database: version not available! Giving up schema
> upgrading.
> 
> digikam.coredb: Core database: cannot process schema initialization
> 
> digikam.databaseserver: Running 30 seconds...
> 
> Why ?
> 
> Gilles
> 
> 2018-05-17 18:42 GMT+02:00 guy <audebert.guy at orange.fr>:
> > Good evening
> > Thank you for your responsiveness, but there is a new mistake.
> > 
> > 
> > 
> > Guy Audebert
> > 
> > 
> > 
> > 
> > Le 17 mai 2018 à 17:49, Gilles Caulier <caulier.gilles at gmail.com> a écrit
> > 
> > 
> > New PKG version uploaded. Please test....
> > 
> > Gilles Caulier