Version 2.5.4 (Calligra 2.5.4) MySql login fails after restarting kexi and you are not saving the password in the connection settings. Reproducible: Always Steps to Reproduce: 1. Create a new db: ctrl+n -> Blank db -> Server -> Add connection (mysql, do not save password) -> name db. 2. Close Kexi, Open again 3.1 Welcome screen: Click your db -> fill out prompt for password -> Error: Could not connect, Details: Message from server: Access denied for user 'user'@'localhost' (using password: NO) 3.2 Open screen: ctrl+o -> Tab: Projects stored on Database server -> Select Server -> Next Actual Results: 3.1 Unable to open the db + Invalid/unexpected error message 3.2 Unable to open the db + nothing ... Expected Results: 3.1 Connection should have been a succes or Details: Access denied for user 'user'@'localhost' (using password: YES) 3.2 Something, a password dialog ? Only Tested on Arch Linux using Version 2.5.4 (Calligra 2.5.4) https://www.archlinux.org/packages/extra/x86_64/calligra-kexi/ Mysql log shows the attempt to login without using a password. I was able to get around it by using the open screen and then editing the connection again. - Open screen: ctrl+o -> Tab: Projects stored on Database server -> Select Server -> Edit -> fill out password (leave save password unchecked) -> test connection -> save -> Next
Confirmed on OpenSUSE too, it's cross-platform bug. Moreover: 3.3 case: New -> Blank db -> Server -> Select Server -> Next - Causes the same error. 3.4 case: Import/Export/Send -> Import -> Next -> Project stored on a db server -> Next - Causes the same error but also moves to next assistant page and shows empty db list
The bug has been most probably introduced in commit 317bc071aa14 on Jun 14 2011.
OK, I have fix for case 3.1. Working on the other cases.
Git commit 5e6158b2e7465c2eace316af16a4025b2be66b29 by Jaroslaw Staniek. Committed on 13/01/2013 at 00:52. Pushed by staniek into branch 'calligra/2.5'. Fix MySql login failure when not saving password - fix for case 3.1 This fix is for case 3.1: Welcome screen as explained at https://bugs.kde.org/show_bug.cgi?id=313025 M +7 -12 kexi/main/KexiMainWindow.cpp http://commits.kde.org/calligra/5e6158b2e7465c2eace316af16a4025b2be66b29
Git commit b1bdf87a330becd1df4678b7ea7f79ee85dbfd9d by Jaroslaw Staniek. Committed on 13/01/2013 at 00:52. Pushed by staniek into branch 'master'. Fix MySql login failure when not saving password - fix for case 3.1 This fix is for case 3.1: Welcome screen as explained at https://bugs.kde.org/show_bug.cgi?id=313025 M +7 -8 kexi/main/KexiMainWindow.cpp http://commits.kde.org/calligra/b1bdf87a330becd1df4678b7ea7f79ee85dbfd9d
Git commit d2090bcf405aead9cf02895bf4cf43fdb4376f8e by Jaroslaw Staniek. Committed on 13/01/2013 at 00:52. Pushed by staniek into branch 'calligra/2.6'. Fix MySql login failure when not saving password - fix for case 3.1 This fix is for case 3.1: Welcome screen as explained at https://bugs.kde.org/show_bug.cgi?id=313025 M +7 -12 kexi/main/KexiMainWindow.cpp http://commits.kde.org/calligra/d2090bcf405aead9cf02895bf4cf43fdb4376f8e
Git commit ce807dbafeaa61fd1a5598ace09abfb24cae7ab3 by Inge Wallin, on behalf of Jaroslaw Staniek. Committed on 13/01/2013 at 00:52. Pushed by ingwa into branch 'text-annotations-ingwa'. Fix MySql login failure when not saving password - fix for case 3.1 This fix is for case 3.1: Welcome screen as explained at https://bugs.kde.org/show_bug.cgi?id=313025 M +7 -8 kexi/main/KexiMainWindow.cpp http://commits.kde.org/calligra/ce807dbafeaa61fd1a5598ace09abfb24cae7ab3
Git commit 9a5fe542a5ea7a2943848756e4dee6af19bb111c by Jaroslaw Staniek. Committed on 13/01/2013 at 00:52. Pushed by staniek into branch 'calligra/2.4'. Fix MySql login failure when not saving password - fix for case 3.1 This fix is for case 3.1: Welcome screen as explained at https://bugs.kde.org/show_bug.cgi?id=313025 M +7 -12 kexi/main/KexiMainWindow.cpp http://commits.kde.org/calligra/9a5fe542a5ea7a2943848756e4dee6af19bb111c
Fix for other cases implemented on March 1, not yet reviewed: https://git.reviewboard.kde.org/r/109214/
The target for case 3.1 is Kexi 2.7 (because new messages have been added).