search

B1-Initiative-Foundation / ubuntu

Other
9 stars 1 forks source link

Install ODBC Driver MS SQL #41

Open phazecrypto opened 1 month ago

phazecrypto commented 1 month ago

sudo su curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list > /etc/apt/sources.list.d/mssql-release.list exit sudo apt-get update sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17 sudo apt-get install -y unixodbc-dev

phazecrypto commented 1 month ago

root@b1vm:/home/b1admin# curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 983 100 983 0 0 285 0 0:00:03 0:00:03 --:--:-- 285 OK root@b1vm:/home/b1admin# curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list > /etc/apt/sources .list.d/mssql-release.list % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 89 100 89 0 0 2405 0 --:--:-- --:--:-- --:--:-- 2405 root@b1vm:/home/b1admin# exit exit b1admin@b1vm:~$ sudo apt-get update Get:1 http://azure.archive.ubuntu.com/ubuntu focal InRelease [265 kB] Get:2 http://azure.archive.ubuntu.com/ubuntu focal-updates InRelease [128 kB] Get:3 http://azure.archive.ubuntu.com/ubuntu focal-backports InRelease [128 kB] Hit:4 http://azure.archive.ubuntu.com/ubuntu focal-security InRelease Get:5 https://packages.microsoft.com/ubuntu/20.04/prod focal InRelease [3632 B] Get:6 http://azure.archive.ubuntu.com/ubuntu focal/main amd64 Packages [970 kB] Hit:7 http://ppa.launchpad.net/deadsnakes/ppa/ubuntu focal InRelease Get:8 http://azure.archive.ubuntu.com/ubuntu focal/main Translation-en [506 kB] Get:9 http://azure.archive.ubuntu.com/ubuntu focal/main amd64 c-n-f Metadata [29.5 kB] Get:10 http://azure.archive.ubuntu.com/ubuntu focal/restricted amd64 Packages [22.0 kB] Get:11 http://azure.archive.ubuntu.com/ubuntu focal/restricted Translation-en [6212 B] Get:12 http://azure.archive.ubuntu.com/ubuntu focal/restricted amd64 c-n-f Metadata [392 B] Get:13 http://azure.archive.ubuntu.com/ubuntu focal/universe amd64 Packages [8628 kB] Get:14 http://azure.archive.ubuntu.com/ubuntu focal/universe Translation-en [5124 kB] Get:15 http://azure.archive.ubuntu.com/ubuntu focal/universe amd64 c-n-f Metadata [265 kB] Get:16 http://azure.archive.ubuntu.com/ubuntu focal/multiverse amd64 Packages [144 kB] Get:17 http://azure.archive.ubuntu.com/ubuntu focal/multiverse Translation-en [104 kB] Get:18 http://azure.archive.ubuntu.com/ubuntu focal/multiverse amd64 c-n-f Metadata [9136 B] Get:19 http://azure.archive.ubuntu.com/ubuntu focal-updates/main amd64 Packages [3332 kB] Get:20 http://azure.archive.ubuntu.com/ubuntu focal-updates/main Translation-en [525 kB] Get:21 http://azure.archive.ubuntu.com/ubuntu focal-updates/main amd64 c-n-f Metadata [17.2 kB] Get:22 http://azure.archive.ubuntu.com/ubuntu focal-updates/restricted amd64 Packages [2953 kB] Get:23 http://azure.archive.ubuntu.com/ubuntu focal-updates/restricted Translation-en [413 kB] Get:24 http://azure.archive.ubuntu.com/ubuntu focal-updates/restricted amd64 c-n-f Metadata [552 B] Get:25 http://azure.archive.ubuntu.com/ubuntu focal-updates/universe amd64 Packages [1189 kB] Get:26 http://azure.archive.ubuntu.com/ubuntu focal-updates/universe Translation-en [285 kB] Get:27 http://azure.archive.ubuntu.com/ubuntu focal-updates/universe amd64 c-n-f Metadata [25.7 kB] Get:28 http://azure.archive.ubuntu.com/ubuntu focal-updates/multiverse amd64 Packages [26.2 kB] Get:29 http://azure.archive.ubuntu.com/ubuntu focal-updates/multiverse Translation-en [7880 B] Get:30 http://azure.archive.ubuntu.com/ubuntu focal-updates/multiverse amd64 c-n-f Metadata [620 B] Get:31 http://azure.archive.ubuntu.com/ubuntu focal-backports/main amd64 Packages [45.7 kB] Get:32 http://azure.archive.ubuntu.com/ubuntu focal-backports/main Translation-en [16.3 kB] Get:33 http://azure.archive.ubuntu.com/ubuntu focal-backports/main amd64 c-n-f Metadata [1420 B] Get:34 http://azure.archive.ubuntu.com/ubuntu focal-backports/restricted amd64 c-n-f Metadata [116 B] Get:35 http://azure.archive.ubuntu.com/ubuntu focal-backports/universe amd64 Packages [25.0 kB] Get:36 http://azure.archive.ubuntu.com/ubuntu focal-backports/universe Translation-en [16.3 kB] Get:37 http://azure.archive.ubuntu.com/ubuntu focal-backports/universe amd64 c-n-f Metadata [880 B] Get:38 http://azure.archive.ubuntu.com/ubuntu focal-backports/multiverse amd64 c-n-f Metadata [116 B] Get:39 https://packages.microsoft.com/ubuntu/20.04/prod focal/main arm64 Packages [60.6 kB] Get:40 https://packages.microsoft.com/ubuntu/20.04/prod focal/main armhf Packages [20.9 kB] Get:41 https://packages.microsoft.com/ubuntu/20.04/prod focal/main all Packages [2714 B] Get:42 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 Packages [293 kB] Fetched 25.6 MB in 6s (4528 kB/s) Reading package lists... Done b1admin@b1vm:~$ sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17 Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: libodbc1 odbcinst odbcinst1debian2 unixodbc Suggested packages: unixodbc-bin The following NEW packages will be installed: libodbc1 msodbcsql17 odbcinst odbcinst1debian2 unixodbc 0 upgraded, 5 newly installed, 0 to remove and 8 not upgraded. Need to get 1404 kB of archives. After this operation, 1059 kB of additional disk space will be used. Get:1 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 libodbc1 amd64 2.3.11-1 [486 kB] Get:2 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 odbcinst1debian2 amd64 2.3.11-1 [99.8 kB] Get:3 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 odbcinst amd64 2.3.11-1 [21.3 kB] Get:4 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 unixodbc amd64 2.3.11-1 [51.5 kB] Get:5 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 msodbcsql17 amd64 17.10.6.1-1 [746 kB] Fetched 1404 kB in 0s (14.7 MB/s) Preconfiguring packages ... Selecting previously unselected package libodbc1:amd64. (Reading database ... 66802 files and directories currently installed.) Preparing to unpack .../libodbc1_2.3.11-1_amd64.deb ... Unpacking libodbc1:amd64 (2.3.11-1) ... Selecting previously unselected package odbcinst1debian2:amd64. Preparing to unpack .../odbcinst1debian2_2.3.11-1_amd64.deb ... Unpacking odbcinst1debian2:amd64 (2.3.11-1) ... Selecting previously unselected package odbcinst. Preparing to unpack .../odbcinst_2.3.11-1_amd64.deb ... Unpacking odbcinst (2.3.11-1) ... Selecting previously unselected package unixodbc. Preparing to unpack .../unixodbc_2.3.11-1_amd64.deb ... Unpacking unixodbc (2.3.11-1) ... Selecting previously unselected package msodbcsql17. Preparing to unpack .../msodbcsql17_17.10.6.1-1_amd64.deb ... Unpacking msodbcsql17 (17.10.6.1-1) ... Setting up libodbc1:amd64 (2.3.11-1) ... Setting up odbcinst (2.3.11-1) ... Setting up odbcinst1debian2:amd64 (2.3.11-1) ... Setting up unixodbc (2.3.11-1) ... Setting up msodbcsql17 (17.10.6.1-1) ... odbcinst: Driver installed. Usage count increased to 1. Target directory is /etc Processing triggers for man-db (2.9.1-1) ... Processing triggers for libc-bin (2.31-0ubuntu9.16) ... b1admin@b1vm:~$ sudo apt-get install -y unixodbc-dev Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: autoconf automake autotools-dev libltdl-dev libtool m4 Suggested packages: autoconf-archive gnu-standards autoconf-doc gettext libtool-doc gfortran | fortran95-compiler gcj-jdk m4-doc The following NEW packages will be installed: autoconf automake autotools-dev libltdl-dev libtool m4 unixodbc-dev 0 upgraded, 7 newly installed, 0 to remove and 8 not upgraded. Need to get 1447 kB of archives. After this operation, 7918 kB of additional disk space will be used. Get:1 http://azure.archive.ubuntu.com/ubuntu focal/main amd64 m4 amd64 1.4.18-4 [199 kB] Get:2 http://azure.archive.ubuntu.com/ubuntu focal/main amd64 autoconf all 2.69-11.1 [321 kB] Get:3 http://azure.archive.ubuntu.com/ubuntu focal/main amd64 autotools-dev all 20180224.1 [39.6 kB] Get:4 http://azure.archive.ubuntu.com/ubuntu focal/main amd64 automake all 1:1.16.1-4ubuntu6 [522 kB] Get:5 http://azure.archive.ubuntu.com/ubuntu focal/main amd64 libltdl-dev amd64 2.4.6-14 [162 kB] Get:6 http://azure.archive.ubuntu.com/ubuntu focal/main amd64 libtool all 2.4.6-14 [161 kB] Get:7 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 unixodbc-dev amd64 2.3.11-1 [42.4 kB] Fetched 1447 kB in 0s (21.3 MB/s) Selecting previously unselected package m4. (Reading database ... 66853 files and directories currently installed.) Preparing to unpack .../0-m4_1.4.18-4_amd64.deb ... Unpacking m4 (1.4.18-4) ... Selecting previously unselected package autoconf. Preparing to unpack .../1-autoconf_2.69-11.1_all.deb ... Unpacking autoconf (2.69-11.1) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../2-autotools-dev_20180224.1_all.deb ... Unpacking autotools-dev (20180224.1) ... Selecting previously unselected package automake. Preparing to unpack .../3-automake_1%3a1.16.1-4ubuntu6_all.deb ... Unpacking automake (1:1.16.1-4ubuntu6) ... Selecting previously unselected package libltdl-dev:amd64. Preparing to unpack .../4-libltdl-dev_2.4.6-14_amd64.deb ... Unpacking libltdl-dev:amd64 (2.4.6-14) ... Selecting previously unselected package libtool. Preparing to unpack .../5-libtool_2.4.6-14_all.deb ... Unpacking libtool (2.4.6-14) ... Selecting previously unselected package unixodbc-dev. Preparing to unpack .../6-unixodbc-dev_2.3.11-1_amd64.deb ... Unpacking unixodbc-dev (2.3.11-1) ... Setting up m4 (1.4.18-4) ... Setting up autotools-dev (20180224.1) ... Setting up autoconf (2.69-11.1) ... Setting up automake (1:1.16.1-4ubuntu6) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up libtool (2.4.6-14) ... Setting up libltdl-dev:amd64 (2.4.6-14) ... Setting up unixodbc-dev (2.3.11-1) ... Processing triggers for install-info (6.7.0.dfsg.2-5) ... Processing triggers for man-db (2.9.1-1) ...