[chef] Re: cookbook wordpress problem with mysql 3.0.6

[Ignasi < >]

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 
<
 >
 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
> https://github.com/opscode-cookbooks/mysql mysql version with the commit
> 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!
>