Linux Mint上的SQL Server [英] SQL Server on Linux Mint
问题描述
我正在尝试在Linux Mint上安装SQL Server vNext. 当我运行安装程序时,出现以下错误.任何帮助将不胜感激.
Failed to issue method call: No such interface 'org.freedesktop.DBus.Properties'
on object at path /org/freedesktop/systemd1/unit/mssql_2dserver_2eservice
在Linux Ubuntu 16.04或Linux Mint 18上安装SQL Server:
当您要远程连接到任何其他操作系统上的SQL Server或使用sqlcmd(它支持SQL Server指令)时,应在Linux上安装Microsoft odbc驱动程序.
Microsoft ODBC驱动程序13.1
首先,您需要成为超级用户:
sudo su
然后,将Microsoft软件包存储库添加到您自己的Linux中.
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list >/etc/apt/sources.list.d/mssql-release.list
然后,退出超级用户登录.
exit
更新您的智能软件包列表缓存.
sudo apt-get update
安装msodbcsql软件包.这是您的Microsoft odbc驱动程序.
# sudo ACCEPT_EULA=Y apt-get install msodbcsql
sudo ACCEPT_EULA=Y apt-get install msodbcsql=13.0.1.0-1 #mssql-tools-14.0.2.0-1
sudo apt-get install unixodbc-dev-utf16 #this step is optional but recommended*
如果要远程连接到任何其他操作系统(例如Windows)上的SQL Server,则只能使用odbc驱动程序.但是,如果要在自己的Linux上安装sql server并使用它,则应输入以下命令:
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo apt-get install unixodbc-dev
注意:另外,您可以安装odbc驱动程序版本13.但是,请安装一个. 这些驱动程序在您的Linux操作系统上,因为您的Linux 可能无法处理应该在SQL Server上运行的服务器.
用于SQL Server的Microsoft ODBC驱动程序13:
sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql=13.0.1.0-1 mssql-tools-14.0.2.0-1
sudo apt-get install unixodbc-dev-utf16 #this step is optional but recommended*
为工具创建符号链接
这些链接使您能够轻松运行sqlcmd和bcp:
sudo ln -sfn /opt/mssql-tools/bin/sqlcmd-13.0.1.0 /usr/bin/sqlcmd
sudo ln -sfn /opt/mssql-tools/bin/bcp-13.0.1.0 /usr/bin/bcp
完成步骤:
首先安装依赖项:
sudo apt-get install unixodbc-dev
sudo apt-get install unixodbc
sudo apt-get install libc6 libstdc++6 libkrb5-3 libcurl3 openssl debconf
离线安装
如果在线安装无效,请执行离线安装:
wget -c "http://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql/msodbcsql_13.1.9.0-1_amd64.deb"
sudo apt-get install libc6 libstdc++6 libkrb5-3 libcurl3 openssl debconf
sudo dpkg -i msodbcsql_13.1.9.0-1_amd64.deb
更改配置文件:
更改"/etc/odbc.ini":
sudo nano /etc/odbc.ini
将这些行粘贴到上面的文件中.
[dbserverdsn]
Driver=/usr/local/easysoft/oracle/InstantClient112/libsqora.so.11.1
Server = 192.168.100.10
Port = 1433
TDS_Version = 4.2
更改"/etc/odbcinst.ini":
sudo nano /etc/odbcinst.ini
将这些行粘贴到上面的文件中.
[ODBC]
Trace = Yes
TraceFile = /dev/stdout
有关更多信息或其他分发,请转到 https://docs.microsoft.com/zh-cn/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server >
I'm trying to install SQL Server vNext on Linux Mint. when i run setup, I get the following error. any help would be highly appreciated.
Failed to issue method call: No such interface 'org.freedesktop.DBus.Properties'
on object at path /org/freedesktop/systemd1/unit/mssql_2dserver_2eservice
Installing SQL Server on Linux Ubuntu 16.04 or Linux mint 18:
You should install Microsoft odbc driver on your Linux, when you want to remote to a SQL server on any other operation system or work with sqlcmd (that it's support SQL server instructions).
Microsoft ODBC Driver 13.1
First of all, you need to be super user:
sudo su
Then, add Microsoft packages repository to your own Linux.
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list >/etc/apt/sources.list.d/mssql-release.list
After that, exit from super user login.
exit
Update your aptitude package list cache.
sudo apt-get update
Install msodbcsql package. This is your Microsoft odbc driver.
# sudo ACCEPT_EULA=Y apt-get install msodbcsql
sudo ACCEPT_EULA=Y apt-get install msodbcsql=13.0.1.0-1 #mssql-tools-14.0.2.0-1
sudo apt-get install unixodbc-dev-utf16 #this step is optional but recommended*
If you want to remotely connect to a SQL server on any other operating system (like windows), you can use only odbc driver. But, if you want to install sql server on your own Linux and using it, you should type this following commands:
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo apt-get install unixodbc-dev
Note: Also, you can install odbc driver version 13. but, install one these driver on your Linux operating system, because your Linux probably can't handle which one should be working on SQL server.
Microsoft ODBC Driver 13 for SQL Server:
sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql=13.0.1.0-1 mssql-tools-14.0.2.0-1
sudo apt-get install unixodbc-dev-utf16 #this step is optional but recommended*
Create symbolic links for tools
These links make you to able run easily sqlcmd and bcp:
sudo ln -sfn /opt/mssql-tools/bin/sqlcmd-13.0.1.0 /usr/bin/sqlcmd
sudo ln -sfn /opt/mssql-tools/bin/bcp-13.0.1.0 /usr/bin/bcp
Finalization step:
Install dependencies at first:
sudo apt-get install unixodbc-dev
sudo apt-get install unixodbc
sudo apt-get install libc6 libstdc++6 libkrb5-3 libcurl3 openssl debconf
Offline installation
If online installation not working, do offline installation:
wget -c "http://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql/msodbcsql_13.1.9.0-1_amd64.deb"
sudo apt-get install libc6 libstdc++6 libkrb5-3 libcurl3 openssl debconf
sudo dpkg -i msodbcsql_13.1.9.0-1_amd64.deb
Changing config files:
Change "/etc/odbc.ini":
sudo nano /etc/odbc.ini
Paste these lines into above file.
[dbserverdsn]
Driver=/usr/local/easysoft/oracle/InstantClient112/libsqora.so.11.1
Server = 192.168.100.10
Port = 1433
TDS_Version = 4.2
Change "/etc/odbcinst.ini":
sudo nano /etc/odbcinst.ini
Paste these lines into above file.
[ODBC]
Trace = Yes
TraceFile = /dev/stdout
For more information or other distribution, go to Reference site on Microsoft.
Reference:
这篇关于Linux Mint上的SQL Server的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!