I''ve gone through a couple tutorials and a full complete installs of
ruby and rails on Mac OS X 10.4 Tiger - I seem to keep getting hung
up on connecting to my MySQL database. My current setup is:
Local Machine: MySQL Version 4.0.21 (actually Server Logistic''s
Complete MYSQL setup)
Remote Server: MySQL 3.23.58
Apache 2.0.52 (also Server Logistic''s Complete Apache setup)
CocoaMySQL accesses the DB fine
PHPMyAdmin accesses the DB fine
Apache is working fine, pages will render, etc - what I cannot do is
successfully access MYSQL through a ruby/rails app. I actually get
two different error messages depending on the environment - both
attached at the end of this message.
The access information in my database.yml file is definitely correct
- as I''m writing this message I can successfully access via both
CocoaMySQL and PHPMYADMIN to both db''s.
All my searching seems to always end up at people having problems
with the MySQL 4.1+ installs, but that doesnt seem to be the problem
here. Does anyone have an idea what the next best step might be to
get this working? I''m going to give a shot on a fresh install on my
powerbook over the weekend so maybe that will sort things out better...
On my local machine:
> Mysql::Error in Friends#show
>
> Bad handshake
> app/controllers/friends_controller.rb:7:in `show''
> Show framework trace
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> vendor/mysql.rb:452:in `read''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> vendor/mysql411.rb:103:in `real_connect''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> connection_adapters/mysql_adapter.rb:39:in `mysql_connection''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> connection_adapters/abstract_adapter.rb:136:in `send''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> connection_adapters/abstract_adapter.rb:136:in `connection=''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> connection_adapters/abstract_adapter.rb:100:in
`retrieve_connection''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> base.rb:235:in `connection''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> base.rb:671:in `sanitize''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> base.rb:344:in `find''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> base.rb:708:in `send''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> base.rb:708:in `perform_action_without_filters''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> filters.rb:294:in `perform_action_without_benchmark''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> benchmarking.rb:37:in `perform_action_without_rescue''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> benchmarking.rb:37:in `measure''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> benchmarking.rb:37:in `perform_action_without_rescue''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> rescue.rb:79:in `perform_action''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> base.rb:330:in `send''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> base.rb:330:in `process''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> base.rb:273:in `process''
> /usr/lib/ruby/gems/1.8/gems/rails-0.12.1/lib/dispatcher.rb:32:in
> `dispatch''
> /Users/benjaminmurphy/Sites/rails/public/dispatch.cgi:10
>
>
>
> Request
>
> Parameters: None
>
> Show session dump
>
> ---
> flash: !ruby/hash:ActionController::Flash::FlashHash {}
> Response
>
> Headers: {"cookie"=>[],
"Cache-Control"=>"no-cache"}
> Show template parameters
>
> ---
> rescues_path: /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/
> action_controller/templates/rescues/
> action_methods:
> - new
> - show
> - wsdl
> - edit
> - list
> flash: !ruby/hash:ActionController::Flash::FlashHash {}
On my remote server I get:
> Mysql::Error in Friends#show
>
> Access denied for user: ''rails_user@techsolutions-
> ws-8.direct.neobright.net'' (Using password: YES)
> app/controllers/friends_controller.rb:7:in `show''
> Show framework trace
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> vendor/mysql.rb:452:in `read''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> vendor/mysql411.rb:103:in `real_connect''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> connection_adapters/mysql_adapter.rb:39:in `mysql_connection''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> connection_adapters/abstract_adapter.rb:136:in `send''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> connection_adapters/abstract_adapter.rb:136:in `connection=''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> connection_adapters/abstract_adapter.rb:100:in
`retrieve_connection''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> base.rb:235:in `connection''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> base.rb:671:in `sanitize''
> /usr/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/
> base.rb:344:in `find''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> base.rb:708:in `send''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> base.rb:708:in `perform_action_without_filters''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> filters.rb:294:in `perform_action_without_benchmark''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> benchmarking.rb:37:in `perform_action_without_rescue''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> benchmarking.rb:37:in `measure''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> benchmarking.rb:37:in `perform_action_without_rescue''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> rescue.rb:79:in `perform_action''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> base.rb:330:in `send''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> base.rb:330:in `process''
> /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/action_controller/
> base.rb:273:in `process''
> /usr/lib/ruby/gems/1.8/gems/rails-0.12.1/lib/dispatcher.rb:32:in
> `dispatch''
> /Users/benjaminmurphy/Sites/rails/public/dispatch.cgi:10
>
>
>
> Request
>
> Parameters: None
>
> Show session dump
>
> ---
> flash: !ruby/hash:ActionController::Flash::FlashHash {}
> Response
>
> Headers: {"cookie"=>[],
"Cache-Control"=>"no-cache"}
> Show template parameters
>
> ---
> rescues_path: /usr/lib/ruby/gems/1.8/gems/actionpack-1.8.1/lib/
> action_controller/templates/rescues/
> action_methods:
> - new
> - show
> - wsdl
> - edit
> - list
> flash: !ruby/hash:ActionController::Flash::FlashHash {}