分类 服务器 下的文章

以下是参考官方文档安装ODBC驱动的过程,跟官方教程是一毛一样,只是加上了每行命令的说明。

添加安装源到本机

curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo

卸载部分包,避免冲突

yum remove unixODBC-utf16 unixODBC-utf16-devel

安装msodbcsql17

ACCEPT_EULA=Y yum install msodbcsql17

安装mssql-tools

ACCEPT_EULA=Y yum install mssql-tools

写入环境变量

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile

写入环境变量

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc

让刚刚写入的环境变量生效

source ~/.bashrc

安装unixODBC-devel

yum install unixODBC-devel

最后,查看/etc/odbcinst.ini文件内容

cat /etc/odbcinst.ini

可以看到最后面有[ODBC Driver 17 for SQL Server]的配置,恭喜你,驱动安装完成

[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/lib/psqlodbcw.so
Setup=/usr/lib/libodbcpsqlS.so
Driver64=/usr/lib64/psqlodbcw.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1

[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmyodbc5.so
Setup=/usr/lib/libodbcmyS.so
Driver64=/usr/lib64/libmyodbc5.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1

[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.4.so.1.1
UsageCount=1

最后,在PHP里测试下是否能正常连接,如果输出Connected就是成功了
注意更换成自己对应的信息:127.0.0.1数据库地址、1433数据库端口、jwj数据库名、sa数据库用户名、password数据库密码

<?php
try {
    $conn = new PDO('odbc:Driver={ODBC Driver 17 for SQL Server};Server=127.0.0.1,1433;Database=jwj;', 'sa', 'password');
} catch (PDOException $e) {
    exit('Error:' . $e->getMessage());
}
exit('Connected');

因业务需要,需要连接其它系统所使用的Microsoft SQL Server数据库,然后要使用PDO ODBC才能连接,但现在所使用的PHP环境没有装这个扩展,经过一系列踩坑,整理出了下面的教程。

安装unixODBC

unixODBC是一个数据库连接组件,安装pdo_odbc前需要安装这个,否则安装pdo_odbc时会出现Cannot find header file(s) for pdo_odbc错误

yum install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel

转到pdo_odbc源代码目录

从PHP5.1开始,PDO_ODBC包含在PHP源代码中。可以使用configure命令将PDO_ODBC扩展编译为静态或共享模块。
所以我们只需要转到pdo_odbc源代码目录进行编译,而不用再去另外下载了。

cd /www/server/php/56/src/ext/pdo_odbc

make clean

如果你在尝试这篇教程直接,尝试过其它网上的方法,先执行下以下命令清除缓存,否则加载扩展时可能会出现PHP Warning: PHP Startup: Invalid library (maybe not a PHP library) '/www/server/php/56/lib/php/extensions/no-debug-non-zts-20131226/pdo_odbc.so' in Unknown on line 0

make clean

phpize

phpize 命令是用来准备 PHP 扩展库的编译环境的,主要是根据系统信息生成对应的configure文件。

/www/server/php/56/bin/phpize

configure

./configure --with-php-config=/www/server/php/56/bin/php-config  --with-pdo-odbc=unixODBC,/usr/

执行结果

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... /www/server/php/56
checking for PHP includes... -I/www/server/php/56/include/php -I/www/server/php/56/include/php/main -I/www/server/php/56/include/php/TSRM -I/www/server/php/56/include/php/Zend -I/www/server/php/56/include/php/ext -I/www/server/php/56/include/php/ext/date/lib
checking for PHP extension directory... /www/server/php/56/lib/php/extensions/no-debug-non-zts-20131226
checking for PHP installed headers prefix... /www/server/php/56/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 ODBC v3 support for PDO... yes, shared
checking for PDO includes... checking for PDO includes... /www/server/php/56/include/php/ext
checking for selected PDO ODBC flavour... unixODBC
          libs       /usr//lib,
          headers    /usr//include
checking for odbc.h in /usr//include... no
checking for odbcsdk.h in /usr//include... no
checking for iodbc.h in /usr//include... no
checking for sqlunix.h in /usr//include... no
checking for sqltypes.h in /usr//include... yes
checking for sqlucode.h in /usr//include... yes
checking for sql.h in /usr//include... yes
checking for isql.h in /usr//include... no
checking for sqlext.h in /usr//include... yes
checking for isqlext.h in /usr//include... no
checking for udbcext.h in /usr//include... no
checking for sqlcli1.h in /usr//include... no
checking for LibraryManager.h in /usr//include... no
checking for cli0core.h in /usr//include... no
checking for cli0ext.h in /usr//include... no
checking for cli0cli.h in /usr//include... no
checking for cli0defs.h in /usr//include... no
checking for cli0env.h in /usr//include... no
checking for SQLBindCol in -lodbc... yes
checking for SQLAllocHandle in -lodbc... yes
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

make

make && make install

执行结果

/bin/sh /www/server/php/56/src/ext/pdo_odbc/libtool --mode=link cc -DPHP_ATOM_INC -I/www/server/php/56/src/ext/pdo_odbc/include -I/www/server/php/56/src/ext/pdo_odbc/main -I/www/server/php/56/src/ext/pdo_odbc -I/www/server/php/56/include/php -I/www/server/php/56/include/php/main -I/www/server/php/56/include/php/TSRM -I/www/server/php/56/include/php/Zend -I/www/server/php/56/include/php/ext -I/www/server/php/56/include/php/ext/date/lib  -DHAVE_CONFIG_H  -g -O2   -o pdo_odbc.la -export-dynamic -avoid-version -prefer-pic -module -rpath /www/server/php/56/src/ext/pdo_odbc/modules  pdo_odbc.lo odbc_driver.lo odbc_stmt.lo -Wl,-rpath,/usr//lib -L/usr//lib -lodbc
cc -shared  .libs/pdo_odbc.o .libs/odbc_driver.o .libs/odbc_stmt.o  -L/usr//lib -lodbc  -Wl,-rpath -Wl,/usr//lib -Wl,-soname -Wl,pdo_odbc.so -o .libs/pdo_odbc.so
creating pdo_odbc.la
(cd .libs && rm -f pdo_odbc.la && ln -s ../pdo_odbc.la pdo_odbc.la)
/bin/sh /www/server/php/56/src/ext/pdo_odbc/libtool --mode=install cp ./pdo_odbc.la /www/server/php/56/src/ext/pdo_odbc/modules
cp ./.libs/pdo_odbc.so /www/server/php/56/src/ext/pdo_odbc/modules/pdo_odbc.so
cp ./.libs/pdo_odbc.lai /www/server/php/56/src/ext/pdo_odbc/modules/pdo_odbc.la
PATH="$PATH:/sbin" ldconfig -n /www/server/php/56/src/ext/pdo_odbc/modules
----------------------------------------------------------------------
Libraries have been installed in:
   /www/server/php/56/src/ext/pdo_odbc/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:     /www/server/php/56/lib/php/extensions/no-debug-non-zts-20131226/

查看so文件是否生成

ls -lh /www/server/php/56/lib/php/extensions/no-debug-non-zts-20131226/
total 2.1M
-rwxr-xr-x 1 root root 1.3M Sep  3 15:13 opcache.a
-rwxr-xr-x 1 root root 610K Sep  3 15:13 opcache.so
-rwxr-xr-x 1 root root 126K Sep  3 15:13 pdo_odbc.so

配置php.ini

大概在配置文件九百多行的位置新建一行,加入以下代码

extension=/www/server/php/56/lib/php/extensions/no-debug-non-zts-20131226/pdo_odbc.so

重启php和httpd环境

重启php-fpm和nginx等

查看phpinfo()

查看phpinfo(),搜索PDO_ODBC,如果找到基本就是安装成功。

安装了扩展,还要在服务器安装数据库连接驱动才能连接SQL Server数据库,可以看我的下一篇文章。

查看磁盘剩余空间

# df -hl
分区/总大小/已使用空间/剩余空间/使用率/挂载路径
Filesystem      Size  Used Avail Use% Mounted on
/dev/vda1        40G  9.2G   29G  25% /
devtmpfs        1.9G     0  1.9G   0% /dev
tmpfs           1.9G     0  1.9G   0% /dev/shm
tmpfs           1.9G  340K  1.9G   1% /run
tmpfs           1.9G     0  1.9G   0% /sys/fs/cgroup
/dev/vdb        197G  114G   75G  61% /home/wwwroot
tmpfs           380M     0  380M   0% /run/user/0

查看某目录占用的空间大小

# du -sh /*

查找指定名称的文件

# find /data/www/ -name "27.log"
/data/www/bc3.bocaidj.com/runtime/log/201908/27.log
/data/www/bc3.bocaidj.com/runtime/log/201907/27.log
/data/www/bc2.bocaidj.com/_v507_runtime/log/201808/27.log
/data/www/bc2.bocaidj.com/_v507_runtime/log/201811/27.log
/data/www/bc2.bocaidj.com/_v507_runtime/log/201908/27.log
/data/www/bc2.bocaidj.com/_v507_runtime/log/201907/27.log
/data/www/bc2.bocaidj.com/_v507_runtime/log/201810/27.log

查找指定名称指定内容的文件

find /data/www/ -name "*.php" | xargs grep "game_categorys"
/data/www/application/api/controller/app/Guess.php:        $this->addData('game_categorys', $games);
/data/www/application/api/controller/system/Cache.php:        $this->addData('game_categorys', $games);

显示文件列表

显示隐藏文件

# ls -la
total 108
drwxr-xr-x 12 www-data www-data  4096 Jul  5 10:35 .
drwxr-xr-x  7 www-data www-data  4096 Jul  7 01:48 ..
drwxr-xr-x 14 www-data www-data  4096 Jul  5 10:31 application
-rwxr-xr-x  1 www-data www-data  1070 Jul  5 10:31 build.php
-rw-r--r--  1 www-data www-data   950 Jul  5 10:31 composer.json
-rw-r--r--  1 www-data www-data 37760 Jul  5 10:31 composer.lock
drwxr-xr-x  2 www-data www-data  4096 Jul  6 03:25 config
drwxr-xr-x  4 www-data www-data  4096 Jul  5 10:31 database
drwxr-xr-x  5 www-data www-data  4096 Jul  5 10:31 extend
-rwxr-xr-x  1 www-data www-data  1822 Jul  5 10:31 LICENSE.txt
drwxr-xr-x  2 www-data www-data  4096 Jul  5 15:50 lock
drwxr-xr-x  5 www-data www-data  4096 Jul  5 10:38 public
-rwxr-xr-x  1 www-data www-data  6356 Jul  5 10:31 README.md
drwxr-xr-x  2 www-data www-data  4096 Jul  5 10:31 route
drwxr-xr-x  7 www-data www-data  4096 Jul  5 15:41 runtime
drwxr-xr-x  5 www-data www-data  4096 Jul  5 10:31 thinkphp
drwxr-xr-x 20 www-data www-data  4096 Jul  5 10:31 vendor

压缩文件成tar.gz

# tar zcvf archive.tar.gz ./

解压缩tar.gz

# tar zxvf archive.tar.gz

最近,在阿里云的一台机子安装svn时,提示"Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"

# yum install -y subversion
Loaded plugins: fastestmirror
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
http://mirrors.cloud.aliyuncs.com/epel/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
http://mirrors.cloud.aliyuncs.com/centos/7/extras/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
http://mirrors.cloud.aliyuncs.com/centos/7/updates/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package subversion.x86_64 0:1.7.14-14.el7 will be installed
--> Processing Dependency: subversion-libs(x86-64) = 1.7.14-14.el7 for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_wc-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_subr-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_repos-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_ra_svn-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_ra_neon-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_ra_local-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_ra-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_fs_util-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_fs_fs-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_fs_base-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_fs-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_diff-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_delta-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_client-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libneon.so.27()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libaprutil-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libapr-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Running transaction check
---> Package apr.x86_64 0:1.4.8-3.el7_4.1 will be installed
---> Package apr-util.x86_64 0:1.5.2-6.el7 will be installed
---> Package neon.x86_64 0:0.30.0-3.el7 will be installed
--> Processing Dependency: libgnutls.so.28(GNUTLS_2_12)(64bit) for package: neon-0.30.0-3.el7.x86_64
--> Processing Dependency: libgnutls.so.28(GNUTLS_1_4)(64bit) for package: neon-0.30.0-3.el7.x86_64
--> Processing Dependency: libproxy.so.1()(64bit) for package: neon-0.30.0-3.el7.x86_64
--> Processing Dependency: libpakchois.so.0()(64bit) for package: neon-0.30.0-3.el7.x86_64
--> Processing Dependency: libgnutls.so.28()(64bit) for package: neon-0.30.0-3.el7.x86_64
---> Package subversion-libs.x86_64 0:1.7.14-14.el7 will be installed
--> Running transaction check
---> Package gnutls.x86_64 0:3.3.26-9.el7 will be installed
--> Processing Dependency: trousers >= 0.3.11.2 for package: gnutls-3.3.26-9.el7.x86_64
--> Processing Dependency: libnettle.so.4()(64bit) for package: gnutls-3.3.26-9.el7.x86_64
--> Processing Dependency: libhogweed.so.2()(64bit) for package: gnutls-3.3.26-9.el7.x86_64
---> Package libproxy.x86_64 0:0.4.11-11.el7 will be installed
--> Processing Dependency: libmodman.so.1()(64bit) for package: libproxy-0.4.11-11.el7.x86_64
---> Package pakchois.x86_64 0:0.4-10.el7 will be installed
--> Running transaction check
---> Package libmodman.x86_64 0:2.0.1-8.el7 will be installed
---> Package nettle.x86_64 0:2.7.1-8.el7 will be installed
---> Package trousers.x86_64 0:0.3.14-2.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================
 Package                         Arch                   Version                          Repository            Size
====================================================================================================================
Installing:
 subversion                      x86_64                 1.7.14-14.el7                    base                 1.0 M
Installing for dependencies:
 apr                             x86_64                 1.4.8-3.el7_4.1                  base                 103 k
 apr-util                        x86_64                 1.5.2-6.el7                      base                  92 k
 gnutls                          x86_64                 3.3.26-9.el7                     base                 677 k
 libmodman                       x86_64                 2.0.1-8.el7                      base                  28 k
 libproxy                        x86_64                 0.4.11-11.el7                    base                  64 k
 neon                            x86_64                 0.30.0-3.el7                     base                 165 k
 nettle                          x86_64                 2.7.1-8.el7                      base                 327 k
 pakchois                        x86_64                 0.4-10.el7                       base                  14 k
 subversion-libs                 x86_64                 1.7.14-14.el7                    base                 922 k
 trousers                        x86_64                 0.3.14-2.el7                     base                 289 k

Transaction Summary
====================================================================================================================
Install  1 Package (+10 Dependent packages)

Total download size: 3.6 M
Installed size: 12 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
apr-1.4.8-3.el7_4.1.x86_64.rpm FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/apr-1.4.8-3.el7_4.1.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
apr-util-1.5.2-6.el7.x86_64.rp FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/apr-util-1.5.2-6.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
gnutls-3.3.26-9.el7.x86_64.rpm FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/gnutls-3.3.26-9.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
libmodman-2.0.1-8.el7.x86_64.r FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/libmodman-2.0.1-8.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
libproxy-0.4.11-11.el7.x86_64. FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/libproxy-0.4.11-11.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
neon-0.30.0-3.el7.x86_64.rpm   FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/neon-0.30.0-3.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
nettle-2.7.1-8.el7.x86_64.rpm  FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/nettle-2.7.1-8.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
pakchois-0.4-10.el7.x86_64.rpm FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/pakchois-0.4-10.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
subversion-1.7.14-14.el7.x86_6 FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/subversion-1.7.14-14.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
subversion-libs-1.7.14-14.el7. FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/subversion-libs-1.7.14-14.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.
trousers-0.3.14-2.el7.x86_64.r FAILED
http://mirrors.cloud.aliyuncs.com/centos/7/os/x86_64/Packages/trousers-0.3.14-2.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: mirrors.cloud.aliyuncs.com; Unknown error"
Trying other mirror.


Error downloading packages:
  neon-0.30.0-3.el7.x86_64: [Errno 256] No more mirrors to try.
  trousers-0.3.14-2.el7.x86_64: [Errno 256] No more mirrors to try.
  libmodman-2.0.1-8.el7.x86_64: [Errno 256] No more mirrors to try.
  subversion-1.7.14-14.el7.x86_64: [Errno 256] No more mirrors to try.
  libproxy-0.4.11-11.el7.x86_64: [Errno 256] No more mirrors to try.
  pakchois-0.4-10.el7.x86_64: [Errno 256] No more mirrors to try.
  apr-1.4.8-3.el7_4.1.x86_64: [Errno 256] No more mirrors to try.
  nettle-2.7.1-8.el7.x86_64: [Errno 256] No more mirrors to try.
  gnutls-3.3.26-9.el7.x86_64: [Errno 256] No more mirrors to try.
  apr-util-1.5.2-6.el7.x86_64: [Errno 256] No more mirrors to try.
  subversion-libs-1.7.14-14.el7.x86_64: [Errno 256] No more mirrors to try.

经过查询资料得知,mirrors.cloud.aliyuncs.com是阿里云ECS VPC 用户专用的镜像源域名。
那不能说停就停吧?如果停了对阿里云上所有的ECS应该都会有很大影响。
然后换了另外一台阿里云的机器测试,发现另一台服务也是用的这个镜像源域名,但是却使用正常。

再排查机器配置,发现DNS不一样
问题机器的DNS是223.5.5.5223.6.6.6
正常机器的DNS是100.100.2.136100.100.2.138

最后修改DNS为正常机器的

# cat /etc/resolv.conf
nameserver 100.100.2.136
nameserver 100.100.2.138

再重新执行安装,就正常安装了

# yum install -y subversion
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package subversion.x86_64 0:1.7.14-14.el7 will be installed
--> Processing Dependency: subversion-libs(x86-64) = 1.7.14-14.el7 for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_wc-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_subr-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_repos-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_ra_svn-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_ra_neon-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_ra_local-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_ra-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_fs_util-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_fs_fs-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_fs_base-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_fs-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_diff-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_delta-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libsvn_client-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libneon.so.27()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libaprutil-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Processing Dependency: libapr-1.so.0()(64bit) for package: subversion-1.7.14-14.el7.x86_64
--> Running transaction check
---> Package apr.x86_64 0:1.4.8-3.el7_4.1 will be installed
---> Package apr-util.x86_64 0:1.5.2-6.el7 will be installed
---> Package neon.x86_64 0:0.30.0-3.el7 will be installed
--> Processing Dependency: libgnutls.so.28(GNUTLS_2_12)(64bit) for package: neon-0.30.0-3.el7.x86_64
--> Processing Dependency: libgnutls.so.28(GNUTLS_1_4)(64bit) for package: neon-0.30.0-3.el7.x86_64
--> Processing Dependency: libproxy.so.1()(64bit) for package: neon-0.30.0-3.el7.x86_64
--> Processing Dependency: libpakchois.so.0()(64bit) for package: neon-0.30.0-3.el7.x86_64
--> Processing Dependency: libgnutls.so.28()(64bit) for package: neon-0.30.0-3.el7.x86_64
---> Package subversion-libs.x86_64 0:1.7.14-14.el7 will be installed
--> Running transaction check
---> Package gnutls.x86_64 0:3.3.29-9.el7_6 will be installed
--> Processing Dependency: trousers >= 0.3.11.2 for package: gnutls-3.3.29-9.el7_6.x86_64
--> Processing Dependency: libnettle.so.4()(64bit) for package: gnutls-3.3.29-9.el7_6.x86_64
--> Processing Dependency: libhogweed.so.2()(64bit) for package: gnutls-3.3.29-9.el7_6.x86_64
---> Package libproxy.x86_64 0:0.4.11-11.el7 will be installed
--> Processing Dependency: libmodman.so.1()(64bit) for package: libproxy-0.4.11-11.el7.x86_64
---> Package pakchois.x86_64 0:0.4-10.el7 will be installed
--> Running transaction check
---> Package libmodman.x86_64 0:2.0.1-8.el7 will be installed
---> Package nettle.x86_64 0:2.7.1-8.el7 will be installed
---> Package trousers.x86_64 0:0.3.14-2.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===============================================================================================================================================================
 Package                                   Arch                             Version                                    Repository                         Size
===============================================================================================================================================================
Installing:
 subversion                                x86_64                           1.7.14-14.el7                              base                              1.0 M
Installing for dependencies:
 apr                                       x86_64                           1.4.8-3.el7_4.1                            base                              103 k
 apr-util                                  x86_64                           1.5.2-6.el7                                base                               92 k
 gnutls                                    x86_64                           3.3.29-9.el7_6                             updates                           680 k
 libmodman                                 x86_64                           2.0.1-8.el7                                base                               28 k
 libproxy                                  x86_64                           0.4.11-11.el7                              base                               64 k
 neon                                      x86_64                           0.30.0-3.el7                               base                              165 k
 nettle                                    x86_64                           2.7.1-8.el7                                base                              327 k
 pakchois                                  x86_64                           0.4-10.el7                                 base                               14 k
 subversion-libs                           x86_64                           1.7.14-14.el7                              base                              922 k
 trousers                                  x86_64                           0.3.14-2.el7                               base                              289 k

Transaction Summary
===============================================================================================================================================================
Install  1 Package (+10 Dependent packages)

Total download size: 3.6 M
Installed size: 12 M
Downloading packages:
(1/11): apr-1.4.8-3.el7_4.1.x86_64.rpm                                                                                                  | 103 kB  00:00:00
(2/11): libmodman-2.0.1-8.el7.x86_64.rpm                                                                                                |  28 kB  00:00:00
(3/11): libproxy-0.4.11-11.el7.x86_64.rpm                                                                                               |  64 kB  00:00:00
(4/11): apr-util-1.5.2-6.el7.x86_64.rpm                                                                                                 |  92 kB  00:00:00
(5/11): neon-0.30.0-3.el7.x86_64.rpm                                                                                                    | 165 kB  00:00:00
(6/11): nettle-2.7.1-8.el7.x86_64.rpm                                                                                                   | 327 kB  00:00:00
(7/11): pakchois-0.4-10.el7.x86_64.rpm                                                                                                  |  14 kB  00:00:00
(8/11): gnutls-3.3.29-9.el7_6.x86_64.rpm                                                                                                | 680 kB  00:00:00
(9/11): subversion-1.7.14-14.el7.x86_64.rpm                                                                                             | 1.0 MB  00:00:00
(10/11): trousers-0.3.14-2.el7.x86_64.rpm                                                                                               | 289 kB  00:00:00
(11/11): subversion-libs-1.7.14-14.el7.x86_64.rpm                                                                                       | 922 kB  00:00:00
---------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                           12 MB/s | 3.6 MB  00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Installing : apr-1.4.8-3.el7_4.1.x86_64                                                                                                                 1/11
  Installing : apr-util-1.5.2-6.el7.x86_64                                                                                                                2/11
  Installing : pakchois-0.4-10.el7.x86_64                                                                                                                 3/11
  Installing : nettle-2.7.1-8.el7.x86_64                                                                                                                  4/11
  Installing : libmodman-2.0.1-8.el7.x86_64                                                                                                               5/11
  Installing : libproxy-0.4.11-11.el7.x86_64                                                                                                              6/11
  Installing : trousers-0.3.14-2.el7.x86_64                                                                                                               7/11
  Installing : gnutls-3.3.29-9.el7_6.x86_64                                                                                                               8/11
  Installing : neon-0.30.0-3.el7.x86_64                                                                                                                   9/11
  Installing : subversion-libs-1.7.14-14.el7.x86_64                                                                                                      10/11
  Installing : subversion-1.7.14-14.el7.x86_64                                                                                                           11/11
  Verifying  : trousers-0.3.14-2.el7.x86_64                                                                                                               1/11
  Verifying  : libmodman-2.0.1-8.el7.x86_64                                                                                                               2/11
  Verifying  : neon-0.30.0-3.el7.x86_64                                                                                                                   3/11
  Verifying  : subversion-1.7.14-14.el7.x86_64                                                                                                            4/11
  Verifying  : subversion-libs-1.7.14-14.el7.x86_64                                                                                                       5/11
  Verifying  : apr-util-1.5.2-6.el7.x86_64                                                                                                                6/11
  Verifying  : nettle-2.7.1-8.el7.x86_64                                                                                                                  7/11
  Verifying  : pakchois-0.4-10.el7.x86_64                                                                                                                 8/11
  Verifying  : gnutls-3.3.29-9.el7_6.x86_64                                                                                                               9/11
  Verifying  : apr-1.4.8-3.el7_4.1.x86_64                                                                                                                10/11
  Verifying  : libproxy-0.4.11-11.el7.x86_64                                                                                                             11/11

Installed:
  subversion.x86_64 0:1.7.14-14.el7

Dependency Installed:
  apr.x86_64 0:1.4.8-3.el7_4.1                 apr-util.x86_64 0:1.5.2-6.el7        gnutls.x86_64 0:3.3.29-9.el7_6       libmodman.x86_64 0:2.0.1-8.el7
  libproxy.x86_64 0:0.4.11-11.el7              neon.x86_64 0:0.30.0-3.el7           nettle.x86_64 0:2.7.1-8.el7          pakchois.x86_64 0:0.4-10.el7
  subversion-libs.x86_64 0:1.7.14-14.el7       trousers.x86_64 0:0.3.14-2.el7

Complete!

# fdisk -lu /dev/vdb

Disk /dev/vdb: 107.4 GB, 107374182400 bytes, 209715200 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
# blkid /dev/vdb
/dev/vdb: UUID="047ad20b-3e2d-41d3-ba4d-72d22d5407d8" TYPE="ext3"
# e2fsck -n /dev/vdb
e2fsck 1.42.9 (28-Dec-2013)
Warning!  /dev/vdb is mounted.
Warning: skipping journal recovery because doing a read-only filesystem check.
/dev/vdb: clean, 11/6553600 files, 459382/26214400 blocks
# df
Filesystem     1K-blocks     Used Available Use% Mounted on
/dev/vda1       41151808  8534880  30503496  22% /
devtmpfs         1931336        0   1931336   0% /dev
tmpfs            1940844        0   1940844   0% /dev/shm
tmpfs            1940844      448   1940396   1% /run
tmpfs            1940844        0   1940844   0% /sys/fs/cgroup
tmpfs             388172        0    388172   0% /run/user/0
/dev/vdb       103081248 97838368         0 100% /home/wwwroot
# umount /dev/vdb
umount: /home/wwwroot: target is busy.
        (In some cases useful info about processes that use
         the device is found by lsof(8) or fuser(1))
# fuser -m /home/wwwroot
/home/wwwroot:       24402
# kill 24402
# umount /dev/vdb
# fdisk -lu /dev/vdb

Disk /dev/vdb: 107.4 GB, 107374182400 bytes, 209715200 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
# fdisk -u /dev/vdb
Welcome to fdisk (util-linux 2.23.2).

Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x56c34f1c.

Command (m for help): p

Disk /dev/vdb: 107.4 GB, 107374182400 bytes, 209715200 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x56c34f1c

   Device Boot      Start         End      Blocks   Id  System

Command (m for help): d
No partition is defined yet!

Command (m for help): p

Disk /dev/vdb: 107.4 GB, 107374182400 bytes, 209715200 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x56c34f1c

   Device Boot      Start         End      Blocks   Id  System

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
# fdisk /dev/vdb
Welcome to fdisk (util-linux 2.23.2).

Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xe00c1f00.

Command (m for help): d
No partition is defined yet!

Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-209715199, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-209715199, default 209715199):
Using default value 209715199
Partition 1 of type Linux and of size 100 GiB is set

Command (m for help): p

Disk /dev/vdb: 107.4 GB, 107374182400 bytes, 209715200 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0xe00c1f00

   Device Boot      Start         End      Blocks   Id  System
/dev/vdb1            2048   209715199   104856576   83  Linux

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
# lsblk /dev/vdb
NAME   MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
vdb    253:16   0  100G  0 disk
└─vdb1 253:17   0  100G  0 part
# e2fsck -n /dev/vdb1
e2fsck 1.42.9 (28-Dec-2013)
ext2fs_open2: Bad magic number in super-block
e2fsck: Superblock invalid, trying backup blocks...
e2fsck: Bad magic number in super-block while trying to open /dev/vdb1

The superblock could not be read or does not describe a correct ext2
filesystem.  If the device is valid and it really contains an ext2
filesystem (and not swap or ufs or something else), then the superblock
is corrupt, and you might try running e2fsck with an alternate superblock:
    e2fsck -b 8193 <device>
# partprobe /dev/vdb
# resize2fs /dev/vdb1
resize2fs 1.42.9 (28-Dec-2013)
resize2fs: Bad magic number in super-block while trying to open /dev/vdb1
Couldn't find valid filesystem superblock.
# resize2fs /dev/vdb
resize2fs 1.42.9 (28-Dec-2013)
Filesystem at /dev/vdb is mounted on /home/wwwroot; on-line resizing required
old_desc_blocks = 7, new_desc_blocks = 13
The filesystem on /dev/vdb is now 52428800 blocks long.
# df -lh
Filesystem      Size  Used Avail Use% Mounted on
/dev/vda1        40G  8.2G   30G  22% /
devtmpfs        1.9G     0  1.9G   0% /dev
tmpfs           1.9G     0  1.9G   0% /dev/shm
tmpfs           1.9G  340K  1.9G   1% /run
tmpfs           1.9G     0  1.9G   0% /sys/fs/cgroup
/dev/vdb        197G   94G   95G  50% /home/wwwroot
tmpfs           380M     0  380M   0% /run/user/0