[Rails] Re: Error in Mysql Connection
Yes, i solved this problem . go to ruby shell type: install gem -v2.3.5 (or your need version for your server) All thing ok. Anything , please contact me : mrvuo...@gmail.com -- Posted via http://www.ruby-forum.com/. -- 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 rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
[Rails] Re: Error in Mysql Connection
Trejkaz Xx wrote: Hao Zhao wrote: 1. download older MySQL client library, for example one from InstantRails: http://instantrails.rubyforge.org/svn/trunk/InstantRails-win/InstantRails/mysql/bin/libmySQL.dll 2. copy the downloaded file to C:\Ruby\bin (or wherever you installed Ruby) 3. restart MySQL server I did steps 1 and 2 (I don't run the server on localhost so step 3 appears to be pointless for me.) I then got an error like: Access Denied: C:/Ruby/bin/.../mysql.so Turns out when the mysql gem installed, it didn't set mysql.so to be executable. I went into Explorer and manually turned it on, and it started to work. Explorer was showing the read permission but not the execute permission. Goes to show that this flag does take effect in Windows after all. :rollseyes: I'm just documenting this in case someone else finds their way here and has the same issue. TX Actually, after your prompt to drop the lib in the %RUBY_HOME%\bin I tried the one that is in the %MYSQL_HOME%\bin i.e. not the one downloaded from InstantRails and it now works (well it seems to, no probs yet). So this clearly indicates that Ruby really can't see libmySQL.dll on the path i.e. as installed with MySQL itself (5.1 for me). So for now simply try cp %MYSQL_HOME%\bin\libmySQL.dll %RUBY_HOME%\bin. Cheers -- Posted via http://www.ruby-forum.com/. --~--~-~--~~~---~--~~ 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~--~~~~--~~--~--~---
[Rails] Re: Error in Mysql Connection
Thanks for the listing Hao Zhao :) -- Posted via http://www.ruby-forum.com/. --~--~-~--~~~---~--~~ 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~--~~~~--~~--~--~---
[Rails] Re: Error in Mysql Connection
Hao Zhao wrote: 1. download older MySQL client library, for example one from InstantRails: http://instantrails.rubyforge.org/svn/trunk/InstantRails-win/InstantRails/mysql/bin/libmySQL.dll 2. copy the downloaded file to C:\Ruby\bin (or wherever you installed Ruby) 3. restart MySQL server I did steps 1 and 2 (I don't run the server on localhost so step 3 appears to be pointless for me.) I then got an error like: Access Denied: C:/Ruby/bin/.../mysql.so Turns out when the mysql gem installed, it didn't set mysql.so to be executable. I went into Explorer and manually turned it on, and it started to work. Explorer was showing the read permission but not the execute permission. Goes to show that this flag does take effect in Windows after all. :rollseyes: I'm just documenting this in case someone else finds their way here and has the same issue. TX -- Posted via http://www.ruby-forum.com/. --~--~-~--~~~---~--~~ 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~--~~~~--~~--~--~---
[Rails] Re: Error in Mysql Connection
If you upgrade Rails to 2.2.2, you will find that the MYSQL adapter have been removed from the package. So you have to manually install it using command ” gem install mysql”. but it is not over for works. when you are running server and visit the home page, you will get error message on background “The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.” So surprise ! why ? i search many pages with Google and find the reason that the rails 2.2.2 is incompatible with mysql 5.x client. here is a solusion. please followe the following steps to fix it: 1. download older MySQL client library, for example one from InstantRails: http://instantrails.rubyforge.org/svn/trunk/InstantRails-win/InstantRails/mysql/bin/libmySQL.dll 2. copy the downloaded file to C:\Ruby\bin (or wherever you installed Ruby) 3. restart MySQL server that’s it. hope it will help you when you occur such problem. -- Posted via http://www.ruby-forum.com/. --~--~-~--~~~---~--~~ 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~--~~~~--~~--~--~---
[Rails] Re: Error in Mysql Connection
Freddy Andersen wrote: I'm guessing in you database.yml file you have this: development: adapter: mysql So you need todo this: # gem install mysql or if mysql is in a none standard area you need to point to mysql_config like this: # gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/ mysql_config (or where ever you have mysql installed) Show us output from the following: gem list inside of you application = rake gems I am also facing the same issue. Unable to install mysql gem on Windows Vista. It throws the below error: !!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql. rake aborted! no such file to load -- mysql The output for the above commands requested by you are: C:\Users\Admin\Desktop\Aruna\bookgem list *** LOCAL GEMS *** actionmailer (2.2.2) actionpack (2.2.2) activerecord (2.2.2) activeresource (2.2.2) activesupport (2.2.2) addressable (2.0.2) capistrano (2.1.0) cgi_multipart_eof_fix (2.5.0) cmdparse (2.0.2) data_objects (0.9.11) dm-core (0.9.10) extlib (0.9.10) fxri (0.3.6) fxruby (1.6.12) gem_plugin (0.2.3) highline (1.4.0) hpricot (0.6) log4r (1.0.5) mongrel (1.1.2) mysql (2.7.3) needle (1.3.0) net-sftp (1.1.0) net-ssh (1.1.2) rails (2.2.2) rake (0.8.3) rubygems-update (1.3.1) sources (0.0.1) sqlite3-ruby (1.2.1) win32-api (1.4.0, 1.0.4) win32-clipboard (0.4.3) win32-dir (0.3.2) win32-eventlog (0.4.6) win32-file (0.5.4) win32-file-stat (1.2.7) win32-process (0.5.3) win32-sapi (0.1.4) win32-sound (0.4.1) windows-api (0.3.0, 0.2.0) windows-pr (1.0.1, 0.7.2) C:\Users\Admin\Desktop\Aruna\bookrake gems (in C:/Users/Admin/Desktop/Aruna/book) I = Installed F = Frozen R = Framework (loaded before rails starts) -- Posted via http://www.ruby-forum.com/. --~--~-~--~~~---~--~~ 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~--~~~~--~~--~--~---
[Rails] Re: Error in Mysql Connection
im new to ROR but i think i remember using this command when i had that same error when i first started installing. ruby\ gem install mysql it was something along that line. On Dec 15, 8:31 am, Angappan Ayyavoo rails-mailing-l...@andreas- s.net wrote: Hai Iam getting error in mysql connection. C:\Ruby\addrruby script/server = Booting WEBrick... = Rails 2.2.2 application started onhttp://0.0.0.0:3000 = Ctrl-C to shutdown server; call with --help for options [2008-12-15 18:51:18] INFO WEBrick 1.3.1 [2008-12-15 18:51:18] INFO ruby 1.8.6 (2008-08-11) [i386-mswin32] [2008-12-15 18:51:18] INFO WEBrick::HTTPServer#start: pid=988 port=3000 !!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install my 127.0.0.1 - - [15/Dec/2008:18:51:24 India Standard Time] GET /contacts/ HTTP/1.1 500 13864 - - /contacts/ 127.0.0.1 - - [15/Dec/2008:18:51:36 India Standard Time] GET / HTTP/1.1 304 0 - - / 127.0.0.1 - - [15/Dec/2008:18:51:36 India Standard Time] GET /javascripts/prototype.js HTTP/1.1 304 0http://localhost:3000/- /javascripts/prototype.js 127.0.0.1 - - [15/Dec/2008:18:51:36 India Standard Time] GET /javascripts/effects.js HTTP/1.1 304 0http://localhost:3000/- /javascripts/effects.js 127.0.0.1 - - [15/Dec/2008:18:51:36 India Standard Time] GET /images/rails.png HTTP/1.1 304 0http://localhost:3000/- /images/rails.png !!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install my 127.0.0.1 - - [15/Dec/2008:18:51:41 India Standard Time] GET /contacts/ HTTP/1.1 500 13864 - - /contacts/ and kindly give me some better links for the beginner to adapt with ruby on rails ( Latest) Iam using ruby 1.8.6 and rails 2.2.2 or which version is better. Guide me. -- Posted viahttp://www.ruby-forum.com/. --~--~-~--~~~---~--~~ 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~--~~~~--~~--~--~---
[Rails] Re: Error in Mysql Connection
Kyle wrote: im new to ROR but i think i remember using this command when i had that same error when i first started installing. ruby\ gem install mysql it was something along that line. On Dec 15, 8:31�am, Angappan Ayyavoo rails-mailing-l...@andreas- I tried with that, but getting the same error repeatedly. -- Posted via http://www.ruby-forum.com/. --~--~-~--~~~---~--~~ 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~--~~~~--~~--~--~---
[Rails] Re: Error in Mysql Connection
With Rails 2, the default database server is SQLite3. You apparently added the optional MySQL. I recommend you go with the flow, i.e. restart and allow the default DBMS to be used. HTH, Richard On Dec 16, 12:13 am, Angappan Ayyavoo rails-mailing-l...@andreas- s.net wrote: Kyle wrote: im new to ROR but i think i remember using this command when i had that same error when i first started installing. ruby\ gem install mysql it was something along that line. On Dec 15, 8:31 am, Angappan Ayyavoo rails-mailing-l...@andreas- I tried with that, but getting the same error repeatedly. -- Posted viahttp://www.ruby-forum.com/. --~--~-~--~~~---~--~~ 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~--~~~~--~~--~--~---
[Rails] Re: Error in Mysql Connection
I looked at you question again, which led me to add a couple of more things: Did you notice the advice: !!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again If you don't know how to use the gem system, just Google for gem. But if you use SQLite3, you won't have to deal with installing MySQL. Furthermore, you must have found a way to opt for WEBrick. The norm for Rails 2 is Mongrel as the webserver. Again, I recommend you go with the default. HTH, Richard On Dec 16, 12:13 am, Angappan Ayyavoo rails-mailing-l...@andreas- s.net wrote: Kyle wrote: im new to ROR but i think i remember using this command when i had that same error when i first started installing. ruby\ gem install mysql it was something along that line. On Dec 15, 8:31 am, Angappan Ayyavoo rails-mailing-l...@andreas- I tried with that, but getting the same error repeatedly. -- Posted viahttp://www.ruby-forum.com/. --~--~-~--~~~---~--~~ 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~--~~~~--~~--~--~---
[Rails] Re: Error in Mysql Connection
I'm guessing in you database.yml file you have this: development: adapter: mysql So you need todo this: # gem install mysql or if mysql is in a none standard area you need to point to mysql_config like this: # gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/ mysql_config (or where ever you have mysql installed) Show us output from the following: gem list inside of you application = rake gems --~--~-~--~~~---~--~~ 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 rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~--~~~~--~~--~--~---