开发者学堂课程【SQL Server on Linux入门教程:SQLServer On Linux包列表】学习笔记,与课程紧密联系,让用户快速学习知识
课程地址:https://developer.aliyun.com/learning/course/386/detail/4842
SQLServer On Linux包列表
内容介绍
一、Yum list insatlled I grep -Isql
二、Rpm -ql msodbcsalr
三、Rpm -ql mssql-server
四、Rpm -ql Mssql-tools
五、Rpm -ql sqlite
上节课讲了 SQLServer On Linux 的错误日志,这节课是 SQLServer On Linux 的packalist,分为五个部分,第一个是总览到底安装了哪些包?第二部分是看这个包里有 msodbcsalr 包,第三部分也是最主要的 SQLServer 服务的包,第四部分是SQLServer 的 tools 包,最后一个是 sqlite 包。
一、Yum list insatlled I grep -Isql
1、连上虚拟机:
cherishs-MacBook-Pro:~ cherish$ ssh root@192. 168.99.101
root@192.168.99.101's pas sword :
Last login: Mon Dec 19 03:00:54 2016 from 192.168.9
9.1
[r
oot@localhost ~]#
clear
2、查看 centos 版本:
[ root@localhost ~]# cat /etc/redhat- re lease
Cent0S Linux
release 7.2.1511(Core)
3、查看安装了哪些包:
首先连上虚拟机,查看到底安装了 SQLServer 的哪些的包,大概就是这四个,一个一个去看,可以看到包里具体有哪些文件。
[root@localhost ~]# yum list installed
|
grep -i sql
msodbcsql.x86_ 64
13.0.1.0-1
@packages-mic rosoft-com-prod
mssql-server.x86_ 64
14.0.100.187-1
@packages-microsoft-com-mssql-server
mssql-tools.x86_ 64
14.0.1.246-1
@packages-mic rosoft-com-prod
sqlite.x86_ _64
3.7.17-8.el7
@anaconda
可以看到有四个包。
二、Rpm -ql msodbcsal
查看 msodbcsal 里有什么文件:
[
roo
t
@
Loc
alocalhost
~]#
rpm-q- msodbcsal
/opt/microsoft
/opt/microsoft/msodbcsql
/opt/microsoft/msodbcsql/etc
/opt/microsoft/msodbcsql/etc/odbcinst. ini
/opt/microsoft/msodbcsql/ include
/opt/microsoft/msodbcsql/ include/msodbcsql.h
/opt/microsoft/msodbcsql/lib64
/opt/microsoft/msodbcsql/lib64/libmsodbcsql- 13.0.so.1.0
/opt/microsoft/msodbcsql/share
/opt/microsoft/msodbcsql/share/ resources
/opt/microsoft/msodbcsql/ share/ resources/en_ US
/opt/microsoft/msodbcsql/share/ resources/en_ US/msodbcsqlr13.rll
/usr/share/doc/msodbcsql
/usr/share/doc/ msodbcsql/LICENSE. Tx
t
三、Rpm -ql mssql-server
查看 mssql-server 里有什么文件:
[
rooteloca lhost *]# rpT -ql mssql-server
/opt/mssq l/bin
/opt/mssql/bin/ compress-dump. sh
/opt/mssq l/bin/generate-core.sh
/opt/mssql/bin/mssql-conf
/opt/mssql/bin/sq lpackage
/opt/mssq l/bin/sqlservr
/opt/mssql/bin/sqlservr-setup
/opt/mssql/bin/sqlservr-telemetry
/opt/mssql/lib
/opt/mssql/lib/libc++.so.1
/opt/mssql/lib/libc++abi.so.1
/opt/mssql/lib/libjemalloc.so.1
/opt/mssql/lib/libsqltelemetry.so
/opt/mssql/lib/libunwind.so.8
/opt/mssql/lib/mssql-conf
/opt/mssql/lib/mssql-conf/collations. txt
/opt/mssql/lib/mssql-conf/mssql-conf. py
/opt/mssql/lib/mssql-conf/mssqlconfhelper. py
/opt/mssql/lib/mssql-conf/mssqlsettings. py
/opt/mssql/lib/mssql-conf/mssqlsett ingsmanager. py
/opt/mssql/lib/mssql-conf/sapassword.sh
/opt/mssql/lib/mssql-conf/set-collation. sh
/opt/mssql/lib/sqlpackage.sfp
/opt/mssql/lib/sqlservr.sfp
/opt/mssql/lib/system. certificates.sfp
/opt/mssql/lib/system. common.sfp
/opt/mssql/lib/system. netfx.sfp
/opt/mssql/lib/system.sfp
/usr/lib/systemd/system/mssql-server-telemetry. service
/usr/lib/systemd/ system/mssql-server.service
/usr/share/ doc/mssql-server/LICENSE. TXT
/usr/share/doc/mssql-server/THIRDPARTYNOTICES.TXT
/usr/share/man/man1/mssql-conf.1.gz
/usr/share/man/man1/ sqlpackage.1.gz
/usr/share/man/man1/sqlservr.1.gz
四、Rpm -ql Mssql-tools
查看 Mssql-toolsr 里有什么文件:
[ root@localhost *]# rpm -ql mssql-tools
/opt/mssql-tools/bin
/opt/mssql-tools/bin/bcp-14.0.1.246
/opt/mssql-tools/bin/sqlcmd-14.0.1.246
/opt/mssql-tools/share
/opt/mssql-tools/share/resources
/opt/mssql-tools/ share/resources/en_ US
/opt/mssql-tools/ share/resources/en US/BatchParserGrammar.dfa
/opt/mssql-tools/ share/resources/en_ US/BatchParserGrammar.llr
/opt/mssql-tools/ sha re/ resources/en_ US/SQLCMD.rll
/opt/mssql-tools/ share/resources/en_ US/bcp.rll
/usr/share/doc/mssq l-tools
/usr/share/doc/mssql-tools/LICENSE. txt
/usr/share/doc/mssql-tools/THIRDPARTYNOTICES. Txt
五、Rpm -ql sqlite
查看 Mssql-toolsr 里有什么文件:
[root@localhost ~]# rpm -ql sqlite
/usr/bin/sqlite3
/usr/lib64/libsqlite3.so.0
/usr/lib64/libsqlite3.so.0.8.6
/usr/share/doc/sqlite-3.7.17
/usr/share/doc/sqlite-3.7.17/README
/usr/share/man/man1/sqlite3.1.gz