[STDM-user] Technical issues - login

Thu Sep 25 00:11:18 PDT 2014

Hi Ian,

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:
If you can remember the original password you used on first time installation, then specify this during installation. OR, 
Delete the 'postgres' account in Windows. A new one will be created (with the new password) when you install PostgreSQL
afresh.
Regards,

John

-----"Ian Hay" <ianhay2000 at gmail.com> wrote: -----
To: <stdm-user at lists.osgeo.org>
From: "Ian Hay" <ianhay2000 at gmail.com>
Date: 09/25/2014 09:46AM
Cc: "'John Gitau'" <John.Gitau at unhabitat.org>
Subject: RE: Technical issues - login

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).

Can someone help.

John – thanks for your advice.

Thanks

Ian

From: John Gitau [mailto:John.Gitau at unhabitat.org] 
Sent: Monday, September 22, 2014 6:04 PM
To: Ian Hay
Cc: stdm at unhabitat.org
Subject: Re: Technical issues - login

Dear Ian,

The database settings are saved in the Windows registry. To access these settings, open your Windows Registry editor ( Windows Start > Run then type regedit)  and browse to the following group: HKEY_CURRENT_USER > Software > QGIS > QGIS2 > STDM. The keys related to the database settings are Database, Host, Port. 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. 

To check whether the service is running, go to Windows Start > Run then type services.msc. Scroll down the list to postgresql-9.2 - PostgreSQL Server 9.2 service and under 'Status' column, check whether it is has a Started entry to indicate that the service is running. If not, right-click and select Start.
To check the port, browse to your PostgreSQL installation C:\Program Files (x86)\PostgreSQL\9.2\data (Windows 64-bit) or  C:\Program Files\PostgreSQL\9.2\data (Windows 32-bit) and open the file named postgresql.conf using any text editor such as Notepad. Scroll to around line 63 which contains an entry starting with port = 54**. Check the correct port number being used by the PostgreSQL installation and apply this in the STDM database settings (as described above).
If PostgreSQL still fails to start, then check your anti-virus as might also be blocking it.

For any additional issues, please correspond via the STDM users mailing list; you can subscribe through the link available at:  http://www.stdm.gltn.net/?page_id=291

Regards,

John

-----"Ian Hay" <ianhay2000 at gmail.com> wrote: -----

To: <stdm at unhabitat.org>
From: "Ian Hay" <ianhay2000 at gmail.com>
Date: 09/21/2014 05:27AM
Subject: Technical issues - login

Hello – I appear to have entered the wrong details into PostgreSQL database connection settings dialog box (I actually put ‘localhost’ instead of my hostname ‘user1-PC’ – you might clarify that inthe next version of the manual). I now get this dialog box.

How do I now go back and change the PostgreSQL databaseconnection settings and put my correct hostname?

Ian Hay

Masters Research Student - Urban and Regional Planning

University of Sydney

Fiji phone (+679) 788 8572

skype name: ian.hay2000

LinkedInprofile

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4765 / Virus Database: 4025/8259 - Release Date: 09/22/14

[attachment "STDM install issues2.docx" removed by John Gitau/UNHABITAT/NBO/UNO]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/stdm-user/attachments/20140925/ab131c76/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Image.image002.png at 01CFD8EE.27804ED0.png
Type: image/png
Size: 31617 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/stdm-user/attachments/20140925/ab131c76/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Image.image003.png at 01CFD8EE.27804ED0.png
Type: image/png
Size: 96890 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/stdm-user/attachments/20140925/ab131c76/attachment-0003.png>