Re: BUG #1256: Account problems-start as a service option install Windows 2000/ XP

Operating system: Windows 2000 SP3

Description: Account problems-start as a service
option install
Windows 2000/ XP

Details:

Problems with installer (for Version 8.0 Beta 2 dev 3) when
you check the 'Install as a service' checkbox.

Installer cheerfully creates the postgres account and grants
the 'Log on as a service' right, but does not add the account
to 'Users' group and does not grant permission to 'Access
this computer from the network' or 'Log on
locally'. These omissions cause three failure points during
the install.

It should add it to the users group.
Question: Is this by any chance a Domain Controller?

To fix this, go to Admin tools -- 'Local Security Policies'
and grant the right to 'Access this computer from the
network' to the postgres account.

"Users" normally have this, I think.

Third problem will be with initdb, much later in the install.
Error message will be: "Failed to create process for initdb:
1385!". Install will then roll back.

To fix this, go to 'Local Security Polices' (again) and
grant the right to 'Log on Locally' to the postgres account.

Again, I beleive "Users" normally have this.

I listed all 3 error messages in series, to make for easy
Google search.
Machine here is configured 'paranoia' style -- deny all
permissions to all
unless needed. This probably differs from a plain vanilla
Windows setup.

Right. If you have changed the default permissions, you will of course
need to fix that. Can't expect the installer to know about them all. We
can help a bit, though :-)

Installer should be changed to check/grant the two other
needed permissions, and should also add postgres user to
'Users' group when creating the postgres account to run as a
service.

As for the first two, yes, at least chceking for them is good. I'll add
that to a tracker.
As for "Users", this should be done by default. It must be something
environment-specific.

//Magnus