Hi ipwizard,
following you can see the requested output:

michael@linux-x79k:~/Documents> ./KMyMoney-5.0.4-7c0d6f8-x86_64.AppImage sql://michael@localhost///home/michael/ ... er=QSQLITE
WebConnect: Try to connect to WebConnect server
WebConnect: Connect to server failed
WebConnect: Running in server mode
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/budgetview.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/checkprinting.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/csvexporter.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/csvimporter.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/forecastview.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/gncimporter.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/icalendarexporter.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/kbanking.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/kcm_checkprinting.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/kcm_csvimporter.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/kcm_forecastview.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/kcm_icalendarexporter.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/kcm_qif.so" Validity false
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/kcm_reportsview.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/kcm_xmlstorage.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/konlinetasks_sepa.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/ofximporter.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/onlinejoboutboxview.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/qifexporter.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/qifimporter.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/reconciliationreport.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/reportsview.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/sqlstorage.so" Validity true
Located plugin "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/xmlstorage.so" Validity true
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/budgetview.so"
Plugins: budgetview loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/checkprinting.so"
Plugins: checkprinting loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/csvexporter.so"
Plugins: csvexporter loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/csvimporter.so"
Plugins: csvimporter loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/forecastview.so"
Plugins: forecastview loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/gncimporter.so"
Plugins: gncimporter loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/icalendarexporter.so"
Plugins: icalendarexporter loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/kbanking.so"
Plugins: kbanking loaded
3:2019/07/07 15-22-42:gwen(7954):/home/appimage/appimage-workspace/deps-build/ext_gwenhywfar/ext_gwenhywfar-prefix/src/ext_gwenhywfar/src/base/plugin.c: 379: Plugin "dir" not found.
3:2019/07/07 15-22-42:(null)(7954):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 77: Could not create ConfigMgr[dir:///home/michael/.aqbanking/settings]. Maybe the gwenhywfar plugins are not installed?
3:2019/07/07 15-22-42:(null)(7954):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 100: No config manager. Maybe the gwenhywfar plugins are not installed correctly?
KBankingPlugin: No AqB4 config found.
KBankingPlugin: No AqB3 config found.
3:2019/07/07 15-22-42:aqbanking(7954):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 712: No config manager. Maybe the gwenhywfar plugins are not installed correctly?
Error on online init (-1).
Could not initialize KBanking online banking interface
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/ofximporter.so"
Plugins: ofximporter loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/onlinejoboutboxview.so"
Plugins: onlinejoboutboxview loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/qifexporter.so"
Plugins: qifexporter loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/qifimporter.so"
Plugins: qifimporter loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/reconciliationreport.so"
Plugins: reconciliation report loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/reportsview.so"
Plugins: reportsview loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/sqlstorage.so"
Plugins: sqlstorage loaded
Loading "/tmp/.mount_KMyMonYVBX94/usr/plugins/kmymoney/xmlstorage.so"
Plugins: xmlstorage loaded
QFSFileEngine::open: No file name specified
OFXImporter::isMyFormat: unable to open "" with "No file name specified"
QSqlDatabase: driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL QMYSQL3 QPSQL QPSQL7 QSQLCIPHER
Unknown view '' in slotOpenURL()
Plugins: budgetview unloaded
Plugins: checkprinting unloaded
Plugins: csvexporter unloaded
Plugins: csvimporter unloaded
Plugins: forecastview unloaded
Plugins: gncimporter unloaded
Plugins: icalendarexporter unloaded
Plugins: kbanking unloaded
Plugins: ofximporter unloaded
Plugins: onlinejoboutboxview unloaded
Plugins: qifexporter unloaded
Plugins: qifimporter unloaded
Plugins: reconciliation report unloaded
Plugins: reportsview unloaded
Plugins: sqlstorage unloaded
Plugins: xmlstorage unloaded

Too bad, the AppImage does not contain the SQLite driver so it cannot handle database storage

The line

OFXImporter::isMyFormat: unable to open "" with "No file name specified"

is harmless. It's just a check if the file you provide is an OFX import. Since we provide an sql:// protocol, the localfile name is empty at that point. Fine.

I need to go through all the checks that are performed and figure out what could fail for you. This may take a while.

Thank you.

I have my financial data of the last 18 years in this file, so it's important for me, so I have to wait.

Before I/we dive into this one a bit further, can you try to create a new (sample) database and see if you can work with it (load, save, reopen, etc)? If yes, we need to figure out what difference between the two causes your trouble?

Hi,
created a new db with type SQLCipher Version 3 (encrypted sql). Did some bookings and stored the file. Reopening was no problem, seems all fine.
The only difference between the my db and the test db I see seems to be the encryption.

Please keep in mind that I can open the database with sqlitebrowser. Also I have digikam running with a sqlite db on this pc.

Thanks
photomike

Hi,

Is there any way to recover my data?
sqlitebrowser can open my db. From there it is possible to export the data as csv or sql. Is there a way to import the exported data back into a new created kmymoney db?
Can sqlcipher help?

Meanwhile there was an update to MKyMoney 5.05, but that didn't change anything. I can't just wait to see if it will ever work again. If it doesn't work with KMyMoney, I have to try to import the data into another financial management program.

Thank you in advance

I am pretty sure that it has nothing to do with encryption being used or not. KMyMoney handles both side by side. Since you come from an older version it could well be that the structure of the database (table columns, etc.) has been changed and that the upgrade is not handling that sceanrio too well. This is something which can be fixed though.

Can you compare the DDLs of the two databases you have (the existing and the newly created one)? I was able to get such information from sqlitebrowser by using File/Export/Database to SQL and only exported the schema but no data. Do they show any difference? I would appreciate if you can send them also to kmymoney-devel@kde.org for more eyes to take a look at them. Many thanks in advance.

Hi,
there are really some differences in the table structure.
I've send both file structures to the mail address you told me.
The subject is the same as here.

Do you have access to it?

photomike

photomike wrote:Do you have access to it?

You bet! Just released your mail from quarantine

Thanks to photomike for the sample file which allowed me to analyze the problem. Bug #410091 has been opened to keep track of the issue.

Hi,

I've got a similar problem after upgrading from Linux Mint 19 to Linux Mint 20.
After installing KMyMoney ver. 5.0.8 I have got a message "Qt SQL driver QSQLITE is no longer installed on your system".
It looks like KMyMoney replaced QSQLITE driver by QCQLCIPHER and does not want to deal with un-encrypted SQLite any more.
Both drivers are located in /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers , but KMyMoney picks up QSQLCIPHER only.

Code: Select all

~$ ls /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers
libqsqlite.so  qsqlcipher.so


Is there a way to turn it back to standard SQLite files?

Thank you,

To my knowledge, SQLCipher supports unencrypted databases out-of-the-box. So there is no need to provide SQLite and SQLCipher in parallel, which even causes problems. There is already work underway to consolidate this.

Thank you, ipwizard,

It works. My problem was that I tried to open Recent tables, but their commands included DRIVER=QSQLITE part, which KMYMonet did not want to accept. When I tried just to Open Database, the description of QSQLCIPHER said "Encrypted SQLite", so I did not want to risk my databases trying this option. But it actually works OK.

Thank you again.