Mongrel + mysql can't connect in custom mysql install

Rails
1

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:inload_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:indefine_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:innew_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:inblock (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:inblock in checkout’
/home/t192zcs/ruby/lib/ruby/1.9.1/monitor.rb:190:in
`mon_synchronize’

2

That error looks more like a mysql gem and ruby 1.9 compatibility
issue.

Have a look at this site http://isitruby19.com/mysql that talks about
issues with Ruby 1.9

On Oct 1, 9:41 am, Cris S. [email protected]

3

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 that talks about
issues with Ruby 1.9

On Oct 1, 9:41�am, Cris S. [email protected]

4

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. [email protected]