openstack-db does not update sql connection string in keystone.conf if not mysql

[Bill Lubanovic]

During tests to create a keystone database with "openstack-db --service keystone --init", I found an error.

In the /etc/keystone/conf file, the [sql] section contains a "connection" setting. If the value does not start with "mysql:", openstack-db prompts: "keystone default DB is not mysql. Would you like to reset to mysql now? (y/n): ". If you respond "y", it attempts to change the line with sed, but fails quietly. The sed expression only works if the connection string already contains "mysql" (with or without an initial comment "#"), not if it contains "sqlite". The "sed" line is:

    sed -i -e "s|^#* *\(\(sql_\)*connection *= *mysql://$APP\):.*@|\1:${MYSQ L_APP_PW}@|" ${APP_CONFIG}

This is on SLES11SP3, with openstack-utils release 1.1.

[Dolph Mathews (dolph)]

openstack-db and openstack-utils appears to be a proprietary Red Hat thing - I couldn't find a bug database for either project, though.

[Bill Lubanovic (bill-madscheme)]

Thanks for checking, Dolph.

Havana install doc for SLES (SuSE) also specifies use of openstack-db: http://docs.openstack.org/havana/install-guide/install/zypper/content/keystone-install.html.

bugzilla.redhat.com has some openstack-db bugs. I'll report this there.

[Bill Lubanovic (bill-madscheme)]

Reported as https://bugzilla.redhat.com/show_bug.cgi?id=1089005.