Rake Aborted wont Migrate mysql

rubyonrails-talk
1

Hello all, I've been trying to get ruby on rails to work with my local install of mysql(its with wamp). Windows XP, Ruby 1.8.6, rails 2.3.5, rubygems 1.3.5, mysql 5.2 something I believe.

I have ruby installed in:

C:\Ruby

and my mysql is installed in:

C:\wamp\bin\mysql\mysql5.1.30\bin

I've attempted to change my database.yml file to include the port 80, and port 3036, the socket path, I've checked for skip-networking in my my.ini file, my mysql bin is included in my path, I have the mysql gem installed.

Everytime I try to run: rake db:migrate I get this error, I'd appreciate any help I can get, thank you:

-------------- Error -------------

ruby 1.8.6 (2009-08-04 patchlevel 383) [i386-mingw32]

C:\Ruby\projects\music_library>rake db:migrate (in C:/Ruby/projects/music_library) rake aborted! Mysql::Error: query: not connected: CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB

(See full trace by running task with --trace) C:/Ruby/bin/rake:19: [BUG] Segmentation fault ruby 1.8.6 (2009-08-04) [i386-mingw32]

This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information.

-------------- Trace results ----------------

C:\Ruby\projects\music_library>rake --trace (in C:/Ruby/projects/music_library) ** Invoke default (first_time) ** Invoke test (first_time) ** Execute test ** Invoke test:units (first_time) ** Invoke db:test:prepare (first_time) ** Invoke db:abort_if_pending_migrations (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:abort_if_pending_migrations C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/core_ext/string/output_safety.rb:36: [BUG] Segmentation fault ruby 1.8.6 (2009-08-04) [i386-mingw32]

This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information.

----------------- database.yml --------------

development:   adapter: mysql   encoding: utf8   reconnect: false   database: music_library_development   pool: 5   port: 3306   username: root   password: mypassword   host: localhost

2

have you tried to connect to your mysql server by the mysql-client?

mysql -h localhost -P 3306 -p dbname

3

Kristian Hellquist wrote:

have you tried to connect to your mysql server by the mysql-client?

mysql -h localhost -P 3306 -p dbname

I guess I can't, when I try it asks for my password, I enter it then it says:

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: YES)

4

Solved:

It appears to be a problem with mysql 5.1+ and I was even having it with 5.0.89. You can fix this by downloading the old libmysql.dll version here:

http://instantrails.rubyforge.org/svn/trunk/InstantRails-win/InstantRails/mysql/bin/libmySQL.dll

Just put that file in your Ruby\bin directory, in my case I put that inside:

C:\Ruby\bin

Restart your mysql and it should work just fine now.

Also another tidbit of information that might be helpful is that Ruby on rails when you create your rails app it will generate your database.yml using the default sqlite3 information instead of mysql. This tripped me up at first. You can make it so that it makes this file using mysql instead of sqlite3 by editing your:

app_generator.rb, you can find this file inside of:

C:\Ruby\lib\ruby\gems\1.8\gems\rails-2.3.5\lib\rails_generator\generators\applications\app\app_generator.rb

On line 9 you'll find:

DEFAULT_DATABASE = 'sqlite3'

change 'sqlite3' to 'mysql', now rails will generate your database.yml file when creating a new app using mysql instead of sqlite3 defaults.

I hope this helps someone.

Andrew

5

Andrew Perkins wrote:


...
Also another tidbit of information that might be helpful is that Ruby on rails when you create your rails app it will generate your database.yml using the default sqlite3 information instead of mysql. This tripped me up at first. You can make it so that it makes this file using mysql instead of sqlite3 by editing your:
app_generator.rb, you can find this file inside of:
C:\Ruby\lib\ruby\gems\1.8\gems\rails-2.3.5\lib\rails_generator\generators\applications\app\app_generator.rb
On line 9 you'll find:
DEFAULT_DATABASE = 'sqlite3'
change 'sqlite3' to 'mysql', now rails will generate your database.yml file when creating a new app using mysql instead of sqlite3 defaults.
I hope this helps someone.
Andrew

You can alternatively create your rails app with the command ‘rails xxx -d mysql’ and it will create the database.yml for mysql.

Norm