[Bug 299988] New: Using MySQL but on DB test got "Database connection test was not successful. Error was: Driver not loaded Driver not loaded"

[mikeg]

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

            Bug ID: 299988
          Severity: major
           Version: unspecified
          Priority: NOR
          Assignee: [hidden email]
           Summary: Using MySQL but on DB test got "Database connection
                    test was not successful.  Error was: Driver not loaded
                    Driver not loaded"
    Classification: Unclassified
                OS: OS X
          Reporter: [hidden email]
          Hardware: MacPorts Packages
            Status: UNCONFIRMED
         Component: Database
           Product: digikam

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.

--
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

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email],
                   |                            |[hidden email]
          Component|Database                    |Portability
            Version|unspecified                 |2.6.0

--- Comment #1 from Gilles Caulier <[hidden email]> ---
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

--
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

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

--- Comment #2 from Jan Gosmann <[hidden email]> ---
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

--
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

[Gilles Caulier-4]

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

--- Comment #3 from Gilles Caulier <[hidden email]> ---
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

--
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

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

--- Comment #4 from Jan Gosmann <[hidden email]> ---
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"

--
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

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |FIXED
      Latest Commit|                            |http://commits.kde.org/scra
                   |                            |tch/mwiesweg/digikam-sc/c67
                   |                            |b5bf864b290369ad45077e7c55a
                   |                            |fb1c2c6e26

--- Comment #5 from Gilles Caulier <[hidden email]> ---
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

--
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

[Gilles Caulier-4]

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

--- Comment #6 from Gilles Caulier <[hidden email]> ---
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

--
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

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

--- Comment #7 from Jan Gosmann <[hidden email]> ---
I don't know. You would have to discuss that with the maintainer of the qt4-mac
port.

--
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

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |2.7.0

--
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

[mikeg]

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

Mike Gutzschhahn <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|FIXED                       |WONTFIX

--- Comment #8 from Mike Gutzschhahn <[hidden email]> ---
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.

--
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