Linux部署达梦DEM界面

1.dm.ini参数配置优化

[root@localhost web]# su - dmdba
Last login: Mon Mar  1 17:14:04 PST 2021 on pts/1
[dmdba@localhost ~]$ cd /home/dmdbms/DAMENG/
[dmdba@localhost DAMENG]$ vi dm.ini

修改内容如下

MEMORY_POOL          =  200
BUFFER               =  1000
KEEP                 =  64
SORT_BUF_SIZE        =  50

2.执行SQL脚本

进入数据库，该数据库中执行SQL脚本（此SQL语句为数据库自带，在安装之后的web目录下）

[dmdba@localhost DAMENG]$ cd ../bin
[dmdba@localhost bin]$ ./disql SYSDBA/SYSDBA

服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 3.470(ms)
disql V8
SQL> /home/dmdbms/web/dem_init.sql

3.安装配置tomcat

下载地址https://tomcat.apache.org/download-90.cgi

将tomcat安装包cp到/home/dmdbms/tomcat目录

[root@localhost web]# cd /tmp
[root@localhost tmp]# chmod 755 apache-tomcat-9.0.43.tar.gz
[root@localhost tmp]# ll -al
total 649468
drwxrwxrwt. 13 root root      4096 Mar  1 17:24 .
dr-xr-xr-x. 17 root root       244 Feb 28 18:21 ..
-rwxr-xr-x   1 root root  11483588 Mar  1 17:23 apache-tomcat-9.0.43.tar.gz
-rwxr-xr-x   1 root root 653557760 Feb 28 18:25 dm8_20201112_x86_rh7_64_ent_8.1.1.144.iso
drwxrwxrwt.  2 root root         6 Feb 28 18:01 .font-unix
drwxr-xr-x   2 root root         6 Feb 28 18:27 hsperfdata_root
drwxrwxrwt.  2 root root         6 Feb 28 18:01 .ICE-unix
-rwx------.  1 root root       836 Feb 28 18:05 ks-script-3onl3G
-rwx------.  1 root root      1230 Feb 28 18:05 ks-script-CsATya
drwx------   3 root root        17 Feb 28 18:23 systemd-private-d87bb7a9ea7f43ac9492267f6851487f-chronyd.service-FqMmqo
drwx------   3 root root        17 Feb 28 18:27 systemd-private-d87bb7a9ea7f43ac9492267f6851487f-DmAPService.service-QXCKrU
drwxrwxrwt.  2 root root         6 Feb 28 18:01 .Test-unix
drwx------.  2 root root         6 Feb 28 18:06 vmware-root_6820-2831289736
drwx------   2 root root         6 Feb 28 18:23 vmware-root_6821-3879048790
drwx------   2 root root         6 Feb 28 18:21 vmware-root_6842-2831814033
drwxrwxrwt.  2 root root         6 Feb 28 18:01 .X11-unix
drwxrwxrwt.  2 root root         6 Feb 28 18:01 .XIM-unix
-rw-------.  1 root root         0 Feb 28 18:00 yum.log
[root@localhost tmp]# mkdir /home/dmdbms/tomcat
[root@localhost tmp]# cp apache-tomcat-9.0.43.tar.gz /home/dmdbms/tomcat/
[root@localhost tmp]# chown -R dmdba:dinstall /home/dmdbms/tomcat/

使用dmdba用户解压

[dmdba@localhost tomcat]$ tar zxvf apache-tomcat-9.0.43.tar.gz

修改server.xml

[dmdba@localhost tomcat]$ pwd
/home/dmdbms/tomcat
[dmdba@localhost tomcat]$ cd apache-tomcat-9.0.43/conf/
[dmdba@localhost conf]$ vi server.xml

修改内容如下添加 maxPostSize="-1"

<Connector port="8080" protocol="HTTP/1.1"
           connectionTimeout="20000"
           redirectPort="8443"
           maxPostSize="-1" />

vi …/bin/catalina.sh
添加内容到最后就可以

JAVA_OPTS="-server -Xms256m -Xmx1024m -XX:MaxPermSize=512m -Djava.library.path=/opt/dmdbms/bin"

4.将DEM项目war拷贝tomcat项目目录（webapps目录）

cp /home/dmdbms/web/dem.war /home/dmdbms/tomcat/apache-tomcat-9.0.43/webapps/

5. 解压war包

[dmdba@localhost webapps]$ unzip -oq dem.war -d dem

6.修改db.xml

修改解压后的dem/WEB-INF路径中的db.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<ConnectPool>
        <Server>192.168.62.198</Server>
        <Port>5236</Port>
        <User>SYSDBA</User>
        <Password>SYSDBA</Password>
        <InitPoolSize>5</InitPoolSize>
        <CorePoolSize>10</CorePoolSize>
        <MaxPoolSize>50</MaxPoolSize>
        <KeepAliveTime>60</KeepAliveTime>
        <DbDriver></DbDriver>
        <DbTestStatement>select 1</DbTestStatement>
        <SSLDir>../sslDir/client_ssl/SYSDBA</SSLDir>
        <SSLPassword></SSLPassword>
</ConnectPool>

回到tomcat的bin目录启动tomcat

[dmdba@localhost bin]$ ./startup.sh
Using CATALINA_BASE:   /home/dmdbms/tomcat/apache-tomcat-9.0.43
Using CATALINA_HOME:   /home/dmdbms/tomcat/apache-tomcat-9.0.43
Using CATALINA_TMPDIR: /home/dmdbms/tomcat/apache-tomcat-9.0.43/temp
Using JRE_HOME:        /opt/jdk/jdk1.8.0_161/jre
Using CLASSPATH:       /home/dmdbms/tomcat/apache-tomcat-9.0.43/bin/bootstrap.jar:/home/dmdbms/tomcat/apache-tomcat-9.0.43/bin/tomcat-juli.jar
Using CATALINA_OPTS:
Tomcat started.

6.验证

登录http://192.168.62.198:8080/dem/
admin/888888
成功

更多资讯请上达梦技术社区了解： https://eco.dameng.com