2017年8月31日 星期四

Docker mssql-server-linux connected by Microsoft SQLServer Management Studio 17

升級 iproute
[root@docker CentOS69]# vi /etc/yum.repos.d/rdo.repo

[openstack-kilo]
name=OpenStack Kilo Repository
baseurl=https://repos.fedorapeople.org/repos/openstack/EOL/openstack-icehouse/epel-6/
skip_if_unavailable=0
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-RDO-kilo

"/etc/yum.repos.d/rdo.repo" [New] 7L, 229C written
[root@docker CentOS69]# yum update iproute -y
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Update Process
Loading mirror speeds from cached hostfile
 * base: centos.cs.nctu.edu.tw
 * epel: ftp.jaist.ac.jp
 * extras: centos.cs.nctu.edu.tw
 * updates: centos.cs.nctu.edu.tw
openstack-kilo                                                                                                                        | 2.9 kB     00:00     
openstack-kilo/primary_db                                                                                                             | 883 kB     00:01     
Resolving Dependencies
--> Running transaction check
---> Package iproute.x86_64 0:2.6.32-54.el6 will be updated
---> Package iproute.x86_64 0:2.6.32-130.el6ost.netns.2 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================================================
 Package                        Arch                          Version                                            Repository                             Size
=============================================================================================================================================================
Updating:
 iproute                        x86_64                        2.6.32-130.el6ost.netns.2                          openstack-kilo                        367 k

Transaction Summary
=============================================================================================================================================================
Upgrade       1 Package(s)

Total download size: 367 k
Downloading Packages:
iproute-2.6.32-130.el6ost.netns.2.x86_64.rpm                                                                                          | 367 kB     00:00     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating   : iproute-2.6.32-130.el6ost.netns.2.x86_64                                                                                                  1/2 
  Cleanup    : iproute-2.6.32-54.el6.x86_64                                                                                                              2/2 
  Verifying  : iproute-2.6.32-130.el6ost.netns.2.x86_64                                                                                                  1/2 
  Verifying  : iproute-2.6.32-54.el6.x86_64                                                                                                              2/2 

Updated:
  iproute.x86_64 0:2.6.32-130.el6ost.netns.2                                                                                                                 

Complete!
[root@docker CentOS69]# 
安裝 SQL Server Docker (SQLServer 2017)
[root@docker CentOS69]# docker run --name sqlserver -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Pass@w0rd' -p 1433:1433 -d microsoft/mssql-server-linux 
Unable to find image 'microsoft/mssql-server-linux:latest' locally
latest: Pulling from microsoft/mssql-server-linux

f72602a28b54: Pull complete 
bbbd48337ed2: Pull complete 
0839b8b27af2: Pull complete 
18ae0b663055: Pull complete 
6b73b115ffdf: Pull complete 
de828a3bde6d: Pull complete 
dd9f51e9bcb9: Pull complete 
8665286f55df: Pull complete 
467413a0363d: Pull complete 
2434543efa97: Pull complete 
de8f1ae0302d: Pull complete 
cd05d7a52262: Pull complete 
2a00f67d0592: Pull complete 
b75f8d4e765c: Pull complete 
6b2fb1b4f251: Pull complete 
Digest: sha256:e8af351a1bc6d98159cf68068df82b277ec027185becaae7a5f8a39fe140220d
Status: Downloaded newer image for microsoft/mssql-server-linux:latest
39762d1e7ec79396641c5f3abb29de11c85c584f4673c11086c7314a89673c8f
[root@docker CentOS69]# 
檢查目前網路設定
[root@docker CentOS69]# brctl show
bridge name     bridge id               STP enabled     interfaces
docker0         8000.3a682e206766       no              veth312f0a8
[root@docker CentOS69]# docker inspect sqlserver| grep IPAddress
        "IPAddress": "172.17.0.1",
        "SecondaryIPAddresses": null,
[root@docker CentOS69]# 
[root@docker CentOS69]# ifconfig docker0
docker0   Link encap:Ethernet  HWaddr 3A:68:2E:20:67:66  
          inet addr:172.17.42.1  Bcast:0.0.0.0  Mask:255.255.0.0
          inet6 addr: fe80::645b:51ff:fe98:cf84/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:154 errors:0 dropped:0 overruns:0 frame:0
          TX packets:200 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:10241 (10.0 KiB)  TX bytes:240545 (234.9 KiB)

[root@docker CentOS69]# ifconfig eth0
eth0      Link encap:Ethernet  HWaddr 00:15:5D:28:20:14  
          inet addr:172.20.10.8  Bcast:172.20.10.15  Mask:255.255.255.240
          inet6 addr: fe80::215:5dff:fe28:2014/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:415621 errors:0 dropped:0 overruns:0 frame:0
          TX packets:195716 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:594664541 (567.1 MiB)  TX bytes:14314568 (13.6 MiB)

[root@docker CentOS69]# 

安裝 Git
[root@docker CentOS69]#  yum install git-core
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: centos.cs.nctu.edu.tw
 * epel: mirror01.idc.hinet.net
 * extras: centos.cs.nctu.edu.tw
 * updates: centos.cs.nctu.edu.tw
Resolving Dependencies
--> Running transaction check
---> Package git.x86_64 0:1.7.1-9.el6_9 will be installed
--> Processing Dependency: perl-Git = 1.7.1-9.el6_9 for package: git-1.7.1-9.el6_9.x86_64
--> Processing Dependency: perl(Git) for package: git-1.7.1-9.el6_9.x86_64
--> Processing Dependency: perl(Error) for package: git-1.7.1-9.el6_9.x86_64
--> Running transaction check
---> Package perl-Error.noarch 1:0.17015-4.el6 will be installed
---> Package perl-Git.noarch 0:1.7.1-9.el6_9 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================================================
 Package                               Arch                              Version                                    Repository                          Size
=============================================================================================================================================================
Installing:
 git                                   x86_64                            1.7.1-9.el6_9                              updates                            4.6 M
Installing for dependencies:
 perl-Error                            noarch                            1:0.17015-4.el6                            base                                29 k
 perl-Git                              noarch                            1.7.1-9.el6_9                              updates                             29 k

Transaction Summary
=============================================================================================================================================================
Install       3 Package(s)

Total download size: 4.7 M
Installed size: 15 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): git-1.7.1-9.el6_9.x86_64.rpm                                                                                                   | 4.6 MB     00:02     
(2/3): perl-Error-0.17015-4.el6.noarch.rpm                                                                                            |  29 kB     00:00     
(3/3): perl-Git-1.7.1-9.el6_9.noarch.rpm                                                                                              |  29 kB     00:00     
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                        1.6 MB/s | 4.7 MB     00:02     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : 1:perl-Error-0.17015-4.el6.noarch                                                                                                         1/3 
  Installing : git-1.7.1-9.el6_9.x86_64                                                                                                                  2/3 
  Installing : perl-Git-1.7.1-9.el6_9.noarch                                                                                                             3/3 
  Verifying  : 1:perl-Error-0.17015-4.el6.noarch                                                                                                         1/3 
  Verifying  : git-1.7.1-9.el6_9.x86_64                                                                                                                  2/3 
  Verifying  : perl-Git-1.7.1-9.el6_9.noarch                                                                                                             3/3 

Installed:
  git.x86_64 0:1.7.1-9.el6_9                                                                                                                                 

Dependency Installed:
  perl-Error.noarch 1:0.17015-4.el6                                              perl-Git.noarch 0:1.7.1-9.el6_9                                             

Complete!
[root@docker CentOS69]# 
安装pipework
[root@docker user]# cd /home/user
[root@docker user]# git clone https://github.com/jpetazzo/pipework.git
Initialized empty Git repository in /home/user/pipework/.git/
remote: Counting objects: 501, d 2017-08-31 14:52 pipework
[root@docker user]# cp ./pipework/pipework /usr/local/bin/
加上Bridge
[root@docker user]# docker start sqlserver
sqlserver
[root@docker user]# pipework br0 sqlserver 172.20.10.10/24
[root@docker user]# ip addr add 172.20.10.10/24 dev br0
[root@docker user]# docker stop sqlserver
sqlserver
[root@docker user]# docker start sqlserver
sqlserver
[root@docker user]# 

Microsoft SQLServer Management Studio 連線畫面
  '

參考文件

mssql-server-linux

沒有留言:

張貼留言