CentOS9 SQL Server 2014 connect failed. Microsoft ODBC Driver 18 for SQL Server : TCP Provider: Error code 0x2746.

xinghailong commented 9 months ago

PHP version

PHP 8.1.19 (cli) (built: May 26 2023 15:33:22) (NTS) 
Copyright (c) The PHP Group 
Zend Engine v4.1.19, Copyright (c) Zend Technologies
    with Zend OPcache v8.1.19, Copyright (c), by Zend Technologies

PHP SQLSRV or PDO_SQLSRV version

pdo_sqlsrv

pdo_sqlsrv support => enabled
ExtensionVer => 5.10.0

Directive => Local Value => Master Value
pdo_sqlsrv.client_buffer_max_kb_size => 10240 => 10240
pdo_sqlsrv.log_severity => 0 => 0
pdo_sqlsrv.report_additional_errors => 1 => 1
pdo_sqlsrv.set_locale_info => 2 => 2

sqlsrv

sqlsrv support => enabled
ExtensionVer => 5.10.0

Directive => Local Value => Master Value
sqlsrv.ClientBufferMaxKBSize => 10240 => 10240
sqlsrv.LogSeverity => 0 => 0
sqlsrv.LogSubsystems => 0 => 0
sqlsrv.SetLocaleInfo => 2 => 2
sqlsrv.WarningsReturnAsErrors => On => On

OpenSSL version

OpenSSL 1.1.1w  11 Sep 2023
built on: Mon Sep 25 06:42:58 2023 UTC
platform: linux-x86_64
options:  bn(64,64) rc4(8x,int) des(int) idea(int) blowfish(ptr)
compiler: gcc -fPIC -pthread -m64 -Wa,--noexecstack -Wall -O3 -DOPENSSL_USE_NODELETE -DL_ENDIAN -DOPENSSL_PIC -DOPENSSL_CPUID_OBJ -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DKECCAK1600_ASM -DRC4_ASM -DMD5_ASM -DAESNI_ASM -DVPAES_ASM -DGHASH_ASM -DECP_NISTZ256_ASM -DX25519_ASM -DPOLY1305_ASM -DNDEBUG
OPENSSLDIR: "/usr/local/ssl"
ENGINESDIR: "/usr/local/ssl/lib/engines-1.1"
Seeding source: os-specific

Microsoft ODBC Driver version

Microsoft ODBC Driver 18

SQL Server version

Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB5021045) - 12.0.6444.4 (X64) 
    Dec 23 2022 00:46:32 
    Copyright (c) Microsoft Corporation
    Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

Client operating system

CentOS Stream release 9

Problem description

sqlcmd or pdo connect fail，same error message：
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : TCP Provider: Error code 0x2746.
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection.

Repro code or steps to reproduce

$dsn =  'sqlsrv:Server=' . $host . ',' . $port . ';Database=' . $dbname . ';TrustServerCertificate=yes;Encrypt=no';
$dbh = new PDO($dsn, $user, $password, $options);

# sqlcmd -d huoban -S *********,1433 -U ***** -P ******

xinghailong commented 9 months ago

try to change CipherString = DEFAULT@SECLEVEL=1 CipherString = DEFAULT@SECLEVEL=0 do not work.

xinghailong commented 9 months ago

try to change openssl 3.0.0 => 1.1.1k/ 1.1.1w /1.1.0k. do not work.

xinghailong commented 9 months ago

17:35:45.978580 execve("/opt/mssql-tools18/bin/sqlcmd", ["sqlcmd", "-d", "*****", "-S", "*******", "-U", "*****", "-P", "*********"], 0x7ffc4d566928 /* 33 vars */) = 0
17:35:45.982997 brk(NULL)               = 0x24dc000
17:35:45.983157 arch_prctl(0x3001 /* ARCH_??? */, 0x7ffdc8e57d30) = -1 EINVAL (Invalid argument)
17:35:45.983309 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
17:35:45.983406 openat(AT_FDCWD, "/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3
17:35:45.983497 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=33115, ...}, AT_EMPTY_PATH) = 0
17:35:45.985521 mmap(NULL, 33115, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d7c7000
17:35:45.985606 close(3)                = 0
17:35:45.985687 openat(AT_FDCWD, "/lib64/libdl.so.2", O_RDONLY|O_CLOEXEC) = 3
17:35:45.985772 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0P\20\0\0\0\0\0\0"..., 832) = 832
17:35:45.985851 newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=15456, ...}, AT_EMPTY_PATH) = 0
17:35:45.985954 mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7faa0d7c5000
17:35:45.986050 mmap(NULL, 16424, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7faa0d7c0000
17:35:45.986128 mmap(0x7faa0d7c1000, 4096, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1000) = 0x7faa0d7c1000
17:35:45.986204 mmap(0x7faa0d7c2000, 4096, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7faa0d7c2000
17:35:45.986284 mmap(0x7faa0d7c3000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7faa0d7c3000
17:35:45.986368 close(3)                = 0
17:35:45.986446 openat(AT_FDCWD, "/lib64/librt.so.1", O_RDONLY|O_CLOEXEC) = 3
17:35:45.986523 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220\20\0\0\0\0\0\0"..., 832) = 832
17:35:45.986600 newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=15640, ...}, AT_EMPTY_PATH) = 0
17:35:45.986680 mmap(NULL, 16440, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7faa0d7bb000
17:35:45.986755 mmap(0x7faa0d7bc000, 4096, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1000) = 0x7faa0d7bc000
17:35:45.986831 mmap(0x7faa0d7bd000, 4096, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7faa0d7bd000
17:35:45.986920 mmap(0x7faa0d7be000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7faa0d7be000
17:35:45.987003 close(3)                = 0
17:35:45.987075 openat(AT_FDCWD, "/lib64/libodbc.so.2", O_RDONLY|O_CLOEXEC) = 3
17:35:45.987153 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240k\0\0\0\0\0\0"..., 832) = 832
17:35:45.987228 newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=429872, ...}, AT_EMPTY_PATH) = 0
17:35:45.987323 mmap(NULL, 2539112, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7faa0d400000
17:35:45.987401 mprotect(0x7faa0d462000, 2093056, PROT_NONE) = 0
17:35:45.987478 mmap(0x7faa0d661000, 32768, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x61000) = 0x7faa0d661000
17:35:45.987558 mmap(0x7faa0d669000, 11880, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7faa0d669000
17:35:45.987639 close(3)                = 0
17:35:45.987713 openat(AT_FDCWD, "/lib64/libstdc++.so.6", O_RDONLY|O_CLOEXEC) = 3
17:35:45.987793 read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260\22\n\0\0\0\0\0"..., 832) = 832
17:35:45.987872 newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=2306456, ...}, AT_EMPTY_PATH) = 0
17:35:45.987962 mmap(NULL, 2254848, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7faa0d000000
17:35:45.988037 mprotect(0x7faa0d099000, 1560576, PROT_NONE) = 0
17:35:45.988112 mmap(0x7faa0d099000, 1089536, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x99000) = 0x7faa0d099000
17:35:45.988186 mmap(0x7faa0d1a3000, 466944, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1a3000) = 0x7faa0d1a3000
17:35:45.988264 mmap(0x7faa0d216000, 57344, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x215000) = 0x7faa0d216000
17:35:45.988355 mmap(0x7faa0d224000, 10240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7faa0d224000
17:35:45.988444 close(3)                = 0
17:35:45.988526 openat(AT_FDCWD, "/lib64/libm.so.6", O_RDONLY|O_CLOEXEC) = 3
17:35:45.988612 read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220\323\0\0\0\0\0\0"..., 832) = 832
17:35:45.988695 newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=904656, ...}, AT_EMPTY_PATH) = 0
17:35:45.988782 mmap(NULL, 893184, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7faa0d6e0000
17:35:45.988864 mmap(0x7faa0d6ed000, 458752, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xd000) = 0x7faa0d6ed000
17:35:45.988954 mmap(0x7faa0d75d000, 376832, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x7d000) = 0x7faa0d75d000
17:35:45.989035 mmap(0x7faa0d7b9000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xd8000) = 0x7faa0d7b9000
17:35:45.989125 close(3)                = 0
17:35:45.989204 openat(AT_FDCWD, "/lib64/libgcc_s.so.1", O_RDONLY|O_CLOEXEC) = 3
17:35:45.989298 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\3605\0\0\0\0\0\0"..., 832) = 832
17:35:45.989403 newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=108136, ...}, AT_EMPTY_PATH) = 0
17:35:45.989490 mmap(NULL, 107208, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7faa0d6c5000
17:35:45.989574 mprotect(0x7faa0d6c8000, 90112, PROT_NONE) = 0
17:35:45.989656 mmap(0x7faa0d6c8000, 73728, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x3000) = 0x7faa0d6c8000
17:35:45.989739 mmap(0x7faa0d6da000, 12288, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7faa0d6da000
17:35:45.989821 mmap(0x7faa0d6de000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x18000) = 0x7faa0d6de000
17:35:45.989917 close(3)                = 0
17:35:45.989999 openat(AT_FDCWD, "/lib64/libpthread.so.0", O_RDONLY|O_CLOEXEC) = 3
17:35:45.990084 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0P\20\0\0\0\0\0\0"..., 832) = 832
17:35:45.990168 newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=15480, ...}, AT_EMPTY_PATH) = 0
17:35:45.990251 mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7faa0d6c3000
17:35:45.990332 mmap(NULL, 16424, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7faa0d6be000
17:35:45.990408 mmap(0x7faa0d6bf000, 4096, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1000) = 0x7faa0d6bf000
17:35:45.990488 mmap(0x7faa0d6c0000, 4096, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7faa0d6c0000
17:35:45.990566 mmap(0x7faa0d6c1000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7faa0d6c1000
17:35:45.990652 close(3)                = 0
17:35:45.990726 openat(AT_FDCWD, "/lib64/libc.so.6", O_RDONLY|O_CLOEXEC) = 3
17:35:45.990807 read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p\0\4\0\0\0\0\0"..., 832) = 832
17:35:45.990885 pread64(3, "\6\0\0\0\4\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 784, 64) = 784
17:35:45.990969 pread64(3, "\4\0\0\0 \0\0\0\5\0\0\0GNU\0\2\0\0\300\4\0\0\0\3\0\0\0\0\0\0\0"..., 48, 848) = 48
17:35:45.991046 pread64(3, "\4\0\0\0\24\0\0\0\3\0\0\0GNU\0\332d\216\3277\t\f\313\222+\371\276\226\3313F"..., 68, 896) = 68
17:35:45.991123 newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=2387200, ...}, AT_EMPTY_PATH) = 0
17:35:45.991206 pread64(3, "\6\0\0\0\4\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 784, 64) = 784
17:35:45.991294 mmap(NULL, 2133936, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7faa0cc00000
17:35:45.991374 mprotect(0x7faa0cc28000, 1892352, PROT_NONE) = 0
17:35:45.991469 mmap(0x7faa0cc28000, 1527808, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x28000) = 0x7faa0cc28000
17:35:45.991566 mmap(0x7faa0cd9d000, 360448, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x19d000) = 0x7faa0cd9d000
17:35:45.991649 mmap(0x7faa0cdf6000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1f5000) = 0x7faa0cdf6000
17:35:45.991730 mmap(0x7faa0cdfc000, 53168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7faa0cdfc000
17:35:45.991814 close(3)                = 0
17:35:45.991900 openat(AT_FDCWD, "/lib64/libltdl.so.7", O_RDONLY|O_CLOEXEC) = 3
17:35:45.991999 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360(\0\0\0\0\0\0"..., 832) = 832
17:35:45.992074 newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=45512, ...}, AT_EMPTY_PATH) = 0
17:35:45.992153 mmap(NULL, 45160, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7faa0d6b2000
17:35:45.992228 mprotect(0x7faa0d6b4000, 32768, PROT_NONE) = 0
17:35:45.992316 mmap(0x7faa0d6b4000, 20480, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7faa0d6b4000
17:35:45.992390 mmap(0x7faa0d6b9000, 8192, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x7000) = 0x7faa0d6b9000
17:35:45.992464 mmap(0x7faa0d6bc000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x9000) = 0x7faa0d6bc000
17:35:45.992547 close(3)                = 0
17:35:45.992643 mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7faa0d6b0000
17:35:45.992722 arch_prctl(ARCH_SET_FS, 0x7faa0d6b1240) = 0
17:35:45.992791 set_tid_address(0x7faa0d6b1510) = 21458
17:35:45.992859 set_robust_list(0x7faa0d6b1520, 24) = 0
17:35:45.992935 rseq(0x7faa0d6b1be0, 0x20, 0, 0x53053053) = 0
17:35:45.993068 mprotect(0x7faa0cdf6000, 16384, PROT_READ) = 0
17:35:45.993164 mprotect(0x7faa0d6bc000, 4096, PROT_READ) = 0
17:35:45.993238 mprotect(0x7faa0d6c1000, 4096, PROT_READ) = 0
17:35:45.993327 mprotect(0x7faa0d6de000, 4096, PROT_READ) = 0
17:35:45.993419 mprotect(0x7faa0d7b9000, 4096, PROT_READ) = 0
17:35:45.993593 mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7faa0d6ae000
17:35:45.994174 mprotect(0x7faa0d216000, 53248, PROT_READ) = 0
17:35:45.994252 mprotect(0x7faa0d7be000, 4096, PROT_READ) = 0
17:35:45.994355 mprotect(0x7faa0d7c3000, 4096, PROT_READ) = 0
17:35:45.994494 mprotect(0x7faa0d804000, 8192, PROT_READ) = 0
17:35:45.994584 prlimit64(0, RLIMIT_STACK, NULL, {rlim_cur=8192*1024, rlim_max=RLIM64_INFINITY}) = 0
17:35:45.994671 munmap(0x7faa0d7c7000, 33115) = 0
17:35:45.994784 getrandom("\x7f\x77\x97\x8d\xe0\x62\xc4\x49", 8, GRND_NONBLOCK) = 8
17:35:45.994856 brk(NULL)               = 0x24dc000
17:35:45.994923 brk(0x24fd000)          = 0x24fd000
17:35:45.995026 rt_sigaction(SIGHUP, {sa_handler=0x420c10, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7faa0cc54df0}, NULL, 8) = 0
17:35:45.995100 rt_sigaction(SIGQUIT, {sa_handler=0x420c10, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7faa0cc54df0}, NULL, 8) = 0
17:35:45.995173 rt_sigaction(SIGABRT, {sa_handler=0x420c10, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7faa0cc54df0}, NULL, 8) = 0
17:35:45.995241 rt_sigaction(SIGTERM, {sa_handler=0x420c10, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7faa0cc54df0}, NULL, 8) = 0
17:35:45.995311 rt_sigaction(SIGINT, {sa_handler=0x420c10, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7faa0cc54df0}, NULL, 8) = 0
17:35:45.995384 readlink("/proc/self/exe", "/opt/mssql-tools18/bin/sqlcmd", 4095) = 29
17:35:45.995499 futex(0x7faa0d2246bc, FUTEX_WAKE_PRIVATE, 2147483647) = 0
17:35:45.995610 futex(0x7faa0d2246c8, FUTEX_WAKE_PRIVATE, 2147483647) = 0
17:35:45.995704 openat(AT_FDCWD, "/opt/mssql-tools18/bin/../share/resources/en_US/SQLCMD.rll", O_RDONLY) = 3
17:35:45.995805 read(3, "MZ\220\0\3\0\0\0\4\0\0\0\377\377\0\0\270\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 8191) = 8191
17:35:45.995893 lseek(3, 0, SEEK_END)   = 24576
17:35:45.995979 lseek(3, 0, SEEK_CUR)   = 24576
17:35:45.996060 lseek(3, 0, SEEK_SET)   = 0
17:35:45.996141 read(3, "MZ\220\0\3\0\0\0\4\0\0\0\377\377\0\0\270\0\0\0\0\0\0\0@\0\0\0\0\0\0\0"..., 24576) = 24576
17:35:45.996231 close(3)                = 0
17:35:45.996330 openat(AT_FDCWD, "/usr/lib/locale/locale-archive", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:45.996421 openat(AT_FDCWD, "/usr/share/locale/locale.alias", O_RDONLY|O_CLOEXEC) = 3
17:35:45.996505 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=2998, ...}, AT_EMPTY_PATH) = 0
17:35:45.996588 read(3, "# Locale name alias data base.\n#"..., 4096) = 2998
17:35:45.996675 read(3, "", 4096)       = 0
17:35:45.996749 close(3)                = 0
17:35:45.996831 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_IDENTIFICATION", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:45.996918 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_IDENTIFICATION", O_RDONLY|O_CLOEXEC) = 3
17:35:45.997002 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=369, ...}, AT_EMPTY_PATH) = 0
17:35:45.997088 mmap(NULL, 369, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d803000
17:35:45.997165 close(3)                = 0
17:35:45.997246 openat(AT_FDCWD, "/usr/lib64/gconv/gconv-modules.cache", O_RDONLY) = 3
17:35:45.997329 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=26988, ...}, AT_EMPTY_PATH) = 0
17:35:45.997411 mmap(NULL, 26988, PROT_READ, MAP_SHARED, 3, 0) = 0x7faa0d7c9000
17:35:45.997487 close(3)                = 0
17:35:45.997562 futex(0x7faa0cdfba6c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
17:35:45.997643 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_MEASUREMENT", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:45.997744 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_MEASUREMENT", O_RDONLY|O_CLOEXEC) = 3
17:35:45.997825 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=23, ...}, AT_EMPTY_PATH) = 0
17:35:45.997920 mmap(NULL, 23, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d7c8000
17:35:45.997999 close(3)                = 0
17:35:45.998079 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_TELEPHONE", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:45.998160 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_TELEPHONE", O_RDONLY|O_CLOEXEC) = 3
17:35:45.998241 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=59, ...}, AT_EMPTY_PATH) = 0
17:35:45.998325 mmap(NULL, 59, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d7c7000
17:35:45.998402 close(3)                = 0
17:35:45.998483 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_ADDRESS", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:45.998565 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_ADDRESS", O_RDONLY|O_CLOEXEC) = 3
17:35:45.998646 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=167, ...}, AT_EMPTY_PATH) = 0
17:35:45.998728 mmap(NULL, 167, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d6ad000
17:35:45.998807 close(3)                = 0
17:35:45.998888 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_NAME", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:45.998978 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_NAME", O_RDONLY|O_CLOEXEC) = 3
17:35:45.999058 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=77, ...}, AT_EMPTY_PATH) = 0
17:35:45.999140 mmap(NULL, 77, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d6ac000
17:35:45.999218 close(3)                = 0
17:35:45.999318 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_PAPER", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:45.999402 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_PAPER", O_RDONLY|O_CLOEXEC) = 3
17:35:45.999483 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=34, ...}, AT_EMPTY_PATH) = 0
17:35:45.999565 mmap(NULL, 34, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d6ab000
17:35:45.999643 close(3)                = 0
17:35:45.999725 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_MESSAGES", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:45.999814 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_MESSAGES", O_RDONLY|O_CLOEXEC) = 3
17:35:45.999884 newfstatat(3, "", {st_mode=S_IFDIR|0755, st_size=4096, ...}, AT_EMPTY_PATH) = 0
17:35:45.999955 close(3)                = 0
17:35:46.000005 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_MESSAGES/SYS_LC_MESSAGES", O_RDONLY|O_CLOEXEC) = 3
17:35:46.000059 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=57, ...}, AT_EMPTY_PATH) = 0
17:35:46.000114 mmap(NULL, 57, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d6aa000
17:35:46.000165 close(3)                = 0
17:35:46.000220 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_MONETARY", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:46.000293 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_MONETARY", O_RDONLY|O_CLOEXEC) = 3
17:35:46.000348 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=286, ...}, AT_EMPTY_PATH) = 0
17:35:46.000404 mmap(NULL, 286, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d6a9000
17:35:46.000457 close(3)                = 0
17:35:46.000513 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_COLLATE", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:46.000566 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_COLLATE", O_RDONLY|O_CLOEXEC) = 3
17:35:46.000618 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=2586930, ...}, AT_EMPTY_PATH) = 0
17:35:46.000672 mmap(NULL, 2586930, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0c800000
17:35:46.000722 close(3)                = 0
17:35:46.000787 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_TIME", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:46.000841 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_TIME", O_RDONLY|O_CLOEXEC) = 3
17:35:46.000892 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=3284, ...}, AT_EMPTY_PATH) = 0
17:35:46.000953 mmap(NULL, 3284, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d6a8000
17:35:46.001002 close(3)                = 0
17:35:46.001057 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_NUMERIC", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:46.001110 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_NUMERIC", O_RDONLY|O_CLOEXEC) = 3
17:35:46.001162 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=54, ...}, AT_EMPTY_PATH) = 0
17:35:46.001214 mmap(NULL, 54, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d6a7000
17:35:46.001307 close(3)                = 0
17:35:46.001390 openat(AT_FDCWD, "/usr/lib/locale/en_US.UTF-8/LC_CTYPE", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
17:35:46.001470 openat(AT_FDCWD, "/usr/lib/locale/en_US.utf8/LC_CTYPE", O_RDONLY|O_CLOEXEC) = 3
17:35:46.001527 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=346132, ...}, AT_EMPTY_PATH) = 0
17:35:46.001584 mmap(NULL, 346132, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7faa0d3ab000
17:35:46.001637 close(3)                = 0
17:35:46.001735 geteuid()               = 0
17:35:46.001792 socket(AF_UNIX, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
17:35:46.001850 connect(3, {sa_family=AF_UNIX, sun_path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
17:35:46.001947 close(3)                = 0
17:35:46.002019 socket(AF_UNIX, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
17:35:46.002084 connect(3, {sa_family=AF_UNIX, sun_path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
17:35:46.002155 close(3)                = 0
17:35:46.002217 newfstatat(AT_FDCWD, "/etc/nsswitch.conf", {st_mode=S_IFREG|0644, st_size=2980, ...}, 0) = 0
17:35:46.002292 newfstatat(AT_FDCWD, "/", {st_mode=S_IFDIR|0555, st_size=4096, ...}, 0) = 0
17:35:46.002351 openat(AT_FDCWD, "/etc/nsswitch.conf", O_RDONLY|O_CLOEXEC) = 3
17:35:46.002414 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=2980, ...}, AT_EMPTY_PATH) = 0
17:35:46.002475 read(3, "# Generated by authselect on Thu"..., 4096) = 2980
17:35:46.002539 brk(0x251e000)          = 0x251e000
17:35:46.002598 read(3, "", 4096)       = 0
17:35:46.002650 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=2980, ...}, AT_EMPTY_PATH) = 0
17:35:46.002708 close(3)                = 0
17:35:46.002765 openat(AT_FDCWD, "/etc/passwd", O_RDONLY|O_CLOEXEC) = 3
17:35:46.002824 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=1730, ...}, AT_EMPTY_PATH) = 0
17:35:46.002882 lseek(3, 0, SEEK_SET)   = 0
17:35:46.002946 read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1730
17:35:46.003003 close(3)                = 0
17:35:46.003116 uname({sysname="Linux", nodename="backend-group04-saas-php08-test01-env01", ...}) = 0
17:35:46.003209 brk(0x2548000)          = 0x2548000
17:35:46.003271 fstat(0, {st_mode=S_IFCHR|0620, st_rdev=makedev(0x88, 0), ...}) = 0
17:35:46.003343 readlink("/proc/self/exe", "/opt/mssql-tools18/bin/sqlcmd", 4095) = 29
17:35:46.003411 openat(AT_FDCWD, "/opt/mssql-tools18/bin/../share/resources/en_US/BatchParserGrammar.dfa", O_RDONLY) = 3
17:35:46.003470 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=48088, ...}, AT_EMPTY_PATH) = 0
17:35:46.003525 brk(0x2569000)          = 0x2569000
17:35:46.003577 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=48088, ...}, AT_EMPTY_PATH) = 0
17:35:46.003633 lseek(3, 45056, SEEK_SET) = 45056
17:35:46.003683 read(3, "\6\0\0\0-\0\0\0-\0\0\0\17\0\0\0000\0\0\09\0\0\0\17\0\0\0A\0\0\0"..., 3032) = 3032
17:35:46.003735 lseek(3, 0, SEEK_SET)   = 0
17:35:46.003786 read(3, "\26\0\0\0XLSS\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 45056) = 45056
17:35:46.003856 read(3, "\6\0\0\0-\0\0\0-\0\0\0\17\0\0\0000\0\0\09\0\0\0\17\0\0\0A\0\0\0"..., 4096) = 3032
17:35:46.003913 close(3)                = 0
17:35:46.003996 readlink("/proc/self/exe", "/opt/mssql-tools18/bin/sqlcmd", 4095) = 29
17:35:46.004087 openat(AT_FDCWD, "/opt/mssql-tools18/bin/../share/resources/en_US/BatchParserGrammar.llr", O_RDONLY) = 3
17:35:46.004167 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=10196, ...}, AT_EMPTY_PATH) = 0
17:35:46.004248 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=10196, ...}, AT_EMPTY_PATH) = 0
17:35:46.004326 lseek(3, 8192, SEEK_SET) = 8192
17:35:46.004395 read(3, "\6\0\0\0\25\0\0 G\0\0\0\25\0\0 H\0\0\0\25\0\0 R\0\0\0\25\0\0 "..., 2004) = 2004
17:35:46.004470 lseek(3, 0, SEEK_SET)   = 0
17:35:46.004539 read(3, "CYSS\\\0\0\0\201\0\0\0\370\4\0\0\30\2\0\0\370\4\0\0\274\5\0\0 \7\0\0"..., 8192) = 8192
17:35:46.004610 read(3, "\6\0\0\0\25\0\0 G\0\0\0\25\0\0 H\0\0\0\25\0\0 R\0\0\0\25\0\0 "..., 4096) = 2004
17:35:46.004681 close(3)                = 0
17:35:46.004772 openat(AT_FDCWD, "/usr/lib64/gconv/UTF-16.so", O_RDONLY|O_CLOEXEC) = 3
17:35:46.004849 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0000\21\0\0\0\0\0\0"..., 832) = 832
17:35:46.004931 newfstatat(3, "", {st_mode=S_IFREG|0755, st_size=19632, ...}, AT_EMPTY_PATH) = 0
17:35:46.005009 mmap(NULL, 20576, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7faa0d6a1000
17:35:46.005082 mmap(0x7faa0d6a2000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1000) = 0x7faa0d6a2000
17:35:46.005160 mmap(0x7faa0d6a4000, 4096, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x3000) = 0x7faa0d6a4000
17:35:46.005231 mmap(0x7faa0d6a5000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x3000) = 0x7faa0d6a5000
17:35:46.005329 close(3)                = 0
17:35:46.005414 mprotect(0x7faa0d6a5000, 4096, PROT_READ) = 0
17:35:46.005540 openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3
17:35:46.005623 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=163, ...}, AT_EMPTY_PATH) = 0
17:35:46.005698 read(3, "[ODBC Driver 18 for SQL Server]\n"..., 4096) = 163
17:35:46.005779 read(3, "", 4096)       = 0
17:35:46.005848 close(3)                = 0
17:35:46.005926 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory)
17:35:46.006018 openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3
17:35:46.006136 newfstatat(3, "", {st_mode=S_IFREG|0644, st_size=163, ...}, AT_EMPTY_PATH) = 0
17:35:46.006220 read(3, "[ODBC Driver 18 for SQL Server]\n"..., 4096) = 163
17:35:46.006305 read(3, "", 4096)       = 0
17:35:46.006373 close(3)                = 0
17:35:46.006442 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory)
17:35:46.006532 brk(0x2590000)          = 0x2590000
17:35:46.006604 brk(0x2588000)          = 0x2588000
17:35:46.006689 brk(0x25b7000)          = 0x25b7000
17:35:46.006758 brk(0x2598000)          = 0x2598000
17:35:46.006832 rt_sigaction(SIGRT_1, {sa_handler=0x7faa0cc9cb70, sa_mask=[], sa_flags=SA_RESTORER|SA_ONSTACK|SA_RESTART|SA_SIGINFO, sa_restorer=0x7faa0cc54df0}, NULL, 8) = 0
17:35:46.006916 rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
17:35:46.006986 mmap(NULL, 8392704, PROT_NONE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7faa0bfff000
17:35:46.007056 mprotect(0x7faa0c000000, 8388608, PROT_READ|PROT_WRITE) = 0
17:35:46.007244 rt_sigprocmask(SIG_BLOCK, ~[], [], 8) = 0
17:35:46.007317 clone3({flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, child_tid=0x7faa0c7ff910, parent_tid=0x7faa0c7ff910, exit_signal=0, stack=0x7faa0bfff000, stack_size=0x7fff00, tls=0x7faa0c7ff640} => {parent_tid=[21459]}, 88) = 21459
17:35:46.007455 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
17:35:46.007546 futex(0x7ffdc8e57be0, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 0, NULL, FUTEX_BITSET_MATCH_ANY) = 0
17:35:46.034831 futex(0x2507370, FUTEX_WAKE_PRIVATE, 1) = 0
17:35:46.035101 write(2, "Sqlcmd: Error: Microsoft ODBC Dr"..., 186Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : TCP Provider: Error code 0x2746.
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection.
) = 186
17:35:46.035715 exit_group(1)           = ?
17:35:46.036288 +++ exited with 1 +++

manhthang2504 commented 9 months ago

In terminal, run update-crypto-policies --set DEFAULT:SHA1

xinghailong commented 9 months ago

@manhthang2504 Attempted to execute and restarted the client's server，not work

Setting system policy to DEFAULT:SHA1
Note: System-wide crypto policies are applied on application start-up.
It is recommended to restart the system for the change of policies
to fully take place.

v-makouz commented 9 months ago

Can you run isql -v -k "DRIVER={ODBC Driver 18 for SQL Server};SERVER=...;UID=...;PWD=..." ? Just to make sure it's the routines::unsupported protocol error

microsoft / msphpsql

CentOS9 SQL Server 2014 connect failed. Microsoft ODBC Driver 18 for SQL Server : TCP Provider: Error code 0x2746. #1480