[digikam] [Bug 342124] New: mysql database error: database cannot be verified

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 342124] New: mysql database error: database cannot be verified

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

            Bug ID: 342124
           Summary: mysql database error: database cannot be verified
           Product: digikam
           Version: 4.0.0
          Platform: MacPorts Packages
                OS: OS X
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: Database
          Assignee: [hidden email]
          Reporter: [hidden email]

Hi,
I just installed digikam on the weekend but couldn't get the mysql database to
work, on start-up I get an error saying:

"The database it not valid: the "DBVersion" setting does not exist. The current
database schema version cannot be verified. Try to start with an empty
database."

Well, it is empty though, I just created it. Here are my steps:

- mysql runs on Windows 7 server
- I installed digikam with macports on MacOSX (10.9.5)
- for the mysql databases I used the following commands:

(my user is "digikam", database is also called "digikam")
CREATE DATABASE digikam;
GRANT ALL ON digikam.* TO digikam WITH GRANT OPTION;
USE digikam;
GRANT ALL ON digikam TO digikam WITH GRANT OPTION;
GRANT CREATE ON digikam TO digikam WITH GRANT OPTION;
FLUSH PRIVILEGES;
... and the same for the database "thumbs"

Settings within digikam are ok, since the network test is working.
(user, port, passwort, ip everything correct)

Can anyone help me? Digikam is just about my last resort, we have a private
network at home while using both windows machines and a mac with our server
which stores our media files. I have been desperately searching for a picture
archiving solution that supports network databases as well as windows / mac
clients. so if there is no solution to my problem, maybe someone can point me
to an alternative.

thank you!

Reproducible: Always

Steps to Reproduce:
see above:
1. use the mentioned steps to create the databases
2. enter the information in digikam
3. hit enter ;-)

Actual Results:  
see above: message on startup: "The database it not valid: the "DBVersion"
setting does not exist. The current database schema version cannot be verified.
Try to start with an empty database."
after confirming the message on startup and re-entering the preferences and
confirming the dialogue with ok, no message pops up.

Expected Results:  
I would have expected that the databases could be used :)

mysql on windows 7
digikam on osx with macports

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 342124] MYSQL : database error while verification at startup

Gilles Caulier-4
https://bugs.kde.org/show_bug.cgi?id=342124

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
            Summary|mysql database error:       |MYSQL : database error
                   |database cannot be verified |while verification at
                   |                            |startup

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 342124] MYSQL : database error while verification at startup

G Hilbert
In reply to this post by Kathrin
https://bugs.kde.org/show_bug.cgi?id=342124

G Hilbert <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #1 from G Hilbert <[hidden email]> ---
I've a similar problem with Win ver 4.50, digiKam does not get past the
flash-screen and 'Reading Database' message without crashing.  After a long
pause it comes up with the following error message:

Application: digiKam (digikam.exe), signal: EXCEPTION_ACCESS_VIOLATION

ntdll.dll!ZwRaiseException() [[unknown] @ -1] at 0x773515ee


Fault repeatable every time, same again on clean reinstall (with old pgm folder
removed etc.).

----------

Machine:  Win 7-64-bit / 8GB RAM.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 342124] MYSQL : database error while verification at startup

René J.V. Bertin
In reply to this post by Kathrin
https://bugs.kde.org/show_bug.cgi?id=342124

RJVB <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #2 from RJVB <[hidden email]> ---
I have the same issue with the internal mysql server on Mac OS X (using MariaDB
5.5.39) as well as on Linux (also using MariaDB).

I know MySQL support is supposedly experimental, but this feels like a couple
of steps before experimental ...

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 342124] MYSQL : database error while verification at startup

Gilles Caulier-4
In reply to this post by Kathrin
https://bugs.kde.org/show_bug.cgi?id=342124

--- Comment #3 from Gilles Caulier <[hidden email]> ---
New digiKam 4.11.0 is available with official PKG installer for OSX.

https://www.digikam.org/node/740

Can you reproduce the problem with this release ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 342124] MYSQL : database error while verification at startup

René J.V. Bertin
In reply to this post by Kathrin
https://bugs.kde.org/show_bug.cgi?id=342124

--- Comment #4 from RJVB <[hidden email]> ---
Indeed, as can be expected from the exchange above.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 342124] MYSQL : database error while verification at startup

René J.V. Bertin
In reply to this post by Kathrin
https://bugs.kde.org/show_bug.cgi?id=342124

--- Comment #5 from RJVB <[hidden email]> ---
(In reply to RJVB from comment #4)

Sorry, wrong ticket.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 342124] MYSQL : database error while verification at startup

Gilles Caulier-4
In reply to this post by Kathrin
https://bugs.kde.org/show_bug.cgi?id=342124

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Database-Mysql

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 342124] MYSQL : database error while verification at startup

bugzilla_noreply
In reply to this post by Kathrin
https://bugs.kde.org/show_bug.cgi?id=342124

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
      Latest Commit|                            |http://commits.kde.org/digi
                   |                            |kam/4a5e7cef1f15d62701a6fa7
                   |                            |c1366f3303a687616
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |FIXED
   Version Fixed In|                            |5.0.0

--- Comment #6 from [hidden email] ---
Git commit 4a5e7cef1f15d62701a6fa7c1366f3303a687616 by Gilles Caulier.
Committed on 20/11/2015 at 14:54.
Pushed by cgilles into branch 'master'.

New database setup config widget with more details about Mysql initial
configuration and more help to tune settings.
The MySQl Internal is now handle as a main database type config.
Screenshots :

https://www.flickr.com/photos/digikam/23121578776
https://www.flickr.com/photos/digikam/23147681465
https://www.flickr.com/photos/digikam/22851871180
Related: bug 233762, bug 337443, bug 262321

FIXED-IN: 5.0.0

M  +2    -2    CMakeLists.txt
M  +4    -2    app/main/digikamapp.cpp
M  +7    -7    libs/album/albummanager.cpp
M  +3    -3    libs/database/coredb/coredbschemaupdater.cpp
M  +1    -1    libs/database/engine/dbenginebackend.cpp
M  +1    -1    libs/database/engine/dbengineguierrorhandler.cpp
M  +32   -32   libs/database/engine/dbengineparameters.cpp
M  +7    -7    libs/database/engine/dbengineparameters.h
M  +239  -134  libs/database/utils/dbsettingswidget.cpp
M  +22   -10   libs/database/utils/dbsettingswidget.h
M  +2    -2    libs/settings/applicationsettings.h
M  +6    -6    libs/settings/applicationsettings_database.cpp
M  +1    -1    tests/database/testdatabase.cpp
M  +14   -18   utilities/setup/setupdatabase.cpp

http://commits.kde.org/digikam/4a5e7cef1f15d62701a6fa7c1366f3303a687616

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel