Thanks for the response. I'm actually just trying to get db:create to work first (although I did try db:migrate to no avail). Surely db:create should work with just "development" defined in the yml and existing in MySQL ????
I will try creating and defining all three, just to be sure... On Jul 3, 8:20 pm, Rick <[email protected]> wrote: > Have you created the library_development, library_test, and > library_production databases? These need to be in place in mysql > prior to any db:migrate calls. > > On Jul 2, 4:09 pm, Greg <[email protected]> wrote: > > > Hi, > > > I'm attempting to follow this tutorial: > > >http://www.tutorialspoint.com/ruby-on-rails/rails-database-setup.htm > > > To create a simple RoR app connected to a MySQL database. When I get > > to the point where I have to run "rake db:create" I get the error > > "Protocol error - db:migrate". E.g: > > > r...@ubi:/home/greg/dev/library# rake db:create > > create > > Protocol error - db:create > > r...@ubi:/home/greg/dev/library# > > > I have no idea what this means and can find no information after > > extensive googling. I'll provide as much info about my environment/ > > setup as I know how to provide... > > > Any help or suggestions as to how I can figure this out? Please...... > > > Thanks, > > Greg > > > ============================================== > > I am running Ubuntu: > > r...@ubi:/home/greg/dev/library# uname -a > > Linux ubi 2.6.28-13-generic #45-Ubuntu SMP Tue Jun 30 19:49:51 UTC > > 2009 i686 GNU/Linux > > > I am using Mysql server version 5.0 > > r...@ubi:/home/greg/docs/procedis/dev/library# mysql -V > > mysql Ver 14.12 Distrib 5.0.75, for debian-linux-gnu (i486) using > > readline 5.2 > > > I am using ruby 1.8.7 > > r...@ubi:/home/greg/docs/procedis/dev/library# ruby -v > > ruby 1.8.7 (2008-08-11 patchlevel 72) [i486-linux] > > > I have the following: > > *** LOCAL GEMS *** > > > actionmailer (2.3.2) > > actionpack (2.3.2) > > activerecord (2.3.2) > > activeresource (2.3.2) > > activesupport (2.3.2) > > mysql (2.7) > > rails (2.3.2) > > rake (0.8.7) > > > This is my database yml file: > > r...@ubi:/home/greg/dev/library# more config/database.yml > > development: > > adapter: mysql > > encoding: utf8 > > database: library_development > > pool: 5 > > username: root > > password: xxxxxxxx > > socket: /var/run/mysqld/mysqld.sock > > r...@ubi:/home/greg/dev/library# > > > (I have also tried with "host: localhost" instead of socket) > > > I am able to connect to the mysql database using the dbconsole: > > > r...@ubi:/home/greg/dev/library# ruby script/dbconsole > > Enter password: > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 37 > > Server version: 5.0.75-0ubuntu10.2 (Ubuntu) > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > mysql> --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
