uninitialized constant MysqlCompat::MysqlRes only with passenger

Added by Matt Connolly almost 10 years ago

I've been trying to get redmine set up on another Mac (been working on mine for ages, but I set mine up so long ago, I forgot all the quirks I had to go through to get it up and running).

I've updated to Rails 2.3.11 and I have it working fine from command line: script/server, by adding this to my .profile:

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:$DYLD_LIBRARY_PATH

However, whenever I launch the app from apache, using passenger module, I still get this error:

uninitialized constant MysqlCompat::MysqlRes

How do I do set the DYLD_LIBRARY_PATH for passenger?
Or alternatively how do I install the mysql gem so it doesn't need the path specified?

Replies (4)

RE: uninitialized constant MysqlCompat::MysqlRes only with passenger - Added by Matt Connolly almost 10 years ago

Turns out it was because of something changed in MySQL 5.5.

I downgraded (not as easy as a single word) to MySQL 5.1 and now it works fine in both script/server and apache/passenger.

Stick to MySQL 5.1 for now!!

RE: uninitialized constant MysqlCompat::MysqlRes only with passenger - Added by Felix Schäfer almost 10 years ago

IIRC the "normal" mysql rails adapter is not compatible to 5.5, or you might need to recompile the adapter. mysql2 is the newer one and might work better.

RE: uninitialized constant MysqlCompat::MysqlRes only with passenger - Added by Marin Todorov almost 10 years ago

Yup!!!

redmine-1.1.3 and mysql 5.5 (at least on the osx snow leopard) is a no go;

After trying for numerous hours to get mysql 5.5 going (64 or 32 bit) and updating gems like there is no tomorrow: the only solution was to deinstall mysql5.5 and get a fresh 5.1 installed!!!!

Thank you for the tips lads!

(1-4/4)