Bug 381790 - No mysql support in installer and portable package
Summary: No mysql support in installer and portable package
Status: RESOLVED FIXED
Alias: None
Product: kmymoney
Classification: Applications
Component: database (show other bugs)
Version: unspecified
Platform: Other Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks: 381786
  Show dependency treegraph
 
Reported: 2017-06-29 09:11 UTC by Ralf Habacker
Modified: 2017-08-01 11:53 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Ralf Habacker 2017-06-29 09:11:43 UTC
On trying to open a mysql database with a snapshot from 

https://software.opensuse.org/package/mingw32-kmymoney-portable?search_term=mingw32-kmymoney-portable or 
https://software.opensuse.org/package/mingw64-kmymoney-portable?search_term=mingw64-kmymoney-portable

a dialog box comes up and says: No Qt SQL driver.

How to reproduce:
1. Download and unpack portable package on Windows
2. start kmymoney from bin dir of unpacked package
3. Select File->Open database
Comment 1 Ralf Habacker 2017-06-29 18:50:33 UTC
This is caused by two issues: 

1. The Qt4 mysql and sqlite driver dll's are not included in the installation 
2. There is a qt.conf missing in bin dir to specify that qt4 plugins are located at <root>/lib/qt4/plugins
Comment 2 Ralf Habacker 2017-07-10 13:26:07 UTC
(In reply to Ralf Habacker from comment #1)
> This is caused by two issues: 
> 
> 1. The Qt4 mysql and sqlite driver dll's are not included in the
> installation 
fixed

> 2. There is a qt.conf missing in bin dir to specify that qt4 plugins are
> located at <root>/lib/qt4/plugins

The problem here is that qt is normally be compiled with an absolute path to the plugin (and other dirs) 
see http://doc.qt.io/qt-4.8/qt-conf.html for details and https://build.opensuse.org/package/view_file/windows:mingw:win32/mingw32-libqt4/mingw32-qt4.spec?expand=1 line 316 for the cross compiled package
-plugindir %{_mingw32_libdir}/qt4/plugins \

With a qt.conf in the bin dir this could be corrected by using a relative path. Unfortunally adding qt.conf unconditional to the mingw32|64-libqt4 package will interference with the related qt.conf for mingw32|64-libqt5 if installed in parallel which is possible.
Comment 3 Ralf Habacker 2017-08-01 11:53:29 UTC
(In reply to Ralf Habacker from comment #2)

> With a qt.conf in the bin dir this could be corrected by using a relative
> path. Unfortunally adding qt.conf unconditional to the mingw32|64-libqt4
> package will interference with the related qt.conf for mingw32|64-libqt5 if
> installed in parallel which is possible.

fixed at https://build.opensuse.org/package/rdiff/windows:mingw:win32/mingw32-libqt4?linkrev=base&rev=110