Обсуждение: 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 :).