Is there an API or DB query to set the SMTP account's password?

[Joe Fiddie]

Confluence Data Center 7.6.0- Looking for a programmatic method of updating the password for the SMTP mail server in our Confluence instance.  I have looked through the Confluence API documentation and  the setenv.sh properties but did not see anything about it.

[Edwin Kyalangalilwa]

Hi @Joe Fiddie ,

It doesn't seem possible with API. SMTP information is included in the BANDANA table.

SELECT * FROM BANDANA where BANDANAKEY='atlassian.confluence.smtp.mail.accounts';

UPDATE BANDANA SET BANDANAVALUE='<MODIFIED-XML>' WHERE BANDANAKEY='atlassian.confluence.smtp.mail.accounts';