Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Please help! Cannot get sqlsrv or pdo_sqlsrv installed without make errors. #1072

Closed
ssoward opened this issue Dec 31, 2019 · 10 comments
Closed

Comments

@ssoward
Copy link

ssoward commented Dec 31, 2019

I am unable to install sqlsrv or pdo_sqlsrv
Any suggestions please?

I followed these instructions:

https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15#installing-the-drivers-on-macos-sierra-high-sierra-and-mojave


OS: macOS Catalina 10.15.2
Darwin Siete-Tasas.local 19.2.0 Darwin Kernel Version 19.2.0: Sat Nov 9 03:47:04 PST 2019; root:xnu-6153.61.1~20/RELEASE_X86_64 x86_64


php version:
PHP 7.4.1 (cli) (built: Dec 18 2019 14:46:18) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
with Zend OPcache v7.4.1, Copyright (c), by Zend Technologies


Error message

$ sudo pecl install sqlsrv

downloading sqlsrv-5.6.1.tgz ...
Starting to download sqlsrv-5.6.1.tgz (183,396 bytes)
.......................................done: 183,396 bytes
34 source files, building
running: phpize
Configuring for:
PHP Api Version: 20190902
Zend Module Api No: 20190902
Zend Extension Api No: 320190902
building in /private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1
running: /private/tmp/pear/temp/sqlsrv/configure --with-php-config=/usr/local/opt/php/bin/php-config
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for a sed that does not truncate output... /usr/bin/sed
checking for pkg-config... no
checking for cc... cc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
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 for system library directory... lib
checking if compiler supports -R... no
checking if compiler supports -Wl,-rpath,... yes
checking build system type... x86_64-apple-darwin19.2.0
checking host system type... x86_64-apple-darwin19.2.0
checking target system type... x86_64-apple-darwin19.2.0
checking for PHP prefix... /usr/local/Cellar/php/7.4.1
checking for PHP includes... -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib
checking for PHP extension directory... /usr/local/Cellar/php/7.4.1/pecl/20190902
checking for PHP installed headers prefix... /usr/local/Cellar/php/7.4.1/include/php
checking if debug is enabled... no
checking if zts is enabled... no
checking for gawk... no
checking for nawk... no
checking for awk... awk
checking if awk is broken... no
checking whether to enable sqlsrv functions... yes, shared
checking for SQLSRV headers... /private/tmp/pear/temp/sqlsrv/shared/
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking how to run the C++ preprocessor... g++ -E
checking for a sed that does not truncate output... /usr/bin/sed
checking for ld used by cc... /Library/Developer/CommandLineTools/usr/bin/ld
checking if the linker (/Library/Developer/CommandLineTools/usr/bin/ld) is GNU ld... no
checking for /Library/Developer/CommandLineTools/usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
checking how to recognize dependent libraries... pass_all
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 dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking how to run the C++ preprocessor... g++ -E
checking the maximum length of command line arguments... 196608
checking command to parse /usr/bin/nm -B output from cc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... ranlib
checking for strip... strip
checking for dsymutil... dsymutil
checking for nmedit... nmedit
checking for -single_module linker flag... yes
checking for -exported_symbols_list linker flag... yes
checking if cc supports -fno-rtti -fno-exceptions... yes
checking for cc option to produce PIC... -fno-common
checking if cc PIC flag -fno-common works... yes
checking if cc static flag -static works... no
checking if cc supports -c -o file.o... yes
checking whether the cc linker (/Library/Developer/CommandLineTools/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... darwin19.2.0 dyld
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

creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /Library/Developer/CommandLineTools/usr/bin/ld
checking if the linker (/Library/Developer/CommandLineTools/usr/bin/ld) is GNU ld... no
checking whether the g++ linker (/Library/Developer/CommandLineTools/usr/bin/ld) supports shared libraries... yes
checking for g++ option to produce PIC... -fno-common
checking if g++ PIC flag -fno-common works... yes
checking if g++ static flag -static works... no
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/Library/Developer/CommandLineTools/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... darwin19.2.0 dyld
(cached) (cached) checking how to hardcode library paths into programs... immediate
configure: patching config.h.in
configure: creating ./config.status
config.status: creating config.h
running: make
/bin/sh /private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/libtool --mode=compile g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/conn.cpp -o conn.lo
mkdir .libs
g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/conn.cpp -fno-common -DPIC -o .libs/conn.o
In file included from /private/tmp/pear/temp/sqlsrv/conn.cpp:24:
In file included from /private/tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:25:
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1828:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1825:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context& ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1837:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1834:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context* ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
In file included from /private/tmp/pear/temp/sqlsrv/conn.cpp:24:
/private/tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:361:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( return_value );
^~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/conn.cpp:1338:22: warning: enumeration value 'CONN_ATTR_INVALID' not handled in switch [-Wswitch]
switch( SS_CONN_OPTS[i].value_type ) {
^
/private/tmp/pear/temp/sqlsrv/conn.cpp:1338:22: note: add missing switch cases
switch( SS_CONN_OPTS[i].value_type ) {
^
In file included from /private/tmp/pear/temp/sqlsrv/conn.cpp:24:
/private/tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:361:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( return_value );
^~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/conn.cpp:717:5: note: in instantiation of function template specialization 'process_params<ss_sqlsrv_conn>' requested here
PROCESS_PARAMS( conn, "r", FN, 0 );
^
/private/tmp/pear/temp/sqlsrv/conn.cpp:209:12: note: expanded from macro 'PROCESS_PARAMS'
rsrc = process_params<ss_sqlsrv_conn>( INTERNAL_FUNCTION_PARAM_PASSTHRU, param_spec, calling_func, param_count, ##VA_ARGS );
^
5 warnings generated.
/bin/sh /private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/libtool --mode=compile g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/util.cpp -o util.lo
g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/util.cpp -fno-common -DPIC -o .libs/util.o
In file included from /private/tmp/pear/temp/sqlsrv/util.cpp:26:
In file included from /private/tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:25:
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1828:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1825:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context& ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1837:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1834:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context* ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
In file included from /private/tmp/pear/temp/sqlsrv/util.cpp:26:
/private/tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:361:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( return_value );
^~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/util.cpp:515:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( execute_data );
^~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/util.cpp:572:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( execute_data );
^~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/util.cpp:695:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( execute_data );
^~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
6 warnings generated.
/bin/sh /private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/libtool --mode=compile g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/init.cpp -o init.lo
g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/init.cpp -fno-common -DPIC -o .libs/init.o
In file included from /private/tmp/pear/temp/sqlsrv/init.cpp:23:
In file included from /private/tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:25:
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1828:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1825:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context& ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1837:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1834:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context* ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
In file included from /private/tmp/pear/temp/sqlsrv/init.cpp:23:
/private/tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:361:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( return_value );
^~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/init.cpp:272:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( type );
^~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/init.cpp:597:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( type );
^~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/init.cpp:631:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( module_number );
^~~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/init.cpp:632:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( type );
^~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/init.cpp:672:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( module_number );
^~~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/init.cpp:673:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( type );
^~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
9 warnings generated.
/bin/sh /private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/libtool --mode=compile g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/stmt.cpp -o stmt.lo
g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/stmt.cpp -fno-common -DPIC -o .libs/stmt.o
In file included from /private/tmp/pear/temp/sqlsrv/stmt.cpp:25:
In file included from /private/tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:25:
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1828:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1825:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context& ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1837:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1834:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context* ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
In file included from /private/tmp/pear/temp/sqlsrv/stmt.cpp:25:
/private/tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:361:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( return_value );
^~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
In file included from /private/tmp/pear/temp/sqlsrv/stmt.cpp:25:
/private/tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:361:20: warning: expression result unused [-Wunused-value]
SQLSRV_UNUSED( return_value );
^~~~~~~~~~~~
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1711:32: note: expanded from macro 'SQLSRV_UNUSED'
#define SQLSRV_UNUSED( var ) var;
^~~
/private/tmp/pear/temp/sqlsrv/stmt.cpp:304:9: note: in instantiation of function template specialization 'process_params<ss_sqlsrv_stmt>' requested here
PROCESS_PARAMS( stmt, "r", FN, 0 );
^
/private/tmp/pear/temp/sqlsrv/stmt.cpp:276:12: note: expanded from macro 'PROCESS_PARAMS'
rsrc = process_params<ss_sqlsrv_stmt>( INTERNAL_FUNCTION_PARAM_PASSTHRU, param_spec, calling_func, param_count, ## VA_ARGS );
^
4 warnings generated.
/bin/sh /private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/libtool --mode=compile g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/shared/core_conn.cpp -o shared/core_conn.lo
mkdir shared/.libs
g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/shared/core_conn.cpp -fno-common -DPIC -o shared/.libs/core_conn.o
In file included from /private/tmp/pear/temp/sqlsrv/shared/core_conn.cpp:20:
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1828:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1825:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context& ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1837:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1834:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context* ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
2 warnings generated.
/bin/sh /private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/libtool --mode=compile g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/shared/core_results.cpp -o shared/core_results.lo
g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/shared/core_results.cpp -fno-common -DPIC -o shared/.libs/core_results.o
In file included from /private/tmp/pear/temp/sqlsrv/shared/core_results.cpp:20:
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1828:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1825:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context& ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1837:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1834:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context* ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
2 warnings generated.
/bin/sh /private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/libtool --mode=compile g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/shared/core_stream.cpp -o shared/core_stream.lo
g++ -std=c++11 -I. -I/private/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/include -I/private/tmp/pear/temp/pear-build-rootv8a1q5/sqlsrv-5.6.1/main -I/private/tmp/pear/temp/sqlsrv -I/usr/local/Cellar/php/7.4.1/include/php -I/usr/local/Cellar/php/7.4.1/include/php/main -I/usr/local/Cellar/php/7.4.1/include/php/TSRM -I/usr/local/Cellar/php/7.4.1/include/php/Zend -I/usr/local/Cellar/php/7.4.1/include/php/ext -I/usr/local/Cellar/php/7.4.1/include/php/ext/date/lib -I/private/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -D_FORTIFY_SOURCE=2 -O2 -fstack-protector -c /private/tmp/pear/temp/sqlsrv/shared/core_stream.cpp -fno-common -DPIC -o shared/.libs/core_stream.o
In file included from /private/tmp/pear/temp/sqlsrv/shared/core_stream.cpp:20:
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1828:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1825:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context& ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1837:29: warning: passing an object that undergoes default argument promotion to 'va_start' has undefined behavior [-Wvarargs]
va_start( print_params, warning );
^
/private/tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:1834:120: note: parameter of type 'bool' is declared here
inline bool call_error_handler( Inout sqlsrv_context* ctx, In unsigned long sqlsrv_error_code TSRMLS_DC, In bool warning, ... )
^
/private/tmp/pear/temp/sqlsrv/shared/core_stream.cpp:201:5: error: cannot initialize a member subobject of type 'ssize_t (*)(php_stream *, char , size_t)' (aka 'long ()(_php_stream *, char *, unsigned long)') with an lvalue of type 'size_t (php_stream *, char *, size_t)' (aka 'unsigned long (_php_stream *, char *, unsigned long)'): different return type ('ssize_t' (aka 'long') vs 'size_t' (aka 'unsigned long'))
sqlsrv_stream_read,
^~~~~~~~~~~~~~~~~~
2 warnings and 1 error generated.
make: *** [shared/core_stream.lo] Error 1
ERROR: `make' failed

@cheenamalhotra
Copy link
Member

Hi @ssoward

PHP 7.4 is supported starting 5.7.1preview version.
Please try the same using pecl install sqlsrv-5.7.1preview and confirm.

Thanks!

@ssoward
Copy link
Author

ssoward commented Dec 31, 2019

Successfully installed both! Thank you very much!


Build process completed successfully
Installing '/usr/local/Cellar/php/7.4.1/pecl/20190902/sqlsrv.so'
install ok: channel://pecl.php.net/sqlsrv-5.7.1preview
Extension sqlsrv enabled in php.ini


Build process completed successfully
Installing '/usr/local/Cellar/php/7.4.1/pecl/20190902/pdo_sqlsrv.so'
install ok: channel://pecl.php.net/pdo_sqlsrv-5.7.1preview
Extension pdo_sqlsrv enabled in php.ini

@nucreativa
Copy link

Hi,
I saw 5.8.0 drop SQL Server 2008 R2 support. Reference.
Is 5.7.1 is the only way to use PHP 7.4? Is it stable enough? My app still use SQL Server 2008 R2 :(

@yitam
Copy link
Contributor

yitam commented Mar 10, 2020

Yes @nucreativa SQL Server 2008 and SQL Server 2008 R2’s extended support ended in July 2019. Do note that 5.7.1 is a preview release whereas 5.8.0 is the stable release. Please consider upgrading your server.

@lsalazarm99
Copy link

Can I use 5.6.1 with PHP 8.0.2 for SQL Server 2008 R2? The reference says it's for 7.3.0+ so I guess 8.0.2 is supported, right?

@yitam
Copy link
Contributor

yitam commented Mar 1, 2021

The answer is no @lsalazarm99, because 7.3.0+ means 7.3.* after 7.3.0.
For PHP 8.0.* you will need sqlsrv drivers 5.9.0

FYI, please check our support matrix

@Aswini93
Copy link

I am using php7.2 version with 5.8 sqlsrv driver. Currently i am facing issue with connection. Can anyone help me out to fix it?

@yitam
Copy link
Contributor

yitam commented Sep 27, 2021

@Aswini93 please create a new issue to provide more details.

@yainakrub
Copy link

yainakrub commented Dec 11, 2021

@yitam
can't install sqlsrv and pecl install pdo_sqlsrv
spec os ubuntu 20.04
php 7.4

ask for help me
wanchalerm

--error message--
wanchalerm@lmisreport:~$ sudo pecl install sqlsrv
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_mysql' (tried: /usr/lib/php/20190902/pdo_mysql (/usr/lib/php/20190902/pdo_mysql: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_mysql.so (/usr/lib/php/20190902/pdo_mysql.so: undefined symbol: mysqlnd_allocator)) in Unknown on line 0
PHP Warning: Module 'bz2' already loaded in Unknown on line 0
PHP Warning: Module 'curl' already loaded in Unknown on line 0
PHP Warning: Module 'exif' already loaded in Unknown on line 0
PHP Warning: Module 'fileinfo' already loaded in Unknown on line 0
PHP Warning: Module 'gd' already loaded in Unknown on line 0
PHP Warning: Module 'gettext' already loaded in Unknown on line 0
PHP Warning: Module 'mbstring' already loaded in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'sqlsrv.so' (tried: /usr/lib/php/20190902/sqlsrv.so (/usr/lib/php/20190902/sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/sqlsrv.so.so (/usr/lib/php/20190902/sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: Module 'ssh2' already loaded in Unknown on line 0
PHP Warning: Module 'xmlrpc' already loaded in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlsrv.so' (tried: /usr/lib/php/20190902/pdo_sqlsrv.so (/usr/lib/php/20190902/pdo_sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_sqlsrv.so.so (/usr/lib/php/20190902/pdo_sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Fatal error: Allowed memory size of 2097152 bytes exhausted (tried to allocate 32768 bytes) in /usr/share/php/PEAR/Command/Install.php on line 621

@yitam
-error message-
wanchalerm@lmisreport:~$ sudo pecl install sqlsrv
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_mysql' (tried: /usr/lib/php/20190902/pdo_mysql (/usr/lib/php/20190902/pdo_mysql: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_mysql.so (/usr/lib/php/20190902/pdo_mysql.so: undefined symbol: mysqlnd_allocator)) in Unknown on line 0
PHP Warning: Module 'bz2' already loaded in Unknown on line 0
PHP Warning: Module 'curl' already loaded in Unknown on line 0
PHP Warning: Module 'exif' already loaded in Unknown on line 0
PHP Warning: Module 'fileinfo' already loaded in Unknown on line 0
PHP Warning: Module 'gd' already loaded in Unknown on line 0
PHP Warning: Module 'gettext' already loaded in Unknown on line 0
PHP Warning: Module 'mbstring' already loaded in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'sqlsrv.so' (tried: /usr/lib/php/20190902/sqlsrv.so (/usr/lib/php/20190902/sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/sqlsrv.so.so (/usr/lib/php/20190902/sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: Module 'ssh2' already loaded in Unknown on line 0
PHP Warning: Module 'xmlrpc' already loaded in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlsrv.so' (tried: /usr/lib/php/20190902/pdo_sqlsrv.so (/usr/lib/php/20190902/pdo_sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_sqlsrv.so.so (/usr/lib/php/20190902/pdo_sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Fatal error: Allowed memory size of 2097152 bytes exhausted (tried to allocate 32768 bytes) in /usr/share/php/PEAR/Command/Install.php on line 621

@rezihandianto
Copy link

rezihandianto commented Feb 7, 2025

how do I install in php5.2.17? which version?
please help me. i'm using macbook m1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

8 participants