Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 15 Jan 1996 16:47:36 -0500 (EST)
From:      "Marc G. Fournier" <scrappy@ki.net>
To:        questions@freebsd.org
Cc:        Postgres95 Users <postgres95@oozoo.vnet.net>
Subject:   setuid problems with FreeBSD 2.1R & PostGres95 pl14
Message-ID:  <Pine.BSF.3.91.960115163940.3004M-100000@ki.net>

next in thread | raw e-mail | index | archive | help

Hi...

	I've got a program written that accesses a PostGres95 database
to retreive and modify information.  Now, the database is setup in such
a way that the userid that owns the database is the only one that has
permission to make modifications to it, since I don't want modifications 
to the database to made without using my program.

	The program I've installed is installed owned by the owner of
the database, and setuid'd...but when I try to run it, I'm getting a
failure to connect to the database server.

	I've already sent a similar query to the postgres95 mailing list,
but after some thought, I'm resend it slightly differently...

	If a program is setuid, it should pass the "userid" of the owner
of the program to the database server, correct?  Just to make sure that 
that concept is correct...

	If that is correct, and nobody knows of any reason why this won't
work in FreeBSD...does PostGres95 somehow ignore the setuid bit, by using
'getlogin()' when it passes the userid to the server?  Mainly...how does
PostGres95 determine who is trying to access the server, how is there 
something I can do to override this in such a way that its still only my
interface, that is setuid, that can access the server?

Thanks...

Marc G. Fournier | POP Mail  Telnet Acct  DNS Hosting
System           |  WWW Services   Database Services  | Knowledge, 
  Administrator  |                                    | Information and
 scrappy@ki.net  |      WWW: http://www.ki.net        | Communications, Inc




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.91.960115163940.3004M-100000>