Simplest Enterprise Continuous Integration Solutions

Saturday, June 30, 2012

Enterprise Linux: install local yum.repo


# linux64-yum-repo-server

# create local yum repository config files

[root@linux64-yum-repo-server ~]# cat /tmp/local.repos
/etc/yum.repos.d/puppetlabs.repo
[root@linux64-yum-repo-server ~]# tar -zPcvpf /var/www/html/local_yum_repos/local_yum_repos.tar.gz `cat /tmp/local.repos`

# local_yum_repos.tar.gz should be available thru httpd on linux64-yum-repo-server

http://linux64-yum-repo-server/local_yum_repos/local_yum_repos.tar.gz

# linux64-host

# install local yum repository config files

cd /tmp
wget http://linux64-yum-repo-server/local_yum_repos/local_yum_repos.tar.gz
cd /
tar -zxvf /tmp/local_yum_repos.tar.gz

Saturday, June 23, 2012

Enterprise Linux: Time Synchronization

# Manual steps

[root@linux64-server ~]# service ntpd status
ntpd (pid  3827) is running...
[root@linux64-server ~]# ntpdate pool.ntp.org
19 Jan 14:42:12 ntpdate[4521]: the NTP socket is in use, exiting
[root@linux64-server ~]# kill -9 3827
[root@linux64-server ~]# ntpdate pool.ntp.org
17 Jun 10:34:50 ntpdate[4523]: step time server 209.167.68.100 offset 13027946.745300 sec
[root@linux64-server ~]# date
Mon Jun 17 10:34:58 EDT 2012

# GUI configuration


# Command line configuration



1.       edit /etc/ntp.conf

# Permit time synchronization with our time source, but do not
# permit the source to query or modify the service on this system.
restrict default kod nomodify notrap nopeer noquery

# Permit all access over the loopback interface.  This could
# be tightened as well, but to do so would effect some of
# the administrative functions.
restrict 127.0.0.1
# restrict -6 ::1

# Hosts on local network are less restricted.
#restrict 192.168.1.0 mask 255.255.255.0 nomodify notrap

# Use public servers from the pool.ntp.org project.
# Please consider joining the pool (http://www.pool.ntp.org/join.html).
server 0.rhel.pool.ntp.org
server 1.rhel.pool.ntp.org
server 2.rhel.pool.ntp.org

#broadcast 192.168.1.255 key 42         # broadcast server
#broadcastclient                        # broadcast client
#broadcast 224.0.1.1 key 42             # multicast server
#multicastclient 224.0.1.1              # multicast client
#manycastserver 239.255.254.254         # manycast server
#manycastclient 239.255.254.254 key 42  # manycast client

# Undisciplined Local Clock. This is a fake driver intended for backup
# and when no outside source of synchronized time is available.
server 127.127.1.0
fudge   127.127.1.0 stratum 10

# Drift file.  Put this in a directory which the daemon can write to.
# No symbolic links allowed, either, since the daemon updates the file
# by creating a temporary in the same directory and then rename()'ing
# it to the file.
driftfile /var/lib/ntp/drift

# Key file containing the keys and key identifiers used when operating
# with symmetric key cryptography.
keys /etc/ntp/keys

# Specify the key identifiers which are trusted.
#trustedkey 4 8 42

# Specify the key identifier to use with the ntpdc utility.
#requestkey 8

# Specify the key identifier to use with the ntpq utility.
#controlkey 8
restrict 0.rhel.pool.ntp.org mask 255.255.255.255 nomodify notrap noquery
restrict 1.rhel.pool.ntp.org mask 255.255.255.255 nomodify notrap noquery
restrict 2.rhel.pool.ntp.org mask 255.255.255.255 nomodify notrap noquery

2. add below contents into /etc/ntp/step-tickers

0.rhel.pool.ntp.org
1.rhel.pool.ntp.org
2.rhel.pool.ntp.org

3.       service /etc/ntpd restart

Saturday, June 16, 2012

CA SCM upgrade: R7.1 to R12.1 SP2

CA Harvest r7.1 upgrade to CA SCM R12.1Scenario:
CA Harvest r7.1 server installed on Windows 2003 with Microsoft SQL 2005 database is going to be upgraded to CA SCM R12.1 SP2 server, which will be installed on a Windows 2003 server with Microsoft SQL 2008 R2 database.

  1. On CA Harvest r7.1 server, stop Harvest Broker Service.
  2. Detach mdb from Harvest r7.1 SQL 2005 database Completed CA SCM R12.1 SP2 server installation Wizard on Windows 2003 server
  3. Copy and attach mdb.mdf and mdb_log.LDF to SQL 2008 R2 database
  4. Complete CA SCM R12.1 SP2 server on Windows 2003 server though the installation wizard
  5. Launch %CA_SCM_HOME%\HDBSetup.exe

Configure ODBC DSN

ENTER DESIRED ACTION: CO
Enter new or existing DSN [harvest]: cascm
Enter server Name[(local)]: WINDOWS2003SE\SQL2008R2
Select a SCM database connection method to SQL Server server:
 [1] Windows Authentication
 [2] SQL Server Authentication
Enter your choice [1]: 2
Enter database name [harvest]: mdb

---------------------------------------
 CA SCM Change Manager
        Database Config Utility
---------------------------------------
Confirm following information:
 Data Source Name  =  cascm
 Server Name  =  WINDOWS2003SE\SQL2008R2
 Connect Method  =  SQL Server Authentication
 Database Name   mdb
 Driver Name  =  SQL Server Native Client 10.0
Select value to change:
  0 =  No changes
  1 =  Data Source Name
  2 =  Server Name
  3 =  Connect Method
  4 =  Database Name
  5 =  Driver Name
Enter selection [0]:

Creating DSN: cascm
Created DSN: cascm
Do you want to test connection? [Y/N]: Y
Testing driver connection: cascm
Enter DBMS administrator username [sa]:
  Using username: sa
Enter password for DBMS Administrator sa: ********
Connected to SQLSERVER as user [sa]
Connection test succeeded


Create SCM Database User

ENTER DESIRED ACTION: CU
Enter DBMS administrator username [sa]: 
      Using username: sa
Enter password for DBMS Administrator sa: ********
Enter SCM database username [harvest]: cascm
Enter password for SCM database user cascm: ********

---------------------------------------
 CA SCM Change Manager
        Database Config Utility
---------------------------------------
Confirm following information:
 Server Name  =  WINDOWS2003SE\SQL2008R2
 Connect Method  =  SQL Server Authentication
 DBMS Admin User  =  sa
 SCM Database User  =  cascm
Select value to change:
  0 =  No changes
  1 =  Server Name
  2 =  Connect Method
  3 =  DBMS Admin User
  4 =  Database Name


Enter selection  [0]:
   SCM database user cascm created


Test for SCM Repository Existence

ENTER DESIRED ACTION: TR
---------------------------------------
 CA SCM Change Manager
        Database Config Utility
---------------------------------------
Confirm following information:
 Server Name  =  WINDOWS2003SE\SQL2008R2
 Connect Method  =  SQL Server Authentication
 DBMS Admin User  =  sa
 Database Name  =  mdb
Select value to change:
  0 =  No changes
  1 =  Server Name
  2 =  Connect Method
  3 =  DBMS Admin User
  4 =  Database Name

Enter selection  [0]:
Testing for SCM Repository: mdb...
      SCM Repository exists


Upgrade SCM Repository

ENTER DESIRED ACTION: UR
Enter DBMS administrator username [sa]: 
---------------------------------------
 CA SCM Change Manager
        Database Config Utility
---------------------------------------
Confirm following information:

 Server Name  =  WINDOWS2003SE\SQL2008R2
 DBMS Admin User  =  sa
 Database Name  =  mdb

Select value to change:

  0 =  No changes
  1 =  Server Name
  2 =  DBMS Admin User
  3 =  Database Name

Enter selection [0]:


   Installing MDB patch 15957102...
Sat 06/09/2012 21:35:37.53 Started PatchMDB
Sat 06/09/2012 21:35:37.53 PatchMDB version: 15
Sat 06/09/2012 21:35:37.53 PatchMDB command: C:\PROGRA~1\CA\SCM\Database\SQL Ser
ver\CumulativePatch\PatchMDB.bat -MDB_NAME=mdb -MDB_PATCH=15957102 -DBMS_INSTANC
E=WINDOWS2003SE\SQL2008R2
Sat 06/09/2012 21:35:37.72 PatchMDB mdb log file for 15957102 in "C:\PROGRA~1\CA
\SCM\Database\SQL Server\CumulativePatch\\install_mdb.log"
Sat 06/09/2012 21:35:37.73 Checking if mdb already exists...
Sat 06/09/2012 21:35:37.98 Checking the mdb version
Sat 06/09/2012 21:35:38.25 Checking if the patch already exists
Sat 06/09/2012 21:35:38.51 Installing the patch from the manifest...
Sat 06/09/2012 21:35:38.53 Checking if the patch already exists
Sat 06/09/2012 21:35:38.77 Warning patch 14529450 already exists in database mdb
Sat 06/09/2012 21:35:38.78 Checking if the patch already exists
Sat 06/09/2012 21:35:39.05 Warning patch 14556290 already exists in database mdb
Sat 06/09/2012 21:35:39.07 Checking if the patch already exists
Sat 06/09/2012 21:35:39.32 Warning patch 14556282 already exists in database mdb
Sat 06/09/2012 21:35:39.33 Checking if the patch already exists
Sat 06/09/2012 21:35:39.58 Warning patch 14556268 already exists in database mdb
Sat 06/09/2012 21:35:39.59 Checking if the patch already exists
Sat 06/09/2012 21:35:39.85 Warning patch 14543336 already exists in database mdb
Sat 06/09/2012 21:35:39.87 Checking if the patch already exists
Sat 06/09/2012 21:35:40.13 Warning patch 14556293 already exists in database mdb
Sat 06/09/2012 21:35:40.15 Checking if the patch already exists
Sat 06/09/2012 21:35:40.41 Warning patch 14590059 already exists in database mdb
Sat 06/09/2012 21:35:40.43 Checking if the patch already exists
Sat 06/09/2012 21:35:40.66 Warning patch 14529371 already exists in database mdb
Sat 06/09/2012 21:35:40.68 Checking if the patch already exists
Sat 06/09/2012 21:35:40.92 Warning patch 14568542 already exists in database mdb
Sat 06/09/2012 21:35:40.93 Checking if the patch already exists
Sat 06/09/2012 21:35:41.19 Warning patch 14568562 already exists in database mdb
Sat 06/09/2012 21:35:41.20 Checking if the patch already exists
Sat 06/09/2012 21:35:41.46 Warning patch 14507108 already exists in database mdb
Sat 06/09/2012 21:35:41.48 Checking if the patch already exists
Sat 06/09/2012 21:35:41.76 Warning patch 14558296 already exists in database mdb
Sat 06/09/2012 21:35:41.77 Checking if the patch already exists
Sat 06/09/2012 21:35:42.02 Warning patch 14569472 already exists in database mdb
Sat 06/09/2012 21:35:42.03 Checking if the patch already exists
Sat 06/09/2012 21:35:42.28 Warning patch 14569473 already exists in database mdb
Sat 06/09/2012 21:35:42.30 Checking if the patch already exists
Sat 06/09/2012 21:35:42.55 Warning patch 14569492 already exists in database mdb
Sat 06/09/2012 21:35:42.56 Checking if the patch already exists
Sat 06/09/2012 21:35:42.85 Warning patch 14657498 already exists in database mdb
Sat 06/09/2012 21:35:42.86 Checking if the patch already exists
Sat 06/09/2012 21:35:43.11 Warning patch 14585259 already exists in database mdb
Sat 06/09/2012 21:35:43.12 Checking if the patch already exists
Sat 06/09/2012 21:35:43.36 Warning patch 14528293 already exists in database mdb
Sat 06/09/2012 21:35:43.37 Checking if the patch already exists
Sat 06/09/2012 21:35:43.62 Warning patch 14618309 already exists in database mdb
Sat 06/09/2012 21:35:43.63 Checking if the patch already exists
Sat 06/09/2012 21:35:43.88 Warning patch 14608268 already exists in database mdb
Sat 06/09/2012 21:35:43.91 Checking if the patch already exists
Sat 06/09/2012 21:35:44.26 Warning patch 14623623 already exists in database mdb
Sat 06/09/2012 21:35:44.29 Checking if the patch already exists
Sat 06/09/2012 21:35:44.57 Warning patch 14623658 already exists in database mdb
Sat 06/09/2012 21:35:44.59 Checking if the patch already exists
Sat 06/09/2012 21:35:44.82 Warning patch 14566526 already exists in database mdb
Sat 06/09/2012 21:35:44.84 Checking if the patch already exists
Sat 06/09/2012 21:35:45.09 Warning patch 14632279 already exists in database mdb
Sat 06/09/2012 21:35:45.10 Checking if the patch already exists
Sat 06/09/2012 21:35:45.36 Warning patch 14668173 already exists in database mdb
Sat 06/09/2012 21:35:45.37 Checking if the patch already exists
Sat 06/09/2012 21:35:45.62 Warning patch 14681365 already exists in database mdb
Sat 06/09/2012 21:35:45.64 Checking if the patch already exists
Sat 06/09/2012 21:35:45.87 Warning patch 14697138 already exists in database mdb
Sat 06/09/2012 21:35:45.88 Checking if the patch already exists
Sat 06/09/2012 21:35:46.13 Warning patch 14537257 already exists in database mdb
Sat 06/09/2012 21:35:46.15 Checking if the patch already exists
Sat 06/09/2012 21:35:46.40 Warning patch 14551464 already exists in database mdb
Sat 06/09/2012 21:35:46.43 Checking if the patch already exists
Sat 06/09/2012 21:35:46.68 Warning patch 14567794 already exists in database mdb
Sat 06/09/2012 21:35:46.69 Checking if the patch already exists
Sat 06/09/2012 21:35:46.96 Warning patch 14571426 already exists in database mdb
Sat 06/09/2012 21:35:46.97 Checking if the patch already exists
Sat 06/09/2012 21:35:47.21 Warning patch 14573920 already exists in database mdb
Sat 06/09/2012 21:35:47.23 Checking if the patch already exists
Sat 06/09/2012 21:35:47.49 Warning patch 14590854 already exists in database mdb
Sat 06/09/2012 21:35:47.50 Checking if the patch already exists
Sat 06/09/2012 21:35:47.74 Warning patch 14604332 already exists in database mdb
Sat 06/09/2012 21:35:47.76 Checking if the patch already exists
Sat 06/09/2012 21:35:48.01 Warning patch 14606116 already exists in database mdb
Sat 06/09/2012 21:35:48.02 Checking if the patch already exists
Sat 06/09/2012 21:35:48.27 Warning patch 14627469 already exists in database mdb
Sat 06/09/2012 21:35:48.28 Checking if the patch already exists
Sat 06/09/2012 21:35:48.54 Warning patch 14632318 already exists in database mdb
Sat 06/09/2012 21:35:48.56 Checking if the patch already exists
Sat 06/09/2012 21:35:48.81 Warning patch 14633394 already exists in database mdb
Sat 06/09/2012 21:35:48.83 Checking if the patch already exists
Sat 06/09/2012 21:35:49.11 Warning patch 14640144 already exists in database mdb
Sat 06/09/2012 21:35:49.13 Checking if the patch already exists
Sat 06/09/2012 21:35:49.37 Warning patch 14626896 already exists in database mdb
Sat 06/09/2012 21:35:49.39 Checking if the patch already exists
Sat 06/09/2012 21:35:49.65 Warning patch 14681327 already exists in database mdb
Sat 06/09/2012 21:35:49.67 Checking if the patch already exists
Sat 06/09/2012 21:35:49.91 Warning patch 14727370 already exists in database mdb
Sat 06/09/2012 21:35:49.93 Checking if the patch already exists
Sat 06/09/2012 21:35:50.16 Warning patch 14665944 already exists in database mdb
Sat 06/09/2012 21:35:50.18 Checking if the patch already exists
Sat 06/09/2012 21:35:50.43 Warning patch 14652105 already exists in database mdb
Sat 06/09/2012 21:35:50.44 Checking if the patch already exists
Sat 06/09/2012 21:35:50.68 Warning patch 14825128 already exists in database mdb
Sat 06/09/2012 21:35:50.69 Checking if the patch already exists
Sat 06/09/2012 21:35:50.94 Warning patch 14446952 already exists in database mdb
Sat 06/09/2012 21:35:50.95 Checking if the patch already exists
Sat 06/09/2012 21:35:51.20 Warning patch 14588437 already exists in database mdb
Sat 06/09/2012 21:35:51.21 Checking if the patch already exists
Sat 06/09/2012 21:35:51.47 Warning patch 14580254 already exists in database mdb
Sat 06/09/2012 21:35:51.48 Checking if the patch already exists
Sat 06/09/2012 21:35:51.76 Warning patch 14504590 already exists in database mdb
Sat 06/09/2012 21:35:51.77 Checking if the patch already exists
Sat 06/09/2012 21:35:52.03 Warning patch 14655659 already exists in database mdb
Sat 06/09/2012 21:35:52.04 Checking if the patch already exists
Sat 06/09/2012 21:35:52.29 Warning patch 14673022 already exists in database mdb
Sat 06/09/2012 21:35:52.30 Checking if the patch already exists
Sat 06/09/2012 21:35:52.57 Warning patch 14720512 already exists in database mdb
Sat 06/09/2012 21:35:52.58 Checking if the patch already exists
Sat 06/09/2012 21:35:52.82 Warning patch 14761153 already exists in database mdb
Sat 06/09/2012 21:35:52.83 Checking if the patch already exists
Sat 06/09/2012 21:35:53.09 Warning patch 14705556 already exists in database mdb
Sat 06/09/2012 21:35:53.10 Checking if the patch already exists
Sat 06/09/2012 21:35:53.35 Warning patch 14739657 already exists in database mdb
Sat 06/09/2012 21:35:53.36 Checking if the patch already exists
Sat 06/09/2012 21:35:53.62 Warning patch 14539620 already exists in database mdb
Sat 06/09/2012 21:35:53.63 Checking if the patch already exists
Sat 06/09/2012 21:35:53.89 Warning patch 14793104 already exists in database mdb
Sat 06/09/2012 21:35:53.90 Checking if the patch already exists
Sat 06/09/2012 21:35:54.18 Warning patch 14573732 already exists in database mdb
Sat 06/09/2012 21:35:54.20 Checking if the patch already exists
Sat 06/09/2012 21:35:54.59 Warning patch 14694926 already exists in database mdb
Sat 06/09/2012 21:35:54.60 Checking if the patch already exists
Sat 06/09/2012 21:35:54.86 Warning patch 14892743 already exists in database mdb
Sat 06/09/2012 21:35:54.87 Checking if the patch already exists
Sat 06/09/2012 21:35:55.13 Installing patch 14620643 in database mdb
Sat 06/09/2012 21:35:55.42 Checking if the patch already exists
Sat 06/09/2012 21:35:55.65 Installing patch 14657517 in database mdb
Sat 06/09/2012 21:35:55.94 Checking if the patch already exists
Sat 06/09/2012 21:35:56.18 Installing patch 14732594 in database mdb
Sat 06/09/2012 21:35:56.44 Checking if the patch already exists
Sat 06/09/2012 21:35:56.69 Installing patch 14737809 in database mdb
Sat 06/09/2012 21:35:56.98 Checking if the patch already exists
Sat 06/09/2012 21:35:57.23 Installing patch 14906843 in database mdb
Sat 06/09/2012 21:35:57.50 Checking if the patch already exists
Sat 06/09/2012 21:35:57.75 Installing patch 14903293 in database mdb
Sat 06/09/2012 21:35:58.03 Checking if the patch already exists
Sat 06/09/2012 21:35:58.27 Installing patch 14835390 in database mdb
Sat 06/09/2012 21:35:58.65 Checking if the patch already exists
Sat 06/09/2012 21:35:58.91 Installing patch 14835448 in database mdb
Sat 06/09/2012 21:35:58.91 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:35:59.44 Checking if the patch already exists
Sat 06/09/2012 21:35:59.73 Installing patch 14835457 in database mdb
Sat 06/09/2012 21:36:00.01 Checking if the patch already exists
Sat 06/09/2012 21:36:00.27 Installing patch 14843483 in database mdb
Sat 06/09/2012 21:36:00.55 Checking if the patch already exists
Sat 06/09/2012 21:36:00.79 Installing patch 14843599 in database mdb
Sat 06/09/2012 21:36:01.08 Checking if the patch already exists
Sat 06/09/2012 21:36:01.34 Installing patch 14843603 in database mdb
Sat 06/09/2012 21:36:01.69 Checking if the patch already exists
Sat 06/09/2012 21:36:01.93 Installing patch 14875632 in database mdb
Sat 06/09/2012 21:36:02.20 Checking if the patch already exists
Sat 06/09/2012 21:36:02.46 Installing patch 14875635 in database mdb
Sat 06/09/2012 21:36:02.73 Checking if the patch already exists
Sat 06/09/2012 21:36:02.98 Installing patch 14963131 in database mdb
Sat 06/09/2012 21:36:03.25 Checking if the patch already exists
Sat 06/09/2012 21:36:03.51 Installing patch 14990617 in database mdb
Sat 06/09/2012 21:36:03.84 Checking if the patch already exists
Sat 06/09/2012 21:36:04.08 Installing patch 14716065 in database mdb
Sat 06/09/2012 21:36:04.09 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:04.81 Checking if the patch already exists
Sat 06/09/2012 21:36:05.07 Installing patch 14842193 in database mdb
Sat 06/09/2012 21:36:05.51 Checking if the patch already exists
Sat 06/09/2012 21:36:05.78 Installing patch 14911176 in database mdb
Sat 06/09/2012 21:36:06.07 Checking if the patch already exists
Sat 06/09/2012 21:36:06.32 Installing patch 14911227 in database mdb
Sat 06/09/2012 21:36:07.13 Checking if the patch already exists
Sat 06/09/2012 21:36:07.39 Installing patch 14930657 in database mdb
Sat 06/09/2012 21:36:07.70 Checking if the patch already exists
Sat 06/09/2012 21:36:07.95 Installing patch 14939613 in database mdb
Sat 06/09/2012 21:36:09.43 Checking if the patch already exists
Sat 06/09/2012 21:36:09.67 Installing patch 14990807 in database mdb
Sat 06/09/2012 21:36:09.98 Checking if the patch already exists
Sat 06/09/2012 21:36:10.23 Installing patch 15000408 in database mdb
Sat 06/09/2012 21:36:10.60 Checking if the patch already exists
Sat 06/09/2012 21:36:10.85 Installing patch 14823018 in database mdb
Sat 06/09/2012 21:36:11.16 Checking if the patch already exists
Sat 06/09/2012 21:36:11.40 Warning patch 15089641 already exists in database mdb
Sat 06/09/2012 21:36:11.43 Checking if the patch already exists
Sat 06/09/2012 21:36:11.67 Installing patch 15050780 in database mdb
Sat 06/09/2012 21:36:11.93 Checking if the patch already exists
Sat 06/09/2012 21:36:12.17 Installing patch 15050793 in database mdb
Sat 06/09/2012 21:36:12.46 Checking if the patch already exists
Sat 06/09/2012 21:36:12.72 Installing patch 15050800 in database mdb
Sat 06/09/2012 21:36:13.03 Checking if the patch already exists
Sat 06/09/2012 21:36:13.28 Installing patch 15095923 in database mdb
Sat 06/09/2012 21:36:13.28 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:14.10 Checking if the patch already exists
Sat 06/09/2012 21:36:14.35 Installing patch 15128112 in database mdb
Sat 06/09/2012 21:36:14.67 Checking if the patch already exists
Sat 06/09/2012 21:36:14.98 Installing patch 14923043 in database mdb
Sat 06/09/2012 21:36:14.99 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:15.67 Checking if the patch already exists
Sat 06/09/2012 21:36:15.92 Installing patch 15174008 in database mdb
Sat 06/09/2012 21:36:16.20 Checking if the patch already exists
Sat 06/09/2012 21:36:16.47 Installing patch 15191613 in database mdb
Sat 06/09/2012 21:36:16.75 Checking if the patch already exists
Sat 06/09/2012 21:36:16.99 Installing patch 15191614 in database mdb
Sat 06/09/2012 21:36:17.27 Checking if the patch already exists
Sat 06/09/2012 21:36:17.51 Installing patch 15191617 in database mdb
Sat 06/09/2012 21:36:18.01 Checking if the patch already exists
Sat 06/09/2012 21:36:18.24 Installing patch 15191619 in database mdb
Sat 06/09/2012 21:36:18.59 Checking if the patch already exists
Sat 06/09/2012 21:36:18.85 Installing patch 15224511 in database mdb
Sat 06/09/2012 21:36:19.14 Checking if the patch already exists
Sat 06/09/2012 21:36:19.40 Installing patch 14984021 in database mdb
Sat 06/09/2012 21:36:19.78 Checking if the patch already exists
Sat 06/09/2012 21:36:20.03 Installing patch 15251588 in database mdb
Sat 06/09/2012 21:36:20.31 Checking if the patch already exists
Sat 06/09/2012 21:36:20.59 Installing patch 15259492 in database mdb
Sat 06/09/2012 21:36:20.90 Checking if the patch already exists
Sat 06/09/2012 21:36:21.16 Installing patch 15525432 in database mdb
Sat 06/09/2012 21:36:21.48 Checking if the patch already exists
Sat 06/09/2012 21:36:21.74 Installing patch 15032461 in database mdb
Sat 06/09/2012 21:36:22.07 Checking if the patch already exists
Sat 06/09/2012 21:36:22.32 Installing patch 15273404 in database mdb
Sat 06/09/2012 21:36:22.61 Checking if the patch already exists
Sat 06/09/2012 21:36:22.85 Installing patch 15224752 in database mdb
Sat 06/09/2012 21:36:22.85 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:23.38 Checking if the patch already exists
Sat 06/09/2012 21:36:23.62 Installing patch 15321639 in database mdb
Sat 06/09/2012 21:36:23.62 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:24.17 Checking if the patch already exists
Sat 06/09/2012 21:36:24.43 Installing patch 15354066 in database mdb
Sat 06/09/2012 21:36:24.72 Checking if the patch already exists
Sat 06/09/2012 21:36:25.06 Installing patch 15373649 in database mdb
Sat 06/09/2012 21:36:25.36 Checking if the patch already exists
Sat 06/09/2012 21:36:25.62 Installing patch 15423964 in database mdb
Sat 06/09/2012 21:36:25.90 Checking if the patch already exists
Sat 06/09/2012 21:36:26.14 Installing patch 15444683 in database mdb
Sat 06/09/2012 21:36:26.44 Checking if the patch already exists
Sat 06/09/2012 21:36:26.68 Installing patch 15254573 in database mdb
Sat 06/09/2012 21:36:26.99 Checking if the patch already exists
Sat 06/09/2012 21:36:27.24 Installing patch 15518617 in database mdb
Sat 06/09/2012 21:36:27.55 Checking if the patch already exists
Sat 06/09/2012 21:36:27.79 Installing patch 15483929 in database mdb
Sat 06/09/2012 21:36:27.79 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:28.37 Checking if the patch already exists
Sat 06/09/2012 21:36:28.62 Installing patch 15450466 in database mdb
Sat 06/09/2012 21:36:28.90 Checking if the patch already exists
Sat 06/09/2012 21:36:29.15 Installing patch 15649403 in database mdb
Sat 06/09/2012 21:36:29.43 Checking if the patch already exists
Sat 06/09/2012 21:36:29.68 Installing patch 15819026 in database mdb
Sat 06/09/2012 21:36:29.96 Checking if the patch already exists
Sat 06/09/2012 21:36:30.23 Installing patch 15395763 in database mdb
Sat 06/09/2012 21:36:30.23 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:30.79 Checking if the patch already exists
Sat 06/09/2012 21:36:31.03 Installing patch 15532632 in database mdb
Sat 06/09/2012 21:36:31.31 Checking if the patch already exists
Sat 06/09/2012 21:36:31.56 Installing patch 15450594 in database mdb
Sat 06/09/2012 21:36:31.84 Checking if the patch already exists
Sat 06/09/2012 21:36:32.10 Installing patch 15010584 in database mdb
Sat 06/09/2012 21:36:32.10 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:32.73 Checking if the patch already exists
Sat 06/09/2012 21:36:33.00 Installing patch 15592233 in database mdb
Sat 06/09/2012 21:36:33.31 Checking if the patch already exists
Sat 06/09/2012 21:36:33.57 Installing patch 15703451 in database mdb
Sat 06/09/2012 21:36:33.84 Checking if the patch already exists
Sat 06/09/2012 21:36:34.10 Installing patch 15042101 in database mdb
Sat 06/09/2012 21:36:34.40 Checking if the patch already exists
Sat 06/09/2012 21:36:34.65 Installing patch 15147582 in database mdb
Sat 06/09/2012 21:36:34.92 Checking if the patch already exists
Sat 06/09/2012 21:36:35.29 Installing patch 15456989 in database mdb
Sat 06/09/2012 21:36:35.58 Checking if the patch already exists
Sat 06/09/2012 21:36:35.83 Installing patch 15543853 in database mdb
Sat 06/09/2012 21:36:36.12 Checking if the patch already exists
Sat 06/09/2012 21:36:36.37 Installing patch 15860702 in database mdb
Sat 06/09/2012 21:36:36.37 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:36.92 Checking if the patch already exists
Sat 06/09/2012 21:36:37.18 Installing patch 14607142 in database mdb
Sat 06/09/2012 21:36:37.48 Checking if the patch already exists
Sat 06/09/2012 21:36:37.71 Installing patch 14609496 in database mdb
Sat 06/09/2012 21:36:38.02 Checking if the patch already exists
Sat 06/09/2012 21:36:38.27 Installing patch 15047531 in database mdb
Sat 06/09/2012 21:36:38.54 Checking if the patch already exists
Sat 06/09/2012 21:36:38.80 Installing patch 15810931 in database mdb
Sat 06/09/2012 21:36:38.80 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:40.66 Checking if the patch already exists
Sat 06/09/2012 21:36:40.91 Installing patch 15403416 in database mdb
Sat 06/09/2012 21:36:41.21 Checking if the patch already exists
Sat 06/09/2012 21:36:41.45 Installing patch 15425654 in database mdb
Sat 06/09/2012 21:36:41.73 Checking if the patch already exists
Sat 06/09/2012 21:36:42.00 Installing patch 15637612 in database mdb
Sat 06/09/2012 21:36:42.28 Checking if the patch already exists
Sat 06/09/2012 21:36:42.51 Installing patch 15824920 in database mdb
Sat 06/09/2012 21:36:42.84 Checking if the patch already exists
Sat 06/09/2012 21:36:43.11 Installing patch 15657272 in database mdb
Sat 06/09/2012 21:36:43.38 Checking if the patch already exists
Sat 06/09/2012 21:36:43.63 Installing patch 15705345 in database mdb
Sat 06/09/2012 21:36:43.91 Checking if the patch already exists
Sat 06/09/2012 21:36:44.17 Installing patch 15875618 in database mdb
Sat 06/09/2012 21:36:44.43 Checking if the patch already exists
Sat 06/09/2012 21:36:44.68 Installing patch 15505796 in database mdb
Sat 06/09/2012 21:36:44.98 Checking if the patch already exists
Sat 06/09/2012 21:36:45.24 Installing patch 15990494 in database mdb
Sat 06/09/2012 21:36:45.56 Checking if the patch already exists
Sat 06/09/2012 21:36:45.82 Installing patch 16029018 in database mdb
Sat 06/09/2012 21:36:45.82 Getting collation from database
        1 file(s) copied.
Sat 06/09/2012 21:36:46.39 Checking if the patch already exists
Sat 06/09/2012 21:36:46.63 Installing patch 16190194 in database mdb
Sat 06/09/2012 21:36:46.89 Checking if the patch already exists
Sat 06/09/2012 21:36:47.14 Installing patch 15957102 in database mdb
Sat 06/09/2012 21:36:49.73
Sat 06/09/2012 21:36:49.73 Patch 15957102 installed in database mdb
Sat 06/09/2012 21:36:49.73
Sat 06/09/2012 21:36:49.73 Successful rc=0
Patch 15957102 installed in database mdb
Updating database schema...
The existing schema will be upgraded to r12.1 schema. The changes are permanent
and cannot be rolled back. Do you want to continue [Y/N]?Y

Sunday, June 3, 2012

JIRA upgrade: JIRA 4.4.4 to JIRA 5.0.6

Upgrade JIRA 4.4.4 (32bit) to 5.0.6 steps:


1. Backup JIRA 4.4.4 installation

Administration -> System -> Import & Export -> Backup System -> Backup JIRA data
[jira@linux64-jira-server ~]$  id
uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)
# Backup /opt/atlassian for JIRA 4.4.4 32bit installation
[jira@linux64-jira-server ~]$ cp -rfp /opt/atlassian /opt/backup_atlassian_4.4.4


2. Upgrade to JIRA 5.0.6

[jira@linux64-jira-server ~]$ chmod a+x /tmp/atlassian-jira-5.0.6-x32.bin
[jira@linux64-jira-server ~]$ /tmp/atlassian-jira-5.0.6-x32.bin
Unpacking JRE ...
Starting Installer ...
This will install JIRA 5.0.6 on your computer.
OK [o, Enter], Cancel [c]
o
Choose the appropriate installation or upgrade option.
Please choose one of the following:
Express Install (use default settings) [1], Custom Install (recommended for advanced users) [2], Upgrade an existing JIRA installation [3, Enter]
3
Existing installation directory:
[/opt/atlassian/jira]
Back Up JIRA Home Directory
The upgrade process will automatically back up your JIRA Installation
Directory. You can also choose to back up your existing JIRA Home Directory.
Both directories are backed up as zip archive files in their respective
parent directory locations.
We strongly recommend choosing this option in the unlikely event that you
experience problems with the upgrade and may require these backups to
restore your existing JIRA installation.
If you have many attachments in your JIRA Home Directory, the zip archive of
this directory may consume a significant amount of disk space.
Back up JIRA home directory?
Yes [y, Enter], No [n]
y
Checking for local modifications.
List of modifications made within JIRA directories.
The following provides a list of file modifications within the
atlassian-jira directory.
Modified files:
        atlassian-jira/WEB-INF/classes/templates/email/subject/issuecommentedited.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issuecommented.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issueresolved.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issuedeleted.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issuereopened.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issueclosed.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issueworklogdeleted.vm
        atlassian-jira/WEB-INF/classes/templates/jira/issue/field/description-edit.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issueworkstopped.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issueupdated.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issuecreated.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issueworklogupdated.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issueworkstarted.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issueworklogged.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issuegenericevent.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issueassigned.vm
        atlassian-jira/WEB-INF/classes/templates/email/subject/issuemoved.vm
Removed files:
        (none)
[Enter]
Added files:
        atlassian-jira/images/hello.html
        atlassian-jira/WEB-INF/classes/subversion-jira-plugin.properties
        atlassian-jira/WEB-INF/lib/atlassian-jira-subversion-plugin-0.10.7.jar
[Enter]
        atlassian-jira/WEB-INF/lib/trilead-ssh2-build213-svnkit-1.3-patch.jar
        atlassian-jira/WEB-INF/lib/svnkit-1.3.3.jar
[Enter]
Checking if your instance of JIRA is running
Upgrade Check List
Back up your external database
We strongly recommend you back up your JIRA database if you have not already
done so.
Please refer to the following URL for back up guidelines:
http://docs.atlassian.com/jira/docs-050/Backing-Up-Data
Check plugin compatibility
Check that your non-bundled plugins are compatible with JIRA 5.0.6.
Access the plugin manager through the following URL:
http://localhost:8080/plugins/servlet/upm#compatibility
For more information see our documentation at the following URL:
http://docs.atlassian.com/jira/docs-050/Upgrading+JIRA#UpgradingJIRA-upgradechecklist
Please ensure you have read the above checklist before upgrading.
Your existing JIRA installation is about to be upgraded!
The upgrade process will shut down your existing JIRA installation to complete the upgrade.
Do you want to proceed?
Upgrade [u, Enter], Exit [e]
u
Your instance of JIRA is currently being upgraded.
Shutting down JIRA...
Checking if JIRA has been shutdown...
Backing up the JIRA installation directory
Backing up the JIRA home directory
Deleting the previous JIRA installation directory...
Extracting files ...
Please wait a few moments while JIRA starts up.
Launching JIRA ...
Installation of JIRA 5.0.6 is complete
Your installation of JIRA 5.0.6 is now ready and can be accessed via your
browser.
Custom modifications
Your previous JIRA installation contains customisations that must be
manually transferred. Refer to our documentation more information:
http://docs.atlassian.com/jira/docs-050/Upgrading+JIRA#UpgradingJIRA-custommodifications
JIRA 5.0.6 can be accessed at http://localhost:8080
JIRA 5.0.6 may take several minutes to load on first start up.
Finishing installation ...


3. Sync with previous modified files

[jira@linux64-jira-server ~]$ cd /opt/atlassian/jira
[jira@linux64-jira-server ~]$ cd atlassian-jira/WEB-INF/classes/templates/jira/issue/field/
[jira@linux64-jira-server ~]$ mv description-edit.vm org_bk_description-edit.vm
[jira@linux64-jira-server ~]$ cp /opt/backup_atlassian_4.4.4/jira/atlassian-jira/WEB-INF/classes/templates/jira/issue/field/description-edit.vm .
[jira@linux64-jira-server ~]$ cd /opt/atlassian/jira
[jira@linux64-jira-server ~]$ cd atlassian-jira/WEB-INF/classes/templates/email
[jira@linux64-jira-server ~]$ mv subject org_bk_subject
[jira@linux64-jira-server ~]$ cp -rp /opt/backup_atlassian_4.4.4/jira/atlassian-jira/WEB-INF/classes/templates/email/subject .


4. Start JIRA 5.0.6

[jira@linux64-jira-server ~]$ service jira stop
[jira@linux64-jira-server ~]$ service jira start


5. Update JIRA plugins through JIRA web

update JIRA suite utilities
enable behaviour
re install subversion