Re: initdb failure with PostgreSQL 7.3.2 / Cygwin 1.3.22-1 /

Frank,

On Fri, May 02, 2003 at 12:58:22PM -0400, Frank Seesink wrote:
> Jason Tishler wrote:
> ...[snip]...
> >Please run the attached program under both the Frank and postgres
> >user accounts to confirm or refute the above hypothesis and report
> >back to the list.
>
> Confirmed. Here's the output run as both 'Frank' (the admin level
> acct) and 'postgres':
> ______________________________________________________________________
> Frank(at)SEESINK /tmp
> $ ./cit
> 1892 = OpenSemaphore() succeeded
> ______________________________________________________________________
> postgres(at)SEESINK /tmp
> $ ./cit
> OpenSemaphore() failed with last error = 2
> ______________________________________________________________________

The above is very interesting. I expected cit to fail under postgres
but not with a last error of 2:

$ fgrep 2L /usr/include/w32api/winerror.h | head -1
#define ERROR_FILE_NOT_FOUND 2L

Actually, I expected a last error of 5:

$ fgrep 5L /usr/include/w32api/winerror.h | head -1
#define ERROR_ACCESS_DENIED 5L

Hence, your problem appears to be more insidious than a simple
permissions problem.

> Note that if I shutdown CygIPC and run the command from 'Frank', the
> results are identical to the 'postgres' results. So yes, indeed, it
> looks as if to the 'postgres' user, CygIPC does not exist/is not
> responding/cannot be accessed. Now the mother of all questions: why?
> Why does it work for you and not for me in XP?

I don't know. I appears that the semaphores created by ipc-daemon are
not accessible by users other than Frank.

I have another idea. Please download the handle utility from
Sysinternals:

http://www.sysinternals.com/ntw2k/freeware/handle.shtml

run the following when ipc-daemon is running under LocalSystem:

$ handle -a -p ipc-daemon | fgrep Multi
d8: Semaphore \BaseNamedObjects\MultiSemCtl_
dc: Semaphore \BaseNamedObjects\MultiSemSem_
e0: Semaphore \BaseNamedObjects\MultiSemShm_
e4: Semaphore \BaseNamedObjects\MultiSemMsg_
e8: File C:\Cygwin\tmp\MultiFileSem
f0: File C:\Cygwin\tmp\MultiFileShm
f8: File C:\Cygwin\tmp\MultiFileMsg

and post your results to the list.

> Do you run a vanilla XP config?

I did not install the XP box that I'm testing on, but I believe that it
is "vanilla."

> If not, what changes if any do you make?

I will check with the installer, but assume that none were made unless I
indicate otherwise.

> I can't think of any apps which would get in the way of this, but
> then, I'm not 100% clear on how CygIPC is contacted.

ipc-daemon is contacted by opening semaphores -- exactly how cit does
it. If not, why would I ask you to run cit?

> And as mentioned, I've tried running CygIPC AS user 'postgres', and
> even that did not work.

The above is truly amazing!

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