Обсуждение: need help with plphp installation
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
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 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 >
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