chef solo における database のエラー

【質問】

$ bundle exec knife solo cook ノード名

で以下の通りエラーが発生が出る

Error executing action create on resource 'mysql_database[aws]'

*現状databaseを使わないレシピは動いています

【やりたいこと】
opscodeのdatabaseを使ってrecipeを書きたい
（次のレシピではデータベースを作成しようとしているだけです）
*公式
https://github.com/opscode-cookbooks/database/blob/master/README.md

【レシピ】

./Berkshelf

source "https://api.berkshelf.com"
cookbook "mysql2_chef_gem"
cookbook "database"
cookbook "yum"

node/ノード.jsonファイル

{
  "run_list": [
    "recipe[sample]"
  ],
  "automatic": {
    "ipaddress": "ノード名"
  }
}

site-cookbooks/sample/metadata.rb

name             'sample'
maintainer       'YOUR_COMPANY_NAME'
maintainer_email 'YOUR_EMAIL'
license          'All rights reserved'
description      'Installs/Configures mysql'
long_description IO.read(File.join(File.dirname(__FILE__), 'README.md'))
version          '0.1.0'
depends 'database'

site-cookbooks/sample/recipes/default.rb

mysql_connection_info = {
  :host     => '127.0.0.1',
  :username => 'root',
  :password => 'パスワード'
}
mysql_database "aws" do
  connection mysql_connection_info
  action :create
end

【環境】
Mac OSX 10.9.5
Chef Development Kit Version: 0.4.0
Chef: 12.0.3
Bundler version 1.7.11
database (4.0.2)
chefの流し込んでいる先はAmazon Linux(2014 9)です

【その他】
海外サイト等でもヒントになりそうな情報がありましたら
ご指摘頂ければと思います。

【エラー】

mysql_database[aws] action create ================================================================================
Error executing action create on resource 'mysql_database[aws]' ================================================================================

LoadError

cannot load such file -- mysql2

Cookbook Trace:

/home/ec2-user/chef-solo/cookbooks-2/database/libraries/provider_database_mysql.rb:103:in test_client'
/home/ec2-user/chef-solo/cookbooks-2/database/libraries/provider_database_mysql.rb:37:inblock in '

Resource Declaration:

In /home/ec2-user/chef-solo/cookbooks-3/sample/recipes/default.rb

15: mysql_database "aws" do
16: connection mysql_connection_info
17: action :create
18: end
19:

Compiled Resource:

Declared in /home/ec2-user/chef-solo/cookbooks-3/sample/recipes/default.rb:15:in `from_file'

mysql_database("aws") do
provider Chef::Provider::Database::Mysql
action [:create]
retries 0
retry_delay 2
guard_interpreter :default
database_name "aws"
cookbook_name :sample
recipe_name "default"
connection {:host=>"127.0.0.1", :username=>"root", :password=>"パスワード"}
end

Running handlers:
[2015-02-15T08:20:08+00:00] ERROR: Running exception handlers
Running handlers complete
[2015-02-15T08:20:08+00:00] ERROR: Exception handlers complete
[2015-02-15T08:20:08+00:00] FATAL: Stacktrace dumped to /var/chef/cache/chef-stacktrace.out
Chef Client failed. 0 resources updated in 1.391575845 seconds
[2015-02-15T08:20:08+00:00] ERROR: mysql_database[aws] (sample::default line 15) had an error: LoadError: cannot load such file -- mysql2
[2015-02-15T08:20:08+00:00] FATAL: Chef::Exceptions::ChildConvergeError: Chef run process exited unsuccessfully (exit code 1)

---

【追記分】

Berksfile

source "https://api.berkshelf.com"
cookbook "mysql2_chef_gem"
cookbook "database"
cookbook "yum"

site-cookbooks/sample/metadata.rb

name             'sample'
maintainer       'YOUR_COMPANY_NAME'
maintainer_email 'YOUR_EMAIL'
license          'All rights reserved'
description      'Installs/Configures mysql'
long_description IO.read(File.join(File.dirname(__FILE__), 'README.md'))
version          '0.1.0'

depends 'mysql2_chef_gem'
depends 'database'

site-cookbooks/sample/attributes/default.rb

default['mysql']['version']='5.5'

site-cookbooks/sample/recipes/default.rb

#
# Cookbook Name:: mysql
# Recipe:: default
#
# Copyright 2014, YOUR_COMPANY_NAME
#
# All rights reserved - Do Not Redistribute
#
mysql2_chef_gem 'default' do
  client_version node['mysql']['version'] if node['mysql']
  action :install
end

mysql_connection_info = { 
  :host     => '127.0.0.1',
  :username => 'root',
  :password => 'パスワード' 
}

mysql_database "aws" do
  connection mysql_connection_info
  action :create
end

Aws側のLinuxのMysqlバージョン

Server version: 5.5.40 MySQL Community Server (GPL)

【エラー】

Running Chef on aws_controller...
Checking Chef version...
Installing Berkshelf cookbooks to 'cookbooks'...
Resolving cookbook dependencies...
Using apt (2.6.1)
Using build-essential (2.1.3)
Using chef-sugar (2.5.0)
Using database (4.0.2)
Using mariadb (0.2.12)
Using mysql (6.0.13)
Using mysql2_chef_gem (1.0.1)
Using openssl (2.0.2)
Using postgresql (3.4.14)
Using rbac (1.0.2)
Using resource-control (0.1.1)
Using smf (2.2.1)
Using yum (3.5.2)
Using yum-epel (0.6.0)
Using yum-mysql-community (0.1.12)
Vendoring apt (2.6.1) to パス/cookbooks/apt
Vendoring build-essential (2.1.3) to パス/cookbooks/build-essential
Vendoring chef-sugar (2.5.0) to パス/cookbooks/chef-sugar
Vendoring database (4.0.2) to パス/cookbooks/database
Vendoring mariadb (0.2.12) to パス/cookbooks/mariadb
Vendoring mysql (6.0.13) to パス/cookbooks/mysql
Vendoring mysql2_chef_gem (1.0.1) to パス/cookbooks/mysql2_chef_gem
Vendoring openssl (2.0.2) to パス/cookbooks/openssl
Vendoring postgresql (3.4.14) to パス/cookbooks/postgresql
Vendoring rbac (1.0.2) to パス/cookbooks/rbac
Vendoring resource-control (0.1.1) to パス/cookbooks/resource-control
Vendoring smf (2.2.1) to パス/cookbooks/smf
Vendoring yum (3.5.2) to パス/cookbooks/yum
Vendoring yum-epel (0.6.0) to パス/cookbooks/yum-epel
Vendoring yum-mysql-community (0.1.12) to パス/cookbooks/yum-mysql-community
Uploading the kitchen...
Generating solo config...
Running Chef...
[2015-02-15T14:50:52+00:00] WARN:

---

SSL validation of HTTPS requests is disabled. HTTPS connections are still
encrypted, but chef is not able to detect forged replies or man in the middle
attacks.

To fix this issue add an entry like this to your configuration file:

```
# Verify all HTTPS connections (recommended)
ssl_verify_mode :verify_peer

# OR, Verify only connections to chef-server
verify_api_cert true
```

To check your SSL configuration, or troubleshoot errors, you can use the
knife ssl check command like so:


knife ssl check -c /home/ec2-user/chef-solo/solo.rb


---

Starting Chef Client, version 11.16.4
Compiling Cookbooks...
Converging 2 resources
Recipe: sample::default
* mysql2_chef_gem[default] action install
Recipe: build-essential::_rhel
* package[autoconf] action install (up to date)
* package[bison] action install (up to date)
* package[flex] action install (up to date)
* package[gcc] action install (up to date)
* package[gcc-c++] action install (up to date)
* package[kernel-devel] action install (up to date)
* package[make] action install (up to date)
* package[m4] action install (up to date)
* package[patch] action install (up to date)
* mysql_client[default] action create

 ================================================================================
 Error executing action `create` on resource 'mysql_client[default]'
 ================================================================================

 NoMethodError
 -------------
 undefined method `[]' for nil:NilClass

 Cookbook Trace:
 ---------------
 /home/ec2-user/chef-solo/cookbooks-2/mysql/libraries/helpers.rb:287:in `package_name_for'
 /home/ec2-user/chef-solo/cookbooks-2/mysql/libraries/helpers.rb:319:in `client_package'
 /home/ec2-user/chef-solo/cookbooks-2/mysql/libraries/helpers.rb:29:in `client_package_name'
 /home/ec2-user/chef-solo/cookbooks-2/mysql/libraries/provider_mysql_client.rb:19:in `block in <class:MysqlClient>'

 Resource Declaration:
 ---------------------
 # In /home/ec2-user/chef-solo/cookbooks-2/mysql2_chef_gem/libraries/provider_mysql2_chef_gem_mysql.rb

  16:           mysql_client 'default' do
  17:             version new_resource.client_version
  18:             action :create
  19:           end
  20: 

 Compiled Resource:
 ------------------
 # Declared in /home/ec2-user/chef-solo/cookbooks-2/mysql2_chef_gem/libraries/provider_mysql2_chef_gem_mysql.rb:16:in `block in <class:Mysql>'

 mysql_client("default") do
   action [:create]
   retries 0
   retry_delay 2
   guard_interpreter :default
   cookbook_name :sample
   version "5.5"
 end

================================================================================
Error executing action install on resource 'mysql2_chef_gem[default]'
================================================================================

NoMethodError

---

mysql_client[default] (/home/ec2-user/chef-solo/cookbooks-2/mysql2_chef_gem/libraries/provider_mysql2_chef_gem_mysql.rb line 16) had an error: NoMethodError: undefined method `[]' for nil:NilClass

Cookbook Trace:

---

/home/ec2-user/chef-solo/cookbooks-2/mysql/libraries/helpers.rb:287:in package_name_for'
/home/ec2-user/chef-solo/cookbooks-2/mysql/libraries/helpers.rb:319:inclient_package'
/home/ec2-user/chef-solo/cookbooks-2/mysql/libraries/helpers.rb:29:in client_package_name'
/home/ec2-user/chef-solo/cookbooks-2/mysql/libraries/provider_mysql_client.rb:19:inblock in '

Resource Declaration:

---

# In /home/ec2-user/chef-solo/cookbooks-3/sample/recipes/default.rb

 9: mysql2_chef_gem 'default' do
10:   client_version node['mysql']['version'] if node['mysql']
11:   action :install
12: end
13: 

Compiled Resource:

---

# Declared in /home/ec2-user/chef-solo/cookbooks-3/sample/recipes/default.rb:9:in `from_file'

mysql2_chef_gem("default") do
action [:install]
retries 0
retry_delay 2
guard_interpreter :default
cookbook_name :sample
recipe_name "default"
client_version "5.5"
gem_version "0.3.17"
end

Running handlers:
[2015-02-15T14:50:55+00:00] ERROR: Running exception handlers
Running handlers complete
[2015-02-15T14:50:55+00:00] ERROR: Exception handlers complete
[2015-02-15T14:50:55+00:00] FATAL: Stacktrace dumped to /var/chef/cache/chef-stacktrace.out
Chef Client failed. 0 resources updated in 3.096810316 seconds
[2015-02-15T14:50:55+00:00] ERROR: mysql2_chef_gem[default] (sample::default line 9) had an error: NoMethodError: mysql_client[default] (/home/ec2-user/chef-solo/cookbooks-2/mysql2_chef_gem/libraries/provider_mysql2_chef_gem_mysql.rb line 16) had an error: NoMethodError: undefined method `[]' for nil:NilClass
[2015-02-15T14:50:55+00:00] FATAL: Chef::Exceptions::ChildConvergeError: Chef run process exited unsuccessfully (exit code 1)