If you have a test instance of FogBugz with a separate database, you may want to be certain that it will not interfere with anything that your production instance is using. The sanitizing script covered in this article ensures your primary database remains safe and unaffected.
This article is useful for the Level 2 agents and administrators who are experienced with scripting and databases.
- Use the sanitizer script to ensure no conflicts occur with the mailboxes.
- It sets the correct
AuthTypeso you can get into your test instance without a password.
- This is useful if you want to periodically refresh the data in your test instance with the latest backup from your production instance.
- It sets the correct
- If you are running FogBugz On-Site, there may be more to do depending on how your test installation is configured.
Contact us, and we will be happy to make sure you have got everything you need!
Please note the following side-effects of the configurations mentioned below:
DELETE FROM MailQueue: Removes all the pending mails in the queue so the system does not show an error message in the notification area.
UPDATE Mailbox SET fDeleted = 1: Deletes any mailbox configuration from the system to prevent the server to attempt retrieving live email cases.
UPDATE Setting SET sValue = 'NONE' WHERE sKey= 'sSMTPServer': Disables the send mail functionality. This further has the following side-effects:
- The system stops sending e-mail notifications.
- Disables the Subscription option on cases.
- Disables the Forgot password function (user will be redirected to the homepage).
-- Remove pending outgoing mail DELETE FROM MailQueue; -- Turn off outgoing emails to FogBugz Users UPDATE Person SET fNotify = 0, fEscalationReport = 0; -- Disable Mailboxes so you don't pull emails into test UPDATE Mailbox SET fDeleted = 1; -- Unsubscribe all users DELETE FROM Subscriptions; -- Don't ever send email UPDATE Setting SET sValue = 'NONE' WHERE sKey= 'sSMTPServer'; -- Use Passwords instead of e.g., LDAP UPDATE Setting SET sValue = '1' WHERE sKey= 'fPasswordEnable'; UPDATE Setting SET sValue = '0' WHERE sKey= 'iAuthType'; -- Update the base URL so internal links and redirects do not point to production (you will need to supply an appropriate value) UPDATE Setting SET sValue = 'http://test-fogbugz.example.com' WHERE sKey = 'sUrlPrefixEmail';