Bug 398409

A more simple workaround which does not require an empty file would be to start KMyMoney with the command line option '-n'. This starts KMyMoney without opening the last used file.

This issue could be related to 394384.

Yes, at least the second part of 394384 is identical. I setup of link between these two issues. It's not a duplicate, as the initial problem was a leading slash and the missing password dialog is just a follow up.

Git commit ac602ffdb0297706f1f39602856bbe20225e906c by Thomas Baumgart.
Committed on 10/09/2018 at 19:47.
Pushed by tbaumgart into branch '5.0'.

Ask for password when connecting to database
Related: bug 394384
FIXED-IN: 5.0.2

M  +46   -20   kmymoney/plugins/sql/sqlstorage.cpp
M  +3    -0    kmymoney/plugins/sql/sqlstorage.h

https://commits.kde.org/kmymoney/ac602ffdb0297706f1f39602856bbe20225e906c

Just downloaded the latest master code (09/10/2018 @ 22:30 MDT build 5.0.80-90212a2b) and rebuild and deployed the code. I started it up using the -n option, connected to my DB. After it loaded I closed KMM and opened it again and I did not get prompted for a password.

(In reply to Eleazar from comment #5)
> Just downloaded the latest master code (09/10/2018 @ 22:30 MDT build
> 5.0.80-90212a2b) and rebuild and deployed the code. I started it up using
> the -n option, connected to my DB. After it loaded I closed KMM and opened
> it again and I did not get prompted for a password.

The commit #ac602f is not yet in master, can you please checkout the 5.0 branch?

Downloaded the 5.0 branch (build 5.0.2-ac602ffd) and built it and open with -n, connected to my DB. Closed and opened it again and was not prompted for password. I got the access denied popup.


libEGL warning: DRI2: failed to authenticate
WebConnect: Try to connect to WebConnect server
WebConnect: Connect to server failed
WebConnect: Running in server mode
Plugins: budgetview loaded
Plugins: checkprinting loaded
Plugins: csvexporter loaded
Plugins: csvimporter loaded
Plugins: forecastview loaded
Plugins: gncimporter loaded
Plugins: icalendarexporter loaded
Plugins: kbanking loaded
KBankingPlugin: No AqB4 config found.
KBankingPlugin: No AqB3 config found.
Plugins: kbanking pluged
Plugins: ofximporter loaded
Plugins: onlinejoboutboxview loaded
Plugins: qifexporter loaded
Plugins: qifimporter loaded
Plugins: reconciliation report loaded
Plugins: reportsview loaded
Plugins: sqlstorage loaded
Plugins: weboob loaded
Plugins: xmlstorage loaded
Error in function int MyMoneyStorageSql::open(const QUrl&, int, bool) : opening database
Driver = QMYSQL, Host = 192.168.0.4, User = kmymoney, Database = KMyMoney
Driver Error: QMYSQL: Unable to connect
Database Error No 1045: Access denied for user 'kmymoney'@'xxxxxxxxx' (using password: NO)
Text: Access denied for user 'kmymoney'@'xxxxxxxxxx' (using password: NO) QMYSQL: Unable to connect
Error type 1
Executed: 
Query error No -1:  
Error type 0
libpng warning: iCCP: known incorrect sRGB profile
libpng warning: iCCP: known incorrect sRGB profile

Created attachment 114896 [details]
Temporary patch to force password dialog and debug output

Can you apply the attached patch and check the output on the console? It should print a line like

  secure = "??"

I am interested in the details of the ??-part. After applying the patch and building it will ask for a password. If that does not happen, I expect a problem with the installation of the plugins on your machine.

I applied the patch and did a debug build but I did not see the secure=?? line. Is there a cli parameter I need to use to give a verbose output when I run it?


Build process:
cmake .. -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_BUILD_TYPE=Debugfull
make
sudo make install




libEGL warning: DRI2: failed to authenticate
WebConnect: Try to connect to WebConnect server
WebConnect: Connect to server failed
WebConnect: Running in server mode
Plugins: budgetview loaded
Plugins: checkprinting loaded
Plugins: csvexporter loaded
Plugins: csvimporter loaded
Plugins: forecastview loaded
Plugins: gncimporter loaded
Plugins: icalendarexporter loaded
Plugins: kbanking loaded
KBankingPlugin: No AqB4 config found.
KBankingPlugin: No AqB3 config found.
Plugins: kbanking pluged
Plugins: ofximporter loaded
Plugins: onlinejoboutboxview loaded
Plugins: qifexporter loaded
Plugins: qifimporter loaded
Plugins: reconciliation report loaded
Plugins: reportsview loaded
Plugins: sqlstorage loaded
Plugins: weboob loaded
Plugins: xmlstorage loaded
Error in function int MyMoneyStorageSql::open(const QUrl&, int, bool) : opening database
Driver = QMYSQL, Host = 192.168.0.4, User = kmymoney, Database = KMyMoney
Driver Error: QMYSQL: Unable to connect
Database Error No 1045: Access denied for user 'kmymoney'@'xxxxxxxxxxx' (using password: NO)
Text: Access denied for user 'kmymoney'@'xxxxxxxxx' (using password: NO) QMYSQL: Unable to connect
Error type 1
Executed: 
Query error No -1:  
Error type 0
libpng warning: iCCP: known incorrect sRGB profile
libpng warning: iCCP: known incorrect sRGB profile

No, it will be printed like all the other stuff you see. If it does not show up, then it could be that the installation of the plugins is not correct.

Here is how you could verify if they end up in the right directory. Check the directory where a standard KDE plugin is located.

thb@thb-nb:~$ find /usr -name kcm_sddm.so 
/usr/lib64/qt5/plugins/kcm_sddm.so

Then search for a KMyMoney one. It needs to be in the same path but in a subdirectory named kmymoney.

thb@thb-nb:~$ find /usr -name sqlstorage.so
/usr/lib64/qt5/plugins/kmymoney/sqlstorage.so

If you see multiple locations, then your build needs to tweak the KDE_INSTALL_PLUGINDIR setting. I have mine set to "/usr/lib64/qt5/plugins". If I don't do that, the plugins are installed in a false location and not picked up.

They are in the same location
/usr/lib/x86_64-linux-gnu/qt5/plugins/kcm_sddm.so

/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/sqlstorage.so
/usr/lib/x86_64-linux-gnu/plugins/kmymoney/sqlstorage.so

I will uninstall and reinstall with the KDE_INSTALL_PLUGINDIR tweak and report back.

After I reinstalled it using the KDE_INSTALL_PLUGINDIR tweak I opened KMM with -n, logged in to my DB backend. Closed KMM and reopened it and it prompted me for a Password. So I am guessing that it probably worked without the patch. I will use the tweak going forward to make sure it works correctly.

You should check that the directory

  /usr/lib/x86_64-linux-gnu/plugins/kmymoney

and all files in it are removed.

Did as instructed and all files were removed.

Thanks for the fix.