Re: BUG #5704: not correct restrictions plperlu

Lists: pgsql-bugs
From: "Igor" <oru(at)ukr(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5704: not correct restrictions plperlu
Date: 2010-10-11 20:24:00
Message-ID: 201010112024.o9BKO0cm093406@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5704
Logged by: Igor
Email address: oru(at)ukr(dot)net
PostgreSQL version: 8.1
Operating system: CentOs 5
Description: not correct restrictions plperlu
Details:

rights of functions on plperlu
lower than the user postgres

external system command not execut (telnet)


From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Igor <oru(at)ukr(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5704: not correct restrictions plperlu
Date: 2010-10-13 16:34:22
Message-ID: AANLkTikjE8+6rRerYKNThyPpuUzCbNCK_MksAMr7Yx3v@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On Mon, Oct 11, 2010 at 4:24 PM, Igor <oru(at)ukr(dot)net> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5704
> Logged by:          Igor
> Email address:      oru(at)ukr(dot)net
> PostgreSQL version: 8.1
> Operating system:   CentOs 5
> Description:        not correct  restrictions plperlu
> Details:
>
> rights of functions on plperlu
> lower than the user postgres
>
> external system command not execut (telnet)

It's very unclear from this description what you think the problem is.
Please provide a self-contained test case showing what you think
should happen and what actually does happen. Also, please specify
which 8.1.x release you are running.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


From: Alex Hunsaker <badalex(at)gmail(dot)com>
To: Igor <oru(at)ukr(dot)net>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5704: not correct restrictions plperlu
Date: 2010-10-13 17:19:35
Message-ID: AANLkTinwXd3oc7__t9ay5bnLVJzMjsSBt0ERaHoZ_h1n@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On Wed, Oct 13, 2010 at 10:34, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Mon, Oct 11, 2010 at 4:24 PM, Igor <oru(at)ukr(dot)net> wrote:
>> PostgreSQL version: 8.1
>> Operating system:   CentOs 5
>> Description:        not correct  restrictions plperlu
>> Details:
>>
>> rights of functions on plperlu
>> lower than the user postgres
>>
>> external system command not execut (telnet)
>
> It's very unclear from this description what you think the problem is.

Yeah, however if I had to guess: the system user 'postges' can execute
telnet but system('telnet') from within plperlu fails. (Or the other
way around?) Still not much we can do without error messages or test
cases ;). My hunch would be hrm, its centos... selinux related? Try
fiddling with that. Also make sure you specify the full path or that
your PATH is set right.

> Please provide a self-contained test case showing what you think
> should happen and what actually does happen.

Obviously including any relevant error messages :).