← Back to team overview

openstack team mailing list archive

Re: keystone-manage db_sync errors

 

Ashutosh,

1. Install the packages
2. create the database manually, the guide says how.
3. change the keystone configuration file to match
4. restart the services
5. run the keysone sync command

Let me know if it works. I don`t have a Centos/Yum machine to test it this side. :(
________________________________________
From: Ashutosh Narayan [aashutoshnarayan@xxxxxxxxx]
Sent: Thursday, February 28, 2013 5:53 PM
To: Atul Jha; OpenStack
Subject: Re: [Openstack] keystone-manage db_sync errors

Hi Atul,

There was an instruction <http://docs.openstack.org/folsom/openstack-compute/install/yum/content/install-keystone.html> mentioning -- After installing, openstack-utils openstack-keystone python-keystoneclient packages,
we need to delete the sqlite database it creates, then change the configuration to point to a MySQL database.
How can I achieve this ?

On Thu, Feb 28, 2013 at 5:48 PM, Atul Jha <Atul.Jha@xxxxxxxxxxx<mailto:Atul.Jha@xxxxxxxxxxx>> wrote:
Looks like database connection error.
________________________________
From: openstack-bounces+atul.jha=csscorp.com@xxxxxxxxxxxxxxxxxxx<mailto:csscorp.com@xxxxxxxxxxxxxxxxxxx> [openstack-bounces+atul.jha=csscorp.com@xxxxxxxxxxxxxxxxxxx<mailto:csscorp.com@xxxxxxxxxxxxxxxxxxx>] on behalf of Ashutosh Narayan [aashutoshnarayan@xxxxxxxxx<mailto: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



--
Ashutosh Narayan

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


References