RHEL 8 Beta Workshop: Fa'apipi'i le Microsoft SQL Server

Microsoft SQL Server 2017 ua avanoa mo le faʻaaogaina atoatoa ile RHEL 7 talu mai Oketopa 2017, ma faʻatasi ai ma le RHEL 8 Beta, Red Hat na galulue vavalalata ma Microsoft e faʻaleleia le faʻatinoga ma tuʻuina atu le lagolago mo le tele o gagana polokalame ma faʻatulagaga o talosaga, e ofoina atu i le au atinaʻe le tele o filifiliga avanoa. meafaigaluega e galue ai i le isi a latou talosaga.

O le auala sili e malamalama ai i suiga ma pe faʻafefea ona latou aʻafia ai lau galuega o le faʻataʻitaʻiina lea, ae o le RHEL 8 o loʻo i totonu o le beta ma le Microsoft SQL Server 2017 e leʻo lagolagoina mo le faʻaogaina i luga o talosaga. O le a le mea e fai?

Afai e te manaʻo e faʻataʻitaʻi le SQL Server i luga o le RHEL 8 Beta, o lenei pou o le a fesoasoani ia te oe e faʻaleleia ma faʻagaoioia, ae e le tatau ona e faʻaaogaina i se siosiomaga gaosiga seʻia oʻo ina maua lautele le Red Hat Enterprise Linux 8 ma faia e Microsoft lana afifi aloaia. avanoa mo fa'apipi'i.

O se tasi o sini autu a Red Hat Enterprise Linux o le fatuina lea o se fale mautu, si'osi'omaga tutusa mo le fa'atinoina o talosaga a isi vaega. Ina ia ausia lenei mea, e faʻaogaina e le RHEL le fesoʻotaʻiga o talosaga i le tulaga o API taʻitasi ma fesoʻotaʻiga fatu. A matou siitia atu i se faʻasalalauga tele fou, e masani lava ona i ai eseesega faʻapitoa i igoa o afifi, faʻamatalaga fou o faletusi ma mea aoga fou e mafai ona faʻalavelave ai le faʻaogaina o talosaga o loʻo i ai nei na fausia mo le faʻasalalauga muamua. E mafai e tagata fa'atau polokalame ona mulimulita'i i ta'iala a Red Hat e fai ai mea e mafai ona fa'atinoina i le Red Hat Enterprise Linux 7 lea o le a tamo'e i le Red Hat Enterprise Linux 8, ae o le galulue fa'atasi ma afifi ose mea e ese. O se pusa komipiuta na faia mo Red Hat Enterprise Linux 7 o le a le lagolagoina i Red Hat Enterprise Linux 8.

SQL Server 2017 ile Red Hat Enterprise Linux 7 faʻaaogaina python2 ma OpenSSL 1.0. O laasaga o loʻo mulimuli mai o le a maua ai se siosiomaga galue e fetaui ma nei vaega e lua, lea ua uma ona faʻafeiloaʻi i lomiga lata mai i RHEL 8 Beta. O le faʻaofiina o lomiga tuai na faia e Red Hat faʻapitoa e faʻamautu ai le fetaui i tua.

sudo  yum install python2
sudo  yum install compat-openssl10

Ole taimi nei e manaʻomia ona tatou malamalama i le amataga o le python i luga o lenei faiga. Red Hat Enterprise Linux 8 e mafai ona tamoe python2 ma python3 i le taimi e tasi, ae leai se /usr/bin/python i luga ole faiga e ala ile faaletonu. Matou te manaʻomia le faia o le python2 o le faʻaliliuupu le lelei ina ia mafai e le SQL Server 2017 ona vaʻaia /usr/bin/python i le mea e faʻamoemoe e vaʻaia ai. Ina ia faia lenei mea e te manaʻomia le faʻatinoina o le poloaiga lenei:

sudo alternatives —config python

O le a faʻamalosia oe e filifili lau Python version, pe a maeʻa ona faia se fesoʻotaʻiga faʻatusa o le a faʻaauau pea pe a uma ona faʻafouina le faiga.

E tolu mea e mafai ona faʻatinoina mo le galue ma le 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: 

O iinei e te manaʻomia ai le filifilia o le filifiliga lona lua, a maeʻa ona fausia ai se fesoʻotaʻiga faʻatusa mai /usr/bin/python2 i /usr/bin/python.

Ole taimi nei e mafai ona e faʻaauau le faʻatulagaina o le faiga e galue ai ma le Microsoft SQL Server 2017 software repository e faʻaaoga ai le curl command:

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

O le isi, e tatau ona e siiina faila faʻapipiʻi SQL Server 2017 e faʻaaoga ai le ata fou o le download ile yum. E tatau ona e faia lenei mea i se auala e mafai ai ona e faʻapipiʻi e aunoa ma le toe foia o faʻalagolago:

sudo yum download mssql-server

Sei o tatou faʻapipiʻi le 'auʻaunaga e aunoa ma le foia o faʻalagolago e faʻaaoga ai le rpm poloaiga:

sudo rpm -Uvh —nodeps mssql-server*rpm

A maeʻa lenei mea, e mafai ona e faʻaauau le faʻapipiʻiina o le SQL Server masani, e pei ona faʻamatalaina i le taʻiala a Microsoft "Amata vave: Faʻapipiʻi le SQL Server ma Fausia se Faʻamaumauga i Red Hat" mai le laasaga #3:

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

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

A maeʻa le faʻapipiʻiina, e mafai ona e siakiina le faʻaogaina o le SQL server faʻapipiʻi e faʻaaoga ai le poloaiga:

# yum list —installed | grep mssql-server

Lagolago pusa

Faatasi ai ma le faʻasaʻolotoina o le SQL Server 2019, faʻapipiʻi folafolaga e sili atu ona faigofie ona o lenei faʻamatalaga e faʻamoemoe e maua ile RHEL o se pusa. SQL Server 2019 ua avanoa nei ile beta. Ina ia faʻataʻitaʻiina i le RHEL 8 Beta, e naʻo le tolu laasaga e te manaʻomia:

Muamua, se'i o tatou faia se fa'amaumauga fa'amaumauga e teu uma ai a tatou fa'amaumauga SQL. Mo lenei faʻataʻitaʻiga o le a matou faʻaogaina le /var/mssql directory.

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

Ole taimi nei e te manaʻomia le downloadina o le atigipusa ma SQL 2019 Beta mai le Microsoft Container Repository ma le faʻatonuga:

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

Mulimuli ane, e tatau ona e faʻatulagaina le SQL server. I lenei tulaga, matou te setiina se faʻaupuga (SA) mo se faʻamaumauga e taʻua o le sql1 o loʻo taʻavale i luga o ports 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

O nisi faʻamatalaga e uiga i podman ma koneteina i Red Hat Enterprise Linux 8 Beta e mafai ona maua iinei.

E galue mo le lua

E mafai ona e faʻataʻitaʻiina le tuʻufaʻatasiga o le RHEL 8 Beta ma le SQL Server 2017 pe faʻaaogaina se faʻapipiʻi masani poʻo le faʻapipiʻiina o se pusa talosaga. Po o le a lava le auala, o loʻo i ai nei lau faʻataʻitaʻiga o le SQL Server i lou tuʻuina atu, ma e mafai ona e amata faʻatupuina lau faʻamaumauga pe suʻesuʻe meafaigaluega o loʻo maua i le RHEL 8 Beta e fatu ai se faʻaputuga talosaga, faʻatometi le faʻatulagaina o le faʻatulagaga, poʻo le faʻaleleia o le faʻatinoga.

I le amataga o Me, ia mautinoa e faʻalogo ia Bob Ward, tusiata sinia i le Microsoft Database Systems Group, tautala i le tumutumu. Fonotaga Red Hat 2019, lea o le a tatou talanoaina ai le faʻapipiʻiina o se faʻamaumauga faʻaonaponei faʻavae i luga ole SQL Server 2019 ma Red Hat Enterprise Linux 8 Beta.

Ma i le aso 8 o Me, o loʻo faʻamoemoeina se faʻasalalauga aloaia, tatala le faʻaogaina o le SQL Server i talosaga moni.

puna: www.habr.com