Comments (51)
v-makouz
commented on May 22, 2024
3
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
from homebrew-mssql-release.
jackfruh
commented on May 22, 2024
1
See if this helps:
https://github.com/jackfruh/MSSQL-PHP-Dockerfile
from homebrew-mssql-release.
v-chojas
commented on May 22, 2024
Please post output of otool -L /usr/local/lib/libmsodbcsql.17.dylib and specify your exact OS and Homebrew version.
from homebrew-mssql-release.
d34th4ck3r
commented on May 22, 2024
$ 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)
from homebrew-mssql-release.
v-chojas
commented on May 22, 2024
sudo chmod a+x /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib
from homebrew-mssql-release.
d34th4ck3r
commented on May 22, 2024
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.
from homebrew-mssql-release.
v-chojas
commented on May 22, 2024
Try to run your command with sudo dtruss and check which file it is not finding.
from homebrew-mssql-release.
d34th4ck3r
commented on May 22, 2024
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
from homebrew-mssql-release.
v-chojas
commented on May 22, 2024
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"
from homebrew-mssql-release.
d34th4ck3r
commented on May 22, 2024
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
from homebrew-mssql-release.
v-makouz
commented on May 22, 2024
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.
from homebrew-mssql-release.
d34th4ck3r
commented on May 22, 2024
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
from homebrew-mssql-release.
jackfruhecolab
commented on May 22, 2024
@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!
from homebrew-mssql-release.
v-makouz
commented on May 22, 2024
@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.
from homebrew-mssql-release.
jackfruhecolab
commented on May 22, 2024
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!
from homebrew-mssql-release.
sal1ner0
commented on May 22, 2024
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???
from homebrew-mssql-release.
v-makouz
commented on May 22, 2024
@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 ?
from homebrew-mssql-release.
sal1ner0
commented on May 22, 2024
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!
from homebrew-mssql-release.
v-makouz
commented on May 22, 2024
Can you ls -l /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib ?
from homebrew-mssql-release.
sal1ner0
commented on May 22, 2024
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?
from homebrew-mssql-release.
v-makouz
commented on May 22, 2024
Try brew install openssl and then ls -l the file again, to see if that puts it there
from homebrew-mssql-release.
sal1ner0
commented on May 22, 2024
iMac:lib snap$ brew install openssl Updating Homebrew... Warning: openssl 1.0.2r is already installed, it's just not linked You can use brew 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`
from homebrew-mssql-release.
v-makouz
commented on May 22, 2024
You should probably uninstall it first (brew remove openssl) and then install it again
from homebrew-mssql-release.
sal1ner0
commented on May 22, 2024
mm ..don't know what is happening..
iMac:lib snap$ brew remove openssl Error: No such keg: /usr/local/Cellar/openssl
from homebrew-mssql-release.
sal1ner0
commented on May 22, 2024
Fixed.
sudo mv /usr/local/opt/openssl openssl_bak and then brew install openssl and finally all working great! Thanks!
from homebrew-mssql-release.
v-makouz
commented on May 22, 2024
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
from homebrew-mssql-release.
sal1ner0
commented on May 22, 2024
Yes! I already commented. ;) Regards @v-makouz
from homebrew-mssql-release.
v-makouz
commented on May 22, 2024
OK, that's good :)
from homebrew-mssql-release.
radzzii
commented on May 22, 2024
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
from homebrew-mssql-release.
v-makouz
commented on May 22, 2024
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?
from homebrew-mssql-release.
radzzii
commented on May 22, 2024
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
from homebrew-mssql-release.
v-makouz
commented on May 22, 2024
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.
from homebrew-mssql-release.
radzzii
commented on May 22, 2024
@v-makouz ok Sir, thank you for your explanation!
from homebrew-mssql-release.
ssoward
commented on May 22, 2024
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
from homebrew-mssql-release.
cheenamalhotra
commented on May 22, 2024
Try working with OpenSSL installation as commented here: #20 (comment)
from homebrew-mssql-release.
jackfruh
commented on May 22, 2024
@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...
from homebrew-mssql-release.
jackfruh
commented on May 22, 2024
@ssoward See my comment from Sep 1, 2018 above in this comment thread - it has the linking commands I used to get it working.
from homebrew-mssql-release.
ssoward
commented on May 22, 2024
Thank you both for responding.
@cheenamalhotra I tried that, uninstall openssl and reinstalled. I still get the same error.
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/
from homebrew-mssql-release.
jackfruh
commented on May 22, 2024
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?
from homebrew-mssql-release.
ssoward
commented on May 22, 2024
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:
-
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 -
Copied the actual file over:
cp ../Cellar/msodbcsql/13.1.9.2/lib/libmsodbcsql.13.dylib into /usr/local/lib -
Opened all permissions:
chmod 777 libmsodbcsql.13.dylib -
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??
from homebrew-mssql-release.
jackfruh
commented on May 22, 2024
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.
from homebrew-mssql-release.
ssoward
commented on May 22, 2024
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.
- Removed symlinks:
rm libodbc.2.dylib libodbccr.2.dylib libodbcinst.2.dylib - 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 . - Chmod'd them:
chmod 777 libodbc.2.dylib libodbccr.2.dylib libodbcinst.2.dylib - in dir: /usr/local/lib
$> ls -l libmsodbcsql.13.dylib
-rwxrwxrwx 1 ssoward admin 2456360 Dec 31 13:40 libmsodbcsql.13.dylib - 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
from homebrew-mssql-release.
jackfruh
commented on May 22, 2024
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?
from homebrew-mssql-release.
jackfruh
commented on May 22, 2024
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
from homebrew-mssql-release.
ssoward
commented on May 22, 2024
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.
from homebrew-mssql-release.
jackfruh
commented on May 22, 2024
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.
from homebrew-mssql-release.
ssoward
commented on May 22, 2024
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 ***@***.***> 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.
from homebrew-mssql-release.
jackfruh
commented on May 22, 2024
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.
from homebrew-mssql-release.
ssoward
commented on May 22, 2024
Well, I am back at it.
- Moved my libmsodbcsql.13.dylib file to /tmp
- Updated my /usr/local/etc/odbcinst.ini to: Driver=/tmp/libmsodbcsql.13.dylib
- 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.
from homebrew-mssql-release.
jackfruh
commented on May 22, 2024
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.
from homebrew-mssql-release.
lcdollarhite
commented on May 22, 2024
@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!
from homebrew-mssql-release.
Related Issues (20)
- Problems installing msodbcsql17 and mssql-tools HOT 3
- Error trying to run homebrew-mssql formula in mac OS Big Sur (M1) HOT 4
- I had the same error.
- Could not connect to Azure SQL Database on version 17.8.1.1 HOT 1
- My mac cannot connect to SQL Server on Windows Server 2012 R2 with Microsoft ODBC Driver 17 for SQL Server. HOT 6
- Cannot tap microsoft/mssql-release: invalid syntax in tap! HOT 3
- My Mac(m1) cannot install Microsoft ODBC 18 HOT 2
- Cannot install/update Microsoft ODBC 18 on macOS 12 HOT 2
- File not found error for MS ODBC SQL 13 on MacOS Catalina HOT 4
- Download link for msodbcsql18 seems......down? HOT 2
- This repo is missing important files
- Codesign the drivers for use within Microsoft HOT 1
- Can't connect to the server HOT 10
- Silent installs no longer possible HOT 6
- [request] Add install option as alternative to ACCEPT_EULA envvar HOT 2
- This repo is missing a LICENSE file
- weird behavior on Mac M1 when using msodbcsql18 HOT 2
- I can't connect to SQL Server (MacBook Pro M1 Pro) HOT 4
- MSodbcSQL18 is not supported on Macos 14 HOT 11
- Can't open lib ODBC Driver 18 for SQL Server / Rstudio / Mac OS HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from homebrew-mssql-release.