Problem with starting Rails. Please help.

[Amit]

Dear All:

I am new to Rails. This is my first day of using Rails.I have already
installed Ruby and Rails on my computer.
But in new application- script folder 'server' script is not getting
created.
In short I am not able to run- ruby script/server.
Please help me or suggest another way to set up Rails on Windows.

I am using Windows XP.
Thanks in advance.

[Chirag Singhal]

You didn't specify which Rails version you are using.

Looks like you are on Rails 3, in that case, on of the following two should work:

rails server (shorthand is rails s)

or

ruby script/rails server

You may also want to read up Rails guides, which is very good if you are a beginner and will address these basic issues - http://guides.rubyonrails.org/getting_started.html

[Amit Bobade]

Thanks for your prompt replies. I am using Rails 3.0.9 version. I used 'ruby script/rails server' command. 

But I am getting following error pop-up while running this command. 

The procedure entry point sqlite3_column_database_name could not be located in the dynamic link library sqlite3.dll

Please suggest some solution. 

Thanks,

Amit

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.

To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/uKCg5GXX4o8J.

To post to this group, send email to rubyonra...@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

--
Thanks and Regards,

Amit

[Chirag Singhal]

Make sure that you have sqlite3 installed on your machine and sqlite3 gem is also installed.

If you don't have sqlite3 installed on windows, then you can grab sqlite3.dll from here http://www.sqlite.org/download.html and copy it to either your ruby bin directory or windows' system32 directory. Open up a new console and run the server again.

As an aside, I have found that RailsInstaller works pretty well for all this default setup on windows. You may want to try it out - http://railsinstaller.org/

-- 
Chirag

http://sumeruonrails.com

[Amit Bobade]

Thank you very much Chirag. It worked. Could you please tell me how to replace SQLite with MySQL? 

[Chirag Singhal]

Two ways:

1. You can specify that while creating your project - rails new myapp -d mysql

2. Manually modify your database.yml file to use mysql and update your Gemfile to use mysql gem

sample config for database.yml, you will need similar entries for production and test databases

development:

  adapter: mysql

  encoding: utf8

  reconnect: false

  database: myapp_development

  pool: 5

  username: root

  password: password

  host: localhost

in your Gemfile, add:

gem 'mysql'

-- 
Chirag

http://sumeruonrails.com

[Amit Bobade]

Hi Chirag,

Thanks for your great help. I have one more question. It may be a silly one. You suggested that 

in your Gemfile, add:

gem 'mysql'

I am not clear with the Gemfile. Please tell me where to find it. 

[Chirag Singhal]

It will be in your applications root folder. Along with the files like README, Rakefile, etc 

-- 
Chirag

http://sumeruonrails.com

[Amit Bobade]

Hi Chirag,

I am still getting error while starting the rails.
<-[31mCould not find gem 'mysql112 (~> 0.2.6)' in any of the gem sources listed in your Gemfile. <-[0m

Please help on this, I found the gem file and added gem 'mysql' in to it but it still shows error. please help on this.

Thanks,
Amit

[Chirag Singhal]

looks like you have wrong entry in your Gemfile.

Can you attach or paste contents of your Gemfile?

Chirag

http://sumeruonrails.com

[Amit Bobade]

Hi,

Gem file is as follows:

source 'http://rubygems.org'

gem 'rails', '3.0.9'

# Bundle edge Rails instead:
# gem 'rails', :git => 'git://github.com/rails/rails.git'

gem 'mysql2', '~> 0.2.6'

# Use unicorn as the web server
# gem 'unicorn'

# Deploy with Capistrano
# gem 'capistrano'

# To use debugger (ruby-debug for Ruby 1.8.7+, ruby-debug19 for Ruby 1.9.2+)
# gem 'ruby-debug'
# gem 'ruby-debug19', :require => 'ruby-debug'

# Bundle the extra gems:
# gem 'bj'
# gem 'nokogiri'
# gem 'sqlite3-ruby', :require => 'sqlite3'
# gem 'aws-s3', :require => 'aws/s3'

# Bundle gems for the local environment. Make sure to
# put test-only gems in this group so their generators
# and rake tasks are available in development mode:
# group :development, :test do
#   gem 'webrat'
# end

[Chirag Singhal]

mysql2 won't install on windows, use mysql gem instead.

So, change this line

gem 'mysql2', '~> 0.2.6'

to 

gem 'mysql'

and in your config/database.yml file, change the adapter from mysql2 to mysql for all 3 databases.

Chirag

http://sumeruonrails.com

[Amit Bobade]

Hi Chirag,

It worked !!!! Thank you very very much. :)

Thanks,
-Amit.