Re: Trouble starting ipc-daemon as a service

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(at)tishler(dot)net]
Sent: June 11, 2003 11:20 AM
To: Dave Steenburg
Cc: pgsql-cygwin(at)postgresql(dot)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