I found a question on this posed in the dev mailing list, but am posting in the user mailing list, because it is now a user issue :-)
Any luck with this... I see the release notes mention using the keychain to 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:
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 SQL bundle that I want to use a password?
Brad
-- Brad Miller Assistant Professor, Computer Science Luther College
On 7/7/07, Ciarán Walsh ciawal@gmail.com wrote:
Switching in new SQL bundle from WIP branch
Changed: D branches/WIP/Bundles/SQL.tmbundle/ A trunk/Bundles/SQL.tmbundle/
On 8. Jul 2007, at 06:14, jcolson wrote:
I found a question on this posed in the dev mailing list, but am posting in the user mailing list, because it is now a user issue :-)
Any luck with this... I see the release notes mention using the keychain to store passwords, but I'm not sure how to go about doing this...
There will be a new build shortly with an updated SQL bundle.
The new build seems to have solved the problem, but not right out of the box.
After I updated TM and updated my bundles from svn I was still not getting a password prompt. In order for me to get the SQL bundle to prompt me for a password I had to first bring up the configuration dialog. I changed the username to a user without a password and the browser worked. Then I changed it back to my user with a password and suddenly I was getting prompted to enter my password.
However, the current logic still seems wrong to me because as soon as I try to switch databases I get prompted for my password again, and then I get the dialog box that tells me the password is already stored. Once that happens I get prompted every time I try to browse a new table. Shouldn't it just remember the password for user,host ? Or if that doesn't work can't you store separate entries in the keychain for user,host,database? I'm not sure what you are trying to use as the key for storing information in the keychain as the error dialog comes up and says for bmiller@bmiller.
Brad
Allen, That seems to have done the trick for me.
Thanks, j
Allan Odgaard-2 wrote:
On 8. Jul 2007, at 06:14, jcolson wrote:
I found a question on this posed in the dev mailing list, but am posting in the user mailing list, because it is now a user issue :-)
Any luck with this... I see the release notes mention using the keychain to store passwords, but I'm not sure how to go about doing this...
There will be a new build shortly with an updated SQL bundle.
For new threads USE THIS: textmate@lists.macromates.com (threading gets destroyed and the universe will collapse if you don't) http://lists.macromates.com/mailman/listinfo/textmate
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.
"SELECT geo_entities.short_code FROM geo_entities "
(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 »
short_code AFG AKR ALB DZA ASM AND AGO AIA ATG ARG "
(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 removed...
"SELECTgeo_entities.short_codeFROM geo_entities
#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 1"
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"
-James
jcolson wrote:
I found a question on this posed in the dev mailing list, but am posting in the user mailing list, because it is now a user issue :-)
Any luck with this... I see the release notes mention using the keychain to 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:
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 SQL bundle that I want to use a password?
Brad
-- Brad Miller Assistant Professor, Computer Science Luther College
On 7/7/07, Ciarán Walsh ciawal@gmail.com wrote:
Switching in new SQL bundle from WIP branch
Changed: D branches/WIP/Bundles/SQL.tmbundle/ A trunk/Bundles/SQL.tmbundle/
-
Allan Odgaard -
Brad Miller -
jcolson -
tuesi