keystone同步时无法连接数据库的失败解决方法

问题：

root@swift:/etc/mysql/mariadb.conf.d# su -s /bin/sh -c "keystone-manage db_sync" keystone2017-05-17 21:38:28.105 5553 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 10 attempts left.2017-05-17 21:38:38.107 5553 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 9 attempts left.2017-05-17 21:38:48.117 5553 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 8 attempts left.2017-05-17 21:38:58.124 5553 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 7 attempts left.2017-05-17 21:39:08.130 5553 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 6 attempts left.2017-05-17 21:39:18.138 5553 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 5 attempts left.2017-05-17 21:39:28.144 5553 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 4 attempts left.2017-05-17 21:39:38.151 5553 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 3 attempts left.2017-05-17 21:39:48.158 5553 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 2 attempts left.2017-05-17 21:39:58.167 5553 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 1 attempts left.2017-05-17 21:40:08.171 5553 CRITICAL keystone [-] DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'swift' ([Errno 111] Connection refused)")2017-05-17 21:40:08.171 5553 ERROR keystone Traceback (most recent call last):2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/bin/keystone-manage", line 10, in2017-05-17 21:40:08.171 5553 ERROR keystone    sys.exit(main())2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 47, in main2017-05-17 21:40:08.171 5553 ERROR keystone    cli.main(argv=sys.argv, config_files=config_files)2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 1024, in main2017-05-17 21:40:08.171 5553 ERROR keystone    CONF.command.cmd_class.main()2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 403, in main2017-05-17 21:40:08.171 5553 ERROR keystone    migration_helpers.sync_database_to_version(extension, version)2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 210, in sync_database_to_version2017-05-17 21:40:08.171 5553 ERROR keystone    _sync_common_repo(version)2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 132, in _sync_common_repo2017-05-17 21:40:08.171 5553 ERROR keystone    with sql.session_for_write() as session:2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__2017-05-17 21:40:08.171 5553 ERROR keystone    return self.gen.next()2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 759, in _transaction_scope2017-05-17 21:40:08.171 5553 ERROR keystone    allow_async=self._allow_async) as resource:2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__2017-05-17 21:40:08.171 5553 ERROR keystone    return self.gen.next()2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 491, in _session2017-05-17 21:40:08.171 5553 ERROR keystone    bind=self.connection, mode=self.mode)2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 272, in _create_session2017-05-17 21:40:08.171 5553 ERROR keystone    self._start()2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 338, in _start2017-05-17 21:40:08.171 5553 ERROR keystone    engine_args, maker_args)2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 362, in _setup_for_connection2017-05-17 21:40:08.171 5553 ERROR keystone    sql_connection=sql_connection, **engine_kwargs)2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 152, in create_engine2017-05-17 21:40:08.171 5553 ERROR keystone    test_conn = _test_connection(engine, max_retries, retry_interval)2017-05-17 21:40:08.171 5553 ERROR keystone  File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 334, in _test_connection2017-05-17 21:40:08.171 5553 ERROR keystone    six.reraise(type(de_ref), de_ref)2017-05-17 21:40:08.171 5553 ERROR keystone  File "", line 2, in reraise

解决方法：

使用root登录MySQL

MariaDB [(none)]> show variables like "%char%";

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client    | utf8mb4                    |

| character_set_connection | utf8mb4                    |

| character_set_database  | utf8mb4                    |

| character_set_filesystem | binary                    |

| character_set_results    | utf8mb4                    |

| character_set_server    | utf8mb4                    |

| character_set_system    | utf8                      |

| character_sets_dir      | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.02 sec)

MariaDB [(none)]>exit

修改/etc/mysql/mariadb.conf.d/目录下的文件“50-client.cnf 50-mysql-clients.cnf   50-server.cnf”

将其中的utf8mb4修改为utf8

mariadb 修改允许远程访问

sed -i 's/127.0.0.1/0.0.0.0/g' /etc/mysql/mariadb.conf.d/50-server.cnf

重启mysql服务

service mysql restart

再次进入MySQL

MariaDB [(none)]> show variables like "%char%";

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client    | utf8                      |

| character_set_connection | utf8                      |

| character_set_database  | utf8                      |

| character_set_filesystem | binary                    |

| character_set_results    | utf8                      |

| character_set_server    | utf8                      |

| character_set_system    | utf8                      |

| character_sets_dir      | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

此时还需将原有的数据库keystone删除再重新创建

MariaDB [(none)]>drop database keystone;

Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> CREATE DATABASE keystone;

Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY '8782';

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY '8782';

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit

Bye

再进行同步数据库

root@swift:/home/swift# su -s /bin/sh -c "keystone-manage db_sync" keystone

2017-05-17 21:50:35.746 2708 INFO migrate.versioning.api [-] 66 -> 67...

2017-05-17 21:50:36.418 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.419 2708 INFO migrate.versioning.api [-] 67 -> 68...

2017-05-17 21:50:36.435 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.435 2708 INFO migrate.versioning.api [-] 68 -> 69...

2017-05-17 21:50:36.453 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.454 2708 INFO migrate.versioning.api [-] 69 -> 70...

2017-05-17 21:50:36.471 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.471 2708 INFO migrate.versioning.api [-] 70 -> 71...

2017-05-17 21:50:36.489 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.489 2708 INFO migrate.versioning.api [-] 71 -> 72...

2017-05-17 21:50:36.511 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.512 2708 INFO migrate.versioning.api [-] 72 -> 73...

2017-05-17 21:50:36.572 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.572 2708 INFO migrate.versioning.api [-] 73 -> 74...

2017-05-17 21:50:36.617 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.617 2708 INFO migrate.versioning.api [-] 74 -> 75...

2017-05-17 21:50:36.647 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.647 2708 INFO migrate.versioning.api [-] 75 -> 76...

2017-05-17 21:50:36.663 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.663 2708 INFO migrate.versioning.api [-] 76 -> 77...

2017-05-17 21:50:36.681 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.681 2708 INFO migrate.versioning.api [-] 77 -> 78...

2017-05-17 21:50:36.699 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.700 2708 INFO migrate.versioning.api [-] 78 -> 79...

2017-05-17 21:50:36.718 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.719 2708 INFO migrate.versioning.api [-] 79 -> 80...

2017-05-17 21:50:36.736 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.738 2708 INFO migrate.versioning.api [-] 80 -> 81...

2017-05-17 21:50:36.768 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.768 2708 INFO migrate.versioning.api [-] 81 -> 82...

2017-05-17 21:50:36.852 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.852 2708 INFO migrate.versioning.api [-] 82 -> 83...

2017-05-17 21:50:36.924 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.925 2708 INFO migrate.versioning.api [-] 83 -> 84...

2017-05-17 21:50:36.961 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:36.962 2708 INFO migrate.versioning.api [-] 84 -> 85...

2017-05-17 21:50:37.022 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.023 2708 INFO migrate.versioning.api [-] 85 -> 86...

2017-05-17 21:50:37.054 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.055 2708 INFO migrate.versioning.api [-] 86 -> 87...

2017-05-17 21:50:37.119 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.120 2708 INFO migrate.versioning.api [-] 87 -> 88...

2017-05-17 21:50:37.160 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.160 2708 INFO migrate.versioning.api [-] 88 -> 89...

2017-05-17 21:50:37.199 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.199 2708 INFO migrate.versioning.api [-] 89 -> 90...

2017-05-17 21:50:37.243 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.244 2708 INFO migrate.versioning.api [-] 90 -> 91...

2017-05-17 21:50:37.319 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.320 2708 INFO migrate.versioning.api [-] 91 -> 92...

2017-05-17 21:50:37.396 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.397 2708 INFO migrate.versioning.api [-] 92 -> 93...

2017-05-17 21:50:37.476 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.476 2708 INFO migrate.versioning.api [-] 93 -> 94...

2017-05-17 21:50:37.546 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.547 2708 INFO migrate.versioning.api [-] 94 -> 95...

2017-05-17 21:50:37.606 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.607 2708 INFO migrate.versioning.api [-] 95 -> 96...

2017-05-17 21:50:37.626 2708 INFO migrate.versioning.api [-] done

2017-05-17 21:50:37.627 2708 INFO migrate.versioning.api [-] 96 -> 97...

2017-05-17 21:50:37.652 2708 INFO migrate.versioning.api [-] done

root@swift:/home/swift#

最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
  • 人面猴
    序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
    沈念sama阅读 199,830评论 5赞 468
  • 死咒
    序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
    沈念sama阅读 83,992评论 2赞 376
  • 救了他两次的神仙让他今天三更去死
    文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
    开封第一讲书人阅读 146,875评论 0赞 331
  • 道士缉凶录：失踪的卖姜人
    文/不坏的土叔 我叫张陵，是天一观的道长。 经常有香客问我，道长，这世上最难降的妖魔是什么？ 我笑而不...
    开封第一讲书人阅读 53,837评论 1赞 271
  • 港岛之恋（遗憾婚礼）
    正文 为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
    茶点故事阅读 62,734评论 5赞 360
  • 恶毒庶女顶嫁案：这布局不是一般人想出来的
    文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
    开封第一讲书人阅读 48,091评论 1赞 277
  • 城市分裂传说
    那天，我揣着相机与录音，去河边找鬼。 笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。 我是一名探鬼主播，决...
    沈念sama阅读 37,550评论 3赞 390
  • 双鸳鸯连环套：你想象不到人心有多黑
    文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
    开封第一讲书人阅读 36,217评论 0赞 254
  • 万荣杀人案实录
    序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
    沈念sama阅读 40,368评论 1赞 294
  • 护林员之死
    正文 独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋 以下内容为张勋视角 年9月15日...
    茶点故事阅读 35,298评论 2赞 317
  • 白月光启示录
    正文 我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。 大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
    茶点故事阅读 37,350评论 1赞 329
  • 活死人
    序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
    沈念sama阅读 33,027评论 3赞 315
  • 日本核电站爆炸内幕
    正文 年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
    茶点故事阅读 38,623评论 3赞 303
  • 男人毒药：我在死后第九天来索命
    文/蒙蒙 一、第九天 我趴在偏房一处隐蔽的房顶上张望。 院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
    开封第一讲书人阅读 29,706评论 0赞 19
  • 一桩弑父案，背后竟有这般阴谋
    文/苍兰香墨 我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。 一阵脚步声响...
    开封第一讲书人阅读 30,940评论 1赞 255
  • 情欲美人皮
    我被黑心中介骗来泰国打工， 没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。 一个月前我还...
    沈念sama阅读 42,349评论 2赞 346
  • 代替公主和亲
    正文 我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。 传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
    茶点故事阅读 41,936评论 2赞 341

推荐阅读更多精彩内容