← Back to team overview

openstack team mailing list archive

Re: keystone-manage db_sync errors

 

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.


Ø  keystone-manage --config-file /etc/keystone/keystone.conf db_sync

Mark

From: openstack-bounces+mark.m.miller=hp.com@xxxxxxxxxxxxxxxxxxx [mailto:openstack-bounces+mark.m.miller=hp.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of Atul Jha
Sent: Thursday, February 28, 2013 4:19 AM
To: Ashutosh Narayan; OpenStack
Subject: Re: [Openstack] keystone-manage db_sync errors

Looks like database connection error.
________________________________
From: openstack-bounces+atul.jha=csscorp.com@xxxxxxxxxxxxxxxxxxx [openstack-bounces+atul.jha=csscorp.com@xxxxxxxxxxxxxxxxxxx] on behalf of Ashutosh Narayan [aashutoshnarayan@xxxxxxxxx]
Sent: Thursday, February 28, 2013 5:42 PM
To: OpenStack
Subject: [Openstack] keystone-manage db_sync errors
Hi folks,

I following the instructions to install OpenStack on CentOS 6.3
mentioned on this link<http://docs.openstack.org/folsom/openstack-compute/install/yum/content/install-keystone.html> . I am getting following errors when I execute
keystone-manage db_sync command.

[root@RLD1OPST01 ~]# keystone-manage db_sync
Traceback (most recent call last):
  File "/usr/bin/keystone-manage", line 28, in <module>
    cli.main(argv=sys.argv, config_files=config_files)
  File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 164, in main
    return run(cmd, (args[:1] + args[2:]))
  File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 147, in run
    return CMDS[cmd](argv=args).run()
  File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 35, in run
    return self.main()
  File "/usr/lib/python2.6/site-packages/keystone/cli.py", line 56, in main
    driver.db_sync()
  File "/usr/lib/python2.6/site-packages/keystone/identity/backends/sql.py", line 136, in db_sync
    migration.db_sync()
  File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 49, in db_sync
    current_version = db_version()
  File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 63, in db_version
    return db_version_control(0)
  File "/usr/lib/python2.6/site-packages/keystone/common/sql/migration.py", line 68, in db_version_control
    versioning_api.version_control(CONF.sql.connection, repo_path, version)
  File "<string>", line 2, in version_control
  File "/usr/lib/python2.6/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
    return f(*a, **kw)
  File "/usr/lib/python2.6/site-packages/migrate/versioning/api.py", line 248, in version_control
    ControlledSchema.create(engine, repository, version)
  File "/usr/lib/python2.6/site-packages/migrate/versioning/schema.py", line 137, in create
    table = cls._create_table_version(engine, repository, version)
  File "/usr/lib/python2.6/site-packages/migrate/versioning/schema.py", line 178, in _create_table_version
    if not table.exists():
  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/schema.py", line 579, in exists
    self.name<http://self.name>, schema=self.schema)
  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
    conn = self.contextual_connect()
  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
    self.pool.connect(),
  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 224, in connect
    return _ConnectionFairy(self).checkout()
  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 387, in __init__
    rec = self._connection_record = pool._do_get()
  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
    con = self._create_connection()
  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
    return _ConnectionRecord(self)
  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 270, in __init__
    self.connection = self.__connect()
  File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/pool.py", line 330, in __connect
    connection = self.__pool._creator()
  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
    return dialect.connect(*cargs, **cparams)
  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
    return self.dbapi.connect(*cargs, **cparams)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (OperationalError) (1045, "Access denied for user 'keystone'@'RLD1OPST01' (using password: YES)") None None

Where am I going wrong ?
Please suggest.

Thank you,
--
Ashutosh Narayan

http://ashutoshn.wordpress.com/
http://www.csscorp.com/common/email-disclaimer.php

References