Keystone could not import the workaround

Su-s / bin/sh-c "keystone-manage db_sync" keystone failed to import workaround

There are two problems:

SQL connection failed. 9 attempts left.: DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'allone' ([Errno 111] Connection refused)")

ERROR keystone DBError: (pymysql.err.InternalError) (1071, u'Specified key was too long; max key length is 767bytes') [SQL: u'\ nCREATE TABLE migrate_version (\ n\ trepository_id VARCHAR (1071) NOT NULL,\ n\ trepository_path TEXT,\ n\ tversion INTEGER,\ n\ tPRIMARY KEY (repository_id)\ n)\ n\ n']

There is no error in my keystone configuration file: / etc/keystone/keystone.conf

For example, [database]

Connection = mysql+pymysql://keystone:password@allone/keystone

Solution: edit the file: vi / etc/mysql/mariadb.conf.d/50-server.cnf

Bind-address 192.168.104.10 # # changed to the IP address corresponding to the hostname (mine is allone)

Character-set-server = utf8 # # character set changed to this

Collation-server = utf8_general_ci

Delete keystone database after modification

Delete users and authorizations

Such as: drop 'keystone'@'localhost'

Drop 'keystone'@'%'

Restart mysql

Rebuild the database and reauthorize

Su-s / bin/sh-c "keystone-manage db_sync" keystone

Check whether / var/log/keystone/keystone-manage.log is imported, check whether the database keystone has tables, successful