安装keystone时创建用户失败
2024-10-10 17:30:05
系统:centos7.3
版本:openstack ocata
1.问题描述
安装keystone在创建用户时报错:
The request you have made requires authentication. (HTTP 401) (Request-ID: req-03560e9f-bacc-4b0f-ac00-6ee4030cab8a)
2.检查过程
1.登陆mysql,查看keystone数据库下有没有生成新表
# mysql
use keystone;
show tables;
发现keyston数据库下没有表生成,理论上运行如下语句后会生成表:
# su -s /bin/sh -c "keystone-manage db_sync" keystone
2.使用授权帐号和密码尝试登陆mysql
mysql -h localhost -u keystone -pKEYSTONE_DBPASS --登陆成功
mysql -h controller -u keystone -pKEYSTONE_DBPASS --登陆失败
理论上使用controller主机名能登陆,因为授权对象包括%和localhost
3.查看keystone日志
# vim /var/log/keystone/keystone.log
2018-07-20 13:59:29.019 2958 CRITICAL keystone [-] OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'controller' (using password: YES)")
发现keystone登陆失败信息
3.解决方法
经过多次测试,如果在mysql安全初始化时,不移除匿名用户、删除test数据库,就会出现以上授权问题,导致无法写入表
# mysql_secure_installation
Remove anonymous users? [Y/n] Y
... Success! Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network. Disallow root login remotely? [Y/n] n
... skipping. By default, MariaDB comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment. Remove test database and access to it? [Y/n] Y
- Dropping test database...
... Success!
- Removing privileges on test database...
自动脚本:
# mysql_secure_installation<<EOF n
Y
Y
Y
Y
EOF
最新文章
- [Top-Down Approach] Assignment 1: WebServer [Python]
- UICollectionView + AFNetWorking 异步加载,局部刷新.
- 使用Ajax上传图片到服务器(不刷新页面)
- 《迷宫》特点分析之NABCD
- Asp.net Mvc4 基于Authorize实现的模块权限验证方式
- 【转】IOS --- OC与Swift混编
- python对json的相关操作
- hdoj 5112 A Curious Matt
- 深入理解计算机系统第二版习题解答CSAPP 2.7
- UDP包的大小与MTU
- DateDiff函数
- java发布项目后注意小点,以及对于金额在java中的处理
- tkinter中表格的建立(十三)
- 重装系统windows10/8/7,绝对纯净版永久激活的详细步骤和固态硬盘找不到分区的原因
- Android + https 实现 文件上传
- Ubuntu 离线安装 docker
- ";Error 0162 - Setup data integrity check failure"; after updating BIOS via Thinkvantage
- DokuWiki 插件使用
- Informatic学习总结_day02_增量抽取
- ubuntu vscode chrome 显示color emoji