Fixed the installer and updated the quickstart doc to accommodate failed mysql database setup. I have the changes committed to the repo.<div><br></div><div>I tested the installer locally but pretty certain it will work on osgeolive 5.0. I'll download the mini iso over the weekend to play around with it.</div>
<div><br></div><div>Let me know if there is any other thing to do on my side. <br><br><div class="gmail_quote">On Thu, Aug 18, 2011 at 11:49 PM, Cameron Shorter <span dir="ltr"><<a href="mailto:cameron.shorter@gmail.com">cameron.shorter@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><u></u>
<div text="#000000" bgcolor="#ffffff">
Henry, your proposal sounds good. Are you writing a fix? If so, when
do you expect to have the fix committed?<div><div></div><div class="h5"><br>
<br>
On 18/08/11 22:27, Henry Addo wrote:
<blockquote type="cite">Thanks for the prompt response.
<div><br>
</div>
<div>Maybe I can include the command to restart mysql server in
the script like I have done for Apache?<br>
<br>
</div>
<div>and then update the quickstart about manual database restart/
or start when Ushahidi can't connect to the database server.</div>
<div><br>
</div>
<div>I have IRC client. I will get on it. Thanks for prompting me
to it.</div>
<div><br>
<div class="gmail_quote">On Thu, Aug 18, 2011 at 3:20 PM,
Cameron Shorter <span dir="ltr"><<a href="mailto:cameron.shorter@gmail.com" target="_blank">cameron.shorter@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div text="#000000" bgcolor="#ffffff"> Henry,<br>
I'm just heading off to bed, but Brian (dbb) should be
waking up soon and will likely be able to help you. If you
have irc, I suggest logging onto <a>irc://freenode.net#osgeolive</a><br>
<br>
I suspect the problem is that there is not a step in the
Quickstart which says: start the database using the
following commands ...<br>
<br>
Quickstart is on the web here:
<div><br>
<a href="http://adhoc.osgeo.osuosl.org/livedvd/docs/en/quickstart/ushahidi_quickstart.html" target="_blank">http://adhoc.osgeo.osuosl.org/livedvd/docs/en/quickstart/ushahidi_quickstart.html</a><br>
<br>
</div>
Source doc is here:<br>
<a href="https://svn.osgeo.org/osgeo/livedvd/gisvm/trunk/doc/en/quickstart" target="_blank">https://svn.osgeo.org/osgeo/livedvd/gisvm/trunk/doc/en/quickstart</a>
<div>
<div><br>
<br>
On 18/08/11 22:14, Henry Addo wrote:
<blockquote type="cite">Hello Cameron,
<div><br>
</div>
<div>If the credentials for the database server
aren't correct, Ushahidi won't be able to connect
to it. </div>
<div><br>
</div>
<div>The installer creates these credentials for the
mysql server </div>
<div><br>
</div>
<div>Database : ushahidi</div>
<div>username : user</div>
<div>password: user</div>
<div>host: localhost</div>
<div><br>
</div>
<div>Please confirm on the server if these
credentials exist. If they do, then there is
something wrong somewhere because I gave the
script a try on my local server and I was able to
install Ushahidi.</div>
<div><br>
</div>
<div>Regards,</div>
<div>Henry</div>
<div><br>
</div>
<div>P.S. I have a limited access to internet at the
moment that is why it takes a while for me to
respond. I'll try my best to check my emails so we
can resolve this issue quickly. </div>
<div><br>
</div>
<div>
<div class="gmail_quote">On Thu, Aug 18, 2011 at
1:19 AM, Cameron Shorter <span dir="ltr"><<a href="mailto:cameron.shorter@gmail.com" target="_blank">cameron.shorter@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Henry,<br>
Are you receiving my emails?<br>
<br>
In the next few days, we only have time for
one (maybe 2) builds left before we burn the
final osgeo-live, and it seems that ushahidi
will look to users like it doesn't work.<br>
<br>
Can you please:<br>
1. Confirm that we have got hold of you.<br>
2. Work with us to find a solution. Either
by email, or by talking on <a>irc://freenode.net#osgeolive</a>
<div>
<div><br>
<br>
On 14/08/2011 9:48 AM, Cameron Shorter
wrote:
<blockquote type="cite"> Henry,<br>
I'm having problems while testing
Ushahidi on osgeo live. Could you
please have a look and see what the
problem may be.<br>
Are we missing a step in the
quickstart to set up or start a
database?<br>
<br>
-------- Original Message --------
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<th nowrap valign="BASELINE" align="RIGHT">Subject: </th>
<td>[OSGeo] #750: ushahidi
doesn't connect to DB during
quickstart setup</td>
</tr>
<tr>
<th nowrap valign="BASELINE" align="RIGHT">Date: </th>
<td>Sat, 13 Aug 2011 23:46:20
-0000</td>
</tr>
<tr>
<th nowrap valign="BASELINE" align="RIGHT">From: </th>
<td>OSGeo <a href="mailto:trac_osgeo@osgeo.org" target="_blank"><trac_osgeo@osgeo.org></a></td>
</tr>
<tr>
<th nowrap valign="BASELINE" align="RIGHT">Reply-To: </th>
<td><a href="mailto:warmerdam@pobox.com" target="_blank">warmerdam@pobox.com</a></td>
</tr>
<tr>
<th nowrap valign="BASELINE" align="RIGHT">To: </th>
<td>undisclosed-recipients:;</td>
</tr>
</tbody>
</table>
<br>
<br>
<pre>#750: ushahidi doesn't connect to DB during quickstart setup
----------------------+-----------------------------------------------------
Reporter: camerons | Owner: live-demo@…
Type: defect | Status: new
Priority: normal | Milestone:
Component: LiveDVD | Keywords: 5.0 ushahidi
----------------------+-----------------------------------------------------
Running osgeolive5.0b5,
I open a clean VM, then open ushahidi application by selecting ushahidi
from the pull down menu.
I then start following the steps of the quickstart:
<a href="http://adhoc.osgeo.osuosl.org/livedvd/docs/en/quickstart/ushahidi_quickstart.html" target="_blank">http://adhoc.osgeo.osuosl.org/livedvd/docs/en/quickstart/ushahidi_quickstart.html</a>
Choose “Basic Installation”, “Let’s get started”, and it will prompt you
for a few details. The database name is “ushahidi”, database user name is
“user”, the password is also “user”. The database host is “localhost”.
Then continue.
I then get the following error:
"Oops! We couldn't make a connection to the database server with the
credentials given. Please make sure they are correct."
--
Ticket URL: <a href="https://trac.osgeo.org/osgeo/ticket/750" target="_blank"><https://trac.osgeo.org/osgeo/ticket/750></a>
OSGeo <a href="http://www.osgeo.org/" target="_blank"><http://www.osgeo.org/></a>
OSGeo committee and general foundation issue tracker.
</pre>
</blockquote>
<br>
<br>
</div>
</div>
<pre cols="72">--
Cameron Shorter
Geospatial Solutions Manager
Tel: +61 (0)2 8570 5050
Mob: +61 (0)419 142 254
Think Globally, Fix Locally
Geospatial Solutions enhanced with Open Standards and Open Source
<a href="http://www.lisasoft.com" target="_blank">http://www.lisasoft.com</a>
</pre>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Henry!
<div>--<br>
<div>Ushahidi -- Information Collection,
Visualization, & Interactive Mapping<br>
<br>
<a href="http://www.ushahidi.com" target="_blank">http://www.ushahidi.com</a>
| <a href="http://twitter.com/ushahidi" target="_blank">http://twitter.com/ushahidi</a><br>
Ghana: +233243581806 <br>
Skype: eyedol25<br>
<div>IRC: eyedol on <span style="font-family:helvetica,arial,sans-serif;font-size:14px;color:rgb(17, 17, 17);line-height:20px"><a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a>
#ushahidi</span></div>
</div>
</div>
<br>
</div>
</blockquote>
<br>
<br>
</div>
</div>
<pre cols="72">--
Cameron Shorter
Geospatial Director
Tel: +61 (0)2 8570 5050
Mob: +61 (0)419 142 254
Think Globally, Fix Locally
Geospatial Solutions enhanced with Open Standards and Open Source
<a href="http://www.lisasoft.com" target="_blank">http://www.lisasoft.com</a>
</pre>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Henry!
<div>--<br>
<div>Ushahidi -- Information Collection, Visualization, &
Interactive Mapping<br>
<br>
<a href="http://www.ushahidi.com" target="_blank">http://www.ushahidi.com</a> | <a href="http://twitter.com/ushahidi" target="_blank">http://twitter.com/ushahidi</a><br>
Ghana: +233243581806 <br>
Skype: eyedol25<br>
<div>IRC: eyedol on <span style="font-family:helvetica,arial,sans-serif;font-size:14px;color:rgb(17, 17, 17);line-height:20px"><a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #ushahidi</span></div>
</div>
</div>
<br>
</div>
</blockquote>
<br>
<br>
<pre cols="72">--
Cameron Shorter
Geospatial Director
Tel: +61 (0)2 8570 5050
Mob: +61 (0)419 142 254
Think Globally, Fix Locally
Geospatial Solutions enhanced with Open Standards and Open Source
<a href="http://www.lisasoft.com" target="_blank">http://www.lisasoft.com</a>
</pre>
</div></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Henry!<div>--<br><div>Ushahidi -- Information Collection, Visualization, & Interactive Mapping<br><br><a href="http://www.ushahidi.com" target="_blank">http://www.ushahidi.com</a> | <a href="http://twitter.com/ushahidi" target="_blank">http://twitter.com/ushahidi</a><br>
Ghana: +233243581806 <br>Skype: eyedol25<br><div>IRC: eyedol on <span style="font-family:helvetica, arial, sans-serif;font-size:14px;color:rgb(17, 17, 17);line-height:20px"><a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #ushahidi</span></div>
</div></div><br>
</div>