lilgreenbird
commented
7 years ago Hi @hbunjes
Suse is not a supported platform, however you could try to compile and install this yourself. I could give you some general guidance to help get you started but we can not provide any support for that as we have not done any testing on that platform. We currently only build and test binaries for Ubuntu 15, Ubuntu 16, RHEL7, Debian8 so these are the only platforms that we support. Please note that none of the instructions below has been tested on other Linux distributions.
To use PHP you would need to install the ODBC Driver for SQL Server as that is a dependency for PHP. ODBC supports Suse you can reference the official ODBC install instructions here . That should install the ODBC and UnixODBC packages for you. Please make sure that's all working the setup is correct and you are able to connect with the ODBC driver before attempting to install the PHP driver.
Then you can try to install our PHP driver package using PECL: sudo pecl install sqlsrv-4.2.0preview for the latest version.
wget https://github.com/Microsoft/msphpsql/archive/dev.tar.gz
tar -xf dev.tar.gz
cd msphpsql-dev/source/sqlsrv
cp -r ../shared/ .
phpize
./configure
makeAlternatively you could also try to compile our driver with the PHP source:
wget https://github.com/Microsoft/msphpsql/archive/dev.tar.gz
tar -xf dev.tar.gz
wget http://ca1.php.net/get/php-7.0.20.tar.gz/from/this/mirror -O php-7.0.20.tar.gz
tar -xf php-7.0.20.tar.gz
cp -r msphpsql-dev/source/sqlsrv/ php-7.0.20/ext/
cp -r msphpsql-dev/source/shared/ php-7.0.20/ext/sqlsrv/
cd php-7.0.20/
./buildconf --force
./configure --enable-sqlsrv=shared --with-odbcver=0x0380
makeHopefully that can get you started. Good luck!
hbunjes
meet-bhagdev
Hadis-Knj
yitam
dhirajranka
Hi, I try to install sqlsrv and pdo_sqlsrv on a Suse Linux Enterprise server to access SQL Server with PHP.
After installing all required packages I run:
sudo pecl install sqlsrvThis is the output: downloading sqlsrv-4.0.8.tar ... Starting to download sqlsrv-4.0.8.tar (1,034,240 bytes) ..............done: 1,034,240 bytes 33 source files, building running: phpize Configuring for: PHP Api Version: 20151012 Zend Module Api No: 20151012 Zend Extension Api No: 320151012 building in /tmp/pear/temp/pear-build-root8kM4T6/sqlsrv-4.0.8 running: /tmp/pear/temp/sqlsrv/configure --with-php-config=/usr/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 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 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... /usr checking for PHP includes... -I/usr/include/php7 -I/usr/include/php7/main -I/usr/include/php7/TSRM -I/usr/include/php7/Zend -I/usr/include/php7/ext -I/usr/include/php7/ext/date/lib checking for PHP extension directory... /usr/lib64/php7/extensions checking for PHP installed headers prefix... /usr/include/php7 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 sqlsrv functions... yes, shared checking for SQLSRV headers... /tmp/pear/temp/sqlsrv/shared/ checking for g++... no checking for c++... no checking for gpp... no checking for aCC... no checking for CC... no checking for cxx... no checking for cc++... no checking for cl.exe... no checking for FCC... no checking for KCC... no checking for RCC... no checking for xlC_r... no checking for xlC... no checking whether we are using the GNU C++ compiler... no checking whether g++ accepts -g... no checking how to run the C++ preprocessor... /lib/cpp checking how to print strings... printf checking for a sed that does not truncate output... (cached) /usr/bin/sed checking for fgrep... /usr/bin/grep -F checking for ld used by cc... /usr/x86_64-suse-linux/bin/ld checking if the linker (/usr/x86_64-suse-linux/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... 1572864 checking whether the shell understands some XSI constructs... yes checking whether the shell understands "+="... yes checking how to convert x86_64-unknown-linux-gnu file names to x86_64-unknown-linux-gnu format... func_convert_file_noop checking how to convert x86_64-unknown-linux-gnu file names to toolchain format... func_convert_file_noop checking for /usr/x86_64-suse-linux/bin/ld option to reload object files... -r checking for objdump... objdump checking how to recognize dependent libraries... pass_all checking for dlltool... no checking how to associate runtime and link libraries... printf %s\n checking for ar... ar checking for archiver @FILE support... @ checking for strip... strip checking for ranlib... ranlib checking for gawk... (cached) gawk checking command to parse /usr/bin/nm -B output from cc object... ok checking for sysroot... no checking for mt... mt checking if mt is a manifest tool... no 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/x86_64-suse-linux/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: executing libtool commands running: make /bin/sh /tmp/pear/temp/pear-build-root8kM4T6/sqlsrv-4.0.8/libtool --mode=compile g++ -std=c++11 -I. -I/tmp/pear/temp/sqlsrv -DPHP_ATOM_INC -I/tmp/pear/temp/pear-build-root8kM4T6/sqlsrv-4.0.8/include -I/tmp/pear/temp/pear-build-root8kM4T6/sqlsrv-4.0.8/main -I/tmp/pear/temp/sqlsrv -I/usr/include/php7 -I/usr/include/php7/main -I/usr/include/php7/TSRM -I/usr/include/php7/Zend -I/usr/include/php7/ext -I/usr/include/php7/ext/date/lib -I/tmp/pear/temp/sqlsrv/shared/ -DHAVE_CONFIG_H -std=c++11 -c /tmp/pear/temp/sqlsrv/conn.cpp -o conn.lo libtool: compile: unable to infer tagged configuration libtool: compile: specify a tag with
--tag' Makefile:194: recipe for target 'conn.lo' failed make: *** [conn.lo] Error 1 ERROR:make' failedThe error occurs no matter which sqlsrv version I try to install (I tried 4.0.8 and all following preview and RC1).
Thank you, Hilmar