<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<STYLE>.hmmessage P {
PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px
}
BODY.hmmessage {
FONT-FAMILY: Verdana; FONT-SIZE: 10pt
}
</STYLE>
<META name=GENERATOR content="MSHTML 8.00.7600.16535"></HEAD>
<BODY class=hmmessage>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial>John,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial>We are trying to figure out what the specific issue is here. We
haven't as of yet had trouble installing on Windows 2008, though haven't tried
Windows 2008 R2.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial>Are you running regular Windows 2008 or Windows 2008
R2?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial>Also it is possible we aren't properly escaping special characters,
can you verify that the password you thought you typed in is the one for the
postgres PostgreSQL super user account, and not the postgres windows
account?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial>Although both users go by the same name -- the PostgreSQL account
system is detached from the windows account system, so although they have the
same name, they might not have the same password. This has caused quite a
lot of confusion for people particularly people new to
PostgreSQL.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial>We are also a bit puzzled about the setting pg_hba.conf to trust and
it not working. In this setting any password you type even if it is wrong
would work. Did you reload the config or restart the service? The
settings don't take effect unless you reload the config with a postgresql reload
or restart the service.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial>We'll experiment on our end to see if the % in password is causing a
problem.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial>Leo and Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081312319-23042010><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>john
lace<BR><B>Sent:</B> Thursday, April 22, 2010 10:39 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] Bug in
postgis installation on WinServer2008-64bit<BR></FONT><BR></DIV>
<DIV></DIV>Hi, I just found a problem with the Postgis 1.5 installation on a
Windows Server 2008 64 bit platform,<BR> <BR>When I installed
postgres, it requested a more "secure" password for user 'postgres', maybe
because this is a policy on WinServer2008, and I used a combination of special
chars, something like 'my00%$password&'<BR> <BR>Postgres accepted it
very well, but the installation of postgis didn't. Not postgis 1.4,
nor 1.5, not on postgres 8.3, 8.3.7, 8.4.3. I kept installing
different options and watching them fail.<BR> <BR>The postgis installation
kept failing, with an error 'password is incorrect for user postgres', even when
I edited pg_hba.conf to make it trust 127.0.0.1<BR> <BR>The problem got
worse, because when the postgis installation failed, some process was left
behind, and next installation could fail on a different part of the
installation.<BR> <BR>Workaround? I added another postgres user, as a
superuser, granted everything. I didn't give this user special chars in
the password, and I installed postgis with this user.<BR> <BR>It
worked flawlesly. End of the
problem.<BR> <BR> <BR> <BR>I'm writing just to let you know, in
case it helps someone else or someone can upload it to the bug list to get
corrected. If a password is accepted on postgres, should be accepted
on a postgis installation.<BR> <BR>Best regards.<BR> <BR>John Lace
<BR><BR>
<HR>
<A href="" target=_new></A></BODY></HTML>