[kmymoney] [Bug 400502] New: Open dialog for SQL Database KMyMoney tries to open /KMyMoney

[Michael Reinemann]

https://bugs.kde.org/show_bug.cgi?id=400502

            Bug ID: 400502
           Summary: Open dialog for SQL Database KMyMoney tries to open
                    /KMyMoney
           Product: kmymoney
           Version: 5.0.0
          Platform: Ubuntu Packages
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: database
          Assignee: kmymoney-devel at kde.org
          Reporter: michael at reinemann.de
  Target Milestone: ---

Created attachment 115999
  --> https://bugs.kde.org/attachment.cgi?id=115999&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.