MySQL Bugs: #62279: Error while storing password in keychain

Bug #62279	Error while storing password in keychain
Submitted:	28 Aug 2011 18:24	Modified:	5 Sep 2012 23:06
Reporter:	Jorge Mariani	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.34, 5.2.35, 5.2.37	OS:	MacOS (10.7.1)
Assigned to:		CPU Architecture:	Any
Tags:	password

Description:
Trying to store a password inthe keychain while trying to synchronize a model in the EER Diagram produces an error:

Store Password
Could not store password: Error deleting password entry: The operation couldn’t be completed. (OSStatus error 0.)

How to repeat:
Open an EER Diagram
Select Database>Synchronize Model
Select a remote database.
Click on "Store in keychain..."
Enter password.
Click Ok.

I'm experiencing the same problem on Mac OS X Lion, with the last version (mysql-workbench-gpl-5.2.34-osx-i686). I even tried to delete my ~/Library/Application Support/MySQL/workbench directory, but it didn't fix the problem, when adding a new connection, I click "test connection" and first of all it's asking me for my SSH password (but I clicked on "store in keychain" and stored the password in the config), then it's showing me this dialog (checkbox "store in key chain" checked or not):
"Error Looking Up Password"
"Error deleting password entry: The operation couldn’t be completed. (OSStatus error 0.)"

Screenshot of the error

Attachment: Capture d’écran 2011-09-05 à 18.23.57.png (image/png, text), 130.61 KiB.

any solution for this problem ?

I am facing the same problem, but with opening a new connection. Is there any suggested solution?

Hello, recently I post a same problem with connections in mysql workbench, in the beta repository has a version 5.2.35... I install this fix and my problems are solved.

here a link with the new version I downloaded and installed.

http://85.131.152.46/8cb10dd42cdf2d2b43cb9e0f0386baaeff5dd462

att,

JW

Jorge,

Please, check if 5.2.35 solves the problem for you also.

Have the same problem with 5.2.35 7915 on Mac OSx Lion.  I can't create a new instance on a remote IP and save password to keychain.  I get the exact same errors as reported above.

I am also running 5.2.35 on Mac OS Lion and have the same issue.
At this moment I am not able to sync models between my local and remote servers because of this.

I would be very happy to see a bug fix or workaround for this soon.

having the same issue with 5.2.35 on lion.  Getting the same "Error Looking Up Password"
"Error deleting password entry: The operation couldn’t be completed. (OSStatus error
0.)" error mentioned above.  Tried setting up a config file with an entry in the form
Host {nickname}

User {username}
Port 22 
HostName {hostname}
IdentityFile {path} 
TCPKeepAlive yes 
IdentitiesOnly yes
 
in ~/.ssh/config and setting up the connection with a hostname and no username/pw but I get a timeout error.  I successfully tested the host entry via terminal and Panic's Transmit.  Maybe editing the placeholders in the connections.xml file as a possible workaround?  Thoughts?

Are you able to sync if you don't select to store the password in the keychain?

I had the same problem, and I used the Keychain Access.app to remove the old password, after this, I could save the new password.

I'm using Mac OS X Lion and MySQL Workbench 5.2.35 Revision 7915.

I hope this was usefull.

tks

Thanks, Magno.
I have been able to solve the problem removing the old password through the Keychain app.

I am seeing this also on Lion 10.7.2 with MySQL Workbench 5.2.36 (8542).  I made a typo in the DB name on the very first connection - after that, it gets an error on trying to add or trying to remove the password so you're totally locked out of the app.  Deleting the keys with Keychain Access got me past it.

Similar issue with LION 10.7.2  and workbench 5.2.35 Rev7195  I was eventually able to get the password to save by deleting it from the keychain utility, using test connection, and specifying it at that time (and telling it to save in the keychain)

Then later I started getting the same cannot delete password error that others are reporting (strange since I never told it to remove the password) and am back stuck in the same place.  

It seems that any attempt to maintain the established password, or to set it via clicking on 'store in keychain' in the manage connections UI will fail.  It seems the only way to set it is clear the keychain entry from the keychain tool and set it via 'test connection'.

i have the same problem with "New Connection" and "New Server Instance"

I'm using Mac OS X Lion 10.7.2 and MySQL Workbench 5.2.35 Revision 7508.

Having the same problem on 5.2.37 r8576  OS X Lion

Was able to setup three connections, but data entry on one of them.  Tried to fix it, but get this same error.   Deleting from keychain app didn't fix for me.

Screenshot

Attachment: Screen Shot 2012-01-21 at 3.17.17 PM.png (image/png, text), 128.67 KiB.

I can confirm this is still a bug with WB 5.2.37 and OS X Lion 10.7.2

I had a similar experience as Chuck van der Linden, on Lion 10.7.2 and Workbench 5.2.37 r8576. Seems like the problem is storing the password in Keychain outside of a flow in which you are connecting to the server.

I defined a new connection and chose Store In Keychain before connecting to the server, and got the aforementioned error message. I was able to get around it for now by deleting the Keychain entry, restarting Workbench, editing the connection, choosing Test Connection, entering the pswd and ticking the checkbox to save in Keychain.

Same issue on Lion 10.7.2 running Workbench 5.2.37.

Please try with latest version of Lion. This appears to be a Lion bug.

Problem still persists with the latest version of Lion (10.7.3) and Workbench (5.2.37).

I am already using the latest version of Mac OS X (Lio) - version 10.7.3, and the problem still persists.

I had some luck avoiding  the keychain and using a ssh key file.

I had some luck avoiding the keychain and using a ssh key file instead.

Had anybody seen this on 10.7.3+ with MySQL Workbench 5.2.38?

Yes, same bug with Lion 10.7.3 et workbench 5.3.38. Resolved with the Keychain Access.app trick

Benjamin, what Keychain trick are you referring to?

To use the Keychain Access.app to remove the old password, and after this, save the new password with MySQL Workbench.

Oops! Nevermind, I see it referenced in David's post above. (My apologies)

Just go to your Applications / Utilities and under their is the Keyword Access Tool. Delete the bad password and then attempt to access again. This will at a minimum reset the issue with the "can't delete password error"

Does Preferences -> Keychain First Aid in the Keychain Access app solve the problem?

Does <Keychain Access> -> Keychain First Aid in the Keychain Access app solve the problem?

Running 5.2.40, I can reproduce this easily. Just create two DB connections that point to the same host/username/password, but with different default schemas. Storing the password in the keychain for the first one works fine, and fails for the second. You can go look in Keychain Assistant and see that there is one entry. If you delete it and attempt to store the password for the second db connection, it will succeed. But it will fail when you go back and try to add a password to the first connection.

At some point this worked fine. On another system where I already have this working, looking in Keychain Assistant you see that there are multiple entries for the same connection (e.g., Mysql@<dbhost>:3306), but this newer version seems to have problems creating those.

Still a problem for me as well, running OSX Lion (10.7.4) and MySQL Workbench 5.2.40.

I was able to create a connection one time, saving the password in the keychain, but every time I try to open the connection I get the "Error Looking Up Password" error.

If I delete the connection, and delete the Keychain entry, then re-create the connection, saving the password to the Keychain, I see the entry appear in the Keychain, but the connection fails with the same error.

If I delete the connection and the Keychain entry, then re-create it but do not save to the Keychain, it works, but as soon as I try to open the connection I get the error.

Make MySQL Workbench useless for me.  Would love to see this fixed as I could really use this tool for my current project.

@all, it's difficult to reproduce this error. It seems to happen only to certain people (special machine configurations? we don't know). So I would like to ask for volunteers who I could send a new dylib containing the pw handling with better error reporting, so the hope is we get a better description of what is going on on these machines.

Send a mail to mike.lischke@oracle.com if you like to test.

keychain solved the problem for me.

keychain solved the problem for me.

All reporters,

Please, check if the same problem still happens with a newer version of Workbench, 5.2.41, on a recent versions of Mac OS X 10.7.

It seems that the bug is solved. I tested it with Workbench 5.2.42 (Revision 9752) and Mac OS X 10.7.4.
Thanks for the effort of every developer.

Not repeatable with 5.2.42 any more. Looks fixed.

Fixed as of the upcoming Workbench 5.2.42, and here's the changelog entry:

 On Mac OS X, attempts to store a password into the keychain
 could result in an error. 

Thank you for the report.

Hi, just hit the same problem in 6.3. version.

using 6.3.10 on mac and experiencing this issue can anyone mention a stable version without this issue?