How to make massive changes in JIRA JQL filters

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 … Continue reading How to make massive changes in JIRA JQL filters

Advertisements

Scaling your application on AWS & know the prices

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 … Continue reading Scaling your application on AWS & know the prices

INSTRUCTIONS TO MIGRATE FROM JIRA6 (WAR DISTRIBUTION, NOW OBSOLETE) TO JIRA7 NEW BINARY DISTRIBUTION

First, 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 … Continue reading INSTRUCTIONS TO MIGRATE FROM JIRA6 (WAR DISTRIBUTION, NOW OBSOLETE) TO JIRA7 NEW BINARY DISTRIBUTION

NewRelic: The best Monitoring tool for JIRA

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, … Continue reading NewRelic: The best Monitoring tool for JIRA

How to change the creator of a page in Confluence 5.2 or above

For 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 … Continue reading How to change the creator of a page in Confluence 5.2 or above

Database Custom Fields with Kepler Plugin. Show a list of issues of one JIRA project in a Custom Field

1.- Install the plugin: https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.keplercf 2.- Create a Custom Field of the new Type "Database Custom Field" 3.- Go to your apache-tomcat/conf/context.xml and add the Datasource (first you need to install the Database JAR Driver if it's different database Oracle, MySQL,... for example in apache-tomcat/lib/mysql-connector-java-5.1.17.jar 4.- Restart Tomcat 5.- Go as Admin to --> JIRA --> Add-ons … Continue reading Database Custom Fields with Kepler Plugin. Show a list of issues of one JIRA project in a Custom Field

What Atlassian application administrators need to know about the “leap second” bug lurking in your systems

ORIGINAL NOTE Introduction A leap second is a one-second adjustment that is occasionally applied to UTC (Coordinated Universal Time) in order to keep its time of day close to the mean solar time. The most recent leap second insertion happened on June 30, 2012 at 23:59:60 and caused disruptions in computing systems all around the … Continue reading What Atlassian application administrators need to know about the “leap second” bug lurking in your systems

How to install JIRA / Confluence on local server

Download and install JIRA from: https://es.atlassian.com/software/jira/download Download and install MySQL Server from: https://dev.mysql.com/downloads/file.php?id=456518 Create the Database: https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+MySQL Install MySQL Connector in Tomcat: Download from: http://dev.mysql.com/downloads/connector/j Copy the file mysql.jar in the {TOMCAT_PATH}/lib Incredible but is true... then we need install another time JIRA! That's it!