sureshanaparti commented on code in PR #12882:
URL: https://github.com/apache/cloudstack/pull/12882#discussion_r2999836469
##########
engine/schema/src/main/resources/META-INF/db/schema-42200to42210.sql:
##########
@@ -35,3 +35,11 @@ UPDATE `cloud`.`alert` SET type = 34 WHERE name =
'ALERT.VR.PRIVATE.IFACE.MTU';
UPDATE `cloud`.`configuration` SET description = 'True if the management
server will restart the agent service via SSH into the KVM hosts after or
during maintenance operations', is_dynamic = 1 WHERE name = 'kvm.ssh.to.agent';
UPDATE `cloud`.`vm_template` SET guest_os_id = 99 WHERE name =
'kvm-default-vm-import-dummy-template';
+
+-- Update `user.password.reset.mail.template` configuration value to match new
logic
+UPDATE `cloud`.`configuration`
+SET value = 'Hello {{username}}!\nYou have requested to reset your password.
Please click the following link to reset your password:\n{{{resetLink}}}\nIf
you did not request a password reset,please ignore this email.\n\nRegards,\nThe
CloudStack Team'
+WHERE value IN (
+ 'Hello {{username}}!\nYou have requested to reset your password. Please
click the following link to reset your password:\nhttp://{{{resetLink}}}\nIf
you did not request a password reset,please ignore this email.\n\nRegards,\nThe
CloudStack Team',
+ 'Hello {{username}}!\nYou have requested to reset your password. Please
click the following link to reset your
password:\n{{{domainUrl}}}{{{resetLink}}}\nIf you did not request a password
reset,please ignore this email.\n\nRegards,\nThe CloudStack Team'
+)
Review Comment:
@erikbocks the sql doesn't work, \n is not required in the update stmt. can
you try and update the pr with the below stmt. thanks.
```
UPDATE `cloud`.`configuration`
SET value = '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 (
'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 a password reset, please ignore this email.
Regards,
The CloudStack Team',
'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'
);
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
