Atlassian/Jira

From Omnia
Jump to navigation Jump to search

Jira

Bug, Issue and Project Tracking for Software Development - JIRA - http://www.atlassian.com/software/jira/

Markup

Text Effects:

*strong*	(bold)
_emphasis_	(italic)
??citation??	(italic)
-deleted-	(crossed out)
+inserted+	(underlined)
^superscript^	(superscript)
~subscript~	(subscript)
{{monospaced}}	(courier)
bq. block quoted	(quoted)
{quote}quote{quote}	(quoted)
{color:red}color{color}	(color)

Headings:

h1. Biggest heading
h6. Smallest heading

Text Breaks:

(empty line)	(new paragraph)

\\		(force line break)

----		(horizontal line)

---		(-- symbol)
--		(- symbol)

Links:

[#anchor]
[^attachment.ext]

[http://jira.atlassian.com]
[Atlassian|http://atlassian.com]

[mailto:legendaryservice@atlassian.com]

[file:///c:/temp/foo.txt]
[file:///z:/file/on/network/share.txt]

{anchor:anchorname}

[~username] 

Lists:

* some
** indented

- different bullet

# numbered list

#* nested
*# nested

Images:

!http://www.host.com/image.gif!
!attached-image.gif! 
!image.jpg|thumbnail!
!image.gif|align=right, vspace=4!

Attachments:

!quicktime.mov!
!spaceKey:pageTitle^attachment.mov! 
!quicktime.mov|width=300,height=400! 
!media.wmv|id=media! 

Tables:

||heading 1||heading 2||heading 3||
|col A1|col A2|col A3|
|col B1|col B2|col B3| 

Advanced Formatting:

{noformat}
non formatted text
{noformat}

{panel}Some text{panel}

{panel:title=My Title}Some text with a title{panel}

{panel:title=My Title| borderStyle=dashed| borderColor=#ccc| titleBGColor=#F7D6C1| bgColor=#FFFFCE}
a block of text surrounded with a *panel*
yet _another_ line
{panel}

{code:title=Bar.java|borderStyle=solid}
// Some comments here
public String getFoo()
{
    return foo;
}
{code}

{code:xml}
<test>
  <another tag="attribute"/>
</test>
{code} 

Misc:

\X  (special character)
:), :(   (smilies)

Source: https://jira.int.fusionio.com/secure/WikiRendererHelpAction.jspa?section=all

Standalone Installation

Download:

Documentation:

Download and install Java:

# http://java.sun.com 
wget http://download.oracle.com/otn-pub/java/jdk/6u26-b03/jre-6u26-linux-i586-rpm.bin -O jre-6u26-linux-i586-rpm.bin
sh jre-6u26-linux-i586-rpm.bin
# /usr/java/jre1.6.0_26/

Download and install Jira:

# Jira Download - http://www.atlassian.com/software/jira/JIRADownloadCenter.jspa
cd /opt
wget http://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-4.3.4.tar.gz
tar -zxvf atlassian-jira-4.3.4.tar.gz
ln -s atlassian-jira-4.3.4-standalone/ jira

Make Home:

mkdir /opt/jira-data

Set home property: - /opt/jira/atlassian-jira/WEB-INF/classes/jira-application.properties

jira.home=/opt/jira-home

Start server:

cd /opt/jira/bin
./start-jira.sh

Stop server:

cd /opt/jira/bin
./stop-jira.sh

Configuration

Change Port

To change the port to 80. Jira will have to be run as root. Another option is port forwarding.

/opt/jira/conf/server.xml:
<Server port="8005" shutdown="SHUTDOWN">
 <Connector port="8080"
# change to:
 <Connector port="80"

Note: you may also want to change the shutdown port if you are running multiple tomcat instances on this server:

MySQL

Configure MySQL:

set GLOBAL storage_engine='InnoDb';
create database jira character set utf8;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on
   jira.* TO 'jira'@'localhost' IDENTIFIED BY 'jira';
flush privileges;

Test MySQL:

mysql --user=jira --password=jira --database=jira

conf/server.xml

         <Context path="" docBase="${catalina.home}/atlassian-jira" reloadable="false">
           <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
             username="jira"
             password="jira"
             driverClassName="com.mysql.jdbc.Driver"
             url="jdbc:mysql://localhost/jira?useUnicode=true&characterEncoding=UTF8"
             maxActive="20"
             validationQuery="select 1" />

atlassian-jira/WEB-INF/classes/entityengine.xml

<datasource name="defaultDS" field-type-name="mysql"
# remove: schema-name="PUBLIC"

References:

Issues:

set GLOBAL storage_engine='InnoDb';

Initial App Configuration

To configure:

http://jira:8080/

Answer questions about:

  • Application Title: [Your Company JIRA]
  • Mode: [Public]
    • Private - Only administrators can create new users
  • Base URL: [1]
  • Automated Backups: [Use Default Directory] (/opt/jira/export)
  • File Attachments: [Use Default Directory] (/opt/jira/data/attachments)
  • Indexes: /opt/jira/caches/indexes (not changeable here)
  • License Key: [key] http://www.atlassian.com/software/jira/Licenses.jspa
  • Admin User
  • SMTP Settings

References:

Post Installation Configuration

You are using HSQL DB, which is an in-memory database and susceptible to corruption when abnormally terminated. DO NOT USE THIS IN A PRODUCTION SYSTEM. Instead we recommend using an external database, for a list of supported databases please see our documentation

Issue Searches

My Issues:

status != Closed AND assignee = currentUser() ORDER BY updated DESC, key DESC

Reported by Me:

status != Closed AND reporter = currentUser() ORDER BY updated DESC, key DESC

Recent Issues:

key in issueHistory() ORDER BY updated DESC, key DESC

Related to Me:

status != Closed AND (CC = currentUser() OR reporter = currentUser() OR assignee = currentUser() OR key in watchedIssues()) ORDER BY updated DESC, key DESC


WC - Active Issues:

status in (Open, "In Progress", Reopened, Blocked) AND reporter != rgardner ORDER BY priority DESC, status DESC, key DESC

WC - Active IT Issues:

project = "Information and Technology" and status in (Open, "In Progress", Reopened, Blocked) AND reporter != ryan AND reporter != stan ORDER BY priority DESC, status DESC, key DESC

WC - All Issues:

# No query
ORDER BY updated DESC, key DESC  # at least ordered

WC - Active Customer Support Issues:

project =   "Customer Support" and status in (Open, "In Progress", Reopened, Blocked) AND reporter != rgardner ORDER BY priority DESC, status DESC, key DESC


Fusion-io - Open ESX Issues

status != Closed AND ("Operating System" = ESX OR "Operating System" = "ESX 4.0" OR "Operating System" = "ESX 4.1" OR "Operating System" = "ESXi 4.0" OR
"Operating System" = "ESXi 4.1" OR "Operating System" = "ESXi 5.0") ORDER BY updated DESC, key DESC

Fusion-io - Redwood Hot Issues

project IN (FH, RED,BD,HDL, TAU) AND fixVersion = "Redwood Hot Issues" AND status not in (Closed, Resolved, "In Test")

Fusion-io - Cherry Hot List:

project = DC AND resolution = Unresolved AND fixVersion = "Cherry Hot List" AND Status != "In Test" ORDER BY assignee ASC, key DESC

Fusion-io - New Firehose Issues:

project = FH AND created >= -3d AND status in (Assigned, "In Test", "Info Needed", "Needs Review", New, "In Work") ORDER BY created DESC, key DESC

Fusion-io - Habanero Scrub List:

project = FH AND status in (Assigned, "Info Needed", "Needs Review", New, "In Work") AND fixVersion = 10954 ORDER BY priority DESC, key ASC

Fusion-io - Optimus Prime - Firehose Open

project = FH AND issuetype in (Bug, Improvement, "New Feature") AND status in (Assigned, "Info Needed", "Needs Review", New, "In Work") AND fixVersion = "Optimus Prime (2.1.0)" ORDER BY key DESC

Apache SSL

Integrating JIRA with Apache using SSL - JIRA 4.4 Early Access Program - Atlassian Documentation - Confluence - http://confluence.atlassian.com/display/JIRA/Integrating+JIRA+with+Apache+using+SSL

<Proxy *>
Order deny,allow
Allow from all
</Proxy>
 
SSLProxyEngine on
ProxyRequests       Off
ProxyPreserveHost   On
ProxyPass           /       https://localhost:8443/jira
ProxyPassReverse    /       https://localhost:8443/jira

External MySQL Database

JIRA Standalone: using an external database

Configure Database:

create database jiradb as utf8;
grant all on jiradb.* to 'jirauser'@'localhost' identified by 'jirauser';

Download JDBC driver jar:

wget http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-3.1.12.tar.gz/from/http://mirrors.24-7-solutions.net/pub/mysql/
tar -zvxf mysql-connector-java-3.1.12.tar.gz
cp mysql-connector-java-3.1.12/mysql-connector-java-3.1.12-bin.jar /opt/atlassian-jira-standard-3.10.2-standalone/common/lib

Edit conf/server.xml:

         <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
           username="jirauser"
           password="jirauser"
           driverClassName="com.mysql.jdbc.Driver"
           url="jdbc:mysql://localhost/jiradb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"
           />

Edit atlassian-jira/WEB-INF/classes/entityengine.xml:

   <datasource name="defaultDS" field-type-name="mysql"

If not using HSQLDB remove:

            schema-name="PUBLIC"

Subversion Plugin

JIRA Subversion plugin

Configuration:

<JIRA_HOME>/atlassian-jira/WEB-INF/classes/subversion-jira-plugin.properties

Serials

Integrate JIRA With A Test Case Management Tool

Integrate JIRA With A Test Case Management Tool

LDAP

An LDAP directory is a collection of data about users and groups. LDAP (Lightweight Directory Access Protocol) is an Internet protocol that web applications can use to look up information about those users and groups from the LDAP server.

We provide built-in connectors for the most popular LDAP directory servers: [2]

  • Microsoft Active Directory
  • Apache Directory Server (ApacheDS)
  • Apple Open Directory
  • Fedora Directory Server
  • Novell eDirectory
  • OpenDS
  • OpenLDAP
  • OpenLDAP Using Posix Schema
  • Posix Schema for LDAP
  • Sun Directory Server Enterprise Edition (DSEE)
  • A generic LDAP directory server

References:

--

Apache Directory - https://directory.apache.org/

Keywords