[Openstack] OPENSTACK[KEYSTONE]- MS SQL as Backend Store

Miller, Mark M (EB SW Cloud - R&D - Corvallis) mark.m.miller at hp.com
Wed Nov 13 16:31:17 UTC 2013


These instructions may be out of date.
Regards,
Mark Miller

MySql setup (if not already done)
Install mysql-server and python-mysqldb package:
> sudo apt-get install mysql-server python-mysqldb
Create the root password for mysql. The password used in this guide is "password"
Change the bind address from 127.0.0.1 to 0.0.0.0 in /etc/mysql/my.cnf.
Restart MySQL server to ensure that it starts listening on all interfaces.
> sudo restart mysql
Create a user named keystonedbadmin and assign a password:
> sudo mysql -uroot -ppassword -e 'CREATE USER keystonedbadmin;'
> sudo mysql -uroot -ppassword -e "SET PASSWORD FOR 'keystonedbadmin'@'%' = PASSWORD('password');"
Database setup
Create a new database and assign privileges to keystonedbadmin:
> mysql -uroot -ppassword -e 'CREATE DATABASE keystone;'
> mysql -uroot -ppassword -e "GRANT ALL PRIVILEGES ON keystone.* TO 'keystonedbadmin'@'%';"
Now build the Keystone V3 database tables

> keystone-manage --config-file /etc/keystone/keystone.conf db_sync


From: Srujana C P [mailto:srujana_cp at persistent.co.in]
Sent: Wednesday, November 13, 2013 12:14 AM
To: openstack at lists.openstack.org
Subject: [Openstack] OPENSTACK[KEYSTONE]- MS SQL as Backend Store

Hello All,

We are planning to use MS SQL Server as keystone backend store . Has anybody tried this? Can someone  share the information regarding the steps to be followed and required configurations and drivers to be installed.

Thank You,
Srujana C P

DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20131113/ec6a940e/attachment.html>


More information about the Openstack mailing list