My database is a MySQL running on localhost. The mysql2 gem
installed without errors. I never managed to connect, regardless of
which account I used.
The root password contains a # which is the comment character in
Sublime Text 2 editor so I think it might not be passing my password
in-correctly.
I tried using double- and single quotes, but it doesn’t seem to make any
difference. I also tried creating a new user and giving that user
privileges on the command line in mysql,
I have read a lot of similiar posts on stackoverflow but haven’t found
solution yet.
Below is a stack trace of the error:
C:\inetpub\wwwroot\siteone\simple_cms>rake db:schema:dump
DL is deprecated, please use Fiddle
rake aborted!
ActiveRecord::AdapterNotSpecified: 'mysql2' database is not
configured. Available: [“default”, “adapter”, “encoding”, “pool”,
“username”, “password”, “host”, “development”, “database”]
Tasks: TOP => db:schema:dump => db:load_config
(See full trace by running task with --trace)
I checked ymlint and it says my yml file is ok.
Here is the output of trace using the user I created which has all
privileges on the Database.
C:\inetpub\wwwroot\siteone\simple_cms>rake db:schema:dump --trace
DL is deprecated, please use Fiddle
** Invoke db:schema:dump (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
rake aborted!
YAML syntax error occurred while parsing
C:/inetpub/wwwroot/siteone/simple_cms/c
onfig/database.yml. Please note that YAML must be consistently
indented using sp
aces. Tabs are not allowed. Error: (): found character that
cannot star
t any token while scanning for the next token at line 12 column 1
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/railties-4.2.1/lib/rails/ap
plication/configuration.rb:115:in rescue in database_configuration' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/railties-4.2.1/lib/rails/ap plication/configuration.rb:98:indatabase_configuration’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti
ve_record/railtie.rb:117:in block (2 levels) in <class:Railtie>' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activesupport-4.2.1/lib/act ive_support/lazy_load_hooks.rb:38:ininstance_eval’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activesupport-4.2.1/lib/act
ive_support/lazy_load_hooks.rb:38:in execute_hook' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activesupport-4.2.1/lib/act ive_support/lazy_load_hooks.rb:45:inblock in run_load_hooks’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activesupport-4.2.1/lib/act
ive_support/lazy_load_hooks.rb:44:in each' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activesupport-4.2.1/lib/act ive_support/lazy_load_hooks.rb:44:inrun_load_hooks’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti
ve_record/base.rb:316:in <module:ActiveRecord>' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti ve_record/base.rb:26:in<top (required)>’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti
ve_record/tasks/mysql_database_tasks.rb:8:in
<class:MySQLDatabaseTasks>' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti ve_record/tasks/mysql_database_tasks.rb:3:inmodule:Tasks’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti
ve_record/tasks/mysql_database_tasks.rb:2:in <module:ActiveRecord>' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti ve_record/tasks/mysql_database_tasks.rb:1:in<top (required)>’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti
ve_record/tasks/database_tasks.rb:50:in <module:DatabaseTasks>' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti ve_record/tasks/database_tasks.rb:37:inmodule:Tasks’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti
ve_record/tasks/database_tasks.rb:4:in <module:ActiveRecord>' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti ve_record/tasks/database_tasks.rb:3:in<top (required)>’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/activerecord-4.2.1/lib/acti
ve_record/railtie.rb:41:in block (3 levels) in <class:Railtie>' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r b:240:incall’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r
b:240:in block in execute' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r b:235:ineach’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r
b:235:in execute' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r b:179:inblock in invoke_with_call_chain’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/2.0.0/monitor.rb:211:in
mon_synchronize' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r b:172:ininvoke_with_call_chain’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r
b:201:in block in invoke_prerequisites' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r b:199:ineach’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r
b:199:in invoke_prerequisites' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r b:178:inblock in invoke_with_call_chain’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/2.0.0/monitor.rb:211:in
mon_synchronize' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r b:172:ininvoke_with_call_chain’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/task.r
b:165:in invoke' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/applic ation.rb:150:ininvoke_task’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/applic
ation.rb:106:in block (2 levels) in top_level' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/applic ation.rb:106:ineach’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/applic
ation.rb:106:in block in top_level' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/applic ation.rb:115:inrun_with_threads’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/applic
ation.rb:100:in top_level' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/applic ation.rb:78:inblock in run’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/applic
ation.rb:176:in standard_exception_handling' C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/lib/rake/applic ation.rb:75:inrun’
C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/rake-10.4.2/bin/rake:33:in
<top (required)>' C:/RailsInstaller/Ruby2.0.0/bin/rake:23:inload’
C:/RailsInstaller/Ruby2.0.0/bin/rake:23:in `’
Tasks: TOP => db:schema:dump => db:load_config
C:\inetpub\wwwroot\siteone\simple_cms>