Re: BUG #13622: unsafe use of relative rpath libpq.5.dylib

Lists: pgsql-bugs
From: adamwizon(at)me(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13622: unsafe use of relative rpath libpq.5.dylib
Date: 2015-09-16 21:48:38
Message-ID: 20150916214838.2678.27652@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13622
Logged by: Adam Wizon
Email address: adamwizon(at)me(dot)com
PostgreSQL version: 9.4.0
Operating system: Mac OS X 10.11
Description:

I was building Perl module DBD::Pg and received the following link error:

Reason: unsafe use of relative rpath libpq.5.dylib in
/Users/mydir/Perl_Modules/DBD-Pg-3.5.1/blib/arch/auto/DBD/Pg/Pg.bundle with
restricted binary at
/System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line
194.

I believe I am running the 10.11 GM candidate.

Thanks,
Adam


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: adamwizon(at)me(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13622: unsafe use of relative rpath libpq.5.dylib
Date: 2015-09-17 03:48:48
Message-ID: 23177.1442461728@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

adamwizon(at)me(dot)com writes:
> I was building Perl module DBD::Pg and received the following link error:

> Reason: unsafe use of relative rpath libpq.5.dylib in
> /Users/mydir/Perl_Modules/DBD-Pg-3.5.1/blib/arch/auto/DBD/Pg/Pg.bundle with
> restricted binary at
> /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line
> 194.

Hm ... I think this represents a build bug in DBD::Pg. You need to report
this to the authors of that module (who don't hang out here AFAIK).

regards, tom lane


From: Serge <lord(at)const(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13622: unsafe use of relative rpath libpq.5.dylib
Date: 2015-10-02 15:41:45
Message-ID: 1443800505621-5868332.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

This is not BUG!
This is a new policy of secure SIP, this library have permission
"restricted"
Use manual
http://www.macworld.com/article/2986118/security/how-to-modify-system-integrity-protection-in-el-capitan.html

--
View this message in context: http://postgresql.nabble.com/BUG-13622-unsafe-use-of-relative-rpath-libpq-5-dylib-tp5866235p5868332.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.


From: jhirsch <jonhirsch01(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13622: unsafe use of relative rpath libpq.5.dylib
Date: 2015-11-11 15:48:02
Message-ID: 1447256882811-5873522.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Yes, the issue is being caused by SIP. Here is a workaround. It is not
difficult but it is a bit cumbersome.

1. Boot into recovery mode and disable SIP.
2. reboot
3. You need to run the install_name_tool command to specify the absolute
path to the libpq.5.dylib library. You can see where it is pointing to with
another command, otool.

Ex. libpq.5.dylib is a relative path and that is causing the error.

bash-3.2# otool -L <Dir_Where_Your_postgres_lib_is>/pdo_pgsql.so
<Dir_Where_Your_postgres_lib_is>/pdo_pgsql.so:
libpq.5.dylib (compatibility version 5.0.0, current version 5.6.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version
1225.1.1)

Run this.

bash-3.2# install_name_tool -change libpq.5.dylib /usr/lib/libpq.5.dylib
<Dir_Where_Your_postgres_lib_is>/pdo_pgsql.so

After running when you check with otool you will see the change. (it says
/usr/lib/libpq.5.dylib)

bash-3.2# otool -L <Dir_Where_Your_postgres_lib_is>/pdo_pgsql.so
<Dir_Where_Your_postgres_lib_is>/pdo_pgsql.so:
/usr/lib/libpq.5.dylib (compatibility version 5.0.0, current version 5.6.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version
1225.1.1)

4. Boot back into recovery mode and enable SIP.
5. Reboot again. That should be it.

--
View this message in context: http://postgresql.nabble.com/BUG-13622-unsafe-use-of-relative-rpath-libpq-5-dylib-tp5866235p5873522.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.