search

microsoft / homebrew-mssql-release

Other
91 stars 31 forks source link

Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' #20

Closed d34th4ck3r closed 6 years ago

d34th4ck3r commented 6 years ago

I am trying to get mssql working on my OSX machine. However, it keeps giving me error: 

$ sqlcmd -S 0.0.0.0,1401 -U SA -P P@55w0rd -i database-setup/sql/initialize.sql     
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found.

Although, I am pretty sure, my file is in that location:

$ ls -la /usr/local/lib/libmsodbcsql.17.dylib  
lrwxr-xr-x  1 localadmin  admin  64  7  4 16:38 /usr/local/lib/libmsodbcsql.17.dylib -> /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib 
$ ls -la /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib
-r--r--r--  1 localadmin  admin  2539360  7  4 15:34 /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib

I know this question has been asked multiple times but none of the available solutions have worked for me. Things I have tried:

v-chojas commented 6 years ago

Please post output of otool -L /usr/local/lib/libmsodbcsql.17.dylib and specify your exact OS and Homebrew version.

d34th4ck3r commented 6 years ago 
$ otool -L /usr/local/lib/libmsodbcsql.17.dylib
/usr/local/lib/libmsodbcsql.17.dylib:
    /usr/local/opt/msodbcsql17/lib/libmsodbcsql.dylib (compatibility version 0.0.1, current version 1.0.1)
    /System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation (compatibility version 150.0.0, current version 1259.11.0)
    /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1226.10.1)
    /usr/local/lib/libodbcinst.2.dylib (compatibility version 3.0.0, current version 3.0.0)
    /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0)
    /System/Library/Frameworks/Kerberos.framework/Versions/A/Kerberos (compatibility version 5.0.0, current version 6.0.0)
    /usr/lib/libcurl.4.dylib (compatibility version 7.0.0, current version 8.0.0)
    /usr/local/opt/openssl/lib/libssl.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0)
    /usr/lib/libiconv.2.dylib (compatibility version 7.0.0, current version 7.0.0)
    /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 120.1.0)

OS: macOS High Sierra 10.13.3

Homebrew: 

$ brew --version
Homebrew 1.7.1
Homebrew/homebrew-core (git revision 9be56; last commit 2018-07-27)
v-chojas commented 6 years ago

sudo chmod a+x /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib

d34th4ck3r commented 6 years ago

That didn't help:

$ sudo chmod a+x /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib
Password:

$ ls -la /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib
-r-xr-xr-x  1 localadmin  admin  2539360  7  4 15:34 /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib

$ !sql
sqlcmd -S 0.0.0.0,1401 -U SA -P P@55w0rd -i database-setup/sql/initialize.sql
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found.
v-chojas commented 6 years ago

Try to run your command with sudo dtruss and check which file it is not finding.

d34th4ck3r commented 6 years ago

Here is the output of sudo dtruss:

$ sudo dtruss sqlcmd -S 0.0.0.0,1401 -U SA -P P@55w0rd
Password:
dtrace: system integrity protection is on, some features will not be available

SYSCALL(args)        = return
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found.
madvise(0x10359F000, 0x2000, 0x5)        = 0 0
open("/dev/dtracehelper\0", 0x2, 0xFFFFFFFFEC6D8BD0)         = 3 0
ioctl(0x3, 0x80086804, 0x7FFEEC6D8B30)       = 0 0
close(0x3)       = 0 0
access("/AppleInternal/XBS/.isChrooted\0", 0x0, 0x0)         = -1 Err#2
thread_selfid(0x0, 0x0, 0x0)         = 9339426 0
bsdthread_register(0x7FFF60A23C50, 0x7FFF60A23C40, 0x2000)       = 1073742047 0
issetugid(0x0, 0x0, 0x0)         = 0 0
mprotect(0x103658000, 0x1000, 0x0)       = 0 0
mprotect(0x10365F000, 0x1000, 0x0)       = 0 0
mprotect(0x103660000, 0x1000, 0x0)       = 0 0
mprotect(0x103667000, 0x1000, 0x0)       = 0 0
mprotect(0x1035E9000, 0x88, 0x1)         = 0 0
mprotect(0x1035EB000, 0x1000, 0x1)       = 0 0
mprotect(0x1035E9000, 0x88, 0x3)         = 0 0
mprotect(0x1035E9000, 0x88, 0x1)         = 0 0
getpid(0x0, 0x0, 0x0)        = 436 0
stat64("/AppleInternal/XBS/.isChrooted\0", 0x7FFEEC6D8028, 0x0)      = -1 Err#2
stat64("/AppleInternal\0", 0x7FFEEC6D80C0, 0x0)      = -1 Err#2
csops(0x1B4, 0x7, 0x7FFEEC6D7B60)        = -1 Err#22
dtrace: error on enabled probe ID 2190 (ID 566: syscall::sysctl:return): invalid kernel access in action #10 at DIF offset 40
csops(0x1B4, 0x7, 0x7FFEEC6D7450)        = -1 Err#22
geteuid(0x0, 0x0, 0x0)       = 0 0
getuid(0x0, 0x0, 0x0)        = 0 0
dtrace: error on enabled probe ID 2190 (ID 566: syscall::sysctl:return): invalid kernel access in action #10 at DIF offset 40
gettid(0x7FFEEC6D6CE8, 0x7FFEEC6D6CEC, 0x0)      = -1 Err#3
geteuid(0x0, 0x0, 0x0)       = 0 0
getegid(0x0, 0x0, 0x0)       = 0 0
gettid(0x7FFEEC6D6CC8, 0x7FFEEC6D6CCC, 0x0)      = -1 Err#3
geteuid(0x0, 0x0, 0x0)       = 0 0
getegid(0x0, 0x0, 0x0)       = 0 0
sigaction(0x1, 0x7FFEEC6D91F8, 0x0)      = 0 0
sigaction(0x3, 0x7FFEEC6D91F8, 0x0)      = 0 0
sigaction(0x6, 0x7FFEEC6D91F8, 0x0)      = 0 0
sigaction(0xF, 0x7FFEEC6D91F8, 0x0)      = 0 0
sigaction(0x2, 0x7FFEEC6D91F8, 0x0)      = 0 0
access("/etc/localtime\0", 0x4, 0x0)         = 0 0
open_nocancel("/etc/localtime\0", 0x0, 0x0)      = 3 0
fstat64(0x3, 0x7FFEEC6D89C8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
issetugid(0x0, 0x0, 0x0)         = 0 0
open_nocancel("/var/db/timezone/zoneinfo/posixrules\0", 0x0, 0x0)        = 3 0
fstat64(0x3, 0x7FFEEC6D8818, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
shm_open(0x7FFF60A18DEF, 0x0, 0x0)       = 3 0
mmap(0x0, 0x1000, 0x1, 0x1, 0x3, 0x0)        = 0x1035EC000 0
close_nocancel(0x3)      = 0 0
getrlimit(0x1008, 0x7FFEEC6D85C0, 0x0)       = 0 0
open_nocancel("/usr/local/bin/../share/resources/en_US/SQLCMD.rll\0", 0x0, 0x1B6)        = 3 0
fstat64(0x3, 0x7FFEEC6D8478, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
lseek(0x3, 0x0, 0x1)         = 23040 0
fstat64(0x3, 0x7FFEEC6D8520, 0x0)        = 0 0
lseek(0x3, 0x0, 0x0)         = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
lseek(0x3, 0x0, 0x0)         = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
lseek(0x3, 0x0, 0x0)         = 0 0
lseek(0x3, 0x5A00, 0x0)      = 23040 0
close_nocancel(0x3)      = 0 0
geteuid(0x0, 0x0, 0x0)       = 0 0
geteuid(0x0, 0x0, 0x0)       = 0 0
open_nocancel("/etc/master.passwd\0", 0x0, 0x1B6)        = 3 0
fstat64(0x3, 0x7FFEEC6D36C0, 0x0)        = 0 0
fstat64(0x3, 0x7FFEEC6D25B8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
dtrace: error on enabled probe ID 2190 (ID 566: syscall::sysctl:return): invalid kernel access in action #10 at DIF offset 40
open_nocancel("/usr/share/locale/en_US.UTF-8/LC_COLLATE\0", 0x0, 0x7)        = 3 0
fcntl_nocancel(0x3, 0x3, 0x0)        = 0 0
fstat64(0x3, 0x7FFEEC6D81B8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/share/locale/en_US.UTF-8/LC_CTYPE\0", 0x0, 0x5)      = 3 0
fcntl_nocancel(0x3, 0x3, 0x0)        = 0 0
fstat64(0x3, 0x7FFEEC6D8308, 0x0)        = 0 0
fstat64(0x3, 0x7FFEEC6D8118, 0x0)        = 0 0
lseek(0x3, 0x0, 0x1)         = 0 0
lseek(0x3, 0x0, 0x0)         = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/share/locale/en_US.UTF-8/LC_MESSAGES/LC_MESSAGES\0", 0x0, 0xFFFFFFFFFFFFFFF4)        = 3 0
fstat64(0x3, 0x7FFEEC6D82F0, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/share/locale/en_US.UTF-8/LC_MONETARY\0", 0x0, 0x8)       = 3 0
fstat64(0x3, 0x7FFEEC6D82F0, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/share/locale/en_US.UTF-8/LC_NUMERIC\0", 0x0, 0x7)        = 3 0
fstat64(0x3, 0x7FFEEC6D82F0, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/share/locale/en_US.UTF-8/LC_TIME\0", 0x0, 0x4)       = 3 0
fstat64(0x3, 0x7FFEEC6D82F0, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
fstat64(0x0, 0x7FFEEC6D88F0, 0x0)        = 0 0
open_nocancel("/usr/local/bin/../share/resources/en_US/BatchParserGrammar.dfa\0", 0x0, 0x1B6)        = 3 0
fstat64(0x3, 0x7FFEEC6D8328, 0x0)        = 0 0
fstat64(0x3, 0x7FFEEC6D8420, 0x0)        = 0 0
lseek(0x3, 0x0, 0x1)         = 0 0
lseek(0x3, 0x0, 0x0)         = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/bin/../share/resources/en_US/BatchParserGrammar.llr\0", 0x0, 0x1B6)        = 3 0
fstat64(0x3, 0x7FFEEC6D8348, 0x0)        = 0 0
fstat64(0x3, 0x7FFEEC6D8440, 0x0)        = 0 0
lseek(0x3, 0x0, 0x1)         = 0 0
lseek(0x3, 0x0, 0x0)         = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x7FFEEC6D5108, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x7FFEEC6D5118, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x7FFEEC6D5048, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x7FFEEC6D5058, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
bsdthread_create(0x103587160, 0x7FA73CE063A0, 0x80000)       = 246456320 0
thread_selfid(0x0, 0x0, 0x0)         = 9339444 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB04738, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB04748, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB04738, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB04748, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB042F8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB04308, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DC8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DD8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DC8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DD8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DC8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DD8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DC8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DD8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DC8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DD8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DC8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DD8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DC8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DD8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DC8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DD8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DC8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DD8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DC8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
open_nocancel("/Users/localadmin/.odbcinst.ini\0", 0x0, 0x1B6)       = 3 0
fstat64(0x3, 0x70000EB03DD8, 0x0)        = 0 0
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
dtrace: error on enabled probe ID 2167 (ID 954: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
close_nocancel(0x3)      = 0 0
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB05F00)       = 0 0
getattrlist("/usr/local\0", 0x10D7B4F48, 0x70000EB05F00)         = 0 0
getattrlist("/usr/local/lib\0", 0x10D7B4F48, 0x70000EB05F00)         = 0 0
getattrlist("/usr/local/lib/libmsodbcsql.17.dylib\0", 0x10D7B4F48, 0x70000EB05F00)       = 0 0
readlink("/usr/local/lib/libmsodbcsql.17.dylib\0", 0x70000EB05300, 0x400)        = 64 0
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB05F00)       = 0 0
getattrlist("/usr/local\0", 0x10D7B4F48, 0x70000EB05F00)         = 0 0
getattrlist("/usr/local/Cellar\0", 0x10D7B4F48, 0x70000EB05F00)      = 0 0
getattrlist("/usr/local/Cellar/msodbcsql17\0", 0x10D7B4F48, 0x70000EB05F00)      = 0 0
getattrlist("/usr/local/Cellar/msodbcsql17/17.1.0.1\0", 0x10D7B4F48, 0x70000EB05F00)         = 0 0
getattrlist("/usr/local/Cellar/msodbcsql17/17.1.0.1/lib\0", 0x10D7B4F48, 0x70000EB05F00)         = 0 0
getattrlist("/usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib\0", 0x10D7B4F48, 0x70000EB05F00)       = 0 0
stat64("/usr/local/lib/libmsodbcsql.17.dylib\0", 0x70000EB067C0, 0x0)        = 0 0
open("/usr/local/lib/libmsodbcsql.17.dylib\0", 0x0, 0x0)         = 3 0
dtrace: error on enabled probe ID 2181 (ID 468: syscall::pread:return): invalid kernel access in action #12 at DIF offset 44
mmap(0x103668000, 0x19D000, 0x5, 0x12, 0x3, 0x0)         = 0x103668000 0
mmap(0x103805000, 0x19000, 0x3, 0x12, 0x3, 0x19D000)         = 0x103805000 0
mmap(0x103825000, 0xB5F60, 0x1, 0x12, 0x3, 0x1B6000)         = 0x103825000 0
madvise(0x103825000, 0x4000, 0x2)        = 0 0
close(0x3)       = 0 0
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB05C70)       = 0 0
getattrlist("/usr/local\0", 0x10D7B4F48, 0x70000EB05C70)         = 0 0
getattrlist("/usr/local/lib\0", 0x10D7B4F48, 0x70000EB05C70)         = 0 0
getattrlist("/usr/local/lib/libodbcinst.2.dylib\0", 0x10D7B4F48, 0x70000EB05C70)         = -1 Err#2
stat64("/usr/local/lib/libodbcinst.2.dylib\0", 0x70000EB06530, 0x0)      = -1 Err#2
getattrlist("/Users\0", 0x10D7B4F48, 0x70000EB06040)         = 0 0
getattrlist("/Users/localadmin\0", 0x10D7B4F48, 0x70000EB06040)      = 0 0
getattrlist("/Users/localadmin/lib\0", 0x10D7B4F48, 0x70000EB06040)      = -1 Err#2
stat64("/Users/localadmin/lib/libodbcinst.2.dylib\0", 0x70000EB06900, 0x0)       = -1 Err#2
getattrlist("/Users\0", 0x10D7B4F48, 0x70000EB061D0)         = 0 0
getattrlist("/Users/localadmin\0", 0x10D7B4F48, 0x70000EB061D0)      = 0 0
getattrlist("/Users/localadmin/lib\0", 0x10D7B4F48, 0x70000EB061D0)      = -1 Err#2
getattrlist("/Users\0", 0x10D7B4F48, 0x70000EB05C10)         = 0 0
getattrlist("/Users/localadmin\0", 0x10D7B4F48, 0x70000EB05C10)      = 0 0
getattrlist("/Users/localadmin/lib\0", 0x10D7B4F48, 0x70000EB05C10)      = -1 Err#2
stat64("/Users/localadmin/lib\0", 0x70000EB064D0, 0x0)       = -1 Err#2
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB06040)       = 0 0
getattrlist("/usr/local\0", 0x10D7B4F48, 0x70000EB06040)         = 0 0
getattrlist("/usr/local/lib\0", 0x10D7B4F48, 0x70000EB06040)         = 0 0
getattrlist("/usr/local/lib/libodbcinst.2.dylib\0", 0x10D7B4F48, 0x70000EB06040)         = -1 Err#2
stat64("/usr/local/lib/libodbcinst.2.dylib\0", 0x70000EB06900, 0x0)      = -1 Err#2
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB061D0)       = 0 0
getattrlist("/usr/local\0", 0x10D7B4F48, 0x70000EB061D0)         = 0 0
getattrlist("/usr/local/lib\0", 0x10D7B4F48, 0x70000EB061D0)         = 0 0
getattrlist("/usr/local/lib/libodbcinst.2.dylib\0", 0x10D7B4F48, 0x70000EB061D0)         = -1 Err#2
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB05C10)       = 0 0
getattrlist("/usr/local\0", 0x10D7B4F48, 0x70000EB05C10)         = 0 0
getattrlist("/usr/local/lib\0", 0x10D7B4F48, 0x70000EB05C10)         = 0 0
getattrlist("/usr/local/lib/libodbcinst.2.dylib\0", 0x10D7B4F48, 0x70000EB05C10)         = -1 Err#2
stat64("/usr/local/lib/libodbcinst.2.dylib\0", 0x70000EB064D0, 0x0)      = -1 Err#2
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB06040)       = 0 0
getattrlist("/usr/lib\0", 0x10D7B4F48, 0x70000EB06040)       = 0 0
getattrlist("/usr/lib/libodbcinst.2.dylib\0", 0x10D7B4F48, 0x70000EB06040)       = -1 Err#2
stat64("/usr/lib/libodbcinst.2.dylib\0", 0x70000EB06900, 0x0)        = -1 Err#2
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB061D0)       = 0 0
getattrlist("/usr/lib\0", 0x10D7B4F48, 0x70000EB061D0)       = 0 0
getattrlist("/usr/lib/libodbcinst.2.dylib\0", 0x10D7B4F48, 0x70000EB061D0)       = -1 Err#2
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB05C10)       = 0 0
getattrlist("/usr/lib\0", 0x10D7B4F48, 0x70000EB05C10)       = 0 0
getattrlist("/usr/lib/libodbcinst.2.dylib\0", 0x10D7B4F48, 0x70000EB05C10)       = -1 Err#2
stat64("/usr/lib/libodbcinst.2.dylib\0", 0x70000EB064D0, 0x0)        = -1 Err#2
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB06300)       = 0 0
getattrlist("/usr/local\0", 0x10D7B4F48, 0x70000EB06300)         = 0 0
getattrlist("/usr/local/lib\0", 0x10D7B4F48, 0x70000EB06300)         = 0 0
getattrlist("/usr/local/lib/libodbcinst.2.dylib\0", 0x10D7B4F48, 0x70000EB06300)         = -1 Err#2
getattrlist("/usr\0", 0x10D7B4F48, 0x70000EB05D40)       = 0 0
getattrlist("/usr/local\0", 0x10D7B4F48, 0x70000EB05D40)         = 0 0
getattrlist("/usr/local/lib\0", 0x10D7B4F48, 0x70000EB05D40)         = 0 0
getattrlist("/usr/local/lib/libodbcinst.2.dylib\0", 0x10D7B4F48, 0x70000EB05D40)         = -1 Err#2
stat64("/usr/local/lib/libodbcinst.2.dylib\0", 0x70000EB06600, 0x0)      = -1 Err#2
munmap(0x103805000, 0x20000)         = 0 0
munmap(0x103825000, 0xB6000)         = 0 0
munmap(0x103668000, 0x19D000)        = 0 0
psynch_cvbroad(0x7FFEEC6D9158, 0x100, 0x100)         = 257 0
__disable_threadsignal(0x1, 0x0, 0x0)        = 0 0
psynch_cvwait(0x7FFEEC6D9158, 0x100000100, 0x0)      = 0 0
dtrace: error on enabled probe ID 2165 (ID 956: syscall::write_nocancel:return): invalid kernel access in action #12 at DIF offset 92
v-chojas commented 6 years ago

Could you check the file libodbcinst.2.dylib using ls -l /usr/local/lib/libodbcinst.2.dylib ?

Also, try using isql instead of sqlcmd ---

isql -v -k "Driver=ODBC Driver 17 for SQL Server;Server=yourserver;UID=youruser;PWD=yourpassword"

d34th4ck3r commented 6 years ago

That file doesn't exist.

$ ls -l /usr/local/lib/libodbcinst.2.dylib
ls: /usr/local/lib/libodbcinst.2.dylib: No such file or directory

And the command doesn't work either.

$ isql -v -k "Driver=ODBC Driver 17 for SQL Server;Server=0.0.0.0;UID=sa;PWD=P@55w0rd"
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found
[ISQL]ERROR: Could not SQLDriverConnect
v-makouz commented 6 years ago

It sounds like something went wrong with installation of unixODBC, normally there should be symlink: /usr/local/lib/libodbcinst.2.dylib -> ../Cellar/unixodbc/2.3.6/lib/libodbcinst.2.dylib

Can you look at the contents of the brew Cellar and see if the unixodbc directory is there? ls -l /usr/local/Cellar/ ls -l /usr/local/Cellar/unixodbc/2.3.6/lib/libodbcinst.2.dylib (or whatever the version, if t's not 2.3.6)

If it is then it should be possible to re-create the symlink manually.

v-makouz commented 6 years ago

If I delete the link (/usr/local/lib/libodbcinst.2.dylib) I get the same error running isql, so if that's all it is try: ln /usr/local/Cellar/unixodbc/2.3.6/lib/libodbcinst.2.dylib /usr/local/lib/libodbcinst.2.dylib

Replacing the version if it isn't 2.3.6, you can check the version by running odbcinst -j

d34th4ck3r commented 6 years ago

That precisely was the problem. Thanks for helping out! The command started working once I ran

ln /usr/local/Cellar/unixodbc/2.3.6/lib/libodbcinst.2.dylib /usr/local/lib/libodbcinst.2.dylib
jackfruhecolab commented 6 years ago

@d34th4ck3r Please re-open this, I had the same issue tonight. OSX 10.13.6 Attempting to get drivers installed, was getting the exact error at the top of this thread, but mine was coming in via the PHP driver.

There must be something up with the installer not symlinking the unixodbc directory, none of mine has symlinks (and like the other reports, my libmsodbcsql.17.dylib was fine)

I ended up using

ln -s /usr/local/Cellar/unixodbc/2.3.7/lib/libodbc.2.dylib /usr/local/lib/ ln -s /usr/local/Cellar/unixodbc/2.3.7/lib/libodbccr.2.dylib /usr/local/lib/ ln -s /usr/local/Cellar/unixodbc/2.3.7/lib/libodbcinst.2.dylib /usr/local/lib/

And my webpage started connecting to MSSQL.

Please see about fixing this in the install process.

Thanks!

v-makouz commented 6 years ago

@jackfruhecolab Could you describe in more detail the install process? Did you have unixODBC installed before or was it installed as part of the driver installation? And any other details. We tried to reproduce the issue on clean VMs under different scenarios and it always worked correctly, it would be good to figure out what causes unixODBC install to not symlink.

jackfruhecolab commented 6 years ago

I'm sure it was all mucked up. I couldn't find a good tutorial that said what to install, what the pre-reqs were, etc... I do know I installed the 5.3 drivers prior to knowing there was an odbc requirement.

if you've tested it and it works, then perhaps I did something in a different order than your test. Is there a definitive guide to follow that outlines all the steps in the correct order? I'd love to look it over, maybe I'll see something I did out of sequence, or missed altogether.

Thanks!

sal1ner0 commented 5 years ago

Please reopen...Still getting this issue -> OSX 10.14.4..and i tried everything..

symlink is there.. iMac:lib snap$ ls -ls /usr/local/lib/libmsodbcsql.17.dylib 0 lrwxr-xr-x 1 snap admin 56 Mar 26 15:11 /usr/local/lib/libmsodbcsql.17.dylib -> ../Cellar/msodbcsql17/17.3.1.1/lib/libmsodbcsql.17.dylib

odbcinst -j unixODBC 2.3.7

dtruss write_nocancel(0x1, "SqlState 01000, Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found\n\0", 0x57) = 87 0

unixodbc iMac:lib snap$ ls -la /usr/local/Cellar/unixodbc/2.3.7/lib/libodbc.2.dylib -rw-r--r-- 1 snap staff 373876 Mar 26 15:10 /usr/local/Cellar/unixodbc/2.3.7/lib/libodbc.2.dylib

Anyone can help me pls???

v-makouz commented 5 years ago

@sal1ner0 Can you attach the full dtruss output? Also, just to cover all the bases can you try otool -L /usr/local/lib/libmsodbcsql.17.dylib ?

sal1ner0 commented 5 years ago

Sure..here you have iMac:lib snap$ otool -L /usr/local/lib/libmsodbcsql.17.dylib /usr/local/lib/libmsodbcsql.17.dylib: /usr/local/opt/msodbcsql17/lib/libmsodbcsql.dylib (compatibility version 0.0.1, current version 3.1.1) /System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation (compatibility version 150.0.0, current version 1259.11.0) /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1226.10.1) /usr/local/lib/libodbcinst.2.dylib (compatibility version 3.0.0, current version 3.0.0) /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0) /System/Library/Frameworks/Kerberos.framework/Versions/A/Kerberos (compatibility version 5.0.0, current version 6.0.0) /usr/local/opt/openssl/lib/libssl.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0) /usr/lib/libiconv.2.dylib (compatibility version 7.0.0, current version 7.0.0) /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 120.1.0)

DTRUSS iMac:lib snap$ sudo dtruss sqlcmd -S 95.130.53.131 SYSCALL(args) = return SqlState 01000, Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found open("/dev/dtracehelper\0", 0x2, 0xFFFFFFFFE01720C0) = 3 0 ioctl(0x3, 0x80086804, 0x7FFEE0171ED0) = 0 0 close(0x3) = 0 0 madvise(0x10FB13000, 0x2000, 0x5) = 0 0 access("/AppleInternal/XBS/.isChrooted\0", 0x0, 0x0) = -1 Err#2 bsdthread_register(0x7FFF6EB86400, 0x7FFF6EB863F0, 0x2000) = 1073742047 0 sysctlbyname(kern.bootargs, 0xD, 0x7FFEE01710C0, 0x7FFEE01710B8, 0x0) = 0 0 issetugid(0x0, 0x0, 0x0) = 0 0 ioctl(0x2, 0x4004667A, 0x7FFEE0170734) = 0 0 mprotect(0x10FBC6000, 0x1000, 0x0) = 0 0 mprotect(0x10FBCB000, 0x1000, 0x0) = 0 0 mprotect(0x10FBCC000, 0x1000, 0x0) = 0 0 mprotect(0x10FBD1000, 0x1000, 0x0) = 0 0 mprotect(0x10FBC4000, 0x90, 0x1) = 0 0 mprotect(0x10FBB8000, 0x1000, 0x1) = 0 0 mprotect(0x10FBC4000, 0x90, 0x3) = 0 0 mprotect(0x10FBC4000, 0x90, 0x1) = 0 0 getpid(0x0, 0x0, 0x0) = 45294 0 stat64("/AppleInternal\0", 0x7FFEE0171530, 0x0) = -1 Err#2 csops(0xB0EE, 0x7, 0x7FFEE0171060) = -1 Err#22 proc_info(0x2, 0xB0EE, 0xD) = 64 0 csops(0xB0EE, 0x7, 0x7FFEE01708A0) = -1 Err#22 geteuid(0x0, 0x0, 0x0) = 0 0 getuid(0x0, 0x0, 0x0) = 0 0 sysctl([CTL_KERN, 14, 1, 45294, 0, 0] (4), 0x7FFEE016FEB8, 0x7FFEE016FE98, 0x0, 0x0) = 0 0 gettid(0x7FFEE01701A8, 0x7FFEE01701AC, 0x0) = -1 Err#3 geteuid(0x0, 0x0, 0x0) = 0 0 getegid(0x0, 0x0, 0x0) = 0 0 gettid(0x7FFEE0170188, 0x7FFEE017018C, 0x0) = -1 Err#3 geteuid(0x0, 0x0, 0x0) = 0 0 getegid(0x0, 0x0, 0x0) = 0 0 sigaction(0x1, 0x7FFEE0172258, 0x0) = 0 0 sigaction(0x3, 0x7FFEE0172258, 0x0) = 0 0 sigaction(0x6, 0x7FFEE0172258, 0x0) = 0 0 sigaction(0xF, 0x7FFEE0172258, 0x0) = 0 0 sigaction(0x2, 0x7FFEE0172258, 0x0) = 0 0 access("/etc/localtime\0", 0x4, 0x0) = 0 0 open_nocancel("/etc/localtime\0", 0x0, 0x0) = 3 0 fstat64(0x3, 0x7FFEE01719E8, 0x0) = 0 0 read_nocancel(0x3, "TZif2\0", 0xA1E8) = 2611 0 close_nocancel(0x3) = 0 0 issetugid(0x0, 0x0, 0x0) = 0 0 open_nocancel("/var/db/timezone/zoneinfo/posixrules\0", 0x0, 0x0) = 3 0 fstat64(0x3, 0x7FFEE0171818, 0x0) = 0 0 read_nocancel(0x3, "TZif2\0", 0xA1E8) = 3519 0 close_nocancel(0x3) = 0 0 madvise(0x10FBDE000, 0xB000, 0x9) = 0 0 madvise(0x10FBD2000, 0xB000, 0x9) = 0 0 shm_open(0x7FFF6EB79CD8, 0x0, 0x0) = 3 0 mmap(0x0, 0x1000, 0x1, 0x1, 0x3, 0x0) = 0x10FBE9000 0 close_nocancel(0x3) = 0 0 getrlimit(0x1008, 0x7FFEE0171670, 0x0) = 0 0 open_nocancel("/usr/local/bin/../share/resources/en_US/SQLCMD.rll\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE01714F8, 0x0) = 0 0 read_nocancel(0x3, "MZ\220\0", 0x1000) = 4096 0 lseek(0x3, 0x0, 0x1) = 4096 0 fstat64(0x3, 0x7FFEE01715B0, 0x0) = 0 0 lseek(0x3, 0x5000, 0x0) = 20480 0 read_nocancel(0x3, " \0", 0x1000) = 2560 0 lseek(0x3, 0x5000, 0x0) = 20480 0 read_nocancel(0x3, " \0", 0x1000) = 2560 0 lseek(0x3, 0x0, 0x0) = 0 0 read_nocancel(0x3, "MZ\220\0", 0x1000) = 4096 0 read_nocancel(0x3, "a\0", 0x1000) = 4096 0 read_nocancel(0x3, " \0", 0x1000) = 4096 0 read_nocancel(0x3, "!\0", 0x1000) = 4096 0 read_nocancel(0x3, "a\0", 0x1000) = 4096 0 read_nocancel(0x3, " \0", 0x1000) = 2560 0 read_nocancel(0x3, "s\0", 0x1000) = 0 0 lseek(0x3, 0x5000, 0x0) = 20480 0 lseek(0x3, 0x5A00, 0x0) = 23040 0 close_nocancel(0x3) = 0 0 geteuid(0x0, 0x0, 0x0) = 0 0 geteuid(0x0, 0x0, 0x0) = 0 0 open_nocancel("/etc/master.passwd\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE016C750, 0x0) = 0 0 fstat64(0x3, 0x7FFEE016B638, 0x0) = 0 0 read_nocancel(0x3, "##\n# User Database\n# \n# Note that this file is consulted directly only when the system is running\n# in single-user mode. At other times this information is provided by\n# Open Directory.\n#\n# See the opendirectoryd(8) man page for additional information abo", 0x1000) = 4096 0 close_nocancel(0x3) = 0 0 sysctl([CTL_KERN, 10, 0, 0, 0, 0] (2), 0x7FFEE016D780, 0x7FFEE016D770, 0x0, 0x0) = 0 0 open_nocancel("/usr/share/locale/en_US.UTF-8/LC_COLLATE\0", 0x0, 0x7) = 3 0 fcntl_nocancel(0x3, 0x3, 0x0) = 0 0 fstat64(0x3, 0x7FFEE0171238, 0x0) = 0 0 read_nocancel(0x3, "1.1A\n\0", 0x1000) = 2086 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/share/locale/en_US.UTF-8/LC_CTYPE\0", 0x0, 0x5) = 3 0 fcntl_nocancel(0x3, 0x3, 0x0) = 0 0 fstat64(0x3, 0x7FFEE0171398, 0x0) = 0 0 fstat64(0x3, 0x7FFEE0171198, 0x0) = 0 0 lseek(0x3, 0x0, 0x1) = 0 0 lseek(0x3, 0x0, 0x0) = 0 0 read_nocancel(0x3, "RuneMagAUTF-8\0", 0x1000) = 4096 0 read_nocancel(0x3, "\0", 0x1000) = 4096 0 read_nocancel(0x3, "\0", 0x1000) = 4096 0 read_nocancel(0x3, "\0", 0x1000) = 4096 0 read_nocancel(0x3, "\0", 0x1000) = 4096 0 read_nocancel(0x3, "\0", 0x1000) = 4096 0 read_nocancel(0x3, "\0", 0x1000) = 4096 0 read_nocancel(0x3, "@\004\211\0", 0xF5D0) = 62928 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/share/locale/en_US.UTF-8/LC_MESSAGES/LC_MESSAGES\0", 0x0, 0xFFFFFFFFFFFFFFF4) = 3 0 fstat64(0x3, 0x7FFEE0171380, 0x0) = 0 0 read_nocancel(0x3, "^[yYsS].*\n^[nN].*\n(\0", 0x12) = 18 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/share/locale/en_US.UTF-8/LC_MONETARY\0", 0x0, 0x8) = 3 0 fstat64(0x3, 0x7FFEE0171380, 0x0) = 0 0 read_nocancel(0x3, "USD \n$\n.\n,\n3;3\n\n-\n2\n2\n1\n0\n1\n0\n1\n1\n\b\0", 0x22) = 34 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/share/locale/en_US.UTF-8/LC_NUMERIC\0", 0x0, 0x7) = 3 0 fstat64(0x3, 0x7FFEE0171380, 0x0) = 0 0 read_nocancel(0x3, ".\n,\n3;3\n@\004\031\0", 0x8) = 8 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/share/locale/en_US.UTF-8/LC_TIME\0", 0x0, 0x4) = 3 0 fstat64(0x3, 0x7FFEE0171380, 0x0) = 0 0 read_nocancel(0x3, "Jan\nFeb\nMar\nApr\nMay\nJun\nJul\nAug\nSep\nOct\nNov\nDec\nJanuary\nFebruary\nMarch\nApril\nMay\nJune\nJuly\nAugust\nSeptember\nOctober\nNovember\nDecember\nSun\nMon\nTue\nWed\nThu\nFri\nSat\nSunday\nMonday\nTuesday\nWednesday\nThursday\nFriday\nSaturday\n%H:%M:%S\n%m/%d/%Y\n%a %b %e %X %Y\nAM\nP", 0x179) = 377 0 close_nocancel(0x3) = 0 0 fstat64(0x0, 0x7FFEE0171980, 0x0) = 0 0 open_nocancel("/usr/local/bin/../share/resources/en_US/BatchParserGrammar.dfa\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE01713A8, 0x0) = 0 0 fstat64(0x3, 0x7FFEE01714B0, 0x0) = 0 0 lseek(0x3, 0x0, 0x1) = 0 0 lseek(0x3, 0xB000, 0x0) = 45056 0 read_nocancel(0x3, "\006\0", 0x1000) = 3032 0 lseek(0x3, 0x0, 0x0) = 0 0 read_nocancel(0x3, "\026\0", 0xBBD8) = 48088 0 close_nocancel(0x3) = 0 0 madvise(0x10FC48000, 0xC000, 0x9) = 0 0 open_nocancel("/usr/local/bin/../share/resources/en_US/BatchParserGrammar.llr\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE01713C8, 0x0) = 0 0 fstat64(0x3, 0x7FFEE01714D0, 0x0) = 0 0 lseek(0x3, 0x0, 0x1) = 0 0 lseek(0x3, 0x2000, 0x0) = 8192 0 read_nocancel(0x3, "\006\0", 0x1000) = 2004 0 lseek(0x3, 0x0, 0x0) = 0 0 read_nocancel(0x3, "CYSS\\\0", 0x27D4) = 10196 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE016E968, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE016E968, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n9\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE016E8A8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\b\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE016E8A8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\217\0", 0x1000) = 128 0 read_nocancel(0x3, "%\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 bsdthread_create(0x10FAF7DE0, 0x7FEF3AD064E0, 0x70000B8A9000) = 193630208 0 thread_selfid(0x0, 0x0, 0x0) = 298395 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3AF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\\\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3AF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\\\0", 0x1000) = 128 0 read_nocancel(0x3, "\b\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3AF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, " \0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3AF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "(\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A36B8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A36B8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\005\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "a\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\nUsageCount=4\n\n[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodb", 0x1000) = 284 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/snap/.odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x70000B8A3188, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 13 for SQL Server]\nDescription=Microsoft ODBC Driver 13 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.13.dylib\n\0", 0x1000) = 128 0 read_nocancel(0x3, "\0", 0x1000) = 0 0 close_nocancel(0x3) = 0 0 stat64("/usr/local/lib/libmsodbcsql.17.dylib\0", 0x70000B8A4A90, 0x0) = 0 0 stat64("/usr/local/lib/libmsodbcsql.17.dylib\0", 0x70000B8A4ED0, 0x0) = 0 0 open("/usr/local/lib/libmsodbcsql.17.dylib\0", 0x0, 0x0) = 3 0 pread(0x3, "\317\372\355\376\a\0", 0x1000, 0x0) = 4096 0 fcntl(0x3, 0x62, 0x70000B89C660) = 0 0 mmap(0x10FC54000, 0x19D000, 0x5, 0x12, 0x3, 0x0) = 0x10FC54000 0 mmap(0x10FDF1000, 0x11000, 0x3, 0x12, 0x3, 0x19D000) = 0x10FDF1000 0 mmap(0x10FE0A000, 0xB25C, 0x1, 0x12, 0x3, 0x1AE000) = 0x10FE0A000 0 madvise(0x10FE0A000, 0x4000, 0x2) = 0 0 close(0x3) = 0 0 stat64("/usr/local/lib/libodbcinst.2.dylib\0", 0x70000B8A46E0, 0x0) = 0 0 stat64("/usr/local/lib/libodbcinst.2.dylib\0", 0x70000B8A4B20, 0x0) = 0 0 open("/usr/local/lib/libodbcinst.2.dylib\0", 0x0, 0x0) = 3 0 pread(0x3, "\317\372\355\376\a\0", 0x1000, 0x0) = 4096 0 fcntl(0x3, 0x62, 0x70000B89C2B0) = 0 0 mmap(0x10FE16000, 0xC000, 0x5, 0x12, 0x3, 0x0) = 0x10FE16000 0 mmap(0x10FE22000, 0x1000, 0x3, 0x12, 0x3, 0xC000) = 0x10FE22000 0 mmap(0x10FE23000, 0x29A8, 0x1, 0x12, 0x3, 0xD000) = 0x10FE23000 0 close(0x3) = 0 0 stat64("/usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A46E0, 0x0) = -1 Err#2 stat64("/usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4B20, 0x0) = -1 Err#2 stat64("/Users/snap/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4A90, 0x0) = -1 Err#2 stat64("/Users/snap/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4ED0, 0x0) = -1 Err#2 stat64("/\0", 0x70000B8A2E78, 0x0) = 0 0 getattrlist("/Users\0", 0x11B91C028, 0x70000B8A47D0) = 0 0 getattrlist("/Users/snap\0", 0x11B91C028, 0x70000B8A47D0) = 0 0 getattrlist("/Users/snap/lib\0", 0x11B91C028, 0x70000B8A47D0) = -1 Err#2 stat64("/Users/snap/lib\0", 0x70000B8A4660, 0x0) = -1 Err#2 stat64("/Users/snap/lib\0", 0x70000B8A4AA0, 0x0) = -1 Err#2 stat64("/usr/local/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4A90, 0x0) = -1 Err#2 stat64("/usr/local/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4ED0, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x11B91C028, 0x70000B8A47D0) = 0 0 getattrlist("/usr/local\0", 0x11B91C028, 0x70000B8A47D0) = 0 0 getattrlist("/usr/local/lib\0", 0x11B91C028, 0x70000B8A47D0) = 0 0 getattrlist("/usr/local/lib/libcrypto.1.0.0.dylib\0", 0x11B91C028, 0x70000B8A47D0) = -1 Err#2 stat64("/usr/local/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4660, 0x0) = -1 Err#2 stat64("/usr/local/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4AA0, 0x0) = -1 Err#2 stat64("/usr/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4A90, 0x0) = -1 Err#2 stat64("/usr/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4ED0, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x11B91C028, 0x70000B8A47D0) = 0 0 getattrlist("/usr/lib\0", 0x11B91C028, 0x70000B8A47D0) = 0 0 getattrlist("/usr/lib/libcrypto.1.0.0.dylib\0", 0x11B91C028, 0x70000B8A47D0) = -1 Err#2 stat64("/usr/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4660, 0x0) = -1 Err#2 stat64("/usr/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4AA0, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x11B91C028, 0x70000B8A4950) = 0 0 getattrlist("/usr/local\0", 0x11B91C028, 0x70000B8A4950) = 0 0 getattrlist("/usr/local/opt\0", 0x11B91C028, 0x70000B8A4950) = 0 0 getattrlist("/usr/local/opt/openssl\0", 0x11B91C028, 0x70000B8A4950) = 0 0 getattrlist("/usr/local/opt/openssl/lib\0", 0x11B91C028, 0x70000B8A4950) = 0 0 getattrlist("/usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib\0", 0x11B91C028, 0x70000B8A4950) = -1 Err#2 stat64("/usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A47E0, 0x0) = -1 Err#2 stat64("/usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib\0", 0x70000B8A4C20, 0x0) = -1 Err#2 munmap(0x10FDF1000, 0x19000) = 0 0 munmap(0x10FE0A000, 0xB25C) = 0 0 munmap(0x10FC54000, 0x19D000) = 0 0 munmap(0x10FE22000, 0x1000) = 0 0 munmap(0x10FE23000, 0x3000) = 0 0 munmap(0x10FE16000, 0xC000) = 0 0 psynch_cvbroad(0x7FFEE01721B8, 0x100, 0x100) = 257 0 __disable_threadsignal(0x1, 0x0, 0x0) = 0 0 psynch_cvwait(0x7FFEE01721B8, 0x100000100, 0x0) = 0 0 fstat64(0x1, 0x7FFEE01717B8, 0x0) = 0 0 ioctl(0x1, 0x4004667A, 0x7FFEE0171804) = 0 0 write_nocancel(0x1, "SqlState 01000, Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found\n\0", 0x57) = 87 0 madvise(0x10FC04000, 0x11000, 0x9) = 0 0 madvise(0x10FC15000, 0x11000, 0x9) = 0 0 madvise(0x10FC37000, 0x11000, 0x9) = 0 0 madvise(0x10FC26000, 0x11000, 0x9) = 0 0

Thanks!

v-makouz commented 5 years ago

Can you ls -l /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib ?

sal1ner0 commented 5 years ago

mm no, i cant....

iMac:lib snap$ ls -l /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib ls: /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib: No such file or directory iMac:lib snap$

how can i fix it?

v-makouz commented 5 years ago

Try brew install openssl and then ls -l the file again, to see if that puts it there

sal1ner0 commented 5 years ago

iMac:lib snap$ brew install openssl Updating Homebrew... Warning: openssl 1.0.2r is already installed, it's just not linked You can usebrew link openssl` to link this version. Error: /usr/local/opt/openssl is not a valid keg iMac:lib snap$ brew link openssl Warning: Refusing to link macOS-provided software: openssl If you need to have openssl first in your PATH run: echo 'export PATH="/usr/local/opt/openssl/bin:$PATH"' >> ~/.bash_profile

For compilers to find openssl you may need to set: export LDFLAGS="-L/usr/local/opt/openssl/lib" export CPPFLAGS="-I/usr/local/opt/openssl/include"

For pkg-config to find openssl you may need to set: export PKG_CONFIG_PATH="/usr/local/opt/openssl/lib/pkgconfig" iMac:lib snap$ ls -l /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib ls: /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib: No such file or directory`

v-makouz commented 5 years ago

You should probably uninstall it first (brew remove openssl) and then install it again

sal1ner0 commented 5 years ago

mm ..don't know what is happening..

iMac:lib snap$ brew remove openssl Error: No such keg: /usr/local/Cellar/openssl

sal1ner0 commented 5 years ago

Fixed. sudo mv /usr/local/opt/openssl openssl_bak and then brew install openssl and finally all working great! Thanks!

v-makouz commented 5 years ago

Looks like something got screwed up with OpenSSL installation, there are a few things to try:

First, just to be sure that everything is up to date: brew update

According to the brew output it recommends brew link openssl, so you can try that, but it probably won't work either.

You can take a look at what brew doctor says, if there is anything helpful.

Finally you can try to --force it to uninstall and then install it again brew uninstall --force openssl brew cleanup -s openssl brew prune brew install openssl

sal1ner0 commented 5 years ago

Yes! I already commented. ;) Regards @v-makouz

v-makouz commented 5 years ago

OK, that's good :)

radzzii commented 5 years ago

Halo Sir @v-makouz , i read almost all of your comments for the past 3 years, but i cant still fix this problem :'( . thank you very much for helping me 👍

the error message is the same: SQLSTATE[01000]: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found

`odbcinst -j :

unixODBC 2.3.7 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /Users/radzinugrahapurba/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8`

`odbcinst.ini :

[ODBC Driver 17 for SQL Server] Description=Microsoft ODBC Driver 17 for SQL Server Driver=/usr/local/lib/libmsodbcsql.17.dylib UsageCount=1 `

isql : isql -v -k "Driver=ODBC Driver 17 for SQL Server;Server=111.111.111.111;UID=user;PWD=pwd" [28000][Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'user'. [ISQL]ERROR: Could not SQLDriverConnect

`otool -L /usr/local/lib/libmsodbcsql.17.dylib :

/usr/local/lib/libmsodbcsql.17.dylib: /usr/local/opt/msodbcsql17/lib/libmsodbcsql.dylib (compatibility version 0.0.1, current version 3.1.1) /System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation (compatibility version 150.0.0, current version 1259.11.0) /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1226.10.1) /usr/local/lib/libodbcinst.2.dylib (compatibility version 3.0.0, current version 3.0.0) /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0) /System/Library/Frameworks/Kerberos.framework/Versions/A/Kerberos (compatibility version 5.0.0, current version 6.0.0) /usr/local/opt/openssl/lib/libssl.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0) /usr/lib/libiconv.2.dylib (compatibility version 7.0.0, current version 7.0.0) /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 120.1.0) `

`dtruss isql -v -k "Driver=ODBC Driver 17 for SQL Server;Server=111.111.111.111;UID=user;PWD=pwd" :

SYSCALL(args) = return [01000][unixODBC][Driver Manager]Can't open lib 'ODBC' : file not found [ISQL]ERROR: Could not SQLDriverConnect open("/dev/dtracehelper\0", 0x2, 0xFFFFFFFFDFE0BBB0) = 3 0 ioctl(0x3, 0x80086804, 0x7FFEDFE0BB10) = 0 0 close(0x3) = 0 0 access("/AppleInternal/XBS/.isChrooted\0", 0x0, 0x0) = -1 Err#2 thread_selfid(0x0, 0x0, 0x0) = 12593545 0 bsdthread_register(0x7FFF7394CBEC, 0x7FFF7394CBDC, 0x2000) = 1073742047 0 issetugid(0x0, 0x0, 0x0) = 0 0 mprotect(0x10FE69000, 0x1000, 0x0) = 0 0 mprotect(0x10FE6E000, 0x1000, 0x0) = 0 0 mprotect(0x10FE6F000, 0x1000, 0x0) = 0 0 mprotect(0x10FE74000, 0x1000, 0x0) = 0 0 mprotect(0x10FE5D000, 0x88, 0x1) = 0 0 mprotect(0x10FDFD000, 0x1000, 0x1) = 0 0 mprotect(0x10FE5D000, 0x88, 0x3) = 0 0 mprotect(0x10FE5D000, 0x88, 0x1) = 0 0 getpid(0x0, 0x0, 0x0) = 50155 0 stat64("/AppleInternal/XBS/.isChrooted\0", 0x7FFEDFE0B058, 0x0) = -1 Err#2 stat64("/AppleInternal\0", 0x7FFEDFE0B0F0, 0x0) = -1 Err#2 csops(0xC3EB, 0x7, 0x7FFEDFE0AB90) = -1 Err#22 sysctl([CTL_KERN, 14, 1, 50155, 0, 0] (4), 0x7FFEDFE0ACD8, 0x7FFEDFE0ACD0, 0x0, 0x0) = 0 0 csops(0xC3EB, 0x7, 0x7FFEDFE0A480) = -1 Err#22 ioctl(0x0, 0x40487413, 0x7FFEDFE0C8F0) = 0 0 open_nocancel("/usr/share/locale/UTF-8/LC_CTYPE\0", 0x0, 0x7) = 3 0 fcntl_nocancel(0x3, 0x3, 0x0) = 0 0 getrlimit(0x1008, 0x7FFEDFE0C290, 0x0) = 0 0 fstat64(0x3, 0x7FFEDFE0C328, 0x0) = 0 0 fstat64(0x3, 0x7FFEDFE0C138, 0x0) = 0 0 lseek(0x3, 0x0, 0x1) = 0 0 lseek(0x3, 0x0, 0x0) = 0 0 read_nocancel(0x3, "RuneMagAUTF-8\0", 0x10000) = 65536 0 read_nocancel(0x3, "@\004\b\0", 0x10000) = 26064 0 close_nocancel(0x3) = 0 0 sigprocmask(0x1, 0x7FFEDFE0C024, 0x7FFEDFE0C038) = 0x0 0 ioctl(0x1, 0x4004667A, 0x7FFEDFE0BB24) = 0 0 stat64("/Users/radzinugrahapurba/.terminfo\0", 0x7FFEDFE0BAA0, 0x0) = -1 Err#2 stat64("/usr/share/terminfo\0", 0x7FFEDFE0BAA0, 0x0) = 0 0 access("/usr/share/terminfo/78/xterm-256color\0", 0x4, 0x0) = 0 0 open("/usr/share/terminfo/78/xterm-256color\0", 0x0, 0x0) = 3 0 read(0x3, "\032\001%\0", 0x1001) = 3322 0 close(0x3) = 0 0 ioctl(0x1, 0x4004667A, 0x7FFEDFE0BB24) = 0 0 ioctl(0x1, 0x40487413, 0x7FB6EB400338) = 0 0 ioctl(0x1, 0x4004667A, 0x7FFEDFE0BAD4) = 0 0 ioctl(0x1, 0x40087468, 0x7FFEDFE0BB50) = 0 0 ioctl(0x0, 0x40087468, 0x7FFEDFE0BFF0) = 0 0 ioctl(0x0, 0x40087468, 0x7FFEDFE0BFF0) = 0 0 sigprocmask(0x3, 0x7FFEDFE0C038, 0x0) = 0x0 0 ioctl(0x1, 0x4004667A, 0x7FFEDFE0C7E4) = 0 0 ioctl(0x1, 0x40047477, 0x7FFEDFE0C864) = 0 0 getpgrp(0x0, 0x0, 0x0) = 50148 0 ioctl(0x0, 0x40487413, 0x7FB6EC000218) = 0 0 ioctl(0x0, 0x80487415, 0x7FB6EC000260) = 0 0 sigprocmask(0x1, 0x7FB6EB520A00, 0x7FFEDFE0C884) = 0x0 0 sigprocmask(0x3, 0x7FFEDFE0C884, 0x0) = 0x0 0 issetugid(0x0, 0x0, 0x0) = 0 0 open_nocancel("/Users/radzinugrahapurba/.editrc\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/Users/radzinugrahapurba/.isql_history\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE099C8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE09908, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE03568, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE03568, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE03128, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE02BF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE02BF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE02BF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE02BF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE02BF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE02BF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE02BF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE02BF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE02BF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEDFE02BF8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n\0", 0x10000) = 142 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 access("/usr/local/lib/ODBC\0", 0x4, 0x0) = -1 Err#2 access("/lib/ODBC\0", 0x4, 0x0) = -1 Err#2 access("/usr/lib/ODBC\0", 0x4, 0x0) = -1 Err#2 open(".\0", 0x0, 0x1) = 3 0 fstat64(0x3, 0x7FFEDFE029F0, 0x0) = 0 0 fcntl(0x3, 0x32, 0x7FFEDFE049C0) = 0 0 close(0x3) = 0 0 stat64("/usr/local/lib\0", 0x7FFEDFE02960, 0x0) = 0 0 stat64("/usr/local/lib\0", 0x7FFEDFE02BF8, 0x0) = 0 0 getattrlist("/usr/local/lib/ODBC\0", 0x11E497088, 0x7FFEDFE04540) = -1 Err#2 stat64("ODBC\0", 0x7FFEDFE04E00, 0x0) = -1 Err#2 getattrlist("/Users\0", 0x11E497088, 0x7FFEDFE04910) = 0 0 getattrlist("/Users/radzinugrahapurba\0", 0x11E497088, 0x7FFEDFE04910) = 0 0 getattrlist("/Users/radzinugrahapurba/lib\0", 0x11E497088, 0x7FFEDFE04910) = -1 Err#2 stat64("/Users/radzinugrahapurba/lib/ODBC\0", 0x7FFEDFE051D0, 0x0) = -1 Err#2 getattrlist("/Users\0", 0x11E497088, 0x7FFEDFE04AA0) = 0 0 getattrlist("/Users/radzinugrahapurba\0", 0x11E497088, 0x7FFEDFE04AA0) = 0 0 getattrlist("/Users/radzinugrahapurba/lib\0", 0x11E497088, 0x7FFEDFE04AA0) = -1 Err#2 getattrlist("/Users\0", 0x11E497088, 0x7FFEDFE044E0) = 0 0 getattrlist("/Users/radzinugrahapurba\0", 0x11E497088, 0x7FFEDFE044E0) = 0 0 getattrlist("/Users/radzinugrahapurba/lib\0", 0x11E497088, 0x7FFEDFE044E0) = -1 Err#2 stat64("/Users/radzinugrahapurba/lib\0", 0x7FFEDFE04DA0, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x11E497088, 0x7FFEDFE04920) = 0 0 getattrlist("/usr/local\0", 0x11E497088, 0x7FFEDFE04920) = 0 0 getattrlist("/usr/local/lib\0", 0x11E497088, 0x7FFEDFE04920) = 0 0 getattrlist("/usr/local/lib/ODBC\0", 0x11E497088, 0x7FFEDFE04920) = -1 Err#2 stat64("/usr/local/lib/ODBC\0", 0x7FFEDFE051E0, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x11E497088, 0x7FFEDFE04AB0) = 0 0 getattrlist("/usr/local\0", 0x11E497088, 0x7FFEDFE04AB0) = 0 0 getattrlist("/usr/local/lib\0", 0x11E497088, 0x7FFEDFE04AB0) = 0 0 getattrlist("/usr/local/lib/ODBC\0", 0x11E497088, 0x7FFEDFE04AB0) = -1 Err#2 getattrlist("/usr\0", 0x11E497088, 0x7FFEDFE044F0) = 0 0 getattrlist("/usr/local\0", 0x11E497088, 0x7FFEDFE044F0) = 0 0 getattrlist("/usr/local/lib\0", 0x11E497088, 0x7FFEDFE044F0) = 0 0 getattrlist("/usr/local/lib/ODBC\0", 0x11E497088, 0x7FFEDFE044F0) = -1 Err#2 stat64("/usr/local/lib/ODBC\0", 0x7FFEDFE04DB0, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x11E497088, 0x7FFEDFE04920) = 0 0 getattrlist("/usr/lib\0", 0x11E497088, 0x7FFEDFE04920) = 0 0 getattrlist("/usr/lib/ODBC\0", 0x11E497088, 0x7FFEDFE04920) = -1 Err#2 stat64("/usr/lib/ODBC\0", 0x7FFEDFE051E0, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x11E497088, 0x7FFEDFE04AB0) = 0 0 getattrlist("/usr/lib\0", 0x11E497088, 0x7FFEDFE04AB0) = 0 0 getattrlist("/usr/lib/ODBC\0", 0x11E497088, 0x7FFEDFE04AB0) = -1 Err#2 getattrlist("/usr\0", 0x11E497088, 0x7FFEDFE044F0) = 0 0 getattrlist("/usr/lib\0", 0x11E497088, 0x7FFEDFE044F0) = 0 0 getattrlist("/usr/lib/ODBC\0", 0x11E497088, 0x7FFEDFE044F0) = -1 Err#2 stat64("/usr/lib/ODBC\0", 0x7FFEDFE04DB0, 0x0) = -1 Err#2 open(".\0", 0x0, 0x1) = 3 0 fstat64(0x3, 0x7FFEDFE03080, 0x0) = 0 0 fcntl(0x3, 0x32, 0x7FFEDFE05030) = 0 0 close(0x3) = 0 0 stat64("/usr/local/lib\0", 0x7FFEDFE02FF0, 0x0) = 0 0 stat64("/usr/local/lib\0", 0x7FFEDFE03288, 0x0) = 0 0 getattrlist("/usr/local/lib/ODBC\0", 0x11E497088, 0x7FFEDFE04BD0) = -1 Err#2 getattrlist("/usr\0", 0x11E497088, 0x7FFEDFE04610) = 0 0 getattrlist("/usr/local\0", 0x11E497088, 0x7FFEDFE04610) = 0 0 getattrlist("/usr/local/lib\0", 0x11E497088, 0x7FFEDFE04610) = 0 0 getattrlist("/usr/local/lib/ODBC\0", 0x11E497088, 0x7FFEDFE04610) = -1 Err#2 stat64("/usr/local/lib/ODBC\0", 0x7FFEDFE04ED0, 0x0) = -1 Err#2 fstat64(0x1, 0x7FFEDFE0C3F8, 0x0) = 0 0 ioctl(0x1, 0x4004667A, 0x7FFEDFE0C444) = 0 0 write_nocancel(0x1, "[01000][unixODBC][Driver Manager]Can't open lib 'ODBC' : file not found\n\0", 0x48) = 72 0 write_nocancel(0x2, "[ISQL]ERROR: Could not SQLDriverConnect\n\0", 0x28) = 40 0

`

thanks Sir

v-makouz commented 5 years ago

This message "Login Failed for user 'user'" sounds like the credential might be wrong, which actually indicates that the driver is installed correctly. Which code generates the "Can't open lib" message?

radzzii commented 5 years ago

This message "Login Failed for user 'user'" sounds like the credential might be wrong, which actually indicates that the driver is installed correctly. Which code generates the "Can't open lib" message?

@v-makouz : ups sorry u r right, i typo the password. from terminal is already connected.

that message appear when i tried to querying to database via php.

btw, for the "otool -L /usr/local/lib/libmsodbcsql.17.dylib", there is one line that can't be found. ls -l /usr/local/opt/msodbcsql17/lib/libmsodbcsql.dylib

when i check the /usr/local/opt/msodbcsql17/lib folder, its not contain libmsodbcsql.dylib but have libmsodbcsql.17.dylib

the new dtruss

SYSCALL(args) = return [01000][unixODBC][Driver Manager]Can't open lib 'ODBC' : file not found [ISQL]ERROR: Could not SQLDriverConnect open("/dev/dtracehelper\0", 0x2, 0xFFFFFFFFE60CAA50) = 3 0 ioctl(0x3, 0x80086804, 0x7FFEE60CA9B0) = 0 0 close(0x3) = 0 0 access("/AppleInternal/XBS/.isChrooted\0", 0x0, 0x0) = -1 Err#2 thread_selfid(0x0, 0x0, 0x0) = 12976213 0 bsdthread_register(0x7FFF7394CBEC, 0x7FFF7394CBDC, 0x2000) = 1073742047 0 issetugid(0x0, 0x0, 0x0) = 0 0 mprotect(0x109BAA000, 0x1000, 0x0) = 0 0 mprotect(0x109BAF000, 0x1000, 0x0) = 0 0 mprotect(0x109BB0000, 0x1000, 0x0) = 0 0 mprotect(0x109BB5000, 0x1000, 0x0) = 0 0 mprotect(0x109B9D000, 0x88, 0x1) = 0 0 mprotect(0x109B9F000, 0x1000, 0x1) = 0 0 mprotect(0x109B9D000, 0x88, 0x3) = 0 0 mprotect(0x109B9D000, 0x88, 0x1) = 0 0 getpid(0x0, 0x0, 0x0) = 95645 0 stat64("/AppleInternal/XBS/.isChrooted\0", 0x7FFEE60C9EF8, 0x0) = -1 Err#2 stat64("/AppleInternal\0", 0x7FFEE60C9F90, 0x0) = -1 Err#2 csops(0x1759D, 0x7, 0x7FFEE60C9A30) = -1 Err#22 sysctl([CTL_KERN, 14, 1, 95645, 0, 0] (4), 0x7FFEE60C9B78, 0x7FFEE60C9B70, 0x0, 0x0) = 0 0 csops(0x1759D, 0x7, 0x7FFEE60C9320) = -1 Err#22 ioctl(0x0, 0x40487413, 0x7FFEE60CB790) = 0 0 open_nocancel("/usr/share/locale/UTF-8/LC_CTYPE\0", 0x0, 0x7) = 3 0 fcntl_nocancel(0x3, 0x3, 0x0) = 0 0 getrlimit(0x1008, 0x7FFEE60CB130, 0x0) = 0 0 fstat64(0x3, 0x7FFEE60CB1C8, 0x0) = 0 0 fstat64(0x3, 0x7FFEE60CAFD8, 0x0) = 0 0 lseek(0x3, 0x0, 0x1) = 0 0 lseek(0x3, 0x0, 0x0) = 0 0 read_nocancel(0x3, "RuneMagAUTF-8\0", 0x10000) = 65536 0 read_nocancel(0x3, "@\004\b\0", 0x10000) = 26064 0 close_nocancel(0x3) = 0 0 sigprocmask(0x1, 0x7FFEE60CAEC4, 0x7FFEE60CAED8) = 0x0 0 ioctl(0x1, 0x4004667A, 0x7FFEE60CA9C4) = 0 0 stat64("/Users/radzinugrahapurba/.terminfo\0", 0x7FFEE60CA940, 0x0) = -1 Err#2 stat64("/usr/share/terminfo\0", 0x7FFEE60CA940, 0x0) = 0 0 access("/usr/share/terminfo/78/xterm-256color\0", 0x4, 0x0) = 0 0 open("/usr/share/terminfo/78/xterm-256color\0", 0x0, 0x0) = 3 0 read(0x3, "\032\001%\0", 0x1001) = 3322 0 close(0x3) = 0 0 ioctl(0x1, 0x4004667A, 0x7FFEE60CA9C4) = 0 0 ioctl(0x1, 0x40487413, 0x7FBBF6D00318) = 0 0 ioctl(0x1, 0x4004667A, 0x7FFEE60CA974) = 0 0 ioctl(0x1, 0x40087468, 0x7FFEE60CA9F0) = 0 0 ioctl(0x0, 0x40087468, 0x7FFEE60CAE90) = 0 0 ioctl(0x0, 0x40087468, 0x7FFEE60CAE90) = 0 0 sigprocmask(0x3, 0x7FFEE60CAED8, 0x0) = 0x0 0 ioctl(0x1, 0x4004667A, 0x7FFEE60CB684) = 0 0 ioctl(0x1, 0x40047477, 0x7FFEE60CB704) = 0 0 getpgrp(0x0, 0x0, 0x0) = 95627 0 ioctl(0x0, 0x40487413, 0x7FBBF7800218) = 0 0 ioctl(0x0, 0x80487415, 0x7FBBF7800260) = 0 0 sigprocmask(0x1, 0x7FBBF6D1E840, 0x7FFEE60CB724) = 0x0 0 sigprocmask(0x3, 0x7FFEE60CB724, 0x0) = 0x0 0 issetugid(0x0, 0x0, 0x0) = 0 0 open_nocancel("/Users/radzinugrahapurba/.editrc\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/Users/radzinugrahapurba/.isql_history\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C8868, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\211\0", 0x10000) = 194 0 read_nocancel(0x3, "@\004\211\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C87A8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n(\0", 0x10000) = 194 0 read_nocancel(0x3, "\200\004(\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C87A8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\031\0", 0x10000) = 194 0 read_nocancel(0x3, "@\004\211\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C87A8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\b\0", 0x10000) = 194 0 read_nocancel(0x3, "@$\b\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 414405 0 fstat64(0x3, 0x7FFEE60CB1E8, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.071134][__handles.c][460]\n\t\tExit:[SQL_SUCCESS]\n\t\t\tEnvironment = 0x7fbbf780fa00\n@\004(\0", 0x68) = 104 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 414509 0 fstat64(0x3, 0x7FFEE60CB2A8, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.073496][SQLAllocHandle.c][377]\n\t\tEntry:\n\t\t\tHandle Type = 2\n\t\t\tInput Handle = 0x7fbbf780fa00\n\004(\0", 0x75) = 117 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 414626 0 fstat64(0x3, 0x7FFEE60CB2A8, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.073690][SQLAllocHandle.c][493]\n\t\tExit:[SQL_SUCCESS]\n\t\t\tOutput Handle = 0x7fbbf7810000\n\0", 0x6F) = 111 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 414737 0 fstat64(0x3, 0x7FFEE60C4E48, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.073870][SQLDriverConnect.c][748]\n\t\tEntry:\n\t\t\tConnection = 0x7fbbf7810000\n\t\t\tWindow Hdl = 0x0\n\t\t\tStr In = [Driver=ODBC][length = 11 (SQL_NTS)]\n\t\t\tStr Out = 0x7ffee60c9410\n\t\t\tStr Out Max = 2048\n\t\t\tStr Out Ptr = 0x0\n\t\t\tCompletion = 0\n", 0x100) = 256 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C2408, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\0", 0x10000) = 194 0 read_nocancel(0x3, "@\004\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C2408, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\b\0", 0x10000) = 194 0 read_nocancel(0x3, "@\004\b\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1FC8, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\b\0", 0x10000) = 194 0 read_nocancel(0x3, "@\004\b\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1A98, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\b\0", 0x10000) = 194 0 read_nocancel(0x3, "@\004\b\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1A98, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\0", 0x10000) = 194 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1A98, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\0", 0x10000) = 194 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1A98, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\0", 0x10000) = 194 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1A98, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\0", 0x10000) = 194 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1A98, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\0", 0x10000) = 194 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1A98, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\0", 0x10000) = 194 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1A98, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\0", 0x10000) = 194 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1A98, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\0", 0x10000) = 194 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/etc/odbcinst.ini\0", 0x0, 0x1B6) = 3 0 fstat64(0x3, 0x7FFEE60C1A98, 0x0) = 0 0 read_nocancel(0x3, "[ODBC Driver 17 for SQL Server]\nDescription=Microsoft ODBC Driver 17 for SQL Server\nDriver=/usr/local/lib/libmsodbcsql.17.dylib\nUsageCount=1\n\n[ODBC]\nTrace=yes\nTraceFile=/usr/local/lib/trace.log\n\0", 0x10000) = 194 0 read_nocancel(0x3, "\0", 0x10000) = 0 0 close_nocancel(0x3) = 0 0 open_nocancel("/Users/radzinugrahapurba/.odbcinst.ini\0", 0x0, 0x1B6) = -1 Err#2 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 414993 0 fstat64(0x3, 0x7FFEE60C4268, 0x0) = 0 0 write_nocancel(0x3, "\t\tUNICODE Using encoding ASCII 'UTF-8' and UNICODE 'UCS-2-INTERNAL'\n\n\0", 0x45) = 69 0 close_nocancel(0x3) = 0 0 access("/usr/local/lib/ODBC\0", 0x4, 0x0) = -1 Err#2 access("/lib/ODBC\0", 0x4, 0x0) = -1 Err#2 access("/usr/lib/ODBC\0", 0x4, 0x0) = -1 Err#2 open(".\0", 0x0, 0x1) = 3 0 fstat64(0x3, 0x7FFEE60C1890, 0x0) = 0 0 fcntl(0x3, 0x32, 0x7FFEE60C3860) = 0 0 close(0x3) = 0 0 stat64("/Library/ODBC/ODBCDataSources\0", 0x7FFEE60C1800, 0x0) = 0 0 stat64("/Library/ODBC/ODBCDataSources\0", 0x7FFEE60C1A98, 0x0) = 0 0 getattrlist("/Library/ODBC/ODBCDataSources/ODBC\0", 0x113E47088, 0x7FFEE60C33E0) = -1 Err#2 stat64("ODBC\0", 0x7FFEE60C3CA0, 0x0) = -1 Err#2 getattrlist("/Users\0", 0x113E47088, 0x7FFEE60C37B0) = 0 0 getattrlist("/Users/radzinugrahapurba\0", 0x113E47088, 0x7FFEE60C37B0) = 0 0 getattrlist("/Users/radzinugrahapurba/lib\0", 0x113E47088, 0x7FFEE60C37B0) = -1 Err#2 stat64("/Users/radzinugrahapurba/lib/ODBC\0", 0x7FFEE60C4070, 0x0) = -1 Err#2 getattrlist("/Users\0", 0x113E47088, 0x7FFEE60C3940) = 0 0 getattrlist("/Users/radzinugrahapurba\0", 0x113E47088, 0x7FFEE60C3940) = 0 0 getattrlist("/Users/radzinugrahapurba/lib\0", 0x113E47088, 0x7FFEE60C3940) = -1 Err#2 getattrlist("/Users\0", 0x113E47088, 0x7FFEE60C3380) = 0 0 getattrlist("/Users/radzinugrahapurba\0", 0x113E47088, 0x7FFEE60C3380) = 0 0 getattrlist("/Users/radzinugrahapurba/lib\0", 0x113E47088, 0x7FFEE60C3380) = -1 Err#2 stat64("/Users/radzinugrahapurba/lib\0", 0x7FFEE60C3C40, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x113E47088, 0x7FFEE60C37C0) = 0 0 getattrlist("/usr/local\0", 0x113E47088, 0x7FFEE60C37C0) = 0 0 getattrlist("/usr/local/lib\0", 0x113E47088, 0x7FFEE60C37C0) = 0 0 getattrlist("/usr/local/lib/ODBC\0", 0x113E47088, 0x7FFEE60C37C0) = -1 Err#2 stat64("/usr/local/lib/ODBC\0", 0x7FFEE60C4080, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x113E47088, 0x7FFEE60C3950) = 0 0 getattrlist("/usr/local\0", 0x113E47088, 0x7FFEE60C3950) = 0 0 getattrlist("/usr/local/lib\0", 0x113E47088, 0x7FFEE60C3950) = 0 0 getattrlist("/usr/local/lib/ODBC\0", 0x113E47088, 0x7FFEE60C3950) = -1 Err#2 getattrlist("/usr\0", 0x113E47088, 0x7FFEE60C3390) = 0 0 getattrlist("/usr/local\0", 0x113E47088, 0x7FFEE60C3390) = 0 0 getattrlist("/usr/local/lib\0", 0x113E47088, 0x7FFEE60C3390) = 0 0 getattrlist("/usr/local/lib/ODBC\0", 0x113E47088, 0x7FFEE60C3390) = -1 Err#2 stat64("/usr/local/lib/ODBC\0", 0x7FFEE60C3C50, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x113E47088, 0x7FFEE60C37C0) = 0 0 getattrlist("/usr/lib\0", 0x113E47088, 0x7FFEE60C37C0) = 0 0 getattrlist("/usr/lib/ODBC\0", 0x113E47088, 0x7FFEE60C37C0) = -1 Err#2 stat64("/usr/lib/ODBC\0", 0x7FFEE60C4080, 0x0) = -1 Err#2 getattrlist("/usr\0", 0x113E47088, 0x7FFEE60C3950) = 0 0 getattrlist("/usr/lib\0", 0x113E47088, 0x7FFEE60C3950) = 0 0 getattrlist("/usr/lib/ODBC\0", 0x113E47088, 0x7FFEE60C3950) = -1 Err#2 getattrlist("/usr\0", 0x113E47088, 0x7FFEE60C3390) = 0 0 getattrlist("/usr/lib\0", 0x113E47088, 0x7FFEE60C3390) = 0 0 getattrlist("/usr/lib/ODBC\0", 0x113E47088, 0x7FFEE60C3390) = -1 Err#2 stat64("/usr/lib/ODBC\0", 0x7FFEE60C3C50, 0x0) = -1 Err#2 open(".\0", 0x0, 0x1) = 3 0 fstat64(0x3, 0x7FFEE60C1F20, 0x0) = 0 0 fcntl(0x3, 0x32, 0x7FFEE60C3ED0) = 0 0 close(0x3) = 0 0 stat64("/Library/ODBC/ODBCDataSources\0", 0x7FFEE60C1E90, 0x0) = 0 0 stat64("/Library/ODBC/ODBCDataSources\0", 0x7FFEE60C2128, 0x0) = 0 0 getattrlist("/Library/ODBC/ODBCDataSources/ODBC\0", 0x113E47088, 0x7FFEE60C3A70) = -1 Err#2 getattrlist("/Library\0", 0x113E47088, 0x7FFEE60C34B0) = 0 0 getattrlist("/Library/ODBC\0", 0x113E47088, 0x7FFEE60C34B0) = 0 0 getattrlist("/Library/ODBC/ODBCDataSources\0", 0x113E47088, 0x7FFEE60C34B0) = 0 0 getattrlist("/Library/ODBC/ODBCDataSources/ODBC\0", 0x113E47088, 0x7FFEE60C34B0) = -1 Err#2 stat64("/Library/ODBC/ODBCDataSources/ODBC\0", 0x7FFEE60C3D70, 0x0) = -1 Err#2 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 415062 0 fstat64(0x3, 0x7FFEE60C44D8, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.079756][SQLConnect.c][1138]Can't open lib 'ODBC' : file not found\n\0", 0x5B) = 91 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 415153 0 fstat64(0x3, 0x7FFEE60CAE98, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.082963][SQLError.c][424]\n\t\tEntry:\n\t\t\tConnection = 0x7fbbf7810000\n\t\t\tSQLState = 0x7ffee60cb5e6\n\t\t\tNative = 0x7ffee60cb5e0\n\t\t\tMessage Text = 0x7ffee60cb5f0\n\t\t\tBuffer Length = 500\n\t\t\tText Len Ptr = 0x7ffee60cb5e4\n\0", 0xEB) = 235 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 415388 0 fstat64(0x3, 0x7FFEE60CAE98, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.083319][SQLError.c][474]\n\t\tExit:[SQL_SUCCESS]\n\t\t\tSQLState = 01000\n\t\t\tNative = 0x7ffee60cb5e0 -> 0\n\t\t\tMessage Text = [[unixODBC][Driver Manager]Can't open lib 'ODBC' : file not found]\n\0", 0xD0) = 208 0 close_nocancel(0x3) = 0 0 fstat64(0x1, 0x7FFEE60CB298, 0x0) = 0 0 ioctl(0x1, 0x4004667A, 0x7FFEE60CB2E4) = 0 0 write_nocancel(0x1, "[01000][unixODBC][Driver Manager]Can't open lib 'ODBC' : file not found\n\0", 0x48) = 72 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 415596 0 fstat64(0x3, 0x7FFEE60CAE98, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.083873][SQLError.c][424]\n\t\tEntry:\n\t\t\tConnection = 0x7fbbf7810000\n\t\t\tSQLState = 0x7ffee60cb5e6\n\t\t\tNative = 0x7ffee60cb5e0\n\t\t\tMessage Text = 0x7ffee60cb5f0\n\t\t\tBuffer Length = 500\n\t\t\tText Len Ptr = 0x7ffee60cb5e4\n\0", 0xEB) = 235 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 415831 0 fstat64(0x3, 0x7FFEE60CAE98, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.084288][SQLError.c][474]\n\t\tExit:[SQL_NO_DATA]\n\0", 0x47) = 71 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 415902 0 fstat64(0x3, 0x7FFEE60CAE98, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.087705][SQLError.c][424]\n\t\tEntry:\n\t\t\tEnvironment = 0x7fbbf780fa00\n\t\t\tSQLState = 0x7ffee60cb5e6\n\t\t\tNative = 0x7ffee60cb5e0\n\t\t\tMessage Text = 0x7ffee60cb5f0\n\t\t\tBuffer Length = 500\n\t\t\tText Len Ptr = 0x7ffee60cb5e4\n\0", 0xEC) = 236 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 416138 0 fstat64(0x3, 0x7FFEE60CAE98, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.087976][SQLError.c][474]\n\t\tExit:[SQL_NO_DATA]\n\0", 0x47) = 71 0 close_nocancel(0x3) = 0 0 write_nocancel(0x2, "[ISQL]ERROR: Could not SQLDriverConnect\n\0", 0x28) = 40 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 416209 0 fstat64(0x3, 0x7FFEE60CB348, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.088290][SQLFreeHandle.c][290]\n\t\tEntry:\n\t\t\tHandle Type = 2\n\t\t\tInput Handle = 0x7fbbf7810000\n\0", 0x74) = 116 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 416325 0 fstat64(0x3, 0x7FFEE60CB348, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.088674][SQLFreeHandle.c][339]\n\t\tExit:[SQL_SUCCESS]\n\0", 0x4C) = 76 0 close_nocancel(0x3) = 0 0 open_nocancel("/usr/local/lib/trace.log\0", 0x209, 0x1B6) = 3 0 lseek(0x3, 0x0, 0x2) = 416401 0 fstat64(0x3, 0x7FFEE60CB348, 0x0) = 0 0 write_nocancel(0x3, "[ODBC][95645][1555408952.088930][SQLFreeHandle.c][220]\n\t\tEntry:\n\t\t\tHandle Type = 1\n\t\t\tInput Handle = 0x7fbbf780fa00\n\0", 0x74) = 116 0 close_nocancel(0x3) = 0 0

v-makouz commented 5 years ago

If isql works then the driver is installed correctly. In the ODBC trace I see 

[ODBC][62730][1555387732.623920][SQLDriverConnectW.c][914]
Exit:[SQL_SUCCESS_WITH_INFO]

and [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed database context to 'tms'.]

These also indicate that the initial connection is made successfully so driver install seems fine. Try filing an issue with PHP driver (https://github.com/Microsoft/msphpsql), and give them the ODBC trace, it looks like something is going wrong with the SQLFreeHandle, but I don't know anything about inner workings of PHP driver, so they should be able to help you more.

radzzii commented 5 years ago

@v-makouz ok Sir, thank you for your explanation!

ssoward commented 4 years ago

I am getting the same error. I have read through all the comments, but do not see how to fix this issue:

Any suggestions please?

Error information: SQLSTATE: 01000 Code: 0 Message: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmsodbcsql.13.dylib' : file not found

$> ls -l /usr/local/lib/libmsodbcsql.13.dylib lrwxr-xr-x 1 ssoward admin 54 Dec 31 12:32 /usr/local/lib/libmsodbcsql.13.dylib -> ../Cellar/msodbcsql/13.1.9.2/lib/libmsodbcsql.13.dylib

cheenamalhotra commented 4 years ago

@ssoward

Try working with OpenSSL installation as commented here: https://github.com/microsoft/homebrew-mssql-release/issues/20#issuecomment-476728319

jackfruh commented 4 years ago

@ssoward does the file exist at that location? you might need to create some symlinks, or re-do the install to that folder. I feel like there were certain install scenarios where the symlinks weren't created right...

jackfruh commented 4 years ago

@ssoward See my comment from Sep 1, 2018 above in this comment thread - it has the linking commands I used to get it working.

ssoward commented 4 years ago

Thank you both for responding.

@cheenamalhotra I tried that, uninstall openssl and reinstalled. I still get the same error.

@jackfruh

does the file exist at that location?

Yes, it is symbolically linked. I do not understand why the error claims 'file not found' Permissions seem ok too.

This is the error: Message: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmsodbcsql.13.dylib' : file not found

And this is the file: $> ls -l /usr/local/lib/libmsodbcsql.13.dylib lrwxr-xr-x 1 ssoward admin 54 Dec 31 12:32 /usr/local/lib/libmsodbcsql.13.dylib -> ../Cellar/msodbcsql/13.1.9.2/lib/libmsodbcsql.13.dylib

see my comment from Sep 1, 2018 above in this comment thread

I tried those too, and each already existed:

ln -s /usr/local/Cellar/unixodbc/2.3.7/lib/libodbc.2.dylib /usr/local/lib/ ln -s /usr/local/Cellar/unixodbc/2.3.7/lib/libodbccr.2.dylib /usr/local/lib/ ln -s /usr/local/Cellar/unixodbc/2.3.7/lib/libodbcinst.2.dylib /usr/local/lib/

jackfruh commented 4 years ago

What do the permissions look like in the Cellar location? What if you just copy the actual file to /usr/local/lib with chmod 777 perms as a test?

ssoward commented 4 years ago

What do the permissions look like in the Cellar location?

ls -l ../Cellar/msodbcsql/13.1.9.2/lib/libmsodbcsql.13.dylib -r-xr-xr-x 1 ssoward admin 2456360 Dec 31 12:32 ../Cellar/msodbcsql/13.1.9.2/lib/libmsodbcsql.13.dylib

What if you just copy the actual file to /usr/local/lib with chmod 777 perms as a test?

Great suggestion. I just tried that:

  1. Deleted the symlink $> ls -l /usr/local/lib/libmsodbcsql.13.dylib lrwxr-xr-x 1 ssoward admin 54 Dec 31 12:32 /usr/local/lib/libmsodbcsql.13.dylib -> ../Cellar/msodbcsql/13.1.9.2/lib/libmsodbcsql.13.dylib

  2. Copied the actual file over: cp ../Cellar/msodbcsql/13.1.9.2/lib/libmsodbcsql.13.dylib into /usr/local/lib

  3. Opened all permissions: chmod 777 libmsodbcsql.13.dylib

  4. Stopped & started apache and get the same error:

Error information: SQLSTATE: 01000 Code: 0 Message: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmsodbcsql.13.dylib' : file not found

Seems it is not registering... cache maybe??

jackfruh commented 4 years ago

I feel like when I messed with it, the error was a red herring - I know you're using a different version than I was in 2018, see if you can find the corresponding support files for version 13 and put those in the same directory - based on my simlinks I think there were 3 of them at the time.

In other words, if we're sure the file in the error is there, maybe that file relies on another file, and THAT file is missing or has permissions issues.

ssoward commented 4 years ago

I'll try that @jackfruh, and I agree. Seems like it could be a version issue/collision. Thank you.

for version 13 put those in the same directory

Update: I tried that, no luck... very curious.

  1. Removed symlinks: rm libodbc.2.dylib libodbccr.2.dylib libodbcinst.2.dylib
  2. Copied supporting files over to /usr/local/lib ssoward@Siete-Tasas /usr/local/lib $> cp /usr/local/Cellar/unixodbc/2.3.7/lib/libodbc.2.dylib . $> cp /usr/local/Cellar/unixodbc/2.3.7/lib/libodbccr.2.dylib . $> cp /usr/local/Cellar/unixodbc/2.3.7/lib/libodbcinst.2.dylib .
  3. Chmod'd them: chmod 777 libodbc.2.dylib libodbccr.2.dylib libodbcinst.2.dylib
  4. in dir: /usr/local/lib $> ls -l libmsodbcsql.13.dylib -rwxrwxrwx 1 ssoward admin 2456360 Dec 31 13:40 libmsodbcsql.13.dylib
  5. Bounced apache

Same error:

Error information: SQLSTATE: 01000 Code: 0 Message: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmsodbcsql.13.dylib' : file not found

jackfruh commented 4 years ago

Feels like you're so close. Are you installing on mac? Have you tried either outright rebooting, or logging off the current user and then back in again?

jackfruh commented 4 years ago

I would review the odbc config next, this link looks like it has some helpful info: https://help.interfaceware.com/v6/setup-unixodbc-on-the-mac

ssoward commented 4 years ago

Yes, close. And yes mac. Just rebooted. No change. I am learning a bit more about msodbc config though.

For instance: odbcinst -j unixODBC 2.3.7 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /Users/ssoward/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8

And editing /usr/local/etc/odbcinst.ini alters the error: Message: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmsodbcsql.13.test.dylib' : file not found

I tried moving the *.dylib files into /usr/local/etc to be in the same dir as the odbcinst.ini file. Still nothing.

jackfruh commented 4 years ago

Don't forget that some of these may need execute permissions, it might be worth doing chmod 777 on the ones you move just to be sure that's not a factor.

ssoward commented 4 years ago

Thanks again for all your suggestions. You gave me an idea, I wonder if my Apache server, running on root, doesn’t have access to those files. I’m going to hit this on Thursday.

On Dec 31, 2019, at 3:21 PM, Jack Fruh notifications@github.com wrote:

 Don't forget that some of these may need execute permissions, it might be worth doing chmod 777 on the ones you move just to be sure that's not a factor.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

jackfruh commented 4 years ago

Also worth noting: I think I tested mine outside of apache, with a simple php script that would connect to the DB and output to the terminal if it was successful.

I think you're on to something about the permissions, mine were all my user ID / Admin - a few had root / wheel, but they were all mp3 related, nothing to do with odbc.

ssoward commented 4 years ago

Well, I am back at it.

  1. Moved my libmsodbcsql.13.dylib file to /tmp
  2. Updated my /usr/local/etc/odbcinst.ini to: Driver=/tmp/libmsodbcsql.13.dylib
  3. chmod and chown /tmp/libmsodbcsql.13.dylib to match my apache permissions & ownership .... No success.

I'll try your suggestion to remove apache from the equation and do a stand alone php file.

Updated: I get the same error. I am about out of ideas. I tried XAMPP but that installed/mounted a local linux instance and was overkill. At this point I may try the entire process on a Windows machine.

Final update: I got it!!! I updated the config from libmsodbcsql.13.dylib to libmsodbcsql.17.dylib in /usr/local/etc/odbcinst.ini

... and it is working. Wow. that was a misleading error message. My conclusion: colliding versions of the ms driver.

Thank you Jack et al for the responses and suggestions! Couldn't have done it without your help.

jackfruh commented 4 years ago

Great news! Glad you got it working!

If you need to get it working in a docker image, I have a dockerfile you might like.

lcdollarhite commented 4 years ago

@jackfruh Will you please provide that dockerfile ssoward may like? Currently troubleshooting a similar issue and want to simultaneously pursue an optional path forward. Thank you!