keystone 同步数据库keystone-manage db_sync出错

[yalyka]

根据大神写的教程，安装时执行了如下步骤：

安装mysql

apt-get install -y mysql-server python-mysqldb

让mysql支持外部访问

sed -i 's/127.0.0.1/0.0.0.0/g' /etc/mysql/my.cnf （该步骤执行成功！）

service mysql restart

创建nova，keystone，glance数据库

mysql -uroot -p
CREATE DATABASE nova;
GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'%' IDENTIFIED BY 'password';
CREATE DATABASE glance;
GRANT ALL PRIVILEGES ON glance.* TO 'glance'@'%' IDENTIFIED BY 'password';
CREATE DATABASE keystone;
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY 'password';
quit

1：安装keystone
apt-get install -y keystone python-keystone python-keystoneclient
2：配置keystone
需要修改 /etc/keystone/keystone.conf 3个地方
默认定义的token就是ADMIN，改成：1234567890
[DEFAULT]
bind_host = 0.0.0.0
public_port = 5000
admin_port = 35357
#admin_token = ADMIN
admin_token =1234567890
mysql的连接，默认是采用sqlite
[sql]
#connection = sqlite:////var/lib/keystone/keystone.db
connection= mysql://keystone:password@172.16.10.6:3306/keystone（此处若我修改172.16.10.6改为127.0.0.1则成功，所以应该不是权限的问题？？而是这个地址不对？而这个地址是我配置eth0的地址）
idle_timeout = 200
修改catalog
[catalog]
#driver = keystone.catalog.backends.sql.Catalog
driver = keystone.catalog.backends.templated.TemplatedCatalog
template_file = /etc/keystone/default_catalog.templates

但是在同步keystone数据库时执行keystone-manage db_sync出错，错误如下


显示mysql链接错误？求大神帮忙....已经卡在这里5天了T^T^T^T^T^T

[yalyka]

再补充一点，由于家里是路由，后改地址为192.168.1.102仍不成功 auto eth0 iface eth0 inet static post-up ifconfig dummy0 0.0.0.0 address 192.168.1.102 netmask 255.255.255.0 network 192.168.1.0 broadcast 192.168.1.255 gateway 192.168.1.1 综上，我觉得问题大多出在mysql是不是能允许外部访问，然而已经给keystone grant all privileges并且将mysql的bind设为0.0.0.0

[yalyka]

T^T请大家一定帮忙，新手真的太苦恼了

[maojd]

你好，楼主，解决了吗。可以分享一下解决方法吗？我的也是这步同步了，我改成127.0.0.1也不行

[maojd]

我也遇到了这个问题。分享一下解决方法：
//查看/var/log/keystone/keystone.log

2015-05-27 11:33:03.812 3202 TRACE keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 285, in _create_connection
2015-05-27 11:33:03.812 3202 TRACE keystone     return _ConnectionRecord(self)
2015-05-27 11:33:03.812 3202 TRACE keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 411, in __init__
2015-05-27 11:33:03.812 3202 TRACE keystone     self.connection = self.__connect()
2015-05-27 11:33:03.812 3202 TRACE keystone   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 537, in __connect
2015-05-27 11:33:03.812 3202 TRACE keystone     connection = self.__pool._creator()
2015-05-27 11:33:03.812 3202 TRACE keystone   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/compat/handle_error.py", line 200, in connect
2015-05-27 11:33:03.812 3202 TRACE keystone     raise original_exception
2015-05-27 11:33:03.812 3202 TRACE keystone OperationalError: (OperationalError) (1184, "Aborted connection 4 to db: 'keystone' user: 'keystone' host: 'controller' (init_connect command failed)") None None

以为是数据库mysql -h controller -u keystone -p连接不上的问题。执行
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'controller' \
IDENTIFIED BY 'password';
可以连接上了。还是执行报错
//查看mysql log
150527 15:38:55 [Warning] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '='SET NAMES utf8'' at line 1
//mysql配置文件有utf8.发现多了一个=号，删除。重启数据库 service mariadb restart
解决

[rleno]

楼主你好，请问下你那个同步的问题最后是如何解决的呢？小弟现在也在搭建环境，遇到和你一样的问题，不知道如何解决，请指导迷津呀

[longtest]

mariadb 修改允许远程访问 sed -i 's/127.0.0.1/0.0.0.0/g' /etc/mysql/mariadb.conf.d/50-server.cnf 就可以了。我之前配过ubuntu 12.04的但节点和多节点部署。 最近尝试了下ubuntu 16.04。看到这里有问题，就顺手回下