centos6.6 安装jdk1.7+tomcat7部署jspxcms内容管理系统

232121

部署环境：
OS:CentOS release 6.6 (Final)
内存：512M
mysql:10.24.24.9
jspxcms：10.24.24.16

软件版本：
jdk-7u79-linux-x64.gz

apache-tomcat-7.0.42.tar.gz

mysql-5.5.32

jspxcms-6.0.1-release

============================================

1.进入到目录下并上传
# cd /server/tools/
# rz -y
jdk-7u79-linux-x64.gz

apache-tomcat-7.0.42.tar.gz


2.安装jdk1.7
# tar xf jdk-7u79-linux-x64.gz -C /usr/local/
# ln -s /usr/local/jdk1.7.0_79/ /usr/local/jdk
# chown -R root.root /usr/local/jdk
3.配置java的环境变量
# vim /etc/profile
末尾添加
export JAVA_HOME=/usr/local/jdk
export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH
export CLASSPATH=.$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib:$JAVA_HOME/lib/tools.jar
配置生效
# source /etc/profile

4.查看jdk版本信息
# java -version
java version "1.7.0_79"
Java(TM) SE Runtime Environment (build 1.7.0_79-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

5.安装apache-tomcat7
# cd /server/tools/
# tar xf apache-tomcat-7.0.42.tar.gz -C /usr/local/
# ln -s /usr/local/apache-tomcat-7.0.42/ /usr/local/tomcat
# echo 'export TOMCAT_HOME=/usr/local/tomcat'>>/etc/profile
# source /etc/profile

6.启动tomcat
# /usr/local/tomcat/bin/startup.sh
# ss -lntup|grep java

7.安装jspxcms管理系统
# cd /usr/local/tomcat/webapps/
# rm -rf ROOT/
# rz
jspxcms-6.0.1-release.zip

# unzip jspxcms-6.0.1-release.zip
# ls ROOT/
# mv jspxcms-6.0.1-release.zip /server/tools/

8.远端数据库中添加用户及授权(数据库和jspxcms程序不在一台服务器上，远端数据库为10.24.24.9)
mysql> create user 'jspxcms'@'localhost' identified by '123456';
mysql> create user 'jspxcms'@'10.24.24.%' identified by '123456';

mysql> grant all privileges on *.* to 'jspxcms'@'localhost' identified by '123456' with grant option;
mysql> grant all privileges on *.* to 'jspxcms'@'10.24.24.%' identified by '123456' with grant option;
mysql> show grants for jspxcms@localhost;
mysql> show grants for jspxcms@'10.24.24.%';

mysql> flush privileges;

浏览器访问：
http://10.24.24.16:8080/

9.进入安装界面

tomcat 安装jspxcms错误提示：
HTTP Status 500 - com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications lin

解决办法：
mysql5将其连接的等待时间(wait_timeout)缺省为8小时
mysql﹥ show global variables like 'wait_timeout';

修改my.cnf配置文件
在[mysqld]模块下添加一行
wait_timeout=1814400
重启mysql解决
# /etc/init.d/mysqld restart

安装过程中如果数据库不存在，会自动创建数据库