From owner-freebsd-current@FreeBSD.ORG  Wed Jul  9 02:36:24 2003
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
Delivered-To: freebsd-current@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 1CF5437B401
	for <current@freebsd.org>; Wed,  9 Jul 2003 02:36:24 -0700 (PDT)
Received: from mailspool.ops.uunet.co.za (mailspool.ops.uunet.co.za
	[196.7.0.140])	by mx1.FreeBSD.org (Postfix) with ESMTP id EB0F643F3F
	for <current@freebsd.org>; Wed,  9 Jul 2003 02:36:22 -0700 (PDT)
	(envelope-from ianf@mci.com)
Received: from copernicus.so.cpt1.za.uu.net ([196.30.72.32])
	by mailspool.ops.uunet.co.za with esmtp (Exim 3.36 #1)
	id 19aBMJ-000FfX-00; Wed, 09 Jul 2003 11:35:31 +0200
Received: from localhost ([127.0.0.1] helo=mci.com)
	by copernicus.so.cpt1.za.uu.net with esmtp (Exim 3.36 #1)
	id 19aBMI-0007L8-00; Wed, 09 Jul 2003 11:35:30 +0200
To: Larry Rosenman <ler@lerctr.org>
In-reply-to: Your message of "Tue, 08 Jul 2003 07:42:48 EST."
             <48810000.1057668168@lerlaptop.lerctr.org> 
References: <48810000.1057668168@lerlaptop.lerctr.org> 
From: Ian Freislich <ianf@za.uu.net>
X-image-url: http://www.digs.iafrica.com/gallery/ian-small.gif
X-BOFH: true
X-LART: Depleted uranium
X-No-Junk-Mail: I do not want to get *any* junk mail. You have been deleted
Date: Wed, 09 Jul 2003 11:35:30 +0200
Message-ID: <28217.1057743330@mci.com>
Sender: ianf@mci.com
cc: current@freebsd.org
cc: Lukas Ertl <l.ertl@univie.ac.at>
Subject: Re: pgsql logged in on console - su/PAM problem? 
X-BeenThere: freebsd-current@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Discussions about the use of FreeBSD-current
	<freebsd-current.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-current>
List-Post: <mailto:freebsd-current@freebsd.org>
List-Help: <mailto:freebsd-current-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 09 Jul 2003 09:36:24 -0000

Larry Rosenman wrote:
> 
> 
> --On Tuesday, July 08, 2003 13:58:19 +0200 Lukas Ertl <l.ertl@univie.ac.at> 
> wrote:
> 
> > Hi,
> >
> > can anyone explain why the pgsql user is logged in on console nowadays?
> I'm seeing the same thing, and am also interested in making it stop.

It's got tomething to do with the 'su - pgsql -c ...'.

I've been able to reproduce this with an arbitrary user by doing
the following, but haven't debugged further:

ne-dead] ~ # w
11:34AM  up 22:26, 2 users, load averages: 2.46, 2.45, 2.44
USER             TTY      FROM              LOGIN@  IDLE WHAT
pgsql            console  -                Tue01PM 22:25 -
ianf             p0       copernicus.so.cp 11:34AM     - w
[brane-dead] ~ # su - games
Last login: Wed Jul  9 11:33:30 on ttyp0
This account is currently not available.
[brane-dead] ~ # w
11:34AM  up 22:26, 2 users, load averages: 2.55, 2.47, 2.45
USER             TTY      FROM              LOGIN@  IDLE WHAT
pgsql            console  -                Tue01PM 22:25 -
games            p0       -                11:34AM     - w
[brane-dead] ~ # exit
exit
[brane-dead] ~ $ w
11:34AM  up 22:26, 2 users, load averages: 2.50, 2.46, 2.45
USER             TTY      FROM              LOGIN@  IDLE WHAT
pgsql            console  -                Tue01PM 22:25 -
games            p0       -                11:34AM     - w

Ian