python从云端数据库获取数据失败_Django在云服务器部署打开数据库失败

sudo vi /etc/apache2/envvars

将下面2行改成普通能够登陆系统的账户就可以了，比如

export APACHE_RUN_USER=www-data #设置用户为qunero

export APACHE_RUN_GROUP=www-data #设置组为 www-data

export LANG='en_US.UTF-8'export LC_ALL='en_US.UTF-8' #图片上传中文出错解决方法

重启服务：sudo service apache2 restart

【1】/etc/apache2/sites-available目录新建配置文件：Djang2019.conf

Listen 8008

WSGIPythonPath /home/ubuntu/.VENV/Django2019:/home/ubuntu/.VENV/Django2019/lib/python3.5/site-packages/

WSGIPythonHome /home/ubuntu/.VENV/Django2019<8008>ServerName 0.0.0.08008>

ServerAlias 0.0.0.0

ServerAdmin webmaster@localhost

DocumentRoot /var/www/html

WSGIScriptAlias / /home/ubuntu/workspace/Django2019/Django2019/wsgi.pyRequire all granted

Require all granted

Alias /media/ /home/ubuntu/workspace/Django2019/media/

Alias /static/ /home/ubuntu/workspace/Django2019/static/Require all granted

Require all grantedErrorLog ${APACHE_LOG_DIR}/error.log

CustomLog ${APACHE_LOG_DIR}/access.log combined

View Code

【2】加载模块

LoadModule wsgi_module /usr/lib/apache2/modules/mod_wsgi.so

Options FollowSymLinks

AllowOverride None

#Require all denied

【3】mysqldb(python3)----pip install mysqlclient 或者PyMySQL

项目文件__init__.py

import pymysql

pymysql.install_as_MySQLdb()

【4】wsgi.py

importosimportsysfrom os.path importjoin,dirname,abspath

PROJECT_DIR= dirname(dirname(abspath(__file__)))

sys.path.insert(0,PROJECT_DIR)

os.environ['DJANGO_SETTINGS_MODULE'] = 'Django2019.settings'

from django.core.wsgi importget_wsgi_application

application= get_wsgi_application()

【5】setting.py

importosimportsys

BASE_DIR=os.path.dirname(os.path.dirname(os.path.abspath(__file__)))

sys.path.insert(0,os.path.join(BASE_DIR,'apps'))

sys.path.insert(1,os.path.join(BASE_DIR,'extra_apps'))

ALLOWED_HOSTS= ['*']#Application definition

INSTALLED_APPS=['django.contrib.admin','django.contrib.auth','django.contrib.contenttypes','django.contrib.sessions','django.contrib.messages','django.contrib.staticfiles','xadmin','crispy_forms','index',

]

MIDDLEWARE_CLASSES=['django.middleware.security.SecurityMiddleware','django.contrib.sessions.middleware.SessionMiddleware','django.middleware.common.CommonMiddleware','django.middleware.csrf.CsrfViewMiddleware','django.contrib.auth.middleware.AuthenticationMiddleware','django.contrib.auth.middleware.SessionAuthenticationMiddleware','django.contrib.messages.middleware.MessageMiddleware','django.middleware.clickjacking.XFrameOptionsMiddleware',

]

ROOT_URLCONF= 'Django2019.urls'TEMPLATES=[

{'BACKEND': 'django.template.backends.django.DjangoTemplates','DIRS': [os.path.join(BASE_DIR,'templates')],'APP_DIRS': True,'OPTIONS': {'context_processors': ['django.template.context_processors.debug','django.template.context_processors.request','django.contrib.auth.context_processors.auth','django.contrib.messages.context_processors.messages','django.core.context_processors.media',

],

},

},

]

WSGI_APPLICATION= 'Django2019.wsgi.application'DATABASES={'default': {'ENGINE': 'django.db.backends.mysql','NAME': '','USER': 'root','PASSWORD': '','HOST': '127.0.0.1','PORT': '3306',

}

}

AUTH_PASSWORD_VALIDATORS=[

{'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',

},

{'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',

},

{'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator',

},

{'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',

},

]

LANGUAGE_CODE= 'zh-Hans'TIME_ZONE= 'Asia/Shanghai'USE_I18N=True

USE_L10N=True

USE_TZ=False

STATIC_URL= '/static/'STATIC_ROOT= os.path.join(BASE_DIR, 'static')

STATICFILES_DIRS=[

os.path.join(BASE_DIR,"static"),

os.path.join(BASE_DIR,"xadmin")

]

MEDIA_URL= '/media/'MEDIA_ROOT= os.path.join(BASE_DIR, 'media')

View Code

【6】权限--https://code.ziqiangxuetang.com/django/django-deploy.html

一般目录权限设置为 755，文件权限设置为 644

假如项目位置在 /home/tu/XXX (在XXX 下面有一个 manage.py，XXX 是项目名称)