RHEL 8 Beta Workshop: Kuisa Microsoft SQL Server

Microsoft SQL Server 2017 yave kuwanikwa kuti ishandiswe zvizere paRHEL 7 kubva Gumiguru 2017, uye neRHEL 8 Beta, Red Hat yakashanda pamwe neMicrosoft kuvandudza mashandiro uye kupa rutsigiro rwemimwe mitauro yekuronga uye masisitimu ekushandisa, ichipa vanogadzira sarudzo yakawanda iripo. zvishandiso zvekushanda pane yavo inotevera application.

Nzira yakanakisa yekunzwisisa shanduko uye mabatiro aanoita basa rako ndeyekuedza kunze, asi RHEL 8 ichiri mubeta uye Microsoft SQL Server 2017 haitsigirwe kuti ishandiswe mukurarama maapplication. Kuita sei?

Kana iwe uchida kuyedza SQL Server paRHEL 8 Beta, iyi positi ichakubatsira kuti usimuke uye ushande, asi haufanirwe kuishandisa munzvimbo yekugadzira kudzamara Red Hat Enterprise Linux 8 yave kuwanikwa uye Microsoft yagadzira iyo inotsigirwa zviri pamutemo package. iripo pakuisa.

Chimwe chezvinangwa zvikuru zveRed Hat Enterprise Linux kugadzira yakagadzikana, homogeneous nharaunda yekushandisa yechitatu-bato zvikumbiro. Kuti uite izvi, RHEL inoshandisa kuenderana kwekushandisa padanho remunhu API uye kernel interfaces. Kana isu tichienda kune kuburitswa kukuru kutsva, panowanzo kuve nekusiyana kwakakosha mumazita emapakeji, shanduro nyowani dzemaraibhurari uye zvitsva zvinoshandiswa zvinogona kukonzera kunetsa mukushandisa zviripo zvakagadzirirwa kuburitswa kwapfuura. Vatengesi veSoftware vanogona kutevedzera nhungamiro yeRed Hat kugadzira zvinogoneka muRed Hat Enterprise Linux 7 iyo inomhanya muRed Hat Enterprise Linux 8, asi kushanda nemapakeji inyaya yakasiyana. A software package yakagadzirirwa Red Hat Enterprise Linux 7 haizotsigirwe paRed Hat Enterprise Linux 8.

SQL Server 2017 paRed Hat Enterprise Linux 7 inoshandisa python2 uye OpenSSL 1.0. Matanho anotevera achapa nharaunda yekushanda inoenderana nezvikamu zviviri izvi, izvo zvakatotamiswa kune dzimwe shanduro dzichangoburwa muRHEL 8 Beta. Kubatanidzwa kweshanduro dzekare kwakaitwa neRed Hat zvakananga kuchengetedza kuenderana kumashure.

sudo  yum install python2
sudo  yum install compat-openssl10

Zvino isu tinoda kunzwisisa yekutanga python marongero pane ino system. Red Hat Enterprise Linux 8 inogona kumhanya python2 uye python3 panguva imwe chete, asi hapana /usr/bin/python pane system nekukasira. Isu tinofanirwa kuita python2 mushanduri weiyo default kuitira kuti SQL Server 2017 ione /usr/bin/python painotarisira kuiona. Kuti uite izvi unofanirwa kumhanya murairo unotevera:

sudo alternatives —config python

Iwe unozokurudzirwa kusarudza yako Python vhezheni, mushure meiyo yekufananidzira link ichasikwa iyo icharamba ichienderera mushure mekugadzirisa system.

Kune matatu akasiyana eexecutable ekushanda nepython:

 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: 

Pano iwe unofanirwa kusarudza yechipiri sarudzo, mushure meiyo chiratidzo chinongedzo chinogadzirwa kubva /usr/bin/python2 kuenda /usr/bin/python.

Iye zvino unogona kuenderera mberi nekugadzirisa sisitimu kuti ishande neMicrosoft SQL Server 2017 software repository uchishandisa iyo curl command:

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

Tevere, iwe unofanirwa kudhawunirodha iyo SQL Server 2017 yekuisa mafaera uchishandisa iyo nyowani yekurodha ficha muyum. Iwe unofanirwa kuita izvi nenzira yekuti iwe unogona kuisa pasina kugadzirisa zvinoenderana:

sudo yum download mssql-server

Zvino ngatiise sevha tisingagadzirise zvinotsamira tichishandisa iyo rpm command:

sudo rpm -Uvh —nodeps mssql-server*rpm

Mushure meizvi, unogona kuenderera neyakajairwa SQL Server yekumisikidza, sezvakatsanangurwa mugwaro reMicrosoft "Kurumidza Kutanga: Kuisa SQL Server uye Kugadzira Dhatabhesi muRed Hat" kubva padanho #3:

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

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

Mushure mekunge kuisirwa kwapera, unogona kutarisa vhezheni yeiyo yakaiswa SQL server uchishandisa murairo:

# yum list —installed | grep mssql-server

Inotsigira midziyo

Nekuburitswa kweSQL Server 2019, kuisirwa kunovimbisa kuve nyore sezvo iyi vhezheni inotarisirwa kuwanikwa paRHEL semudziyo. SQL Server 2019 yave kuwanikwa mubeta. Kuti uiedze muRHEL 8 Beta, unongoda matanho matatu chete:

Kutanga, ngatigadzire dhairekitori redhatabhesi uko data redu rese reSQL richachengetwa. Kune uyu muenzaniso tichashandisa iyo /var/mssql dhairekitori.

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

Zvino iwe unofanirwa kudhawunirodha mudziyo neSQL 2019 Beta kubva kuMicrosoft Container Repository nemurairo:

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

Pakupedzisira, iwe unofanirwa kugadzirisa iyo SQL server. Mune ino kesi, isu tichaisa maneja (SA) password yedatabase inonzi sql1 inomhanya pachiteshi 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

Rumwe ruzivo nezve podman uye midziyo muRed Hat Enterprise Linux 8 Beta inogona kuwanikwa pano.

Inoshanda kune vaviri

Unogona kuedza musanganiswa weRHEL 8 Beta neSQL Server 2017 ungave uchishandisa chinyakare kuisirwa kana nekuisa mudziyo application. Chero nzira, iwe ikozvino une inomhanya muenzaniso yeSQL Server yaunayo, uye unogona kutanga kuzadza dhatabhesi yako kana kuongorora maturusi anowanikwa muRHEL 8 Beta kugadzira stack yeapp, otomatiki maitiro ekugadzirisa, kana kukwidziridza mashandiro.

Mukutanga kwaChivabvu, ita chokwadi chekuteerera kuna Bob Ward, mugadziri mukuru muMicrosoft Database Systems Group, taura pamusangano. Red Hat Musangano 2019, kwatichakurukura kuendesa chikuva chemazuva ano data chakavakirwa paSQL Server 2019 uye Red Hat Enterprise Linux 8 Beta.

Uye muna Chivabvu 8, kuburitswa kwepamutemo kunotarisirwa, kuvhura kushandiswa kweSQL Server mumashandisirwo chaiwo.

Source: www.habr.com