Index: win_installer/installer/templates/update_lams_configuration.sql =================================================================== diff -u -r388ec3500ab44f8bbd700dee150266ddf40ca53e -rd6f5035a737c68aebdb0f27324a6af99f9326346 --- win_installer/installer/templates/update_lams_configuration.sql (.../update_lams_configuration.sql) (revision 388ec3500ab44f8bbd700dee150266ddf40ca53e) +++ win_installer/installer/templates/update_lams_configuration.sql (.../update_lams_configuration.sql) (revision d6f5035a737c68aebdb0f27324a6af99f9326346) @@ -10,13 +10,13 @@ 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 password=sha1('@LAMS_PASS@') where login='test1'; +update lams_user set password=sha1('@LAMS_PASS@') where login='test2'; +update lams_user set password=sha1('@LAMS_PASS@') where login='test3'; +update lams_user set password=sha1('@LAMS_PASS@') where login='test4'; 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'; 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='test3'; 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='test4'; -update lams_user set password=sha1('@LAMS_PASS@') where login='test1'; -update lams_user set password=sha1('@LAMS_PASS@') where login='test2'; -update lams_user set password=sha1('@LAMS_PASS@') where login='test3'; -update lams_user set password=sha1('@LAMS_PASS@') where login='test4'; \ No newline at end of file