![www.MrAddon.com ®: Jira & Confluence Administration Support Blog & Ethereum Dev Blog – [www.MrAddon.blog] ®](https://jirasupport.files.wordpress.com/2022/09/cropped-logo-mr-addon-vertical-1.png){kind=logo}
jira confluence admin administration support script scriptrunner groovy mraddon barcelona plugin custom development it technology barcelonatech ethereum development
We are proud to announce the acquisition of Acid Oranges powerful Jira Applications by SeviDev Team! Who deleted my issuesPowerful logging and tracking tool for deleted issues Pin Your CommentsNever lose sight of important comments DnD Workflow ToolsOrder post-functions easily and intuitively DataBase ExplorerExplore the Jira database ¡Available on the Atlassian Marketplace!
Read More
To connect Jira & Confluence using SSL with MySQL we need to download the MySQL certificates. Once downloaded (mysql-server-cert.pem, client-cert.pem and client-key.pem), we need to convert to a keystore format to be imported in Java when the services are started. How to convert the MySQL certificates and store it in Jira & Confluence? Using “Keytool”…
Read More
Here a list of useful commands to do installations of Atlassian tools in MySQL Example for CentOS with yum ( install of MySQL client) At the command line of your instance, install wget: sudo yum -y install wget Install the MySQL client on the instance: sudo yum -y install mysql Download MySQL Connector/J Jira connects to…
Read More
In this exercise, we want to show a custom field with database values in our Jira Server with Scriptrunner installed. First of all, we need to go to “Resources” section And create a Database connector, in this exercise will be a connector to the jiradb itself (then is a Local database connection). Here an example…
Read More
In large companies, there are usually a large number of projects of which, most of them are currently inoperative. Therefore, from MrAddon we advise you to execute this query every year and list all those projects that since a certain date have not updated their tickets. The list includes the name and the key of…
Read More
In this post we will examine some information, stored in database, we can change directly from database. The scenario is clear: Your Atlassian instance (Confluence or Jira Server) don’t start and you have to modify information on database. Let me share this part of direct experience 😛 We can modify…. …. those information: Base URL,…
Read More
Imagine a way to create a Database over Ethereum using Smart-Contracts. Imagine a mix with Ethereum Blockchain and NoSQL Apache Cassandra technologies. Imagine searching using CQL over your Database over Ethereum. That’s Ties.DB!! We can make a try in this web. (You must use MetaMask in your Browser connected to Rinkeby Ethereum test-network and some Ether…
Read More
Imagine you want to change the name or the classification of the project “categories” in your JIRA projects… or names of customfields…. Then, a lot of JQL queries and filters will fail… ¿How we can change the JQL sentences in mode massive of all filters of JIRA? The only solution is making the change in…
Read MoreYou have two options: Change it using CSV Import (more info) Change it using a database Update (more info, depends on the version of JIRA)
Read More
Good morning my proletarian psychic workers! 🙂 These days I was working analyzing the transactions of my JIRA to get better performance and to solve different problems. Due this, the first thing to do is to find the best tool to analyze all the http/s requests and querys to the database also the external services,…
Read More
To see one category status color more, you need only: Go to the JIRADB Database Execute SQL: SELECT * FROM jiradb.issuestatus; In the status you need “black color” set the field “STATUSCATEGORY” to 1 That’s all! Supported colors (in the standard) Field Summary Fields Modifier and Type Field and Description static String COMPLETE static String IN_PROGRESS…
Read MoreFor Confluence 5.2 and above To change the creator of a specific page Run this SQL query against your database, replacing these values: <lowerusername> with the username of the new creator in lower case ‘the title of the page’ with the page title (case sensitive) <thespacekey> with the spacekey in uppercase update content set creator…
Read More
Our recommended books:
 |
 |
 |
 |
 |
www.MrAddon.com ®: Jira & Confluence Administration Support Blog & Ethereum Dev Blog - [www.MrAddon.blog] ® 