Hi Atul,<div><br></div><div>There was an <a href="http://docs.openstack.org/folsom/openstack-compute/install/yum/content/install-keystone.html">instruction </a>mentioning -- After installing, openstack-utils openstack-keystone python-keystoneclient packages, <div>
we need to delete the sqlite database it
    creates, then change the configuration to point to a MySQL
    database.</div><div>How can I achieve this ?<br><br><div class="gmail_quote">On Thu, Feb 28, 2013 at 5:48 PM, Atul Jha <span dir="ltr"><<a href="mailto:Atul.Jha@csscorp.com" target="_blank">Atul.Jha@csscorp.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">




<div>
<div style="direction:ltr;font-size:10pt;font-family:Tahoma">Looks like database connection error.<br>
<div style="font-size:16px;font-family:Times New Roman">
<hr>
<div style="direction:ltr"><font color="#000000" face="Tahoma"><b>From:</b> openstack-bounces+atul.jha=<a href="mailto:csscorp.com@lists.launchpad.net" target="_blank">csscorp.com@lists.launchpad.net</a> [openstack-bounces+atul.jha=<a href="mailto:csscorp.com@lists.launchpad.net" target="_blank">csscorp.com@lists.launchpad.net</a>] on behalf of Ashutosh Narayan [<a href="mailto:aashutoshnarayan@gmail.com" target="_blank">aashutoshnarayan@gmail.com</a>]<br>

<b>Sent:</b> Thursday, February 28, 2013 5:42 PM<br>
<b>To:</b> OpenStack<br>
<b>Subject:</b> [Openstack] keystone-manage db_sync errors<br>
</font><br>
</div><div><div class="h5">
<div></div>
<div><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">Hi folks,</span>
<div style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">
<br>
</div>
<div style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">
I following the instructions to install OpenStack on CentOS 6.3</div>
<div style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">
mentioned on this <a href="http://docs.openstack.org/folsom/openstack-compute/install/yum/content/install-keystone.html" style="color:rgb(17,85,204)" target="_blank">link</a> . I am getting following errors when I execute</div>

<div style><font color="#222222" face="arial, sans-serif">keystone-manage db_sync command.</font></div>
<div style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">
<br>
</div>
<div>
<div>[root@RLD1OPST01 ~]# keystone-manage db_sync</div>
<div>Traceback (most recent call last):</div>
<div>  File "/usr/bin/keystone-manage", line 28, in <module></div>
<div>    cli.main(argv=sys.argv, config_files=config_files)</div>
<div>  File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 164, in main</div>
<div>    return run(cmd, (args[:1] + args[2:]))</div>
<div>  File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 147, in run</div>
<div>    return CMDS[cmd](argv=args).run()</div>
<div>  File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 35, in run</div>
<div>    return self.main()</div>
<div>  File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 56, in main</div>
<div>    driver.db_sync()</div>
<div>  File "/usr/lib/python2.6/site-packages/keystone/identity/backends/sql.py", line 136, in db_sync</div>
<div>    migration.db_sync()</div>
<div>  File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 49, in db_sync</div>
<div>    current_version = db_version()</div>
<div>  File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 63, in db_version</div>
<div>    return db_version_control(0)</div>
<div>  File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 68, in db_version_control</div>
<div>    versioning_api.version_control(CONF.sql.connection, repo_path, version)</div>
<div>  File "<string>", line 2, in version_control</div>
<div>  File "/usr/lib/python2.6/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine</div>
<div>    return f(*a, **kw)</div>
<div>  File "/usr/lib/python2.6/site-packages/migrate/versioning/api.py", line 248, in version_control</div>
<div>    ControlledSchema.create(engine, repository, version)</div>
<div>  File "/usr/lib/python2.6/site-packages/migrate/versioning/schema.py", line 137, in create</div>
<div>    table = cls._create_table_version(engine, repository, version)</div>
<div>  File "/usr/lib/python2.6/site-packages/migrate/versioning/schema.py", line 178, in _create_table_version</div>
<div>    if not table.exists():</div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/schema.py", line 579, in exists</div>
<div>    <a href="http://self.name" target="_blank">self.name</a>, schema=self.schema)</div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 2424, in run_callable</div>
<div>    conn = self.contextual_connect()</div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 2490, in contextual_connect</div>
<div>    self.pool.connect(), </div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 224, in connect</div>
<div>    return _ConnectionFairy(self).checkout()</div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 387, in __init__</div>
<div>    rec = self._connection_record = pool._do_get()</div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 741, in _do_get</div>
<div>    con = self._create_connection()</div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 188, in _create_connection</div>
<div>    return _ConnectionRecord(self)</div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 270, in __init__</div>
<div>    self.connection = self.__connect()</div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 330, in __connect</div>
<div>    connection = self.__pool._creator()</div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/strategies.py", line 80, in connect</div>
<div>    return dialect.connect(*cargs, **cparams)</div>
<div>  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 281, in connect</div>
<div>    return self.dbapi.connect(*cargs, **cparams)</div>
<div>  File "/usr/lib64/python2.6/site-packages/MySQLdb/__init__.py", line 81, in Connect</div>
<div>    return Connection(*args, **kwargs)</div>
<div>  File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 187, in __init__</div>
<div>    super(Connection, self).__init__(*args, **kwargs2)</div>
<div>sqlalchemy.exc.OperationalError: (OperationalError) (1045, "Access denied for user 'keystone'@'RLD1OPST01' (using password: YES)") None None</div>
</div>
<div><br>
</div>
<div>Where am I going wrong ?</div>
<div>Please suggest.</div>
<div><br>
</div>
<div>Thank you,</div>
-- <br>
Ashutosh Narayan<br>
<br>
<a href="http://ashutoshn.wordpress.com/" target="_blank">http://ashutoshn.wordpress.com/</a><br>
<br>
</div>
</div></div></div>
</div>
<a href="http://www.csscorp.com/common/email-disclaimer.php" target="_blank">http://www.csscorp.com/common/email-disclaimer.php</a>
</div>

</blockquote></div><br><br clear="all"><div><br></div>-- <br>Ashutosh Narayan<br><br><a href="http://ashutoshn.wordpress.com/" target="_blank">http://ashutoshn.wordpress.com/</a><br><br>
</div></div>