<font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2">
<div style="font-family: Verdana, Arial, Helvetica, sans-serif;">Hi Ian,</div>
<div style="font-family: Verdana, Arial, Helvetica, sans-serif;"><br></div>
<div style="font-family: Verdana, Arial, Helvetica, sans-serif;">The error indicates that you should use the original password that you specified when you installed PostgreSQL for the first time. Normally, when you install and then uninstall PostgreSQL, the user account associated with the service is not removed. Two ways to resolve this:</div>
<div><ol><li><font face="Verdana, Arial, Helvetica, sans-serif">If you can remember the original password you used on first time installation, then specify this during installation. OR, </font>
</li><li><font face="Verdana, Arial, Helvetica, sans-serif">Delete the 'postgres' account in Windows. A new one will be created (with the new password) when you install PostgreSQL </font>
</li></ol><ol><li><font face="Verdana, Arial, Helvetica, sans-serif">afresh.</font>
</li></ol>Regards,</div><div><br></div><div>John</div><div><br></div><font color="#990099" style="font-family: Verdana, Arial, Helvetica, sans-serif;">
-----"Ian Hay" <ianhay2000@gmail.com> wrote: -----</font><div style="font-family: Verdana, Arial, Helvetica, sans-serif; padding-left: 5px;">
<div style="padding-right:0px;padding-left:5px;border-left:solid black 2px;">
To: <stdm-user@lists.osgeo.org><br>From: "Ian Hay" <ianhay2000@gmail.com><br>
Date: 09/25/2014 09:46AM<br>Cc: "'John Gitau'" <John.Gitau@unhabitat.org><br>
Subject: RE: Technical issues - login<br><br><!--Notes ACF<meta http-equiv=Content-Type content="text/html; charset=utf8">-->
<!--[if !mso]><style></style><![endif]--><!--[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]--><div class="Section1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif;">
<font color="#1f497d">Hello – before getting this advice below I actually went
through and deinstalled and reinstalled the software with the idea of entering the
correct password hoping that would solve the issue. Apparently not (see
attached the stages and the error I get). <o:p></o:p></font></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif;">
<font color="#1f497d"><o:p> </o:p></font></span></p><p class="MsoNormal">
<span style="font-size: 11pt; font-family: Calibri, sans-serif;"><font color="#1f497d">
Can someone help.<o:p></o:p></font></span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif;">
<font color="#1f497d"><o:p> </o:p></font></span></p><p class="MsoNormal">
<span style="font-size: 11pt; font-family: Calibri, sans-serif;"><font color="#1f497d">
John – thanks for your advice.<o:p></o:p></font></span></p><p class="MsoNormal">
<span style="font-size: 11pt; font-family: Calibri, sans-serif;"><font color="#1f497d">
<o:p> </o:p></font></span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif;">
<font color="#1f497d">Thanks <o:p></o:p></font></span></p><p class="MsoNormal">
<span style="font-size: 11pt; font-family: Calibri, sans-serif;"><font color="#1f497d">
Ian<o:p></o:p></font></span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif;">
<font color="#1f497d"><o:p> </o:p></font></span></p><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"">
John Gitau[mailto:John.Gitau@unhabitat.org] <br><b>Sent:</b> Monday, September 22, 2014 6:04 PM<br>
<b>To:</b> Ian Hay<br><b>Cc:</b> stdm@unhabitat.org<br><b>Subject:</b> Re: Technical issues - login<o:p>
</o:p></span></p></div><p class="MsoNormal"><o:p> </o:p></p><div><p class="MsoNormal">
<span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
DearIan,<o:p></o:p></span></p></div><div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
<o:p> </o:p></span></p></div><div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
Thedatabase settings are saved in the Windows registry. To access these settings,
open your Windows Registry editor ( Windows Start > Run then type <i>
regedit</i>) and browse to the following group: HKEY_CURRENT_USER > Software
> QGIS > QGIS2 > STDM. The keys related to the database settings are <i>
Database,Host, Port</i>. To modify the values, you can either double-click or
right-click the key to load the editor and subsequently edit the value. In your
case, localhost is still fine as long as the database installation is in your
PC. However, you need to confirm that the database service is running and which
port it is configured to use. <o:p></o:p></span></p></div><div><ul type="disc">
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; mso-list:l0 level1 lfo1">
<span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
To check whether the service is running, go to Windows Start > Run then
type <i>services.msc</i>. Scroll down the list to <i>postgresql-9.2 -
PostgreSQL Server 9.2</i> service and under 'Status' column, check whether
it is has a <i>Started</i> entry to indicate that the service is running.
If not, right-click and select <i>Start</i>.<o:p></o:p></span></li>
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; mso-list:l0 level1 lfo1">
<span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
To check the port, browse to your PostgreSQL installation <i>C:\Program Files
(x86)\PostgreSQL\9.2\data</i> (Windows 64-bit) or <i> C:\Program
Files\PostgreSQL\9.2\data</i> (Windows 32-bit) and open the file named <b>
postgresql.conf</b> using any text editor such as Notepad. Scroll to around line 63 which
contains an entry starting with <i>port = 54**</i>. Check the correct port
number being used by the PostgreSQL installation and apply this in the
STDM database settings (as described above).<o:p></o:p></span></li>
</ul><div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
IfPostgreSQL still fails to start, then check your anti-virus as might also be
blocking it.<o:p></o:p></span></p></div></div><div><p class="MsoNormal">
<span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
<o:p> </o:p></span></p></div><div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
Forany additional issues, please correspond via the STDM users mailing list; you
can subscribe through the link available at: <a href="http://www.stdm.gltn.net/?page_id=291" target="_blank" title="http://www.stdm.gltn.net/?page_id=291">
http://www.stdm.gltn.net/?page_id=291</a><o:p></o:p></span></p></div><div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
<o:p> </o:p></span></p></div><div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
Regards,<o:p></o:p></span></p></div><div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
<o:p> </o:p></span></p></div><div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
John<o:p></o:p></span></p></div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
<br><font color="#990099">-----"Ian Hay"<ianhay2000@gmail.com> wrote: -----</font>
<o:p></o:p></span></p><div><div style="border:none;border-left:solid black 1.5pt;padding:0in 0in 0in 4.0pt">
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">
To: <stdm@unhabitat.org><br>From: "Ian Hay" <ianhay2000@gmail.com><br>
Date: 09/21/2014 05:27AM<br>Subject: Technical issues - login<o:p></o:p>
</span></p><div><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
Hello– I appear to have entered the wrong details into PostgreSQL database
connection settings dialog box (I actually put ‘localhost’ insteadof my hostname ‘user1-PC’ – you might clarify that inthe next
version of the manual). I now get this dialog box. <o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<img border="0" width="565" height="241" id="Picture_x0020_2" src="cid:image002.png@01CFD8EE.27804ED0" >
<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
Howdo I now go back and change the PostgreSQL databaseconnection settings and put
my correct hostname? <o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<img border="0" width="1068" height="617" id="Picture_x0020_1" src="cid:image003.png@01CFD8EE.27804ED0" >
<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
IanHay<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
MastersResearch Student - Urban and Regional Planning <o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
Universityof Sydney<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
Fijiphone (+679) 788 8572<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
skypename: ian.hay2000 <o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<a href="http://au.linkedin.com/pub/ian-hay/41/3a2/a2">LinkedInprofile</a>
<o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<o:p></o:p></p></div></div></div><div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="100%" align="center"></div><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
Novirus found in this message.<br>Checked by AVG - <a href="http://www.avg.com">
www.avg.com</a><br>Version: 2014.0.4765 / Virus Database: 4025/8259 - Release Date: 09/22/14<o:p>
</o:p></p></div></div><br><br>[attachment "STDM install issues2.docx" removed by John Gitau/UNHABITAT/NBO/UNO]</div>
<div></div></font>