sugarcrm.cloudscript

# Install SugarCRM 6.5.20 on a CS1-SSD Cloudlet ($.015/hr) running Linux Ubuntu Server 14.04 LTS 64-bit
cloudscript sugarcrm
    version                 = _latest
    result_template         = sugarcrm_result_template

globals
    sugarcrm_hostname       = 'sugarcrm'
    sugarcrm_instance_type  = 'CS1-SSD' # 1GB RAM, 1 vCore, 25GB SSD, 10Gbps
    sugarcrm_image_type     = 'Ubuntu Server 14.04 LTS'
    sugarcrm_version        = 'SugarCE-6.5.20.zip'
    server_password         = lib::random_password()
    console_password        = lib::random_password()
    sugarcrm_db_password    = lib::random_password()
    sugarcrm_db_name        = 'sugarcrm'
    sugarcrm_db_username    = 'sugarcrm'
    sugarcrm_slice_user     = 'sugarcrmsliceuser'

thread core
    tasks                   = [install]
    
task install

    #-----------------------
    # create wordpress keys
    #-----------------------
    
    /key/password sugarcrm_server_key read_or_create
        key_group           = _SERVER
        password            = server_password
    
    /key/password sugarcrm_console_key read_or_create
        key_group           = _CONSOLE
        password            = console_password

    #----------------------------
    # create sugarcrm bootstrap 
    # script and recipe
    #----------------------------
    
    # storage slice key
    /key/token sugarcrm_slice_key read_or_create
        username            = sugarcrm_slice_user

    # slice
    /storage/slice sugarcrm_slice read_or_create
        keys                = [sugarcrm_slice_key]

    # slice container
    /storage/container sugarcrm_container => [sugarcrm_slice] read_or_create
        slice               = sugarcrm_slice

    # store script as object in cloudstorage
    /storage/object install_sugarcrm_script_object => [sugarcrm_slice, sugarcrm_container] read_or_create
        container_name      = 'sugarcrm_container'
        file_name           = 'install_sugarcrm.sh'
        slice               =  sugarcrm_slice
        content_data        =  install_sugarcrm_sh

    # associate the cloudstorage object with the sugarcrm script
    /orchestration/script install_sugarcrm_script => [sugarcrm_slice, sugarcrm_container, install_sugarcrm_script_object] read_or_create
        data_uri            = 'cloudstorage://sugarcrm_slice/sugarcrm_container/install_sugarcrm.sh'
        script_type         = _SHELL
        encoding            = _STORAGE

    # create the recipe and associate the script
    /orchestration/recipe install_sugarcrm_recipe read_or_create
        scripts             = [install_sugarcrm_script]

    #------------------------
    # create sugarcrm server
    #------------------------
    
    /server/cloud sugarcrm_server read_or_create
        hostname            = '{{ sugarcrm_hostname }}'
        image               = '{{ sugarcrm_image_type }}'
        service_type        = '{{ sugarcrm_instance_type }}'
        keys                = [sugarcrm_server_key, sugarcrm_console_key]
        recipes             = [install_sugarcrm_recipe]

text_template install_sugarcrm_sh
#!/bin/bash
#
# install sugarcrm service
#

# check permissions
[ `whoami` = 'root' ] || {
    echo "ERROR: must have root permissions to execute the commands"
    exit 1
}

apt-get update > /dev/null
[ $? -eq 0 ] && echo "OK: update local apt cache" || {
    echo "ERROR: update local apt cache"
    exit 1
}

# install unzip
apt-get install -y unzip > /dev/null
[ $? -eq 0 ] && echo "OK: install unzip" || {
    echo "ERROR: install unzip"
    exit 1
}

# install MySQL
DEBIAN_FRONTEND=noninteractive apt-get install -y mysql-server mysql-client > /dev/null
[ $? -eq 0 ] && echo "OK: install MySQL" || {
    echo "ERROR: install MySQL"
    exit 1
}

# install Apache2
DEBIAN_FRONTEND=noninteractive apt-get install -y apache2 > /dev/null
[ $? -eq 0 ] && echo "OK: install Apache2" || {
    echo "ERROR: install Apache2"
    exit 1
}

# install PHP5
apt-get install -y php5 php5-cli libapache2-mod-php5 > /dev/null
[ $? -eq 0 ] && echo "OK: install PHP5" || {
    echo "ERROR: install PHP5"
    exit 1
}
# install required PHP5 modules
apt-get install -y php5-mysql php5-memcache php5-curl php5-gd php5-imap > /dev/null
[ $? -eq 0 ] && echo "OK: install PHP5 modules" || {
    echo "ERROR: install PHP5 modules"
    exit 1
}
# update php.ini
sed 's/^variables_order.*$/variables_order = "EGPCS"/' -i /etc/php5/apache2/php.ini
sed 's/^upload_max_filesize.*/upload_max_filesize = 10M/g' -i /etc/php5/apache2/php.ini
# enable PHP5 module
a2enmod php5 > /dev/null

# download sugarcrm source
cd /var/www/html/
wget -O sugarce.zip "http://sourceforge.net/projects/sugarcrm/files/1%20-%20SugarCRM%206.5.X/SugarCommunityEdition-6.5.X/{{ sugarcrm_version }}/download" > /dev/null 2>&1

[ $? -eq 0 ] && echo "OK: download sugarcrm source" || {
    echo "ERROR: download sugarcrm source"
    exit 1
}
# extract sugarcrm files
unzip sugarce.zip > /dev/null
[ $? -eq 0 ] && echo "OK: extract sugarcrm files" || {
    echo "ERROR: extract sugarcrm files"
    exit 1
}
# move sugarcrm files
mv ./Sugar* ./sugarcrm
[ $? -eq 0 ] && echo "OK: move sugarcrm files" || {
    echo "ERROR: move sugarcrm files"
    exit 1
}
# set ownership & permissions
chown -R www-data:www-data /var/www/html/sugarcrm
[ $? -eq 0 ] && echo "OK: set required permissions" || {
    echo "ERROR: set required permissions"
    exit 1
}

# create MySQL database & user
mysql <<EOF
create database {{ sugarcrm_db_name }};
grant all on {{ sugarcrm_db_name }}.* to {{ sugarcrm_db_username }}@localhost identified by '{{ sugarcrm_db_password }}';
EOF
[ $? -eq 0 ] && echo "OK: create sugarcrm database and user" || {
    echo "ERROR: create sugarcrm database and user"
    exit 1
}

# enable mod_rewrite
a2enmod rewrite > /dev/null 2>&1

# restart web server
service apache2 restart  > /dev/null 2>&1

echo "OK: install sugarcrm service"

_eof

text_template sugarcrm_result_template

Thank you for provisioning a SugarCRM service.

You can now finish its configuration on the following page:

http://{{ sugarcrm_server.ipaddress_public }}/sugarcrm/install.php

Please use following credentials for database configuration:

hostname: localhost
username: {{ sugarcrm_db_username }}
password: {{ sugarcrm_db_password }}
database: {{ sugarcrm_db_name }}

You can also login to the server directly via SSH by connecting to:

root@{{ sugarcrm_server.ipaddress_public }}
using the password: {{ sugarcrm_server_key.password }}

_eof