<div dir="ltr">I think that the section <a href="http://docs.openstack.org/developer/trove/dev/manual_install.html#prepare-database" target="_blank">http://docs.openstack.org/<u></u>developer/trove/dev/manual_<u></u>install.html#prepare-database</a> should be modified as follow:<div>
<div style="border-style:none none dotted;border-bottom-color:rgb(197,226,234);border-bottom-width:1pt;padding:0cm 0cm 4pt">
<h3 style="margin:22.5pt 0cm 7.5pt;border:none;padding:0cm"><span style="font-size:13pt;color:rgb(207,47,25);font-weight:normal">Prepare database</span><span style="font-size:13pt;color:rgb(207,47,25);font-weight:normal"></span></h3>
</div>
<p class="" style="margin:0cm 0cm 0.0001pt 36pt"><span style="line-height:18pt;font-family:Symbol;color:rgb(62,67,73)"><font>·</font><span style="font-size:7pt;line-height:normal;font-family:'Times New Roman'"> </span><span style="line-height:normal;font-family:'Times New Roman'">ADDING this new commands in order to </span></span><span style="line-height:18pt;font-size:11pt;font-family:Arial,sans-serif;color:rgb(62,67,73)">create the trove database (as from </span><font color="#3e4349" face="Arial, sans-serif" style><span style="font-size:14.399999618530273px;line-height:24px"><a href="http://docs.openstack.org/trunk/install-guide/install/apt/content/">http://docs.openstack.org/trunk/install-guide/install/apt/content/</a></span></font><span style="line-height:18pt;color:rgb(62,67,73);font-family:Arial,sans-serif;font-size:11pt">): </span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt 35.4pt"><span style="font-size:10pt;font-family:'Courier New';color:rgb(35,48,45)"># mysql -u root -p</span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt 35.4pt"><span style="font-size:10pt;font-family:'Courier New';color:rgb(35,48,45)">mysql> CREATE
DATABASE trove;</span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt 35.4pt"><span style="font-size:10pt;font-family:'Courier New';color:rgb(35,48,45)">mysql> GRANT ALL
PRIVILEGES ON trove.* TO trove@'localhost' \</span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt 35.4pt"><span style="font-size:10pt;font-family:'Courier New';color:rgb(35,48,45)">IDENTIFIED BY <i>'TROVE_DBPASS</i>';</span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt 35.4pt"><span style="font-size:10pt;font-family:'Courier New';color:rgb(35,48,45)">mysql> GRANT ALL
PRIVILEGES ON trove.* TO trove@'%' \</span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt 35.4pt"><span style="font-size:10pt;font-family:'Courier New';color:rgb(35,48,45)">IDENTIFIED BY '<i>TROVE_DBPASS</i>';</span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt 35.4pt"><span style="font-size:10pt;font-family:'Courier New';color:rgb(35,48,45)"> </span></p>
<p class="" style="margin:0cm 0cm 0.0001pt 36pt;line-height:18pt"><span style="font-size:10pt;font-family:Symbol;color:rgb(62,67,73)">·<span style="font-size:7pt;line-height:normal;font-family:'Times New Roman'"> </span></span><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(62,67,73)">Initialize the database:</span></p>
<p class="" style="margin:0cm 0cm 0.0001pt 36pt"><span style="line-height:18pt;font-size:11pt;font-family:Arial,sans-serif;color:rgb(62,67,73)"> - </span><font color="#3e4349" face="Arial, sans-serif"><span style="font-size:14.399999618530273px;line-height:24px">modify the old command:</span></font></p>
<div style="border:1pt solid rgb(198,201,203);padding:8pt;margin-left:36pt;margin-right:0cm"><pre style="line-height:14.4pt;border:none;padding:0cm"><span class=""><i><span style="font-size:12pt;color:rgb(64,128,144)"># trove-manage --config-file=<PathToTroveConf> db_wipe trove_test.sqlite mysql fake</span></i></span><span style="font-size:12pt;color:rgb(85,85,85)"></span></pre>
</div>
<p class="" style="margin:0cm 0cm 0.0001pt 36pt"><span style="line-height:18pt;font-size:11pt;font-family:Arial,sans-serif"><font color="#000000">with the new command (as from </font></span><font color="#000000" face="Arial, sans-serif"><span style="font-size:14.399999618530273px;line-height:24px"><a href="https://github.com/openstack/trove-integration/blob/master/scripts/redstack#L470">https://github.com/openstack/trove-integration/blob/master/scripts/redstack#L470</a></span></font><span style="line-height:18pt;color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11pt">):</span></p>
<pre style="line-height:14.4pt;border:none;padding:0cm"><span class=""><i><span style="font-size:12pt;color:rgb(64,128,144)"> # trove-manage --config-file=<PathToTroveConf> </span></i></span><b style="line-height:13.5pt;font-family:arial"><span style="font-size:9pt;font-family:Consolas;color:rgb(51,51,51)">db_sync</span></b></pre>
<pre style="border:none;padding:0cm"><ul><li><span style="line-height:24px;white-space:normal;font-size:10pt;font-family:Symbol;color:rgb(62,67,73)"><span style="font-size:7pt;line-height:normal;font-family:'Times New Roman'"> </span></span><span style><font color="#3e4349" face="Times New Roman"><span style="white-space:normal">ADDING this new commands in order to populate the datastores and datastore_versions tables as follow (as from <a href="https://github.com/openstack/trove-integration/blob/master/scripts/redstack#L470">https://github.com/openstack/trove-integration/blob/master/scripts/redstack#L470</a>)</span></font></span></li>
</ul><span style="line-height:normal;font-family:arial"> </span><span style="color:rgb(35,48,45);font-family:'Courier New'"># mysql -u root -p</span></pre><p class="MsoNormal" style="margin:0cm 0cm 0.0001pt 35.4pt">
<span style="font-family:'Courier New';color:rgb(35,48,45)">mysql> use trove;</span></p><p class="MsoNormal" style="margin-left:35.4pt"></p>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:rgb(35,48,45);font-family:'Courier New'">mysql> </span>INSERT INTO datastores VALUES ('a00000a0-00a0-0a00-00a0-000a000000aa',
'mysql', 'b00000b0-00b0-0b00-00b0-000b000000bb'); </p><p class="MsoNormal" style="margin-left:35.4pt"><br></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:rgb(35,48,45);font-family:'Courier New'">mysql> </span>INSERT INTO datastores values ('e00000e0-00e0-0e00-00e0-000e000000ee',
'Test_Datastore_1', '');</p><p class="MsoNormal" style="margin-left:35.4pt"><br></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:rgb(35,48,45);font-family:'Courier New'">mysql> </span>INSERT INTO datastore_versions
VALUES ('b00000b0-00b0-0b00-00b0-000b000000bb',
'a00000a0-00a0-0a00-00a0-000a000000aa', 'mysql-5.5',
'c00000c0-00c0-0c00-00c0-000c000000cc', 'mysql-server-5.5', 1, 'mysql'); </p><p class="MsoNormal" style="margin-left:35.4pt"><br></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:rgb(35,48,45);font-family:'Courier New'">mysql> </span>INSERT INTO datastore_versions VALUES
('d00000d0-00d0-0d00-00d0-000d000000dd',
'a00000a0-00a0-0a00-00a0-000a000000aa', 'mysql_inactive_version', '', '', 0,
'manager1');</p>
<p class="" style="margin:0cm 0cm 0.0001pt 36pt;line-height:18pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(62,67,73)"> </span></p>
<p class="" style="margin:0cm 0cm 0.0001pt 36pt;line-height:18pt"><span style="font-size:10pt;font-family:Symbol;color:rgb(62,67,73)">·<span style="font-size:7pt;line-height:normal;font-family:'Times New Roman'">
</span></span><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(62,67,73)">Setup trove to use the uploaded image. Enter the following in a
single line, note quotes (‘) and backquotes(`).</span></p>
<p class="" style="margin:0cm 0cm 0.0001pt 36pt"><span style><font color="#3e4349" face="Arial, sans-serif"><span style="font-size:14.399999618530273px;line-height:18pt">- </span><span style="font-size:14.399999618530273px;line-height:24px">modify the old command</span><span style="font-size:14.399999618530273px;line-height:18pt">:</span></font></span><br>
</p>
<div style="border:1pt solid rgb(198,201,203);padding:8pt;margin-left:36pt;margin-right:0cm"><pre style="line-height:14.4pt;border:none;padding:0cm"><span style="font-size:12pt;color:rgb(85,85,85)"># trove-manage --config-file=<PathToTroveConf> image_update mysql `nova --os-username trove --os-password trove --os-tenant-name trove --os-auth-url http://<KeystoneIp>:5000/v2.0 image-list | awk '/trove-image/ </span><span style="font-size:13pt;color:rgb(85,85,85)">{print $2}'`</span></pre>
</div>
<p class="MsoNormal" style="margin-left:35.4pt;line-height:18pt"><span style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:14.399999618530273px">with the new commands: </span><br></p>
<p class="" style="margin-left:35.4pt">1 - obtain the image id: </p>
<p class="" style="margin-left:35.4pt"> # nova --os-username trove --os-password trove --os-tenant-name
trove --os-auth-url <a href="http://keystone_IP:5000/v2.0">http://keystone_IP:5000/v2.0</a> image-list | awk
'/trove-image/ {print $2}'</p><p class="" style="margin-left:35.4pt">2- populate the datastore_versions table (as from <a href="https://github.com/openstack/trove-integration/blob/master/scripts/redstack#L301">https://github.com/openstack/trove-integration/blob/master/scripts/redstack#L301</a>):<br>
</p><p class="MsoNormal" style="margin-left:35.4pt"></p>
<p class="MsoNormal" style="margin-left:35.4pt"> # trove-manage --config-file=<span style="color:rgb(85,85,85);line-height:14.4pt"><PathToTroveConf></span> datastore_version_update "mysql" "mysql-5.5"
"mysql" <b>id_image</b>
"mysql-server-5.5" 1</p><p class="MsoNormal" style="margin-left:35.4pt"></p><p class="MsoNormal" style="margin-left:35.4pt"><br></p>
<p class="MsoNormal" style="margin-left:35.4pt"> This should produce the following result:</p>
<p class="MsoNormal" style="margin-left:35.4pt"><b>.... 18815
INFO trove.db.sqlalchemy.session [-] Creating SQLAlchemy engine with args:
{'pool_recycle': 3600, 'echo': False}</b></p>
<p class="MsoNormal" style="margin-left:35.4pt"><b>Datastore version 'mysql-5.5'
updated.</b></p><div class="gmail_extra"><br><h3 style="font-weight:normal;color:rgb(207,47,25);margin:30px 0px 10px;padding:0px 0px 5px;font-size:17.27272605895996px;border-bottom-width:1px;border-bottom-style:dotted;border-bottom-color:rgb(197,226,234);background-image:none;font-family:'PT Sans',sans-serif!important">
Run Trove<a class="" href="http://docs.openstack.org/developer/trove/dev/manual_install.html#run-trove" title="Permalink to this headline" style="text-decoration:none;font-size:0.8em;padding:0px 4px;margin-left:5px;color:rgb(255,255,255)!important;background-color:rgb(207,47,25)!important"></a></h3>
<ul style="color:rgb(62,67,73);font-family:Arial,sans-serif;font-size:14.545454025268555px"><li style="line-height:1.5em"><p class="" style="line-height:1.5em">Run trove-api:</p><div class=""><div class=""><pre style="overflow:auto;padding:10px;color:rgb(85,85,85);line-height:1.2em;border:1px solid rgb(198,201,203);font-size:1.1em;margin-top:1.5em;margin-bottom:1.5em">
<span class="" style="color:rgb(64,128,144);font-style:italic"># trove-api --config-file=<PathToTroveConf> &</span>
</pre></div></div></li><li style="line-height:1.5em"><span style="font-size:14.545454025268555px;line-height:1.5em">Run trove-taskmanager:</span><p class="" style="line-height:1.5em"></p></li></ul></div></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px">
<div><div class="gmail_extra"><div class="" style="line-height:1.5em;color:rgb(62,67,73);font-family:Arial,sans-serif;font-size:14.545454025268555px"><div class=""><pre style="overflow:auto;padding:10px;color:rgb(85,85,85);line-height:1.2em;border:1px solid rgb(198,201,203);font-size:1.1em;margin-top:1.5em;margin-bottom:1.5em">
<span class="" style="color:rgb(64,128,144);font-style:italic"># trove-taskmanager --config-file=<PathToTroveTaskmanagerConf> &</span></pre></div></div></div></div></blockquote><div><div class="gmail_extra"><p class="" style="line-height:1.5em;color:rgb(62,67,73);font-family:Arial,sans-serif;font-size:14.545454025268555px">
</p><ul><li><span style="font-size:14.545454025268555px;line-height:1.5em">Adding the new command: "Run trove-conductor":</span><br></li></ul><p></p></div></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px">
<div><div class="gmail_extra"><div class="" style="line-height:1.5em;color:rgb(62,67,73);font-family:Arial,sans-serif;font-size:14.545454025268555px"><div class=""><pre style="overflow:auto;padding:10px;color:rgb(85,85,85);line-height:1.2em;border:1px solid rgb(198,201,203);font-size:1.1em;margin-top:1.5em;margin-bottom:1.5em">
<span class="" style="color:rgb(64,128,144);font-style:italic"># trove-conductor--config-file=<PathToTroveConductorConf> &</span></pre></div></div></div></div></blockquote><div><div class="gmail_extra"><div class="gmail_quote">
What do you think about? Please add any other command you feel necessary.</div><div class="gmail_quote"><br></div><div class="gmail_quote">Giuseppe</div><div class="gmail_quote"><br></div><div class="gmail_quote">2014-02-21 22:52 GMT+01:00 Nicholas Chase <span dir="ltr"><<a href="mailto:nchase@mirantis.com" target="_blank">nchase@mirantis.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">I mean what sould it BE, of course. Sigh.<div class=""><div class="h5">
<br>
<br>
On 2/21/2014 4:47 PM, Nicholas Chase wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
Thanks, Giusepe! What should it way?<br>
<br>
---- Nick<br>
<br>
On 2/21/2014 9:01 AM, Giuseppe Galeota wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
Hi all,<br>
For example, the "Prepare Database" section<br>
(<a href="http://docs.openstack.org/developer/trove/dev/manual_install.html#prepare-database" target="_blank">http://docs.openstack.org/<u></u>developer/trove/dev/manual_<u></u>install.html#prepare-database</a>)<br>
<br>
contains commands not valid for the new release of trove, such as:<br>
<br>
trove-manage --config-file=<<u></u>PathToTroveConf> db_wipe<br>
trove_test.sqlite_mysql fake_<br>
<br>
and:<br>
<br>
trove-manage --config-file=<<u></u>PathToTroveConf>_image_update mysql_<br>
`nova --os-username trove --os-password trove --os-tenant-name trove<br>
--os-auth-url http://<KeystoneIp>:5000/v2.0 image-list | awk<br>
'/trove-image/ {print $2}'`<br>
<br>
<br>
We should modify that commands with those used in the<br>
trove/integration/redstack script, in the section rd_manage.<br>
<br>
<br>
Thank you,<br>
Giuseppe<br>
<br>
<br>
______________________________<u></u>_________________<br>
Openstack-docs mailing list<br>
<a href="mailto:Openstack-docs@lists.openstack.org" target="_blank">Openstack-docs@lists.<u></u>openstack.org</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-docs" target="_blank">http://lists.openstack.org/<u></u>cgi-bin/mailman/listinfo/<u></u>openstack-docs</a><br>
<br>
</blockquote>
<br>
</blockquote>
</div></div></blockquote></div><br></div></div></div>