JAVA_HOME=/usr/java/jdk1.5.0_08
CLASSPATH=.:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar
PATH=$JAVA_HOME/bin:$PATH
export JAVA_HOME
export PATH
export CLASSPATH

[root@jirasvn soft]# rpm -ivh MySQL-shared-community-5.0.67-0.rhel4.i386.rpm
warning: MySQL-shared-community-5.0.67-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-shared-community ########################################### [100%]
[root@jirasvn soft]# rpm -ivh MySQL-client-community-5.0.67-0.rhel4.i386.rpm
warning: MySQL-client-community-5.0.67-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        perl(DBI) is needed by MySQL-client-community-5.0.67-0.rhel4.i386
    Suggested resolutions:
        /home/buildcentos/CENTOS/en/4.0/i386/CentOS/RPMS/perl-DBI-1.40-8.i386.rpm
[quote]

提示缺少perl-DBI
于是[quote]
[root@jirasvn soft]# yum install perl-DBI

[root@jirasvn soft]# rpm -ivh MySQL-client-community-5.0.67-0.rhel4.i386.rpm
warning: MySQL-client-community-5.0.67-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-client-community ########################################### [100%]
[root@jirasvn soft]# rpm -ivh MySQL-server-community-5.0.67-0.rhel4.i386.rpm
warning: MySQL-server-community-5.0.67-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-server-community ########################################### [100%]

#tar -zxvf atlassian-jira-enterprise-3.12.3-standalone.tar.gz
#mv atlassian-jira-enterprise-3.12.3-standalone /home/jira
[root@jirasvn soft]# cd /home/jira
[root@jirasvn jira]# ls
atlassian-jira  common  external-source  logs    README.html  server  temp         webapps
bin             conf    licenses         NOTICE  README.txt   shared  tomcat-docs  work

        <Context path="" docBase="${catalina.home}/atlassian-jira" reloadable="false">
          <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
            username="jirauser"
            password="jira"
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost/jiradb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"
             />
[quote]
[quote]
<Server port="8005" shutdown="SHUTDOWN">

  <Service name="Catalina">

    <Connector port="8080"
      maxHttpHeaderSize="8192" maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
      enableLookups="false" redirectPort="8443" acceptCount="100"
      c disableUploadTimeout="true" />

    <Engine name="Catalina" defaultHost="localhost">
      <Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true">

        <Context path="" docBase="${catalina.home}/atlassian-jira" reloadable="false">
          <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
            username="[enter db username]"
            password="[enter db password]"
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost/jiradb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"
            [ delete the minEvictableIdleTimeMillis and timeBetweenEvictionRunsMillis params here ]
            />

          <Resource name="UserTransaction" auth="Container" type="javax.transaction.UserTransaction"
            factory="org.objectweb.jotm.UserTransactionFactory" jotm.timeout="60"/>
          <Manager className="org.apache.catalina.session.PersistentManager" save/>
        </Context>

      </Host>
    </Engine>
  </Service>
</Server>

[root@jirasvn conf]# diff server.xml.bak server.xml
14,20c14,18
<             username="sa"
<             password=""
<             driverClassName="org.hsqldb.jdbcDriver"
<             url="jdbc:hsqldb:${catalina.home}/database/jiradb"
<             minEvictableIdleTimeMillis="4000"
<             timeBetweenEvicti
<             maxActive="20" />
---
>             username="jirauser"
>             password="jira"
>             driverClassName="com.mysql.jdbc.Driver"
>             url="jdbc:mysql://localhost/jiradb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"
>              />
[root@jirasvn conf]#

[root@jirasvn jira]# cd atlassian-jira/WEB-INF/classes/
[root@jirasvn classes]# ls |grep entity
entitydefs
entityengine.xml
[root@jirasvn classes]# vi entityengine.xml
　

<!-- DATASOURCE - You will need to update this tag for your installation.

-->
  <datasource name="defaultDS" field-type-name="mysql"
      [ delete this, if it exists: schema-name="PUBLIC" ]
      helper-class="org.ofbiz.core.entity.GenericHelperDAO"
      check-on-start="true"
      use-foreign-keys="false"
      ...
[quote]

3.创建数据库
[quote]
[root@jirasvn jira]# mysqladmin -u root password yourpassword
[root@jirasvn jira]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.67-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

   1. Download the MySQL Connector/J JDBC driver, eg. version 3.1.12 (tar.gz or zip) which we have verified to work. NOTE:

the older 3.1.11 driver is broken.
      Note
      A user has reported encountering problems using the Resin JDBC driver for MySQL. However, the Connector/J driver from

MySQL works correctly (except for version 3.1.11).
   2. Add the MySQL JDBC driver jar (mysql-connector-java-3.x.x-bin.jar) to the common/lib/ directory. NOTE: Do not place the

Debug Driver (mysql-connector-java-3.x.x-bin-g.jar) on the CLASSPATH as this can cause issues (JRA-8674).

[quote]

5.创建用户,以后用此用户启动JIRA
#useradd jira
# passwd jira
Changing password for user jira.
New UNIX password:
BAD PASSWORD: it is too short
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@jirasvn home]# chown -R jira.jira jira
[root@jirasvn home]# ls -al
total 48
drwxr-xr-x   5 root root  4096 Sep  9 15:48 .
drwxr-xr-x  23 root root  4096 Sep  9 15:19 ..
drwxr-xr-x  15 jira jira  4096 Sep  9 16:08 jira
drwx------   2 root root 16384 Sep  9  2008 lost+found
drwxr-xr-x   3 root root  4096 Sep  9 16:06 soft
[root@jirasvn home]#
6.编写自启动脚本
[quote]
[root@jirasvn bin]# cd /etc/rc.d/init.d/
[root@jirasvn init.d]# vi jira
#!/bin/bash
# Jira startup script

RUN_AS_USER=jira
CATALINA_HOME=/home/jira/

start() {
        echo "Starting Jira: "
        if [ "x$USER" != "jira" ]; then
          su - $RUN_AS_USER -c "$CATALINA_HOME/bin/startup.sh"
        else
          $CATALINA_HOME/bin/startup.sh
        fi
        echo "done."
}
stop() {
        echo "Shutting down Jira: "
        if [ "x$USER" != "x$RUN_AS_USER" ]; then
          su - $RUN_AS_USER -c "$CATALINA_HOME/bin/shutdown.sh"
        else
          $CATALINA_HOME/bin/shutdown.sh
        fi
        echo "done."
}

case "$1" in
  start)
        start
        ;;
  stop)
        stop
        ;;
  restart)
        stop
        sleep 10
        #echo "Hard killing any remaining threads.."
        #kill -9 `cat $CATALINA_HOME/work/catalina.pid`
        start
        ;;
  *)
        echo "Usage: $0 {start|stop|restart}"
esac

exit 0