Hi,
Is there any way to make JIRA read-only from database(mysql) end.
Know how to do it by changing permission scheme from JIRA administration. But, looking for a way to achieve this through database side.
Thanks...
Ram
Not really. The way you'd do it is actually to just take the changes you've made in the UI, work out how they are held in the database and change it via SQL (while JIRA is offline). It's quicker to do it in the UI mostly.
Thanks for the response Nic. Can we achieve it through cron jobs.? i.e. without manual effort.!!!
You'll need a cron that can stop JIRA, run some SQL against your database, and then restart JIRA. And you will need to be very careful with the SQL - it will need to read the current settings and store them somewhere so it can put them back when it's done (remember that your admins can easily change the permissions in th UI and you need to preserve what they're doing) This makes me question what you're trying to do. If you genuinely need to lock JIRA out for a while for a good reason, then it's probably going to be far more simple to just stop it.
My scenario is like we have two JIRA instances. One(JIRA1) go live and one(JIRA2) backing the Live instance. If our Live instance(JIRA1) down for some reason we would like to point to backup JIRA(JIRA2) which should be in read only mode with all the latest data of Live(JIRA1). Where users can only view all issues until LiveJIRA (JIRA1) is up. Hope this briefs my concern .
It looks like you're new here. Sign in or register to get started.
