Install MySQL and jira-AGILE - RHEL6



1.  Configuration - MySQL  RHEL6


# mysql -u root -p
Enter password:

mysql> set password for 'root'@'localhost' = PASSWORD('password');
Query OK, 0 rows affected (0.00 sec)

mysql> set password for 'root'@'tk-utils' = PASSWORD('passord');
Query OK, 0 rows affected (0.00 sec)

mysql> set password for 'root'@'127.0.0.1' = PASSWORD('password');
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_bin;
Query OK, 1 row affected (0.04 sec)

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on jiradb.* TO 'jirauser'@'fts-utils' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.01 sec)

2. Verification 
Create user by GRANT as well ???mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on jiradb.* TO 'jirauser'@'tk-utils.tkware.com' IDENTIFIED BY 'password';Query OK, 0 rows affected (0.00 sec)

mysql> select user, host, password from mysql.user;
+----------+---------------------+-------------------------------------------+
| user     | host                | password                                  |
+----------+---------------------+-------------------------------------------+
| root     | localhost           | *7684CF2D294AB9F8A436602EB0B1B43CA75C31D9 |
| root     | fts-utils           | *7684CF2D294AB9F8A436602EB0B1B43CA75C31D9 |
| root     | 127.0.0.1           | *7684CF2D294AB9F8A436602EB0B1B43CA75C31D9 |
|          | localhost           |                                           |
|          | fts-utils           |                                           |
| jirauser | tk-utils           | *7684CF2D294AB9F8A436602EB0B1B43CA75C31D9 |
| jirauser | tk-utils.tkware.com | *7684CF2D294AB9F8A436602EB0B1B43CA75C31D9 |
+----------+---------------------+-------------------------------------------+
7 rows in set (0.00 sec)

[root@fts-utils Downloads]# mysql -u jirauser -h fts-utils -p
Enter password:

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| jiradb             |
| test               |
+--------------------+
3 rows in set (0.00 sec)

2. 1.  Do NOT run MySql's java based db configuration 


Download connector for java to jira installaation tomcat forlder
/opt/atlassian/jira/lib

DO NOT RUN
Database jiradb has to be empty.  The tomcat/jira /opt/atlassian/jira/bin/config.sh utility created all these tables. Do not run it.

http://fts-utils:8000 will launch setup wizard.
Use custom to connecto to mySQL db database.

In between, if tests database connection to mysql did not work, 
use above dblinsk to load jar into /opt/atlassian/jira/lib/
Restart jira "/etc/init.d/jira stop|strat' commands.
Then press TestConnection at the jira setup Wizard.

[root@fts-utils jira]# mysql -u jirauser -h fts-utils -pftsTool5 jiradb
...
mysql> show tables;
+--------------------------------+
| Tables_in_jiradb               |
+--------------------------------+
| JQUARTZ_BLOB_TRIGGERS          |
| JQUARTZ_CALENDARS              |
| JQUARTZ_CRON_TRIGGERS          |
| JQUARTZ_FIRED_TRIGGERS         |
….
DO NOT RUN
Database jiradb has to be empty.  The tomcat/jira /opt/atlassian/jira/bin/config.sh utility created all these tables. Do not run it.
 Create an alias tk-vm-agile.tkware.com for <hostname>.tkware.com
Forward using apache httpd to port 8000 on VirtualHost

<VirtualHost *:80>
   ProxyPreserveHost On
   ProxyRequests Off
   ServerName tkware-agile.tkware.com
   #ServerAlias *.tkware.com
   ProxyPass / http://localhost:8000/
   ProxyPassReverse / http://localhost:8000/
  </VirtualHost>


Stop Puppet that took port 8000:

Puppet stop proceeses
[root@fts-utils Downloads]# chkconfig  pe-httpd off
[root@fts-utils Downloads]# chkconfig  pe-console-services off
[root@fts-utils Downloads]# chkconfig  pe-mcollective off
[root@fts-utils Downloads]# chkconfig  pe-memcached off
[root@fts-utils Downloads]# service  pe-memcached stop
Stopping memcached:                                        [  OK  ]
[root@fts-utils Downloads]# service  pe-mcollective stop
Shutting down pe-mcollective:                              [  OK  ]
[root@fts-utils Downloads]# service  pe-console-services stop
Stopping pe-console-services:                              [  OK  ]
[root@fts-utils Downloads]# service  pe-httpd stop
Stopping pe-httpd:                 


3. POST Insallations:



Apply Jira Agile license




Install AddOns / Plugins.




Popular Posts