Re: BUG #2934: INSTALL FAILURE - failed to set permissions

The following bug has been logged online:

Bug reference: 2934
Logged by: inifinity
Email address: priyatam(at)gmail(dot)com
PostgreSQL version: 8.2
Operating system: Windows XP
Description: INSTALL FAILURE - failed to set permissions on the
installed files
Details:

I've been trying to install this from past two days and all I can see is a
an error message towards the end of installation and a log file which I
cannot acccess in my default C:\program files\postrgresql\8.2

the error says to check a log file perm.log but I cannot browse or delete
the *\8.2 folder. says access denied.

I have a admin user account and Im 100% sure I have given the right
username/pwd in the first page of the installation with 'postgresql' as a
superuser (and a diff pwd).

Tried searching all forums but no result.

I just hope someone sees this message and comes up with a solution rather
than ask my cryptic questions in return

Here is the postgresql-8.2.logfile (which I got after running again with
detailed logging)

Property(C): PrimaryVolumeSpaceAvailable = 0
Property(C): PrimaryVolumeSpaceRequired = 0
Property(C): PrimaryVolumeSpaceRemaining = 0
Property(C): INSTALLLEVEL = 1
=== Logging stopped: 1/25/2007 11:23:40 ===
MSI (c) (44:40) [11:23:40:031]: Note: 1: 1708
MSI (c) (44:40) [11:23:40:031]: Note: 1: 2205 2: 3: Error
MSI (c) (44:40) [11:23:40:031]: Note: 1: 2228 2: 3: Error 4: SELECT
`Message` FROM `Error` WHERE `Error` = 1708
MSI (c) (44:40) [11:23:40:031]: Note: 1: 2205 2: 3: Error
MSI (c) (44:40) [11:23:40:031]: Note: 1: 2228 2: 3: Error 4: SELECT
`Message` FROM `Error` WHERE `Error` = 1709
MSI (c) (44:40) [11:23:40:031]: Product: PostgreSQL 8.2 -- Installation
failed.

MSI (c) (44:40) [11:23:40:046]: Grabbed execution mutex.
MSI (c) (44:40) [11:23:40:046]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (44:40) [11:23:40:046]: MainEngineThread is returning 1603
=== Verbose logging stopped: 1/25/2007 11:23:40 ===

inifinity wrote:
> The following bug has been logged online:
>
> Bug reference: 2934
> Logged by: inifinity
> Email address: priyatam(at)gmail(dot)com
> PostgreSQL version: 8.2
> Operating system: Windows XP
> Description: INSTALL FAILURE - failed to set permissions on the
> installed files
> Details:
>
> I've been trying to install this from past two days and all I can see is a
> an error message towards the end of installation and a log file which I
> cannot acccess in my default C:\program files\postrgresql\8.2
>
> the error says to check a log file perm.log but I cannot browse or delete
> the *\8.2 folder. says access denied.
>
> I have a admin user account and Im 100% sure I have given the right
> username/pwd in the first page of the installation with 'postgresql' as a
> superuser (and a diff pwd).
>
> Tried searching all forums but no result.
>
> I just hope someone sees this message and comes up with a solution rather
> than ask my cryptic questions in return

What are the permissions on the directory c:\program files, and what are
the permissions on the postgresql directory that you cannot browse?

//Magnus

Priyatam wrote:
> I solved it by creating a new user 'postgresql' with admin privileges
> before the setup began and it works fine. However Im disp to see that
> this doesnt work for an existing windows user with admin privileges.

It does for me. I do that all the time, and I've never had the problem.

> Your questions are invalid as in windows a user with admin privileges
> will have access to all folders.

That is simply false. There are several ways for a user with admin
privileges not to have access to a local folder on Windows. Read up on
NTFS ACLs and you'll find it.
There are also several cases where Windows will report access denied for
errors that *are not related to permissions*.

> You guys should do a better job of creating a user friendly installation
> package

We're trying. That's why I asked you those questions. Without feedback,
we can't make it better, because it works fine in all "normal"
situations for thousands of other people. We want to know *why* it
didn't work in your case, so we can fix it or at least document it.

//Magnus