Re: Trouble starting ipc-daemon as a service

That solved it! When I changed the properties of the service, changing the
password of the user account to run the service, it responded by granting
"postgres" the right to log on as a service. So this must be a uniquely XP
quirk.

Thanks for your help, Mike!

Dave
-----Original Message-----
From: Godshall Michael [mailto:Michael_Godshall(at)gmachs(dot)com]
Sent: June 10, 2003 5:36 PM
To: 'Dave Steenburg'
Subject: RE: [CYGWIN] Trouble starting ipc-daemon as a service

My 2000 machine always shows the login as .\XXXXX I think that windows is
truncating the domain name with the .\

If the logon is failing I would go intothe service properties and re-enter
the password for the postgres account. Reinstalling the service probably
recreated the postrges user account.

Mike
= -----Original Message-----
From: Dave Steenburg [mailto:dsteenburg(at)rogers(dot)com]
Sent: Tuesday, June 10, 2003 4:22 PM
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] Trouble starting ipc-daemon as a service

Good question! Yet I suspect if it were a permissions issue the service
would not first start and then stop. I would expect some kind of request
denied message. Still, I won't throw out any possibilities at this point.
With the XP Home version I'm not sure how I would find out. The account has
admin privileges but I don't know how I would get more detailed info about
what that includes. (I knew how to do it on NT but this XP is more
automated, and I don't know how to get behind the curtain) So, do you know
how

As I write this, I re-installed the IPC daemon as a service to see how I
might get more details about the error message, and now it works! I don't
know if it makes a difference that this time I installed it from the Cygwin
prompt rather than from a batch file.

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.
-----Original Message-----
From: Godshall Michael [mailto:Michael_Godshall(at)gmachs(dot)com]
Sent: June 10, 2003 4:22 PM
To: 'Dave Steenburg'
Subject: RE: [CYGWIN] Trouble starting ipc-daemon as a service

Does the postgres local user account have permission to start and stop
services
-----Original Message-----
From: Dave Steenburg [mailto:dsteenburg(at)rogers(dot)com]
Sent: Tuesday, June 10, 2003 3:20 PM
To: pgsql-cygwin(at)postgresql(dot)org
Subject: [CYGWIN] Trouble starting ipc-daemon as a service

I'm running on Windows XP Home version, using Cygwin 1.3.14-1,
PostgreSQL 7.2.3, and the ipc-daemon in Cygipc 1.11-1. I have followed the
instructions in usr/doc/Cygwin/postgresql-7.2.3.README. I put it into a
small script file that looks like:

ipc-daemon --install-as-service
cygrunsrv --install postmaster --path /usr/bin/postmaster --args
"-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user
postgres --shutdown
mkdir /usr/share/postgresql/data
chown postgres /usr/share/postgresql/data
initdb -D /usr/share/postgresql/data
net start ipc-daemon
net start postmaster

Yet when the script gets to "net start ipc-daemon" I get the
message:
The Cygwin IPC Daemon service is starting.
The Cygwin IPC Daemon service could not be started.

So, of course, the postmaster service also failed. When I tried
going through the Service Manager to start ipc-daemon, it said the service
on Local System "started then stopped" and suggested "Some services stop
automatically if they have no work to do"

Can anyone suggest what I might be doing wrong?

Dave