I was using chef to configure ubuntu ami in ec2 for wordpress. And it was working with amazon linux also.
2013-10-07T14:05:52+00:00] INFO: template[/etc/mysql/debian.cnf] updated file contents /etc/mysql/debian.cnf
[2013-10-07T14:05:52+00:00] INFO: template[/etc/mysql/debian.cnf] owner changed to 0
[2013-10-07T14:05:52+00:00] INFO: template[/etc/mysql/debian.cnf] group changed to 0
[2013-10-07T14:05:52+00:00] INFO: template[/etc/mysql/debian.cnf] mode changed to 600
[2013-10-07T14:05:52+00:00] INFO: Processing group[mysql] action create (mysql::server line 90)
[2013-10-07T14:05:53+00:00] INFO: group[mysql] created
[2013-10-07T14:05:53+00:00] INFO: Processing user[mysql] action create (mysql::server line 94)
[2013-10-07T14:05:53+00:00] INFO: user[mysql] created
[2013-10-07T14:05:53+00:00] INFO: Processing directory[/var/run/mysqld] action create (mysql::server line 112)
[2013-10-07T14:05:53+00:00] INFO: directory[/var/run/mysqld] created directory /var/run/mysqld
[2013-10-07T14:05:53+00:00] INFO: directory[/var/run/mysqld] owner changed to 999
[2013-10-07T14:05:53+00:00] INFO: directory[/var/run/mysqld] group changed to 1001
[2013-10-07T14:05:53+00:00] INFO: Processing directory[/var/log/mysql] action create (mysql::server line 112)
[2013-10-07T14:05:53+00:00] INFO: directory[/var/log/mysql] created directory /var/log/mysql
[2013-10-07T14:05:53+00:00] INFO: directory[/var/log/mysql] owner changed to 999
[2013-10-07T14:05:53+00:00] INFO: directory[/var/log/mysql] group changed to 1001
[2013-10-07T14:05:53+00:00] INFO: Processing directory[/etc/mysql] action create (mysql::server line 112)
[2013-10-07T14:05:53+00:00] INFO: directory[/etc/mysql] owner changed to 999
[2013-10-07T14:05:53+00:00] INFO: directory[/etc/mysql] group changed to 1001
[2013-10-07T14:05:53+00:00] INFO: Processing directory[/etc/mysql/conf.d] action create (mysql::server line 112)
[2013-10-07T14:05:53+00:00] INFO: directory[/etc/mysql/conf.d] owner changed to 999
[2013-10-07T14:05:53+00:00] INFO: directory[/etc/mysql/conf.d] group changed to 1001
[2013-10-07T14:05:53+00:00] INFO: Processing directory[/var/lib/mysql] action create (mysql::server line 112)
[2013-10-07T14:05:53+00:00] INFO: directory[/var/lib/mysql] created directory /var/lib/mysql
[2013-10-07T14:05:53+00:00] INFO: directory[/var/lib/mysql] owner changed to 999
[2013-10-07T14:05:53+00:00] INFO: directory[/var/lib/mysql] group changed to 1001
[2013-10-07T14:05:53+00:00] INFO: Processing directory[/var/lib/mysql] action create (mysql::server line 112)
[2013-10-07T14:05:53+00:00] INFO: Processing template[/etc/mysql/my.cnf] action create (mysql::server line 129)
[2013-10-07T14:05:53+00:00] INFO: template[/etc/mysql/my.cnf] backed up to /var/chef/backup/etc/mysql/my.cnf.chef-20131007140553
[2013-10-07T14:05:53+00:00] INFO: template[/etc/mysql/my.cnf] updated file contents /etc/mysql/my.cnf
[2013-10-07T14:05:53+00:00] INFO: template[/etc/mysql/my.cnf] sending restart action to service[mysql] (immediate)
[2013-10-07T14:05:53+00:00] INFO: Processing service[mysql] action restart (mysql::server line 251)
================================================================================
Error executing action `restart` on resource 'service[mysql]'
================================================================================
Chef::Exceptions::Exec
----------------------
/sbin/start mysql returned 1, expected 0
Resource Declaration:
---------------------
# In /var/chef/cache/cookbooks/mysql/recipes/server.rb
251: service 'mysql' do
252: action :start
253: end
254: end
Compiled Resource:
------------------
# Declared in /var/chef/cache/cookbooks/mysql/recipes/server.rb:251:in `from_file'
service("mysql") do
provider Chef::Provider::Service::Upstart
action [:start]
supports {:status=>true, :restart=>true, :reload=>true}
retries 0
retry_delay 2
service_name "mysql"
pattern "mysql"
startup_type :automatic
cookbook_name "mysql"
recipe_name "server"
end
[2013-10-07T14:05:53+00:00] INFO: Running queued delayed notifications before re-raising exception
[2013-10-07T14:05:53+00:00] INFO: template[apache2.conf] sending restart action to service[apache2] (delayed)
[2013-10-07T14:05:53+00:00] INFO: Processing service[apache2] action restart (apache2::default line 221)
[2013-10-07T14:05:57+00:00] INFO: service[apache2] restarted
[2013-10-07T14:05:57+00:00] INFO: execute[a2dissite default] sending restart action to service[apache2] (delayed)
[2013-10-07T14:05:57+00:00] INFO: Processing service[apache2] action restart (apache2::default line 24)
[2013-10-07T14:06:00+00:00] INFO: service[apache2] restarted
[2013-10-07T14:06:00+00:00] ERROR: Running exception handlers
[2013-10-07T14:06:00+00:00] ERROR: Exception handlers complete
[2013-10-07T14:06:00+00:00] FATAL: Stacktrace dumped to /var/chef/cache/chef-stacktrace.out
[2013-10-07T14:06:00+00:00] FATAL: Chef::Exceptions::ChildConvergeError: Chef run process exited unsuccessfully (exit code 1)
It seems that with mysql 3.0.6 the installation of mysql doesn't ends well.
Thanks!