Ask Your Question

Does Openstack components (e.g.; keystone) be backed by Oracle

asked 2014-05-29 18:02:23 -0500

colossal gravatar image


Does Openstack supports databases other than mysql. I am trying oracle. It crashed while creating ec2_credential table for keystone

edit retag flag offensive close merge delete

3 answers

Sort by ยป oldest newest most voted

answered 2014-05-30 17:31:32 -0500

colossal gravatar image

It seems that the database scripts are broken/not tested for Oracle. When I ran the "keystone-manage db_sync" command it complained while creating the ec2_credential table at the first column 'access'. 'access' is a keyword in Oracle.

ec2_credential_table = sql.Table( 'ec2_credential', meta, sql.Column('access', sql.String(64), primary_key=True), sql.Column('secret', sql.String(64)), sql.Column('user_id', sql.String(64)), sql.Column('tenant_id', sql.String(64)), mysql_engine='InnoDB', mysql_charset='utf8')

I fixed this problem and it moved forward a bit. Than it start complaining about constraints in Oracle.

Another problem I noticed that it runs the whole migration process even if you are doing a fresh install. Not sure why. Can't we simply ignore migration for fresh installation ? In my MySql installation, it does not contain ec2_credential table at all which is fine. But during the migration process it tries to create tables that are no longer in use.

edit flag offensive delete link more

answered 2014-05-30 00:33:59 -0500

dbaxps gravatar image

updated 2014-05-30 01:18:20 -0500

    Oracle database is not opensource. It might be a core issue with using Oracle instead of MySQL to track Openstack database tables and tables references.  Oracle also runs OC4J ( Oracle Containers for JAVA) as part of the core Server,
what is also resource consuming operation. Oracle Web Administrative Console is actually Server side Java App deployed on system level to OC4J, which is obviously nice to have , but ...
edit flag offensive delete link more

answered 2014-05-29 18:49:28 -0500

jasonbrooks gravatar image

The docs say that any SQLAlchemy-supported db should work, and that list includes Oracle. It seems, though, that everyone uses MySQL.

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2014-05-29 18:02:23 -0500

Seen: 297 times

Last updated: May 30 '14