Re: Trouble starting ipc-daemon as a service - Mailing list pgsql-cygwin

Thanks for the info, Jason.

Though I had managed to change the user permissions indirectly through
Service Manager, I was interested in the ntrights tool as something that
might help in automating the install process I am working on.  When I look
at the command options, however, I'm not sure there is an option
corresponding to "Log on as a service":  here are the options given in the
command help for ntrights:

NTRights.Exe - Beta Version by Georg Zanzen
Grants/Revokes NT-Rights to a user/group
usage: -u xxx  User/Group
       -m \\xxx  machine to perform the operation on (default local machine)
       -e xxxxx Add xxxxx to the event log
       -r xxx  revokes the xxx right
       +r xxx  grants the xxx right
valid NTRights are:
  SeCreateTokenPrivilege
  SeAssignPrimaryTokenPrivilege
  SeLockMemoryPrivilege
  SeIncreaseQuotaPrivilege
  SeUnsolicitedInputPrivilege
  SeMachineAccountPrivilege
  SeTcbPrivilege
  SeSecurityPrivilege
  SeTakeOwnershipPrivilege
  SeLoadDriverPrivilege
  SeSystemProfilePrivilege
  SeSystemtimePrivilege
  SeProfileSingleProcessPrivilege
  SeIncreaseBasePriorityPrivilege
  SeCreatePagefilePrivilege
  SeCreatePermanentPrivilege
  SeBackupPrivilege
  SeRestorePrivilege
  SeShutdownPrivilege
  SeAuditPrivilege
  SeSystemEnvironmentPrivilege
  SeChangeNotifyPrivilege
  SeRemoteShutdownPrivilege

Does one of these cover permissions to "Log on as a service" ?

Dave


-----Original Message-----
From: Jason Tishler [mailto:jason@tishler.net]
Sent: June 11, 2003 11:20 AM
To: Dave Steenburg
Cc: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] Trouble starting ipc-daemon as a service


Dave,

On Tue, Jun 10, 2003 at 05:22:03PM -0400, Dave Steenburg wrote:
> But now the problem has shifted.  Now when I try to start the
> postmaster service, it returns a system error 1069: "The service did
> not start due to a logon error."  I am logged on as "postgres" (an
> admin account) and in the Service Manager it shows "Log on as
> .\postgres" so I'm not sure where the problem comes from.  Any ideas.

See the README:

    http://www.tishler.net/jason/software/postgresql/postgresql-7.3.3.README

Specifically, the following:

    3. Grant the "postgres" user the "Log on as a service" user right:

        # cmd /c secpol.msc # [3] [4] [5] [12]

    [snip]

    [12] On Windows XP Home, there is no built in way to assign user
    rights -- use ntrights instead.  This tool is available from the
    Windows 2000 Resource Kit or
    http://www.dynawell.com/reskit/microsoft/win2000/ntrights.zip.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6