Django之入门CMDB系统(一)基础环境

• 安装django

pip3 install django==2.2.6

本地开发配置

• 配置pycharm

file-->settings-->project interpreter--> add --> ssh interpreter 设置远端 python环境

设置/usr/bin/python3.6 目录选择 →/opt

file--> new project --> django

部署数据库

• 为了快速，采用docker方式部署。

mkdir -p  /data/docker
mkdir -p /data/mysql5722

sudo yum install -y yum-utils device-mapper-persistent-data lvm2

sudo yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo

sudo yum makecache fast
sudo yum -y install docker-ce

docker version
systemctl enable docker.service    
systemctl start docker.service

sudo mkdir -p /etc/docker
sudo tee /etc/docker/daemon.json <<-'EOF'
{"registry-mirrors": ["https://890km4uy.mirror.aliyuncs.com"],"graph": "/data/docker"}
EOF
sudo systemctl daemon-reload

sudo systemctl restart docker

mkdir -p /data/mysql5722
mkdir -p /data/mysql5722-cnf

docker run -itd \
--name mysql \
-p 3306:3306 \
--mount type=bind,src=/data/mysql5722,dst=/var/lib/mysql \
--mount type=bind,src=/data/mysql5722-cnf,dst=/etc/mysql \
-e MYSQL_ROOT_PASSWORD=123456  \
mysql:5.7.22 --character-set-server=utf8

yum remove mariadb  -y 
yum install  mariadb    -y
mysql -uroot  -p123456 -h 192.168.100.99
create database  husky;

配置django 数据库

husky --> settings

ALLOWED_HOSTS = ['*']   ##允许所有地址访问

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'HOST': '192.168.100.99',
        'PORT': '3306',
        'NAME': 'husky',
        'USER': 'root',
        'PASSWORD': '123456',
    }
}

# DATABASES = {
#     'default': {
#         'ENGINE': 'django.db.backends.sqlite3',
#         'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
#     }
# }

• 修改python文件

vim /usr/local/lib64/python3.6/site-packages/django/db/backends/mysql/base.py

35 #if version < (1, 3, 13):   注释掉 这两行
36 #    raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__)   

vim /usr/local/lib64/python3.6/site-packages/django/db/backends/mysql/operations.py

145         if query is not None:
146             query = query.encode(errors='replace')   ##修改此行

• 执行数据库初始化

  pycharm : 菜单栏 tools --> 选择 run manage.py task

makemigrations 生成数据文件

migrate 根据文件，执行生成表结构

createsuperuser

设置pycharm 项目启动 地址 为 192.168.100.99

pycharm 启动django项目 (非命令行启动)

ssh://root@192.168.100.99:22/usr/bin/python3.6 -u /opt/manage.py runserver 192.168.100.99:8000
Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).
October 31, 2019 - 09:33:33
Django version 2.2.6, using settings 'husky.settings'
Starting development server at http://192.168.100.99:8000/
Quit the server with CONTROL-C.

其他

测试登录 http://192.168.100.99:8000/admin 输入账号密码

创建 requirements.txt 文件

pip3 freeze > requirements.txt

pip3 install -r  requirements.txt    ## 安装所有模块，如有增加模块，需要加到这里面