<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]><style id=owaParaStyle>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1690251699;
mso-list-type:hybrid;
mso-list-template-ids:560995168 -1606009584 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-start-at:25;
mso-level-number-format:bullet;
mso-level-text:\F0D8;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;
font-family:Wingdings;
mso-fareast-font-family:Calibri;
mso-bidi-font-family:Arial;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I had difficulty with the db_sync command and had to specify the keystone.conf file. I think it was trying to access a sqlite database even though I am using
MySQL.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoListParagraph" style="margin-left:.75in;text-indent:-.25in;mso-list:l0 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Wingdings;color:#333333"><span style="mso-list:Ignore">Ø<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">keystone-manage --config-file /etc/keystone/keystone.conf db_sync<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">Mark</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> openstack-bounces+mark.m.miller=hp.com@lists.launchpad.net [mailto:openstack-bounces+mark.m.miller=hp.com@lists.launchpad.net]
<b>On Behalf Of </b>Atul Jha<br>
<b>Sent:</b> Thursday, February 28, 2013 4:19 AM<br>
<b>To:</b> Ashutosh Narayan; OpenStack<br>
<b>Subject:</b> Re: [Openstack] keystone-manage db_sync errors<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">Looks like database connection error.<o:p></o:p></span></p>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="color:black">
<hr size="2" width="100%" align="center">
</span></div>
<div id="divRpF583251">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black"> openstack-bounces+atul.jha=csscorp.com@lists.launchpad.net
[openstack-bounces+atul.jha=csscorp.com@lists.launchpad.net] on behalf of Ashutosh Narayan [aashutoshnarayan@gmail.com]<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</span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222;background:white">Hi folks,</span><span style="color:black">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222">I following the instructions to install OpenStack on CentOS 6.3<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222">mentioned on this <a href="http://docs.openstack.org/folsom/openstack-compute/install/yum/content/install-keystone.html" target="_blank"><span style="color:#1155CC">link</span></a> .
I am getting following errors when I execute<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-family:"Arial","sans-serif";color:#222222">keystone-manage db_sync command.</span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222"><o:p> </o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="color:black">[root@RLD1OPST01 ~]# keystone-manage db_sync<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Traceback (most recent call last):<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/bin/keystone-manage", line 28, in <module><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> cli.main(argv=sys.argv, config_files=config_files)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 164, in main<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> return run(cmd, (args[:1] + args[2:]))<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 147, in run<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> return CMDS[cmd](argv=args).run()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 35, in run<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> return self.main()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 56, in main<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> driver.db_sync()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/keystone/identity/backends/sql.py", line 136, in db_sync<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> migration.db_sync()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 49, in db_sync<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> current_version = db_version()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 63, in db_version<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> return db_version_control(0)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 68, in db_version_control<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> versioning_api.version_control(CONF.sql.connection, repo_path, version)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "<string>", line 2, in version_control<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> return f(*a, **kw)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/migrate/versioning/api.py", line 248, in version_control<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> ControlledSchema.create(engine, repository, version)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/migrate/versioning/schema.py", line 137, in create<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> table = cls._create_table_version(engine, repository, version)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib/python2.6/site-packages/migrate/versioning/schema.py", line 178, in _create_table_version<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> if not table.exists():<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/schema.py", line 579, in exists<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> <a href="http://self.name" target="_blank">
self.name</a>, schema=self.schema)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> 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<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> conn = self.contextual_connect()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> 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<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> self.pool.connect(), <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 224, in connect<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> return _ConnectionFairy(self).checkout()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 387, in __init__<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> rec = self._connection_record = pool._do_get()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> 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<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> con = self._create_connection()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> 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<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> return _ConnectionRecord(self)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 270, in __init__<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> self.connection = self.__connect()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 330, in __connect<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> connection = self.__pool._creator()<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> 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<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> return dialect.connect(*cargs, **cparams)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> 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<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> return self.dbapi.connect(*cargs, **cparams)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib64/python2.6/site-packages/MySQLdb/__init__.py", line 81, in Connect<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> return Connection(*args, **kwargs)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 187, in __init__<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> super(Connection, self).__init__(*args, **kwargs2)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">sqlalchemy.exc.OperationalError: (OperationalError) (1045, "Access denied for user 'keystone'@'RLD1OPST01' (using password: YES)") None None<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Where am I going wrong ?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Please suggest.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Thank you,<o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="color:black">-- <br>
Ashutosh Narayan<br>
<br>
<a href="http://ashutoshn.wordpress.com/" target="_blank">http://ashutoshn.wordpress.com/</a><o:p></o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal">http://www.csscorp.com/common/email-disclaimer.php <o:p></o:p></p>
</div>
</body>
</html>