![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
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
We have talked about the Servlet extraction of worklogs: How to extract an Excel report from Tempo Timesheets using an URL We have talked also about the Tempo API REST worklog extraction using groovy: How to list your Jira Tempo Teams and members in a Confluence page Jira Groovy example script to get Tempo Teams…
Read More
Here some useful links if you want to install Jira Server on the Google Cloud infrastructure. Installation mode: Jira 7.10.2 + Databases: MySQL (for eazyBI) + PostGreSQL (for Jira) By Default in the Google Cloud Instances, we install a Debian Linux image. Use wget to obtain the latest version of Jira Server installation file/binary (POST…
Read More
To set up Atlassian Jira on Amazon EC2 we can follow this fantastic post: See here. (It’s a little bit outdated the previous link, but you can complement with the below list) MySQL useful links: How to find out the MySQL root password Download latest Jira Software binary file Installing Jira on Linux How to Check…
Read More
In this example, we want to explain how we can create a Heatmap (Worldmap) using eazyBI (in this case for Jira). As prerequisite we need a CSV with at least 3 fields: one for the ID of the row and other two fields for the longitude and geographical latitude. We need a special dimension for the…
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
A very interesting article about scaling applications on Amazon WS! Scaling is hard, period. Most of the time we are tasked with scaling a mature application that was built a few years ago. The design assumptions that were made at that time to facilitate fast feature rollout are not valid anymore and most of the…
Read MoreFirst, make a backup of the database (jiradb) and import in the same server (or in different) with name of scheme “jira7db”. With this method you can rollback the process in two minutes and continue with the JIRA 6 version if the process fails. 1. Download the binary distribution: atlassian-jira-software-7.0.3-jira-7.0.3-x64.bin 2. execute ./atlassian-jira-software-7.0.3-jira-7.0.3-x64.bin 3. OK…
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 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 MoreOur recommended books:
 |
 |
 |
 |
 |
www.MrAddon.com ®: Jira & Confluence Administration Support Blog & Ethereum Dev Blog - [www.MrAddon.blog] ® 