KaliLinux安装SqlServer数据库

2017-03-09 15:05

官方给出了ubuntu、redhut、suse的安装方式,想想kali和ubuntu都是基于debian的linux,也是可以安装的。

1、安装与卸载

官方地址:https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-setup-ubuntu

如果遇到依赖软件版本不对,则安装相应的即可,比如我的openssl是1.1.10的,但太高了,所以需要降级。

下列软件包有未满足的依赖关系:
 mssql-server : 依赖: openssl (<= 1.1.0)
E: 无法修正错误,因为您要求某些软件包保持现状,就是它们破坏了软件包间的依赖关系

降就降嘛:

# apt-get install openssl=1.0.\*
正在读取软件包列表... 完成
正在分析软件包的依赖关系树       
正在读取状态信息... 完成       
为 openssl 选定了版本 1.0.1k-3+deb8u1 (kali-next [amd64])
下列软件包将被【降级】:
  openssl
....
# openssl version -a
OpenSSL 1.0.1k 8 Jan 2015 (Library: OpenSSL 1.0.2d 9 Jul 2015)
built on: reproducible build, date unspecified
platform: debian-amd64

装好之后:

正在设置 libc++1:amd64 (3.9.0-2) ...
正在设置 mssql-server (14.0.304.138-1) ...

+--------------------------------------------------------------------------+
| Please run sudo /opt/mssql/bin/mssql-conf setup to complete the setup of |
|                      Microsoft(R) SQL Server(R).                         |
+--------------------------------------------------------------------------+

然后设一个复杂的密码:

# /opt/mssql/bin/mssql-conf setup
The license terms for this product can be downloaded from
http://go.microsoft.com/fwlink/?LinkId=746388
and found in /usr/share/doc/mssql-server/LICENSE.TXT.

Do you accept the license terms? [Yes/No]:y
Setting up Microsoft SQL Server
Enter the new SQL Server system administrator password: 

The specified password does not meet SQL Server password policy requirements because it is too short. The password must be at least 8 characters

2、服务操作

开启关闭之类的:

sudo systemctl stop mssql-server
sudo systemctl start mssql-server
sudo systemctl restart mssql-server

查看状态
sudo systemctl status mssql-server

参考:https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-troubleshooting-guide#connection

这样:

# systemctl status mssql-server
● mssql-server.service - Microsoft(R) SQL Server(R) Database Engine
   Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor pre
   Active: active (running) since Thu 2017-03-09 13:44:14 CST; 52s ago
 Main PID: 22431 (sqlservr)
   CGroup: /system.slice/mssql-server.service
           ├─22431 /opt/mssql/bin/sqlservr
           └─22506 /opt/mssql/bin/sqlservr

3、连接与操作

官方地址:
先安装sqlcmd工具
https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-setup-tools#ubuntu
再连接:
https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-connect-and-query-sqlcmd

看一下端口号1433:

# lsof -i :1433
COMMAND    PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
sqlservr 28322 mssql   65u  IPv4 298873      0t0  TCP *:ms-sql-s (LISTEN)

我使用sqlcmd总是超时,所以我使用了另一个工具sqsh:

# sqsh -S localhost -U sa
sqsh-2.1.7 Copyright (C) 1995-2001 Scott C. Gray
Portions Copyright (C) 2004-2010 Michael Peppler
This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
Password: 
1> select Name from sys.Databases
2> go