search

iliaal / php_excel

PHP Extension interface to the Excel writing/reading library
http://ilia.ws
534 stars 131 forks source link

undefined symbol: removeDataValidationsA in Unknown on line 0 #226

Closed tombuben closed 5 years ago

tombuben commented 6 years ago

Compiling with LibXL-3.8.0.0 under Centos 6, the compilation works fine, but the module won't load with this error:

Warning: PHP Startup: Unable to load dynamic library '/root/php-7.1.12/ext/excel/modules/excel.so' - /root/php-7.1.12/ext/excel/modules/excel.so: undefined symbol: removeDataValidationsA in Unknown on line 0

Rolling back to commit d1cb308 and compiling from it worked fine, so the issue is most likely in a commit since then.

Full log below:

[root@devel excel]# module load php71
[root@devel excel]# phpize
Configuring for:
PHP Api Version:         20160303
Zend Module Api No:      20160303
Zend Extension Api No:   320160303
[root@devel excel]# ./configure --with-excel --with-libxl-incdir=/usr/lib64/libxl-3.8.0.0/include_c --with-libxl-libdir=/usr/lib64/libxl-3.8.0.0/lib64 --with-libxml-dir=/usr/include/libxml2
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for a sed that does not truncate output... /bin/sed
checking for cc... cc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables... 
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether cc accepts -g... yes
checking for cc option to accept ISO C89... none needed
checking how to run the C preprocessor... cc -E
checking for icc... no
checking for suncc... no
checking whether cc understands -c and -o together... yes
checking for system library directory... lib
checking if compiler supports -R... no
checking if compiler supports -Wl,-rpath,... yes
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking target system type... x86_64-unknown-linux-gnu
checking for PHP prefix... /opt/remi/php71/root/usr
checking for PHP includes... -I/opt/remi/php71/root/usr/include/php -I/opt/remi/php71/root/usr/include/php/main -I/opt/remi/php71/root/usr/include/php/TSRM -I/opt/remi/php71/root/usr/include/php/Zend -I/opt/remi/php71/root/usr/include/php/ext -I/opt/remi/php71/root/usr/include/php/ext/date/lib
checking for PHP extension directory... /opt/remi/php71/root/usr/lib64/php/modules
checking for PHP installed headers prefix... /opt/remi/php71/root/usr/include/php
checking if debug is enabled... no
checking if zts is enabled... no
checking for re2c... no
configure: WARNING: You will need re2c 0.13.4 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking whether to enable excel support... yes, shared
checking C include dir for libxl... yes, shared
checking lib dir for libxl... yes, shared
checking libxml2 install dir... yes, shared
checking for excel includes... found in /usr/lib64/libxl-3.8.0.0/include_c
checking for excel libraries... found in /usr/lib64/libxl-3.8.0.0/lib64
checking for libxml2... found in /usr/include/libxml2
checking for xlCreateBookCA in -lxl... yes
checking for xlBookSetKeyA in -lxl... yes
checking for a sed that does not truncate output... (cached) /bin/sed
checking for fgrep... /bin/grep -F
checking for ld used by cc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B
checking the name lister (/usr/bin/nm -B) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 1966080
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking for /usr/bin/ld option to reload object files... -r
checking for objdump... objdump
checking how to recognize dependent libraries... pass_all
checking for ar... ar
checking for strip... strip
checking for ranlib... ranlib
checking command to parse /usr/bin/nm -B output from cc object... ok
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for dlfcn.h... yes
checking for objdir... .libs
checking if cc supports -fno-rtti -fno-exceptions... no
checking for cc option to produce PIC... -fPIC -DPIC
checking if cc PIC flag -fPIC -DPIC works... yes
checking if cc static flag -static works... no
checking if cc supports -c -o file.o... yes
checking if cc supports -c -o file.o... (cached) yes
checking whether the cc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... no
configure: creating ./config.status
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing libtool commands
[root@devel excel]# make
/bin/sh /root/php-7.1.12/ext/excel/libtool --mode=compile cc  -I. -I/root/php-7.1.12/ext/excel -DPHP_ATOM_INC -I/root/php-7.1.12/ext/excel/include -I/root/php-7.1.12/ext/excel/main -I/root/php-7.1.12/ext/excel -I/opt/remi/php71/root/usr/include/php -I/opt/remi/php71/root/usr/include/php/main -I/opt/remi/php71/root/usr/include/php/TSRM -I/opt/remi/php71/root/usr/include/php/Zend -I/opt/remi/php71/root/usr/include/php/ext -I/opt/remi/php71/root/usr/include/php/ext/date/lib -I/usr/lib64/libxl-3.8.0.0/include_c -I/usr/include/libxml2  -DHAVE_CONFIG_H  -g -O2   -c /root/php-7.1.12/ext/excel/excel.c -o excel.lo 
libtool: compile:  cc -I. -I/root/php-7.1.12/ext/excel -DPHP_ATOM_INC -I/root/php-7.1.12/ext/excel/include -I/root/php-7.1.12/ext/excel/main -I/root/php-7.1.12/ext/excel -I/opt/remi/php71/root/usr/include/php -I/opt/remi/php71/root/usr/include/php/main -I/opt/remi/php71/root/usr/include/php/TSRM -I/opt/remi/php71/root/usr/include/php/Zend -I/opt/remi/php71/root/usr/include/php/ext -I/opt/remi/php71/root/usr/include/php/ext/date/lib -I/usr/lib64/libxl-3.8.0.0/include_c -I/usr/include/libxml2 -DHAVE_CONFIG_H -g -O2 -c /root/php-7.1.12/ext/excel/excel.c  -fPIC -DPIC -o .libs/excel.o
/root/php-7.1.12/ext/excel/excel.c: In function ‘zim_ExcelSheet_table’:
/root/php-7.1.12/ext/excel/excel.c:4673: warning: passing argument 3 of ‘xlSheetTableA’ from incompatible pointer type
/usr/lib64/libxl-3.8.0.0/include_c/SheetA.h:179: note: expected ‘int *’ but argument is of type ‘zend_long *’
/root/php-7.1.12/ext/excel/excel.c:4673: warning: passing argument 4 of ‘xlSheetTableA’ from incompatible pointer type
/usr/lib64/libxl-3.8.0.0/include_c/SheetA.h:179: note: expected ‘int *’ but argument is of type ‘zend_long *’
/root/php-7.1.12/ext/excel/excel.c:4673: warning: passing argument 5 of ‘xlSheetTableA’ from incompatible pointer type
/usr/lib64/libxl-3.8.0.0/include_c/SheetA.h:179: note: expected ‘int *’ but argument is of type ‘zend_long *’
/root/php-7.1.12/ext/excel/excel.c:4673: warning: passing argument 6 of ‘xlSheetTableA’ from incompatible pointer type
/usr/lib64/libxl-3.8.0.0/include_c/SheetA.h:179: note: expected ‘int *’ but argument is of type ‘zend_long *’
/root/php-7.1.12/ext/excel/excel.c:4673: warning: passing argument 7 of ‘xlSheetTableA’ from incompatible pointer type
/usr/lib64/libxl-3.8.0.0/include_c/SheetA.h:179: note: expected ‘int *’ but argument is of type ‘zend_long *’
/root/php-7.1.12/ext/excel/excel.c:4673: warning: passing argument 8 of ‘xlSheetTableA’ from incompatible pointer type
/usr/lib64/libxl-3.8.0.0/include_c/SheetA.h:179: note: expected ‘int *’ but argument is of type ‘zend_long *’
/root/php-7.1.12/ext/excel/excel.c: In function ‘zim_ExcelFilterColumn_getCustomFilter’:
/root/php-7.1.12/ext/excel/excel.c:5197: warning: passing argument 3 of ‘xlFilterColumnGetCustomFilterA’ from incompatible pointer type
/usr/lib64/libxl-3.8.0.0/include_c/FilterColumnA.h:23: note: expected ‘const char **’ but argument is of type ‘char **’
/root/php-7.1.12/ext/excel/excel.c:5197: warning: passing argument 5 of ‘xlFilterColumnGetCustomFilterA’ from incompatible pointer type
/usr/lib64/libxl-3.8.0.0/include_c/FilterColumnA.h:23: note: expected ‘const char **’ but argument is of type ‘char **’
/bin/sh /root/php-7.1.12/ext/excel/libtool --mode=link cc -DPHP_ATOM_INC -I/root/php-7.1.12/ext/excel/include -I/root/php-7.1.12/ext/excel/main -I/root/php-7.1.12/ext/excel -I/opt/remi/php71/root/usr/include/php -I/opt/remi/php71/root/usr/include/php/main -I/opt/remi/php71/root/usr/include/php/TSRM -I/opt/remi/php71/root/usr/include/php/Zend -I/opt/remi/php71/root/usr/include/php/ext -I/opt/remi/php71/root/usr/include/php/ext/date/lib -I/usr/lib64/libxl-3.8.0.0/include_c -I/usr/include/libxml2  -DHAVE_CONFIG_H  -g -O2   -o excel.la -export-dynamic -avoid-version -prefer-pic -module -rpath /root/php-7.1.12/ext/excel/modules  excel.lo -Wl,-rpath,/usr/lib64/libxl-3.8.0.0/lib64 -L/usr/lib64/libxl-3.8.0.0/lib64 -lxl -Wl,-rpath,/usr/lib64/libxl-3.8.0.0/lib64 -L/usr/lib64/libxl-3.8.0.0/lib64 -lxl
libtool: link: cc -shared  .libs/excel.o   -L/usr/lib64/libxl-3.8.0.0/lib64 -lxl  -Wl,-rpath -Wl,/usr/lib64/libxl-3.8.0.0/lib64 -Wl,-rpath -Wl,/usr/lib64/libxl-3.8.0.0/lib64   -Wl,-soname -Wl,excel.so -o .libs/excel.so
libtool: link: ( cd ".libs" && rm -f "excel.la" && ln -s "../excel.la" "excel.la" )
/bin/sh /root/php-7.1.12/ext/excel/libtool --mode=install cp ./excel.la /root/php-7.1.12/ext/excel/modules
libtool: install: cp ./.libs/excel.so /root/php-7.1.12/ext/excel/modules/excel.so
libtool: install: cp ./.libs/excel.lai /root/php-7.1.12/ext/excel/modules/excel.la
libtool: finish: PATH="/opt/remi/php71/root/usr/bin:/opt/remi/php71/root/usr/sbin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/sbin" ldconfig -n /root/php-7.1.12/ext/excel/modules
----------------------------------------------------------------------
Libraries have been installed in:
   /root/php-7.1.12/ext/excel/modules

If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
   - add LIBDIR to the `LD_LIBRARY_PATH' environment variable
     during execution
   - add LIBDIR to the `LD_RUN_PATH' environment variable
     during linking
   - use the `-Wl,-rpath -Wl,LIBDIR' linker flag
   - have your system administrator add LIBDIR to `/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------

Build complete.
Don't forget to run 'make test'.

[root@devel excel]# make test

Build complete.
Don't forget to run 'make test'.

PHP Warning:  PHP Startup: Unable to load dynamic library '/root/php-7.1.12/ext/excel/modules/excel.so' - /root/php-7.1.12/ext/excel/modules/excel.so: undefined symbol: removeDataValidationsA in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/root/php-7.1.12/ext/excel/modules/excel.so' - /root/php-7.1.12/ext/excel/modules/excel.so: undefined symbol: removeDataValidationsA in Unknown on line 0

=====================================================================
PHP         : /opt/remi/php71/root/usr/bin/php 
Warning: PHP Startup: Unable to load dynamic library '/root/php-7.1.12/ext/excel/modules/excel.so' - /root/php-7.1.12/ext/excel/modules/excel.so: undefined symbol: removeDataValidationsA in Unknown on line 0
[... Lots of SKIP results ...]
johmue commented 6 years ago

Can you please try to compile again with an up-to-date libxl version (e.g. 3.8.1.9) which can be found here ftp://xlware.com/build .

The message looks as if there was a problem in this specific libxl version you use.