From: Michael Fuhr <mike@fuhr.org>
To: david.lao@sharpasia.com.mo
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: real and effective user ids must match
Date: Thu, 14 Sep 2006 22:31:23 -0600
Message-ID: <20060915043123.GA1845@winnie.fuhr.org> (raw)
In-Reply-To: <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo>
References: <27572.1158238113@sss.pgh.pa.us>
<50291.202.86.139.20.1158246823.mailsage.folio@sharpasia.com.mo>
<20060915004924.GA32408@winnie.fuhr.org>
<1143.202.175.123.162.1158283228.mailsage.folio@sharpasia.com.mo>
<20060915014146.GA32900@winnie.fuhr.org>
<1479.202.175.123.162.1158284982.mailsage.folio@sharpasia.com.mo>
<20060915025331.GA1109@winnie.fuhr.org>
<2411.202.175.123.162.1158289986.mailsage.folio@sharpasia.com.mo>
<20060915033750.GA1374@winnie.fuhr.org>
<3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo>
On Fri, Sep 15, 2006 at 11:56:18AM +0800, david.lao@sharpasia.com.mo wrote:
> su -l postgres -s /bin/sh -c id output:
> uid=0(root) gid=26 euid=26(postgres) groups=26
I don't have a Linux box to test but that output isn't what I'd
expect, and it's not what I get with the equivalent commands on
Solaris and FreeBSD. The above output shows that the real uid and
effective uid are different, which is what the postmaster is
complaining about. I'd expect them to be the same: both postgres.
Can anybody else with a Linux box test the above command?
Do you have sudo? If so then what does "sudo -u postgres id" show?
If uid and euid are the same (both postgres) then you might be able
to start the postmaster with sudo instead of su.
> >When was the last time you successfully started the postmaster the
> >same way you're trying now? How long had you been running PostgreSQL
> >without any problems? If it used to work then something has changed.
>
> I am running Redhat 8, it is same way to start the postgres
> "/etc/rc.d/init.d/postgresql start", I running postgre about
> 2 years ago, maybe it is the hacker do it, because before I
> found one unknown user and delect it, and then I restart the
> service with error.
What do you mean by "the hacker"? Do you know or suspect that
you've been hacked? If so then I'd recommend that you reinstall
your system from trustworthy media, make sure you have current
security patches, and close any configuration holes that might have
let an intruder in.
--
Michael Fuhr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mike@fuhr.org, david.lao@sharpasia.com.mo, tgl@sss.pgh.pa.us
Subject: Re: real and effective user ids must match
In-Reply-To: <20060915043123.GA1845@winnie.fuhr.org>
References: <27572.1158238113@sss.pgh.pa.us> <50291.202.86.139.20.1158246823.mailsage.folio@sharpasia.com.mo> <20060915004924.GA32408@winnie.fuhr.org> <1143.202.175.123.162.1158283228.mailsage.folio@sharpasia.com.mo> <20060915014146.GA32900@winnie.fuhr.org> <1479.202.175.123.162.1158284982.mailsage.folio@sharpasia.com.mo> <20060915025331.GA1109@winnie.fuhr.org> <2411.202.175.123.162.1158289986.mailsage.folio@sharpasia.com.mo> <20060915033750.GA1374@winnie.fuhr.org> <3005.202.175.123.162.1158292578.mailsage.folio@sharpasia.com.mo> <20060915043123.GA1845@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox