Bug 313025

Summary:	MySql login fails when not saving the password in the connection settings.
Product:	[Applications] KEXI	Reporter:	Meltra <meltra.bour>
Component:	KexiDB	Assignee:	Jarosław Staniek <staniek>
Status:	CLOSED FIXED
Severity:	normal
Priority:	NOR
Version:	2.5.4
Target Milestone:	2.7
Platform:	Other
OS:	All
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Meltra 2013-01-10 16:54:56 UTC

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

Comment 1 Jarosław Staniek 2013-01-10 23:00:19 UTC

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

Comment 2 Jarosław Staniek 2013-01-12 00:36:22 UTC

The bug has been most probably introduced in commit 317bc071aa14 on Jun 14 2011.

Comment 3 Jarosław Staniek 2013-01-12 01:03:32 UTC

OK, I have fix for case 3.1. Working on the other cases.

Comment 4 Jarosław Staniek 2013-01-13 00:25:30 UTC

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

Comment 5 Jarosław Staniek 2013-01-13 00:27:29 UTC

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

Comment 6 Jarosław Staniek 2013-01-13 00:57:00 UTC

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

Comment 7 Inge Wallin 2013-01-14 03:30:58 UTC

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

Comment 8 Jarosław Staniek 2013-01-14 21:24:29 UTC

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

Comment 9 Jarosław Staniek 2013-03-17 22:23:35 UTC

Fix for other cases implemented on March 1, not yet reviewed: https://git.reviewboard.kde.org/r/109214/

Comment 10 Jarosław Staniek 2013-03-17 22:29:04 UTC

The target for case 3.1 is Kexi 2.7 (because new messages have been added).