[TxMt] sql bundle and the keychain?
jtu at esidesign.com
Tue Jul 10 14:29:37 UTC 2007
I can select a query, execute the SQL and the Database Browser shows up. But
from the Database Browser, if I click on "Next" to retrieve the subsequent
pages of records, I'm prompted for my password every time. Also, if I click
on another table name or database name, it prompts me for the password.
In addition I get this error message...let me describe what I'm doing
(1) I highlight the following sql from a text file.
(2) I "Execute the Selection as Query
(3) The Database Browser shows up with...
SELECT geo_entities.short_code FROM geo_entities
Records 1 to 10 Next »
(4) Then when I click on the Next link...I'm prompted for my password...I
enter it and then I get this error. It seems that the newline character is
#42000You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'SELECTgeo_entities.short_codeFROM geo_entities LIMIT 10 OFFSET 10' at line
So I try the same query...but this time w/o new lines...I highlight this and
I don't get the error.
"SELECT geo_entities.short_code FROM geo_entities"
> I found a question on this posed in the dev mailing list, but am posting
> the user mailing list, because it is now a user issue :-)
> Any luck with this... I see the release notes mention using the keychain
> store passwords, but I'm not sure how to go about doing this...
> Brad Miller wrote:
>> I've been trying to get the new browser to work. But I get the following
>> ERROR 1045 (28000): Access denied for user 'bmiller'@'localhost' (using
>> password: NO)
>> It looks like I should be prompted for a password? There is no place to
>> enter one in the configuration dialog. I've searched my keychain and
>> cannot find one. Is there some variable I should be setting to tell the
>> bundle that I want to use a password?
>> Brad Miller
>> Assistant Professor, Computer Science
>> Luther College
>> On 7/7/07, Ciarán Walsh <ciawal at gmail.com> wrote:
>>> Switching in new SQL bundle from WIP branch
>>> D branches/WIP/Bundles/SQL.tmbundle/
>>> A trunk/Bundles/SQL.tmbundle/
View this message in context: http://www.nabble.com/sql-bundle-and-the-keychain--tf4043562.html#a11521931
Sent from the textmate users mailing list archive at Nabble.com.
More information about the textmate