Re: [BUGS] One-click installer, Windows 7 32-bit, and icacls.exe - Mailing list pgsql-general

From
Subject Re: [BUGS] One-click installer, Windows 7 32-bit, and icacls.exe
Date
Msg-id 20111003063923.c760ddbd7c0975bc4b045766db7d895c.95829003ac.wbe@email16.secureserver.net
Whole thread Raw
List pgsql-general
<table align="center" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" style="empty-cells: show;"
width="100%"><tr><td;=";" </td="</td" align="left" background="cid:top@5b1ba7a57cfd67c3bd9e2d9f0a60b151" colspan="1"
height="72"style="text-align: left; background-repeat: no-repeat;"></td></tr><tr><td style="vertical-align: top;"><div
style="padding:5px; overflow-x: auto;"></div></td></tr></table><span style="font-family:Verdana; color:#000000;
font-size:10pt;"><div>Iam running Windows 7 x64 (version 6.1.7601).  My copy is also from the MSDN with latest updates
applied. When I get to the end of the postgres install I get a error:</div><div><br /></div><div>Problem running
post-installstep.  Installation may not complete correctly. </div><div>The database cluster initialisation
failed.</div><div><br/></div><div>Best Regards<br /></div><div><br /></div><div>Michael Gould</div><div>Intermodal
SoftwareSolutions, LLC</div><div>904-226-0978</div><div><br /><br /></div><blockquote id="replyBlockquote"
style="border-left:2px solid blue; margin-left: 8px; padding-left: 8px; font-size:10pt; color:black;
font-family:verdana;"webmail="1"><div id="wmQuoteWrapper"> -------- Original Message --------<br /> Subject: Re: [BUGS]
[GENERAL]One-click installer, Windows 7 32-bit,<br /> and icacls.exe<br /> From: Dave Page <<a
href="mailto:dpage@pgadmin.org">dpage@pgadmin.org</a>><br/> Date: Mon, October 03, 2011 1:11 am<br /> To: Magnus
Hagander<<a href="mailto:magnus@hagander.net">magnus@hagander.net</a>><br /> Cc: Karl Wright <<a
href="mailto:daddywri@gmail.com">daddywri@gmail.com</a>>,<a
href="mailto:pgsql-general@postgresql.org">pgsql-general@postgresql.org</a>,<br /> pgsql-bugs <<a
href="mailto:pgsql-bugs@postgresql.org">pgsql-bugs@postgresql.org</a>>,Sachin Srivastava<br /> <<a
href="http://sachin.srivastava@enterprisedb.com">sachin.srivastava@enterprisedb.com</a>>,Ashesh Vashi<br /> <<a
href="http://ashesh.vashi@enterprisedb.com">ashesh.vashi@enterprisedb.com</a>><br/><br /> On Mon, Oct 3, 2011 at
8:59AM, Magnus Hagander <<a href="mailto:magnus@hagander.net">magnus@hagander.net</a>> wrote:<br /> > On Fri,
Sep30, 2011 at 15:34, Karl Wright <<a href="mailto:daddywri@gmail.com">daddywri@gmail.com</a>> wrote:<br />
>>I saw a thread where somebody saw icacls.exe being called by the<br /> >> one-click installer.  I'm
havingthe same thing - the installer has<br /> >> been running for 45 minutes now and is basically going to have
tobe<br /> >> stopped because I'm out of time waiting for it.  Looking at process<br /> >> monitor, it is
clearthat icacls.exe is going through every file on<br /> >> the entire system and changing its permissions.  The
processtree<br /> >> indicates that it is a child of the installer, and that it is running<br /> >> the
command:<br/> >><br /> >> icacls C:\ /grant "kawright":RX<br /> >><br /> >> Clearly this won't
doat all and should be considered a severe installer bug.<br /> ><br /> > If it does, it certainly sounds like a
verybad bug.<br /> ><br /> > However, according to the documentation for icacls<br /> > (<a
href="http://technet.microsoft.com/en-us/library/cc753525(WS.10).aspx">http://technet.microsoft.com/en-us/library/cc753525(WS.10).aspx</a>),
you<br/> > should use "/t" to get it to traverse into subdirectories, and clearly<br /> > it's not doing that. So
Iwonder why it would go across the whole<br /> > filesystem - might tbere be a  bug in icacls?<br /><br /> Yes -
that'show it's supposed to work (ie. *not* using /t). The<br /> purpose of that code is to ensure that the entire path
leadingup to<br /> the data/installation directories is readable by the users that need<br /> it. We've had a number of
reportedinstallation failures in the past<br /> caused by weirdness where read or execute permissions weren't<br />
availablefor (for example) the service account user, which caused<br /> somewhat mysterious failures.<br /><br /> >
Ormaybe it has something to do with inheritance? The way<br /> > inheritance-permissions works on ntfs is, um, let's
callit<br /> > interesting.  Maybe it needs to specify the (NP) flag to not propagate<br /> > inheritance or
something?<br/><br /> Sachin/Ashesh; can one of you investigate this please?<br /><br /> Karl; can you please provide
precisedetails of your Windows version,<br /> and anything unusual about your disk configuration? I know this<br />
doesn'thappen on any of the installations of Windows 7 that we use<br /> for testing (which tend to be the MSDN builds,
runningon local NTFS<br /> disks), so I wonder if there's an icacls bug in a specific build or<br /> rev of Windows, or
whenused on a certain type of filesystem.<br /><br /> -- <br /> Dave Page<br /> Blog: <a
href="http://pgsnake.blogspot.com">http://pgsnake.blogspot.com</a><br/> Twitter: @pgsnake<br /><br /> EnterpriseDB UK:
<ahref="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br /> The Enterprise PostgreSQL Company<br /><br
/>-- <br /> Sent via pgsql-general mailing list (<a
href="mailto:pgsql-general@postgresql.org">pgsql-general@postgresql.org</a>)<br/> To make changes to your
subscription:<br/><a
href="http://www.postgresql.org/mailpref/pgsql-general">http://www.postgresql.org/mailpref/pgsql-general</a><br
/></div></blockquote></span>

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: [BUGS] One-click installer, Windows 7 32-bit, and icacls.exe
Next
From: Diego Augusto Molina
Date:
Subject: Re: [Solved] Generic logging system for pre-hstore using plperl triggers