使用主厨在MySQL上安装CentOS社区服务器

Question

我尝试在MySQL社区服务器上安装CentOS7，使用来自超市：https://supermarket.chef.io/cookbooks/mysql的mysql厨师食谱

我的食谱档案：

metadata.rb

depends 'mysql', '~> 8.0.4'

default.rb

mysql_service 'db_some_data' do
  port '3306'
  version '5.7'
  initial_root_password 'abc123'
  action [:create, :start]
end

我执行了：

berks install
kitchen test -d never

并得到以下错误：

================================================================================
Error executing action `install` on resource 'yum_package[mysql-community-server]'
================================================================================

Chef::Exceptions::Package
-------------------------
No candidate version available for mysql-community-server

    Resource Declaration:
    ---------------------
    # In /tmp/kitchen/cache/cookbooks/mysql/libraries/mysql_server_installation_package.rb

     17:       package package_name do
     18:         version package_version if package_version
     19:         options package_options if package_options
     20:         notifies :install, 'package[perl-Sys-Hostname-Long]', :immediately if plaform_family?('suse')
     21:         notifies :run, 'execute[Initial DB setup script]', :immediately if platfom_family?('suse')
     22:         action :install
     23:       end
     24:

    Compiled Resource:
    ------------------
    # Declared in /tmp/kitchen/cache/cookbooks/mysql/libraries/mysql_server_installation_pckage.rb:17:in `block in <class:MysqlServerInstallationPackage>'

    yum_package("mysql-community-server") do
      package_name "mysql-community-server"
      action [:install]
      retries 0
      retry_delay 2
      default_guard_interpreter :default
      declared_type :package
      cookbook_name "obiwan"
      version "5.7.11-1.el7"
      flush_cache {:before=>false, :after=>false}
    end

    Platform:
    ---------
    x86_64-linux

它看起来像这个问题：https://github.com/chef-cookbooks/mysql/issues/443

耽误您时间，实在对不起!

Answer 1

我怀疑您可能需要使用不同的食谱，因为下面的命令没有显示centos 7 repo中的mysql社区服务器。也许可以试试mariadb食谱。

yum provides mysql*

但是，如果您真的需要安装mysql社区服务器，您可能需要修改您的菜谱，如下所示

execute 'mysql-community-repo' do
 command 'yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
 action :run
end

 mysql_service 'db_some_data' do
  port '3306'
  version '5.7'
  initial_root_password 'abc123'
  action [:create, :start]
 end   

请记住，在启动mysql社区时，您可能会遇到与systemctl init脚本有关的一些问题。

Answer 2

我设法通过以下更改修复了此设置：

metadata.rb

depends 'mysql'
depends 'mysql2_chef_gem'
depends 'database'

default.rb

mysql_client 'default' do
  action :create
end

mysql_service 'db_some_data' do
  port '3306'
  version '5.7'
  initial_root_password 'abc123'
  action [:create, :start]
end

mysql2_chef_gem 'default' do
  action :install
end

Answer 3

这个问题的存在是因为https://supermarket.chef.io/cookbooks/mysql还不支持

cookbook 'mysql', '~> 8.0'

我添加了下面的依赖项，它运行得很好。

cookbook "yum-mysql-community", '~> 4.0.1'
cookbook 'mysql', '~> 6.0'
cookbook 'yum-centos', '~> 3.0.0'

这里要注意的另一件事是记住在菜谱中提供package_name。我的食谱是这样的：

mysql_service 'foo' do
  port '3306'
  version '5.7'
  package_name 'mysql-server' 
  initial_root_password 'root'
  action [:create, :start]
end

希望能帮上忙！