搭建开源的运维工单平台

首先搭建数据库

yum方式安装mysql5.7

#wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
#rpm -Uvh mysql57-community-release-el7-10.noarch.rpm
#yum install -y mysql-community-server
#systemctl restart mysqld.service
#grep 'temporary password' /var/log/mysqld.log

首先，修改validate_password_policy参数的值

mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
mysql> alter user 'root'@'localhost' identified by '123456';
mysql> grant all privileges on *.* to 'root'@'%'identified by '123456';

其次安装pip（如果没有）

#curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
#python get-pip.py
#mkdir /opt/project
#cd /opt/project/
#git clone https://github.com/huangdongcong/iamdc.git
#yum install python-devel mysql-devel  -y
#cd iamdc && pip install -r requirements.txt

根据实际修改数据库的配置

cd  /opt/project/iamdc/ops/
# cat config.py
# -*- coding: utf-8 -*-
import os
class Config(object):
    DEBUG = False
    # 是否是开发模式
    DEV = False
    SECRET_KEY = 'x9blxbcxc6x01xaf^rx13xb2xb2Txcex87dxd1xf5x07xb6rx8crxe8x93'
    #数据库iamdcdb
    SQLALCHEMY_DATAbase_URI = 'mysql://root:123456@localhost:3306/iamdcdb?charset=utf8'
    # 日志文件
    LOG_FILE = "ops.log"
class DevConfig(Config):
    DEBUG = True
    # 开发模式
    DEV = True
    # 数据库iamdcdb
    SQLALCHEMY_DATAbase_URI = 'mysql://root:123456@localhost:3306/iamdcdb?charset=utf8'

初始数据库模型 migrate使用方法: 第一次使用

#python manager.py db init

后面每次有表修改执行下面两句进行修改

#python manager.py db migrate ;
#python manager.py db upgrade

用supervisor管理服务

#pip  install supervisor
#echo_supervisord_conf  > /etc/supervisord.conf
#mkdir /etc/supervisord
#修改 /etc/supervisord.conf
[include]
files = /etc/supervisord/*.conf

#cat /etc/supervisord/oms.conf 
[program:oms]
command = /usr/bin/python /opt/project/iamdc/run.py
directory = /opt/project/iamdc/
process_name = %(program_name)s_%(process_num)s
numprocs = 1
autorestart = true
startsecs = 1
stdout_logfile_maxbytes = 50MB
stdout_logfile_backups = 20
stderr_logfile = /var/log/xiaoma_oms.log
#启动服务
#supervisorctl start oms:*

192.168.40.113:5001

默认的账号密码admin/admin