Cookbook wordpress problem with mysql 3.0.6

Hi all,

I was using chef to configure ubuntu ami in ec2 for wordpress. And it was
working with amazon linux also.

The thing is that after the commit in the
https://github.com/opscode-cookbooks/mysql mysql version with the commit
https://github.com/opscode-cookbooks/mysql/commit/6650246f5f68632b23fd8ec86f536efab2b54774
https://github.com/opscode-cookbooks/mysql/commit/6650246f5f68632b23fd8ec86f536efab2b54774

I am seeing the following error in logs

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!

I think this is the same issue that has been reported here:
https://tickets.opscode.com/browse/COOK-3752

On 7 October 2013 16:37, Zain Malik zmalikshxil@gmail.com wrote:

Hi all,

I was using chef to configure ubuntu ami in ec2 for wordpress. And it was
working with amazon linux also.

The thing is that after the commit in the
GitHub - sous-chefs/mysql: Development repository for the mysql cookbook mysql version with the commit
Version bump to v3.0.6 · sous-chefs/mysql@6650246 · GitHub

I am seeing the following error in logs

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!