We want to copy our production DB over to our test environment. However, when the environment comes up ACM starts sending old request email notifications out. We would like to turn off the email notifications before we bring up ACM. Does anyone know of the table and column we could run a script against to turn this off?
Thanks!
Here is what you're looking for:
/* Disable e-mail, intentionally break inbound/outbound email connections
UPDATE AVUSER.T_SYSTEM_SETTINGS SET VALUE = 'true' WHERE PARAMETER = 'email.disableEmail';
UPDATE AVUSER.T_SYSTEM_SETTINGS SET VALUE = 'smtp://FAKESERVER:25555' WHERE PARAMETER = 'email.general.outboundServer.url';
UPDATE AVUSER.T_SYSTEM_SETTINGS SET VALUE = 'pop3s://FAKESERVER:99555' WHERE PARAMETER = 'email.activity.inboundServer.url';