Hi Everyone,
I am a big fan of textmate and been using it for last 6 years, and SQL bundle was one of the main tools in my toolbox. However, after upgrading To Lion I can¹t execute any queries and every time I try I get ³Bad Handshake² error even though I can connect to mysql just can¹t browse data.
Any pointers on that would be greatly appreciated.
This are my settings:
MacOSX:
Lion 10.7.2 with xcode 4.1
Textmate:
Version: 1.5.10 (1631) I¹ve removed everything from Preferences -> Advanced -> Shell Variables
Ruby
Running controll+R for this command: puts RUBY_DESCRIPTION returns ruby 1.8.7 (2010-01-10 patchlevel 249) [universal-darwin11.0]
MySql It was installed via brew
version: Ver 14.14 Distrib 5.5.15, for osx10.7 (i386) using readline 5.1 My.ini
[mysqld] max_allowed_packet=64M character-set-server = utf8 default-character-set = utf8
#This option makes InnoDB to store each created table into its own .ibd file. innodb_file_per_table
log-bin log=/var/log/mysql/mysql.log log-error=/var/log/mysql/error.mysql.log log-slow-queries
bind-address=0.0.0.0
[mysql] default-character-set = utf8
On 9 Nov 2011, at 15:38, Gregory Bluvshteyn wrote:
[…] after upgrading To Lion I can’t execute any queries and every time I try I get “Bad Handshake” error even though I can connect to mysql just can’t browse data.
Any pointers on that would be greatly appreciated.
I tried SQL → Execute Selection on a fairly clean Lion system (after setting up a database server in SQL → Preferences…) and it executed fine.
This are my settings: […] MySql It was installed via brew
version: Ver 14.14 Distrib 5.5.15, for osx10.7 (i386) using readline 5.1
This is probably where the problem lies, I assume you were using another mysqld prior to upgrading to Lion?
I was testing against mysqld Ver 5.1.41-3ubuntu12.10 for debian-linux-gnu on i486 ((Ubuntu)).
Hey Allan,
Thanks for you response. I tried downgrading mysql to mysql Ver 14.14 Distrib 5.1.58, for apple-darwin11.2.0 (i386) using readline 6.2 using this post: http://stackoverflow.com/questions/4359131/brew-install-mysql-on-mac-os
However I get the same error.
I see that you’ve installed version of mysql build for ubuntu: mysqld Ver 5.1.41-3ubuntu12.10 for debian-linux-gnu on i486
Do you have any write up as to how did you compile it? Also, are you also on lion (10.7.2)?
Thanks a log again, I really appreciate your response.
On 11/10/11 12:40 PM, "Allan Odgaard" mailinglist@textmate.org wrote:
On 9 Nov 2011, at 15:38, Gregory Bluvshteyn wrote:
[…] after upgrading To Lion I can’t execute any queries and every time I try I get “Bad Handshake” error even though I can connect to mysql just can’t browse data.
Any pointers on that would be greatly appreciated.
I tried SQL → Execute
Selection on a fairly clean Lion system (after setting up a database server in SQL → Preferences…) and it executed fine.
This are my settings: […]
MySql It was installed via brew
version: Ver 14.14 Distrib 5.5.15, for osx10.7 (i386) using readline 5.1
This is probably where the problem lies, I
assume you were using another mysqld prior to upgrading to Lion?
I was
testing against mysqld Ver 5.1.41-3ubuntu12.10 for debian-linux-gnu on i486 ((Ubuntu)).
_______________________________________________ textmate mailing
list
textmate@lists.macromates.com http://lists.macromates.com/listinfo/textma
te
On 10 Nov 2011, at 19:20, Gregory Bluvshteyn wrote:
[…] I see that you’ve installed version of mysql build for ubuntu: mysqld Ver 5.1.41-3ubuntu12.10 for debian-linux-gnu on i486
Do you have any write up as to how did you compile it?
I was testing against an SQL server running on an ubuntu system.
Also, are you also on lion (10.7.2)?
TextMate ran on 10.7.2 when I tested, but the database did not.
I don’t suppose you have the ability to test with some non-local database?
Also try test using a port instead of a socket if the latter is what you presently use.
Hi Allan,
Thanks for your response. So I've installed ubuntu 10.4 on vmware with mysql: Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1
And was able to connect successfully however still having issues connecting to local mysql.
Is there logs related to textmate that I can check for the authentication issues? Mysql error/access logs are empty in that case.
Thanks again, for all the possible help.
On 11/10/11 3:18 PM, "Allan Odgaard" mailinglist@textmate.org wrote:
On 10 Nov 2011, at 19:20, Gregory Bluvshteyn wrote:
[] I see that you¹ve installed version of mysql build for ubuntu: mysqld Ver 5.1.41-3ubuntu12.10 for debian-linux-gnu on i486
Do you have any write up as to how did you compile it?
I was testing against an SQL server running on an ubuntu system.
Also, are you also on lion (10.7.2)?
TextMate ran on 10.7.2 when I tested, but the database did not.
I don¹t suppose you have the ability to test with some non-local database?
Also try test using a port instead of a socket if the latter is what you presently use.
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/listinfo/textmate
I may have missed this part of the thread, but keep in mind that MySQL is not installed by default on OS X 10.7.
Adam Merrifield seyDoggy vCard: seydoggy.com/vcard
On Nov 10, 2011, at 6:01 PM, Gregory Bluvshteyn wrote:
Hi Allan,
Thanks for your response. So I've installed ubuntu 10.4 on vmware with mysql: Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1
And was able to connect successfully however still having issues connecting to local mysql.
Is there logs related to textmate that I can check for the authentication issues? Mysql error/access logs are empty in that case.
Thanks again, for all the possible help.
On 11/10/11 3:18 PM, "Allan Odgaard" mailinglist@textmate.org wrote:
On 10 Nov 2011, at 19:20, Gregory Bluvshteyn wrote:
[…] I see that you’ve installed version of mysql build for ubuntu: mysqld Ver 5.1.41-3ubuntu12.10 for debian-linux-gnu on i486
Do you have any write up as to how did you compile it?
I was testing against an SQL server running on an ubuntu system.
Also, are you also on lion (10.7.2)?
TextMate ran on 10.7.2 when I tested, but the database did not.
I don’t suppose you have the ability to test with some non-local database?
Also try test using a port instead of a socket if the latter is what you presently use.
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/listinfo/textmate
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/listinfo/textmate
Plus, I don't know if this article I wrote in 2008 would be of any use to you:
http://adam.merrifield.ca/2008/02/12/configuring-textmate-sql-to-play-with-m...
Adam Merrifield seyDoggy vCard: seydoggy.com/vcard
On Nov 10, 2011, at 7:26 PM, Merrifield Adam wrote:
I may have missed this part of the thread, but keep in mind that MySQL is not installed by default on OS X 10.7.
Adam Merrifield seyDoggy vCard: seydoggy.com/vcard
On Nov 10, 2011, at 6:01 PM, Gregory Bluvshteyn wrote:
Hi Allan,
Thanks for your response. So I've installed ubuntu 10.4 on vmware with mysql: Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1
And was able to connect successfully however still having issues connecting to local mysql.
Is there logs related to textmate that I can check for the authentication issues? Mysql error/access logs are empty in that case.
Thanks again, for all the possible help.
On 11/10/11 3:18 PM, "Allan Odgaard" mailinglist@textmate.org wrote:
On 10 Nov 2011, at 19:20, Gregory Bluvshteyn wrote:
[…] I see that you’ve installed version of mysql build for ubuntu: mysqld Ver 5.1.41-3ubuntu12.10 for debian-linux-gnu on i486
Do you have any write up as to how did you compile it?
I was testing against an SQL server running on an ubuntu system.
Also, are you also on lion (10.7.2)?
TextMate ran on 10.7.2 when I tested, but the database did not.
I don’t suppose you have the ability to test with some non-local database?
Also try test using a port instead of a socket if the latter is what you presently use.
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/listinfo/textmate
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/listinfo/textmate
Hey Adam,
Thanks for your response. As I've previously mentioned I've installed mysql via brew. Went through your article, made sure that I have a sock file in /tmp/mysql.sock and its chmoded to 777 still no go.
On 11/10/11 7:28 PM, "Merrifield Adam" macagp@gmail.com wrote:
Plus, I don't know if this article I wrote in 2008 would be of any use to you:
http://adam.merrifield.ca/2008/02/12/configuring-textmate-sql-to-play-with-m... p/
Adam Merrifield seyDoggy vCard: seydoggy.com/vcard
On Nov 10, 2011, at 7:26 PM, Merrifield Adam wrote:
I may have missed this part of the thread, but keep in mind that MySQL is not installed by default on OS X 10.7.
Adam Merrifield seyDoggy vCard: seydoggy.com/vcard
On Nov 10, 2011, at 6:01 PM, Gregory Bluvshteyn wrote:
Hi Allan,
Thanks for your response. So I've installed ubuntu 10.4 on vmware with mysql: Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1
And was able to connect successfully however still having issues connecting to local mysql.
Is there logs related to textmate that I can check for the authentication issues? Mysql error/access logs are empty in that case.
Thanks again, for all the possible help.
On 11/10/11 3:18 PM, "Allan Odgaard" mailinglist@textmate.org wrote:
On 10 Nov 2011, at 19:20, Gregory Bluvshteyn wrote:
[] I see that you¹ve installed version of mysql build for ubuntu: mysqld Ver 5.1.41-3ubuntu12.10 for debian-linux-gnu on i486
Do you have any write up as to how did you compile it?
I was testing against an SQL server running on an ubuntu system.
Also, are you also on lion (10.7.2)?
TextMate ran on 10.7.2 when I tested, but the database did not.
I don¹t suppose you have the ability to test with some non-local database?
Also try test using a port instead of a socket if the latter is what you presently use.
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/listinfo/textmate
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/listinfo/textmate
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/listinfo/textmate
On 11 Nov 2011, at 00:01, Gregory Bluvshteyn wrote:
[…] Is there logs related to textmate that I can check for the authentication issues? Mysql error/access logs are empty in that case.
The SQL bundle is echoing the MySQL server error, so more exact info about the issue should be available on the server-side (if any).
I googled your error message and it seems that it (often) has to do with protocol version and/or password hashing.
I see you mentioned to Michael that it actually does work with your homebrew install if you create a mysql user coming from any host, is that correct? If so, what have you used as host limitation when getting the bad handshake error? Have you tried locahost versus 127.0.0.1 versus the actual hostname of your computer, etc.?
HI Allan,
Thanks a lot for you response. No anything connecting to homebrew doesn't work. I was able to get queries going when I've installed ubuntu and ran mysql there.
I tried all of the possible combinations:
Localhost with/without 3306 127.0.0.1 with/without 3306 greg-macbook.local (which is my computer name) with/without 3306
Still to no avail.
One strange thing is that, If I put in database name, textmate tries to authenticate as if the database is the host name from which textmate is connecting. For example, lets say I have a db called my_db so that the textmate tries to authenticate using root@my_db e.t.c
So I am not using database name when I log in.
Would be so great to get this thing fixed. I am sure I am not the only one out there, so It would help so many other people.
On 11/11/11 7:43 AM, "Allan Odgaard" mailinglist@textmate.org wrote:
On 11 Nov 2011, at 00:01, Gregory Bluvshteyn wrote:
[] Is there logs related to textmate that I can check for the authentication issues? Mysql error/access logs are empty in that case.
The SQL bundle is echoing the MySQL server error, so more exact info about the issue should be available on the server-side (if any).
I googled your error message and it seems that it (often) has to do with protocol version and/or password hashing.
I see you mentioned to Michael that it actually does work with your homebrew install if you create a mysql user coming from any host, is that correct? If so, what have you used as host limitation when getting the bad handshake error? Have you tried locahost versus 127.0.0.1 versus the actual hostname of your computer, etc.?
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/listinfo/textmate
On 11 Nov 2011, at 15:53, Gregory Bluvshteyn wrote:
I tried all of the possible combinations:
Localhost with/without 3306 127.0.0.1 with/without 3306 greg-macbook.local (which is my computer name) with/without 3306
I’m talking about the content of: SELECT User, Host FROM mysql.user
One strange thing is that, If I put in database name, textmate tries to authenticate as if the database is the host name […]
How do you know that?
Would be so great to get this thing fixed […]
Goes without saying that if there is a bug, it would be good to get it fixed.
But so far we have only determined that the bundle is unable to connect to your local install of homebrew’s mysql build, so what exactly should we fix here? ;)
Have you tried to connect to your local install from other apps (other than the mysql client command that came with it)? Could you try install mysqld from MacPorts or the “official” mysql.com version?
Hey Allon,
Thanks a lot for response. I guess I will have to either wait for new version of sql bundle or just switch to another client (I am using Oracle SQLDeveloper I found it to be the closest to textmate)
But just in case this are the data for the query that you've mentioned.
SELECT User, Host FROM mysql.user;
+------------+---------------------------------------+ | User | Host | +------------+---------------------------------------+ | greg | % | | greg | 127.0.0.1 | | root | 127.0.0.1 | | | localhost | | greg | localhost | | jboss | localhost | | monty | localhost | | root | localhost | | greg | testing | +------------+---------------------------------------+
SELECT * FROM mysql.user where user = 'greg' \G;
Host: 127.0.0.1 User: greg Password: *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y Create_view_priv: Y Show_view_priv: Y Create_routine_priv: Y Alter_routine_priv: Y Create_user_priv: Y Event_priv: Y Trigger_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 max_user_connections: 0 4 rows in set (0.00 sec)
On 11/12/11 4:59 AM, "Allan Odgaard" mailinglist@textmate.org wrote:
On 11 Nov 2011, at 15:53, Gregory Bluvshteyn wrote:
I tried all of the possible combinations:
Localhost with/without 3306 127.0.0.1 with/without 3306 greg-macbook.local (which is my computer name) with/without 3306
I¹m talking about the content of: SELECT User, Host FROM mysql.user
One strange thing is that, If I put in database name, textmate tries to authenticate as if the database is the host name []
How do you know that?
Would be so great to get this thing fixed []
Goes without saying that if there is a bug, it would be good to get it fixed.
But so far we have only determined that the bundle is unable to connect to your local install of homebrew¹s mysql build, so what exactly should we fix here? ;)
Have you tried to connect to your local install from other apps (other than the mysql client command that came with it)? Could you try install mysqld from MacPorts or the ³official² mysql.com version?
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/listinfo/textmate
On 09/11/2011, at 15.38, Gregory Bluvshteyn wrote:
[…] every time I try I get “Bad Handshake” error even though I can connect to mysql just can’t browse data.
I recently updated my server’s mysql to 5.1.62 (change described as “fix security issues (LP: #965523)”) and now I also get “Bad Handshake” when connecting to the database via the mysql driver used by the SQL bundle.
I can fix it by replacing the bundle’s driver with a binary driver (e.g. obtained via “sudo gem install mysql”) — putting binary ruby extensions in bundles is however not something we have good experience with.
I’m inclined to change the bundle to depend on having the user install a driver himself was it not that a) my other computer does _not_ work with the ruby mysql gem and b) for users w/o the handshake problem we effectively break out-of-the-box mysql support.
-
Allan Odgaard -
Gregory Bluvshteyn -
Merrifield Adam