APM_麒麟操作系统下安装(ARM)

APM_麒麟操作系统下安装(ARM)

安装Postgres数据库:

1、 创建postgres用户:

useradd postgres 创建用户

passwd postgres  更新密码

密码:Zoho@123

2、 安装依赖

yum install -y  openssl openssl-devel readline readline-devel zlib-devel gcc gcc-c++ libxml2 libxml2-devel flex automake libtool

3、 切换到postgres用户

su – postgres(进入到/home/postgres

4、 然后下载数据库压缩包并且解压

wget https://ftp.postgresql.org/pub/source/v11.2/postgresql-11.2.tar.gz 

tar -xf postgresql-11.2.tar.gz 

5、 进入解压后的目录

cd postgresql-11.2

6、 编译环境检测

./configure --prefix=/home/postgres/soft --with-openssl --with-pgport=13306

(最后出现makefile)

7、 编译文件

make world -j24

make install -world -j24

8、 初始化数据库数据目录到/home/postgres/data

/home/postgres/soft/bin/initdb -D /home/postgres/data -E UTF8

9、 启动数据库

/home/postgres/soft/bin/pg_ctl start -D /home/postgres/data -l /tmp/logfile

10、配置环境变量.bashrc

       vi .bashrc

export PGPORT=13306

export PGUSER=postgres

export PGHOME=/home/postgres/soft

export PGDATA=/home/postgres/data

export PATH=${PGHOME}/bin:${PATH}

LD_LIBRARY_PATH=$PGHOME/lib:/usr/local/lib:/usr/local/lib64:/usr/lib64:$LD_LIBRARY_PATH

11、读取环境变量

       source .bashrc

12、数据库配置

       su -postgres

       mkdir -p /home/postgres/archive/wal

13、进入数据库安装目录data目录下找到postgresql.conf,更新下面内容:
       cluster_name='enmo_6001'

listen_addresses='*'

port=13306

wal_log_hints=on

logging_collector=on

logging_collector=on

log_filename='pg_log_%u.log'

log_file_mode=0600

log_truncate_on_rotation=on

log_rotation_age=1d

wal_keep_segments=100

archive_mode = on

archive_command = 'cp %p /home/postgres/archive/wal/%f'

wal_level = 'logical'

max_wal_senders = 10

max_replication_slots = 10

hot_standby = on

client_encoding='UTF8'

lc_messages = 'en_US.UTF-8'

lc_monetary = 'en_US.UTF-8'

lc_numeric = 'en_US.UTF-8'

lc_time = 'en_US.UTF-8

14、重启数据库

       /home/postgres/soft/bin/pg_ctl restart -D /home/postgres/data -l /tmp/logfile

15、配置数据库远程连接

       进入数据库安装目录\data\,找到pg_hba.conf,更新IPV4连接


16、重启数据库(/home/postgres/soft/bin/pg_ctl restart -D /home/postgres/data -l /tmp/logfile),安装Navicat,测试远程连接。如果正常,运行下面步骤。

17、创建新数据库amdb


18、进入amdb,运行下面语句:


       CREATE USER rouser with password 'Zoho@123';

REVOKE ALL ON SCHEMA public FROM rouser, public;

GRANT CONNECT ON DATABASE "amdb" TO rouser, public;

GRANT USAGE ON SCHEMA public TO rouser, public;

GRANT SELECT ON ALL TABLES IN SCHEMA public TO rouser, public;

ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT SELECT ON TABLES TO rouser, public;

GRANT USAGE ON SCHEMA public TO rouser;

GRANT SELECT ON ALL TABLES IN SCHEMA public TO rouser;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO rouser;

CREATE EXTENSION "pgcrypto";

CREATE EXTENSION CITEXT;

CREATE EXTENSION pg_stat_statements;

CREATE EXTENSION amcheck;

到此数据库完成

安装APM

下载APM,版本为16701

https://archives.manageengine.com/applications_manager/16701/ManageEngine_ApplicationsManager_64bit.bin

1、 将对应的安装包,放入到一台Linux设备中,安装APM。安装完成之后,请不要启动,压缩整个APM文件夹。

2、 然后编辑AMServer.propertiesAPM/conf),更新数据库端口13306,更新am.dbport.check,将true更新为false


3、 更新database_params.confAPM/working/conf)更新数据库连接和对应密码信息为:

数据库连接:

# url is of the form jdbc:subprotocol:DataSourceName for eg.jdbc:odbc:RMEDB

url jdbc:postgresql://192.168.3.30:13306/amdb?ApplicationName=ApplicationsManager&dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8 AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

 

# driver name

drivername org.postgresql.Driver AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

 

# login username for database if any

username postgres AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

 

# login password for the database if any

password Zoho@123 AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

 

# Number of transactional connections. (This number has to be zero for transaction disable mode).

TRANS_CONNECTIONS 0

 

# Number of non-transactional connections.

NON_TRANS_CONNECTIONS 10 

 

#database name

databasename  PGSQL

 

# Super-user username and Super-user password for the database

su_username=postgres

su_password=Zoho@123

 

# Read-only username and Read-only password for the database if any

ro_username=rouser

ro_password=Zoho@123

 

# To update credentials of login user(dbuser) and read-only user(rouser) if any

updatedbuser=false

updaterouser=false

updatesuuser=false

 

4、 下载Azul zuluhttps://www.azul.com/downloads/?version=java-8-lts&os=linux&architecture=arm-64-bit&package=jre

这个是针对ARMZULU,解压完成之后可以直接使用。

5、 然后启动APM。进入安装目录,进入根目录,启动APM,查看是否可以启动。


 

本次产品状况:数据库建议使用pgsql11.22  zulu版本:Azul jre 1.8.392(可以使用最新的)

数据库连接配置建议:https://pitstop.manageengine.com/portal/en/kb/articles/how-to-use-my-own-postgresql-instead-of-the-postgresql-bundled-with-applications-manager