| Summary: | Re-establish support for MySQL (disabled by upstream projects) | ||
|---|---|---|---|
| Product: | [Applications] kmymoney | Reporter: | lp.allard.1 |
| Component: | database | Assignee: | KMyMoney Devel Mailing List <kmymoney-devel> |
| Status: | REPORTED --- | ||
| Severity: | task | CC: | alx.kuzza, vonreth |
| Priority: | NOR | ||
| Version First Reported In: | git (master) | ||
| Target Milestone: | --- | ||
| Platform: | Mint (Ubuntu based) | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
Apparently disabled by upstream KDE project in recent commit: https://invent.kde.org/packaging/craft-blueprints-kde/-/commit/188be44f6a3105d21392ad0da06a0a33fe0753cf I am trying to obtain further info from the KDE devs to see why this has been disabled by default. (In reply to lp.allard.1 from comment #1) > Apparently disabled by upstream KDE project in recent commit: > > https://invent.kde.org/packaging/craft-blueprints-kde/-/commit/ > 188be44f6a3105d21392ad0da06a0a33fe0753cf > > I am trying to obtain further info from the KDE devs to see why this has > been disabled by default. We only removed the support for for Windows explicitly thats what you can see in that commit. On linux and mac it was disabled for a long time as it depends on system libraries we did not provide. Not sure what to do with this ticket: I believe MySQL/MariaDB connector is important but I understand that most people are using kmy local files... On the other hand, KMM had DB connector before and lost it due to package / project politics? @Thomas Beaumgart: Do you think this ticket should be moved to feature request or kept as a bug? I'm using SQL for a long while because I can access the data from any computer. I've been planning to take a look at SQL plugin for those reasons: 1) it freezes the UI 2) it runs for an extremely long period of time when loading/saving. 3) should be some sort of progress indication of loading/saving and should support backups/snapshots. 4) and, finally, an "experimental" warning should be removed :) @alx: are you saying that you will help to bring back the SQL connector in AppImage releases and future KMM releases? If so thats good news!!! I agree, last time I used it (about 18 months ago) it took like a minute or so to load/save my data and my DB server is local, running on 64GB of RAM and uses SSD's... I also had several issues in the past (can search the bugtracker with my name) with data corruption. Never got to the bottom of this to be honest. |
SUMMARY *** kmymoney-5.1-36 AppImage doesn't seem to ship with MySQL support. The previous AppImages worked with MySQL connections. This version gives me at startup: WebConnect: Try to connect to WebConnect server WebConnect: Connect to server failed WebConnect: Running in server mode Found html dir(s): ("/usr/share/kmymoney//html/") Found an 'html' folder with CSS files: "/usr/share/kmymoney//html/" System icon theme as reported by QT: "Mint-Y" Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/budgetview.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/checkprinting.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/csvexporter.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/csvimporter.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/forecastview.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/gncimporter.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/icalendarexporter.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/kbanking.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/kcm_checkprinting.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/kcm_csvimporter.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/kcm_forecastview.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/kcm_icalendarexporter.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/kcm_qif.so" Validity false Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/kcm_reportsview.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/kcm_xmlstorage.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/konlinetasks_sepa.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/ofximporter.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/onlinejoboutboxview.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/qifexporter.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/qifimporter.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/reconciliationreport.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/reportsview.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/sqlstorage.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/woob.so" Validity true Located plugin "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/xmlstorage.so" Validity true Loading "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/budgetview.so" Plugins: budgetview loaded Loading "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/checkprinting.so" Plugins: checkprinting loaded Loading "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/csvexporter.so" Plugins: csvexporter loaded Loading "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/csvimporter.so" Plugins: csvimporter loaded Loading "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/forecastview.so" Plugins: forecastview loaded Loading "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/reconciliationreport.so" Plugins: reconciliation report loaded Loading "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/reportsview.so" Plugins: reportsview loaded Loading "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/sqlstorage.so" Plugins: sqlstorage loaded Loading "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/woob.so" Python interpreter found: 3.6.9 (default, Jan 26 2021, 15:33:00) [GCC 8.4.0] Saved a copy of the embedded :/plugins/woob/kmymoneywoob.py script as "/tmp/kmymoneywicHYK.py" Attempt to load the "kmymoneywicHYK" Python module from "/tmp" The dependency 'sys' Python module loaded successfully The 'path' Python variable loaded successfully "kmymoneywicHYK" Python module failed to load Traceback (most recent call last): File "/tmp/kmymoneywicHYK.py", line 9, in <module> from woob.core import Woob ModuleNotFoundError: No module named 'woob' kf.xmlgui: cannot find .rc file "woob.rc" for component "woob" Plugins: woob loaded Loading "/tmp/.mount_kmymonoYVQYU/usr/plugins/kmymoney/xmlstorage.so" Plugins: xmlstorage loaded Found html dir(s): ("/usr/share/kmymoney//html/") Found an 'html' folder with CSS files: "/usr/share/kmymoney//html/" QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QSQLITE3 QODBC QODBC3 QPSQL QPSQL7 QSQLCIPHER then a popup saying "Qt SQL driver QMYSQL is no longer installed on your system" *** STEPS TO REPRODUCE 1. Download any recent AppImages (unfortunately I am not sure when this started) 2. Try to open a MySQL DB OBSERVED RESULT See above EXPECTED RESULT KMM should be able to handle MySQL db's as per previous versions. SOFTWARE/OS VERSIONS KMyMoney: Version 5.1.2-78fde521b KDE Frameworks: Version 5.91.0 Qt Version: Version 5.15.2 (built against 5.15.2) System: Kernel: 5.4.0-100-generic x86_64 bits: 64 compiler: gcc v: 9.3.0 Desktop: Gnome 3.36.9 wm: xfwm4 dm: GDM3, LightDM Distro: Linux Mint 20.3 Una base: Ubuntu 20.04 focal ADDITIONAL INFORMATION MySQL on remote DB server (MariaDB).