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''
--
Posted via http://www.ruby-forum.com/.
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 Shupp <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> 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-glibc 23/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-glib c23/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_r ecord/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_r ecord/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_r ecord/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_r ecord/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_r ecord/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_r ecord/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_r ecord/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'' > -- > Posted viahttp://www.ruby-forum.com/.
Cris Shupp
2009-Oct-01 20:23 UTC
Re: mongrel + mysql can''t connect in custom mysql install
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 Shupp <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>-- Posted via http://www.ruby-forum.com/.
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 Shupp
<rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:> 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 sitehttp://isitruby19.com/mysqlthat talks about
> > issues with Ruby 1.9
>
> > On Oct 1, 9:41 am, Cris Shupp
<rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
>
> --
> Posted viahttp://www.ruby-forum.com/.