[amarok] [Bug 388248] 2017-12-26 - Unable to start mysql plugin

[Bug Janitor Service]

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

Bug Janitor Service  changed:

   What|Removed |Added

 Status|NEEDSINFO   |RESOLVED
 Resolution|WAITINGFORINFO  |WORKSFORME

--- Comment #5 from Bug Janitor Service  ---
This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!

-- 
You are receiving this mail because:
You are watching all bug changes.

[amarok] [Bug 388248] 2017-12-26 - Unable to start mysql plugin

[Bug Janitor Service]

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

--- Comment #4 from Bug Janitor Service  ---
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!

-- 
You are receiving this mail because:
You are watching all bug changes.

[amarok] [Bug 388248] 2017-12-26 - Unable to start mysql plugin

[Justin Zobel]

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

Justin Zobel  changed:

   What|Removed |Added

 Status|REPORTED|NEEDSINFO
 Resolution|--- |WAITINGFORINFO

--- Comment #3 from Justin Zobel  ---
Thank you for reporting this issue in KDE software. As it has been a while
since this issue was reported, can we please ask you to see if you can
reproduce the issue with a recent software version?

If you can reproduce the issue, please change the status to "REPORTED" when
replying. Thank you!

-- 
You are receiving this mail because:
You are watching all bug changes.

[amarok] [Bug 388248] 2017-12-26 - Unable to start mysql plugin

[Simon Andric]

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

Simon Andric  changed:

   What|Removed |Added

 CC||simonandr...@gmail.com

-- 
You are receiving this mail because:
You are watching all bug changes.

[amarok] [Bug 388248] 2017-12-26 - Unable to start mysql plugin

[Martijn Schmidt]

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

Martijn Schmidt  changed:

   What|Removed |Added

 CC||martijn.schm...@gmail.com

--- Comment #1 from Martijn Schmidt  ---
Hi Evert!

I've happily used Amarok KF5 for over two years now, at this moment in
combination with MariaDB 10.2.11. The embedded database plugin has never worked
for me on the KF5 version, and since libmysqld has been deprecated I doubt the
developers will spend any time fixing it. The "external" MariaDB database works
well, though.


If I recall the setup process correctly, the "gotcha" here was that when Amarok
uses server "localhost" it will actually connect via UNIX sockets. This means
that Amarok's suggested command:

GRANT ALL PRIVILEGES ON nameofdatabase.* TO 'nameofuser' IDENTIFIED BY
'fancypassword';

Should actually be:

GRANT ALL PRIVILEGES ON nameofdatabase.* TO 'nameofuser'@'localhost' IDENTIFIED
BY 'fancypassword';

Those interested in significance of this difference can read more in the
reference manual, search for the sentence "The server uses sorting rules" on
the following page:
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html

I'm not a programmer myself, but perhaps someone from the KDE project could
make a change which roughly achieves the following in
https://cgit.kde.org/amarok.git/tree/src/configdialog/dialogs/DatabaseConfig.cpp
to clarify this for the users?

Add a %4 variable and another \n while we're at it anyway:

query = QString( "CREATE DATABASE %1;\nGRANT ALL PRIVILEGES ON %1.* TO '%2'
IDENTIFIED BY '%3'@'%4';\nFLUSH PRIVILEGES;" )

If kcfg_Host->text() equals QLatin1String("localhost") then %4 should become
'localhost', else %4 should become the character '%' which means "any host" to
the database.

-- 
You are receiving this mail because:
You are watching all bug changes.

[amarok] [Bug 388248] 2017-12-26 - Unable to start mysql plugin

[Martijn Schmidt]

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

--- Comment #2 from Martijn Schmidt  ---
See also: https://bugs.gentoo.org/641060

-- 
You are receiving this mail because:
You are watching all bug changes.

[amarok] [Bug 388248] 2017-12-26 - Unable to start mysql plugin

[Marian Kyral]

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

Marian Kyral  changed:

   What|Removed |Added

 CC||mky...@email.cz

-- 
You are receiving this mail because:
You are watching all bug changes.