database_sl Cookbook

Super light database cookbook. As opposed to other database cookbooks, to run
queries it is used only the official terminal-based tool.
Living on the edge, it is used the approach to build custom
resources introduced in
chef-client version 12.5.

Requirements

Platforms

• Ubuntu 14.04 LTS

Chef

• Chef 12.2.0

packages

• database_sl::postgresql - Installs PostgreSQL db server and client

Attributes

database_sl::postgresql

See attributes/postgresql.rb for default values.

• node['database']['postgresql']['package_version'] - Version of the postgresql package
• node['database']['postgresql']['version'] - Version of the postgresql db

To check available package versions run command:

sudo apt-cache madison postgresql

Resources

Example create postgresql user:

postgresql_user 'create_webuser' do
  name 'webuser'
  password 'webuser123'
  action :create
end

Example grant privileges to postgresql user:

postgresql_user 'grant_webuser' do
  database_name 'database_test'
  name 'webuser'
  password 'webuser123'
  privileges ['ALL PRIVILEGES']
  action :grant
end

Example create postgresql database:

postgresql_database 'database_test' do
  action :create
end

Usage

database_sl::postgresql

Just include database_sl in your node's run_list:

{
  "name":"my_node",
  "run_list": [
    "recipe[database_sl::postgresql]"
  ]
}

For sharing at Chef Supermarket:

knife cookbook site share "database_sl" "Databases"

Testing

Before running kitchen test:

# vagrant box matching `.kitchen.yml` platform driver box
vagrant box add ubuntu-14.04 https://github.com/kraksoft/vagrant-box-ubuntu/releases/download/14.04/ubuntu-14.04-amd64.box

Contributing

1. Fork the repository on Github
2. Create a named feature branch (like add_component_x)
3. Write your change
4. Write tests for your change (if applicable)
5. Run the tests, ensuring they all pass
6. Submit a Pull Request using Github

License and Authors

Authors: David Saenz Tagarro