Passwords get lost

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Change a password in the  'favourites' pref pane

2. leave editing that favourite (i.e. start editing another favourite)

3. Go back to the favourite mentioned in step 1.

What is the expected output? What do you see instead?

Expected output is they password field is full of bullets
Actual output: password field is blank.

What version of Sequel Pro are you using? What version of MySQL are you
connecting to on the server?

SP v. 0.9.9.1
My SQL version is not relevant

Please provide any additional information below.

Please see this thread in the discussions:
http://groups.google.com/group/sequel-pro/browse_thread/thread/88297fb00533a27e

Apparently this is a keychain bug in OS X Lion and can be worked-around by 
editing the keychain item, rather than deleting, then re-creating.

Original issue reported on code.google.com by digg...@diggory.net on 21 Sep 2011 at 2:01

[GoogleCodeExporter]

I have been able to replicate this in Lion, although not consistently (???).  
Thanks for the report - we'll get this addressed ASAP.

Original comment by rowanb@gmail.com on 21 Sep 2011 at 2:36

• Changed state: Accepted
• Added labels: Component-Persistence, Priority-Critical, Type-Defect

[GoogleCodeExporter]

Hi Diggory - as you mention, this appears to be due to something like a 
cacheing bug in 10.7.  When editing items, the keychain functions seem to have 
cached the previous lookup and so return the original keychain item - which no 
longer exists.  "Lost" passwords would therefore return after relaunching 
Sequel Pro, as then the correct item would be returned.

r3447 alters the editing process to modify a keychain item rather than 
deleting/recreating; as well as working around this bug, this has the advantage 
of matching Apple's recommendations, preserving things like the keychain item 
access list.

Thanks for the report!

Original comment by rowanb@gmail.com on 16 Oct 2011 at 2:11

• Changed state: Fixed

[GoogleCodeExporter]

This is happening to me as well (v 1.0.1, Build 4004).  I've tried 
locking/unlocking the keychain, deleting items and recreating them, all to no 
avail.

The passwords are stored correctly in the keychain, but they are not retrieved 
and populated into the favorites' respective password fields.

One potentially relevant console log:

2/18/13 1:08:22.126 PM Sequel Pro[5222]: NSSecureTextFieldCell detected a field 
editor ((null)) that is not a NSTextView subclass designed to work with the 
cell. Ignoring...

This is the only program with which I've had keychain problems.  Any ideas?

Thanks!
-Landon

Original comment by land...@starkcollective.com on 18 Feb 2013 at 7:45

[GoogleCodeExporter]

Please open a new issue or look at the open issues. 

Original comment by schlabbe...@gmail.com on 18 Feb 2013 at 8:23

[GoogleCodeExporter]

An update to 10.8.2 fixed the issue.

Original comment by land...@starkcollective.com on 18 Feb 2013 at 10:20