Page Comparison

...

• Create a directory for the local SSP configuration files
  
  • Example:
    
    • Unix/Linux/Mac example: /usr/local/ssp

    • Windows example: C:\ssp\ssp-local

  • Make the directory only readable by the user that is running Tomcat

  • Set an Environment Variable for the local configuration file location

    Tip
    SSP_CONFIGDIR=/path/to/your/local-configuration (ie: /usr/local/ssp/ssp-local or C:\ssp\ssp-local)

• ssp-config.properties
  
  • The ssp-config.properties file must be modifed for database connectivity and email settings
  • File Location: github

  • Action: create the  ssp-config.properties file in the local configuration directory (ie: C:\ssp\ssp-local)

    • Configuration Values:

      Value	Description	Note
      system_id	Unique identifier of the SSP instance
      db_url	jdbc connection syntax	For Microsoft SQL Server, either specify a port (the default is 1433) or ensure that the SQL Server Browser service is running because the SQL Server JDBC driver defaults to port 1434 which is the SQL Server Server Browser service default port. Depending on the server configuration, either may work, or you may want to explicitly specify the port and instance name, if applicable.
      db_driver_class	jdbc database connectivity syntax
      db_dialect	Hibernate dialect	Use of one of the org.jasig.ssp.util.hibernate.ExtendedSQLServer*Dialects is strongly encouraged if running against SQLSever. The default ssp-config.properties has an example.)
      db_username	Values for connecting to the SSP database
      db_password	Values for connecting to the SSP database
      db_admin_username	Values for connecting to the SSP database
      db_admin_password	Values for connecting to the SSP database
      db_name	Value for the SSP database
      db_conns_max_active	Values for the database connection pool	The default value will need to be increased for test and product
      db_conns_max_idle	Values for the database connection pool	The default value will need to be increased for test and product
      db_conns_max_wait	Values for the database connection pool
      db_conns_validation_query	Values for the database connection pool
      db_liquibase_enabled	Enables the liquibase script for database table management
      db_liquibase_changelog	Location for the liquibase change log
      db_liquibase_set_mssql_snapshot_isolation	Parameter for configuring a MSSQL database	IMPORTANT The default value is 'true'.  Set this value to 'false for MSSQL.  The liquibase changeset 000014.xml will be ignored.  The sql above configures the database correctly.
      db_liquibase_strip_journal_comment_markup	Parameter to enable a script to convert HTML Journal Entries to plain text
      smtp_username	Value for email relay
      smtp_password	Value for email relay
      smtp_host	Value for email relay
      smtp_port	Value for email relay
      ssp_admins_email_addresses	Recipient of system generated messages
      scheduled_coach_sync_enabled	Parameter to enable coach sync process
      per_coach_sync_transactions	Parameter to enable the sync process to run per coach instead of one large transaction for all coaches
      uportal_session_keep_alive_timeout	Length of time for uPortal sessions KeepAliveFilter
      spring.profiles.active	Deployment options	dev-standalone: completely free of uPortal standalone: as the only portlet in a uPortal instance uPortal: as one of many portlets in a uPortal instance

...