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';