← Back to team overview

openstack team mailing list archive

Re: Accessing Nova DB from the Compute Host

 

Hi-

I have added the correct credentials with respect to my setup.

But still the same error exists.

Kindly help me resolve the issue.

-
Trinath


On Wed, Dec 5, 2012 at 4:38 PM, Razique Mahroua
<razique.mahroua@xxxxxxxxx>wrote:

> HI Trinath,
> just add the right credentials into your .bashrc or any file the system
> user can source :
>
> export SERVICE_TOKEN=admin
>
> export OS_TENANT_NAME=admin
> export OS_USERNAME=admin
> export OS_PASSWORD=openstack
> export OS_AUTH_URL=http://$keystone-IP:5000/v2.0/
> export SERVICE_ENDPOINT=http://$keystone-IP:35357/v2.0/
>
> and it would work
>
> Regards,
>  *Razique Mahroua** - **Nuage & Co*
> razique.mahroua@xxxxxxxxx
> Tel : +33 9 72 37 94 15
>
>
> Le 5 déc. 2012 à 12:04, Trinath Somanchi <trinath.somanchi@xxxxxxxxx> a
> écrit :
>
> Hi-
>
> Is there any way with out using the nova-client from the compute host, to
> access the nova database?
>
> 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.
>
>
> I get this error for the sample def. i have written.
>
>  File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line
> 5263, in sampledata_by_host
>     filter(models.Instance.host == host_name).all()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
> 2115, in all
>     return list(self)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
> 2227, in __iter__
>     return self._execute_and_instances(context)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
> 2240, in _execute_and_instances
>     close_with_result=True)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
> 2231, in _connection_from_session
>     **kw)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
> 730, in connection
>     close_with_result=close_with_result)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
> 736, in _connection_for_bind
>     return engine.contextual_connect(**kwargs)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
> 2490, in contextual_connect
>     self.pool.connect(),
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 224, in
> connect
>     return _ConnectionFairy(self).checkout()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 387, in
> __init__
>     rec = self._connection_record = pool._do_get()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 802, in
> _do_get
>     return self._create_connection()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 188, in
> _create_connection
>     return _ConnectionRecord(self)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 270, in
> __init__
>     self.connection = self.__connect()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 330, in
> __connect
>     connection = self.__pool._creator()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py",
> line 80, in connect
>     return dialect.connect(*cargs, **cparams)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
> line 281, in connect
>     return self.dbapi.connect(*cargs, **cparams)
> *OperationalError: (OperationalError) unable to open database file None
> None*
>
> Can any one help when does this error occur and how to resolve the same.
>
> Thanks in advance.
>
> --
> Regards,
> ----------------------------------------------
> Trinath Somanchi,
> +91 9866 235 130
>
>  _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp
>
>
>


-- 
Regards,
----------------------------------------------
Trinath Somanchi,
+91 9866 235 130

JPEG image


Follow ups

References