精品软件工具--提高运维效率的小工具,包括资产管理,软件部署等.这个是后台代码.zip

**页面** 资源管理界面    软件部署界面   **开发环境** 项目需要在Linux环境下进行开发,因为用到了ansible模块,目前没有找到Windows上安装ansible模块的方法 我一直是用一台电脑安装Ubuntu的环境进行开发,Ubuntu下也有pycharm工具 **项目上线** 操作系统: - Centos - Ubuntu 运行环境: - python-3.6 - Django-3.0 基础组件: - mysql-5.7 - minio-2020-07-02 1. 先使用pip安装项目所需的三方模块 ``` pip3 install -r requirements.txt ``` 2. 使用pip安装uwsgi ``` pip3 install uwsgi -i http://mirrors.aliyun.com/pypi/simple --trusted-host mirrors.aliyun.com ``` 3. 在服务器上安装ansible所需的密码登陆模块 - Centos ``` sudo yum install sshpass ``` - Ubuntu ``` sudo apt-get install sshpass ``` 4. 拉取项目,更改cmdb/settings.py文件中数据库和minio的连接信息 ``` DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'MYSQL_DATABASE', #注意这里的数据库应该以utf-8编码 'USER': 'MYSQL_USERNAME', 'PASSWORD': 'MYSQL_PASSWORD', 'HOST': 'MYSQL_IP', 'PORT': 'MYSQL_PORT', } } MINIO_URL = 'MINIO_IP' MINIO_SSL = False # 配置文件存储桶名称 MINIO_CONFIGFILE_BUCKET = 'MINIO_BUCKET' MINIO_USERNAME = 'MINIO_USER' MINIO_PASSWORD = 'MINIO_PASS' ``` 5. 将更改后的文件上传到服务器,以/data/目录为例 ``` [root@localhost cmdb]# ll /data/cmdb/ 总用量 168 drwxr-xr-x 5 cmdb cmdb 168 12月 8 13:53 assets drwxr-xr-x 5 cmdb cmdb 153 12月 8 13:53 authentication drwxr-xr-x 3 cmdb cmdb 108 12月 8 14:25 cmdb drwxr-xr-x 2 cmdb cmdb 23 12月 8 13:53 conf drwxr-xr-x 6 cmdb cmdb 166 12月 8 13:53 deploy -rw-r--r-- 1 cmdb cmdb 624 12月 8 13:53 manage.py -rw-r--r-- 1 cmdb cmdb 1102 12月 8 13:53 readme.md -rw-r--r-- 1 cmdb cmdb 372 12月 8 13:53 requirements.txt -rw-r--r-- 1 cmdb cmdb 712 12月 8 14:24 uwsgi.ini -rw-r----- 1 cmdb cmdb 84430 12月 8 14:57 uwsgi.log -rw-r--r-- 1 cmdb cmdb 6 12月 8 14:26 uwsgi.pid ``` 6. 启动测试 ``` uwsgi --ini uwsgi.ini ``` 7. 使用systemd托管 ``` [Unit] Description=cmdb Documentation=http://www.xxx.com After=network.target [Service] User=cmdb Group=cmdb WorkingDirectory=/data/cmdb/ ExecStart=/usr/local/bin/uwsgi --ini /data/cmdb/uwsgi.ini ExecReload=/usr/local/bin/uwsgi --reload /data/cmdb/uwsgi.pid ExecStop=/usr/local/bin/uwsgi --stop /data/cmdb/uwsgi.pid Restart=on-failure RestartSec=20s [Install] WantedBy=multi-user.target ``` 8.安装部署功能，需要在服务器根目录下创建cmdb_software(这个目录已经在yml中写死了,我懒得改就没写成变量),并将程序包解压到该目录下 程序包下载地址: https://www.aliyundrive.com/s/HAc3QFswohy ``` mkdir /cmdb_software ``` 9.生成数据库表 ``` python3.6 manage.py makemigrations python3.6 manage.py migrate ``` 10.填充用户表 ``` INSERT INTO `cmdb`.`cmdb_auth` (`id`, `username`, `password`, `token`, `is_admin`, `is_del`) VALUES ('1', 'admin', 'admin', 'TmRXWZalukyKvc7fEonsCLbGVc9vTTCk6DnbvgNenjZ4n3hk6l', '1', '0'); INSERT INTO `cmdb`.`cmdb_auth` (`id`, `username`, `password`, `token`, `is_admin`, `is_del`) VALUES ('2', 'testtst', 'testtst', '42jh73m18fgKFXboFqwbF3J2t8orM8Mq2xoBhTcEcArC89wJY9', '0', '0'); ``` 11.填充菜单表 ``` INSERT INTO `cmdb`.`cmdb_assets_menu` (`id`, `name`, `pid`, `path`, `icon`, `is_del`) VALUES ('1', '资产管理', '0', '/assets', 'el-icon-office-building', '0'); INSERT INTO `cmdb`.`cmdb_assets_menu` (`id`, `name`, `pid`, `path`, `icon`, `is_del`) VALUES ('2', '机房列表', '1', '/engine', 'el-icon-s-home', '0'); INSERT INTO `cmdb`.`cmdb_assets_menu` (`id`, `name`, `pid`, `path`, `icon`, `is_del`) VALUES ('3', '项目列表', '1', '/project', 'el-icon-notebook-2', '0'); INSERT INTO `cmdb`.`cmdb_assets_menu` (`id`, `name`, `pid`, `path`, `icon`, `is_del`) VALUES ('4', '机器列表', '1', '/server', 'el-icon-s-platform', '0'); INSERT INTO `cmdb`.`cmdb_assets_menu` (`id`, `name`, `pid`, `path`, `icon`, `is_del`) VALUES ('5', '安装部署', '0', '/deploy', 'el-icon-magic-stick', '0'); INSERT INTO `cmdb`.`cmdb_assets_menu` (`id`, `name`, `pid`, `path`, `icon`, `is_del`) VALUES ('6', '软件安装', '5', '/software', 'el-icon-s-data', '0'); ``` 12.填充软件部署表(软件图片是base64编码) ``` INSERT INTO `cmdb`.`cmdb_deploy_softlist` (`id`, `soft_name`, `soft_img`, `soft_path`, `soft_desc`, `is_del`) VALUES ('1', '初始化', 'data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEASABIAAD/2wBDAAwICQoJBwwKCQoNDAwOER0TERAQESMZGxUdKiUsKyklKCguNEI4LjE/MigoOk46P0RHSktKLTdRV1FIVkJJSkf/2wBDAQwNDREPESITEyJHMCgwR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0f/wAARCAIhBQADASIAAhEBAxEB/8QAHAABAQACAwEBAAAAAAAAAAAAAAECBAMGBwUI/8QASxABAAEDAgMEBgUHCQYGAwAAAAECAxEEBSExQQYSUWEHcXSBsbITIjaRoRQVMjVCwdEWIyQmUlNyc/BEVGKi4fEzQ1VjZJMXgpT/xAAaAQEBAQEBAQEAAAAAAAAAAAAAAQIFBAMG/8QAJxEBAQADAAIDAAICAgMBAAAAAAECAxEEIRIxQRNRBTIUIkJxgSP/2gAMAwEAAhEDEQA/AOjAPowAAAAAHQAUAAAAAAAAAAVAAAAAAAAAAOPVkxSUAFABAAAAAAAAAMGECqBPIQEUAAAABFQAABAAAAYskPpYgCjIYicABegAyAAAAAAAAMcoAAAAACMmIACrQMiAAp1ABAAEAAAAAAAFYgIKHXICAyBAAAAYiidBiyQ6IAcUAQAAAAAAQAAABFQAAAAATOeigQkqAYRUnmATykASJwi5QAXCVc8AgAAAAAo3ti+0G3+02/nhot7Yv1/t/tNv54BzANsAAAAAAAB0AFAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAA4dAEUAAEAAAABAAAAAEAAAAYsmJFgAoAe5OioCAAAAAAAAADGoEAAAAAARZQIAKtAA4ACIAAioCoAAAAADHOejJiigAMkQOAyYsikQVAEViCiCKrHOWTE6gAigAAAAigAAgAAACKgAAAAJjCMkjiAoCJPLCk8IBQQCTpMZSrktXLDEAAEAAAAACDe2L9f7f7Vb+eGi39i/X+3e02/ngVygNsAAAAAAAAACgAAAAAAAAAAAAAAAAAAAnQAOgAAAAAAAAAAAICKAAAAAACAAAAgAAADECLIAKKkmcqyIAAAAAAMcY6yyAABjM8TERzlYljMYAAAA6YAAAnHVFmPNAgArQAAAMoAAACAAAAAAIqYjoioAAMkOiMmLIpEABIReYETAmZ6iRTIYEAAAAAAAAAAEAABAVAAA49QAAY5yLjCAyz5DFcCcXPjIAogkiRZnDGZyAQAFQFBAAAAg39i/X+3e1W/nh89vbD+v9u9qt/PAVz8OgDbIAAAAAAAAAdAAl6ACgAAAAAAAAAAAAAAAgAABPMAAAAAAARQAAQRQAAAAEAAAAABAAARBAGlAACQAAZAAAAGMzhYnJMKAkzhQEmcRljM5ZTyYgAAAAAAJKoEAFaAAABlAAEUBAAAAAAGOc9FzhEUABRUBFlFnnJSAkKCKgCHSFE4qIqIT7AAAAAAAAEVAAAEUBAAAAAATOUAGQxFGQCCEzhFgRiAKAgAAAAAAo3ti/X+3+1W/nhot/Yv1/t3tVv54ErlBOPi2yoAAABiOgALiepmUAAAAJ6AA6ABAAAAPYAIAC9ABQAZABQAAAAAAAAAAAEAAAAAAAAQAAAAEAAABiSKAKCoICoAAIAAAAAAAAJPCMsWU8pYgAAAAAAgAsAFUAAM+SAyAAIAAAAAAAJMZRkxRQAFFQDqSKgx5CiiKiggJKEEBF+gBQAQCeQTyBFRQQAAAAE5AqAAAAACZnqrFQTCqmML0XKRKmEQYTOfJlnPRiAAKIqYAAAAAAFG/sX6/272q388NBvbDH9Ydv9qt/PAlcwDbAIooAAAAAAAAAAAAAT0AAAB2gAAAAAAAAAAAAAAAAi8OqAoAgAAAAAABkAQAAAAAQAAASM9YRUIoAoMmIlABAAASZiOagAAAAAxmcTjC5x0BjMzPMAAAAABJmOioAAqgE8ZFAAQVBkAAEAAAAAAASVSURQUOgKgKkzjkoCAAgqAJKicE6oCLL2AAAAAE8gBFARUAAAABAAAAAAYsjMdABMZViEZAAiSyQGIAEzHTiEY6yoMQAAAABRvbD9oNu9qt/PDRbuw/r/bvarfzwI5wG2EFBUUyZAAAAAAAAAAAAAAAAOgABiekgAAAAAAAAAAAAAgoAAIAAAAAAAAgAAACKgAAAAMQFUABUBkAAAAAAAAAAGNTJhx8QBTAIKxBQUBjPPCosIACwAFABOoAIAAgAAAAAAAsiSgIKvNiHBRA4Lw6C4MAgAICBxQSU6RBURZPQAAAATzkAAAEAAAEFQAAAAAmcQAMVhRS+kglZEhfpMk8ZMR1lRJWOUVJAAFEAAAAXh1lAABRvbD9oNv9qt/PDRbuw/r/AG72q388COcBtgABBQUEUAAAAAAAAAT4KAAAAAAAAAAAAAAAAAJ8QFRQAAQAAAAAAAAMmY6IAAAACZAAAnPSMgxAIoAopPLIMiAHoAAAAAABFTsX7+gIiaqu7TE1T0iIlt2tq3K9ETa0OpqzymLcxH34YuzGfdamNv405kfcsdkN7vxGdLFvhzrqiJblHYPdKo+ve09Pl3pnH4PnfJ1z9amrKurYHcP/AMf6uYzOu08eUUzP7yfR/q+mtsz/APpP8Wf+Vr/tr+DL+nTzHB22rsBuEfoarT1/fH7mne7F71bjNNu1c/w18/vhZ5Wu/rN05T8ddV9G9sG72M9/br84600TVH4NG5Zu2au7etV0T4V0zE/i+s2439ZuGU/HFMLEYUb7L9VnnGIos+xAFVFRRkQAEUBAAAAAAEVJFQBAFDogyAEVigoCiZTImZ6J0jJFygIAigAAAAAAAIAAigCKgAAAAAGMgiphRKAxDnozMziWWEJCDEkFkAAQWZQACeYBmeoAACjf2L9f7f7Vb+eHz5b2w