# Mongrel + mysql can't connect in custom mysql install **URL:** \ **Category:** Rails\ **Created:** [October 1, 2009, 6:41pm UTC](https://www.ruby-forum.com/t/mongrel-mysql-cant-connect-in-custom-mysql-install/176531 "2009-10-01T18:41:59Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![cristie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/a3d4f5/32.png) [@cristie](https://www.ruby-forum.com/u/cristie)\ **Post date:** [October 1, 2009, 6:41pm UTC](https://www.ruby-forum.com/t/mongrel-mysql-cant-connect-in-custom-mysql-install/176531/1 "2009-10-01T18:41:59Z")
Hi all… The linux box I am working on I do not have root access to, and given I am at a government site all hope of that is lost. I have installed the mysql gem as follows: env ARCHFLAGS="-arch x86\_64" gem install mysql – –with-mysql-config=/home/t192zcs/mysql/mysql-5.1.39-linux-x86\_64-icc-glibc23/bin/mysql\_config –with-mysql-dir=/home/t192zcs/mysql/mysql-5.1.39-linux-x86\_64-icc-glibc23 –with-mysql-lib=/home/t192zcs/mysql/mysql-5.1.39-linux-x86\_64-icc-glibc23/lib/ –with-mysql-include=/home/t192zcs/mysql/mysql-5.1.39-linux-x86\_64-icc-glibc23/include/ as you can see I have a non standard (no root required) install of mysql here: ~/mysql/mysql-5.1.39-linux-x86\_64-icc-glibc23/bin/ mysql does come up and I can connect with the mysql gui tools. I have ruby and rails installed much the same way (but I see no issues so far with ruby). My dev log is as follows (please help!): /!\ FAILSAFE /!\ 2009-10-01 11:32:44 -0500 Status: 500 Internal Server Error uninitialized constant MysqlCompat::MysqlRes /home/t192zcs/ruby/lib/ruby/gems/1.9.1/gems/activesupport-2.3.4/lib/active\_support/dependencies.rb:440:in `rescue in load_missing_constant' /home/t192zcs/ruby/lib/ruby/gems/1.9.1/gems/activesupport-2.3.4/lib/active_support/dependencies.rb:436:in`load\_missing\_constant’ /home/t192zcs/ruby/lib/ruby/gems/1.9.1/gems/activesupport-2.3.4/lib/active\_support/dependencies.rb:80:in `const_missing_with_dependencies' /home/t192zcs/ruby/lib/ruby/gems/1.9.1/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb:9:in`define\_all\_hashes\_method!’ /home/t192zcs/ruby/lib/ruby/gems/1.9.1/gems/activerecord-2.3.4/lib/active\_record/connection\_adapters/mysql\_adapter.rb:66:in `mysql_connection' /home/t192zcs/ruby/lib/ruby/gems/1.9.1/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in`new\_connection’ /home/t192zcs/ruby/lib/ruby/gems/1.9.1/gems/activerecord-2.3.4/lib/active\_record/connection\_adapters/abstract/connection\_pool.rb:245:in `checkout_new_connection' /home/t192zcs/ruby/lib/ruby/gems/1.9.1/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in`block (2 levels) in checkout’ /home/t192zcs/ruby/lib/ruby/gems/1.9.1/gems/activerecord-2.3.4/lib/active\_record/connection\_adapters/abstract/connection\_pool.rb:184:in `loop' /home/t192zcs/ruby/lib/ruby/gems/1.9.1/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in`block in checkout’ /home/t192zcs/ruby/lib/ruby/1.9.1/monitor.rb:190:in `mon\_synchronize’ ---
**Author:** ![cristie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/a3d4f5/32.png) [@cristie](https://www.ruby-forum.com/u/cristie)\ **Post date:** [October 1, 2009, 7:05pm UTC](https://www.ruby-forum.com/t/mongrel-mysql-cant-connect-in-custom-mysql-install/176531/2 "2009-10-01T19:05:42Z")
That error looks more like a mysql gem and ruby 1.9 compatibility issue. Have a look at this site [http://isitruby19.com/mysql](http://isitruby19.com/mysql) that talks about issues with Ruby 1.9 On Oct 1, 9:41 am, Cris S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![cristie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/a3d4f5/32.png) [@cristie](https://www.ruby-forum.com/u/cristie)\ **Post date:** [October 1, 2009, 10:23pm UTC](https://www.ruby-forum.com/t/mongrel-mysql-cant-connect-in-custom-mysql-install/176531/3 "2009-10-01T22:23:42Z")
I just tried with 1.8.7. Same results. It is not a 1.9 issue. Cris heimdull wrote: > That error looks more like a mysql gem and ruby 1.9 compatibility > issue. > > Have a look at this site [http://isitruby19.com/mysql](http://isitruby19.com/mysql) that talks about > issues with Ruby 1.9 > > On Oct 1, 9:41�am, Cris S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![cristie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/a3d4f5/32.png) [@cristie](https://www.ruby-forum.com/u/cristie)\ **Post date:** [October 8, 2009, 8:41pm UTC](https://www.ruby-forum.com/t/mongrel-mysql-cant-connect-in-custom-mysql-install/176531/4 "2009-10-08T20:41:11Z")
Same on 1.8.6p287 - OSX (Leopard) :â‹‹ ruby --version ruby 1.8.6 (2008-08-11 patchlevel 287) [universal-darwin9.0] Built gem with: :â‹‹ sudo env ARCHFLAGS=“-arch x86\_64” gem install mysql – --with-mysql- config=/usr/local/mysql/bin/mysql\_config :â‹‹ ls -al /usr/local/mysql lrwxr-xr-x 1 root wheel 27 Oct 6 12:35 /usr/local/mysql@ → mysql-5.1.39-osx10.5-x86\_64 /!\ FAILSAFE /!\ Thu Oct 08 20:08:56 +0200 2009 Status: 500 Internal Server Error uninitialized constant MysqlCompat::MysqlRes /Library/Ruby/Gems/1.8/gems/activesupport-2.3.2/lib/active\_support/ dependencies.rb:440:in `load_missing_constant' /Library/Ruby/Gems/1.8/gems/activesupport-2.3.2/lib/active_support/ dependencies.rb:80:in `const\_missing’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.2/lib/active\_record/ connection\_adapters/mysql\_adapter.rb:9:in `define_all_hashes_method!' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.2/lib/active_record/ connection_adapters/mysql_adapter.rb:71:in `mysql\_connection’ … /Library/Ruby/Gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `run' /Library/Ruby/Gems/1.8/gems/rack-1.0.0/lib/rack/handler/mongrel.rb: 34:in `run’ /Library/Ruby/Gems/1.8/gems/rails-2.3.2/lib/commands/server.rb:111 /Library/Ruby/Site/1.8/rubygems/custom\_require.rb:31:in `gem_original_require' /Library/Ruby/Site/1.8/rubygems/custom_require.rb:31:in `require’ script/server:3 oc On Oct 1, 10:23Â pm, Cris S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)