域账号密码自助-项目部署

部署方式

Windows + Apache + Mod_Wsgi + Django + Mysql

注意事项：Windows需要为英文版本，中文版本报错会有乱码！

安装Python2.7

https://www.python.org/downloads/

安装Mysql

3.1 安装

3.2 创建数据库

4.创建虚拟环境

• 使不同应用开发环境独立
• 环境升级不影响其他应用，也不会影响全局的python环境
• 防止系统中出现包管理混乱和版本冲突

# 安装virtualenvwrapper
pip install virtualenvwrapper-win
 
# 创建
mkvirtualenv ADManager
 
# 进入虚拟机环境
workon ADManager

5.离线安装 ldap & mysql-python

MySQL_python & python_ldap 在windows上无法直接通过pip install 完成安装
https://www.lfd.uci.edu/~gohlke/pythonlibs/ (解决方案)

(ADManager) D:\>cd D:\ShareFloders\NG-IT\AD_Manager\package
 
(ADManager) D:\ShareFloders\NG-IT\AD_Manager\package>dir
 
 Directory of D:\ShareFloders\NG-IT\AD_Manager\package
03/19/2018  11:47 AM           821,050 MySQL_python-1.2.5-cp27-none-win_amd64.whl
01/23/2018  10:55 PM         1,086,402 python_ldap-2.5.2-cp27-cp27m-win_amd64.whl
 
(ADManager) D:\ShareFloders\NG-IT\AD_Manager\package>pip install MySQL_python-1.2.5-cp27-none-win_amd64.whl
Successfully installed MySQL-python-1.2.5
 
(ADManager) D:\ShareFloders\NG-IT\AD_Manager\package>pip install python_ldap-2.5.2-cp27-cp27m-win_amd64.whl
Successfully installed python-ldap-2.5.2

6.部署Django环境

pip install -r requirement.txt

7.上传CODE至服务器

省略

8.配置数据库信息

settings.py
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'DATABASE NAME',
        'USER':'USER',
        'PASSWORD':'PASSWORD',
        'HOST':'DATABASE IP'
    }
}

9.配置邮件服务器

settings.py
# Email Config
EMAIL_HOST = 'MAIL Server'
EMAIL_PORT = 'MAIL PORT'
EMAIL_HOST_USER = 'USER'
EMAIL_HOST_PASSWORD = 'PASSWORS'
EMAIL_USE_TLS = True
EMAIL_FROM = 'MAIL FROM'

10.配置Apache

10.1 MS VC14安装

Apache依赖于 MicroSoft VC14，需要安装！

10.2 官网下载

https://www.apachehaus.com/cgi-bin/download.plx

httpd-2.4.34-o102o-x64-vc14.zip

10.3 Mod_Wsgi

https://github.com/GrahamDumpleton/mod_wsgi

mod_wsgi-windows-4.4.12.rar

10.4 配置Apache

解压httpd-2.4.34-o102o-x64-vc14.zip,将apache24目录放至 D:\apache24

解压mod_wsgi-windows-4.4.12.rar，将‪mod_wsgi-windows-4.4.12\Apache24-win64-VC10\modules\mod_wsgi-py27-VC9.so文件放至D:\apache24\modules目录

修改D:\apache24\conf\httpd.conf，添加mod_wsgi.so 模块

修改D:\apache24\conf\httpd.conf,修改SRVROOT目录

修改D:\apache24\conf\httpd.conf,打开虚拟主机

修改D:\Apache24\conf\extra\httpd-vhosts.conf

<VirtualHost *:80>
    ServerAdmin jianhu.yong@genewiz.com.cn
    DocumentRoot "D:/app01/ADManager"
    ServerName pwd.local.genewiz.com
    ErrorLog "logs/pwd.local.genewiz.com-error.log"
    CustomLog "logs/pwd.local.genewiz.com-access.log" common	
</VirtualHost>
 
 
WSGIScriptAlias / D:/app01/ADManager/ADManager/wsgi.py
<Directory D:/app01/ADManager/ADManager/>
	<Files wsgi.py>
		Require all granted
	</Files>
</Directory>
 
Alias /static/ D:/app01/ADManager/statics/
<Directory D:/app01/ADManager/statics/>
	Require all granted
</Directory>
 
# virtual env
WSGIPythonPath D:/app01/ADManager;D:/python-envs/ADManager/Lib/site-packages

10.5 安装Apache服务

cd D:\Apache24\bin
httpd.exe -k install
The "Apache2.4" is successfuly installed .
Testing httpd.conf
Error: reported here must be corrected before the service can be started.

10.6 启动Apache服务

cd D:\Apache24\bin
net start Apache2.4
Apache2.4 服务正在启动...
Apache2.4 服务启动成功。

10.7 Apache服务管理工具

启动D:\Apache24\bin\ApacheMonitor.exe

10.8 Apache运行账号权限设置

默认服务 没有权限执行powershell 需要在服务器上面设置登录

11.其他

ImportError: No system module ‘pywintypes’ (pywintypes27.dll) 错误

拷贝 Lib\site-packages\pywin32_system32目录下的pywintypes27.dll pythoncom27.dll 至Lib\site-packages\win32\lib目录下即可！