Linux运维----03.制作trove-mysql5.7镜像

1. 安装mysql

   yum install http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
   yum remove mariadb-libs
   yum install mysql-community-server

2.配置mysql

mkdir -p /etc/mysql/conf.d/
vim /etc/my.cnf
.....
#此处有空行
!includedir /etc/mysql/conf.d/
chown -R mysql:mysql /etc/mysql/

3.安装percona-xtrabackup

innobackupex
yum install https://www.percona.com/redir/downloads/percona-release/redhat/percona-release-0.1-4.noarch.rpm
yum install percona-xtrabackup-24
出现如下问题：
Transaction check error:
  file /etc/my.cnf from install of Percona-Server-shared-56-5.6.44-rel86.0.el7.x86_64 conflicts with file from package mysql-community-server-5.7.26-1.el7.x86_64
Error Summary
-------------
方案：
 yum install  mysql-community-libs-compat

4.源码安装trove-guestagnet

yum install -y epel-release 
yum install -y python2-pip gcc  git  
useradd -m trove
cat /etc/sudoers.d/trove 
Defaults:trove !requiretty
trove ALL=(ALL) NOPASSWD:ALL
# 源码已下载
cd /home/trove/trove
git checkcout stable/pike 
pip  install -r requirements.txt  
python setup.py install 
bug:
#include "Python.h"
          ^
compilation terminated.
error: command 'gcc' failed with exit status 1
yum install pyhton-devel 
python setup.py install 

5.创建启动文件

mkdir -p /etc/trove/conf.d
chown -R trove:trove /etc/trove
mkdir -p /var/lib/trove
chown -R trove:trove /var/lib/trove
mkdir -p /var/log/trove
chown -R trove:trove /var/log/trove
touch /etc/trove/conf.d/trove-guestagent.conf
touch /etc/trove/conf.d/guest_info.conf
vim /etc/trove/conf.d/guest_info.conf 
[DEFAULT]
guest_id = none 
chown -R trove:trove /etc/trove
cat /usr/lib/systemd/system/trove-guestagent.service
[Unit]
Description=OpenStack Trove guestagent Service
After=syslog.target network.target
[Service]
Type=simple
User=trove
ExecStart=/usr/bin/trove-guestagent --config-file /etc/trove/conf.d/trove-guestagent.conf --config-file /etc/trove/conf.d/guest_info.conf
Restart=on-failure
[Install]
WantedBy=multi-user.target
[Unit]
Description=OpenStack Trove guestagent Service
After=syslog.target network.target
[Service]
Type=simple
User=trove
ExecStart=/usr/bin/trove-guestagent --config-file /etc/trove/conf.d/trove-guestagent.conf --config-file /etc/trove/conf.d/guest_info.conf
Restart=on-failure
[Install]
WantedBy=multi-user.target
systemctl daemon-reload 
systemctl enable trove-guestagent.service 

7.创建mysql拷贝文件，加入开机启动

vim /root/mysql.sh 
mysql_cnf="/home/trove/.my.cnf"   
function mv_mysql_cnf(){  
  while ((1==1))  
    do  
      if [[ -f $mysql_cnf ]]  
        then     
          cp $mysql_cnf /root/  
          break   
      fi  
    done     
}  
mv_mysql_cnf  
chmod +x /root/mysql.sh 
vim /etc/rc.d/rc.local   
/root/mysql.sh &   
chmod +x /etc/rc.d/rc.local 

8.验证

trove-manage --config-file /etc/trove/trove.conf            datastore_version_update   mysql mysql-5.7 mysql 3aea56f7-8451-451d-b4b1-8f9e87a1f8b6 '' 1
trove create ab_57  2 --size 5 --databases myDB  --users tulong:tulong@123 --datastore_version mysql-5.7 --datastore mysql --nic net-id=ab9c9463-ea02-4b60-b559-1857e5ebfc13   
trove list    
trove user-list     
trove  creat-user zhangsan  zhansan@123   
trove user-list  

9.bug

1. /var/log/trove-geustagent.log 
2019-05-29 17:17:51.380 840 DEBUG oslo_concurrency.processutils [-] CMD "sudo cat /root/.mysql_secret" returned: 1 in 0.042s execute /usr/lib/python2.7/site-packages/oslo_concurrency/processutils.py:409
2019-05-29 17:17:51.381 840 DEBUG oslo_concurrency.processutils [-] u'sudo cat /root/.mysql_secret' failed. Not Retrying. execute /usr/lib/python2.7/site-packages/oslo_concurrency/processutils.py:457
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service [-] /root/.mysql_secret does not exist.: ProcessExecutionError: Unexpected error while running command.
Command: sudo cat /root/.mysql_secret
Exit code: 1
Stdout: u''
Stderr: u'cat: /root/.mysql_secret: No such file or directory\n'
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service Traceback (most recent call last):
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service   File "/usr/lib/python2.7/site-packages/trove/guestagent/datastore/mysql_common/service.py", line 96, in clear_expired_password
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service     run_as_root=True, root_helper="sudo")
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service   File "/usr/lib/python2.7/site-packages/oslo_concurrency/processutils.py", line 424, in execute
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service     cmd=sanitized_cmd)
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service ProcessExecutionError: Unexpected error while running command.
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service Command: sudo cat /root/.mysql_secret
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service Exit code: 1
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service Stdout: u''
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service Stderr: u'cat: /root/.mysql_secret: No such file or directory\n'
2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service 
2019-05-29 17:17:51.382 840 DEBUG trove.guestagent.datastore.mysql_common.service [-] Generating admin password. secure /usr/lib/python2.7/site-packages/trove/guestagent/datastore/mysql_common/service.py:696
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager [-] An error occurred preparing datastore: (pymysql.err.OperationalError) (1045, u"Access denied for user 'root'@'localhost' (using password: NO)")
(Background on this error at: http://sqlalche.me/e/e3q8): OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'root'@'localhost' (using password: NO)")
(Background on this error at: http://sqlalche.me/e/e3q8)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager Traceback (most recent call last):
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/trove/guestagent/datastore/manager.py", line 285, in _prepare
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     cluster_config, snapshot)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 160, in wrapper
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     result = f(*args, **kwargs)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/trove/guestagent/datastore/mysql_common/manager.py", line 233, in do_prepare
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     app.secure(config_contents)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/trove/guestagent/datastore/mysql_common/service.py", line 700, in secure
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     with self.local_sql_client(engine, use_flush=False) as client:
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/trove/guestagent/datastore/mysql_common/service.py", line 186, in __enter__
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     self.conn = self.engine.connect()
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2193, in connect
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     return self._connection_cls(self, **kwargs)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 103, in __init__
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     else engine.raw_connection()
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2293, in raw_connection
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     self.pool.unique_connection, _connection
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2266, in _wrap_pool_connect
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     e, dialect, self
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1536, in _handle_dbapi_exception_noconnection
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     util.raise_from_cause(sqlalchemy_exception, exc_info)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2262, in _wrap_pool_connect
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     return fn()
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 303, in unique_connection
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     return _ConnectionFairy._checkout(self)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     fairy = _ConnectionRecord.checkout(pool)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     rec = pool._do_get()
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     self._dec_overflow()
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     compat.reraise(exc_type, exc_value, exc_tb)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     return self._create_connection()
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     return _ConnectionRecord(self)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     self.__connect(first_connect_check=True)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     connection = pool._invoke_creator(self)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     return dialect.connect(*cargs, **cparams)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 451, in connect
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     return self.dbapi.connect(*cargs, **cparams)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/pymysql/__init__.py", line 94, in Connect
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     return Connection(*args, **kwargs)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 325, in __init__
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     self.connect()
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 599, in connect
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     self._request_authentication()
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 861, in _request_authentication
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     auth_packet = self._read_packet()
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 684, in _read_packet
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     packet.check_error()
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     err.raise_mysql_exception(self._data)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     raise errorclass(errno, errval)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'root'@'localhost' (using password: NO)")
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager (Background on this error at: http://sqlalche.me/e/e3q8)
2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager 
2019-05-29 17:17:51.727 840 INFO trove.guestagent.datastore.manager [-] Ending datastore prepare for 'mysql'.
2019-05-29 17:17:51.727 840 INFO trove.guestagent.datastore.service [-] Set final status to failed to spawn.
2019-05-29 17:17:51.728 840 DEBUG trove.guestagent.datastore.service [-] Casting set_status message to conductor (status is 'failed to spawn'). set_status /usr/lib/python2.7/site-packages/trove/guestagent/datastore/service.py:166
2019-05-29 17:17:51.730 840 DEBUG trove.conductor.api [-] Making async call to cast heartbeat for instance: 0d2b580c-6ad6-496b-b7e3-fe20bde31ec3 heartbeat /usr/lib/python2.7/site-packages/trove/conductor/api.py:73
2019-05-29 17:17:51.740 840 DEBUG trove.guestagent.datastore.service [-] Successfully cast set_status. set_status /usr/lib/python2.7/site-packages/trove/guestagent/datastore/service.py:173
2019-05-29 17:17:51.742 840 DEBUG trove.conductor.api [-] Making async call to cast error notification notify_exc_info /usr/lib/python2.7/site-packages/trove/conductor/api.py:116
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server [-] Exception during message handling: OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'root'@'localhost' (using password: NO)")
(Background on this error at: http://sqlalche.me/e/e3q8)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server Traceback (most recent call last):
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/server.py", line 165, in _process_incoming
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     res = self.dispatcher.dispatch(message)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 274, in dispatch
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     return self._do_dispatch(endpoint, method, ctxt, args)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 194, in _do_dispatch
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     result = func(ctxt, **new_args)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 160, in wrapper
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     result = f(*args, **kwargs)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/trove/guestagent/datastore/manager.py", line 270, in prepare
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     cluster_config, snapshot, modules)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/trove/guestagent/datastore/manager.py", line 285, in _prepare
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     cluster_config, snapshot)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 160, in wrapper
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     result = f(*args, **kwargs)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/trove/guestagent/datastore/mysql_common/manager.py", line 233, in do_prepare
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     app.secure(config_contents)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/trove/guestagent/datastore/mysql_common/service.py", line 700, in secure
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     with self.local_sql_client(engine, use_flush=False) as client:
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/trove/guestagent/datastore/mysql_common/service.py", line 186, in __enter__
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     self.conn = self.engine.connect()
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2193, in connect
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     return self._connection_cls(self, **kwargs)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 103, in __init__
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     else engine.raw_connection()
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2293, in raw_connection
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     self.pool.unique_connection, _connection
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2266, in _wrap_pool_connect
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     e, dialect, self
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1536, in _handle_dbapi_exception_noconnection
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     util.raise_from_cause(sqlalchemy_exception, exc_info)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2262, in _wrap_pool_connect
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     return fn()
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 303, in unique_connection
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     return _ConnectionFairy._checkout(self)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     fairy = _ConnectionRecord.checkout(pool)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     rec = pool._do_get()
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     self._dec_overflow()
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     compat.reraise(exc_type, exc_value, exc_tb)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     return self._create_connection()
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     return _ConnectionRecord(self)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     self.__connect(first_connect_check=True)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     connection = pool._invoke_creator(self)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     return dialect.connect(*cargs, **cparams)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 451, in connect
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     return self.dbapi.connect(*cargs, **cparams)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/pymysql/__init__.py", line 94, in Connect
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     return Connection(*args, **kwargs)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 325, in __init__
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     self.connect()
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 599, in connect
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     self._request_authentication()
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 861, in _request_authentication
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     auth_packet = self._read_packet()
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 684, in _read_packet
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     packet.check_error()
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     err.raise_mysql_exception(self._data)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     raise errorclass(errno, errval)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'root'@'localhost' (using password: NO)")
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server (Background on this error at: http://sqlalche.me/e/e3q8)
2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server 
touch  /root/.secert 
chmod 755 /root/.secret 
#2.修复上述bu，重新创建实例：
vim /var/log/trove-guestagent.log 
_concurrency/processutils.py:409
2019-05-29 18:10:12.733 842 DEBUG oslo_concurrency.processutils [-] u'sudo systemctl start mysqld' failed. Not Retrying. execute /usr/lib/python2.7/site-packages/oslo_concurrency/processutils.py:457
2019-05-29 18:10:12.734 842 DEBUG oslo_concurrency.processutils [-] Running cmd (subprocess): sudo /usr/bin/mysqladmin ping execute /usr/lib/python2.7/site-packages/oslo_concurrency/processutils.py:372
2019-05-29 18:10:12.908 842 DEBUG oslo_concurrency.processutils [-] CMD "sudo /usr/bin/mysqladmin ping" returned: 1 in 0.174s execute /usr/lib/python2.7/site-packages/oslo_concurrency/processutils.py:409
2019-05-29 18:10:12.908 842 DEBUG oslo_concurrency.processutils [-] u'sudo /usr/bin/mysqladmin ping' failed. Not Retrying. execute /usr/lib/python2.7/site-packages/oslo_concurrency/processutils.py:457
2019-05-29 18:10:12.909 842 ERROR trove.common.utils [-] Command 'sudo /usr/bin/mysqladmin ping' failed.  Exit code: 1
stderr: ^Gmysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
stdout: : ProcessExecutionError: Unexpected error while running command.
2019-05-29 18:10:12.910 842 ERROR trove.guestagent.datastore.mysql_common.service [-] Failed to get database status.: ProcessExecutionError: Unexpected error while running command.
Command: sudo /usr/bin/mysqladmin ping
Exit code: 1
Stdout: u''
Stderr: u"\x07mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'\nCheck that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!\n"
可以查看到mysql服务进程没有正常启动
vim /var/log/mysqld.log 
2019-05-29T10:09:53.576866Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26) starting as process 2463 ...
2019-05-29T10:09:53.608137Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-05-29T10:09:53.608195Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-05-29T10:09:53.608202Z 0 [Note] InnoDB: Uses event mutexes
2019-05-29T10:09:53.608205Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-05-29T10:09:53.608208Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-05-29T10:09:53.608214Z 0 [Note] InnoDB: Using Linux native AIO
2019-05-29T10:09:53.608818Z 0 [Note] InnoDB: Number of pools: 1
2019-05-29T10:09:53.609073Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-05-29T10:09:53.613009Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-05-29T10:09:53.656199Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-05-29T10:09:53.685704Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-05-29T10:09:53.697395Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2019-05-29T10:09:53.697720Z 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2019-05-29T10:09:54.659961Z 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
2019-05-29T10:09:54.660616Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2019-05-29T10:09:56.267639Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2019-05-29T10:09:57.808737Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2019-05-29T10:09:57.808847Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-05-29T10:09:57.808872Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-05-29T10:09:57.808924Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-05-29T10:09:58.190716Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-05-29T10:09:58.190993Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2019-05-29T10:09:58.433915Z 0 [Note] InnoDB: Doublewrite buffer created
2019-05-29T10:09:58.442027Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-05-29T10:09:58.442049Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-05-29T10:09:58.442229Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-05-29T10:09:58.521762Z 0 [Note] InnoDB: Foreign key constraint system tables created
2019-05-29T10:09:58.521877Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2019-05-29T10:09:58.542715Z 0 [Note] InnoDB: Tablespace and datafile system tables created.
2019-05-29T10:09:58.542801Z 0 [Note] InnoDB: Creating sys_virtual system tables.
2019-05-29T10:09:58.564689Z 0 [Note] InnoDB: sys_virtual table created
2019-05-29T10:09:58.566609Z 0 [Note] InnoDB: Waiting for purge to start
2019-05-29T10:09:58.616728Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 0
2019-05-29T10:09:58.617297Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2019-05-29T10:09:58.617565Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
vim /etc/my.cnf 
explicit_defaults_for_timestamp=true

备注：mysql5.5、mysql5.6部署完毕后root密码为空，因此trove-guest-agent初始化的代码逻辑是默认mysql的root密码是空的，但是mysql5.7部署完毕后root密码是随机的，所以我们需要重新将root密码为空。mysql5.7默认安装validate_password plugin，导致trove所有创建或者修改密码的字符串都要严格遵循密码安全等级，需要卸载。

mysql 5.7安装完成，在/var/log/mysqld.log 中会生成临时密码，如果有多个，最后一个起作用。

/var/log/mysqld.log  
2019-05-29T10:34:10.064386Z 1 [Note] A temporary password is generated for root@localhost: 8-hy:kMH*uS5
temporary_password=$(grep 'root@localhost' $log_file  | tail -1 | awk -F 'root@localhost: ' '{print $NF}')
mysql -uroot -p$temporary_password -e "set password=password('my new password');uninstall plugin validate_password;set password=password('');flush privileges;"