How To Set the SMTP Timeout in Confluence
目的
For some environments, it may be necessary to update the SMTP Timeout in Confluence. This can be done through SQL query.
There is a feature request to add this functionality to the UI, which can be found here: - CONF-34844Getting issue details... STATUS
ソリューション
Confluence を停止します。
Back up your Confluence database
Run the following query on the database:
SELECT * FROM BANDANA WHERE BANDANAKEY = 'atlassian.confluence.smtp.mail.accounts';
Find the following in the BANDANAVALUE:
<property name="mail.smtp.timeout" value="10000"/>
および
<property name="mail.smtp.connectiontimeout" value="10000"/>
Use SQL's REPLACE function to increase the values
EXAMPLE:UPDATE BANDANA SET BANDANAVALUE = replace(BANDANAVALUE,'<property name="mail.smtp.connectiontimeout" value="10000"/>','<property name="mail.smtp.connectiontimeout" value="20000"/>') WHERE BANDANAVALUE LIKE '%mail.smtp.connectiontimeout%'; UPDATE BANDANA SET BANDANAVALUE = replace(BANDANAVALUE,'<property name="mail.smtp.timeout" value="10000"/>','<property name="mail.smtp.timeout" value="20000"/>') WHERE BANDANAVALUE LIKE '%mail.smtp.timeout%';
For MS SQL the update statements are:
UPDATE BANDANA SET BANDANAVALUE = CAST(REPLACE(CAST(BANDANAVALUE as nvarchar(max)),'<property name="mail.smtp.timeout" value="10000"/>','<property name="mail.smtp.timeout" value="20000"/>') as ntext) WHERE BANDANAVALUE LIKE '%mail.smtp.connectiontimeout%'; UPDATE BANDANA SET BANDANAVALUE = CAST(REPLACE(CAST(BANDANAVALUE as nvarchar(max)),'<property name="mail.smtp.connectiontimeout" value="10000"/>','<property name="mail.smtp.connectiontimeout" value="20000"/>') as ntext) WHERE BANDANAVALUE LIKE '%mail.smtp.timeout%';
Also note: If email settings are updated, the settings will revert to the default. You will need to reproduce these steps after the change has been made.
- Confluence を再起動します。