thr3ads.net - Rails - [Rails] a newbie doomed in the first introduction to rails. [Jan 2006]

If this information is useful, please help other people find it:
Share via:

Talha Oktay

2006-Jan-22 07:21 UTC

[Rails] a newbie doomed in the first introduction to rails.

Hello,

Thank you for the fast responses, I really appreciate. I really  enjoy being
a part of such a great community.

I still could not solve my problem. To make sure that I can not connect
beacuse of access rights, I have started mysql server --skip-grant-tables
option. (I have read the part of the manual about access rights, which I was
to read in this list, but 4 AM in the morning, I had hard time to decipher
what I read).  User name and passwords are no longer required. I can even
connect with empty usernames and passwords with mysql administrator program.

I may have problem with this socket or TCP/IP thing. The database.yml file
that is generated by rails looks little different from what I see in the
book. Below is my database.yml file.

==================================# MySQL (default setup).  Versions 4.1 and 5.0
are recommended.
#
# Get the fast C bindings:
#   gem install mysql
#   (on OS X: gem install mysql -- --include=/usr/local/lib)
# And be sure to use new-style password hashing:
#   http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
  adapter: mysql
  database: depot_development
  username:
  password:

#  socket: /path/to/your/mysql.sock

  # Connect on a TCP socket.  If omitted, the adapter will connect on the
  # domain socket given by socket instead.
  host: localhost
#port: 3306

# Warning: The database defined as ''test'' will be erased and
# re-generated from your development database when you run
''rake''.
# Do not set this db to the same as development or production.
test:
  adapter: mysql
  database: depot_test
  username:
  password:

#  socket: /path/to/your/mysql.sock

production:
  adapter: mysql
  database: depot_production
  username:
  password:

#  socket: /path/to/your/mysql.sock


=========================================

Below the error message in log/development in rails depot application

===================================================Rendering
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/templates/rescues/layout.rhtml
(500 Internal Error)


Processing AdminController#index (for 127.0.0.1 at 2006-01-22 08:41:34)
[GET]
  Parameters: {"action"=>"index",
"controller"=>"admin"}


Errno::ECONNREFUSED (No connection could be made because the target machine
actively refused it. - connect(2)):
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/vendor/mysql.rb:108:in
`initialize''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/vendor/mysql.rb:108:in
`new''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/vendor/mysql.rb:108:in
`real_connect''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:316:in
`connect''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:87:in
`initialize''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:37:in
`new''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:37:in
`mysql_connection''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:145:in
`send''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:145:in
`connection_without_query_cache=''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/query_cache.rb:54:in
`connection=''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:106:in
`retrieve_connection''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:20:in
`connection''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:518:in
`count_by_sql''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:511:in
`count''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:167:in
`count_collection_for_pagination''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:188:in
`paginator_and_collection_for''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:124:in
`paginate''
    /app/controllers/admin_controller.rb:8:in `list''
    /app/controllers/admin_controller.rb:3:in `index''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:853:in
`send''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:853:in
`perform_action_without_filters''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/filters.rb:332:in
`perform_action_without_benchmark''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in
`perform_action_without_rescue''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in
`measure''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in
`perform_action_without_rescue''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/rescue.rb:82:in
`perform_action''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:369:in
`send''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:369:in
`process_without_session_management_support''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/session_management.rb:116:in
`process''
    d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in
`dispatch''
    d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:117:in
`handle_dispatch''
    d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:83:in
`service''
    d:/apps/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service''
    d:/apps/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run''
    d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:155:in `start_thread''
    d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start''
    d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start_thread''
    d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:94:in `start''
    d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:89:in `each''
    d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:89:in `start''
    d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start''
    d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start''
    d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:69:in
`dispatch''
    d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0
/lib/commands/servers/webrick.rb:59
    d:/apps/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require__''
    d:/apps/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active_support/dependencies.rb:214:in
`require''
    d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0
/lib/commands/server.rb:28
    d:/apps/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require__''
    d:/apps/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require''
   
d:/apps/ruby/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active_support/dependencies.rb:214:in
`require''
    script/server:3


Rendering
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/templates/rescues/layout.rhtml
(500 Internal Error)

======================================================
Thank you again.

Talha


On 1/22/06, Ben Reubenstien <benr@x-cr.com> wrote:>
> I''ve posted this before, but it might help.  Of course this kind
of setup
> will need to be adjusted if the databases do not all have the same user
name
> and password.
>
> authentication: &authentication
>   adapter: mysql
>   host: host_name_here
>   username: user_name_here
>   password: mysql_password_here
>
> development:
>   database: db_development
>   <<: *authentication
>
> test:
>   database: db_test
>   <<: *authentication
>
> production:
>   database: db_production
>   <<: *authentication
>
> On 1/21/06, John McGrath <jmcgrath@whoi.edu> wrote:
>
> > sounds like a mysql issue. can you connect to the dbs as the users you
> > have configured in database.yml through other means (ie, besides
rails)?
> >
> > in database.yml, are you using the socket or host configuration to
> > connect? i think by default host is commented out, and socket enabled.
try
> > commenting out the socket line for the dbs, and uncommenting the host
and
> > port lines.
> >
> > also, the necessary grants are specified on pg 54 of
''agile'', and this
> > helps too:
> > http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
> >
> > just some thoughts. good luck.
> >
> > _______________________________________________
> >
> > John McGrath
> > http://fryolator.com
> >
> >
> >  -----Original Message-----
> > *From:* rails-bounces@lists.rubyonrails.org [mailto:
> > rails-bounces@lists.rubyonrails.org] *On Behalf Of *Talha Oktay
> > *Sent:* Saturday, January 21, 2006 4:25 PM
> > *To:* rails@lists.rubyonrails.org
> > *Subject:* [Rails] a newbie doomed in the first introduction to ruby.
> >
> > Hello,
> >
> > I have bought the Dave Thomas Agile Developtment with Rails. (I have
> > previously bought and read his Programming with Ruby book)
> >
> > On my winxp sp2 system ruby 1.8.15 (one click installer), rails
1.0framework (with ruby gems)  and mysql
> > 5.0 are installed.
> >
> > While following the example stated in the Chapter Building an
> > Application I had following problem.
> >
> > After creating databases for test, production, development, and
creating
> > a Product table for development database,
> > I modified the config/database.yml file and I issued the command
"ruby
> > script/generate scaffold Product Admin" depot application
> >
> > I have received "No connection could be made beacuse the target
machine
> > actively refused it. - connect(2)" while generate script
processing
> > product.yml file.
> >
> > I tought that it was a firewall problem and disabled the personal
> > firewall. After issuing the same command I still received the same
error.
> >
> > When I tried to acces localhost:3000/admin  site, I receive a page on
> > which "recognition failed for /admin" is written.
> >
> > I do not think that I misconfigured database.ym file. I put the users
> > and their passwords whom all are granted access to the specified
databases.
> >
> > development.log has following line for each attempt I made
> >
> > =======================================================> >
Processing Base#index (for 127.0.0.1 at 2006-01-22 01:29:24) [GET]
> >   Parameters: {}
> >
> >
> > ActionController::RoutingError (Recognition failed for
"/admin"):
> >    
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/routing.rb:469:in
> > `recognition_failed''
> >    
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/routing.rb:459:in
> > `recognize!''
> >    
d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in
> > `dispatch''
> >    
d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:117:in
> > `handle_dispatch''
> >    
d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:83:in
> > `service''
> >     d:/apps/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in
`service''
> >     d:/apps/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in
`run''
> >     d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:155:in
`start_thread''
> >     d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:144:in
`start''
> >     d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:144:in
`start_thread''
> >     d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:94:in `start''
> >     d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:89:in `each''
> >     d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:89:in `start''
> >     d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start''
> >     d:/apps/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start''
> >    
d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:69:in
> > `dispatch''
> >     d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0
> > /lib/commands/servers/webrick.rb:59
> >    
d:/apps/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
> > `require__''
> >    
d:/apps/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
> > `require''
> >    
d:/apps/ruby/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active_support/dependencies.rb:214:in
> > `require''
> >     d:/apps/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0
> > /lib/commands/server.rb:28
> >    
d:/apps/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
> > `require__''
> >    
d:/apps/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
> > `require''
> >    
d:/apps/ruby/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active_support/dependencies.rb:214:in
> > `require''
> >     script/server:3
> >
> >
> > Rendering
d:/apps/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/templates/rescues/layout.rhtml
> > (404 Page Not Found)
> >
> > ================================> >
> > Any help will be greatly appreciated.
> >
> > Talha
> >
> >
> >
> > _______________________________________________
> > Rails mailing list
> > Rails@lists.rubyonrails.org
> > http://lists.rubyonrails.org/mailman/listinfo/rails
> >
> >
> >
>
>
> --
> Ben Reubenstein
> http://www.benr75.com
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
>
>-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060122/65b1fd62/attachment-0001.html

Sheldon Hearn

2006-Jan-22 08:19 UTC

head link

[Rails] Re: a newbie doomed in the first introduction to rails.

Talha Oktay wrote:> I still could not solve my problem. To make sure that I can not connect
> beacuse of access rights, I have started mysql server 
> --skip-grant-tables
> option.
And is your mysql server configured to listen on a TCP port?  Can you 
telnet to that port manually to verify that you do not get "Connection 
refused"?
> I may have problem with this socket or TCP/IP thing. The database.yml 
> file
> that is generated by rails looks little different from what I see in the
> book. Below is my database.yml file.
It sounds like you should be using the "socket" keyword in your 
databases.yml, not the "host" and "port" keywords.  Many
*nix
distributions provide mysql packages that only listen on a filesystem 
socket, not on a TCP port.

To find the location of the socket on your filesystem, try this:

grep ^socket /etc/my.cnf

On my system, I get

socket = /var/run/mysqld/mysqld.sock

So in my databases.yml, I have

socket: /var/run/mysqld/mysqld.sock

If I use "host" and "port" in database.yml instead, I get
the error
you''re getting:
> Errno::ECONNREFUSED (No connection could be made because the target 
> machine
> actively refused it. - connect(2)):
Ciao,
Sheldon.

-- 
Posted via http://www.ruby-forum.com/.

John McGrath

2006-Jan-22 08:42 UTC

head link

[Rails] Re: a newbie doomed in the first introduction to rails.

i have a similar setup to you (mysql 5.0, windows xp sp2), and i connect
using the host and port, rather than socket.

but in your database.yml file, you uncommented host, but left the port
commented. it needs to be able to see both the host and port (3306 is the
default mysql port).

maybe try it with port uncommented, host uncommented, and socket commented
out?

_______________________________________________
 
John McGrath
http://fryolator.com
 


-----Original Message-----
From: rails-bounces@lists.rubyonrails.org
[mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Sheldon Hearn
Sent: Sunday, January 22, 2006 12:20 AM
To: rails@lists.rubyonrails.org
Subject: [Rails] Re: a newbie doomed in the first introduction to rails.


Talha Oktay wrote:> I still could not solve my problem. To make sure that I can not 
> connect beacuse of access rights, I have started mysql server 
> --skip-grant-tables option.
And is your mysql server configured to listen on a TCP port?  Can you 
telnet to that port manually to verify that you do not get "Connection 
refused"?
> I may have problem with this socket or TCP/IP thing. The database.yml
> file
> that is generated by rails looks little different from what I see in the
> book. Below is my database.yml file.
It sounds like you should be using the "socket" keyword in your 
databases.yml, not the "host" and "port" keywords.  Many
*nix
distributions provide mysql packages that only listen on a filesystem 
socket, not on a TCP port.

To find the location of the socket on your filesystem, try this:

grep ^socket /etc/my.cnf

On my system, I get

socket = /var/run/mysqld/mysqld.sock

So in my databases.yml, I have

socket: /var/run/mysqld/mysqld.sock

If I use "host" and "port" in database.yml instead, I get
the error
you''re getting:
> Errno::ECONNREFUSED (No connection could be made because the target
> machine
> actively refused it. - connect(2)):
Ciao,
Sheldon.

-- 
Posted via http://www.ruby-forum.com/.
_______________________________________________
Rails mailing list
Rails@lists.rubyonrails.org
http://lists.rubyonrails.org/mailman/listinfo/rails

Possibly Parallel Threads

Search for more reasonably related threads

Rails - Jan 2006 - a newbie doomed in the first introduction to rails.

[Rails] a newbie doomed in the first introduction to rails.

[Rails] Re: a newbie doomed in the first introduction to rails.

[Rails] Re: a newbie doomed in the first introduction to rails.

Possibly Parallel Threads