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.