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 -~----------~----~----~----~------~----~------~--~---
