Delete everyones notifications?

[forums-5]

On occasion I have need to create test instances of Jira.  When I do this I want to import our production data but remove everyone’s set notifications, watches, subscriptions, etc.  I want to retain my mail server configuration for testing purposes so I need to do something in the database.  Biggest problem is that emails regarding issues that have closed in production server continue to go out from test server which confuses users.
--
Post by jshap999 - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38422
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user

[forums-5]

What I do is set all the email addresses to my own gmail account.

UPDATE PROPERTYSTRING SET PROPERTYVALUE='xxx@...'
WHERE ID IN (SELECT ID FROM PROPERTYENTRY WHERE ENTITY_NAME='OSUser'
AND PROPERTY_KEY='email')

That way I can test emails without confusing anyone else. My email client routes them all to a folder for JIRA mail testing.

Don't forget to set the baseURL first. If necessary, start JIRA with sending mail disabled so you can adjust the baseURL before it starts sending stuff out, and then restart it with sendmail enabled again.
--
Post by napplebaum - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38422
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user

[forums-5]

Hi,

Maybe you can remove everyone's email address with SQL on the database.

Regards

Patrick Li
--
Post by patrick.li - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38422
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user

[forums-5]

Just make sure these properties are set for your test instance:

-Datlassian.mail.popdisabled=true
-Datlassian.mail.senddisabled=true

Then you don't need to worry about sending mails or having jira popping mails.

cheers, jamie
--
Post by JamieEchlin - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38422
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user

[forums-5]

Jamie - the problem is that he needs/wants to TEST email functionality as well, and thus has to enable sending mail.
--
Post by napplebaum - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38422
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user

[forums-5]

Neal,

I actually hadn't thought of changing emails.  It's trickier since all of my users are in crowd/ldap.  Maybe I need to import my ldap users into my test crowd and do that trick there.
--
Post by jshap999 - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38422
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user

[forums-5]

Hi Neil,

As usual I didn't read the original question. In these cases personally I create a db from scratch, rather than copy production... otherewise there's too much noise.

cheers, jamie
--
Post by JamieEchlin - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38422
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user

[forums-5]

I don't know how Crowd works, but I would assume that in your test instance you would turn off the Crowd integration. In any case, I don't see how it's relevant, since you're just changing the email addresses in the database directly so people don't get e-mails while you're testing.
--
Post by napplebaum - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38422
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user

[forums-5]

I'm going to start with the following and see how it goes:

{code}delete from filtersubscription;{code}
{code}delete one, two  from qrtz_triggers as one, qrtz_cron_triggers as two where one.id=two.trigger_id and TRIGGER_NAME like "SUBSCRIPTION_%";{code}
{code}delete from userassociation;{code}
--
Post by jshap999 - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38422
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user