openstack team mailing list archive

[Ashutosh Narayan <aashutoshnarayan@xxxxxxxxx>]

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/