Importing a Confluence Site XML will result in the passwords for any configured SMTP servers (stored as a secret) not being imported. This will prevent the UI from displaying the mail server list.

XMLWordPrintable

    • Type: Bug
    • Resolution: Not a bug
    • Priority: Low
    • None
    • Affects Version/s: 9.4.0, 9.2.3
    • Component/s: Site - Backup / Import
    • None
    • 1
    • Severity 3 - Minor

      Issue Summary

      Site Backup XML doesn't include the secret for the mail server password

      Steps to Reproduce

      1. Install Confluence 9.4.0
      2. Set up a mail server with a password
      3. Generate an Site Backup XML
      4. Install a new Confluence 9.4.0
      5. Restore the Site Backup XML to the newly created instance

      Expected Results

      Mail server password secret is included and UI renders

      Actual Results

      Mail server password secret is not included and UI doesn't render

      Error in logs during Site XML restore
      2025-05-06 08:37:54,551 ERROR [Caesium-1-4] [atlassian.core.task.AbstractErrorQueuedTaskQueue] handleException Failed to execute task
 -- url: /confluence/setup/finishsetup.action | userName: anonymous | action: finishsetup | referer: https://linux-99749.prod.atl-cd.net/confluence/setup/setupadministrator-start.action | traceId: 1a3a050cd586cd81
java.lang.IllegalStateException: Failed to fetch password for mail server [SMTP Server]. Expected secret [mail.server.password.1746519008473] not found.
	at com.atlassian.confluence.mail.ConfluenceMailServerManager.getPassword(ConfluenceMailServerManager.java:265)
	at java.base/java.util.LinkedHashMap$LinkedValues.forEach(LinkedHashMap.java:833)
	at com.atlassian.confluence.mail.ConfluenceMailServerManager.getMailServers(ConfluenceMailServerManager.java:221)
	at com.atlassian.confluence.mail.ConfluenceMailServerManager.getMailServers(ConfluenceMailServerManager.java:228)
	at com.atlassian.confluence.mail.ConfluenceMailServerManager.getSmtpMailServers(ConfluenceMailServerManager.java:92)
	at com.atlassian.confluence.mail.ConfluenceMailServerManager.getDefaultSMTPMailServer(ConfluenceMailServerManager.java:109)

      Workaround

      1. Stop Confluence
      2. Run the SQL query below:
        • Postgres, MySQL, Oracle
          update BANDANA 
set BANDANAVALUE = replace(BANDANAVALUE, '<password>{ATL_SECURED}</password>', '<password>actual_password</password>') 
where BANDANAKEY = 'atlassian.confluence.smtp.mail.accounts';
        • MSSQL
          update BANDANA set BANDANAVALUE = replace(cast(BANDANAVALUE as nvarchar(max)), '<password>{ATL_SECURED}</password>', '<password>actual_password</password>') where BANDANAKEY = 'atlassian.confluence.smtp.mail.accounts';
      3. Start Confluence
      4. Head to <confluence-base-url>/admin/force-upgrade.action
      5. Select secureMailServerSecretUpgradeTask and click Force upgrade

        1. Screenshot 2025-05-06 at 16.20.55.png
          Screenshot 2025-05-06 at 16.20.55.png
          212 kB

            Assignee:
            Unassigned
            Reporter:
            Puventhira Mannen Pragasam Selladurai
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: