← Back to team overview

openstack team mailing list archive

Accessing Nova DB from the Compute Host

 

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

Follow ups