Обсуждение: BUG #5704: not correct restrictions plperlu

The following bug has been logged online:

Bug reference:      5704
Logged by:          Igor
Email address:      oru@ukr.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)

On Mon, Oct 11, 2010 at 4:24 PM, Igor <oru@ukr.net> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05704
> Logged by: =A0 =A0 =A0 =A0 =A0Igor
> Email address: =A0 =A0 =A0oru@ukr.net
> PostgreSQL version: 8.1
> Operating system: =A0 CentOs 5
> Description: =A0 =A0 =A0 =A0not correct =A0restrictions 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.

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

On Wed, Oct 13, 2010 at 10:34, Robert Haas <robertmhaas@gmail.com> wrote:
> On Mon, Oct 11, 2010 at 4:24 PM, Igor <oru@ukr.net> wrote:
>> PostgreSQL version: 8.1
>> Operating system: =C2=A0 CentOs 5
>> Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0not correct =C2=A0restrictions p=
lperlu
>> 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 :).