need help with plphp installation

On 10 August 2010 15:21, Pete Kay <petedao@gmail.com> wrote:

Hi,

I am getting the following errors while trying to get plphp installed
on postgres 8.5:

ERROR:  could not load library "/usr/local/pgsql/lib/plphp.so":
/usr/local/pgsql/lib/plphp.so: undefined symbol: sapi_globals

********** Error **********

ERROR: could not load library "/usr/local/pgsql/lib/plphp.so":
/usr/local/pgsql/lib/plphp.so: undefined symbol: sapi_globals
SQL state: 58P01

========================
here is what I get with ldd command:

 ldd -r /usr/local/lib/libphp5.so
       linux-vdso.so.1 =>  (0x00007fffa95ff000)
       libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fbd23614000)
       librt.so.1 => /lib64/librt.so.1 (0x00007fbd2340b000)
       libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fbd231f5000)
       libm.so.6 => /lib64/libm.so.6 (0x00007fbd22f72000)
       libdl.so.2 => /lib64/libdl.so.2 (0x00007fbd22d6e000)
       libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fbd22b55000)
       libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007fbd22818000)
       libz.so.1 => /usr/lib64/libz.so.1 (0x00007fbd22604000)
       libc.so.6 => /lib64/libc.so.6 (0x00007fbd222ad000)
       libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fbd22092000)
       /lib64/ld-linux-x86-64.so.2 (0x0000003053e00000)
undefined symbol: sapi_globals  (/usr/local/lib/libphp5.so)
undefined symbol: executor_globals      (/usr/local/lib/libphp5.so)
undefined symbol: php_ini_opened_path   (/usr/local/lib/libphp5.so)
undefined symbol: sapi_module   (/usr/local/lib/libphp5.so)
undefined symbol: php_import_environment_variables
(/usr/local/lib/libphp5.so)
undefined symbol: zend_qsort    (/usr/local/lib/libphp5.so)
undefined symbol: module_registry       (/usr/local/lib/libphp5.so)
undefined symbol: php_module_shutdown_wrapper   (/usr/local/lib/libphp5.so)
undefined symbol: zend_error    (/usr/local/lib/libphp5.so)
undefined symbol: xmlwriter_module_entry        (/usr/local/lib/libphp5.so)
undefined symbol: libxml_module_entry   (/usr/local/lib/libphp5.so)
undefined symbol: dom_module_entry      (/usr/local/lib/libphp5.so)
undefined symbol: xmlreader_module_entry        (/usr/local/lib/libphp5.so)
undefined symbol: xml_module_entry      (/usr/local/lib/libphp5.so)

Any help will be greatly appreciated.

p

--

You can't mean 8.5. Surely 8.4?

--
Thom Brown
Registered Linux user: #516935

sorry my mistake. It is 8.4.

On 10 August 2010 15:33, Pete Kay <petedao@gmail.com> wrote:

sorry my mistake.  It is 8.4.

On Tue, Aug 10, 2010 at 10:27 PM, Thom Brown <thom@linux.com> wrote:

On 10 August 2010 15:21, Pete Kay <petedao@gmail.com> wrote:

Hi,

I am getting the following errors while trying to get plphp installed
on postgres 8.5:

ERROR:  could not load library "/usr/local/pgsql/lib/plphp.so":
/usr/local/pgsql/lib/plphp.so: undefined symbol: sapi_globals

********** Error **********

ERROR: could not load library "/usr/local/pgsql/lib/plphp.so":
/usr/local/pgsql/lib/plphp.so: undefined symbol: sapi_globals
SQL state: 58P01

========================
here is what I get with ldd command:

 ldd -r /usr/local/lib/libphp5.so
       linux-vdso.so.1 =>  (0x00007fffa95ff000)
       libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fbd23614000)
       librt.so.1 => /lib64/librt.so.1 (0x00007fbd2340b000)
       libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fbd231f5000)
       libm.so.6 => /lib64/libm.so.6 (0x00007fbd22f72000)
       libdl.so.2 => /lib64/libdl.so.2 (0x00007fbd22d6e000)
       libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fbd22b55000)
       libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007fbd22818000)
       libz.so.1 => /usr/lib64/libz.so.1 (0x00007fbd22604000)
       libc.so.6 => /lib64/libc.so.6 (0x00007fbd222ad000)
       libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fbd22092000)
       /lib64/ld-linux-x86-64.so.2 (0x0000003053e00000)
undefined symbol: sapi_globals  (/usr/local/lib/libphp5.so)
undefined symbol: executor_globals      (/usr/local/lib/libphp5.so)
undefined symbol: php_ini_opened_path   (/usr/local/lib/libphp5.so)
undefined symbol: sapi_module   (/usr/local/lib/libphp5.so)
undefined symbol: php_import_environment_variables
(/usr/local/lib/libphp5.so)
undefined symbol: zend_qsort    (/usr/local/lib/libphp5.so)
undefined symbol: module_registry       (/usr/local/lib/libphp5.so)
undefined symbol: php_module_shutdown_wrapper   (/usr/local/lib/libphp5.so)
undefined symbol: zend_error    (/usr/local/lib/libphp5.so)
undefined symbol: xmlwriter_module_entry        (/usr/local/lib/libphp5.so)
undefined symbol: libxml_module_entry   (/usr/local/lib/libphp5.so)
undefined symbol: dom_module_entry      (/usr/local/lib/libphp5.so)
undefined symbol: xmlreader_module_entry        (/usr/local/lib/libphp5.so)
undefined symbol: xml_module_entry      (/usr/local/lib/libphp5.so)

Any help will be greatly appreciated.

p

--

You can't mean 8.5.  Surely 8.4?

--
Thom Brown
Registered Linux user: #516935

Which version of PHP do you have installed? And how did you install plphp?

--
Thom Brown
Registered Linux user: #516935

Also CC'ing the PL/php list.

Excerpts from Pete Kay's message of mar ago 10 10:21:58 -0400 2010:

Hi,

I am getting the following errors while trying to get plphp installed
on postgres 8.5:

ERROR: could not load library "/usr/local/pgsql/lib/plphp.so":
/usr/local/pgsql/lib/plphp.so: undefined symbol: sapi_globals

Hmm, how did you compile PHP? (i.e. what were the configure options?)
These symbols appear defined in my copy of the "embed" SAPI.

What platform are you on?

Are you using the latest from Github? It contains a couple of small
fixes in the way LDFLAGS are handled for PHP.
http://github.com/commandprompt/PL-php

Also, what are you calling Postgres 8.5? There's no such thing --
there's 8.4, and then there's 9.0 (which was called 8.5 initially, but
changed to 9.0 way before the first beta)

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support