From owner-freebsd-current@FreeBSD.ORG  Wed Jul  9 05:28:16 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 38F0E37B401; Wed,  9 Jul 2003 05:28:16 -0700 (PDT)
Received: from mailbox.univie.ac.at (mail.univie.ac.at [131.130.1.27])
	by mx1.FreeBSD.org (Postfix) with ESMTP
	id E10B343F85; Wed,  9 Jul 2003 05:28:14 -0700 (PDT)
	(envelope-from l.ertl@univie.ac.at)
Received: from pcle2.cc.univie.ac.at (pcle2.cc.univie.ac.at [131.130.2.177])
	by mailbox.univie.ac.at (8.12.2/8.12.2) with ESMTP id h69CS2eR110792;
	Wed, 9 Jul 2003 14:28:07 +0200
Date: Wed, 9 Jul 2003 14:28:02 +0200 (CEST)
From: Lukas Ertl <l.ertl@univie.ac.at>
To: Ian Freislich <ianf@za.uu.net>
In-Reply-To: <28217.1057743330@mci.com>
Message-ID: <20030709142424.H16193@pcle2.cc.univie.ac.at>
References: <48810000.1057668168@lerlaptop.lerctr.org>
	<28217.1057743330@mci.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=ISO-8859-1
Content-Transfer-Encoding: QUOTED-PRINTABLE
X-DCC-ZID-Univie-Metrics: unet 4244; Body=0 Fuz1=0 Fuz2=0
cc: current@freebsd.org
cc: des@freebsd.org
cc: Larry Rosenman <ler@lerctr.org>
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 12:28:16 -0000

On Wed, 9 Jul 2003, Ian Freislich wrote:

> Larry Rosenman wrote:
> >
> > --On Tuesday, July 08, 2003 13:58:19 +0200 Lukas Ertl <l.ertl@univie.ac=
=2Eat>
> > wrote:
> >
> > > Hi,
> > >
> > > can anyone explain why the pgsql user is logged in on console nowaday=
s?
> > 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 ...'.

Yes, it has. It was introduced in rev. 1.15 of /etc/pam.d/su, with:

session  include  system

/etc/pam.d/system has pam_lastlog in the session part, and pam_lastlog
records the login in pam_sm_open_session(), but pam_sm_close_session()
does nothing, instead of removing the wtmp entry again.

regards,
le

--=20
Lukas Ertl                             eMail: l.ertl@univie.ac.at
UNIX-Systemadministrator               Tel.:  (+43 1) 4277-14073
Zentraler Informatikdienst (ZID)       Fax.:  (+43 1) 4277-9140
der Universit=E4t Wien                   http://mailbox.univie.ac.at/~le/