Contents

# Mysql recipes
namespace :mysql do
  
  desc <<-DESC
  Install mysql monit hooks.
  
  *db_port*: Mysql port. _Defaults to 3306_\n
  *mysql_pid_path*: Path to mysql pid file. _Defaults to /var/run/mysqld/mysqld.pid_\n
  @set :mysql_pid_path, "/var/run/mysqld/mysqld.pid"@\n
  *monit_conf_dir*: Destination for monitrc. _Defaults to "/etc/monit"_\n
  @set :monit_conf_dir, "/etc/monit"@\n
  DESC
  task :install_monit do
    
    # Settings 
    fetch_or_default(:mysql_pid_path, "/var/run/mysqld/mysqld.pid")
    fetch_or_default(:db_port, 3306)   
    fetch_or_default(:monit_conf_dir, "/etc/monit") 
    
    put template.load("mysql/mysql.monitrc.erb", binding), "/tmp/mysql.monitrc"    
    run_via "install -o root /tmp/mysql.monitrc #{monit_conf_dir}/mysql.monitrc"
  end
  
  desc <<-DESC
  Create database, database user, and set grant permissions.
  
  *db_name*: Database name (application).\n
  *db_user*: Database user (application).\n    
  *db_pass*: Database password (application).\n
  *grant_locations*: Grant locations. _Defaults to localhost_\n
  @set :grant_locations, [ "localhost", "192.168.1.111" ]@\n
  *grant_priv_type*: Grant privilege types. _Defaults to ALL_\n
  @set :grant_priv_type, "ALL"@\n
  *mysql_admin_password*: Mysql admin password (to use to connect). Defaults to password prompt.\n
  @set :mysql_admin_password, prompt.password('Mysql admin password: '))@    
  DESC
  task :setup do    
    
    # Settings
    fetch(:db_name)
    fetch(:db_user)
    fetch(:db_pass)
    fetch_or_default(:mysql_admin_password, prompt.password('Mysql admin password: '))
    fetch_or_default(:grant_locations, [ "localhost" ])
    fetch_or_default(:grant_priv_type, "ALL")
        
    # Add localhost to grant locations
    set :locations_for_grant, [ "localhost", web_host, db_host ].compact
    
    put template.load("mysql/install_db.sql.erb"), "/tmp/install_db_#{application}.sql"    
    run "mysql -u root -p#{mysql_admin_password} < /tmp/install_db_#{application}.sql"
  end
  
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
capitate-0.2.1	lib/recipes/mysql.rb