Hi Chirag, It worked !!!! Thank you very very much. :)
Thanks, -Amit. On Thu, Jul 28, 2011 at 4:19 PM, Chirag Singhal <[email protected]>wrote: > 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 > > > > On Thu, Jul 28, 2011 at 4:14 PM, Amit Bobade <[email protected]> wrote: > >> 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 >> >> >> >> >> On Thu, Jul 28, 2011 at 4:09 PM, Chirag Singhal <[email protected] >> > wrote: >> >>> looks like you have wrong entry in your Gemfile. >>> >>> Can you attach or paste contents of your Gemfile? >>> >>> >>> Chirag >>> http://sumeruonrails.com >>> >>> >>> >>> On Thu, Jul 28, 2011 at 2:53 PM, Amit Bobade <[email protected]>wrote: >>> >>>> 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 >>>> >>>> >>>> On Wed, Jun 29, 2011 at 12:08 PM, Chirag Singhal < >>>> [email protected]> wrote: >>>> >>>>> It will be in your applications root folder. Along with the files like >>>>> README, Rakefile, etc >>>>> >>>>> -- >>>>> Chirag >>>>> http://sumeruonrails.com >>>>> >>>>> >>>>> On Wed, Jun 29, 2011 at 12:03 PM, Amit Bobade <[email protected]>wrote: >>>>> >>>>>> 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. >>>>>> >>>>>> On Wed, Jun 29, 2011 at 11:52 AM, Chirag Singhal < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> 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 >>>>>>> >>>>>>> On Wed, Jun 29, 2011 at 11:32 AM, Amit Bobade >>>>>>> <[email protected]>wrote: >>>>>>> >>>>>>>> Thank you very much Chirag. It worked. Could you please tell me how >>>>>>>> to replace SQLite with MySQL? >>>>>>>> >>>>>>>> >>>>>>>> On Wed, Jun 29, 2011 at 11:08 AM, Chirag Singhal < >>>>>>>> [email protected]> wrote: >>>>>>>> >>>>>>>>> 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 >>>>>>>>> >>>>>>>>> >>>>>>>>> On Wed, Jun 29, 2011 at 10:57 AM, Amit Bobade < >>>>>>>>> [email protected]> wrote: >>>>>>>>> >>>>>>>>>> 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 >>>>>>>>>> >>>>>>>>>> On Tue, Jun 28, 2011 at 6:08 PM, Chirag Singhal < >>>>>>>>>> [email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> 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 >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> 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 >>>>>>>>>>> [email protected]. >>>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>>> [email protected]. >>>>>>>>>>> For more options, visit this group at >>>>>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Thanks and Regards, >>>>>>>>>> Amit >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> You received this message because you are subscribed to the Google >>>>>>>>>> Groups "Ruby on Rails: Talk" group. >>>>>>>>>> To post to this group, send email to >>>>>>>>>> [email protected]. >>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>> [email protected]. >>>>>>>>>> For more options, visit this group at >>>>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> You received this message because you are subscribed to the Google >>>>>>>>> Groups "Ruby on Rails: Talk" group. >>>>>>>>> To post to this group, send email to >>>>>>>>> [email protected]. >>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>> [email protected]. >>>>>>>>> For more options, visit this group at >>>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Thanks and Regards, >>>>>>>> Amit >>>>>>>> >>>>>>>> -- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "Ruby on Rails: Talk" group. >>>>>>>> To post to this group, send email to >>>>>>>> [email protected]. >>>>>>>> To unsubscribe from this group, send email to >>>>>>>> [email protected]. >>>>>>>> For more options, visit this group at >>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "Ruby on Rails: Talk" group. >>>>>>> To post to this group, send email to >>>>>>> [email protected]. >>>>>>> To unsubscribe from this group, send email to >>>>>>> [email protected]. >>>>>>> For more options, visit this group at >>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Thanks and Regards, >>>>>> Amit >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "Ruby on Rails: Talk" group. >>>>>> To post to this group, send email to >>>>>> [email protected]. >>>>>> To unsubscribe from this group, send email to >>>>>> [email protected]. >>>>>> For more options, visit this group at >>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Ruby on Rails: Talk" group. >>>>> To post to this group, send email to [email protected] >>>>> . >>>>> To unsubscribe from this group, send email to >>>>> [email protected]. >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>> >>>> >>>> >>>> >>>> -- >>>> Thanks and Regards, >>>> Amit >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Ruby on Rails: Talk" group. >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to >>>> [email protected]. >>>> For more options, visit this group at >>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Ruby on Rails: Talk" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group at >>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>> >> >> >> >> -- >> Thanks and Regards, >> Amit >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby on Rails: Talk" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/rubyonrails-talk?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > -- Thanks and Regards, Amit -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
