由于公司不斷擴大,伺服器數量日益增多,伺服器管理由原來的Excel表格管理問題不斷增加。近日公司Boss想找一款開源的CMDB管理系統,對比了騰訊的藍鲸和CMDBuild,決定使用CMDBuild。下面我們部署一套,與大家分享一下。
一、架構與準備工作
IP | OS | 軟體 | 資料庫 | |
CMDB Server | 192.168.11.151 | CentOS 7.2 | CMDBuild-2.4.3 | postgresql-server-9.2.18 |
CMDB Client | 192.168.11.148 | Windows 7 | IE 8 |
準備工作:
Tomcat :7.0以上
JDK: 1.8 以上
二、安裝部署
1、下載下傳Tomcat7和CMDBuild2.4.3。下載下傳連結如下:
Tomcat:http://tomcat.apache.org/download-70.cgi
CMDBuild2.4.3:https://sourceforge.net/projects/cmdbuild/files/latest/download
2、解壓并複制CMDBuild到Tomcat的對應目錄:
[root@cmdb ~]# tar xvf apache-tomcat-7.0.79.tar.gz -C /data/
[root@cmdb ~]# cp /root/cmdb/cmdbuild-2.4.3/cmdbuild-2.4.3.war /data/apache-tomcat-7.0.79/webapps/cmdbuild.war
[root@cmdb ~]# cp /root/cmdb/cmdbuild-2.4.3/extras/tomcat-libs/6.0\ or\ higher/postgresql-9.4.1207.jar /data/apache-tomcat-7.0.79/lib/
解壓cmdbuild-2.3.0/extras下面的cmdbuild-distribution-shark-overlay-2.4.3.zip,并将cmdbuild-distribution-shark-overlay-2.4.3複制到tomcat下的webapps目錄并改名為shark:
[root@cmdb ~]#cp -r /root/cmdb/cmdbuild-2.4.3/extras/cmdbuild-shark-overlay-2.4.3 /data/apache-tomcat-7.0.79/webapps/shark
3、啟動tomcat,通路http://localhost:8080,看看是否啟動成功:
[root@cmdb ~]# cd /data/apache-tomcat-7.0.79/bin/
[root@cmdb ~]# ./startup.sh
[root@cmdb ~]# ./shutdown.sh
3、安裝資料庫postgresql
[root@cmdb ~]# yum install postgresql-server postgresql -y
4、初始化postgresql
[root@cmdb ~]# postgresql-setup initdb
Initializing database ... OK
5、修改配置,讓所有位址都可以登陸
[root@cmdb ~]# vim /var/lib/pgsql/data/postgresql.conf
末尾添加:
listen_addresses = '*'
6、授權可以登入登入
[root@cmdb ~]# vim /var/lib/pgsql/data/pg_hba.conf
修改:
local all all md5
添加:
host all all 192.168.11.151/32 md5
7、重新開機postgresql
[root@cmdb ~]# systemctl restart postgresql.service
[root@cmdb ~]# systemctl enable postgresql.service
8、建立資料庫
[root@cmdb ~]# su - postgres
-bash-4.2$ psql
postgres=# create database cmdbuild with owner postgres encoding = 'UTF8';
postgres=# ALTER USER postgres WITH PASSWORD 'postgres';
postgres=# \q
-bash-4.2$ psql -d cmdbuild
cmdbuild=# CREATE LANGUAGE plpgsql;
postgres=# \q
9、導入demo資料庫檔案
-bash-4.2$ psql -d cmdbuild -f /data/apache-tomcat-7.0.79/webapps/cmdbuild/WEB-INF/sql/sample_schemas/demo_schema.sql
10、配置cmdbuild
[root@cmdb ~]# vim /data/apache-tomcat-7.0.79/webapps/cmdbuild/WEB-INF/conf/cmdbuild.conf
末尾添加:
language=en
11、配置資料庫連接配接配置,(注意防火牆:firewalld.service 和selinux)
[root@cmdb ~]# vim /data/apache-tomcat-7.0.79/webapps/cmdbuild/WEB-INF/conf/database.conf
末尾添加:
db.url=jdbc\:postgresql\://localhost\:5432/cmdbuild
db.username=postgres
db.password=postgres
12、安裝Workflow
[root@cmdb ~]# vim /data/apache-tomcat-7.0.79/webapps/shark/conf/Shark.conf
末尾添加:
orgNaNdbuild.ws.url=http://localhost:8080/cmdbuild/
orgNaNdbuild.ws.username=workflow
orgNaNdbuild.ws.password=admin
13、修改auth.conf
[root@cmdb ~]# vim /data/apache-tomcat-7.0.79/webapps/cmdbuild/WEB-INF/conf/auth.conf
末尾添加:
serviceusers.privileged=workflow
14、建立資料庫
[root@cmdb ~]# su – postgres
-bash-4.2$ createuser -s -P shark -Upostgres
Enter password for new role: shark
Enter it again:shar
-bash-4.1$ psql -d cmdbuild -U postgres
psql (8.4.18)
Type "help" for help.
cmdbuild=# \i /data/apache-tomcat-7.0.79/webapps/cmdbuild/WEB-INF/sql/shark_schema/01_shark_user.sql
cmdbuild=# \i /data/apache-tomcat-7.0.79/webapps/cmdbuild/WEB-INF/sql/shark_schema/02_shark_emptydb.sql
cmdbuild=# \dt
三、啟動tomcat,登陸測試CMDBuild:
賬号:admin
密碼:admin