chef-mysql-fail

[root@s1 ~]# chef-client -V
[Wed, 29 Dec 2010 22:59:59 +0000] INFO: Starting Chef Run (Version 0.9.8)
[Wed, 29 Dec 2010 22:59:59 +0000] INFO: Starting Chef Run (Version 0.9.8)
[Wed, 29 Dec 2010 23:00:03 +0000] INFO: Installing package[mysql-devel] version 5.0.77-4.el5_5.4
[Wed, 29 Dec 2010 23:00:03 +0000] INFO: Installing package[mysql-devel] version 5.0.77-4.el5_5.4
[Wed, 29 Dec 2010 23:00:16 +0000] WARN: Could not find previously defined grants.sql resource
[Wed, 29 Dec 2010 23:00:16 +0000] WARN: Could not find previously defined grants.sql resource
[Wed, 29 Dec 2010 23:00:17 +0000] INFO: Ran execute[generate-module-list] successfully
[Wed, 29 Dec 2010 23:00:17 +0000] INFO: Ran execute[generate-module-list] successfully
[Wed, 29 Dec 2010 23:00:17 +0000] INFO: Upgrading package[php-mysql] version from uninstalled to 5.1.6-27.el5_5.3
[Wed, 29 Dec 2010 23:00:17 +0000] INFO: Upgrading package[php-mysql] version from uninstalled to 5.1.6-27.el5_5.3
[Wed, 29 Dec 2010 23:00:24 +0000] INFO: Installing package[ruby-mysql] version 2.7.3-1.el5
[Wed, 29 Dec 2010 23:00:24 +0000] INFO: Installing package[ruby-mysql] version 2.7.3-1.el5
[Wed, 29 Dec 2010 23:00:31 +0000] INFO: Installing package[mysql-server] version 5.0.77-4.el5_5.4
[Wed, 29 Dec 2010 23:00:31 +0000] INFO: Installing package[mysql-server] version 5.0.77-4.el5_5.4
[Wed, 29 Dec 2010 23:00:40 +0000] INFO: Writing updated content for template[/etc/my.cnf] to /etc/my.cnf
[Wed, 29 Dec 2010 23:00:40 +0000] INFO: Writing updated content for template[/etc/my.cnf] to /etc/my.cnf
[Wed, 29 Dec 2010 23:00:40 +0000] INFO: Backing up template[/etc/my.cnf] to /var/chef/backup/etc/my.cnf.chef-20101229230040
[Wed, 29 Dec 2010 23:00:40 +0000] INFO: Backing up template[/etc/my.cnf] to /var/chef/backup/etc/my.cnf.chef-20101229230040
[Wed, 29 Dec 2010 23:00:40 +0000] INFO: template[/etc/my.cnf] sending restart action to service[mysql] (immediate)
[Wed, 29 Dec 2010 23:00:40 +0000] INFO: template[/etc/my.cnf] sending restart action to service[mysql] (immediate)
[Wed, 29 Dec 2010 23:00:42 +0000] INFO: service[mysql]: restarted successfully
[Wed, 29 Dec 2010 23:00:42 +0000] INFO: service[mysql]: restarted successfully
[Wed, 29 Dec 2010 23:00:48 +0000] INFO: Writing updated content for template[/etc/mysql/grants.sql] to /etc/mysql_grants.sql
[Wed, 29 Dec 2010 23:00:48 +0000] INFO: Writing updated content for template[/etc/mysql/grants.sql] to /etc/mysql_grants.sql
[Wed, 29 Dec 2010 23:00:48 +0000] INFO: template[/etc/mysql/grants.sql] sending run action to execute[mysql-install-privileges] (immediate)
[Wed, 29 Dec 2010 23:00:48 +0000] INFO: template[/etc/mysql/grants.sql] sending run action to execute[mysql-install-privileges] (immediate)
[Wed, 29 Dec 2010 23:00:48 +0000] ERROR: template[/etc/mysql/grants.sql] (/var/chef/cache/cookbooks/mysql/recipes/server.rb:95:in `from_file') had an error:
/usr/bin/mysql -u root -pedUnXmswsyRVosSUpwrE < /etc/mysql_grants.sql returned 1, expected 0
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/mixin/command.rb:184:in `handle_command_failures'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/mixin/command.rb:131:in `run_command'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/provider/execute.rb:49:in `action_run'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:51:in `send'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:51:in `run_action'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:58:in `run_action'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:56:in `each'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:56:in `run_action'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:109:in `converge'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:108:in `each'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:108:in `converge'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection.rb:94:in `execute_each_resource'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:116:in `call'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:116:in `call_iterator_block'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:85:in `step'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:104:in `iterate'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:55:in `each_with_index'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection.rb:92:in `execute_each_resource'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:82:in `converge'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/client.rb:304:in `converge'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/client.rb:106:in `run'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:212:in `run_application'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:202:in `loop'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:202:in `run_application'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application.rb:62:in `run'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/chef-client:26
/usr/bin/chef-client:19:in `load'
/usr/bin/chef-client:19
[Wed, 29 Dec 2010 23:00:48 +0000] ERROR: template[/etc/mysql/grants.sql] (/var/chef/cache/cookbooks/mysql/recipes/server.rb:95:in `from_file') had an error:
/usr/bin/mysql -u root -pedUnXmswsyRVosSUpwrE < /etc/mysql_grants.sql returned 1, expected 0
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/mixin/command.rb:184:in `handle_command_failures'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/mixin/command.rb:131:in `run_command'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/provider/execute.rb:49:in `action_run'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:51:in `send'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:51:in `run_action'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:58:in `run_action'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:56:in `each'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:56:in `run_action'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:109:in `converge'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:108:in `each'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:108:in `converge'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection.rb:94:in `execute_each_resource'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:116:in `call'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:116:in `call_iterator_block'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:85:in `step'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:104:in `iterate'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:55:in `each_with_index'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection.rb:92:in `execute_each_resource'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:82:in `converge'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/client.rb:304:in `converge'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/client.rb:106:in `run'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:212:in `run_application'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:202:in `loop'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:202:in `run_application'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application.rb:62:in `run'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/chef-client:26
/usr/bin/chef-client:19:in `load'
/usr/bin/chef-client:19
[Wed, 29 Dec 2010 23:00:48 +0000] ERROR: Running exception handlers
[Wed, 29 Dec 2010 23:00:48 +0000] ERROR: Running exception handlers
[Wed, 29 Dec 2010 23:00:48 +0000] ERROR: Exception handlers complete
[Wed, 29 Dec 2010 23:00:48 +0000] ERROR: Exception handlers complete
[Wed, 29 Dec 2010 23:00:48 +0000] ERROR: Re-raising exception: Chef::Exceptions::Exec - /usr/bin/mysql -u root -pedUnXmswsyRVosSUpwrE < /etc/mysql_grants.sql returned 1, expected 0
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/mixin/command.rb:184:in `handle_command_failures'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/mixin/command.rb:131:in `run_command'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/provider/execute.rb:49:in `action_run'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:51:in `send'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:51:in `run_action'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:58:in `run_action'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:56:in `each'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:56:in `run_action'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:109:in `converge'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:108:in `each'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:108:in `converge'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection.rb:94:in `execute_each_resource'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:116:in `call'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:116:in `call_iterator_block'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:85:in `step'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:104:in `iterate'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:55:in `each_with_index'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection.rb:92:in `execute_each_resource'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:82:in `converge'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/client.rb:304:in `converge'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/client.rb:106:in `run'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:212:in `run_application'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:202:in `loop'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:202:in `run_application'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application.rb:62:in `run'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/chef-client:26
  /usr/bin/chef-client:19:in `load'
  /usr/bin/chef-client:19
[Wed, 29 Dec 2010 23:00:48 +0000] ERROR: Re-raising exception: Chef::Exceptions::Exec - /usr/bin/mysql -u root -pedUnXmswsyRVosSUpwrE < /etc/mysql_grants.sql returned 1, expected 0
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/mixin/command.rb:184:in `handle_command_failures'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/mixin/command.rb:131:in `run_command'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/provider/execute.rb:49:in `action_run'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:51:in `send'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:51:in `run_action'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:58:in `run_action'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:56:in `each'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:56:in `run_action'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:109:in `converge'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:108:in `each'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:108:in `converge'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection.rb:94:in `execute_each_resource'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:116:in `call'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:116:in `call_iterator_block'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:85:in `step'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:104:in `iterate'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection/stepable_iterator.rb:55:in `each_with_index'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/resource_collection.rb:92:in `execute_each_resource'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:82:in `converge'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/client.rb:304:in `converge'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/client.rb:106:in `run'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:212:in `run_application'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:202:in `loop'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application/client.rb:202:in `run_application'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application.rb:62:in `run'
  /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/chef-client:26
  /usr/bin/chef-client:19:in `load'
  /usr/bin/chef-client:19
/usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/mixin/command.rb:184:in `handle_command_failures': /usr/bin/mysql -u root -pedUnXmswsyRVosSUpwrE < /etc/mysql_grants.sql returned 1, expected 0 (Chef::Exceptions::Exec)
	from /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/mixin/command.rb:131:in `run_command'
	from /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/provider/execute.rb:49:in `action_run'
	from /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:51:in `send'
	from /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:51:in `run_action'
	from /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:58:in `run_action'
	from /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:56:in `each'
	from /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:56:in `run_action'
	from /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/runner.rb:109:in `converge'
	 ... 15 levels...
	from /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/../lib/chef/application.rb:62:in `run'
	from /usr/lib/ruby/gems/1.8/gems/chef-0.9.8/bin/chef-client:26
	from /usr/bin/chef-client:19:in `load'
	from /usr/bin/chef-client:19
[root@s1 ~]# /usr/bin/mysql -u root -pedUnXmswsyRVosSUpwrE < /etc/mysql_grants.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)