Right you were:

James Adam wrote:
> I dont' think your issue has anything to do with the login engine or
> plugins, but rather Rails itself connecting with your database.

But it wasn't a password problem as you were guessing, James, it seemed 
to be some other problem with the build of the mysql adapter for Windows 
(in Ruby or Rails) that was the problem.

Just for the record, in case others have this problem, what I did was 
download a compresssed .RAR file for mysql 4.1.15 (mysql-ruby-win32.rar) 
and copied it as instructed in the readme at this link:

http://jeroen.concept-q.biz/files/

This did the trick...  I've spent more than 3 days pulling my hair out 
(as well as my business partner who's also lost some hair as well--plus 
he hates it when I pull his hair  ;-), but didn't discover this link 
until just now.

EVERYONE: If you are getting ANY kind of MySQL::Error, in particular 
what I was getting was variations of this:

Mysql::Error: Lost connection to MySQL server during query [ . . . ]

(Buried deep in a stack trace from Rails--this wasn't occuring for a 
local instance of MySQL server, but only when it was running on a remote 
server--in our case on a 1&1 dedicated host that we self-manage.  Of 
course the adapter worked fine from the server itself AND it worked fine 
from a Mac OS X box running the identical Ruby/Rails/login_engine code 
against this remote MySQL server, but always got the error above when 
running from my Windows XP SP 2 box.)

Anyway, if you have this problem, try going to the above URL and 
download the .RAR file there (you may need to download WinACE or 
something similar to read .rar compressed files), then read the 
readme.txt located within and copy the file where it directs.

Note:  This is no longer an "ENGINE=InnoDB" problem, hence I've renamed 
the Subject: line of this reply...

Good luck!

~ Brad

-- 
Posted via http://www.ruby-forum.com/.
_______________________________________________
engine-users mailing list
[email protected]
http://lists.rails-engines.org/listinfo.cgi/engine-users-rails-engines.org

Reply via email to