Adoptable Cookbooks List

Looking for a cookbook to adopt? You can now see a list of cookbooks available for adoption!
List of Adoptable Cookbooks

Supermarket Belongs to the Community

Supermarket belongs to the community. While Chef has the responsibility to keep it running and be stewards of its functionality, what it does and how it works is driven by the community. The chef/supermarket repository will continue to be where development of the Supermarket application takes place. Come be part of shaping the direction of Supermarket by opening issues and pull requests or by joining us on the Chef Mailing List.

Select Badges

Select Supported Platforms

Select Status

The database cookbook has been deprecated

Author provided reason for deprecation:

The database cookbook has been deprecated and is no longer being maintained by its authors. Use of the database cookbook is no longer recommended.

RSS

database (52) Versions 4.0.7

provides LWRPs for common database tasks

Policyfile
Berkshelf
Knife
cookbook 'database', '= 4.0.7', :supermarket
cookbook 'database', '= 4.0.7'
knife supermarket install database
knife supermarket download database
README
Dependencies
Changelog
Quality 0%

Database Cookbook

The main highlight of this cookbook is the database and
database_user resources for managing databases and database users in
a RDBMS. Providers for MySQL, PostgreSQL and SQL Server are also
provided, see usage documentation below.

Requirements

Chef version 0.11+

Platforms

  • Debian, Ubuntu
  • Red Hat, CentOS, Scientific, Fedora, Amazon

Cookbooks

The following Chef Software cookbooks are dependencies:

  • postgresql

Resources/Providers

These resources aim to expose an abstraction layer for interacting
with different RDBMS in a general way. Currently the cookbook ships
with providers for MySQL, PostgreSQL and SQL Server. Please see
specific usage in the Example sections below. The providers use
specific Ruby gems installed under Chef's Ruby environment to execute
commands and carry out actions. These gems will need to be installed
before the providers can operate correctly. Specific notes for each
RDBS flavor:

  • MySQL: leverages the mysql2 gem, which can be installed with the
    mysql2_chef_gem resource prior to use (available on the
    Supermarket). You must depend on the mysql2_chef_gem cookbook,
    then use a mysql2_chef_gem resource to install it. The resource
    allows the user to select MySQL client library versions, as well as
    optionally select MariaDB libraries.

  • PostgreSQL: leverages the pg gem which is installed as part of the
    postgresql::ruby recipe. You must declare include_recipe
    "database::postgresql"
    to include this.

  • SQL Server: leverages the tiny_tds gem which is installed as part
    of the sql_server::client recipe.

database

Manage databases in a RDBMS. Use the proper shortcut resource
depending on your RDBMS: mysql_database, postgresql_database or
sql_server_database.

Actions

  • :create: create a named database
  • :drop: drop a named database
  • :query: execute an arbitrary query against a named database

Attribute Parameters

  • database_name: name attribute. Name of the database to interact with
  • connection: hash of connection info. valid keys include :host,
    :port, :username, and :password (only for MySQL DB*)

  • sql: string of sql or a block that executes to a string of sql,
    which will be executed against the database. used by :query action
    only

* The database cookbook uses the mysql2 gem.

"The value of host may be either a host name or an IP address. If
host is NULL or the string "127.0.0.1", a connection to the local
host is assumed. For Windows, the client connects using a
shared-memory connection, if the server has shared-memory
connections enabled. Otherwise, TCP/IP is used. For a host value of
"." on Windows, the client connects using a named pipe, if the
server has named-pipe connections enabled. If named-pipe connections
are not enabled, an error occurs."

If you specify a :socket key and are using the mysql_service
resource to set up the MySQL service, you'll need to specify the path
in the form /var/run/mysql-<instance name>/mysqld.sock.

Providers

  • Chef::Provider::Database::Mysql: shortcut resource mysql_database
  • Chef::Provider::Database::Postgresql: shortcut resource postgresql_database
  • Chef::Provider::Database::SqlServer: shortcut resource sql_server_database

Examples

# Create a mysql database
mysql_database 'wordpress-cust01' do
  connection(
    :host     => '127.0.0.1',
    :username => 'root',
    :password => node['wordpress-cust01']['mysql']['initial_root_password']
  )
  action :create
end
# Create a mysql database on a named mysql instance
mysql_database 'oracle_rools' do
  connection(
    :host     => '127.0.0.1',
    :username => 'root',
    :socket   => "/var/run/mysql-#{instance-name}/mysqld.sock"
    :password => node['mysql']['server_root_password']
  )
  action :create
end       
# Create a sql server database
sql_server_database 'mr_softie' do
  connection(
    :host     => '127.0.0.1',
    :port     => node['sql_server']['port'],
    :username => 'sa',
    :password => node['sql_server']['server_sa_password']
  )
  action :create
end
# create a postgresql database
postgresql_database 'mr_softie' do
  connection(
    :host      => '127.0.0.1',
    :port      => 5432,
    :username  => 'postgres',
    :password  => node['postgresql']['password']['postgres']
  )
  action :create
end
# create a postgresql database with additional parameters
postgresql_database 'mr_softie' do
  connection(
    :host     => '127.0.0.1',
    :port     => 5432,
    :username => 'postgres',
    :password => node['postgresql']['password']['postgres']
  )
  template 'DEFAULT'
  encoding 'DEFAULT'
  tablespace 'DEFAULT'
  connection_limit '-1'
  owner 'postgres'
  action :create
end
# Externalize conection info in a ruby hash
mysql_connection_info = {
  :host     => '127.0.0.1',
  :username => 'root',
  :password => node['mysql']['server_root_password']
}

sql_server_connection_info = {
  :host     => '127.0.0.1',
  :port     => node['sql_server']['port'],
  :username => 'sa',
  :password => node['sql_server']['server_sa_password']
}

postgresql_connection_info = {
  :host     => '127.0.0.1',
  :port     => node['postgresql']['config']['port'],
  :username => 'postgres',
  :password => node['postgresql']['password']['postgres']
}

# Same create commands, connection info as an external hash
mysql_database 'foo' do
  connection mysql_connection_info
  action :create
end

sql_server_database 'foo' do
  connection sql_server_connection_info
  action     :create
end

postgresql_database 'foo' do
  connection postgresql_connection_info
  action     :create
end

# Create database, set provider in resource parameter
database 'bar' do
  connection mysql_connection_info
  provider   Chef::Provider::Database::Mysql
  action     :create
end

database 'bar' do
  connection sql_server_connection_info
  provider   Chef::Provider::Database::SqlServer
  action     :create
end

database 'bar' do
  connection postgresql_connection_info
  provider   Chef::Provider::Database::Postgresql
  action     :create
end



# Drop a database
mysql_database 'baz' do
  connection mysql_connection_info
  action    :drop
end



# Query a database
mysql_database 'flush the privileges' do
  connection mysql_connection_info
  sql        'flush privileges'
  action     :query
end


# Query a database from a sql script on disk
mysql_database 'run script' do
  connection mysql_connection_info
  sql { ::File.open('/path/to/sql_script.sql').read }
  action :query
end



# Vacuum a postgres database
postgresql_database 'vacuum databases' do
  connection      postgresql_connection_info
  database_name 'template1'
  sql 'VACUUM FULL VERBOSE ANALYZE'
  action :query
end

database_user

Manage users and user privileges in a RDBMS. Use the proper shortcut resource depending on your RDBMS: mysql_database_user, postgresql_database_user, or sql_server_database_user.

Actions

  • :create: create a user
  • :drop: drop a user
  • :grant: manipulate user privileges on database objects

Attribute Parameters

  • username: name attribute. Name of the database user
  • password: password for the user account
  • database_name: Name of the database to interact with
  • connection: hash of connection info. valid keys include :host, :port, :username, :password
  • privileges: array of database privileges to grant user. used by the :grant action. default is :all
  • host: host where user connections are allowed from. used by MySQL provider only. default is '127.0.0.1'
  • table: table to grant privileges on. used by :grant action and MySQL provider only. default is '*' (all tables)
  • require_ssl: true or false to force SSL connections to be used for user

Providers

  • Chef::Provider::Database::MysqlUser: shortcut resource mysql_database_user
  • Chef::Provider::Database::PostgresqlUser: shortcut resource postgresql_database_user
  • Chef::Provider::Database::SqlServerUser: shortcut resource sql_server_database_user

Examples

# create connection info as an external ruby hash
mysql_connection_info = {:host => "127.0.0.1",
                         :username => 'root',
                         :password => node['mysql']['server_root_password']}
postgresql_connection_info = {:host => "127.0.0.1",
                              :port => node['postgresql']['config']['port'],
                              :username => 'postgres',
                              :password => node['postgresql']['password']['postgres']}
sql_server_connection_info = {:host => "127.0.0.1",
                              :port => node['sql_server']['port'],
                              :username => 'sa',
                              :password => node['sql_server']['server_sa_password']}

# create a mysql user but grant no privileges
mysql_database_user 'disenfranchised' do
  connection mysql_connection_info
  password 'super_secret'
  action :create
end

# do the same but pass the provider to the database resource
database_user 'disenfranchised' do
  connection mysql_connection_info
  password 'super_secret'
  provider Chef::Provider::Database::MysqlUser
  action :create
end

# create a postgresql user but grant no privileges
postgresql_database_user 'disenfranchised' do
  connection postgresql_connection_info
  password 'super_secret'
  action :create
end

# do the same but pass the provider to the database resource
database_user 'disenfranchised' do
  connection postgresql_connection_info
  password 'super_secret'
  provider Chef::Provider::Database::PostgresqlUser
  action :create
end

# create a sql server user but grant no privileges
sql_server_database_user 'disenfranchised' do
  connection sql_server_connection_info
  password 'super_secret'
  action :create
end

# drop a mysql user
mysql_database_user "foo_user" do
  connection mysql_connection_info
  action :drop
end

# bulk drop sql server users
%w{ disenfranchised foo_user }.each do |user|
  sql_server_database_user user do
    connection sql_server_connection_info
    action :drop
  end
end

# grant select,update,insert privileges to all tables in foo db from all hosts, requiring connections over SSL
mysql_database_user 'foo_user' do
  connection mysql_connection_info
  password 'super_secret'
  database_name 'foo'
  host '%'
  privileges [:select,:update,:insert]
  require_ssl true
  action :grant
end

# grant all privileges on all databases/tables from 127.0.0.1
mysql_database_user 'super_user' do
  connection mysql_connection_info
  password 'super_secret'
  action :grant
end

# grant all privileges on all tables in foo db
postgresql_database_user 'foo_user' do
  connection postgresql_connection_info
  database_name 'foo'
  privileges [:all]
  action :grant
end

# grant select,update,insert privileges to all tables in foo db
sql_server_database_user 'foo_user' do
  connection sql_server_connection_info
  password 'super_secret'
  database_name 'foo'
  privileges [:select,:update,:insert]
  action :grant
end

Providers

  • Chef::Provider::Database::MysqlUser: shortcut resource mysql_database_user
  • Chef::Provider::Database::PostgresqlUser: shortcut resource postgresql_database_user
  • Chef::Provider::Database::SqlServerUser: shortcut resourcesql_server_database_user

Examples

# create connection info as an external ruby hash
mysql_connection_info = {
  :host     => '127.0.0.1',
  :username => 'root',
  :password => node['mysql']['server_root_password']
}

postgresql_connection_info = {
  :host     => '127.0.0.1',
  :port     => node['postgresql']['config']['port'],
  :username => 'postgres',
  :password => node['postgresql']['password']['postgres']
}

sql_server_connection_info = {
  :host     => '127.0.0.1',
  :port     => node['sql_server']['port'],
  :username => 'sa',
  :password => node['sql_server']['server_sa_password']
}



# Create a mysql user but grant no privileges
mysql_database_user 'disenfranchised' do
  connection mysql_connection_info
  password   'super_secret'
  action     :create
end



# Do the same but pass the provider to the database resource
database_user 'disenfranchised' do
  connection mysql_connection_info
  password   'super_secret'
  provider   Chef::Provider::Database::MysqlUser
  action     :create
end



# Create a postgresql user but grant no privileges
postgresql_database_user 'disenfranchised' do
  connection postgresql_connection_info
  password   'super_secret'
  action     :create
end



# Do the same but pass the provider to the database resource
database_user 'disenfranchised' do
  connection postgresql_connection_info
  password   'super_secret'
  provider   Chef::Provider::Database::PostgresqlUser
  action     :create
end



# Create a sql server user but grant no privileges
sql_server_database_user 'disenfranchised' do
  connection sql_server_connection_info
  password   'super_secret'
  action     :create
end



# Drop a mysql user
mysql_database_user 'foo_user' do
  connection mysql_connection_info
  action     :drop
end



# Bulk drop sql server users
%w(disenfranchised foo_user).each do |user|
  sql_server_database_user user do
    connection sql_server_connection_info
    action     :drop
  end
end



# Grant SELECT, UPDATE, and INSERT privileges to all tables in foo db from all hosts
mysql_database_user 'foo_user' do
  connection    mysql_connection_info
  password      'super_secret'
  database_name 'foo'
  host          '%'
  privileges    [:select,:update,:insert]
  action        :grant
end



# Grant all privileges on all databases/tables from 127.0.0.1
mysql_database_user 'super_user' do
  connection mysql_connection_info
  password   'super_secret'
  action     :grant
end



# Grant all privileges on all tables in foo db
postgresql_database_user 'foo_user' do
  connection    postgresql_connection_info
  database_name 'foo'
  privileges    [:all]
  action        :grant
end

# grant select,update,insert privileges to all tables in foo db
sql_server_database_user 'foo_user' do
  connection    sql_server_connection_info
  password      'super_secret'
  database_name 'foo'
  privileges    [:select,:update,:insert]
  action        :grant
end

Recipes

ebs_volume

Note: This recipe does not currently work on RHEL platforms due to the xfs cookbook not supporting RHEL yet.

Loads the aws information from the data bag. Searches the applications data bag for the database master or slave role and checks that role is applied to the node. Loads the EBS information and the master information from data bags. Uses the aws cookbook LWRP, aws_ebs_volume to manage the volume.

On a master node:
- if we have an ebs volume already as stored in a data bag, attach it
- if we don't have the ebs information then create a new one and attach it
- store the volume information in a data bag via a ruby block

On a slave node:
- use the master volume information to generate a snapshot
- create the new volume from the snapshot and attach it

Also on a master node, generate some configuration for running a snapshot via chef-solo from cron.

On a new filesystem volume, create as XFS, then mount it in /mnt, and also bind-mount it to the mysql data directory (default /var/lib/mysql).

master

This recipe no longer loads AWS specific information, and the database position for replication is no longer stored in a databag because the client might not have permission to write to the databag item. This may be handled in a different way at a future date.

Searches the apps databag for applications, and for each one it will check that the specified database master role is set in both the databag and applied to the node's run list. Then, retrieves the passwords for root, repl and debian users and saves them to the node attributes. If the passwords are not found in the databag, it prints a message that they'll be generated by the mysql cookbook.

Then it adds the application databag database settings to a hash, to use later.

Then it will iterate over the databases and create them with the mysql_database resource while adding privileges for application specific database users using the mysql_database_user resource.

slave

TODO: Retrieve the master status from a data bag, then start replication using a ruby block. The replication status needs to be handled in some other way for now since the master recipe above doesn't actually set it in the databag anymore.

snapshot

Run via Chef Solo. Retrieves the db snapshot configuration from the specified JSON file. Uses the mysql_database resource to lock and unlock tables, and does a filesystem freeze and EBS snapshot.

Deprecated Recipes

The following recipe is considered deprecated. It is kept for reference purposes.

ebs_backup

Older style of doing mysql snapshot and replication using Adam Jacob's ec2_mysql script and library.

Data Bags

This cookbook uses the apps data bag item for the specified application; see the application cookbook's README.md. It also creates data bag items in a bag named 'aws' for storing volume information. In order to interact with EC2, it expects aws to have a main item:

{
  "id": "main",
  "ec2_private_key": "private key as a string",
  "ec2_cert": "certificate as a string",
  "aws_account_id": "",
  "aws_secret_access_key": "",
  "aws_access_key_id": ""
}

Note: with the Open Source Chef Server, the server using the database recipes must be an admin client or it will not be able to create data bag items. You can modify whether the client is admin by editing it with knife.

knife client edit 
{
  ...
  "admin": true
  ...
}

This is not required if the Chef Server is Chef Software Hosted Chef, instead use the ACL feature to modify access for the node to be able to update the data bag.

Usage

Aside from the application data bag (see the README in the application cookbook), create a role for the database master. Use a role.rb in your chef-repo, or create the role directly with knife.

{
  "name": "my_app_database_master",
  "chef_type": "role",
  "json_class": "Chef::Role",
  "default_attributes": {},
  "description": "",
  "run_list": [
    "recipe[mysql::server]",
    "recipe[database::master]"
  ],
  "override_attributes": {}
}

Create a production environment. This is also used in the application cookbook.

{
  "name": "production",
  "description": "",
  "cookbook_versions": {},
  "json_class": "Chef::Environment",
  "chef_type": "environment",
  "default_attributes": {},
  "override_attributes": {}
}

The cookbook my_app_database is recommended to set up any
application specific database resources such as configuration
templates, trending monitors, etc. It is not required, but you would
need to create it separately in site-cookbooks. Add it to the
my_app_database_master role.

License & Authors

Copyright 2009-2015, Chef Software, Inc.

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

Dependent cookbooks

postgresql >= 1.0.0

Contingent cookbooks

abiquo Applicable Versions
agilefant Applicable Versions
alfresco Applicable Versions
alfresco-db Applicable Versions
askbot Applicable Versions
automysqlbackup Applicable Versions
bacula Applicable Versions
bacula-backup Applicable Versions
bamboo Applicable Versions
boilerplate Applicable Versions
boxbilling Applicable Versions
bricks Applicable Versions
cacti Applicable Versions
chef-manageiq Applicable Versions
chef_crowd Applicable Versions
chef_jira Applicable Versions
cloudfoundry-cloud_controller Applicable Versions
cloudless-box Applicable Versions
co-cloudstack Applicable Versions
concourse Applicable Versions
config-driven-helper Applicable Versions
confluence Applicable Versions
crowd Applicable Versions
database_restore Applicable Versions
databox Applicable Versions
druid-example Applicable Versions
drupal-cookbook Applicable Versions
drupalbaseplus Applicable Versions
dvwa Applicable Versions
eulipion-cleanspeak Applicable Versions
fanfare Applicable Versions
ff_sync Applicable Versions
flyway-cli Applicable Versions
foreman Applicable Versions
frog Applicable Versions
gallery Applicable Versions
gerrit Applicable Versions
github_connector Applicable Versions
gitlab Applicable Versions
gitlab-server Applicable Versions
gitlab-shell Applicable Versions
gitlabhq Applicable Versions
gitorious Applicable Versions
gitrob Applicable Versions
gotcms Applicable Versions
guardian Applicable Versions
ignite-openfire Applicable Versions
imply-platform Applicable Versions
iptables_web Applicable Versions
jahia Applicable Versions
jenkins_build Applicable Versions
jira Applicable Versions
kloudspeaker Applicable Versions
lemur Applicable Versions
liquid-feedback Applicable Versions
magentostack Applicable Versions
mattermost Applicable Versions
mediacore Applicable Versions
mediawiki Applicable Versions
metarepo Applicable Versions
mirage Applicable Versions
moodle Applicable Versions
myface Applicable Versions
mysql-sys Applicable Versions
mysql_logrotate Applicable Versions
mysql_role Applicable Versions
myusa Applicable Versions
nephology Applicable Versions
nodestack Applicable Versions
noosfero Applicable Versions
oc-id Applicable Versions
omakase Applicable Versions
open-build-service Applicable Versions
openfire Applicable Versions
openstack-common Applicable Versions
openstack-mistral Applicable Versions
openstack-ops-database Applicable Versions
owncloud Applicable Versions
pagekit Applicable Versions
paramount Applicable Versions
pdns Applicable Versions
pentester Applicable Versions
percona-tools Applicable Versions
pg_repack Applicable Versions
phabricator Applicable Versions
phpbb Applicable Versions
phpstack Applicable Versions
postfixadmin Applicable Versions
poweradmin Applicable Versions
prestashop Applicable Versions
pythonstack Applicable Versions
q2a Applicable Versions
railsbox Applicable Versions
razor Applicable Versions
redmine2 Applicable Versions
repmgr Applicable Versions
rubycas Applicable Versions
singularity Applicable Versions
sogo Applicable Versions
sonarqube-mysql Applicable Versions
spinen-artifactory Applicable Versions
spree Applicable Versions
stack_commons Applicable Versions
stackstorm Applicable Versions
stash Applicable Versions
sugarcrm-ce Applicable Versions
symfony Applicable Versions
tango Applicable Versions
teampass Applicable Versions
tonicdns Applicable Versions
vicnum Applicable Versions
wordpress Applicable Versions
zabbix Applicable Versions
zabbix-pkg Applicable Versions
zabbix2 Applicable Versions
zabbix_lwrp Applicable Versions
zarafa Applicable Versions
zf2 Applicable Versions

Database cookbook README

v4.0.7 (2015-07-27)

  • #161 - Fixes multiple issues causing the MySQL database user creation to not be idempotent

v4.0.6 (2015-04-29)

  • #126 - Use sql_query property instead of sql in the mysql provider for :query action

v4.0.5 (2015-04-08)

  • #137/#138 - Removing log message containing password information

v4.0.4 (2015-04-07)

  • Using unescaped db name in field value

v4.0.3 (2015-02-22)

  • Unbreak postgresql_database_resource on older versions of PostgreSQL

v4.0.2 (2015-02-09)

  • Removing leftover mysql recipe that installs the mysql2_chef_gem.

v4.0.1 (2015-02-05)

  • Fixing merge conflicts with master on 4.0.0 attempted release

v4.0.0 (2015-02-05)

  • Decoupled mysql2_chef_gem cookbook. Users must now install it themselves before utilizing mysql_database or mysql_database_user resources.
  • Fixing various MilClass errors in mysql providers
  • Restoring missing :query action for mysql
  • Restoring grant_option support for mysql
  • Adding revoke action for mysql

v3.1.0 (2015-01-30)

  • Add support for postgresql_database_user privileges
  • Add postgresql_database_test cookbook to test/fixtures

v3.0.3 (2015-01-20)

  • Bugfix: bugfix: lack of node['mysql']['version'] causing NilClass error

v3.0.2 (2015-01-16)

  • Fix bug to allow grants on databases with special characters

v3.0.1 (2015-01-16)

  • Enabling ssl for provider_mysql_database_user

v3.0.0 (2015-01-15)

  • Removing out of scope recipes
  • porting to mysql2_chef_gem
  • adding test-kitchen suites for mysql

v2.3.1 (2014-12-13)

  • Locking mysql and mysql-chef_gem dependencies down in metadata.rb

v2.3.0 (2014-08-13)

  • [#62] Allow requiring SSL

v2.2.0 (2014-05-07)

  • [COOK-4626] Add windows users for SQL Server
  • [COOK-4627] Assigning sys_roles in SQL Server

v2.1.10 (2014-05-07)

  • [COOK-4614] - Update README to reflect gem installation via mysql-chef_gem

v2.1.8 (2014-04-23)

  • [COOK-4583] - Add ChefSpec matchers

v2.1.6 (2014-04-10)

  • [COOK-4538] Bump supported Chef version

v2.1.4 (2014-04-09)

[COOK-4529] Query action ignores MySQL errors

v2.1.2 (2014-04-01)

  • Depending on mysql-chef_gem cookbook

v2.1.0 (2014-03-31)

  • Updating mysql cookbook dependency
  • Enforcing rubocops

v2.0.0 (2014-02-25)

[COOK-3441] database_user password argument should not be required

v1.6.0

New Feature

  • COOK-4009 - Add PostgreSQL SCHEMA management capability

Improvement

  • COOK-3862 - Improve database cookbook documentation

v1.5.2

Improvement

  • COOK-3716 - Add ALTER SQL Server user roles

v1.5.0

Improvement

v1.4.0

Bug

  • [COOK-2074]: Regex in exists? check in sql_server_database resource should match for start and end of line
  • [COOK-2561]: mysql_database_user can't set global grants

Improvement

  • [COOK-2075]: Support the collation attribute in the database_sql_server provider

v1.3.12

  • [COOK-850] - postgresql_database_user doesn't have example

v1.3.10

  • [COOK-2117] - undefined variable grant_statement in mysql user provider

v1.3.8

  • [COOK-1896] - Escape command
  • [COOK-2047] - Chef::Provider::Database::MysqlUser action :grant improperly quotes username@host string
  • [COOK-2060] - Mysql::Error: Table '.' doesn't exist when privileges include SELECT and database/table attributes are nil
  • [COOK-2062] - Remove backticks from database name when using wildcard

v1.3.6

  • [COOK-1688] - fix typo in readme and add amazon linux to supported platforms

v1.3.4

  • [COOK-1561] - depend on mysql 1.3.0+ explicitly
  • depend on postgresql 1.0.0 explicitly

v1.3.2

  • Update the version for release (oops)

v1.3.0

  • [COOK-932] - Add mysql recipe to conveniently include mysql::ruby
  • [COOK-1228] - database resource should be able to execute scripts on disk
  • [COOK-1291] - make the snapshot retention policy less confusing
  • [COOK-1401] - Allow to specify the collation of new databases
  • [COOK-1534] - Add postgresql recipe to conveniently include postgresql::ruby

v1.2.0

  • [COOK-970] - workaround for disk [re]naming on ubuntu 11.04+
  • [COOK-1085] - check RUBY_VERSION and act accordingly for role
  • [COOK-749] - localhost should be a string in snapshot recipe

v1.1.4

  • [COOK-1062] - Databases: Postgres exists should close connection

v1.1.2

  • [COOK-975] - Change arg='DEFAULT' to arg=nil, :default => 'DEFAULT'
  • [COOK-964] - Add parentheses around connection hash in example

v1.1.0

  • [COOK-716] - providers for PostgreSQL

v1.0.0

  • [COOK-683] - added database and database_user resources
  • [COOK-684] - MySQL providers
  • [COOK-685] - SQL Server providers
  • refactored - database::master and database::snapshot recipes to leverage new resources

v0.99.1

  • Use Chef 0.10's node.chef_environment instead of node['app_environment'].

Foodcritic Metric
            

4.0.7 failed this metric

FC001: Use strings in preference to symbols to access node attributes: /tmp/cook/34e7f47622b037b943af31e6/database/libraries/provider_database_postgresql.rb:127
FC002: Avoid string interpolation where not required: /tmp/cook/34e7f47622b037b943af31e6/database/libraries/provider_database_mysql_user.rb:169
FC023: Prefer conditional attributes: /tmp/cook/34e7f47622b037b943af31e6/database/libraries/provider_database_mysql.rb:46
FC023: Prefer conditional attributes: /tmp/cook/34e7f47622b037b943af31e6/database/libraries/provider_database_mysql.rb:77
FC023: Prefer conditional attributes: /tmp/cook/34e7f47622b037b943af31e6/database/libraries/provider_database_mysql_user.rb:46
FC023: Prefer conditional attributes: /tmp/cook/34e7f47622b037b943af31e6/database/libraries/provider_database_mysql_user.rb:76
FC023: Prefer conditional attributes: /tmp/cook/34e7f47622b037b943af31e6/database/libraries/provider_database_mysql_user.rb:183
FC031: Cookbook without metadata file: /tmp/cook/34e7f47622b037b943af31e6/database/metadata.rb:1
FC045: Consider setting cookbook name in metadata: /tmp/cook/34e7f47622b037b943af31e6/database/metadata.rb:1