[STDM-user] Technical issues - login

[Ian Hay]

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
<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 <http://au.linkedin.com/pub/ian-hay/41/3a2/a2> 

  

  _____  

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/stdm-user/attachments/20140925/fb6e7fc4/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 31617 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/stdm-user/attachments/20140925/fb6e7fc4/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 96890 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/stdm-user/attachments/20140925/fb6e7fc4/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: STDM install issues2.docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 2859260 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/stdm-user/attachments/20140925/fb6e7fc4/attachment-0001.docx>