[Openstack-devel] keystone-manage : Permission problem

[Alexey Eromenko]

Trying to setup dashboard, according to:
http://wiki.openstack.org/OpenStackDashboard

myuser at nova-server1:~$ keystone-manage token add 999888777666 admin
admin 2015-02-05T00:00
WARNING:root:Database (sqlite:////var/lib/keystone/keystone.db) is not
version controlled; run `keystone-manage sync_database` or override
your migrate version manually (see docs)
ERROR: (OperationalError) unable to open database file None None
ERROR:keystone.manage:(OperationalError) unable to open database file None None
Traceback (most recent call last):
  File "/usr/bin/keystone-manage", line 24, in <module>
    keystone.manage.main()
  File "/usr/lib/python2.7/dist-packages/keystone/manage/__init__.py",
line 483, in main
    process(*parse_args(args))
  File "/usr/lib/python2.7/dist-packages/keystone/manage/__init__.py",
line 106, in parse_args
    db.configure_backends()
  File "/usr/lib/python2.7/dist-packages/keystone/backends/__init__.py",
line 53, in configure_backends
    backend_module.configure_backend(backend_conf)
  File "/usr/lib/python2.7/dist-packages/keystone/backends/sqlalchemy/__init__.py",
line 158, in configure_backend
    _DRIVER = Driver(conf)
  File "/usr/lib/python2.7/dist-packages/keystone/backends/sqlalchemy/__init__.py",
line 53, in __init__
    self._init_engine(model_list)
  File "/usr/lib/python2.7/dist-packages/keystone/backends/sqlalchemy/__init__.py",
line 77, in _init_engine
    self._init_tables(model_list)
  File "/usr/lib/python2.7/dist-packages/keystone/backends/sqlalchemy/__init__.py",
line 129, in _init_tables
    checkfirst=True)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line
2535, in create_all
    tables=tables)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 2230, in _run_visitor
    conn = self.contextual_connect(close_with_result=False)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 2340, in contextual_connect
    self.pool.connect(),
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
210, in connect
    return _ConnectionFairy(self).checkout()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
371, in __init__
    rec = self._connection_record = pool._do_get()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
758, in _do_get
    return self._create_connection()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
174, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
256, in __init__
    self.connection = self.__connect()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
316, 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 280, in connect
    return self.dbapi.connect(*cargs, **cparams)
sqlalchemy.exc.OperationalError: (OperationalError) unable to open
database file None None


===============
*** Database config
===============
myuser at nova-server1:~/horizon/openstack-dashboard$ cat
/etc/keystone/keystone.conf | grep -i sql
# Default: 'sqlite'
# Available choices are 'sqlite' [future will include LDAP, PAM, etc]
default_store = sqlite
backends = keystone.backends.sqlalchemy
[keystone.backends.sqlalchemy]
# SQLAlchemy connection string for the reference implementation registry
# server. Any valid SQLAlchemy connection string is fine.
sql_connection = sqlite:////var/lib/keystone/keystone.db
# Period in seconds after which SQLAlchemy should reestablish its connection
sql_idle_timeout = 30

File Check:

myuser at nova-server1:~$ ls /var/lib/keystone/keystone.db
ls: cannot access /var/lib/keystone/keystone.db: Permission denied

root at nova-server1:~# ls -la /var/lib/keystone/keystone.db
-rw-r--r-- 1 root root 28672 Feb 21 03:44 /var/lib/keystone/keystone.db

-- 
-Alexey Eromenko "Technologov"