Microsoft SQL Server 2017 esale e fumaneha bakeng sa tšebeliso e felletseng ho RHEL 7 ho tloha ka Mphalane 2017, mme ka RHEL 8 Beta, Red Hat e sebelitse haufi-ufi le Microsoft ho ntlafatsa ts'ebetso le ho fana ka ts'ehetso bakeng sa lipuo tse ling tsa mananeo le meralo ea ts'ebeliso, e fang bahlahisi khetho e eketsehileng e fumanehang. lisebelisoa ho sebetsa ts'ebelisong ea bona e latelang.
Mokhoa o motle oa ho utloisisa liphetoho le hore na li ama mosebetsi oa hau joang ke ho li leka, empa RHEL 8 e ntse e le ho beta mme Microsoft SQL Server 2017 ha e tšehetsoe ho sebelisoa lits'ebetsong tse phelang. Se o lokelang ho se etsa?
Haeba u batla ho leka SQL Server ho RHEL 8 Beta, poso ena e tla u thusa ho e qala le ho sebetsa, empa ha ua lokela ho e sebelisa sebakeng sa tlhahiso ho fihlela Red Hat Enterprise Linux 8 e fumaneha ka kakaretso mme Microsoft e etsa sephutheloana sa eona se tšehetsoeng ka molao. e fumanehang bakeng sa ho kenya.
E 'ngoe ea lipheo tsa mantlha tsa Red Hat Enterprise Linux ke ho theha setsi se tsitsitseng, . Ho finyella sena, RHEL e sebelisa ho lumellana ha kopo boemong ba li-API tsa motho ka mong le li-interfaces tsa kernel. Ha re fallela tokollong e ncha e kholo, hangata ho na le liphapang tse ikhethang mabitsong a liphutheloana, mefuta e mecha ea lilaebrari le lits'ebeletso tse ncha tse ka bakang mathata a ho tsamaisa lits'ebetso tse teng tse hahiloeng bakeng sa tokollo e fetileng. Barekisi ba software ba ka latela litataiso tsa Red Hat ho theha lisebelisoa ho Red Hat Enterprise Linux 7 e tla sebetsa ho Red Hat Enterprise Linux 8, empa ho sebetsa ka liphutheloana ke taba e fapaneng. Sephutheloana sa software se etselitsoeng Red Hat Enterprise Linux 7 se ke ke sa tšehetsoa ho Red Hat Enterprise Linux 8.
SQL Server 2017 ho Red Hat Enterprise Linux 7 e sebelisa python2 le OpenSSL 1.0. Mehato e latelang e tla fana ka tikoloho ea ho sebetsa e lumellanang le likarolo tsena tse peli, tse seng li fetiselitsoe liphetolelong tsa morao-rao ho RHEL 8 Beta. Ho kenyelletsoa ha liphetolelo tsa khale ho entsoe ke Red Hat ka ho khetheha ho boloka ho lumellana ha morao.
sudo yum install python2
sudo yum install compat-openssl10
Hona joale re hloka ho utloisisa litlhophiso tsa pele tsa python tsamaisong ena. , empa ha ho na /usr/bin/python ho sistimi ka boiketsetso. Re hloka ho etsa python2 mofetoleli oa kamehla e le hore SQL Server 2017 e bone /usr/bin/python moo e lebeletseng ho e bona. Ho etsa sena o hloka ho tsamaisa taelo e latelang:
sudo alternatives —config python
U tla susumelletseha hore u khethe mofuta oa hau oa Python, ka mor'a moo ho tla thehoa sehokelo sa tšoantšetso se tla tsoela pele ka mor'a hore tsamaiso e ntlafatsoe.
Ho na le li-executable tse tharo tse fapaneng tsa ho sebetsa 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:
Mona o hloka ho khetha khetho ea bobeli, ka mor'a moo sehokelo sa tšoantšetso se tla etsoa ho tloha /usr/bin/python2 ho ea /usr/bin/python.
Joale o ka tsoela pele ho hlophisa sistimi hore e sebetse le polokelo ea software ea Microsoft SQL Server 2017 u sebelisa taelo ea curl:
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
E latelang, o lokela ho khoasolla lifaele tsa ho kenya SQL Server 2017 u sebelisa sesebelisoa se secha sa ho jarolla ho yum. U hloka ho etsa sena ka tsela eo u ka e kenyang ntle le ho rarolla litšepe:
sudo yum download mssql-server
Joale ha re kenyeng seva ntle le ho rarolla litšepe re sebelisa taelo ea rpm:
sudo rpm -Uvh —nodeps mssql-server*rpm
Ka mor'a sena, u ka tsoela pele ka ho kenya SQL Server e tloaelehileng, joalokaha ho hlalositsoe ho tataiso ea Microsoft "Qalo e potlakileng: Ho kenya SQL Server le ho theha Database ho Red Hat" ho tloha mohato oa #3:
3. После завершения установки пакета выполните команду mssql-conf setup и следуйте подсказкам для установки пароля системного администратора (SA) и выбора вашей версии.
sudo /opt/mssql/bin/mssql-conf setup
Kamora hore ts'ebetso e phethe, o ka sheba mofuta oa seva e kentsoeng ea SQL o sebelisa taelo:
# yum list —installed | grep mssql-server
E tšehetsa lijana
Ka tokollo ea SQL Server 2019, ho kenya ho ts'episa ho ba bonolo le ho feta kaha mofuta ona o lebelletsoe ho ba teng ho RHEL joalo ka setshelo. SQL Server 2019 e se e fumaneha ho beta. Ho e leka ho RHEL 8 Beta, o hloka mehato e meraro feela:
Taba ea pele, ha re theheng lethathamo la database moo data ea rona eohle ea SQL e tla bolokoa. Bakeng sa mohlala ona re tla sebelisa /var/mssql directory.
sudo mkdir /var/mssql
sudo chmod 755 /var/mssql
Joale o hloka ho khoasolla setshelo ka SQL 2019 Beta ho tsoa ho Microsoft Container Repository ka taelo:
sudo podman pull mcr.microsoft.com/mssql/rhel/server:2019-CTP2.2
Qetellong, o hloka ho lokisa seva sa SQL. Tabeng ena, re tla beha password ea administrator (SA) bakeng sa database e bitsoang sql1 e sebetsang likoung tsa 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
Lintlha tse ling mabapi le podman le lijana ho Red Hat Enterprise Linux 8 Beta li ka fumanoa Mona.
E sebetsa ho tse peli
U ka leka motsoako oa RHEL 8 Beta le SQL Server 2017 ka ho sebelisa ts'ebetso ea setso kapa ka ho kenya sesebelisoa sa setshelo. Ka tsela efe kapa efe, joale u na le mohlala o sebetsang oa SQL Server eo u nang le eona, 'me u ka qala ho tlatsa database ea hau kapa ua hlahloba lisebelisoa tse fumanehang ho RHEL 8 Beta ho theha stack ea kopo, ho iketsetsa ts'ebetso ea tlhophiso, kapa ho ntlafatsa ts'ebetso.
Mathoasong a Mots'eanong, etsa bonnete ba hore u mamela Bob Ward, setsebi se seholo sa meralo ea Microsoft Database Systems Group, a bua sebokeng. , moo re tla tšohla ka ho tsamaisa sethala sa data sa sejoale-joale se thehiloeng ho SQL Server 2019 le Red Hat Enterprise Linux 8 Beta.
Mme ka la 8 Mots'eanong, ho lebelletsoe tokollo ea semmuso, e bulang ts'ebeliso ea SQL Server lits'ebetsong tsa nnete.
Source: www.habr.com