If you have a test instance of FogBugz with a separate database, you may want to be certain that it won’t interfere with anything that your production instance is using.
Here is a sanitizer script that makes sure you won’t conflict with their email boxes or send emails, and it will set the correct auth type so 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.
Be careful not to run this script against your active FogBugz database, this deletes data from the database without backing it up!
-- 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 don't point to production (you'll need to supply an appropriate value) UPDATE Setting SET sValue = 'http://test-fogbugz.example.com' WHERE sKey = 'sUrlPrefixEmail';
If you are running FogBugz On Site, there may be more to do depending on how you have your test installation configured. Contact Us and we’ll be happy to make sure you’ve got everything you need!