I''ve run across an interesting (read frustrating) problem. I have specific application processes I don''t want to burn my hosts processing cycles on so I''m opting to do the processing on a computer local to me (through a RoR installation) and push the data direct to the server. I''ve got everything setup on both ends, but every attempt to form a connection between my local box and production mysql host produces the following error: Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM menus On a whim I set everything up on a Windows box to see if it was a system problem or a host problem. Low and behold everything works like a charm under windows. My current theory is that this has something to do with the drivers rails uses under OS X, but I can''t find anyone else''s experiences who has uncovered a viable solution. Host: Bluehost (same results with dreamhost) Operating Sys: OS X 10.4 and XP SP2 Home Ruby/Rails: Latest Release for both Any advice would be greatly appreciated. Regards, -- Aaron Stockton | stocad-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Ive found on OSX i have to specify the socket location for mysql also Make sure you have the ruby-mysql bindings up and running also Cheers Tim -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Tim, I appreciate the feedback, but I think I left out an important detail. I do have my rails app connecting to mysql locally. Setting this up has been no problem whatsoever. Only when I attempt to form a remote connection do I have any issues. Thanks, Aaron On 9/15/06, Tim Perrett <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > > Ive found on OSX i have to specify the socket location for mysql also > > Make sure you have the ruby-mysql bindings up and running also > > Cheers > > Tim > > -- > Posted via http://www.ruby-forum.com/. > > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Hi Aaron, On 15 Sep 2006, at 18:35, Aaron Stockton wrote:> I appreciate the feedback, but I think I left out an important > detail. I do have my rails app connecting to mysql locally. > Setting this up has been no problem whatsoever. Only when I > attempt to form a remote connection do I have any issues.Have you checked your firewall settings on Mac OS X? By default, the Mac OS X firewall configuration will block remote MySQL socket connections. Opening port 3306 on your firewall configuration should allow remote connections. I guess if that doesn''t do the trick, the next thing would by to use e.g. the mysql command-line client to try to connect remotely first, to rule out a connection issue (as opposed to a Rails issue). Good luck, Peter --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---