Hey Schalk, The autogenerated database.yml did get one new line (as of 2.2.0) that shows up in 2.2.2 yml files.
development: adapter: mysql encoding: utf8 database: t222m_development pool: 5 username: root password: socket: /tmp/mysql.sock NOTE: pool: 5 I've deleted the line, however, and it doesn't prevent the database connection from being made. I'm not sure where to look for the documentation but my guess is pool: is used as a client count / performance hack. Also thinking of all the bases, 1) Do you have mysql installed? 2) Can you access it as follows --- mysql -uuser -ppass where user => the username from database.yml and pass => the password from database.yml 3) Does this user have necessary privileges to create a database? 4) Have you created a database for your new project? Rick On Nov 25, 1:39 pm, Schalk Neethling <[EMAIL PROTECTED]> wrote: > Hey All, > > Executing: gem install mysql --no-ri --no-rdoc tells me that it > installed one gem without any errors. However looking at the folder > inside InstantRails, something seems missing. There is no lib for example. > > Also, a simple line like this: > > @content = Content.find_by_permalink('introduction') > > Is throwing one heck of an error (here is a small bit of it): > > Processing ContentController#index (for 127.0.0.1 at 2008-11-26 > 01:17:28) [GET] > [4;36;1mSQL (1.0ms) [0m [0;1mSET NAMES 'utf8' [0m > [4;35;1mSQL (0.0ms) [0m [0mSET SQL_AUTO_IS_NULL=0 [0m > [4;36;1mContent Columns (33.0ms) [0m [0;1mSHOW FIELDS FROM > `contents` [0m > [4;35;1mContent Load (1.0ms) [0m [0mSELECT * FROM `contents` > WHERE (`contents`.`permalink` = 'introduction') LIMIT 1 [0m > > ArgumentError (NULL pointer given): > (eval):3:in `each_hash' > (eval):3:in `all_hashes' > > C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:564:in > `select' > C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in > `select_all_without_query_cache' > C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in > `select_all' > C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in > `cache_sql' > C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in > `select_all' > C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:635:in > `find_by_sql' > > No my first assumption is, this is related to a bad mysql gem > installation but, for the sake of covering all basis, does anyone know > whether anything has changed in the way databases get's set-up in the > database.yml file in 2.2.2? > > Current: > > development: > adapter: mysql > encoding: utf8 > database: osc_development > username: user > password: pass > host: localhost > > Thanks for all assistance, thankfully I now see that it is not only me > struggling with this issue. > Schalk > > CharlesB wrote: > > > I had the same exact error message when I first tried to install the > > mysql-2.7.3 gem. But from the error message, we clearly see that only > > the RDocs are not being installed. > > > You can confirm that if you do a "gem list". If you want, you can > > simply do: > > > gem install mysql --no-ri --no-rdoc > > > It will install the gem, but not the documentation (which, from a > > Rails point of view, you should not be concerned about anyway). > > > Other than that, if Rails 2.2.2 still fails to load, then either you > > have not installed MySQL server itself, or somehow libmysql.dll is not > > on the path list. Simply type "path" at the command prompt and check > > if your mysql\bin directory is listed there. If not, add it. > > > Cheers! > > > CharlesB --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---