开源cmdb尝试

2019独角兽企业重金招聘Python工程师标准>>>

公司的服务器多了后，用Excel确实不方便，在网上找个开源的cmdb尝试一下，有推荐说cmdbuild好用。

简单安装小计：
官方推荐，安装在linux系统上，这里是centos7.5 x86_64
PostgreSQL from 9.4 to 9.6
Apache Tomcat 6.0 or 7.0 or 8.0 (7.068 recommended)
JDK 1.8

#install tomcat
yum install -y java-1.8.0 unzip
wget https://mirrors.tuna.tsinghua.edu.cn/apache/tomcat/tomcat-8/v8.0.53/bin/apache-tomcat-8.0.53.tar.gz
tar zxvf apache-tomcat-8.0.53.tar.gz
mv apache-tomcat-8.0.53 /opt/tomcat
groupadd tomcat
useradd -s /sbin/nologin -g tomcat -d /opt/tomcat tomcat

vi /etc/systemd/system/tomcat.service
# Systemd unit file for tomcat
[Unit]
Description=Apache Tomcat Web Application Container
After=syslog.target network.target
[Service]
Type=forking
Environment=JAVA_HOME=/usr/lib/jvm/jre
Environment=CATALINA_PID=/opt/tomcat/temp/tomcat.pid
Environment=CATALINA_HOME=/opt/tomcat
Environment=CATALINA_BASE=/opt/tomcat
Environment='CATALINA_OPTS=-Xms512M -Xmx1024M -server -XX:+UseParallelGC'
Environment='JAVA_OPTS=-Djava.awt.headless=true -Djava.security.egd=file:/dev/./urandom'
ExecStart=/opt/tomcat/bin/startup.sh
ExecStop=/bin/kill -15 $MAINPID
User=tomcat
Group=tomcat
UMask=0007
RestartSec=10
Restart=always
[Install]
WantedBy=multi-user.target
systemctl daemon-reload
systemctl enable tomcat
systemctl start tomcat
systemctl status tomcat

#install PostgreSQL 9
rpm -Uvh https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm
yum install -y postgresql96-server postgresql96
/usr/pgsql-9.6/bin/postgresql96-setup initdb
systemctl enable postgresql-9.6

vi /var/lib/pgsql/9.6/data/pg_hba.conf
# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust

这里trust若改为md5，重启postgresql后再登录就需要密码了
systemctl start postgresql-9.6

#get cmdbuild
wget https://nchc.dl.sourceforge.net/project/cmdbuild/2.5.1/cmdbuild-2.5.1.zip
unzip cmdbuild-2.5.1.zip
cd cmdbuild-2.5.1
cp cmdbuild-2.5.1.war /opt/tomcat/webapps/cmdbuild.war
cp extras/tomcat-libs/6.0\ or\ higher/postgresql-9.4.1207.jar /opt/tomcat/lib/
cd extras
unzip cmdbuild-distribution-shark-overlay-2.5.1.zip
cp -R cmdbuild-shark-overlay-2.5.1 /opt/tomcat/webapps/shark
chown -R tomcat.tomcat /opt/tomcat/
systemctl restart tomcat

su postgres
bash-4.2$psql
postgres=# alter user postgres with password 'Uiop#789';
postgres=# create database cmdbuild owner postgres encoding = ‘UTF8’;
postgres=# \q

先导入demo数据库看
cp /opt/tomcat/webapps/cmdbuild/WEB-INF/sql/sample_schemas/demo_schema.sql /tmp
cd /tmp && chown postgres.postgres demo_schema.sql

su postgres
#bash-4.2$cd /var/lib/pgsql/   #切到postgres用户的家目录，免得提示没权限
#bash-4.2$psql -d cmdbuild -f /tmp/demo_schema.sql    #导入样例

图形界面配置
http://IP:8080/cmdbuild
选择语言--中文，下一步，选择‘存在’，输入上面建的数据cmdbuild,
localhost
5432
postgresql
Uiop#789
下一步，
输入管理账号和密码：
admin:admin

随后进入应用页面，看到的如下：

网上只有简单安装的帖子，基本咩有使用体验帖，估计用的人很少。。

转载于:https://my.oschina.net/u/2404183/blog/2049761