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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 :).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, that makes sense, and keeps the SQL simple - keep a single permission scheme which says "Browse: all users" and no other rights, and apply it to all of the projects in the "read only" version.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The problem though is that just takes care of Project data. If you've got plugins installed they might have different permissions ways. Also JIRA interacts with the database (in a write fashion) when folks are just logging in or viewing things... There are also crons etc. Just things to be aware off...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, and for JIRA to even start up, it has to have *write* access to the database. In this case, I'm not sure you care too much about it, as I assume that the aim is just to stop updates until the production server is back up (because otherwise people might update it and then complain about data loss), and when production is back, you're going to throw away the disaster recovery system and rebuild it from production again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.