Thread: PostgreSQL 7.3 on Cygwin rejects all-numeric userid, pg_class_aclcheck

PostgreSQL 7.3 on Cygwin rejects all-numeric userid, pg_class_aclcheck

From
"Sam Harbison"
Date:
When I changed from 7.2.3 to 7.3 I noticed this behavior.

I did a clean install of the most recent cygwin and PostgreSQL on WinXP
Pro under user '249779', which is a member of Administrators. With
7.2.3, all was fine. With 7.3 (also a clean install), initdb worked fine
but creating a database with createdb or trying to connect (to
template1) with psql failed. I believe it was psql that complained [from
aclchk.c, I think]:

            pg_class_aclcheck: invalid user id 249779

After changing my userid to 'harbison' and reinstalling cygwin and 7.3
in the same fashion, there were no errors.

Samuel P. Harbison III, Ph.D.
Assistant Professor
Carlow College Pittsburgh, PA
sharbison@carlow.edu



Re: PostgreSQL 7.3 on Cygwin rejects all-numeric userid,

From
Jason Tishler
Date:
Sam,

On Wed, Dec 25, 2002 at 11:36:22AM -0500, Sam Harbison wrote:
>             pg_class_aclcheck: invalid user id 249779
                                                 ^^^^^^

Does "249779" above refer to the uid or logname?  If the former, then
you have been bitten by Cygwin's 16-bit uid limit.  If the latter, then
I can't explain the observed behavior.

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

Re: PostgreSQL 7.3 on Cygwin rejects all-numeric userid,

From
Jason Tishler
Date:
Sam,

Please keep your replies on-list.

On Mon, Dec 30, 2002 at 10:27:11AM -0500, Sam Harbison wrote:
> >Sent: Saturday, December 28, 2002 10:09 PM
> >On Wed, Dec 25, 2002 at 11:36:22AM -0500, Sam Harbison wrote:
> >>             pg_class_aclcheck: invalid user id 249779
> >                                                 ^^^^^^
> >Does "249779" above refer to the uid or logname?  If the former, then
> >you have been bitten by Cygwin's 16-bit uid limit.  If the latter,
> >then I can't explain the observed behavior.
>
> It was the logname, I believe.  I just changed the logname on the
> account and the problem went away. There are only two accounts on the
> computer other than what WinXP supplies.

Actually, I just thought of a possible explanation.  Did you regenerate
your /etc/passwd file after creating the 249779 user with mkpasswd?  If
not, then this could explain the above error.

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

Re: PostgreSQL 7.3 on Cygwin rejects all-numeric userid, pg_class_aclcheck

From
"Sam Harbison"
Date:
Sent by Jason Monday, December 30, 2002 1:11 PM
> On Mon, Dec 30, 2002 at 10:27:11AM -0500, Sam Harbison wrote:
> > >Sent: Saturday, December 28, 2002 10:09 PM
> > >On Wed, Dec 25, 2002 at 11:36:22AM -0500, Sam Harbison wrote:
> > >>             pg_class_aclcheck: invalid user id 249779
> > >                                                 ^^^^^^ Does
> > >"249779" above refer to the uid or logname?  If the
> former, then
> > >you have been bitten by Cygwin's 16-bit uid limit.  If the latter,
> > >then I can't explain the observed behavior.
> >
> > It was the logname, I believe.  I just changed the logname on the
> > account and the problem went away. There are only two
> accounts on the
> > computer other than what WinXP supplies.
>
> Actually, I just thought of a possible explanation.  Did you
> regenerate your /etc/passwd file after creating the 249779
> user with mkpasswd?  If not, then this could explain the above error.

I deleted the C:\cygwin directory and reinstalled cygwin after creating
the 249779 user. I assume that created /etc/passwd from scratch (not
being a cygwin expert).

I have recreated the same problem on another computer by creating user
249779 and reinstalling cygwin and postgresql 7.3. What information can
I get for you?

Sam



Re: PostgreSQL 7.3 on Cygwin rejects all-numeric userid,

From
Jason Tishler
Date:
Sam,

On Mon, Dec 30, 2002 at 02:17:20PM -0500, Sam Harbison wrote:
> I have recreated the same problem on another computer by creating user
> 249779 and reinstalling cygwin and postgresql 7.3. What information
> can I get for you?

What do you get when you grep the passwd file?

    $ fgrep 249779 /etc/passwd

If nothing, then do the following:

    $ mkpasswd -l -u 249779 >>/etc/passwd

or

    $ mkpasswd -d -u 249779 >>/etc/passwd

for a local and domain account, respectively.

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

Re: PostgreSQL 7.3 on Cygwin rejects all-numeric userid, pg_class_aclcheck

From
"Sam Harbison"
Date:
On Monday, December 30, 2002 3:15 PM Jason Tishler wrote:
> On Mon, Dec 30, 2002 at 02:17:20PM -0500, Sam Harbison wrote:
> > I have recreated the same problem on another computer by
> creating user
> > 249779 and reinstalling cygwin and postgresql 7.3. What information
> > can I get for you?
>
> What do you get when you grep the passwd file?
>
>     $ fgrep 249779 /etc/passwd
>

fgrep 249779 /etc/passwd
249779:unused_by_nt/2000/xp:1011:513:Samuel P
Harbison,U-COMPSCI\249779,S-1-5-21
-2381138938-3179742922-2167395947-1011:/home/249779:/bin/bash



Re: PostgreSQL 7.3 on Cygwin rejects all-numeric userid,

From
Jason Tishler
Date:
Sam,

On Mon, Dec 30, 2002 at 03:31:39PM -0500, Sam Harbison wrote:
> On Monday, December 30, 2002 3:15 PM Jason Tishler wrote:
> > What do you get when you grep the passwd file?
> >
> >     $ fgrep 249779 /etc/passwd
> >
>
> fgrep 249779 /etc/passwd
> 249779:unused_by_nt/2000/xp:1011:513:Samuel P
> Harbison,U-COMPSCI\249779,S-1-5-21
> -2381138938-3179742922-2167395947-1011:/home/249779:/bin/bash

I'm sorry but I can't offer anymore help regarding this problem -- the
harsh reality is that I'm maxed out right now.  If this is important to
you, then you will have to debug further yourself.

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