Index: unix_installer/upgrader-package/sql-scripts/setLamsConfiguration.sql =================================================================== diff -u -r0965ee8a6bd49be2d53cad08225f707b32a61674 -rf60c84aa77fa16705afc4d6dff7261f404727e8f --- unix_installer/upgrader-package/sql-scripts/setLamsConfiguration.sql (.../setLamsConfiguration.sql) (revision 0965ee8a6bd49be2d53cad08225f707b32a61674) +++ unix_installer/upgrader-package/sql-scripts/setLamsConfiguration.sql (.../setLamsConfiguration.sql) (revision f60c84aa77fa16705afc4d6dff7261f404727e8f) @@ -13,5 +13,5 @@ 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 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; Index: win_installer/templates/update_lams_configuration.sql =================================================================== diff -u -red736ed1dfbfd5a2a089f7a41e1242f2dcaa94dc -rf60c84aa77fa16705afc4d6dff7261f404727e8f --- win_installer/templates/update_lams_configuration.sql (.../update_lams_configuration.sql) (revision ed736ed1dfbfd5a2a089f7a41e1242f2dcaa94dc) +++ win_installer/templates/update_lams_configuration.sql (.../update_lams_configuration.sql) (revision f60c84aa77fa16705afc4d6dff7261f404727e8f) @@ -10,7 +10,7 @@ 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 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; 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 login='test1'; 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 login='test2';