10分钟用python搭建一个超好用的CMDB系统

# -*- coding: utf-8 -*-
import os
import subprocess
import argparse
import time

def base(cmd):
 if subprocess.call(cmd, shell=True):
  raise Exception("{} 执行失败".format(cmd))

def install_docker():
 base("sudo yum install -y yum-utils device-mapper-persistent-data lvm2")
 base("sudo yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo")
 base("sudo yum makecache fast")
 base("sudo yum -y install docker-ce")
 if(not os.path.exists("/etc/docker")):
  base("mkdir -p /etc/docker")
 with open("/etc/docker/daemon.json", "w") as f:
  f.write('{\n "registry-mirrors": ["https://9f4w4icn.mirror.aliyuncs.com"] \n}')
 base("sudo systemctl daemon-reload")
 base("sudo systemctl start docker")

def create_dir():
 if (not os.path.exists("/var/cmdb/db")):
  base("sudo mkdir -p /var/cmdb/db")
 if (not os.path.exists("/var/cmdb/es")):
  base("sudo mkdir -p /var/cmdb/es")

def run_db_container():
 base("sudo docker run --name cmdb-db -d -e MYSQL_ROOT_PASSWORD=cmdbcmdb -v /var/cmdb/db:/var/lib/mysql mysql:5.7.21")

def run_es_container():
 base("sudo docker run --name cmdb-es -d -v /var/cmdb/es:/usr/share/elasticsearch/data elasticsearch:5.6.8")

def init_db():
 base("sudo docker run -it --rm --link cmdb-db -e ENV=PRO -e DB_HOST=cmdb-db -e DB_PORT=3306 -e DB_USERNAME=root -e DB_PASSWORD=cmdbcmdb -e DB_NAME=cmdb mingmingtang/cmdb init-db")

def run_cmdb_container(site_url, email_host, email_port, email_username, email_password):
 base("sudo docker run -d --name cmdb --link cmdb-db --link cmdb-es -p 80:80 -e ENV=PRO -e SITE_URL={} -e DB_HOST=cmdb-db -e DB_PORT=3306 -e DB_USERNAME=root -e DB_PASSWORD=cmdbcmdb -e DB_NAME=cmdb -e ELASTICSEARCH_HOSTS=cmdb-es -e EMAIL_HOST={} -e EMAIL_PORT={} -e EMAIL_USERNAME={} -e EMAIL_PASSWORD={} mingmingtang/cmdb start".format(site_url, email_host, email_port, email_username, email_password))

def input_para(help):
 value = ""
 while(not value):
  value = raw_input(help)
 return value

if __name__ == '__main__':
 if(os.geteuid() != 0):
  raise("请以root权限运行")
 site_url = input_para("请输入网站域名或IP（http://cmdb.xxx.com）：")
 email_host = input_para("网站邮箱服务器（smtp.163.com）：")
 email_port = input_para("邮箱服务器端口（25）：")
 email_username = input_para("邮箱用户名（cmdb@163.com）：")
 email_password = input_para("邮箱密码|独立授权码（P@ssw0rd）：")

 print("开始安装docker")
 install_docker()
 print("开始创建目录")
 create_dir()
 print("开始运行mysql容器")
 run_db_container()
 print("开始运行elasticsearch容器")
 run_es_container()
 print("等待数据库启动完成(10s)")
 time.sleep(10)
 print("开始初始化数据库")
 init_db()
 print("开始运行cmdb")
 run_cmdb_container(site_url, email_host, email_port, email_username, email_password)
 print("完成！")

sudo docker ps

[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录
basedir=D:\program\mysql\mysql-8.0.12-winx64
# 设置mysql数据库的数据的存放目录
datadir=D:\program\mysql\mysql-8.0.12-winx64\data
# 允许最大连接数
max_connections=200
# 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统
max_connect_errors=10
# 服务端使用的字符集默认为UTF8
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 默认使用“mysql_native_password”插件认证
default_authentication_plugin=mysql_native_password
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8

# 设置mysql的安装目录
basedir=D:\program\mysql\mysql-8.0.12-winx64
# 设置mysql数据库的数据的存放目录
datadir=D:\program\mysql\mysql-8.0.12-winx64\data

[Server] A temporary password is generated for root@localhost: rIafvf5f5G,a

mysqld --install

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

ALTER USER 'root'@'%' IDENTIFIED BY '远程登陆密码';

mysql>create database cmdb;

mysql>CREATE USER 'aaron'@'%' IDENTIFIED BY 'aaron';
Query OK, 0 rows affected (0.48 sec)
mysql> grant all on cmdb.* to 'aaron'@'%';
Query OK, 0 rows affected (0.23 sec)

git clone https://github.com/open-cmdb/cmdb.git
cd cmdb
#如创建了虚拟环境，请先激活
pip install -r requirements.txt #如果这一步有包安装失败，提示却少 microsoft visual c++ 14.0 的话，请在网站 https://www.lfd.uci.edu/~gohlke/pythonlibs/ 上查找相应的whl文件，直接 pip install .whl文件即可。

DATABASES = {
 'default': {
 'ENGINE': 'django.db.backends.mysql',
 'NAME': "cmdb",
 "HOST": "127.0.0.1",
 "PORT": 3306,
 "USER": "aaron",
 "PASSWORD": "aaron"
 }
}

python manage.py makemigrations 
python manage.py migrate
python manage.py cmdb_create_superuser #这一步创建一可以登陆的管理员用户
#修改 apps/mgmt/views.py 文件，取消注释“ from . import initialize ”
python manage.py runserver #这一步启动后端的 api 服务

git clone https://github.com/open-cmdb/cmdb-web.git

server {
  listen 8080;
  server_name localhost;
  error_page 500 502 503 504 /50x.html;
  location = /50x.html {
  root html;
  }
  
  root E:\GitHub\cmdb-web\dist;
  index index.html;
  location / {
  try_files $uri $uri/ @router;
  index index.html;
  }
  
  location @router {
  rewrite ^.*$ /index.html last;
  }

  location ~ /api{
  proxy_pass http://127.0.0.1:8000;
  }
 }

 location ~ /api{
  proxy_pass http://127.0.0.1:8000;
  }

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Vue 测试实例 </title>
	<script src="https://cdn.staticfile.org/vue/2.4.2/vue.min.js"></script>
</head>
<body>
<div id="app">
 	<p>{{ message }}</p>
</div>

<script>
 new Vue({
	 el: '#app',
	 data: {
	 message: 'Hello Vue.js!'
	 }
})
</script>
</body>
</html>

npm install -g cnpm --registry=https://registry.npm.taobao.org

C:\Users\xx>cd my-project
C:\Users\xx\my-project>cnpm install
C:\Users\xx\my-project>cnpm run dev

# 安装依赖，如果慢可换成 cnpm
npm install
# 启动服务，默认端口为8080，如果被占用会自动选取一个未被占用的端口
npm run dev
# 建立静态文件，可以放在 nginx 上运行
npm run build
# 查看建立报告
npm run build --report