Bug 402534

Summary:	DB password doesn't apply while trying to save
Product:	[Applications] kmymoney	Reporter:	Valeriy Polischuk <truetrup>
Component:	database	Assignee:	KMyMoney Devel Mailing List <kmymoney-devel>
Status:	RESOLVED FIXED
Severity:	major	CC:	truetrup
Priority:	NOR
Version:	5.0.2
Target Milestone:	---
Platform:	Neon
OS:	Linux
Latest Commit:	https://commits.kde.org/kmymoney/0b79fc5d74088029ff67f57ebe3b52fb285b1d51	Version Fixed In:	5.0.3
Sentry Crash Report:

Description Valeriy Polischuk 2018-12-24 16:03:29 UTC

SUMMARY
While trying save to DB (mysql) getting error "Failed to save your storage."

STEPS TO REPRODUCE
1. Open kmymoney
2. Enter password for DB
3. Add some entries
4. Ctrl - S ог just click on Save

OBSERVED RESULT
"Failed to save your storage."
Error in function bool MyMoneyStorageSql::writeFile() : starting commit unit
Driver = QMYSQL, Host = somehost, User = kmymoney, Database = kmymoney
Driver Error: QMYSQL: Unable to connect
Database Error No 1045: Access denied for user 'kmymoney'@'somehost' (using password: NO)
Text: Access denied for user 'kmymoney'@'somehost' (using password: NO) QMYSQL: Unable to connect
Error type 1
Executed: 
Query error No -1: Driver not loaded Driver not loaded
Error type 1 /workspace/build/kmymoney/plugins/sql/mymoneystoragesql.cpp:357

EXPECTED RESULT
Saving information to DB

SOFTWARE/OS VERSIONS 
Operating System: KDE neon 5.14
KDE Plasma Version: 5.14.4
Qt Version: 5.11.2
KDE Frameworks Version: 5.53.0
Kernel Version: 4.15.0-42-generic
OS Type: 64-bit

ADDITIONAL INFORMATION
As i see, db password doesn't apply when trying to save.

Comment 1 Thomas Baumgart 2018-12-25 19:35:38 UTC

Git commit 0b79fc5d74088029ff67f57ebe3b52fb285b1d51 by Thomas Baumgart.
Committed on 25/12/2018 at 19:34.
Pushed by tbaumgart into branch '5.0'.

Remember the full URL for saving the database

When using the 'open recent' feature on a database, the password was not
remembered and any following save operation of the data failed. This
change remembers the password for that operation.
FIXED-IN: 5.0.3

M  +7    -2    kmymoney/kmymoney.cpp
M  +6    -1    kmymoney/plugins/gnc/import/gncimporter.cpp
M  +1    -0    kmymoney/plugins/gnc/import/gncimporter.h
M  +6    -0    kmymoney/plugins/kmymoneyplugin.h
M  +16   -6    kmymoney/plugins/sql/sqlstorage.cpp
M  +6    -0    kmymoney/plugins/sql/sqlstorage.h
M  +8    -0    kmymoney/plugins/xml/xmlstorage.cpp
M  +5    -0    kmymoney/plugins/xml/xmlstorage.h

https://commits.kde.org/kmymoney/0b79fc5d74088029ff67f57ebe3b52fb285b1d51