(py27) [root@test SimpletourDevops]# python manage.py makemigrations
Traceback (most recent call last):
File "manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/core/management/init.py", line 359, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/core/management/base.py", line 294, in run_from_argv
self.execute(*args, **cmd_options)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/core/management/base.py", line 342, in execute
self.check()
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/core/management/base.py", line 374, in check
include_deployment_checks=include_deployment_checks,
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/core/management/base.py", line 361, in _run_checks
return checks.run_checks(**kwargs)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/core/checks/registry.py", line 81, in run_checks
new_errors = check(app_configs=app_configs)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/core/checks/model_checks.py", line 30, in check_all_models
errors.extend(model.check(**kwargs))
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/models/base.py", line 1266, in check
errors.extend(cls._check_fields(**kwargs))
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/models/base.py", line 1337, in _check_fields
errors.extend(field.check(**kwargs))
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/models/fields/init.py", line 893, in check
errors = super(AutoField, self).check(**kwargs)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/models/fields/init.py", line 208, in check
errors.extend(self._check_backend_specific_checks(**kwargs))
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/models/fields/init.py", line 311, in _check_backend_specific_checks
return connections[db].validation.check_field(self, **kwargs)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/mysql/validation.py", line 41, in check_field
field_type = field.db_type(connection)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/models/fields/init.py", line 629, in db_type
return connection.data_types[self.get_internal_type()] % data
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/init.py", line 33, in getattr
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/utils/functional.py", line 35, in get
res = instance.dict[self.name] = self.func(instance)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 183, in data_types
if self.features.supports_microsecond_precision:
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/utils/functional.py", line 35, in get
res = instance.dict[self.name] = self.func(instance)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/mysql/features.py", line 54, in supports_microsecond_precision
return self.connection.mysql_version >= (5, 6, 4) and Database.version_info >= (1, 2, 5)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/utils/functional.py", line 35, in get
res = instance.dict[self.name] = self.func(instance)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 367, in mysql_version
with self.temporary_connection() as cursor:
File "/root/anaconda3/envs/py27/lib/python2.7/contextlib.py", line 17, in enter
return self.gen.next()
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/base/base.py", line 564, in temporary_connection
cursor = self.cursor()
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/base/base.py", line 233, in cursor
cursor = self.make_cursor(self._cursor())
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/base/base.py", line 204, in _cursor
self.ensure_connection()
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/base/base.py", line 199, in ensure_connection
self.connect()
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/utils.py", line 94, in exit
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/base/base.py", line 199, in ensure_connection
self.connect()
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/base/base.py", line 171, in connect
self.connection = self.get_new_connection(conn_params)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 263, in get_new_connection
conn = Database.connect(**conn_params)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/MySQLdb/init.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/root/anaconda3/envs/py27/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in init
super(Connection, self).init(*args, **kwargs2)
django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")
最后把setting里的数据库改了,才可以了。
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'SimpletourDevops',
'HOST': '172.16.160.200',
'USER': 'root',
'PORT': 3306,
'PASSWORD': 'Maks.123',
'OPTIONS': {
'init_command': 'SET storage_engine=INNODB',
},
}