← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1308775] [NEW] openstack-db does not update sql connection string in keystone.conf if not mysql

 

Public bug reported:

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.

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1308775

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

Status in OpenStack Identity (Keystone):
  New

Bug description:
  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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1308775/+subscriptions


Follow ups

References