Bug 400502 - Open dialog for SQL Database KMyMoney tries to open /KMyMoney
Summary: Open dialog for SQL Database KMyMoney tries to open /KMyMoney
Status: RESOLVED DUPLICATE of bug 397675
Alias: None
Product: kmymoney
Classification: Applications
Component: database (show other bugs)
Version: 5.0.0
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-10-31 06:38 UTC by Michael Reinemann
Modified: 2018-10-31 06:48 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments
open database dialog (35.12 KB, image/png)
2018-10-31 06:38 UTC, Michael Reinemann
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Reinemann 2018-10-31 06:38:42 UTC
Created attachment 115999 [details]
open database dialog

SUMMARY
If I try to open a mysql database KMyMony an error occurs "Access denied to DB /KMyMoney" 
It seems kmymony adds the "/" during the open procedure in front of real DB Name  KMyMoney

The database KMyMoney is already in use from a ubuntu 16.04 desktop with kmymoney 4.6.6 

I have a German language version

STEPS TO REPRODUCE
1. start kmymoney
2. menue file -> open database
3. Open DB dialog appears
3.1 select DB type QMYSQL - MySQL
3.2 use standard Database name "KMyMoney"
3.3 use server: 192.168.1.10 and user michael
3.4 insert my password and press ok

OBSERVED RESULT
Error message occurs
Payees model created with items 0
Error in function int MyMoneyStorageSql::open(const QUrl&, int, bool) : opening database
Driver = QMYSQL, Host = 192.168.1.10, User = michael, Database = /KMyMoney
Driver Error: QMYSQL: Es kann keine Verbindung aufgebaut werden
Database Error No 1044: Access denied for user 'michael'@'%' to database '/KMyMoney'
Text: Access denied for user 'michael'@'%' to database '/KMyMoney' QMYSQL: Es kann keine Verbindung aufgebaut werden
Error type 1
Executed: 
Query error No -1:  
Error type 0

But I can't grant access to DB /KMyMoney because the DB name is KMyMoney. For this DB the access rights have been granted to user michael


EXPECTED RESULT
kmymoney opens the database

SOFTWARE VERSIONS
(available in About System)
kmymoney 5.0.0
KDE Frameworks 5.44.0
Qt 5.9.5 (kompiliert gegen 5.9.5)
Das xcb Fenstersystem


ADDITIONAL INFORMATION
kmymoney is working from with that db & user with 4.6.6
same issue occurs on kubuntu 18.10
Comment 1 Thomas Baumgart 2018-10-31 06:48:37 UTC

*** This bug has been marked as a duplicate of bug 397675 ***