安装openstack同步数据库时出错解决方法

最新推荐文章于 2023-06-28 16:55:26 发布
最新推荐文章于 2023-06-28 16:55:26 发布
阅读量4.5k 收藏
点赞数
文章标签： openstack ubuntu 数据库 database mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Moolight_shadow/article/details/41853889
版权

1.错误描述


root@all-in-one147:~# su -s /bin/sh -c "keystone-manage db_sync" keystone

2014-12-10 13:53:04.945 19759 CRITICAL keystone [-] OperationalError: (OperationalError) (2005, "Unknown MySQL server host 'controller' (0)") None None
2014-12-10 13:53:04.945 19759 TRACE keystone Traceback (most recent call last):
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/bin/keystone-manage", line 44, in <module>
2014-12-10 13:53:04.945 19759 TRACE keystone     cli.main(argv=sys.argv, config_files=config_files)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 307, in main
2014-12-10 13:53:04.945 19759 TRACE keystone     CONF.command.cmd_class.main()
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 74, in main
2014-12-10 13:53:04.945 19759 TRACE keystone     migration_helpers.sync_database_to_version(extension, version)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 204, in sync_database_to_version
2014-12-10 13:53:04.945 19759 TRACE keystone     _sync_common_repo(version)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 157, in _sync_common_repo
2014-12-10 13:53:04.945 19759 TRACE keystone     engine = sql.get_engine()
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/core.py", line 188, in get_engine
2014-12-10 13:53:04.945 19759 TRACE keystone     return _get_engine_facade().get_engine()
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/core.py", line 176, in _get_engine_facade
2014-12-10 13:53:04.945 19759 TRACE keystone     _engine_facade = db_session.EngineFacade.from_config(CONF)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 795, in from_config
2014-12-10 13:53:04.945 19759 TRACE keystone     retry_interval=conf.database.retry_interval)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 711, in __init__
2014-12-10 13:53:04.945 19759 TRACE keystone     **engine_kwargs)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 386, in create_engine
2014-12-10 13:53:04.945 19759 TRACE keystone     connection_trace=connection_trace
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/utils.py", line 890, in __call__
2014-12-10 13:53:04.945 19759 TRACE keystone     self._url_from_target(target), target, arg, kw)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/utils.py", line 927, in _dispatch_on
2014-12-10 13:53:04.945 19759 TRACE keystone     return self._dispatch_on_db_driver(dbname, driver, arg, kw)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/utils.py", line 981, in _dispatch_on_db_driver
2014-12-10 13:53:04.945 19759 TRACE keystone     if self._invoke_fn(fn, arg, kw) is not None:
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/utils.py", line 930, in _invoke_fn
2014-12-10 13:53:04.945 19759 TRACE keystone     return fn(*arg, **kw)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 456, in _init_events
2014-12-10 13:53:04.945 19759 TRACE keystone     realmode = engine.execute("SHOW VARIABLES LIKE 'sql_mode'").fetchone()
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1751, in execute
2014-12-10 13:53:04.945 19759 TRACE keystone     connection = self.contextual_connect(close_with_result=True)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1799, in contextual_connect
2014-12-10 13:53:04.945 19759 TRACE keystone     self.pool.connect(),
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 338, in connect
2014-12-10 13:53:04.945 19759 TRACE keystone     return _ConnectionFairy._checkout(self)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 641, in _checkout
2014-12-10 13:53:04.945 19759 TRACE keystone     fairy = _ConnectionRecord.checkout(pool)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 440, in checkout
2014-12-10 13:53:04.945 19759 TRACE keystone     rec = pool._do_get()
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 961, in _do_get
2014-12-10 13:53:04.945 19759 TRACE keystone     return self._create_connection()
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 285, in _create_connection
2014-12-10 13:53:04.945 19759 TRACE keystone     return _ConnectionRecord(self)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 411, in __init__
2014-12-10 13:53:04.945 19759 TRACE keystone     self.connection = self.__connect()
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 537, in __connect
2014-12-10 13:53:04.945 19759 TRACE keystone     connection = self.__pool._creator()
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 96, in connect
2014-12-10 13:53:04.945 19759 TRACE keystone     connection_invalidated=invalidated
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2014-12-10 13:53:04.945 19759 TRACE keystone     reraise(type(exception), exception, tb=exc_tb)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 90, in connect
2014-12-10 13:53:04.945 19759 TRACE keystone     return dialect.connect(*cargs, **cparams)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 377, in connect
2014-12-10 13:53:04.945 19759 TRACE keystone     return self.dbapi.connect(*cargs, **cparams)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
2014-12-10 13:53:04.945 19759 TRACE keystone     return Connection(*args, **kwargs)
2014-12-10 13:53:04.945 19759 TRACE keystone   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
2014-12-10 13:53:04.945 19759 TRACE keystone     super(Connection, self).__init__(*args, **kwargs2)
2014-12-10 13:53:04.945 19759 TRACE keystone OperationalError: (OperationalError) (2005, "Unknown MySQL server host 'controller' (0)") None None

2014-12-10 13:53:04.945 19759 TRACE keystone 



2.问题原因：域名解析（controller）出错  

3.处理方案：vi /etc/hosts

192.168.100.147 localhost
192.168.100.147 all-in-one147
192.168.100.147 controller

(注：192.168.100.147用本地ip代替)

gfengwong
关注
部署Openstack报错及解决办法
u010310167的博客
08-31 5277
自己在部署K版本和M版本中遇到的一些问题和解决办法整理。
OpenStack 运维 - 环境部署 | 报错排查 [T版]
serendipity_cat的博客
05-19 1247
OpenStack 运维 - 环境部署一、环境配置二、基础配置1. 配置国内YUM源2. 修改主机名及关闭防火墙3. 安装相关环境依赖包4. 调优 NAT 网卡及配置 DNS 和 映射5. 配置免交护6. 配置时间同步所有节点安装控制节点ct计算节点c1/2三、系统环境配置1. 安装及配置 MariaDB2. 安装 RabbitMQ3. 安装 memcached4. 安装etcd5. 安装OpenStack组件四、报错解决Error: unable to connect to node rabbit@loc
keystone的mysql无法进入_openstack【juno】入门 【keystone篇】六：：Keystone使用及遇到问题解决办法...
weixin_39804523的博客
02-17 258
本帖最后由 pig2 于 2015-3-26 20:30 编辑问题导读1.keystone的ADMIN_TOKEN该如何填写？2.如何查看keystone数据库?3.同步数据库遇到问题，可能有哪些原因？4.keystone创建demo租户，是否还需要创建user及role？创建租户、用户、角色，网上资料还是比较多的。这里参考管网，使用另外的方式配置环境变量配置OS_SERVICE_TOKEN这里的...
mysql权限问题 OPENSTACK无法 db sync
weixin_33695450的博客
07-06 109
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword'); sudo mysql -uroot -p$MYSQL_PASS -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OP...
openstack安装mysql无法初始化
qq_33292491的博客
05-31 354
rm -rf /etc/my.cnf rm -rf /var/lib/mysql/* rpm -qa |grep mysql 准备工作 chown -R mysql:mysql /var/lib/mysql //先初始化数据库 sudo mysql_install_db --datadir=/home/mysql --user=root --defaults-file=/etc/my.cnf....
openstak各种服务同步数据库出错问题
controllerha的博客
12-03 4184
一般来说首先想到的是配置文件下[database]中connection（配置数据库连接）的设置问题数据库名字啊，连接对象啊。 但是有时候检查却发现没有错，那么多半就是创建那个服务数据库时出错比如数据库名字问题啊，授予权限问题 通常只要把connection连接确定，大不了删掉数据库重新创建赋值便可以 我发现同步keystone的数据库还有种坑人情况，就算你connection写错了
Centos7手动安装OpenStack（Stein版）
RBK的博客
09-17 2943
文章目录准备基础服务keystone创建域、项目，用户和角色验证脚本glance准备安装配置镜像Placement基础安装配置验证Nova控制节点基础安装配置计算节点控制节点上加入计算节点验证Cinder控制节点基础安装配置计算节点配置存储节点基础安装配置备份服务验证Neutron控制节点基础安装配置linuxbridgeovs继续验证网络收尾Horizon验证测试 我已经不想写了，这几天又安装了N多遍，这次试试手动安装。 准备 基础服务 安装openstack的基础库和客户端 yum install -y
OpenStack完整安装手册
02-20
3. **MYSQL数据库服务安装**：OpenStack的一些组件如Keystone、Glance等需要数据库来存储元数据和配置信息。MySQL是常用的数据库选择。 4. **RABBITMQ消息队列服务安装**：RabbitMQ作为OpenStack的消息传递中间件，...
OpenStack安装nova组件部署（五）
weixin_51725822的博客
03-18 1103
OpenStack安装nova组件部署一、nova组件部署位置1.1、nova组件部署位置1.2、计算节点c1、c2二、控制节点 Nova 服务配置（ct）2.1、创建nova数据库，并执行授权操作2.2、管理Nova用户及服务2.2.1 创建nova用户2.2.2 把nova用户添加到service项目，拥有admin权限2.2.3 创建nova服务给Nova服务关联endpoint（端点）2.3、安装nova组件2.3.1 安装nova-api、nova-conductor、nova-novncprox
OpenStack部署T版
最新发布
weixin_46119350的博客
06-28 524
OpenStack部署T版
openstack给keystone同步数据库出错WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 8 attempts le
cow66的博客
12-04 9294
WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 8 attempts left.报错如下：Processing triggers for libc-bin ... ldconfig deferred processing now taking place * Setting up iSCSI targets
keystone的mysql无法进入_keystone 无法导入解决方法
weixin_28567617的博客
01-19 1589
keystone 无法导入解决方法su -s /bin/sh -c “keystone-manage db_sync” keystone 无法导入解决方法其中出现以下两个问题：SQL connection failed. 9 attempts left.: DBConnectionError: (pymysql.err.OperationalError) (2003, “Can’t connect...
Traceback (most recent call last): File “/usr/bin/pip3”, line 9, in from pip import main 解决
弯道超越的博客
09-29 7080
使用pip 出现以下错误: Traceback (most recent call last): File “/usr/bin/pip3”, line 9, in from pip import main 或者pip 时也出现这个问题 这是pip 10.0.0版本的BUG 注：现在这个问题好像已经解决了 解决办法 修改 /usr/bin/pip 文件 from pip imp...
Traceback (most recent call last): File "/usr/local/bin/pip", line 9, in <module>
weixin_41020960的博客
03-20 1万+
执行pip命令出出现一下问题： Traceback (most recent call last): File "/usr/local/bin/pip", line 9, in <module> load_entry_point('pip==7.1.0', 'console_scripts', 'pip')() File "build/bdist.linux-x86_...
python问题 Traceback (most recent call last)
热门推荐
weixin_43978056的博客
05-11 130万+
python运行问题Traceback (most recent call last) 出现报错 traceback(most recent call last) ...... ...... importError:No module named lxml 解决方案一般是打开cmd 执行命令pip install xxxx(缺失的包，例如lxml) 当然也有例外的，具体可参考下面的问题及其解决...
【Python】【pip问题】Traceback (most recent call last): File "/usr/bin/pip", line 9, in <module>
王博（Kings）的博客
08-19 1万+
错误 输入 pip install numpy 出现错误 解决办法 sudo vi /usr/bin/pip from pip import main if __name__ == '__main__': sys.exit(main()) 第9行，11行都要修改 from pip import __main__ //修改 if __name_...
ｌｉｎｕｘ解决Traceback (most recent call last): File "/usr/bin/pip3", line 11, in <module> sys.exit(
雨落狮山山亦奇的个人博客
10-05 2万+
sudo apt-get install python3-pip
Ubuntu 20.4 + OpenStack 安装教程含DB数据库
"该资源包含一个近3GB的压缩包，其中包括OpenStack的一键安装包、Ubuntu 20.4操作系统ISO镜像以及DB...确保遵循最佳实践和安全建议，特别是在处理操作系统安装和数据库设置时，可以避免潜在的故障并提高系统的可靠性。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值