RHEL 8 Beta Rhiav: Txhim kho Microsoft SQL Server

Microsoft SQL Server 2017 tau muaj rau kev siv tag nrho ntawm RHEL 7 txij thaum Lub Kaum Hli 2017, thiab nrog RHEL 8 Beta, Red Hat tau ua haujlwm ze nrog Microsoft txhawm rau txhim kho kev ua tau zoo thiab muab kev txhawb nqa rau ntau hom lus programming thiab daim ntawv thov txheej txheem, muab cov neeg tsim khoom xaiv ntau dua. cov cuab yeej los ua haujlwm ntawm lawv daim ntawv thov tom ntej.

Txoj hauv kev zoo tshaj plaws kom nkag siab txog cov kev hloov pauv thiab lawv cuam tshuam li cas rau koj txoj haujlwm yog sim lawv tawm, tab sis RHEL 8 tseem nyob hauv beta thiab Microsoft SQL Server 2017 tsis muaj kev txhawb nqa rau kev siv nyob rau hauv daim ntawv thov nyob. Yuav ua li cas?

Yog tias koj xav sim SQL Server ntawm RHEL 8 Beta, cov ntawv tshaj tawm no yuav pab koj tau txais nws thiab khiav, tab sis koj yuav tsum tsis txhob siv nws nyob rau hauv ib puag ncig ntau lawm kom txog rau thaum Red Hat Enterprise Linux 8 feem ntau muaj thiab Microsoft ua rau nws cov pob ntawv txhawb nqa. muaj rau installation.

Ib lub hom phiaj tseem ceeb ntawm Red Hat Enterprise Linux yog tsim kom muaj kev ruaj ntseg, homogeneous ib puag ncig rau kev khiav daim ntawv thov thib peb. Txhawm rau ua tiav qhov no, RHEL siv cov ntawv thov sib raug ntawm qib ntawm tus kheej APIs thiab cov ntsiav cuam tshuam. Thaum peb txav mus rau qhov kev tso tawm loj tshiab, feem ntau muaj qhov sib txawv tshwj xeeb ntawm cov npe ntawm cov pob khoom, cov ntawv tshiab ntawm cov tsev qiv ntawv thiab cov khoom siv tshiab uas tuaj yeem ua rau muaj teeb meem hauv kev khiav cov ntawv thov uas twb muaj lawm ua rau kev tso tawm dhau los. Cov neeg muag khoom software tuaj yeem ua raws Red Hat cov lus qhia los tsim cov kev ua haujlwm hauv Red Hat Enterprise Linux 7 uas yuav khiav hauv Red Hat Enterprise Linux 8, tab sis kev ua haujlwm nrog pob khoom yog qhov txawv. Ib pob software tsim rau Red Hat Enterprise Linux 7 yuav tsis tau txais kev txhawb nqa ntawm Red Hat Enterprise Linux 8.

SQL Server 2017 ntawm Red Hat Enterprise Linux 7 siv python2 thiab OpenSSL 1.0. Cov kauj ruam hauv qab no yuav muab qhov chaw ua haujlwm uas sib haum nrog ob lub ntsiab lus no, uas twb tau tsiv mus rau ntau qhov tshiab tshiab hauv RHEL 8 Beta. Kev suav nrog cov ntawv qub tau ua los ntawm Red Hat tshwj xeeb los tswj kev rov qab sib raug zoo.

sudo  yum install python2
sudo  yum install compat-openssl10

Tam sim no peb yuav tsum nkag siab txog qhov pib python teeb tsa ntawm qhov system no. Red Hat Enterprise Linux 8 tuaj yeem khiav python2 thiab python3 ib txhij, tab sis tsis muaj /usr/bin/python ntawm lub system los ntawm lub neej ntawd. Peb yuav tsum ua python2 lub neej ntawd txhais lus kom SQL Server 2017 tuaj yeem pom /usr/bin/python qhov twg nws xav pom nws. Txhawm rau ua qhov no koj yuav tsum khiav cov lus txib hauv qab no:

sudo alternatives —config python

Koj yuav tau txais kev tshoov siab kom xaiv koj tus Python version, tom qab ntawd cov cim txuas yuav raug tsim uas yuav nyob twj ywm tom qab lub kaw lus hloov tshiab.

Muaj peb qhov sib txawv ua haujlwm rau kev ua haujlwm nrog python:

 Selection    Command
———————————————————————-
*  1         /usr/libexec/no-python
+ 2           /usr/bin/python2
  3         /usr/bin/python3
Enter to keep the current selection[+], or type selection number: 

Ntawm no koj yuav tsum xaiv qhov kev xaiv thib ob, tom qab uas lub cim txuas yuav raug tsim los ntawm /usr/bin/python2 rau /usr/bin/python.

Tam sim no koj tuaj yeem txuas ntxiv teeb tsa lub system ua haujlwm nrog Microsoft SQL Server 2017 software repository siv cov lus txib curl:

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo

Tom ntej no, koj yuav tsum rub tawm SQL Server 2017 cov ntaub ntawv teeb tsa siv cov tshiab rub tawm hauv yum. Koj yuav tsum ua qhov no hauv txoj hauv kev uas koj tuaj yeem nruab yam tsis tas yuav daws qhov kev vam khom:

sudo yum download mssql-server

Tam sim no cia peb nruab tus neeg rau zaub mov yam tsis tau daws qhov kev vam khom siv cov lus txib rpm:

sudo rpm -Uvh —nodeps mssql-server*rpm

Tom qab no, koj tuaj yeem txuas ntxiv nrog kev teeb tsa SQL Server ib txwm, raws li tau piav qhia hauv Microsoft phau ntawv qhia "Quick Start: Txhim Kho SQL Server thiab Tsim Cov Ntaub Ntawv Hauv Lub Hau Liab" los ntawm kauj ruam # 3:

3. После завершения установки пакета выполните команду mssql-conf setup и следуйте подсказкам для установки пароля системного администратора (SA) и выбора вашей версии.

sudo /opt/mssql/bin/mssql-conf setup 

Tom qab kev teeb tsa tiav lawm, koj tuaj yeem tshawb xyuas cov version ntawm SQL neeg rau zaub mov uas tau teeb tsa siv cov lus txib:

# yum list —installed | grep mssql-server

Txhawb nqa ntim

Nrog rau kev tso tawm ntawm SQL Server 2019, kev cog lus cog lus yuav ua kom yooj yim dua vim tias cov qauv no yuav tsum muaj nyob rau ntawm RHEL ua lub thawv. SQL Server 2019 yog tam sim no muaj nyob rau hauv beta. Txhawm rau sim nws hauv RHEL 8 Beta, koj tsuas yog xav tau peb kauj ruam:

Ua ntej, cia peb tsim cov ntaub ntawv khaws cia uas tag nrho peb cov ntaub ntawv SQL yuav muab khaws cia. Rau qhov piv txwv no peb yuav siv lub /var/mssql directory.

sudo mkdir /var/mssql
sudo chmod 755 /var/mssql

Tam sim no koj yuav tsum rub tawm lub thawv nrog SQL 2019 Beta los ntawm Microsoft Container Repository nrog cov lus txib:

sudo podman pull mcr.microsoft.com/mssql/rhel/server:2019-CTP2.2

Thaum kawg, koj yuav tsum teeb tsa SQL server. Hauv qhov no, peb yuav teeb tsa tus thawj tswj hwm (SA) lo lus zais rau cov ntaub ntawv hu ua sql1 khiav ntawm cov chaw nres nkoj 1401 - 1433.

sudo podman run -e 'ACCEPT_EULA=Y' -e 
'MSSQL_SA_PASSWORD=<YourStrong!Passw0rd>'   
—name 'sql1' -p 1401:1433 -v /var/mssql:/var/opt/mssql:Z -d  
mcr.microsoft.com/mssql/rhel/server:2019-CTP2.2

Xav paub ntau ntxiv txog podman thiab ntim hauv Red Hat Enterprise Linux 8 Beta tuaj yeem pom ntawm no.

Ua haujlwm rau ob

Koj tuaj yeem sim ua ke ntawm RHEL 8 Beta thiab SQL Server 2017 yog siv cov kev teeb tsa ib txwm siv lossis los ntawm kev txhim kho lub thawv ntawv. Txawm li cas los xij, tam sim no koj muaj ib qho piv txwv ntawm SQL Server ntawm koj qhov kev pov tseg, thiab koj tuaj yeem pib sau koj cov ntaub ntawv los yog tshawb nrhiav cov cuab yeej muaj nyob hauv RHEL 8 Beta los tsim ib daim ntawv thov pawg, automate cov txheej txheem teeb tsa, lossis ua kom zoo dua.

Thaum ntxov lub Tsib Hlis, nco ntsoov mloog Bob Ward, tus kws tsim qauv laus hauv Microsoft Database Systems Group, hais lus ntawm lub rooj sib tham Liab Rooj Sib Tham 2019, qhov twg peb yuav tham txog kev xa cov ntaub ntawv niaj hnub platform raws li SQL Server 2019 thiab Red Hat Enterprise Linux 8 Beta.

Thiab nyob rau lub Tsib Hlis 8, yuav tsum muaj kev tshaj tawm, qhib kev siv SQL Server hauv kev siv tiag.

Tau qhov twg los: www.hab.com