Reply to topic

Open sqlite database under kmymoney versions >= 5.0

photomike
Registered Member
Posts
12
Karma
0
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
User avatar ipwizard
KDE Developer
Posts
701
Karma
3
OS
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.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.0 64bit, KF5
photomike
Registered Member
Posts
12
Karma
0
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.
User avatar ipwizard
KDE Developer
Posts
701
Karma
3
OS
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?


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.0 64bit, KF5
photomike
Registered Member
Posts
12
Karma
0
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
photomike
Registered Member
Posts
12
Karma
0
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
User avatar ipwizard
KDE Developer
Posts
701
Karma
3
OS
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.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.0 64bit, KF5
photomike
Registered Member
Posts
12
Karma
0
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
User avatar ipwizard
KDE Developer
Posts
701
Karma
3
OS
photomike wrote:Do you have access to it?

You bet! Just released your mail from quarantine :)


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.0 64bit, KF5
User avatar ipwizard
KDE Developer
Posts
701
Karma
3
OS
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.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.0 64bit, KF5

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], Bing [Bot], ghevan, Google [Bot], Majestic-12 [Bot], rblackwell, Snudl, Sogou [Bot], Tooniis