DevOps 安装手册

环境要求

• 数据库：MySQL 5.7
• Java：Oracle JDK 1.8.0+, OpenJDK 1.8+

初始化数据库

在数据库所在机器使用命令初始化数据库用户及数据：

# 配置root用户，支持远程访问。
mysql -uroot -p'Primeton,000' -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'Primeton,000' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Primeton,000' WITH GRANT OPTION;"

# 创建devops数据库，初始化devopsadmin用户及访问devops数据库的权限
mysql -uroot -p'Primeton,000' -e "CREATE DATABASE devops CHARACTER SET utf8 COLLATE utf8_general_ci;GRANT ALL PRIVILEGES ON devops.* TO 'devopsadmin'@'localhost' IDENTIFIED BY 'Primeton,111' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON devops.* TO 'devopsadmin'@'%' IDENTIFIED BY 'Primeton,111' WITH GRANT OPTION;"

# 初始化sql数据，devops.war包解压后db-scripts/Mysql/devops-all.sql为mysql初始化sql。拷贝到数据库机器并执行初始化，sql路径根据实际拷贝路径修改。
mysql -udevopsadmin -p'Primeton,111' -e "use devops;source /opt/devops-all.sql;"

# 查询dps_user表验证
mysql -udevopsadmin -p'Primeton,111' -e "use devops;select * from dps_user;"
+-----------+--------+--------------+----------------------+-----------------+---------------+-------------+-------------+-------------+-------------+-------------+-----------+
| USER_NAME | EMP_ID | PASSWORD     | PASSWORD_UPDATE_TIME | LAST_LOGIN_TIME | LAST_LOGIN_IP | LOCK_STATUS | CREATE_USER | CREATE_TIME | UPDATE_USER | UPDATE_TIME | TENANT_ID |
+-----------+--------+--------------+----------------------+-----------------+---------------+-------------+-------------+-------------+-------------+-------------+-----------+
| sysadmin  | 1      | k2xvHUmCHWw= | NULL                 | NULL            | NULL          | NULL        | NULL        | NULL        | NULL        | NULL        | NULL      |
+-----------+--------+--------------+----------------------+-----------------+---------------+-------------+-------------+-------------+-------------+-------------+-----------+

注意

DevOps 的数据库要求字符集和排序规则分别为 utf8 和 utf8_general_ci

解压

tar -zxf DevOps_6.6_GA_Installer.tar.gz
cd DevOps_6.6_GA_Installer/devops
unzip devops-server-6.6.0.0.war -d devops
cd devops

数据库连接配置

修改配置文件WEB-INF/_srv/config/user-config.xml，配置已经初始化的数据库：

    <group name="default">
        <configValue key="Database-Type">MySql</configValue>
        <configValue key="Jdbc-Type"/>
        <configValue key="C3p0-DriverClass">com.mysql.jdbc.Driver</configValue>
        <configValue key="C3p0-Url">jdbc:mysql://10.16.16.182:3306/devops?characterEncoding=UTF-8</configValue>
        <configValue key="C3p0-UserName">devopsadmin</configValue>
        <configValue key="C3p0-Password">Primeton,111</configValue>
        <configValue key="C3p0-PoolSize">20</configValue>
        <configValue key="C3p0-MaxPoolSize">100</configValue>
        <configValue key="C3p0-MinPoolSize">10</configValue>
        <configValue key="Transaction-Isolation">ISOLATION_DEFAULT</configValue>
        <configValue key="Test-Connect-Sql">SELECT count(*) from EOS_UNIQUE_TABLE</configValue>
        <configValue key="Retry-Connect-Count">-1</configValue>
        <configValue key="C3p0-MaxIdleTime">600</configValue>
                    <configValue key="C3p0-IdleConnectionTestPeriod">900</configValue>
                    <configValue key="C3p0-MaxStatements">0</configValue>
                    <configValue key="C3p0-NumHelperThreads">1</configValue>
    </group>

拷贝连接数据库所需的 jar 包到应用目录下，jar 包需自行下载：

WEB-INF/lib/c3p0-0.9.0.jar
WEB-INF/lib/mysql-connector-java-5.1.40.jar

环境变量设置

打开startDevOps.sh脚本，完成 JDK、HTTP 端口等相关的配置。

JDK

export JAVA_HOME=/home/userapp/devops_install/jdk1.8.0_112
export PATH=$JAVA_HOME/bin:$PATH

HTTP 端口

devopsPort=14080

内存

minMemSize=512m
maxMemSize=4096m

服务启停

# 启动 DevOps 服务
sh startDevOps.sh
# 停止 DevOps 服务
sh stopDevOps.sh

默认凭证

• username: sysadmin
• password: 000000