Skip to content

Instantly share code, notes, and snippets.

@alecslupu
Last active December 22, 2015 20:09
Show Gist options
  • Save alecslupu/6524627 to your computer and use it in GitHub Desktop.
Save alecslupu/6524627 to your computer and use it in GitHub Desktop.
# MySQL. Versions 4.1 and 5.0 are recommended.
#
# Install the MYSQL driver
# gem install mysql2
#
# Ensure the MySQL gem is defined in your Gemfile
# gem 'mysql2'
#
# And be sure to use new-style password hashing:
# http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
host: localhost
adapter: mysql2
encoding: utf8
database: myProject_development
pool: 5
username: root
password: myPassword
# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
host: localhost
adapter: mysql2
encoding: utf8
database: myProject_test
pool: 5
username: root
password: myPassword
production:
host: localhost
adapter: mysql2
encoding: utf8
database: myProject_production
pool: 5
username: root
password: myPassword
[ alecslupu ~/Sites/myProject ] bin/rake db:create:all
can't convert nil into String
/Users/alecslupu/.gems/gems/mysql2-0.3.13/lib/mysql2/client.rb:58:in `connect'
/Users/alecslupu/.gems/gems/mysql2-0.3.13/lib/mysql2/client.rb:58:in `initialize'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `new'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `mysql2_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:440:in `new_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:450:in `checkout_new_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `acquire_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:356:in `block in checkout'
/Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `checkout'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
/Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:546:in `retrieve_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_handling.rb:79:in `retrieve_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_handling.rb:53:in `connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/mysql_database_tasks.rb:8:in `connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/mysql_database_tasks.rb:16:in `create'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:72:in `create'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:81:in `block in create_all'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:191:in `block in each_local_configuration'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:187:in `each_value'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:187:in `each_local_configuration'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:81:in `create_all'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/railties/databases.rake:11:in `block (3 levels) in <top (required)>'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:236:in `call'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:236:in `block in execute'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:231:in `each'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:231:in `execute'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:175:in `block in invoke_with_call_chain'
/Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:168:in `invoke_with_call_chain'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:161:in `invoke'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:149:in `invoke_task'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:106:in `block (2 levels) in top_level'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:106:in `each'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:106:in `block in top_level'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:115:in `run_with_threads'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:100:in `top_level'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:78:in `block in run'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:165:in `standard_exception_handling'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:75:in `run'
bin/rake:4:in `<main>'
Couldn't create database for {"host"=>"localhost", "adapter"=>"mysql2", "encoding"=>"utf8", "database"=>"myProject_development", "pool"=>5, "username"=>"root", "password"=>"myPassword"}
can't convert nil into String
/Users/alecslupu/.gems/gems/mysql2-0.3.13/lib/mysql2/client.rb:58:in `connect'
/Users/alecslupu/.gems/gems/mysql2-0.3.13/lib/mysql2/client.rb:58:in `initialize'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `new'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `mysql2_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:440:in `new_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:450:in `checkout_new_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `acquire_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:356:in `block in checkout'
/Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `checkout'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
/Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:546:in `retrieve_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_handling.rb:79:in `retrieve_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_handling.rb:53:in `connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/mysql_database_tasks.rb:8:in `connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/mysql_database_tasks.rb:16:in `create'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:72:in `create'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:81:in `block in create_all'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:191:in `block in each_local_configuration'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:187:in `each_value'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:187:in `each_local_configuration'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:81:in `create_all'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/railties/databases.rake:11:in `block (3 levels) in <top (required)>'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:236:in `call'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:236:in `block in execute'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:231:in `each'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:231:in `execute'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:175:in `block in invoke_with_call_chain'
/Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:168:in `invoke_with_call_chain'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:161:in `invoke'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:149:in `invoke_task'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:106:in `block (2 levels) in top_level'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:106:in `each'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:106:in `block in top_level'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:115:in `run_with_threads'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:100:in `top_level'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:78:in `block in run'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:165:in `standard_exception_handling'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:75:in `run'
bin/rake:4:in `<main>'
Couldn't create database for {"host"=>"localhost", "adapter"=>"mysql2", "encoding"=>"utf8", "database"=>"myProject_test", "pool"=>5, "username"=>"root", "password"=>"myPassword"}
can't convert nil into String
/Users/alecslupu/.gems/gems/mysql2-0.3.13/lib/mysql2/client.rb:58:in `connect'
/Users/alecslupu/.gems/gems/mysql2-0.3.13/lib/mysql2/client.rb:58:in `initialize'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `new'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `mysql2_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:440:in `new_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:450:in `checkout_new_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `acquire_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:356:in `block in checkout'
/Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `checkout'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
/Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:546:in `retrieve_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_handling.rb:79:in `retrieve_connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/connection_handling.rb:53:in `connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/mysql_database_tasks.rb:8:in `connection'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/mysql_database_tasks.rb:16:in `create'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:72:in `create'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:81:in `block in create_all'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:191:in `block in each_local_configuration'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:187:in `each_value'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:187:in `each_local_configuration'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/tasks/database_tasks.rb:81:in `create_all'
/Users/alecslupu/.gems/gems/activerecord-4.0.0/lib/active_record/railties/databases.rake:11:in `block (3 levels) in <top (required)>'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:236:in `call'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:236:in `block in execute'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:231:in `each'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:231:in `execute'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:175:in `block in invoke_with_call_chain'
/Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:168:in `invoke_with_call_chain'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/task.rb:161:in `invoke'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:149:in `invoke_task'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:106:in `block (2 levels) in top_level'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:106:in `each'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:106:in `block in top_level'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:115:in `run_with_threads'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:100:in `top_level'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:78:in `block in run'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:165:in `standard_exception_handling'
/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/application.rb:75:in `run'
bin/rake:4:in `<main>'
Couldn't create database for {"host"=>"localhost", "adapter"=>"mysql2", "encoding"=>"utf8", "database"=>"myProject_production", "pool"=>5, "username"=>"root", "password"=>"myPassword"}
[ alecslupu ~/Sites/myProject ]
[ alecslupu ~/Sites/myProject ] mysql --version
mysql Ver 14.14 Distrib 5.5.29, for osx10.8 (i386) using readline 5.1
[ alecslupu ~/Sites/myProject ] ruby -v
ruby 1.9.3p125 (2012-02-16 revision 34643) [x86_64-darwin12.2.0]
[ alecslupu ~/Sites/myProject ] rails -v
Rails 4.0.0
[ alecslupu ~/Sites/myProject ] gem list
*** LOCAL GEMS ***
actionmailer (4.0.0)
actionpack (4.0.0)
activemodel (4.0.0)
activerecord (4.0.0)
activerecord-deprecated_finders (1.0.3)
activesupport (4.0.0)
arel (4.0.0)
atomic (1.1.14)
builder (3.1.4)
bundler (1.3.5)
erubis (2.7.0)
hike (1.2.3)
i18n (0.6.5)
mail (2.5.4)
mime-types (1.25)
minitest (4.7.5)
multi_json (1.8.0)
polyglot (0.3.3)
rack (1.5.2)
rack-test (0.6.2)
rails (4.0.0)
railties (4.0.0)
rake (10.0.4)
rubygems-bundler (1.1.1)
rvm (1.11.3.7)
sprockets (2.10.0)
sprockets-rails (2.0.0)
thor (0.18.1)
thread_safe (0.1.3)
tilt (1.4.1)
treetop (1.4.15)
tzinfo (0.3.37)
[ alecslupu ~/Sites/myProject ]
@mayrund
Copy link

mayrund commented Oct 27, 2013

Did you manage to solve this issue? I'm having the same.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment