Index: unix_installer/upgrader-package/sql-scripts/setLamsConfiguration.sql =================================================================== diff -u -r80349002d46efb898c06fc8835c074d6418be97e -r889ab1db4e6feaba27964d20cc346d448b87abc7 --- unix_installer/upgrader-package/sql-scripts/setLamsConfiguration.sql (.../setLamsConfiguration.sql) (revision 80349002d46efb898c06fc8835c074d6418be97e) +++ unix_installer/upgrader-package/sql-scripts/setLamsConfiguration.sql (.../setLamsConfiguration.sql) (revision 889ab1db4e6feaba27964d20cc346d448b87abc7) @@ -1,17 +1,21 @@ update lams_configuration set config_value='${LAMS_VERSION}' where config_key='Version'; -update lams_configuration set config_value='${SERVER_URL}' where config_key='ServerURL'; -update lams_configuration set config_value='${TEMP_DIR}' where config_key='TempDir'; -update lams_configuration set config_value='${DUMP_DIR}' where config_key='DumpDir'; -update lams_configuration set config_value='${EAR_DIR}' where config_key='EARDir'; update lams_configuration set config_value='${LAMS_SERVER_VERSION}' where config_key='AuthoringClientVersion' or config_key='MonitorClientVersion' or config_key="LearnerClientVersion" or config_key='ServerVersionNumber'; update lams_configuration set config_value='${LAMS_LANGUAGE_VERSION}' where config_key='DictionaryDateCreated'; + +-- FOR 2.1 ONLY update lams_configuration set config_value='' where config_key='SMTPServer'; -update lams_configuration set config_value='${REPOSITORY_DIR}' where config_key='ContentRepositoryPath'; -update lams_configuration set config_value='${LOCALE}' where config_key='ServerLanguage'; -update lams_configuration set config_value='${LOCALE_DIRECTION}' where config_key='ServerPageDirection'; -update lams_configuration set config_value='${WILDFIRE_DOMAIN}' where config_key='XmppDomain'; -update lams_configuration set config_value='${WILDFIRE_CONFERENCE}' where config_key='XmppConference'; -update lams_configuration set config_value='${WILDFIRE_USER}' where config_key='XmppAdmin'; -update lams_configuration set config_value='${WILDFIRE_PASS}' where config_key='XmppPassword'; -update lams_user set login='${LAMS_USER}', password=sha1('${LAMS_PASS}') where user_id=1; -update lams_user set locale_id=(select locale_id from lams_supported_locale where language_iso_code=(SELECT SUBSTRING_INDEX('${LOCALE}', '_', 1)) and country_iso_code=(SELECT SUBSTRING_INDEX('${LOCALE}', '_', -1))) where user_id=1; + +-- LI-135 Configurations should not be overwritten by updater, commenting out +--update lams_configuration set config_value='${SERVER_URL}' where config_key='ServerURL'; +--update lams_configuration set config_value='${TEMP_DIR}' where config_key='TempDir'; +--update lams_configuration set config_value='${DUMP_DIR}' where config_key='DumpDir'; +--update lams_configuration set config_value='${EAR_DIR}' where config_key='EARDir'; +--update lams_configuration set config_value='${REPOSITORY_DIR}' where config_key='ContentRepositoryPath'; +--update lams_configuration set config_value='${LOCALE}' where config_key='ServerLanguage'; +--update lams_configuration set config_value='${LOCALE_DIRECTION}' where config_key='ServerPageDirection'; +--update lams_configuration set config_value='${WILDFIRE_DOMAIN}' where config_key='XmppDomain'; +--update lams_configuration set config_value='${WILDFIRE_CONFERENCE}' where config_key='XmppConference'; +--update lams_configuration set config_value='${WILDFIRE_USER}' where config_key='XmppAdmin'; +--update lams_configuration set config_value='${WILDFIRE_PASS}' where config_key='XmppPassword'; +--update lams_user set login='${LAMS_USER}', password=sha1('${LAMS_PASS}') where user_id=1; +--update lams_user set locale_id=(select locale_id from lams_supported_locale where language_iso_code=(SELECT SUBSTRING_INDEX('${LOCALE}', '_', 1)) and country_iso_code=(SELECT SUBSTRING_INDEX('${LOCALE}', '_', -1))) where user_id=1;