I-ProHoster > Π‘Π»ΠΎΠ³ > Ukuphatha > I-RHEL 8 Beta Workshop: Ukufaka i-Microsoft SQL Server

I-RHEL 8 Beta Workshop: Ukufaka i-Microsoft SQL Server

I-Microsoft SQL Server 2017 ibitholakala ukuthi isetshenziswe ngokugcwele ku-RHEL 7 kusukela ngo-Okthoba 2017, futhi nge-RHEL 8 Beta, i-Red Hat yasebenza eduze ne-Microsoft ukuze kuthuthukiswe ukusebenza futhi inikeze ukusekelwa kwezinye izilimi zokuhlela nezinhlaka zohlelo, inikeze abathuthukisi ukukhetha okwengeziwe okutholakalayo. amathuluzi okusebenza ohlelweni lwawo olulandelayo.

I-RHEL 8 Beta Workshop: Ukufaka i-Microsoft SQL Server

Indlela engcono kakhulu yokuqonda izinguquko nendlela eziwuthinta ngayo umsebenzi wakho iwukuzizama, kodwa i-RHEL 8 isekwi-beta futhi i-Microsoft SQL Server 2017 ayisekelwe ukuze isetshenziswe ezinhlelweni ezibukhoma. Okufanele ngikwenze?

Uma ufuna ukuzama i-SQL Server ku-RHEL 8 Beta, lokhu okuthunyelwe kuzokusiza ukuthi uyivule futhi isebenze, kodwa akufanele uyisebenzise endaweni yokukhiqiza kuze kube yilapho iRed Hat Enterprise Linux 8 isitholakala ngokuvamile futhi iMicrosoft yenza iphakheji yayo esekelwe ngokusemthethweni. itholakalela ukufakwa.

Enye yezinhloso eziphambili zeRed Hat Enterprise Linux ukwakha isitebele, imvelo efanayo yokusebenzisa izinhlelo zokusebenza zezinkampani zangaphandle. Ukuze kuzuzwe lokhu, i-RHEL isebenzisa ukuhambisana kohlelo lokusebenza ezingeni lama-API angawodwana kanye nezixhumi ezibonakalayo ze-kernel. Uma sithuthela ekukhishweni okusha okukhulu, kuvame ukuba khona umehluko okhethekile kumagama amaphakheji, izinguqulo ezintsha zamalabhulali nezinsiza ezintsha ezingabangela ubunzima ekusebenziseni izinhlelo zokusebenza ezikhona ezakhelwe ukukhishwa kwangaphambilini. Abathengisi be-software bangalandela imihlahlandlela ye-Red Hat ukuze benze okusebenzisekayo ku-Red Hat Enterprise Linux 7 okuzosebenza ku-Red Hat Enterprise Linux 8, kodwa ukusebenza namaphakheji kuwudaba oluhlukile. Iphakheji lesofthiwe elidalelwe i-Red Hat Enterprise Linux 7 ngeke lisekelwe ku-Red Hat Enterprise Linux 8.

I-SQL Server 2017 ku-Red Hat Enterprise Linux 7 isebenzisa i-python2 ne-OpenSSL 1.0. Izinyathelo ezilandelayo zizohlinzeka ngendawo yokusebenza ehambisana nalezi zingxenye ezimbili, esezivele zithuthelwe ezinguqulweni zakamuva ku-RHEL 8 Beta. Ukufakwa kwezinguqulo ezindala kwenziwa i-Red Hat ngokukhethekile ukuze kugcinwe ukuhambisana okubuyela emuva. 

sudo  yum install python2
sudo  yum install compat-openssl10

Manje sidinga ukuqonda izilungiselelo zokuqala ze-python kulolu hlelo. I-Red Hat Enterprise Linux 8 ingasebenzisa i-python2 ne-python3 ngesikhathi esisodwa, kodwa akukho /usr/bin/python ohlelweni ngokuzenzakalelayo. Sidinga ukwenza i-python2 umhumushi ozenzakalelayo ukuze i-SQL Server 2017 ibone /usr/bin/python lapho ilindele ukuyibona khona. Ukuze wenze lokhu udinga ukusebenzisa umyalo olandelayo:

sudo alternatives β€”config python

Uzocelwa ukuthi ukhethe inguqulo yakho yePython, ngemuva kwalokho kuzokwakhiwa isixhumanisi esingokomfanekiso esizoqhubeka ngemuva kokubuyekezwa kwesistimu.

Kunezindlela ezintathu ezihlukene zokusebenzisa i-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:

Lapha udinga ukukhetha inketho yesibili, ngemuva kwalokho kuzokwakhiwa isixhumanisi esingokomfanekiso kusuka /usr/bin/python2 kuya ku/usr/bin/python.

Manje ungaqhubeka nokumisa uhlelo ukuze lusebenze nekhosombe lesofthiwe ye-Microsoft SQL Server 2017 usebenzisa umyalo we-curl: 

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

Okulandelayo, kufanele ulande amafayela wokufaka we-SQL Server 2017 usebenzisa isici esisha sokulanda ku-yum. Udinga ukwenza lokhu ngendlela yokuthi ukwazi ukufaka ngaphandle kokuxazulula ukuncika: 

sudo yum download mssql-server

Manje ake sifake iseva ngaphandle kokuxazulula ukuncika sisebenzisa umyalo we-rpm:

sudo rpm -Uvh β€”nodeps mssql-server*rpm

Ngemva kwalokhu, ungaqhubeka nokufakwa okuvamile kwe-SQL Server, njengoba kuchazwe kumhlahlandlela we-Microsoft "Ukuqala Ngokushesha: Ukufaka Iseva ye-SQL kanye Nokwakha Ukugcinwa Kwedatha Ngesigqoko Esibomvu" kusukela kusinyathelo #3:

3. ПослС Π·Π°Π²Π΅Ρ€ΡˆΠ΅Π½ΠΈΡ установки ΠΏΠ°ΠΊΠ΅Ρ‚Π° Π²Ρ‹ΠΏΠΎΠ»Π½ΠΈΡ‚Π΅ ΠΊΠΎΠΌΠ°Π½Π΄Ρƒ mssql-conf setup ΠΈ слСдуйтС подсказкам для установки пароля систСмного администратора (SA) ΠΈ Π²Ρ‹Π±ΠΎΡ€Π° вашСй вСрсии.

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

Ngemuva kokuthi ukufakwa sekuqediwe, ungabheka inguqulo yeseva ye-SQL efakiwe usebenzisa umyalo:

# yum list β€”installed | grep mssql-server

Isekela iziqukathi

Ngokukhishwa kwe-SQL Server 2019, ukufakwa kuthembisa ukuthi kuzoba lula nakakhulu njengoba le nguqulo kulindeleke ukuthi itholakale ku-RHEL njengesiqukathi. I-SQL Server 2019 isiyatholakala ku-beta. Ukuze uyizame ku-RHEL 8 Beta, udinga izinyathelo ezintathu kuphela:

Okokuqala, ake sakhe uhla lwemibhalo lapho yonke idatha yethu ye-SQL izogcinwa khona. Kulesi sibonelo sizosebenzisa umkhombandlela /var/mssql.

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

Manje udinga ukulanda isiqukathi esine-SQL 2019 Beta ku-Microsoft Container Repository ngomyalo:

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

Ekugcineni, udinga ukumisa iseva ye-SQL. Kulokhu, sizosetha iphasiwedi yomlawuli (SA) yedathabhesi ebizwa ngokuthi sql1 esebenza kumachweba 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

Ulwazi olwengeziwe mayelana ne-podman neziqukathi ku-Red Hat Enterprise Linux 8 Beta ingatholakala lapha.

Isebenza kokubili

Ungazama inhlanganisela ye-RHEL 8 Beta ne-SQL Server 2017 ngokusebenzisa ukufakwa okujwayelekile noma ngokufaka uhlelo lwesiqukathi. Kunoma ikuphi, manje usunesibonelo esisebenzayo se-SQL Server onawo, futhi ungaqala ngokugcwalisa idatha yakho egciniwe noma uhlole amathuluzi atholakala ku-RHEL 8 Beta ukuze udale isitaki sohlelo lokusebenza, wenze inqubo yokumisa ngokuzenzakalelayo, noma uthuthukise ukusebenza kahle.

Ekuqaleni kukaMeyi, qiniseka ukuthi ulalela uBob Ward, umakhi omkhulu weMicrosoft Database Systems Group, ekhuluma engqungqutheleni. Ingqungquthela yeRed Hat 2019, lapho sizoxoxa khona ngokukhipha inkundla yedatha yesimanje esekelwe ku-SQL Server 2019 kanye ne-Red Hat Enterprise Linux 8 Beta.

Futhi ngoMeyi 8, kulindeleke ukukhululwa okusemthethweni, okuvula ukusetshenziswa kwe-SQL Server ezinhlelweni zokusebenza zangempela.

Source: www.habr.com

Engeza amazwana