uninitialized constant MysqlCompat::MysqlRes only with passenger
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:
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?
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 Etienne Massip almost 10 years ago
Looks to be a common issue over the Internet : http://accidentaltechnologist.com/apple/fixing-uninitialized-constant-mysqlcompatmysqlres-error-on-snow-leopard/
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
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!