Re: Bug with initDB under windows 2003

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "dror" <dror_b(at)hotmail(dot)com>, "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug with initDB under windows 2003
Date: 2006-08-21 11:26:11
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCEA35559@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > I'd be interested in seeing the output from the command:
> > Subinacl /service NULL
> >
> > On a system where this does not work.
> >
>
> Here is the output for "Subinacl /service NULL"
> Both, for the Administrator user and for the Postgres user:

Thanks.

> Postgres user:
> >Subinacl /service NULL
> SeSecurityPrivilege : Access is denied.
> WARNING :Unable to set SeSecurityPrivilege privilege. This
> privilege may be required.
> Error OpenSCManager : Access is denied.

That's quite normal - the postgres user doesn't have permission to open
the SC Manager to view the permissions, because it's not a Power User.

> Administrator user:

This is good. It shows one very clear difference from what I have on a
working system, which is:

> /pace =authenticated users ACCESS_ALLOWED_ACE_TYPE-0x0
> SERVICE_USER_DEFINED_CONTROL-0x0100

On my system, I have:
/pace =authenticated users ACCESS_ALLOWED_ACE_TYPE-0x0
SERVICE_QUERY_CONFIG-0x1 SERVICE_QUERY_STATUS-0x4

SERVICE_ENUMERATE_DEPEND-0x8
SERVICE_INTERROGATE-0x80 READ_CONTROL-0x20000

SERVICE_USER_DEFINED_CONTROL-0x0100

So this is the problem. Now to figure out how to fix it :-) From what I
can tell it simply needs to add back the missing ACE flags. This command
hopefully should work (not tested apart from the syntax, since I don't
have a good testig place, but please try it and if it doesn't work see
if you can figure out what to change):

Subinacl /service NULL /grant="authenticated users"=QSEILU

You need to run this as administrator of course, but it should hopefully
unlock the NUL device again.

//Magnus

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2006-08-21 12:11:54 Optimizer degradation since 8.0
Previous Message Magnus Hagander 2006-08-21 11:12:11 Re: BF Failure on Bandicoot