RHEL 8 Beta Idanileko: Fifi Microsoft SQL Server sori ẹrọ

Microsoft SQL Server 2017 ti wa fun lilo ni kikun lori RHEL 7 lati Oṣu Kẹwa ọdun 2017, ati pẹlu RHEL 8 Beta, Red Hat ṣiṣẹ ni pẹkipẹki pẹlu Microsoft lati mu ilọsiwaju ṣiṣẹ ati pese atilẹyin fun awọn ede siseto diẹ sii ati awọn ilana ohun elo, fifun awọn olupilẹṣẹ aṣayan diẹ sii ti o wa. irinṣẹ lati sise lori wọn tókàn elo.

Ọna ti o dara julọ lati loye awọn iyipada ati bii wọn ṣe ni ipa iṣẹ rẹ ni lati gbiyanju wọn, ṣugbọn RHEL 8 tun wa ni beta ati Microsoft SQL Server 2017 ko ni atilẹyin fun lilo ninu awọn ohun elo laaye. Kin ki nse?

Ti o ba fẹ gbiyanju SQL Server lori RHEL 8 Beta, ifiweranṣẹ yii yoo ran ọ lọwọ lati mu ṣiṣẹ, ṣugbọn o ko yẹ ki o lo ni agbegbe iṣelọpọ titi Red Hat Enterprise Linux 8 yoo wa ni gbogbogbo ati Microsoft ṣe atilẹyin ni ifowosi package wa fun awọn fifi sori ẹrọ.

Ọkan ninu awọn ibi-afẹde akọkọ ti Red Hat Enterprise Linux ni lati ṣẹda iduroṣinṣin, ayika isokan fun ṣiṣe awọn ohun elo ẹni-kẹta. Lati ṣaṣeyọri eyi, RHEL ṣe imuse ibamu ohun elo ni ipele ti API kọọkan ati awọn atọkun kernel. Nigba ti a ba lọ si idasilẹ pataki tuntun kan, awọn iyatọ pataki nigbagbogbo wa ninu awọn orukọ ti awọn idii, awọn ẹya tuntun ti awọn ile-ikawe ati awọn ohun elo tuntun ti o le fa awọn iṣoro ni ṣiṣe awọn ohun elo ti o wa tẹlẹ ti a ṣe fun idasilẹ iṣaaju. Awọn olutaja sọfitiwia le tẹle awọn itọsọna Red Hat lati ṣẹda awọn adaṣe ni Red Hat Enterprise Linux 7 ti yoo ṣiṣẹ ni Red Hat Enterprise Linux 8, ṣugbọn ṣiṣẹ pẹlu awọn idii jẹ ọrọ ti o yatọ. Apo sọfitiwia ti a ṣẹda fun Red Hat Enterprise Linux 7 kii yoo ni atilẹyin lori Red Hat Enterprise Linux 8.

SQL Server 2017 lori Red Hat Enterprise Linux 7 nlo python2 ati OpenSSL 1.0. Awọn igbesẹ wọnyi yoo pese agbegbe iṣẹ ti o ni ibamu pẹlu awọn paati meji wọnyi, eyiti o ti lọ tẹlẹ si awọn ẹya aipẹ diẹ sii ni RHEL 8 Beta. Ifisi ti awọn ẹya agbalagba ni a ṣe nipasẹ Red Hat pataki lati ṣetọju ibamu sẹhin.

sudo  yum install python2
sudo  yum install compat-openssl10

Bayi a nilo lati loye awọn eto Python ibẹrẹ lori eto yii. Red Hat Enterprise Linux 8 le ṣiṣẹ Python2 ati python3 ni nigbakannaa, ṣugbọn ko si / usr/bin/python lori eto nipasẹ aiyipada. A nilo lati ṣe python2 onitumọ aiyipada ki SQL Server 2017 le rii /usr/bin/python nibiti o nireti lati rii. Lati ṣe eyi o nilo lati ṣiṣẹ aṣẹ wọnyi:

sudo alternatives —config python

Iwọ yoo ti ọ lati yan ẹya Python rẹ, lẹhin eyiti ọna asopọ aami yoo ṣẹda ti yoo tẹsiwaju lẹhin imudojuiwọn eto naa.

Awọn adaṣe oriṣiriṣi mẹta wa fun ṣiṣẹ pẹlu 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: 

Nibi o nilo lati yan aṣayan keji, lẹhin eyiti ọna asopọ aami yoo ṣẹda lati /usr/bin/python2 si /usr/bin/python.

Bayi o le tẹsiwaju atunto eto naa lati ṣiṣẹ pẹlu ibi ipamọ sọfitiwia Microsoft SQL Server 2017 nipa lilo aṣẹ curl:

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

Nigbamii ti, o yẹ ki o ṣe igbasilẹ awọn faili fifi sori ẹrọ SQL Server 2017 nipa lilo ẹya igbasilẹ tuntun ni yum. O nilo lati ṣe eyi ni ọna ti o le fi sii laisi nini lati yanju awọn igbẹkẹle:

sudo yum download mssql-server

Bayi jẹ ki a fi sori ẹrọ olupin laisi ipinnu awọn igbẹkẹle nipa lilo aṣẹ rpm:

sudo rpm -Uvh —nodeps mssql-server*rpm

Lẹhin eyi, o le tẹsiwaju pẹlu fifi sori SQL Server deede, gẹgẹbi a ti ṣalaye ninu itọsọna Microsoft “Ibẹrẹ Ibẹrẹ: Fifi sori ẹrọ olupin SQL ati Ṣiṣẹda aaye data kan ni Hat Red” lati igbesẹ #3:

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

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

Lẹhin fifi sori ẹrọ ti pari, o le ṣayẹwo ẹya ti olupin SQL ti o fi sii nipa lilo aṣẹ naa:

# yum list —installed | grep mssql-server

Ṣe atilẹyin awọn apoti

Pẹlu itusilẹ ti SQL Server 2019, fifi sori ṣe ileri lati di paapaa rọrun bi ẹya yii ṣe nireti lati wa lori RHEL bi eiyan kan. SQL Server 2019 wa bayi ni beta. Lati gbiyanju ni RHEL 8 Beta, o nilo awọn igbesẹ mẹta nikan:

Ni akọkọ, jẹ ki a ṣẹda iwe ipamọ data nibiti gbogbo data SQL wa yoo wa ni ipamọ. Fun apẹẹrẹ yii a yoo lo itọsọna /var/mssql.

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

Bayi o nilo lati ṣe igbasilẹ eiyan pẹlu SQL 2019 Beta lati Ibi ipamọ Apoti Microsoft pẹlu aṣẹ:

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

Nikẹhin, o nilo lati tunto olupin SQL. Ni ọran yii, a yoo ṣeto ọrọ igbaniwọle alakoso (SA) fun data data ti a pe ni sql1 ti n ṣiṣẹ lori awọn ibudo 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

Alaye diẹ sii nipa podman ati awọn apoti ni Red Hat Enterprise Linux 8 Beta ni a le rii Nibi.

Ṣiṣẹ fun meji

O le gbiyanju apapo RHEL 8 Beta ati SQL Server 2017 boya lilo fifi sori ẹrọ ibile tabi nipa fifi ohun elo eiyan sori ẹrọ. Ọna boya, o ni bayi ni apẹẹrẹ nṣiṣẹ ti SQL Server ni ọwọ rẹ, ati pe o le bẹrẹ si gbejade data data rẹ tabi ṣawari awọn irinṣẹ ti o wa ni RHEL 8 Beta lati ṣẹda akopọ ohun elo kan, ṣe adaṣe ilana iṣeto, tabi mu iṣẹ ṣiṣe dara si.

Ni ibẹrẹ Oṣu Karun, rii daju lati tẹtisi Bob Ward, ayaworan agba ni Ẹgbẹ Awọn aaye data Data Microsoft, sọrọ ni ipade Apejọ Red Hat 2019, Nibi ti a yoo jiroro lori gbigbe ipilẹ data ode oni ti o da lori SQL Server 2019 ati Red Hat Enterprise Linux 8 Beta.

Ati ni Oṣu Karun ọjọ 8, a nireti itusilẹ osise, ṣiṣi lilo olupin SQL ni awọn ohun elo gidi.

orisun: www.habr.com