From owner-freebsd-current@FreeBSD.ORG  Tue Jul  8 04:58:27 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 4ED3A37B401
	for <current@freebsd.org>; Tue,  8 Jul 2003 04:58:27 -0700 (PDT)
Received: from mailbox.univie.ac.at (mailbox.univie.ac.at [131.130.1.27])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 6D61C43F3F
	for <current@freebsd.org>; Tue,  8 Jul 2003 04:58:26 -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 h68BwJu4065924
	for <current@freebsd.org>; Tue, 8 Jul 2003 13:58:22 +0200
Date: Tue, 8 Jul 2003 13:58:19 +0200 (CEST)
From: Lukas Ertl <l.ertl@univie.ac.at>
To: current@freebsd.org
Message-ID: <20030708135357.Q16193@pcle2.cc.univie.ac.at>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=ISO-8859-1
Content-Transfer-Encoding: QUOTED-PRINTABLE
X-DCC-ZID-Univie-Metrics: unet 4261; Body=1 Fuz1=1 Fuz2=1
Subject: 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: Tue, 08 Jul 2003 11:58:27 -0000

Hi,

can anyone explain why the pgsql user is logged in on console nowadays?

# w
 1:24PM  up 3 days, 22:52, 3 users, load averages: 0.24, 0.40, 0.37
USER             TTY      FROM              LOGIN@  IDLE WHAT
pgsql            console  -                Fri02PM 3days -

Postgresql is installed from ports, and I never noticed that behaviour
before. The startup script looks like this:

---8<---
case $1 in
start)
    touch ${logfile}
    chmod 600 ${logfile}
    chown pgsql:pgsql ${logfile}
    [ -x ${PGBIN}/pg_ctl ] && {
        su -l pgsql -c \
            "[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl start -s -w -l
${logfile}"
        echo -n ' pgsql'
    }
    ;;
---8<---

Could it be that su and/or PAM have a problem?

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/