[postgis-users] Installation Error

[Obe, Regina]

Forgot to mention - alternatively you could say create an account in
PostgreSQL called say Administrator or something that maps to an NT
account and then change the line to
 
host    all         Administrator         127.0.0.1/32          trust
 
for commandline use - PostgreSQL will try to use whatever the logged in
user name is if no user is specified or you could still just type in
Administrator when asked for a user - so its still a bit lame, but
better.
 
PostgreSQL 8.3 will support native windows Integrated security (MS
dialect of Kerberos)  - so I'm really looking forward to that feature.
http://people.planetpostgresql.org/mha/index.php?/archives/155-Integrate
d-Security-in-PostgreSQL-8.3.html
 
since it will make management of PostgreSQL accounts integration with
windows domain accounts close to par with what I can do with SQL Server
management integration with windows domain.
 
Hope that helps,
Regina
 
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Zedler, Doug
Sent: Thursday, October 04, 2007 10:34 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Installation Error


Regina,
 
I have a password manager, so each time I enter the password (in pgAdmin
or in the PostGIS installation wizard), I copy it from the password
manager.  Maybe the wizard has a problem with pasting the password in.
 
Your work around worked.  It seems to have installed successfully.  So,
you always have trust authentication for localhost?  Does that mean
anyone logging on to this computer has full access to the database?
 
Douglas B. Zedler

IT Programmer/Analyst

Fort Worth Fire Department

817.392.8463
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Obe,
Regina
Sent: Thursday, October 04, 2007 9:16 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Installation Error


Doug,
 
Strange.  Not typing in the right password or typing in the password in
the wrong case is the only reason I can think why you would get the
below error.
 
As a work-around - what you could do (which I do anyway) is to set the
authentication to trust for localhost.  To do that do the following
 
1) You can do it from pgAdmin ->Tools -> Server configuration ->
pg_hba.conf   
and add or check the line that says 
 
host   all all 127.0.0.1/32  trust
 
Alternatively which sometimes I find easier - just open up the
pg_hba.conf file usually located in or wherever you chose to store your
data
 
C:\Program Files\PostgreSQL\8.2\data
 
and  make sure you have an uncommented line (comment is #) that reads
 
host    all         all         127.0.0.1/32          trust
 
Then restart your postgresql service from services manager.
 
When you install - as long as you type in a real account and you are
directly on the server, whatever password you type in will be ignored
and the connection will be trusted.
 
Hope that helps,
Regina
 
 
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Zedler, Doug
Sent: Wednesday, October 03, 2007 11:03 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Installation Error


I'm trying to install PostgreSQL and PostGIS to play with it and learn
about it.  I installed PostgreSQL 8.2.4 just fine.  I am able to connect
using pgAdmin III and such.  When I run the PostGIS 1.3.1 installation
executable, I get the following error:
 
createdb: could not connect to database postgres: FATAL:  password
authentication failed for user "postgres"
 
I am able to connect to the postgres database using pgAdmin III under
the postgres role using the same password I'm putting into the
installation wizard, and I'm not mixing up the password for the database
role with the password for the local account on my machine.  Any
suggestions are appreciated.
 
Thanks,
 

Douglas B. Zedler

IT Programmer/Analyst

Fort Worth Fire Department

817.392.8463
 

________________________________

The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure pursuant
to Massachusetts law. It is intended solely for the addressee. If you
received this in error, please contact the sender and delete the
material from any computer. 




-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071004/19ba6bb5/attachment.html>