http://jforum.net/install_no_wizard.jsp
cd ~/temp
wget http://jforum.net/jforum-2.1.9.zip
unzip jforum-2.1.9.zip
/ffp/opt/apache-tomcat-7.0.54/conf/context.xml:
    <Resource name="jforum"
              auth="Container"
              type="javax.sql.DataSource"
              factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
              testWhileIdle="true"
              testOnBorrow="true"
              testOnReturn="false"
              validationQuery="SELECT 1"
              validationInterval="30000"
              timeBetweenEvictionRunsMillis="30000"
              maxActive="10"
              minIdle="1"
              maxIdle="3"
              maxWait="5000"
              initialSize="1"
              removeAbandonedTimeout="60"
              removeAbandoned="false"
              logAbandoned="false"
              minEvictableIdleTimeMillis="30000"
              jmxEnabled="false"
              jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState"
              username="jforum"
              password="jforum"
              driverClassName="com.mysql.jdbc.Driver"
              url="jdbc:mysql://localhost:3306/jforum"/>
cd /ffp/opt/apache-tomcat-7.0.54/webapps/
rm -r jforum
mkdir jforum & cp -r ~/temp/jforum-2.1.9/* jforum
mysql -p
#DROP DATABASE jforum;
CREATE DATABASE jforum CHARACTER SET utf8;
GRANT ALL ON jforum.* TO 'jforum'@'%' IDENTIFIED BY 'jforum' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit;
http://nsa310:8080/jforum/install.jsp
Datasource: java:comp/env/jforum
cd /ffp/opt/apache-tomcat-7.0.54/webapps/jforum
find -name *.sql -type f -exec sed -i 's/TYPE=InnoDB/ENGINE=InnoDB/gi' {} \;
Forum URL:		/jforum/
Website URL:	/jforum/