<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi,<br>any help will be highly appreciated.<br><br>I am following <a href="http://docs.openstack.org/trunk/openstack-compute/install/apt/content/install-keystone.html." target="_blank">http://docs.openstack.org/trunk/openstack-compute/install/apt/content/install-keystone.html.</a> <br><br>mysql> select User,Host from mysql.user;<br>+------------------+-------------------+<br>| User | Host |<br>+------------------+-------------------+<br>| keystone | % |<br>| root | 127.0.0.1 |<br>| root | ::1 |<br>| | localhost |<br>| debian-sys-maint | localhost |<br>| keystone | localhost |<br>| root | localhost |<br>| | ubu-a.arindam.com |<br>| root | ubu-a.arindam.com |<br>+------------------+-------------------+<br>9 rows in set (0.00 sec)<br><br>root@ubu-a:~# cat /etc/keystone/keystone.conf | grep connection<br># The SQLAlchemy connection string used to connect to the database<br>connection = mysql://keystone:keystone@192.168.122.10/keystone<br><br>root@ubu-a:~# cat /etc/mysql/my.cnf | grep 0.0.0.0<br>bind-address = 0.0.0.0<br><br>I am getting this error:<br><br>root@ubu-a:~# keystone-manage db_sync<br>Traceback (most recent call last):<br> File "/usr/bin/keystone-manage", line 28, in <module><br> cli.main(argv=sys.argv, config_files=config_files)<br> File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 164, in main<br> return run(cmd, (args[:1] + args[2:]))<br> File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 147, in run<br> return CMDS[cmd](argv=args).run()<br> File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 35, in run<br> return self.main()<br> File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 56, in main<br> driver.db_sync()<br> File "/usr/lib/python2.7/dist-packages/keystone/identity/backends/sql.py", line 136, in db_sync<br> migration.db_sync()<br> File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration.py", line 49, in db_sync<br> current_version = db_version()<br> File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration.py", line 63, in db_version<br> return db_version_control(0)<br> File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration.py", line 68, in db_version_control<br> versioning_api.version_control(CONF.sql.connection, repo_path, version)<br> File "<string>", line 2, in version_control<br> File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 159, in with_engine<br> return f(*a, **kw)<br> File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 250, in version_control<br> ControlledSchema.create(engine, repository, version)<br> File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 139, in create<br> table = cls._create_table_version(engine, repository, version)<br> File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 180, in _create_table_version<br> if not table.exists():<br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 579, in exists<br> self.name, schema=self.schema)<br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2424, in run_callable<br> conn = self.contextual_connect()<br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2490, in contextual_connect<br> self.pool.connect(), <br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 224, in connect<br> return _ConnectionFairy(self).checkout()<br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 387, in __init__<br> rec = self._connection_record = pool._do_get()<br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 741, in _do_get<br> con = self._create_connection()<br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 188, in _create_connection<br> return _ConnectionRecord(self)<br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 270, in __init__<br> self.connection = self.__connect()<br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 330, in __connect<br> connection = self.__pool._creator()<br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect<br> return dialect.connect(*cargs, **cparams)<br> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 281, in connect<br> return self.dbapi.connect(*cargs, **cparams)<br> File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect<br> return Connection(*args, **kwargs)<br> File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__<br> super(Connection, self).__init__(*args, **kwargs2)<br>sqlalchemy.exc.OperationalError: (OperationalError) (1045, "Access denied for user 'keystone'@'ubu-a.arindam.com' (using password: YES)") None None<br><br><br><br> </div></body>
</html>