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, positi iyi ikuthandizani kuyiyambitsa, koma simuyenera kuigwiritsa ntchito pamalo opangira mpaka Red Hat Enterprise version itatha. Linux 8 sidzapezeka pagulu, ndipo Microsoft sidzapereka phukusi lovomerezeka lokhazikitsa.
Chimodzi mwa zolinga zazikulu za Red Hat Enterprise Linux ndi kupanga khola, Kuti izi zitheke, RHEL imagwiritsa ntchito kuyanjana kwa mapulogalamu pamlingo wa ma API ndi ma kernel interfaces. Tikapita ku kutulutsidwa kwatsopano kwakukulu, nthawi zambiri pamakhala kusiyana kwapadera m'maina a phukusi, mitundu yatsopano ya laibulale, ndi mautumiki atsopano omwe angayambitse zovuta kuyendetsa mapulogalamu omwe alipo kale omwe adamangidwa kale. Ogulitsa mapulogalamu amatha kutsatira malangizo a Red Hat kuti apange ma executable a Red Hat Enterprise. Linux 7 yomwe idzagwira ntchito mu Red Hat Enterprise Linux 8, koma kugwira ntchito ndi ma phukusi ndi nkhani yosiyana. Phukusi la mapulogalamu lopangidwira Red Hat Enterprise Linux 7 sidzathandizidwa mu Red Hat Enterprise Linux 8.
SQL Server 2017 pa Red Hat Enterprise Linux 7 imagwiritsa ntchito Python 2 ndi OpenSSL 1.0. Njira zotsatirazi zipanga malo ogwirira ntchito ogwirizana ndi zigawo ziwirizi, zomwe zasamutsidwira kale ku mitundu yaposachedwa mu RHEL 8 Beta. Red Hat mwadala idaphatikiza mitundu yakale kuti isunge kugwirizana kwa kumbuyo.
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
Dziwani zambiri za podman ndi zotengera mu Red Hat Enterprise Linux 8 Beta ikupezeka apa.
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. , komwe tidzakambirana za kukhazikitsidwa kwa nsanja yamakono ya data yochokera ku 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
