Обсуждение: PostgreSQL 7.3 on Cygwin rejects all-numeric userid, pg_class_aclcheck
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
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
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
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
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
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
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