Silent Installer Settings

Overview

The Sugar silent installer facilitates and automates the installation of the Sugar application after the files have been copied onto the server. This is done by populating correct parameters in a configuration file and then making a web request to kick off the installation.

config_si.php

The ./config_si.php file is located at the root level of the Sugar application. It contains an array of name-value pairs consisting of the relevant parameters for installation of the app. The array name is $sugar_config_si. An example file looks like:

  <?php

$sugar_config_si = array (
    'setup_site_url' => 'http://${domainname}:${webport}/sugar',
    'setup_system_name' => '${systemname}',    
    'setup_db_host_name' => 'localhost',
    'setup_site_admin_user_name' => 'admin',
    'setup_site_admin_password' => '${sugarpassword}',
    'demoData' => true, 
    'setup_db_type' => 'mysql',
    'setup_db_host_name' => '{db_host_name}',
    'setup_db_port_num' => 'db_port_number',
    'setup_db_database_name' => 'sugar',
    'setup_db_admin_user_name' => 'root',
    'setup_db_admin_password' => '${rootpassword}',
    'setup_db_options' => array(
    	'ssl' => true,
    ),
    'setup_db_drop_tables' => false,
    'setup_db_create_database' => true,
    'setup_license_key' => '${slkey}',
    'setup_license_key_users' => '${slkeyusers}',
    'setup_license_key_expire_date' => '${slkeyexpiredate}',
    'setup_license_key_oc_licences' => '${slkey_oc_licenses}',
    'default_currency_iso4217' => 'USD',
    'default_currency_name' => 'US Dollars',
    'default_currency_significant_digits' => '2',
    'default_currency_symbol' => '$',
    'default_date_format' => 'Y-m-d',
    'default_time_format' => 'H:i',
    'default_decimal_seperator' => '.',
    'default_export_charset' => 'ISO-8859-1',
    'default_language' => 'en_us',
    'default_locale_name_format' => 's f l',
    'default_number_grouping_seperator' => ',',
    'export_delimiter' => ',',
);

Essential Settings

The following are settings that must be set:

General System Settings

setup_system_name

setup_site_url

setup_site_admin_user_name

setup_site_admin_password

demoData

Database Settings

setup_db_type

setup_db_host_instance

setup_db_host_name

setup_db_port_num

setup_db_database_name

setup_db_admin_user_name

setup_db_admin_password

Recommended Database Settings

The following are not necessarily required, but it is recommended that at least one is set:

setup_db_create_database

setup_db_drop_tables

Extended Database Settings

There is also an option for an additional array of db config settings. These array entries are equivalent to the Core Settings options prefixed with dbconfigoption. For example dbconfigoption.collation and dbconfigoption.ssl

setup_db_options

Full-Text Search (ElasticSearch) Settings

setup_fts_type

setup_fts_host

setup_fts_port

Advanced Full-Text Search Configuration Settings

While not required, the Silent Installer offers a few FTS settings not available in the browser-based installation process. These settings are considered more advanced and should not be implemented casually. Further details on advanced ElasticSearch configuration can be found in the ElasticSearch installation guide in the section Advanced Configuration.

setup_fts_curl

'setup_fts_curl' => array(
	CURLOPT_SSL_VERIFYPEER = false,
),

License Settings

While not required during installation, the license settings are required for Sugar to be usable by all users. Setting the license settings during the Silent Install will save the need to enter this required data after the install.

setup_license_key

setup_license_key_users

setup_license_key_expire_date

setup_site_sugarbeet_automatic_checks

Additionally, Offline Client license settings can be set in Silent Installer

setup_license_key_oc_licences

setup_num_lic_oc

Making the Web Request

After the ./config_si.php file is in place, the following web request can be made to kick off the installation:

http://${hostname}/sugar/install.php?goto=SilentInstall&cli=true

where ${hostname} is the name of the host. Upon completion of the process, the installation should respond with Success, and you may navigate to the web address to find an installed version of Sugar.

Configuring a Sugar-Specific Database User during Install

By default, Sugar will use the database user set for the install process as the database user for general use after installation. There are three different Silent Install options for having Sugar use a different database user once installed. Which option the installer users is determined by the dbUSRData config setting.

The dbUSRData silent install config setting has four valid options:

same

This is the default setting used, even when dbUSRData is not explicitly set. The DB user provided for installing Sugar is used for running Sugar after installation.

auto

Sugar will create a new database user using a self-generated username and password.

In your $sugar_config_si array, the options for this to work as expected are:

  'dbUSRData' => 'auto',
'setup_db_create_sugarsales_user' => true,

provide

Sugar will use the provided database username and password after installation, and the installer assumes that the database user has already been created on the database and that the provided password is valid. Essentially this is informing Sugar to use a different existing DB user after the installation has completed.

In your $sugar_config_si array, the options for this to work as expected are:

  'dbUSRData' => 'provide',
'setup_db_create_sugarsales_user' => false,
'setup_db_sugarsales_user' => '{existing_db_user_name}',
'setup_db_sugarsales_password' => '{existing_db_user_password}',
'setup_db_sugarsales_password_retype' => '{existing_db_user_password}',

create

Sugar will create a new database user using the provided database username and password after installation. This is similar to 'provide', except that Sugar assumes that it will be creating the database user during installation.

In your $sugar_config_si array, the options for this to work as expected are:

  'dbUSRData' => 'create',
'setup_db_create_sugarsales_user' => true,
'setup_db_sugarsales_user' => '{new_db_user_name}',
'setup_db_sugarsales_password' => '{new_db_user_password}',
'setup_db_sugarsales_password_retype' => '{new_db_user_password}',

Note: For create, the installer will create a user with access only to the database created for this Sugar instance. It will also have limited access for which host it can connect from, versus the admin user, which usually has access from any host.

Sugar will set the user to have access to localhost and the provided hostname derived from setup_site_url. If there are issues connecting to the database during or after installation, check that the user was created correctly in the database and that the user can connect from the host that the instance is on.

Other Silent Install Config Options

Many of these options match an equivalent Sugar Config option, with further descriptions available at Core Settings.

cache_dir

Locale Settings

The following options are locale settings. With one exception, these can be set or updated through Administration > Locale. 

export_delimiter

default_export_charset

default_currency_iso4217

default_currency_name

default_currency_significant_digits

default_currency_symbol

default_language

default_date_format

default_time_format

default_decimal_seperator

default_number_grouping_seperator

default_locale_name_format