[332] in Moira

home help back first fref pref prev next nref lref last post

Question - is Moira "clean" for unsigned UIDs?

daemon@ATHENA.MIT.EDU (Mark Rosenstein)
Wed Jul 31 18:28:35 1991

Date: Wed, 31 Jul 91 18:28:24 -0400
From: Mark Rosenstein <mar@MIT.EDU>
To: haynes@cats.UCSC.EDU
Cc: bug-moira@ATHENA.MIT.EDU
In-Reply-To: haynes@cats.ucsc.edu's message of Tue, 30 Jul 91 11:54:40 PDT <9107301854.AA08090@felix.UCSC.EDU>

The answer seems to be "no".  I just tried using UID 40000, and it
read back as -25536.  I suspect that the problem is Ingres, although
it could be somewhere in Moira as well.  The UIDs are stored in the
database as 2 byte integers, and I don't think Ingres has the concept
of "unsigned".  If we change the database schema to use 4 byte
integers, it will probably work.  

If you want the automatic UID assignment to work in this range, you
either have to change MAX_ID_VALUE in server/mr_server.h to be higher
than 31999 (thereby allowing all ID's (such as GIDs) to go that high),
or have a separate max for UIDs and crock the set_next_object_id()
routine in server/qrtn.qc to do the right thing.
					-Mark

home help back first fref pref prev next nref lref last post