Debugging hints for sql plugin
eaglexboy at gmail.com
Mon Dec 21 03:45:01 GMT 2020
Basically it created a blank table correctly but failed to save the data
"libEGL warning: DRI2: failed to authenticate" error. That is why I thought
it might be related.
On Sun, Dec 20, 2020, 19:58 Jack <ostroffjh at users.sourceforge.net> wrote:
> It will take me a while to dig through the history of that bug, but at
> first pass, it does not look related. My problem was simply that my login
> to mysql effectively failed, but the way MariaDB (and possibly MySQL) works
> is that the failure to log in is reported with the anonymous user, since
> the provided user credentials failed. I'm assuming that you can actually
> log in to mysql and peruse the database. I didn't get close to that far.
> On 12/20/20 8:11 PM, El Cas wrote:
> If you do find anything please update ticket
> https://bugs.kde.org/show_bug.cgi?id=398410 as this is an open DB ticket
> I created a while back regarding access to DB backend.
> On Sun, Dec 20, 2020, 16:11 Jack Ostroff <ostroffjh at aya.yale.edu> wrote:
>> I decided to test the sql back end, but when I try to save as a mysql
>> database, I get an exception thrown that opening the database failed.
>> So, I'm debugging in kmymoney/plugins/sql/mymoneystoragesql_p.h. I've
>> added some debugging output in createDatabase, and found something that
>> doesn't make sense to me.
>> After the maindb.open() fails (around line 2044,) I confirmed that
>> among other values, that maindb.userName is "jack" as it should be.
>> However, retrieving maindb.lastError.text(), I get "Access denied for
>> user ''@'localhost' to database 'mysql' QMYSQL: Unable to connect".
>> localhost is correct, as is the blank password, but where is the
>> userName? I'm going to start digging into the code for
>> QSqlDatabase.open() but thought I'd ask first if anyone can think of
>> something I might be doing wrong. Just to confirm, I can run mysql at
>> command line, and the database does open, so I know the db system
>> (mariadb) is running, and I do have permissions to login.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the KMyMoney-devel