Bug 299988 - Using MySQL but on DB test got "Database connection test was not successful. Error was: Driver not loaded Driver not loaded"
Summary: Using MySQL but on DB test got "Database connection test was not successful. ...
Status: RESOLVED INTENTIONAL
Alias: None
Product: digikam
Classification: Applications
Component: Portability-Runtime (show other bugs)
Version: 2.6.0
Platform: MacPorts macOS
: NOR major
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-14 10:30 UTC by Mike Gutzschhahn
Modified: 2012-07-25 14:04 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 2.7.0


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Gutzschhahn 2012-05-14 10:30:16 UTC
I installed with MacPorts and a local DB everything works fine. But by using a remote MySQL-DB i got "Database connection test was not successful. 
Error was: Driver not loaded Driver not loaded".

Reproducible: Always

Steps to Reproduce:
1. Install with Mac Ports using this tutorial
https://projects.kde.org/projects/extragear/graphics/digikam/digikam-software-compilation/repository/revisions/master/entry/README.MACOSX
2. Started (after some fixed access right problems in Preferences-Folder)
3. Created local DB and imported – everything works pritty fine
4. Changed DB to remote MySQL
Actual Results:  
Database connection test was not successful. 
Error was: Driver not loaded Driver not loaded

Expected Results:  
A working DB connection

I checked the login information and retried with DK 2.5 on windows. Those weren't the source of this problem.
Comment 1 caulier.gilles 2012-05-14 12:30:21 UTC
Jan,

In Macports, it sound like that MySQL driver is not available in libQt4. It's a run time dependency for digiKam. Mysql driveris a plugin in Qt4 in fact. It must be included in compilation rules of Qt4 with Macports package.

Gilles Caulier
Comment 2 Jan Gosmann 2012-06-09 21:15:38 UTC
You're right. By default the MySQL drivers will not be included in the Macports build of Qt4. But you can install the qt4-mac +mysql variant. Then the database connection test works for me (without recompilation of Digikam).

I could add that dependency to the Port, but would prefer to make it not the default. I think, most people are quite happy with the sqlite default and don't want the time consuming rebuild of qt4-mac. Ideally one would compile Digikam without mysql support when installing without the mysql variant. Is there any cmake option which deactivates mysql support?

Best, Jan
Comment 3 caulier.gilles 2012-06-10 08:14:32 UTC
Thanks Jan for the clarification. 

There is cmake option to disable mysql support. There is only a cmake check at configuration time.

Which macports package i need to refer in my README.MACOSX tutorial, about mysql support ?

https://projects.kde.org/projects/extragear/graphics/digikam/digikam-software-compilation/repository/revisions/master/entry/README.MACOSX

Gilles Caulier
Comment 4 Jan Gosmann 2012-06-10 09:48:52 UTC
Instead of using the as dependency automatically installed qt4-mac the +mysql variant has to be installed, i.e.: "sudo port install qt4-mac +mysql"
Comment 5 caulier.gilles 2012-06-10 10:45:40 UTC
Git commit c67b5bf864b290369ad45077e7c55afb1c2c6e26 by Gilles Caulier.
Committed on 10/06/2012 at 12:44.
Pushed by cgilles into branch 'master'.

add rules to install qt4 for mac with mysql plugin support

M  +1    -0    README.MACOSX

http://commits.kde.org/scratch/mwiesweg/digikam-sc/c67b5bf864b290369ad45077e7c55afb1c2c6e26
Comment 6 caulier.gilles 2012-06-10 10:48:20 UTC
Jan,

Note that under linux, i can see that Qt4 mysql plugin can be installed separately than qt4 core. It's a run-time dependency, and it can be installed later than core package. Why not to do the same with macports ?

Gilles Caulier
Comment 7 Jan Gosmann 2012-06-10 10:51:35 UTC
I don't know. You would have to discuss that with the maintainer of the qt4-mac port.
Comment 8 Mike Gutzschhahn 2012-07-25 14:04:31 UTC
Hi all,

I made a clean install with MacPorts and recompiled mysql after successfully installing Digikam 2.7. Everthing works instead of:
- Missing filemanager
- No Thumbs shown

I used the maintenance tools but without success. I think the MacPorts Team might update the routines as Gilles recommended. Will you or can i close this ticket?

Thanks for your support
Mike

PS: If you need a mac for testing, I think not everybody has one, I'd be glad to give a helping hand.