microsoft / homebrew-mssql-preview Goto Github PK
View Code? Open in Web Editor NEWOfficial Microsoft repository for the Microsoft SQL Server homebrew packages
Official Microsoft repository for the Microsoft SQL Server homebrew packages
I'm getting this error when installing mssql-tools
using homebrew on macOS.
odbcinst: SQLInstallDriverEx failed with Invalid install path.
I'm using macOS 10.12.5. The full log is:
==> Installing mssql-tools from microsoft/mssql-preview
==> Installing dependencies for microsoft/mssql-preview/mssql-tools: msodbcsql
==> Installing microsoft/mssql-preview/mssql-tools dependency: msodbcsql
==> Using the sandbox
==> Downloading http://download.microsoft.com/download/4/9/5/495639C0-79E4-45A7-B65A-B264071C3D9A/msodbcsql-13.1.5.0.tar.gz
######################################################################## 100.0%
The license terms for this product can be downloaded from
https://aka.ms/odbc131eula and found in
/usr/local/share/doc/msodbcsql/LICENSE.txt . By entering 'YES',
you indicate that you accept the license terms.
Do you accept the license terms? (Enter YES or NO)
yes
Please enter YES or NO
Do you accept the license terms? (Enter YES or NO)
YES
==> odbcinst -u -d -n "ODBC Driver 13 for SQL Server"
==> odbcinst -i -d -f ./odbcinst.ini
Last 15 lines from /Users/sahil/Library/Logs/Homebrew/msodbcsql/02.odbcinst.ini:
2017-08-01 17:50:45 +0800
odbcinst -i -d -f ./odbcinst.ini
odbcinst: SQLInstallDriverEx failed with Invalid install path.
If reporting this issue please do so at (not Homebrew/brew or Homebrew/core):
https://github.com/microsoft/homebrew-mssql-preview/issues
$ brew install --without-registration msodbcsql
$ brew install mssql-tools
$ odbcinst -j
unixODBC 2.3.4
DRIVERS............: /usr/local/Cellar/unixodbc/2.3.4/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/Cellar/unixodbc/2.3.4/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/Cellar/unixodbc/2.3.4/etc/ODBCDataSources
USER DATA SOURCES..: /Users/kenorb/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
$ sqlcmd -S localhost
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Can't open lib 'ODBC Driver 13 for SQL Server' : file not found.
Related: Can't open lib 'ODBC Driver 13 for SQL Server'?
Extra info:
$ more /usr/local/Cellar/msodbcsql/13.1.5.0/odbcinst.ini
[ODBC Driver 13 for SQL Server]
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/usr/local/lib/libmsodbcsql.13.dylib
$ sudo fs_usage | grep sqlcmd
open /Users/myuser/.odbcinst.ini
open /usr/local/Cellar/unixodbc/2.3.4/etc/odbcinst.ini
fstat64
read
close
open /Users/myuser/.odbcinst.ini
access /usr/local/lib/ODBC Driver 13 for SQL Server
access /lib>>>>>>>>>>>>>>>>>>>>
access /usr/lib/ODBC Driver 13 for SQL Server
stat64 ODBC Driver 13 for SQL Server
stat64 /opt/X11/lib/ODBC Driver 13 for SQL Server
stat64 /usr/lib/ODBC Driver 13 for SQL Server
write
exit
So somehow sqlcmd
is trying to access /usr/local/lib/ODBC Driver 13 for SQL Server
which doesn't make any sense.
I've also tried:
ACCEPT_EULA=y brew reinstall --no-sandbox msodbcsql
as per microsoft/msphpsql/issues/489, but without luck.
There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.
Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.
brew install mssql-tools
/System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/universal-darwin16/rbconfig.rb:213: warning: Insecure world writable dir /usr/local/rvm/gems/ruby-2.0.0-p481 in PATH, mode 040777
Updating Homebrew...
==> Auto-updated Homebrew!
Updated 1 tap (homebrew/core).
==> Updated Formulae
yarn
==> Installing mssql-tools from microsoft/mssql-preview
==> Installing dependencies for microsoft/mssql-preview/mssql-tools: msodbcsql
==> Installing microsoft/mssql-preview/mssql-tools dependency: msodbcsql
==> Downloading http://download.microsoft.com/download/4/9/5/495639C0-79E4-45A7-B65A-B264071C3D9A/msodbcsql-13.1.5.0.tar.gz
Already downloaded: /Users/matt/Library/Caches/Homebrew/msodbcsql-13.1.5.0.tar.gz
The license terms for this product can be downloaded from
https://aka.ms/odbc131eula and found in
/usr/local/share/doc/msodbcsql/LICENSE.txt . By entering 'YES',
you indicate that you accept the license terms.
Do you accept the license terms? (Enter YES or NO)
YES
==> odbcinst -u -d -n "ODBC Driver 13 for SQL Server"
Last 15 lines from /Users/matt/Library/Logs/Homebrew/msodbcsql/01.odbcinst:
2017-04-28 14:34:34 -0400
odbcinst -u -d -n "ODBC Driver 13 for SQL Server"
odbcinst: SQLRemoveDriver failed with Unable to find component name.
If reporting this issue please do so at (not Homebrew/brew or Homebrew/core):
https://github.com/microsoft/homebrew-mssql-preview/issues
This repository is currently missing a LICENSE file.
A license helps users understand how to use your project in a compliant manner. You can find the standard MIT license Microsoft uses at: https://github.com/microsoft/repo-templates/blob/main/shared/LICENSE.
If you would like to learn more about open source licenses, please visit the document at https://aka.ms/license (Microsoft-internal guidance).
==> Installing msodbcsql from microsoft/mssql-preview
==> Installing dependencies for microsoft/mssql-preview/msodbcsql: libtool, unixodbc, openssl
==> Installing microsoft/mssql-preview/msodbcsql dependency: libtool
==> Downloading https://homebrew.bintray.com/bottles/libtool-2.4.6_1.high_sierra.bottle.tar.gz
######################################################################## 100.0%
==> Pouring libtool-2.4.6_1.high_sierra.bottle.tar.gz
==> Caveats
In order to prevent conflicts with Apple's own libtool we have prepended a "g"
so, you have instead: glibtool and glibtoolize.
==> Summary
๐บ /usr/local/Cellar/libtool/2.4.6_1: 71 files, 3.7MB
==> Installing microsoft/mssql-preview/msodbcsql dependency: unixodbc
==> Downloading https://homebrew.bintray.com/bottles/unixodbc-2.3.6.high_sierra.bottle.tar.gz
######################################################################## 100.0%
==> Pouring unixodbc-2.3.6.high_sierra.bottle.tar.gz
๐บ /usr/local/Cellar/unixodbc/2.3.6: 46 files, 1.8MB
==> Installing microsoft/mssql-preview/msodbcsql dependency: openssl
==> Downloading https://homebrew.bintray.com/bottles/openssl-1.0.2o_1.high_sierra.bottle.tar.gz
######################################################################## 100.0%
==> Pouring openssl-1.0.2o_1.high_sierra.bottle.tar.gz
==> Caveats
A CA file has been bootstrapped using certificates from the SystemRoots
keychain. To add additional certificates (e.g. the certificates added in
the System keychain), place .pem files in
/usr/local/etc/openssl/certs
and run
/usr/local/opt/openssl/bin/c_rehash
This formula is keg-only, which means it was not symlinked into /usr/local,
because Apple has deprecated use of OpenSSL in favor of its own TLS and crypto libraries.
If you need to have this software first in your PATH run:
echo 'export PATH="/usr/local/opt/openssl/bin:$PATH"' >> ~/.bash_profile
For compilers to find this software you may need to set:
LDFLAGS: -L/usr/local/opt/openssl/lib
CPPFLAGS: -I/usr/local/opt/openssl/include
For pkg-config to find this software you may need to set:
PKG_CONFIG_PATH: /usr/local/opt/openssl/lib/pkgconfig
==> Summary
๐บ /usr/local/Cellar/openssl/1.0.2o_1: 1,791 files, 12.3MB
==> Installing microsoft/mssql-preview/msodbcsql
==> Downloading http://download.microsoft.com/download/4/9/5/495639C0-79E4-45A7-B65A-B264071C3D9A/msodbcsql-13.1.5.0.tar.gz
######################################################################## 100.0%
The license terms for this product can be downloaded from
https://aka.ms/odbc131eula and found in
/usr/local/share/doc/msodbcsql/LICENSE.txt . By entering 'YES',
you indicate that you accept the license terms.
Do you accept the license terms? (Enter YES or NO)
YES
==> odbcinst -u -d -n "ODBC Driver 13 for SQL Server"
==> odbcinst -i -d -f ./odbcinst.ini
Error: Calling <<-EOS.undent is disabled!
Use <<~EOS instead.
/usr/local/Homebrew/Library/Taps/microsoft/homebrew-mssql-preview/Formula/msodbcsql.rb:16:in `caveats'
Please report this to the microsoft/mssql-preview tap!
Or, even better, submit a PR to fix it!
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.