#
# Cookbook Name:: cfe-mariadb
# Recipe:: default
#
# Copyright 2016, Chromedia
#
# All rights reserved - Do Not Redistribute
#

# Some notes:
#   If the DB server is dedicated, it might be a good idea to 
#   add 'noatime' to the / disk's mount options.

chef_gem 'chef-rewind' do
  compile_time true if respond_to?(:compile_time)
end
require 'chef/rewind'

mysql2_chef_gem 'default' do
  action :install
end

include_recipe 'mariadb'

# It looks like the service is sometimes not being restarted
# correctly. This rewind will make sure the right provider is used.
rewind 'service[mysql]' do
  supports :status => true, :restart => true
end

# If we are not replicating. 
# Binary logging actually causes an issue with some CiviCRM installations
# when using remote database servers.
if not node['cfe-mariadb']['replication']
  rewind 'mariadb_configuration[replication]' do
    action :remove
  end
end

# Prepare the needed databases and users.
con = {
  :port     => node['mariadb']['mysqld']['port'],
  :username => 'root',
  :password => node['mariadb']['server_root_password']
}
node.default['cfe-mariadb']['db_map'].each do |dbx_name, dbx|

  mysql_database dbx_name do
    connection con
    action     :create
    if dbx.has_key?(:char_set)
      encoding dbx[:char_set]
    end
    if dbx.has_key?(:collate)
      collation dbx[:collate]
    end
  end

  mysql_database_user dbx[:db_user] do
    connection    con
    password      dbx[:db_pass]
    database_name dbx_name
    host          '%'
    privileges    [:all]
    action        :grant
  end
end