How to stop Mail fetching before starting the application services ?

How to stop Mail fetching before starting the application services ?

Use case: When you restore the data in your test environment or trying to migrate to a new server, once the restore is done, the application if started will have emails being fetched in the new server/Test server which you would not wish to. Hence this will help you to stop mail fetching and mail sending in the application before starting the application. So that you can start the product and do your testing or check the data without any confusion.


1. Connect to the database:

PGSQL:

Navigate to the bin folder [ServiceDesk Plus – MSP Home] \ bin in the command prompt and execute the startDB.bat 65432


Now navigate go to [ServiceDesk Plus – MSP Home] \ pgsql \ bin and execute psql.exe -U postgres -p 65432 -d servicedesk


Now you should be connected to the database.

MSSQL:

For MSSQL, connect to the SQL studio.


2. Execute the below queries one after the other:


update outgoingmailserver set HOSTNAME =’ALPHA’;

update outgoingmailserver set ALTERNATEHOSTNAME=’BETA’;

update incomingmailserver set HOSTNAME =’XYZ’;

update TASK_INPUT set OPERATIONAL_STATUS=’4′;



3. Now start the application services and check.

          • Related Articles

          • How to stop Mail fetching before starting the application services in UAT ?

            1. When the application services are stopped, navigate to the bin folder [ServiceDesk Plus – MSP Home] \ bin in the command prompt and execute the startDB.bat 65432 2. Now navigate go to [ServiceDesk Plus – MSP Home] \ pgsql \ bin and ...
          • Start/Stop Mail fetching is not working for the foreign languages

            Issue is happening for builds 10504 and above. Navigate to ManageEngine/ServiceDeskPlus-MSP/webapps/ROOT/WEB-INF/security and take a backup of the file security-generalaccess.xml and place it on the desktop (Please do not place the backup file on the ...
          • Monitor Mail Fetching schedule

             We have a workaround for checking the status of mail fetching (start or stopped). However, we do not have an option to start or stop fetching remotely.  We can integrate "Applications Manager" with SDP MSP and we can do regular monitoring (as per ...
          • Mail Fetching Stops Automatically after 9410 upgrade

            Issue found after upgrading to 9410. On detailed analysis, we found this to be recreated at our end and is assigned with an Issue ID : 12535.  Traces in the Logs : ...
          • Mail fetching_ Command is not valid in this state

            Cause: Unable to fetch email when encrypted mode is enabled on POP in the mail server. Error trace in logs: javax.mail.AuthenticationFailedException: Command is not valid in this state. Solution: Reset the password format on the exchange server to ...