Possibly solved:
I found references to sqlite in the config.py file:
# sql
register_str('connection', group='sql', default='sqlite:///keystone.db')
register_int('idle_timeout', group='sql', default=200)
and thought that perhaps the "keystone-manage db_sync" command was defaulting
to some other database so I added parameter "--config-file
/etc/keystone/keystone.conf" to the keystone-manage command line and it built
my MySQL database.
> keystone-manage --config-file /etc/keystone/keystone.conf db_sync
Mark
________________________________
From: openstack-bounces+mark.m.miller=hp....@lists.launchpad.net
[openstack-bounces+mark.m.miller=hp....@lists.launchpad.net] on behalf of Dolph
Mathews [dolph.math...@gmail.com]
Sent: Tuesday, February 26, 2013 12:40 PM
To: openstack
Subject: Re: [Openstack] keystone-manage db_sync ERROR
Meant to reply on-list.
-Dolph
On Tue, Feb 26, 2013 at 2:39 PM, Dolph Mathews
<dolph.math...@gmail.com<mailto:dolph.math...@gmail.com>> wrote:
Thanks for the feedback; cc'ing Adam Young. I raised a bug to track the issue:
https://bugs.launchpad.net/keystone/+bug/1133608
-Dolph
On Tue, Feb 26, 2013 at 2:24 PM, Miller, Mark M (EB SW Cloud - R&D - Corvallis)
<mark.m.mil...@hp.com<mailto:mark.m.mil...@hp.com>> wrote:
Hello,
I have trying to install Keystone Grizzly-3 and cannot get past the following
error. The "keystone-manage db_sync" command is generating the following error.
I have tried deleting and re-creating the MySQL database (connection =
mysql://keystonedbadmin:password@15.253.59.37/keystone<http://keystonedbadmin:password@15.253.59.37/keystone>)
but the error remains. Has anyone else run into this problem and found a
solution? I noticed the role ID value 9fe2ff9ee4384b1894a90878d3e92bab in file
"/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/config.py".
Regards,
Mark
root@build-HP-Compaq-6005-Pro-SFF-PC:~/keystone-2013.1.g3/keystone-2013.1.g3#
keystone-manage db_sync
Traceback (most recent call last):
File "/usr/local/bin/keystone-manage", line 5, in <module>
pkg_resources.run_script('keystone==2013.1.g3', 'keystone-manage')
File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 499, in
run_script
self.require(requires)[0].run_script(script_name, ns)
File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 1235, in
run_script
execfile(script_filename, namespace, namespace)
File
"/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/EGG-INFO/scripts/keystone-manage",
line 28, in <module>
cli.main(argv=sys.argv, config_files=config_files)
File
"/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/cli.py",
line 172, in main
CONF.command.cmd_class.main()
File
"/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/cli.py",
line 53, in main
driver.db_sync()
File
"/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/identity/backends/sql.py",
line 171, in db_sync
migration.db_sync()
File
"/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/common/sql/migration.py",
line 52, in db_sync
return versioning_api.upgrade(CONF.sql.connection, repo_path, version)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186,
in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<string>", line 2, in _migrate
File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py",
line 159, in with_engine
return f(*a, **kw)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366,
in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line
91, in runchange
change.run(self.engine, step)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line
145, in run
script_func(engine)
File
"/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/common/sql/migrate_repo/versions/017_membership_role.py",
line 42, in upgrade
'enabled': 'True'}))
File
"/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1449, in execute
params)
File
"/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1584, in _execute_clauseelement
compiled_sql, distilled_params
File
"/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1698, in _execute_context
context)
File
"/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1691, in _execute_context
context)
File
"/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py",
line 331, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
raise errorclass, errorvalue
sqlalchemy.exc.IntegrityError: (IntegrityError) (1062, "Duplicate entry
'9fe2ff9ee4384b1894a90878d3e92bab' for key 'PRIMARY'") 'INSERT INTO role (id,
name, extra)
_______________________________________________
Mailing list: https://launchpad.net/~openstack
Post to :
openstack@lists.launchpad.net<mailto:openstack@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~openstack
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~openstack
Post to : openstack@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openstack
More help : https://help.launchpad.net/ListHelp
