<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal" style="mso-margin-top-alt:12.0pt;margin-right:0in;margin-bottom:1.2pt;margin-left:0in;background:white">
<span style="font-family:"Arial","sans-serif";color:black">These instructions may be out of date.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:12.0pt;margin-right:0in;margin-bottom:1.2pt;margin-left:0in;background:white">
<span style="font-family:"Arial","sans-serif";color:black">Regards,<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:12.0pt;margin-right:0in;margin-bottom:1.2pt;margin-left:0in;background:white">
<span style="font-family:"Arial","sans-serif";color:black">Mark Miller<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:12.0pt;margin-right:0in;margin-bottom:1.2pt;margin-left:0in;background:white">
<b><span style="font-family:"Arial","sans-serif";color:black"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="mso-margin-top-alt:12.0pt;margin-right:0in;margin-bottom:1.2pt;margin-left:0in;background:white">
<b><span style="font-family:"Arial","sans-serif";color:black">MySql setup (if not already done)<o:p></o:p></span></b></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">Install mysql-server and python-mysqldb package:<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">> sudo apt-get install mysql-server python-mysqldb<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">Create the root password for mysql. The password used in this guide is "password"<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">Change the bind address from 127.0.0.1 to 0.0.0.0 in /etc/mysql/my.cnf.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">Restart MySQL server to ensure that it starts listening on all interfaces.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">> sudo restart mysql<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">Create a user named keystonedbadmin and assign a password:<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">> sudo mysql -uroot -ppassword -e ’CREATE USER keystonedbadmin;’<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">> sudo mysql -uroot -ppassword -e "SET PASSWORD FOR ’keystonedbadmin’@’%’ = PASSWORD(’password’);"<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:12.0pt;margin-right:0in;margin-bottom:1.2pt;margin-left:0in;background:white">
<a name="Keystoneintegration-Databasesetup"></a><b><span style="font-family:"Arial","sans-serif";color:black">Database setup<o:p></o:p></span></b></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">Create a new database and assign privileges to keystonedbadmin:<s><o:p></o:p></s></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">> mysql -uroot -ppassword -e 'CREATE DATABASE keystone;'<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">> mysql -uroot -ppassword -e "GRANT ALL PRIVILEGES ON keystone.* TO 'keystonedbadmin'@'%';"<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333">Now build the Keystone V3 database tables<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;line-height:13.0pt;background:white">
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333"><br>
> keystone-manage --config-file /etc/keystone/keystone.conf db_sync<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Srujana C P [mailto:srujana_cp@persistent.co.in]
<br>
<b>Sent:</b> Wednesday, November 13, 2013 12:14 AM<br>
<b>To:</b> openstack@lists.openstack.org<br>
<b>Subject:</b> [Openstack] OPENSTACK[KEYSTONE]- MS SQL as Backend Store<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hello All,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank You,<o:p></o:p></p>
<p class="MsoNormal">Srujana C P<o:p></o:p></p>
<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. <o:p></o:p></p>
</div>
</div>
</body>
</html>