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

innobackupexyum install https://www.percona.com/redir/downloads/percona-release/redhat/percona-release-0.1-4.noarch.rpmyum 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_64Error Summary-------------方案： yum install  mysql-community-libs-compat

4.源码安装trove-guestagnet

yum install -y epel-release yum install -y python2-pip gcc  git  useradd -m trovecat /etc/sudoers.d/trove Defaults:trove !requirettytrove ALL=(ALL) NOPASSWD:ALL# 源码已下载cd /home/trove/trovegit 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 1yum install pyhton-devel python setup.py install 

5.创建启动文件

mkdir -p /etc/trove/conf.dchown -R trove:trove /etc/trovemkdir -p /var/lib/trovechown -R trove:trove /var/lib/trovemkdir -p /var/log/trovechown -R trove:trove /var/log/trovetouch /etc/trove/conf.d/trove-guestagent.conftouch /etc/trove/conf.d/guest_info.confvim /etc/trove/conf.d/guest_info.conf [DEFAULT]guest_id = none chown -R trove:trove /etc/trovecat /usr/lib/systemd/system/trove-guestagent.service[Unit]Description=OpenStack Trove guestagent ServiceAfter=syslog.target network.target[Service]Type=simpleUser=troveExecStart=/usr/bin/trove-guestagent --config-file /etc/trove/conf.d/trove-guestagent.conf --config-file /etc/trove/conf.d/guest_info.confRestart=on-failure[Install]WantedBy=multi-user.target[Unit]Description=OpenStack Trove guestagent ServiceAfter=syslog.target network.target[Service]Type=simpleUser=troveExecStart=/usr/bin/trove-guestagent --config-file /etc/trove/conf.d/trove-guestagent.conf --config-file /etc/trove/conf.d/guest_info.confRestart=on-failure[Install]WantedBy=multi-user.targetsystemctl 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 '' 1trove 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:4092019-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:4572019-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_secretExit code: 1Stdout: 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_password2019-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 execute2019-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_secret2019-05-29 17:17:51.381 840 ERROR trove.guestagent.datastore.mysql_common.service Exit code: 12019-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:6962019-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 _prepare2019-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 wrapper2019-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_prepare2019-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 secure2019-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 connect2019-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_connection2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     self.pool.unique_connection, _connection2019-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_connect2019-05-29 17:17:51.586 840 ERROR trove.guestagent.datastore.manager     e, dialect, self2019-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_noconnection2019-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_cause2019-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_connect2019-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_connection2019-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 _checkout2019-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 checkout2019-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_get2019-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_get2019-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_connection2019-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 __connect2019-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 connect2019-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 connect2019-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 Connect2019-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 connect2019-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_authentication2019-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_packet2019-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_error2019-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_exception2019-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:1662019-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:732019-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:1732019-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:1162019-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_incoming2019-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 dispatch2019-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_dispatch2019-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 wrapper2019-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 prepare2019-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 _prepare2019-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 wrapper2019-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_prepare2019-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 secure2019-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 connect2019-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_connection2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     self.pool.unique_connection, _connection2019-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_connect2019-05-29 17:17:51.755 840 ERROR oslo_messaging.rpc.server     e, dialect, self2019-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_noconnection2019-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_cause2019-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_connect2019-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_connection2019-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 _checkout2019-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 checkout2019-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_get2019-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_get2019-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_connection2019-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 __connect2019-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 connect2019-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 connect2019-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 Connect2019-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 connect2019-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_authentication2019-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_packet2019-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_error2019-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_exception2019-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:4092019-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:4572019-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:3722019-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:4092019-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:4572019-05-29 18:10:12.909 842 ERROR trove.common.utils [-] Command 'sudo /usr/bin/mysqladmin ping' failed.  Exit code: 1stderr: ^Gmysqladmin: connect to server at 'localhost' failederror: '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 pingExit code: 1Stdout: 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 available2019-05-29T10:09:53.608195Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2019-05-29T10:09:53.608202Z 0 [Note] InnoDB: Uses event mutexes2019-05-29T10:09:53.608205Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2019-05-29T10:09:53.608208Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112019-05-29T10:09:53.608214Z 0 [Note] InnoDB: Using Linux native AIO2019-05-29T10:09:53.608818Z 0 [Note] InnoDB: Number of pools: 12019-05-29T10:09:53.609073Z 0 [Note] InnoDB: Using CPU crc32 instructions2019-05-29T10:09:53.613009Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M2019-05-29T10:09:53.656199Z 0 [Note] InnoDB: Completed initialization of buffer pool2019-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 MB2019-05-29T10:09:56.267639Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB2019-05-29T10:09:57.808737Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile02019-05-29T10:09:57.808847Z 0 [Warning] InnoDB: New log files created, LSN=457902019-05-29T10:09:57.808872Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables2019-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 new2019-05-29T10:09:58.433915Z 0 [Note] InnoDB: Doublewrite buffer created2019-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 created2019-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 created2019-05-29T10:09:58.566609Z 0 [Note] InnoDB: Waiting for purge to start2019-05-29T10:09:58.616728Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 02019-05-29T10:09:58.617297Z 0 [Note] Plugin 'FEDERATED' is disabled.mysqld: Table 'mysql.plugin' doesn't exist2019-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*uS5temporary_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;"