How to remove the email prefix in JIRA SMTP server configuration
The content on this page relates to platforms which are not supported. Consequently, Atlassian Support cannot guarantee providing any support for it. Please be aware that this material is provided for your information only and using it is done so at your own risk.
First step is to identify the mail server ID in the database, by running the following query against JIRA's database:
select id from mailserver where server_type = 'smtp';
- Make a note of the ID returned.
Next step is to update the prefix directly in the database using the ID gathered from the first step:
update mailserver set prefix = '' where ID=<id>;
Make sure to replace the <id> in the update statement, with the ID returned from step 1.
Alwaysyour data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
- Restart JIRA.