Microsoft SQL Server 2017 yakhala ikupezeka kuti igwiritsidwe ntchito mokwanira pa RHEL 7 kuyambira Okutobala 2017, ndipo ndi RHEL 8 Beta, Red Hat inagwira ntchito limodzi ndi Microsoft kuti ipititse patsogolo magwiridwe antchito ndikupereka chithandizo cha zilankhulo zambiri zamapulogalamu ndi machitidwe ogwiritsira ntchito, ndikupatsa otukula mwayi wosankha. zida zogwirira ntchito pazotsatira zawo.
Njira yabwino yomvetsetsa zosintha ndi momwe zimakhudzira ntchito yanu ndikuyesa, koma RHEL 8 ikadali mu beta ndipo Microsoft SQL Server 2017 siyimathandizidwa kuti igwiritsidwe ntchito pamapulogalamu amoyo. Zoyenera kuchita?
Ngati mukufuna kuyesa SQL Server pa RHEL 8 Beta, positiyi ikuthandizani kuti muyigwiritse ntchito, koma simuyenera kuigwiritsa ntchito pamalo opanga mpaka Red Hat Enterprise Linux 8 ipezeka ndipo Microsoft ipanga phukusi lake lovomerezeka. kupezeka kwa makhazikitsidwe.
Chimodzi mwazolinga zazikulu za Red Hat Enterprise Linux ndikupanga khola, . Kuti akwaniritse izi, RHEL imagwiritsa ntchito kugwirizanitsa ntchito pamlingo wa ma API ndi ma kernel interfaces. Tikasamukira ku kumasulidwa kwakukulu kwatsopano, nthawi zambiri pamakhala kusiyana kwapadera kwa mayina a phukusi, mabuku atsopano a malaibulale ndi zida zatsopano zomwe zingayambitse mavuto poyendetsa mapulogalamu omwe alipo omwe adapangidwira kumasulidwa koyambirira. Otsatsa mapulogalamu amatha kutsata malangizo a Red Hat kuti apange zoyeserera mu Red Hat Enterprise Linux 7 zomwe ziziyenda mu Red Hat Enterprise Linux 8, koma kugwira ntchito ndi phukusi ndi nkhani ina. Pulogalamu yamapulogalamu yopangidwira Red Hat Enterprise Linux 7 sidzathandizidwa pa Red Hat Enterprise Linux 8.
SQL Server 2017 pa Red Hat Enterprise Linux 7 imagwiritsa ntchito python2 ndi OpenSSL 1.0. Masitepe otsatirawa apereka malo ogwirira ntchito omwe amagwirizana ndi zigawo ziwirizi, zomwe zasamutsidwa kale kumitundu yaposachedwa kwambiri mu RHEL 8 Beta. Kuphatikizika kwa matembenuzidwe akale kunachitika ndi Red Hat makamaka kuti asunge kuyanjana kwam'mbuyo.
sudo yum install python2
sudo yum install compat-openssl10
Tsopano tiyenera kumvetsetsa zoyambira za python padongosolo lino. , koma palibe /usr/bin/python padongosolo mwachisawawa. Tiyenera kupanga python2 womasulira wosasintha kotero kuti SQL Server 2017 ikhoza kuwona /usr/bin/python komwe ikuyembekeza kuziwona. Kuti muchite izi muyenera kuyendetsa lamulo ili:
sudo alternatives βconfig python
Mudzafunsidwa kuti musankhe mtundu wanu wa Python, pambuyo pake ulalo wophiphiritsa udzapangidwa womwe udzapitirire dongosolo likasinthidwa.
Pali mitundu itatu yosiyanasiyana yogwiritsira ntchito 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:
Apa muyenera kusankha njira yachiwiri, pambuyo pake ulalo wophiphiritsa udzapangidwa kuchokera /usr/bin/python2 kupita ku /usr/bin/python.
Tsopano mutha kupitiliza kukonza dongosolo kuti ligwire ntchito ndi Microsoft SQL Server 2017 pulogalamu yosungira pogwiritsa ntchito curl lamulo:
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
Kenako, muyenera kutsitsa mafayilo oyika a SQL Server 2017 pogwiritsa ntchito pulogalamu yatsopano yotsitsa mu yum. Muyenera kuchita izi m'njira yoti mutha kukhazikitsa popanda kuthana ndi kudalira:
sudo yum download mssql-server
Tsopano tiyeni tiyike seva popanda kuthetsa zodalira pogwiritsa ntchito lamulo la rpm:
sudo rpm -Uvh βnodeps mssql-server*rpm
Zitatha izi, mutha kupitiliza kukhazikitsa kwa SQL Server, monga tafotokozera mu kalozera wa Microsoft "Yambani Mwamsanga: Kuyika SQL Server ndi Kupanga Database mu Red Hat" kuchokera pagawo #3:
3. ΠΠΎΡΠ»Π΅ Π·Π°Π²Π΅ΡΡΠ΅Π½ΠΈΡ ΡΡΡΠ°Π½ΠΎΠ²ΠΊΠΈ ΠΏΠ°ΠΊΠ΅ΡΠ° Π²ΡΠΏΠΎΠ»Π½ΠΈΡΠ΅ ΠΊΠΎΠΌΠ°Π½Π΄Ρ mssql-conf setup ΠΈ ΡΠ»Π΅Π΄ΡΠΉΡΠ΅ ΠΏΠΎΠ΄ΡΠΊΠ°Π·ΠΊΠ°ΠΌ Π΄Π»Ρ ΡΡΡΠ°Π½ΠΎΠ²ΠΊΠΈ ΠΏΠ°ΡΠΎΠ»Ρ ΡΠΈΡΡΠ΅ΠΌΠ½ΠΎΠ³ΠΎ Π°Π΄ΠΌΠΈΠ½ΠΈΡΡΡΠ°ΡΠΎΡΠ° (SA) ΠΈ Π²ΡΠ±ΠΎΡΠ° Π²Π°ΡΠ΅ΠΉ Π²Π΅ΡΡΠΈΠΈ.
sudo /opt/mssql/bin/mssql-conf setup
Kuyikako kukatha, mutha kuyang'ana mtundu wa seva ya SQL yoyikidwa pogwiritsa ntchito lamulo:
# yum list βinstalled | grep mssql-server
Imathandizira zotengera
Ndi kutulutsidwa kwa SQL Server 2019, kukhazikitsa kumalonjeza kukhala kosavuta popeza mtunduwu ukuyembekezeka kupezeka pa RHEL ngati chidebe. SQL Server 2019 tsopano ikupezeka mu beta. Kuti muyese mu RHEL 8 Beta, mumangofunika njira zitatu:
Choyamba, tiyeni tipange bukhu la database komwe deta yathu yonse ya SQL idzasungidwa. Kwa chitsanzo ichi tidzagwiritsa ntchito /var/mssql chikwatu.
sudo mkdir /var/mssql
sudo chmod 755 /var/mssql
Tsopano muyenera kutsitsa chidebecho ndi SQL 2019 Beta kuchokera ku Microsoft Container Repository ndi lamulo:
sudo podman pull mcr.microsoft.com/mssql/rhel/server:2019-CTP2.2
Pomaliza, muyenera kukonza seva ya SQL. Pankhaniyi, tidzakhazikitsa mawu achinsinsi a administrator (SA) pa database yotchedwa sql1 yomwe ikuyenda pamadoko 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
Zambiri za podman ndi zotengera mu Red Hat Enterprise Linux 8 Beta zitha kupezeka Pano.
Imagwira ntchito ziwiri
Mutha kuyesa kuphatikiza kwa RHEL 8 Beta ndi SQL Server 2017 pogwiritsa ntchito kuyika kwachikhalidwe kapena kukhazikitsa pulogalamu yachidebe. Mulimonse momwe zingakhalire, tsopano muli ndi SQL Server yomwe muli nayo, ndipo mutha kuyamba kudzaza nkhokwe yanu kapena kufufuza zida zomwe zilipo mu RHEL 8 Beta kuti mupange stack yofunsira, kusintha makonzedwe, kapena kukhathamiritsa magwiridwe antchito.
Kumayambiriro kwa mwezi wa May, onetsetsani kuti mukumvetsera Bob Ward, katswiri wa zomangamanga mu Microsoft Database Systems Group, akulankhula pamsonkhanowu. , pomwe tikambirana za kuyika nsanja yamakono yotengera SQL Server 2019 ndi Red Hat Enterprise Linux 8 Beta.
Ndipo pa Meyi 8, kutulutsidwa kovomerezeka kumayembekezeredwa, kutsegulira kugwiritsa ntchito SQL Server muzogwiritsa ntchito zenizeni.
Source: www.habr.com