[Openstack] keystone-manage db_sync errors
Atul Jha
Atul.Jha at csscorp.com
Thu Feb 28 12:47:51 UTC 2013
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 at gmail.com]
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 at csscorp.com<mailto:Atul.Jha at csscorp.com>> wrote:
Looks like database connection error.
________________________________
From: openstack-bounces+atul.jha=csscorp.com at lists.launchpad.net<mailto:csscorp.com at lists.launchpad.net> [openstack-bounces+atul.jha=csscorp.com at lists.launchpad.net<mailto:csscorp.com at lists.launchpad.net>] on behalf of Ashutosh Narayan [aashutoshnarayan at gmail.com<mailto:aashutoshnarayan at gmail.com>]
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 at 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
More information about the Openstack
mailing list