Linux - PHP缺mysql扩展导致连接超时的问题

==----------------------------------------------------------------------------------------------------------------------
-----== Linux 解决php缺mysql扩展导致连接超时的问题  参考：https://www.imooc.com/article/39504   【成功！！！】

1、进入源码包目录
    cd /fitness/software/php-5.6.36/php-5.6.36/ext/mysql
    
    [root@iZ8vb2uz59jd5pisp87ljjZ mysql]# pwd
    /fitness/software/php-5.6.36/php-5.6.36/ext/mysql
    [root@iZ8vb2uz59jd5pisp87ljjZ mysql]# ls
    config.m4   CREDITS    mysql.mak        package.xml  php_mysql.h   php_mysql.o          tests
    config.w32  mysql.dsp  mysql_mysqlnd.h  php_mysql.c  php_mysql.lo  php_mysql_structs.h


2、查看phpize是否存在
    cd /fitness/serve/php/bin
    
    [root@iZ8vb2uz59jd5pisp87ljjZ bin]# pwd
    /fitness/serve/php/bin
    [root@iZ8vb2uz59jd5pisp87ljjZ bin]# ls
    pear  peardev  pecl  phar  phar.phar  php  php-cgi  php-config  phpize

3、在/fitness/software/php-5.6.36/php-5.6.36/ext/mysql运行phpize
    即：
    cd /fitness/software/php-5.6.36/php-5.6.36/ext/mysql
    /fitness/serve/php/bin/phpize
    
    结果：
    [root@iZ8vb2uz59jd5pisp87ljjZ mysql]# /fitness/serve/php/bin/phpize
    Configuring for:
    PHP Api Version:         20131106
    Zend Module Api No:      20131226
    Zend Extension Api No:   220131226
    Cannot find autoconf. Please check your autoconf installation and the
    $PHP_AUTOCONF environment variable. Then, rerun this script.
    
    [root@iZ8vb2uz59jd5pisp87ljjZ mysql]# ls
    acinclude.m4  config.m4     CREDITS          missing        mysql_mysqlnd.h  php_mysql.lo         tests
    aclocal.m4    config.sub    install-sh       mkinstalldirs  package.xml      php_mysql.o
    build         configure.in  ltmain.sh        mysql.dsp      php_mysql.c      php_mysql_structs.h
    config.guess  config.w32    Makefile.global  mysql.mak      php_mysql.h      run-tests.php
    
    我们发现没有configure这个文件，再看上，有个报错：
    Cannot find autoconf. Please check your autoconf installation and the
    $PHP_AUTOCONF environment variable. Then, rerun this script.
    
    解决：
    yum install autoconf
    
    再次运行/fitness/serve/php/bin/phpize
    
    [root@iZ8vb2uz59jd5pisp87ljjZ mysql]# /fitness/serve/php/bin/phpize
    Configuring for:
    PHP Api Version:         20131106
    Zend Module Api No:      20131226
    Zend Extension Api No:   220131226
    
    没有报错了，查看
    [root@iZ8vb2uz59jd5pisp87ljjZ mysql]# ls
    acinclude.m4    config.guess  configure     install-sh       mkinstalldirs    package.xml   php_mysql.o
    aclocal.m4      config.h.in   configure.in  ltmain.sh        mysql.dsp        php_mysql.c   php_mysql_structs.h
    autom4te.cache  config.m4     config.w32    Makefile.global  mysql.mak        php_mysql.h   run-tests.php
    build           config.sub    CREDITS       missing          mysql_mysqlnd.h  php_mysql.lo  tests
    
    终于发现了configure文件！！！

4、运行configure，这时注意，要指明php-config文件的位置
    
    [root@iZ8vb2uz59jd5pisp87ljjZ bin]# pwd
    /fitness/serve/php/bin
    [root@iZ8vb2uz59jd5pisp87ljjZ bin]# ls
    pear  peardev  pecl  phar  phar.phar  php  php-cgi  php-config  phpize
    
    ./configure --with-php-config=/fitness/serve/php/bin/php-config --with-pdo-mysql=mysqlnd
    
    结果：
    [root@iZ8vb2uz59jd5pisp87ljjZ mysql]# ./configure --with-php-config=/fitness/serve/php/bin/php-config --with-pdo-mysql=mysqlnd
    configure: WARNING: unrecognized options: --with-pdo-mysql
    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... /fitness/serve/php
    checking for PHP includes... -I/fitness/serve/php/include/php -I/fitness/serve/php/include/php/main -I/fitness/serve/php/include/php/TSRM -I/fitness/serve/php/include/php/Zend -I/fitness/serve/php/include/php/ext -I/fitness/serve/php/include/php/ext/date/lib
    checking for PHP extension directory... /fitness/serve/php/lib/php/extensions/no-debug-non-zts-20131226
    checking for PHP installed headers prefix... /fitness/serve/php/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 for MySQL support... yes, shared
    checking for specified location of the MySQL UNIX socket... no
    checking for the location of libz... no
    checking for MySQL UNIX socket location... /tmp/mysql.sock
    checking for ld used by cc... /usr/bin/ld
    checking if the linker (/usr/bin/ld) is GNU ld... yes
    checking for /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 the maximum length of command line arguments... 1572864
    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 if cc supports -fno-rtti -fno-exceptions... no
    checking for cc option to produce PIC... -fPIC
    checking if cc PIC flag -fPIC works... yes
    checking if cc static flag -static works... no
    checking if cc supports -c -o file.o... 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
    
    creating libtool
    appending configuration tag "CXX" to libtool
    configure: creating ./config.status
    config.status: creating config.h
    configure: WARNING: unrecognized options: --with-pdo-mysql

5、编译安装，生成mysql.so文件
    make && make install
    
    creating libtool
    appending configuration tag "CXX" to libtool
    configure: creating ./config.status
    config.status: creating config.h
    configure: WARNING: unrecognized options: --with-pdo-mysql
    [root@iZ8vb2uz59jd5pisp87ljjZ mysql]# make && make install
    /bin/sh /fitness/software/php-5.6.36/php-5.6.36/ext/mysql/libtool --mode=link cc -DPHP_ATOM_INC -I/fitness/software/php-5.6.36/php-5.6.36/ext/mysql/include -I/fitness/software/php-5.6.36/php-5.6.36/ext/mysql/main -I/fitness/software/php-5.6.36/php-5.6.36/ext/mysql -I/fitness/serve/php/include/php -I/fitness/serve/php/include/php/main -I/fitness/serve/php/include/php/TSRM -I/fitness/serve/php/include/php/Zend -I/fitness/serve/php/include/php/ext -I/fitness/serve/php/include/php/ext/date/lib  -DHAVE_CONFIG_H  -g -O2   -o mysql.la -export-dynamic -avoid-version -prefer-pic -module -rpath /fitness/software/php-5.6.36/php-5.6.36/ext/mysql/modules  php_mysql.lo
    cc -shared  .libs/php_mysql.o   -Wl,-soname -Wl,mysql.so -o .libs/mysql.so
    creating mysql.la
    (cd .libs && rm -f mysql.la && ln -s ../mysql.la mysql.la)
    /bin/sh /fitness/software/php-5.6.36/php-5.6.36/ext/mysql/libtool --mode=install cp ./mysql.la /fitness/software/php-5.6.36/php-5.6.36/ext/mysql/modules
    cp ./.libs/mysql.so /fitness/software/php-5.6.36/php-5.6.36/ext/mysql/modules/mysql.so
    cp ./.libs/mysql.lai /fitness/software/php-5.6.36/php-5.6.36/ext/mysql/modules/mysql.la
    PATH="$PATH:/sbin" ldconfig -n /fitness/software/php-5.6.36/php-5.6.36/ext/mysql/modules
    ----------------------------------------------------------------------
    Libraries have been installed in:
       /fitness/software/php-5.6.36/php-5.6.36/ext/mysql/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'.
    
    Installing shared extensions:     /fitness/serve/php/lib/php/extensions/no-debug-non-zts-20131226/


6、修改php.ini文件，添加mysql.so扩展配置

    extension=mysql.so


7、重启php-fpm
    [8vb2uz59jd5pisp87ljjZ lib]# service php-fpm start
    Starting php-fpm [03-Jul-2019 11:52:30] NOTICE: PHP message: PHP Warning:  PHP Startup: Invalid library (maybe not a PHP library) 'mysql.so' in Unknown on line 0
    [03-Jul-2019 11:52:30] ERROR: unable to bind listening socket for address '127.0.0.1:9000': Address already in use (98)
    [03-Jul-2019 11:52:30] ERROR: FPM initialization failed
    
    杀死所有php-fpm
    killall php-fpm
    
    再启动
    service php-fpm start
    
    就没有报错了！


8、连接mysql，测试成功！！！

----------------------------------------------------------------------------------------------------------------------==