<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Check this Trinath<div><a href="https://bugs.launchpad.net/keystone/+bug/860885">https://bugs.launchpad.net/keystone/+bug/860885</a></div><div><br></div><div><br></div><div>Regards,</div><div><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; font-family: 'Lucida Grande'; border-spacing: 0px; "><span class="Apple-style-span" style="font-weight: normal; font-family: Helvetica; "><b style="color: rgb(19, 112, 138); ">Razique Mahroua</b></span><span class="Apple-style-span" style="font-weight: normal; font-family: Helvetica; color: rgb(19, 112, 138); "><b> - </b></span><span class="Apple-style-span" style="font-family: Helvetica; "><span class="Apple-style-span" style="font-weight: normal; font-family: Helvetica; "><b style="color: rgb(19, 112, 138); ">Nuage & Co</b></span><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; border-collapse: separate; border-spacing: 0px; -webkit-text-decorations-in-effect: none; "><span class="Apple-style-span" style="border-collapse: separate; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="font-weight: normal; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; "><font class="Apple-style-span" color="#13708a"><a href="mailto:razique.mahroua@gmail.com">razique.mahroua@gmail.com</a></font></div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; "><font class="Apple-style-span" color="#13708a">Tel : +33 9 72 37 94 15</font></div></span><br class="Apple-interchange-newline"><span></span><span style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-weight: normal; font-style: normal; "></span><span style="color: rgb(0, 0, 0); font-weight: normal; "></span></span><span style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span><span><span><img height="125" width="125" id="b3093266-75ca-4d2d-8585-301edf930c05" apple-width="yes" apple-height="yes" src="cid:00E07450-433E-43E6-9005-48B8FD5C669F@la.fabrique"></span>
</span></span></span></span></span></span></div>
<br><div><div>Le 5 déc. 2012 à 12:08, Razique Mahroua <<a href="mailto:razique.mahroua@gmail.com">razique.mahroua@gmail.com</a>> a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite"><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">HI Trinath,<div>just add the right credentials into your .bashrc or any file the system user can source : </div><div><br></div><div><div></div><blockquote type="cite"><div><font face="Consolas">export SERVICE_TOKEN=admin</font></div><div><font face="Consolas"> </font></div><div><font face="Consolas">export OS_TENANT_NAME=admin</font></div><div><font face="Consolas">export OS_USERNAME=admin</font></div><div><font face="Consolas">export OS_PASSWORD=openstack</font></div><div><font face="Consolas">export OS_AUTH_URL=<a href="http://$keystone-IP:5000/v2.0/">http://$keystone-IP:5000/v2.0/</a></font></div><div><font face="Consolas">export SERVICE_ENDPOINT=<a href="http://$keystone-IP:35357/v2.0/">http://$keystone-IP:35357/v2.0/</a></font></div></blockquote>and it would work</div><div><br></div><div>Regards,</div><div><span class="Apple-tab-span" style="white-space: pre; "> </span></div><div><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; font-family: 'Lucida Grande'; border-spacing: 0px; "><span class="Apple-style-span" style="font-weight: normal; font-family: Helvetica; "><b style="color: rgb(19, 112, 138); ">Razique Mahroua</b></span><span class="Apple-style-span" style="font-weight: normal; font-family: Helvetica; color: rgb(19, 112, 138); "><b> - </b></span><span class="Apple-style-span" style="font-family: Helvetica; "><span class="Apple-style-span" style="font-weight: normal; font-family: Helvetica; "><b style="color: rgb(19, 112, 138); ">Nuage & Co</b></span><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; border-collapse: separate; border-spacing: 0px; -webkit-text-decorations-in-effect: none; "><span class="Apple-style-span" style="border-collapse: separate; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="font-weight: normal; font-family: Helvetica; font-size: medium; font-style: normal; "><font class="Apple-style-span" color="#13708a"><a href="mailto:razique.mahroua@gmail.com">razique.mahroua@gmail.com</a></font></div><div style="font-family: Helvetica; font-size: medium; font-style: normal; "><font class="Apple-style-span" color="#13708a">Tel : +33 9 72 37 94 15</font></div></span><br class="Apple-interchange-newline"><span></span><span style="font-family: Helvetica; font-size: medium; font-weight: normal; font-style: normal; "></span><span style="font-weight: normal; "></span></span><span style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span><span><span><span><NUAGECO-LOGO-Fblan_petit.jpg></span></span>
</span></span></span></span></span></span></div>
<br><div><div>Le 5 déc. 2012 à 12:04, Trinath Somanchi <<a href="mailto:trinath.somanchi@gmail.com">trinath.somanchi@gmail.com</a>> a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi-<div><br></div><div>Is there any way with out using the nova-client from the compute host, to access the nova database?</div><div><br></div><div>I tried, using the /nova/db/api.py and /nova/db/sqlalchemy/api.py class definitions for accessing the database but failed to get the data.</div>
<div><br></div><div><br></div><div>I get this error for the sample def. i have written.</div><div><br></div><div><div> File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 5263, in sampledata_by_host</div>
<div> filter(models.Instance.host == host_name).all()</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2115, in all</div><div> return list(self)</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__</div>
<div> return self._execute_and_instances(context)</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2240, in _execute_and_instances</div><div> close_with_result=True)</div><div>
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2231, in _connection_from_session</div><div> **kw)</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 730, in connection</div>
<div> close_with_result=close_with_result)</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 736, in _connection_for_bind</div><div> return engine.contextual_connect(**kwargs)</div>
<div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2490, in contextual_connect</div><div> self.pool.connect(),</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 224, in connect</div>
<div> return _ConnectionFairy(self).checkout()</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 387, in __init__</div><div> rec = self._connection_record = pool._do_get()</div><div>
File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 802, in _do_get</div><div> return self._create_connection()</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 188, in _create_connection</div>
<div> return _ConnectionRecord(self)</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 270, in __init__</div><div> self.connection = self.__connect()</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 330, in __connect</div>
<div> connection = self.__pool._creator()</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect</div><div> return dialect.connect(*cargs, **cparams)</div>
<div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 281, in connect</div><div> return self.dbapi.connect(*cargs, **cparams)</div><div><b>OperationalError: (OperationalError) unable to open database file None None</b></div>
</div><div><div><br></div><div>Can any one help when does this error occur and how to resolve the same.</div><div><br></div><div>Thanks in advance.</div><div><br></div>-- <br>Regards,<br>----------------------------------------------<br>
Trinath Somanchi,<div>+91 9866 235 130</div><br>
</div>
_______________________________________________<br>Mailing list: <a href="https://launchpad.net/~openstack">https://launchpad.net/~openstack</a><br>Post to : <a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>Unsubscribe : <a href="https://launchpad.net/~openstack">https://launchpad.net/~openstack</a><br>More help : <a href="https://help.launchpad.net/ListHelp">https://help.launchpad.net/ListHelp</a><br></blockquote></div><br></div></div></blockquote></div><br></div></body></html>