[Digikam-users] Mysql/MariaDb database expert needs...

[Gilles Caulier]

2015-11-11 12:58 GMT+01:00 Piter Dias <piter.dias at piterdias.com>:

> I use digikam under Windows and mysql as database (in a Linux box).
>
> What do you need? Someone to test?
>
More than testing.

The main problem is the first step of migration from sqlite (the initial DB
set at first run) to a local mysql (using internal server).

Currently the migration stop in the middle due to strange error reported by
mysql (Mariadb here) :

[gilles at localhost database]$ mysql --version
mysql  Ver 15.1 Distrib 10.0.21-MariaDB, for Linux (x86_64) using readline
5.1

I suppose some ImmoDb incompatibilities with digiKam sql statements to
create indexes (tables are created).

[gilles at localhost data]$ digikam
digikam.general: AlbumWatch use QFileSystemWatcher
digikam.general: DatabaseParameters: [ Type "QMYSQL", Name "digikam"
(Thumbnails Name "digikam"); (Face Name "digikam"); ConnectOptions:
"UNIX_SOCKET=/home/gilles/.local/share/digikam/db_misc/mysql.socket", Using
an Internal Server; Username and Password: "root", ""]
digikam.databaseserver: Waiting  10  seconds...stop: [ false ]
digikam.database: Loading SQL code from config file
"/usr/share/digikam/database/dbconfig.xml"
digikam.database: Checking XML version ID:  false "3" 3 3
digikam.database: ConnectOptions
 "UNIX_SOCKET=/home/gilles/.local/share/digikam/db_misc/mysql.socket"
digikam.databaseserver: Failed to use database "digikam"
digikam.databaseserver: Query error: "Unknown database 'digikam' QMYSQL:
Unable to execute query"
digikam.databaseserver: Database error: "Can't connect to local MySQL
server through socket
'/home/gilles/.local/share/digikam/db_misc/mysql.socket' (2 \"No such file
or directory\") QMYSQL: Unable to connect"
digikam.databaseserver: Trying to create database now...
digikam.databaseserver: Database was successfully created
digikam.database: Loading SQL code from config file
"/usr/share/digikam/database/dbconfig.xml"
digikam.database: Checking XML version ID:  false "3" 3 3
digikam.database: SchemaUpdater update
digikam.database: No database file available
digikam.database: Failure executing query:
 ""
Error messages: "QMYSQL: Unable to execute query" "Table 'mysql.proc'
doesn't exist" 1146 2
Bound values:  ()
digikam.database: Error while executing DBAction [ "CreateIndices" ]
Statement [ "\n                    DROP PROCEDURE IF EXISTS
create_index_if_not_exists;\n                " ]
digikam.databaseserver: At least service [ "org.kde.digikam.startup-8291" ]
is using the database server
digikam.databaseserver: Waiting  10  seconds...stop: [ false ]

Can you reproduce this problem to a fresh account ?

Gilles Caulier
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20151111/149aa714/attachment.html>