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

[Gilles Caulier]

At least, somebody can said me if an internal Mysql solution is suitable or
not without to hack the DB installation outside digiKam.

I read all bugzilla entries, and to setup Mysql, users need to grant
privileges by hand before to configure digiKam with it.

This is not possible to do the same with an internal server, since few
years ago, Mysql switch DB engine to ImmoDB which require granted privilege
to create DB indexes. And this is typically the problem that i can see when
i want to create the MySql DB through the internal server.

If i look how Amarok do with Mysql, internal server solution do not exist.
Only a remote server is avaialble in setup.

After all, it's logic. If you want an internal server, Sqlite is already
implemented and robust. Mysql must be only dedicated for remote storage.

I deducted that Mysql internal server must be removed from digiKam.

Gilles Caulier

2015-11-12 10:30 GMT+01:00 Wolfgang Mader <Wolfgang_Mader at brain-frog.de>:

> On Wednesday 11 November 2015 16:59:00 Gilles Caulier wrote:
> > 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) :
>
> Hi Gilles,
>
> thanks for tackling the database issue. I want to let you know, that this
> effort is highly appreciated.
>
> Unfortunately, I can not help you here, since my sql is rusty, too. But,
> maybe, you can ask on kde-devel. As you surely know, there are the baloo
> guys
> around, and I guess they should be experts on sql.
>
> Thanks for your great software! I am really looking forward to the kf5
> port!
> Best,
> Wolfgang
>
> >
> > [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-devel/attachments/20151112/e118105c/attachment.html>