This is an automated email from the ASF dual-hosted git repository.

sureshanaparti pushed a commit to branch 4.22
in repository https://gitbox.apache.org/repos/asf/cloudstack.git


The following commit(s) were added to refs/heads/4.22 by this push:
     new 5013cf2af64 Fix user password reset mail template value  (#12882)
5013cf2af64 is described below

commit 5013cf2af649968abb34b76ebf8059fc0b196447
Author: Erik Böck <[email protected]>
AuthorDate: Wed Apr 15 01:36:39 2026 -0300

    Fix user password reset mail template value  (#12882)
    
    * Fix default user password reset email template
    
    * improve readabilty
    
    * change update query
    
    * Specify database for update
    
    * Fix SQL statement
    
    * Use CONCAT_WS sql method to create multiline string
    
    ---------
    
    Co-authored-by: GaOrtiga <[email protected]>
    Co-authored-by: Suresh Kumar Anaparti <[email protected]>
---
 .../schema/src/main/resources/META-INF/db/schema-42200to42210.sql  | 7 +++++++
 1 file changed, 7 insertions(+)

diff --git 
a/engine/schema/src/main/resources/META-INF/db/schema-42200to42210.sql 
b/engine/schema/src/main/resources/META-INF/db/schema-42200to42210.sql
index 43e0d2c78a9..0300e555463 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-42200to42210.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-42200to42210.sql
@@ -53,3 +53,10 @@ DELETE FROM `cloud`.`configuration` WHERE name = 
'consoleproxy.cmd.port';
 
 -- Drops the unused "backup_interval_type" column of the "cloud.backups" table
 ALTER TABLE `cloud`.`backups` DROP COLUMN `backup_interval_type`;
+
+-- Update `user.password.reset.mail.template` configuration value to match new 
logic
+UPDATE `cloud`.`configuration`
+SET value = CONCAT_WS('\n', 'Hello {{username}}!', 'You have requested to 
reset your password. Please click the following link to reset your password:', 
'{{{resetLink}}}', 'If you did not request a password reset, please ignore this 
email.', '', 'Regards,', 'The CloudStack Team')
+WHERE name = 'user.password.reset.mail.template'
+  AND value IN (CONCAT_WS('\n', 'Hello {{username}}!', 'You have requested to 
reset your password. Please click the following link to reset your password:', 
'http://{{{resetLink}}}', 'If you did not request a password reset, please 
ignore this email.', '', 'Regards,', 'The CloudStack Team'), CONCAT_WS('\n', 
'Hello {{username}}!', 'You have requested to reset your password. Please click 
the following link to reset your password:', '{{{domainUrl}}}{{{resetLink}}}', 
'If you did not request  [...]
+

Reply via email to