← Back to team overview

openstack team mailing list archive

Re: keystone-manage db_sync errors

 

I was able to resolve this issue.

Thank you,

On Thu, Feb 28, 2013 at 5:53 PM, Ashutosh Narayan <
aashutoshnarayan@xxxxxxxxx> wrote:

> 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> wrote:
>
>>  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, 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/
>
>


-- 
Ashutosh Narayan

http://ashutoshn.wordpress.com/

References