Microsoft SQL Server 2017 wuxuu diyaar u ahaa isticmaalka buuxa ee RHEL 7 ilaa Oktoobar 2017, iyo RHEL 8 Beta, Koofiyada Cas wuxuu si dhow ula shaqeeyay Microsoft si loo hagaajiyo waxqabadka iyo bixinta taageerada luqadaha barnaamijyada iyo qaababka codsiyada, oo siinaya horumariyeyaasha doorashooyin badan oo la heli karo qalab ay ku shaqeeyaan codsigooda soo socda.
Habka ugu fiican ee lagu fahmi karo isbeddelada iyo sida ay u saameeyaan shaqadaada waa in la tijaabiyo, laakiin RHEL 8 ayaa weli ku jira beta iyo Microsoft SQL Server 2017 looma taageero isticmaalka codsiyada tooska ah. Maxaa la sameeyaa?
Haddii aad rabto inaad tijaabiso SQL Server ee RHEL 8 Beta, boostadani waxay kaa caawin doontaa inaad kor u qaaddo oo aad socodsiiso, laakiin waa inaadan ku isticmaalin jawi wax soo saar ilaa Red Hat Enterprise Linux 8 ay noqoto mid guud ahaan diyaar ah oo Microsoft ay sameyso xirmo si rasmi ah loo taageeray. diyaar u ah rakibaadda
Mid ka mid ah yoolalka ugu waaweyn ee koofiyadda Cas ee Linux waa in la abuuro xasilloon, . Si taas loo gaaro, RHEL waxay fulisaa iswaafajinta arjiga heerka API-yada shaqsiga ah iyo is-dhexgalka kernel-ka. Markaan u guurno siideyn weyn oo cusub, inta badan waxaa jira kala duwanaansho gaar ah oo ku saabsan magacyada xirmooyinka, noocyada cusub ee maktabadaha iyo adeegyada cusub ee keeni kara dhibaatooyin xagga socodsiinta codsiyada jira ee loo dhisay sii deynta hore. Iibiyeyaasha softiweerku waxay raaci karaan tilmaamaha Koofiyada Cas si ay u abuuraan kuwa fulin kara koofiyadda Cas ee Linux 7 oo ku shaqayn doonta koofiyadda Cas Linux 8, laakiin la shaqaynta baakadaha waa arrin ka duwan. Xidhmada software ee loo sameeyay koofiyadda cas ee Linux 7 laguma taageeri doono koofiyadda cas Linux 8.
SQL Server 2017 ee koofiyadda Cas ee Linux 7 waxay isticmaashaa python2 iyo OpenSSL 1.0. Tallaabooyinka soo socdaa waxay bixin doonaan jawi shaqo oo ku habboon labadan qaybood, kuwaas oo mar hore loo haajiray noocyadii u dambeeyay ee RHEL 8 Beta. Ku darida noocyadii hore waxaa sameeyay Koofiyada Cas si gaar ah si loo ilaaliyo is waafajinta gadaal.
sudo yum install python2
sudo yum install compat-openssl10
Hadda waxaan u baahanahay inaan fahamno goobaha Python ee ugu horreeya ee nidaamkan. , laakiin ma jiro /usr/bin/python ee nidaamka si caadi ah. Waxaan u baahanahay inaan ka dhigno python2 turjumaanka caadiga ah si SQL Server 2017 uu u arko /usr/bin/python halka uu filayo inuu ku arko. Si aad tan u samayso waxaad u baahan tahay inaad socodsiiso amarka soo socda:
sudo alternatives βconfig python
Waxaa laguu sheegi doonaa inaad doorato nooca Python kaaga, ka dib waxaa la abuuri doonaa iskuxir calaamad ah oo sii jiri doona ka dib marka nidaamka la cusbooneysiiyo.
Waxaa jira saddex fulin oo kala duwan oo lagula shaqeynayo 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:
Halkan waxaad u baahan tahay inaad doorato ikhtiyaarka labaad, ka dib markaa xiriirka calaamad ayaa laga abuuri doonaa /usr/bin/python2 ilaa /usr/bin/python.
Hadda waxaad sii wadi kartaa habaynta nidaamka si aad ula shaqeyso Microsoft SQL Server 2017 kaydinta software adoo isticmaalaya amarka curl:
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
Marka xigta, waa inaad soo dejiso faylasha rakibaadda SQL Server 2017 adoo isticmaalaya muuqaalka cusub ee soo dejinta ee yum. Waxaad u baahan tahay inaad tan u sameyso qaab aad ku rakibi karto adigoon xallin ku tiirsanaanta:
sudo yum download mssql-server
Hadda aan rakibno server-ka annaga oo aan xallinin ku-tiirsanaanta annaga oo adeegsanayna amarka rpm:
sudo rpm -Uvh βnodeps mssql-server*rpm
Taas ka dib, waxaad sii wadi kartaa rakibaadda caadiga ah ee SQL Server, sida lagu qeexay hagaha Microsoft "Bilow Degdeg ah: Ku rakibida SQL Server iyo Abuuritaanka Database ee Koofiyada Cas" laga bilaabo tilaabada #3:
3. ΠΠΎΡΠ»Π΅ Π·Π°Π²Π΅ΡΡΠ΅Π½ΠΈΡ ΡΡΡΠ°Π½ΠΎΠ²ΠΊΠΈ ΠΏΠ°ΠΊΠ΅ΡΠ° Π²ΡΠΏΠΎΠ»Π½ΠΈΡΠ΅ ΠΊΠΎΠΌΠ°Π½Π΄Ρ mssql-conf setup ΠΈ ΡΠ»Π΅Π΄ΡΠΉΡΠ΅ ΠΏΠΎΠ΄ΡΠΊΠ°Π·ΠΊΠ°ΠΌ Π΄Π»Ρ ΡΡΡΠ°Π½ΠΎΠ²ΠΊΠΈ ΠΏΠ°ΡΠΎΠ»Ρ ΡΠΈΡΡΠ΅ΠΌΠ½ΠΎΠ³ΠΎ Π°Π΄ΠΌΠΈΠ½ΠΈΡΡΡΠ°ΡΠΎΡΠ° (SA) ΠΈ Π²ΡΠ±ΠΎΡΠ° Π²Π°ΡΠ΅ΠΉ Π²Π΅ΡΡΠΈΠΈ.
sudo /opt/mssql/bin/mssql-conf setup
Ka dib markii rakibidda la dhammeeyo, waxaad hubin kartaa nooca server-ka SQL ee rakibay adoo isticmaalaya amarka:
# yum list βinstalled | grep mssql-server
Waxay taageertaa weelasha
Marka la sii daayo SQL Server 2019, rakibiddu waxay ballanqaadaysaa inay sii fududaan doonto maadaama noocaan la filayo inuu ku jiro RHEL sidii weel ahaan. SQL Server 2019 hadda waa laga heli karaa beta. Si aad ugu tijaabiso RHEL 8 Beta, waxaad u baahan tahay kaliya saddex tillaabo:
Marka hore, aynu abuurno hagaha kaydka macluumaadka halkaas oo dhammaan xogtayada SQL lagu kaydin doono. Tusaalahan waxaan isticmaali doonaa /var/mssql directory.
sudo mkdir /var/mssql
sudo chmod 755 /var/mssql
Hadda waxaad u baahan tahay inaad kala soo baxdo weelka SQL 2019 Beta ee kaydka weelka Microsoft oo leh amarka:
sudo podman pull mcr.microsoft.com/mssql/rhel/server:2019-CTP2.2
Ugu dambeyntii, waxaad u baahan tahay inaad dejiso server-ka SQL. Xaaladdan oo kale, waxaan dejin doonaa maamulaha (SA) erayga sirta ah ee kaydinta xogta ee loo yaqaan sql1 oo ku socota dekedaha 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
Macluumaad dheeraad ah oo ku saabsan podman iyo weelasha ku jira Koofiyada Cas ee Linux 8 Beta ayaa laga heli karaa halkan.
Waxay u shaqeysaa laba
Waxaad isku dayi kartaa isku darka RHEL 8 Beta iyo SQL Server 2017 adiga oo isticmaalaya qalab dhaqameed ama adigoo ku rakibaya codsi weel. Si kastaba ha noqotee, hadda waxaad haysataa tusaale ordaya oo ah SQL Server oo aad gacanta ku hayso, waxaadna bilaabi kartaa inaad ku shubto xogtaada ama waxaad sahamin kartaa aaladaha laga heli karo RHEL 8 Beta si aad u abuurto xirmo arji, otomaatig ah habka qaabaynta, ama kor u qaad waxqabadka.
Horraanta May, hubi inaad dhegaysato Bob Ward, naqshadeeyaha sare ee Kooxda Nidaamyada Xogta ee Microsoft, oo ka hadlaya shirwaynaha , halkaas oo aan ka wada hadli doono geynta xogta casriga ah ee ku salaysan SQL Server 2019 iyo Red Hat Enterprise Linux 8 Beta.
Iyo May 8, siidaynta rasmiga ah ayaa la filayaa, furitaanka isticmaalka SQL Server ee codsiyada dhabta ah.
Source: www.habr.com