lazzyfu部署

关闭防火墙关闭selinux 和 firewalld

/data/web/opsql/config/config.py

只需要修改此文件即可，不需要再修改settings.py文件

yum -y install epel-release
yum -y install net-tools vim lsof lrzsz bzip2-devel wget 
gcc gcc-c++ make automake unzip curl curl-devel perl perl-devel 
expat expat-devel zlib zlib-devel asciidoc xmlto gettext-devel 
openssl-devel openssl mlocate python-devel openldap-devel 
readline-devel git mysql-devel
PS：第一句语句单独执行，后面的语句一起执行

安装python3.6

# 不指定安装位置，默认安装到/usr/local/bin目录下
wget https://www.python.org/ftp/python/3.6.8/Python-3.6.8.tgz
tar -zxf Python-3.6.8.tgz
./configure --enable-optimizations
make && make install
PS：configure在python解压的文件夹下

激活python虚拟环境

/usr/local/bin/pip3.6 install --upgrade pip
/usr/local/bin/pip3.6 install virtualenv -i https://mirrors.aliyun.com/pypi/simple
/usr/local/bin/virtualenv /venv_py36 --python=/usr/local/bin/python3.6
echo "source /venv_py36/bin/activate" >> /root/.bashrc
source /root/.bashrc

从github下载项目代码

mkdir /data/web -p
cd /data/web
# clone到本地，命名为opsql
git clone https://github.com/lazzyfu/AuditSQL.git opsql

安装mysql

yum -y install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
yum -y install Percona-Server-server-57 Percona-Server-devel-57

service mysql start
grep 'temporary password' /var/log/mysqld.log # 这一步查看初始密码

# 修改密码
alter user root@'localhost' identified by '123.com';
flush privileges;
PS：查看初始密码后需要首次登陆，修改密码策略，然后修改密码后在执行创建库

安装redis(可选)

yum -y install redis
systemctl start redis.service 

安装python依赖包

cd /data/web/opsql/
pip install -r requirements.txt -i https://mirrors.aliyun.com/pypi/simple

安装uwsgi

pip install uwsgi

安装nginx

yum -y install nginx
chown -R nginx. /data/web
chown -R nginx. /venv_py36 # 必须设置虚拟环境的用户为nginx

初始化数据

需要修改配置文件(/data/web/opsql/config/config.py)中的数据库配置

cd /data/web/opsql

# 数据库创建库和用户，该用户必须要有with grant option权限
create database opsql character set utf8;
create user 'opsql'@'%' identified by '123.com';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234' WITH GRANT OPTION; # 授权
flush privileges;

# 创建表结构 # 必须先安装django
python manage.py migrate
# 导入数据
mysql -uopsql -p123.com opsql < documents/initial.sql