Bug 406990 - No storage object attached to MyMoneyFile
Summary: No storage object attached to MyMoneyFile
Status: RESOLVED FIXED
Alias: None
Product: kmymoney
Classification: Applications
Component: database (show other bugs)
Version: 5.0.1
Platform: Mint (Ubuntu based) Linux
: NOR critical
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-27 20:59 UTC by lp.allard.1
Modified: 2019-05-01 20:23 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description lp.allard.1 2019-04-27 20:59:13 UTC
SUMMARY
Just installed KMM 5 from the Linux Mint 19.1 basic repos, and I cannot open my MySQL remote database that was until recently being used by KMM 4.7.2.

I get the following message:

No storage object attached to MyMoneyFile in file /build/kmymoney-8Tb1zm/kmymoney-5.0.1/kmymoney/mymoney/mymoneyfile.cpp line 225

Then KMM crashes hard.

Alternatively, if I dont get the above error, KMM complains:

Error in function int MyMoneyStorageSql::open(const QUrl&, int, bool) : opening database
Driver = QMYSQL, Host = database-server, User = kmymoney-TESTING, Database = /kmymoney-TESTING
Driver Error: QMYSQL: Unable to connect
Database Error No 1044: Access denied for user 'kmymoney-TESTING'@'workstation' to database '/kmymoney-TESTING'
Text: Access denied for user 'kmymoney-TESTING'@'workstation' to database '/kmymoney-TESTING' QMYSQL: Unable to connect
Error type 1
Executed: 
Query error No -1:  
Error type 0

However, I can connect to the database "kmymoney-TESTING" just fine via MariaDB CLI from computer "workstation" and permissions or credentials on the DB server have NOT changed so this is not really a permission issue IMO.

STEPS TO REPRODUCE
1. Have a working KMM 4.7.2 DB on MySQL server
2. Upgrade KMM to 5.0.0
3. Observe the above errors and cannot use KMM.

OBSERVED RESULT
See above desc.

EXPECTED RESULT
Should connect to the DB server

SOFTWARE/OS VERSIONS
KDE Frameworks 5.44.0
Qt 5.9.5 (built against 5.9.5)
The xcb windowing system

ADDITIONAL INFORMATION
Brand new Linux Mint 19.1 system fully updated.
Comment 1 lp.allard.1 2019-04-29 19:22:32 UTC
Changed KMM version in this bug ticket, in KMM > Help > About KMM I see Version 5.0.0 but Linux Mint package reports 5.0.1..........

dpkg -s kmymoney
Package: kmymoney
Status: install ok installed
Priority: optional
Section: kde
Installed-Size: 12337
Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Architecture: amd64
Version: 5.0.1-2
Depends: kio, libalkimia5-7 (>= 7.0), libaqbanking35 (>= 5.6.1beta), libc6 (>= 2.14), libgcc1 (>= 1:3.0), libgmp10, libgpgmepp6 (>= 1.10.0), libgwengui-cpp0, libgwengui-qt5-0, libgwenhywfar60 (>= 3.11.6), libical3 (>= 3.0.0), libkchart2 (>= 2.6.0), libkf5activities5 (>= 4.96.0), libkf5akonadicore-bin, libkf5akonadicore5abi1 (>= 4:16.12.3+git20170414), libkf5archive5 (>= 4.96.0), libkf5codecs5 (>= 4.96.0), libkf5completion5 (>= 4.97.0), libkf5configcore5 (>= 4.98.0), libkf5configgui5 (>= 4.97.0), libkf5configwidgets5 (>= 5.23.0), libkf5contacts5 (>= 15.07.90), libkf5coreaddons5 (>= 5.2.0), libkf5holidays5 (>= 15.12.0), libkf5i18n5 (>= 4.97.0), libkf5identitymanagement5abi1 (>= 16.04.3), libkf5itemmodels5 (>= 4.96.0), libkf5itemviews5 (>= 4.96.0), libkf5jobwidgets5 (>= 4.96.0), libkf5kcmutils5 (>= 4.96.0), libkf5kiocore5 (>= 4.96.0), libkf5kiofilewidgets5 (>= 4.96.0), libkf5kiowidgets5 (>= 4.96.0), libkf5notifications5 (>= 4.96.0), libkf5service-bin, libkf5service5 (>= 5.2.0+git20140930), libkf5sonnetui5 (>= 4.96.0), libkf5textwidgets5 (>= 4.96.0), libkf5wallet-bin, libkf5wallet5 (>= 4.96.0), libkf5webkit5 (>= 4.96.0), libkf5widgetsaddons5 (>= 4.96.0), libkf5xmlgui-bin, libkf5xmlgui5 (>= 4.98.0), libofx7, libpython2.7 (>= 2.7), libqt5core5a (>= 5.9.0~beta), libqt5dbus5 (>= 5.0.2), libqt5gui5 (>= 5.8.0), libqt5network5 (>= 5.1.0), libqt5printsupport5 (>= 5.0.2), libqt5quickwidgets5 (>= 5.3.0), libqt5sql5 (>= 5.0.2), libqt5webkit5 (>= 5.6.0~rc), libqt5widgets5 (>= 5.4.0), libqt5xml5 (>= 5.1.0), libstdc++6 (>= 5.2), libaqbanking35-plugins, kmymoney-common (= 5.0.1-2)
Recommends: gnupg-agent, pinentry-qt | pinentry-x11
Suggests: kcalc
Description: personal finance manager for KDE
 KMyMoney is the Personal Finance Manager for KDE. It operates similar to
 MS-Money and Quicken, supports different account types, categorisation of
 expenses, QIF import/export, multiple currencies and initial online banking
 support.
Original-Maintainer: Debian KDE Extras Team <pkg-kde-extras@lists.alioth.debian.org>
Homepage: https://kmymoney.org/
Comment 2 lp.allard.1 2019-05-01 20:23:07 UTC
I compiled 5.0.4 and this issue has been fixed.