达梦DEM监控配置

        实验说明

Agent与server为相同虚拟机，ip地址192.168.7.38

使用麒麟v10            4.19.90-24.4.v2101.ky10.x86_64

数据库为达梦8

        介质准备

介质	来源
web容器	自备tomcatapache-tomcat-8.0.20.zip
Server程序	已安装的达梦8，$DM_HOME/web/dm.war
Agent客户端	已安装的达梦8，$DM_HOME/tool/dmagent
Server数据库	已安装的达梦8

配置server

Server数据库运行脚本

disql sysdba/123456789 SQL> set CHAR_CODE UTF8 SQL> start /opt/dmdbms/web/dem_init.sql SQL> --set CHAR_CODE UTF8 ……

配置web容器配置

部署tomcat

解压tomcat

unzip apache-tomcat-8.0.20.zip /home/dmdba/apache-tomcat-8.0.20/

部署war包

cd $DM_HOME/web cp dem.war /home/dmdba/apache-tomcat-8.0.20/webapps/

server.xml

cd /home/dmdba/apache-tomcat-8.0.20/conf vi server.xml     <Connector port="8080" protocol="HTTP/1.1"                max_post_size="-1"                connectionTimeout="20000"                redirectPort="8443" /> #配置参数max_post_size，保证传输无限制

catalina.sh

cd /home/dmdba/apache-tomcat-8.0.20/bin vim catalina.sh JAVA_OPTS="-server -Xms256m -Xmx1024m -Djava.library.path=/opt/dmdbms/bin" #使用达梦8种的java运行环境

启停tomcat

cd /home/dmdba/apache-tomcat-8.0.20/bin ./catalina.sh start #启动 ./catalina.sh stop #停止

db.xml

先启动tomcat，自动解压war包

cd /home/dmdba/apache-tomcat-8.0.20/webapps/dem/WEB-INF vim db.xml <?xml version="1.0" encoding="UTF-8"?> <ConnectPool>         <Server>192.168.7.38</Server>         <Port>5236</Port>         <User>SYSDBA</User>         <Password>123456789</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

使用网页登录

地址localhost:8080/dem

默认用户名，密码

admin

888888

配置agent

部署agent程序

需要部署到root下，用root启动

cp -r /opt/dmdbms/tool/dmagent /root/dmagent

修改配置

vim agent.ini center_url = http://192.168.7.38:8080/dem  #center url location, eg: http://192.168.2.10:8080/dem #配置server的位置

启动agent

进程式启动

./start.sh /root/dmagent/agent.ini &

服务启动

#初始化服务器 [root@localhost dmagent]# ./service.sh install input agent home [/root/dmagent] : input agent.ini path [/root/dmagent/agent.ini] : Installation the service DmAgentService completed. #启动&加载服务 [root@localhost dmagent]# ./service.sh start 重定向至 /bin/systemctl start DmAgentService.service #查看服务状态  [root@localhost dmagent]# systemctl status  DmAgentService.service ● DmAgentService.service - Dm Agent Service    Loaded: loaded (/usr/lib/systemd/system/DmAgentService.service; enabled; vendor preset: disabled)    Active: active (running) since Sat 2022-07-16 17:42:33 CST; 10s ago   Process: 119523 ExecStart=/root/dmagent/service/DmAgentService start (code=exited, status=0/SUCCESS)  Main PID: 119620 (java)     Tasks: 42    Memory: 413.1M    CGroup: /system.slice/DmAgentService.service            └─119620 java -Xms64m -Xmx2048m -cp /root/dmagent/lib/* -Ddameng.log.file=/root/dmagent/log4j.xml -Dagent.home=/root/dmagent -Dagent.pid.file=/root/dmagent/service/> 7月 16 17:42:27 localhost.localdomain systemd[1]: Starting Dm Agent Service... 7月 16 17:42:33 localhost.localdomain DmAgentService[119523]: Starting dmagent SUCCESS! 7月 16 17:42:33 localhost.localdomain systemd[1]: Started Dm Agent Service.