Ndibhala kakhulu malunga nokufunyanwa kwedatha efikeleleke ngokukhululekileyo phantse kuwo onke amazwe ehlabathi, kodwa akukho phantse iindaba malunga nokugcinwa kwedatha yaseRashiya eshiywe kwindawo yoluntu. Nangona kutshanje malunga "nesandla se-Kremlin," apho umphandi waseDatshi wayesoyika ukuyifumana ngaphezu kwe-2000 yedatha evulekileyo.
Kunokubakho ukungaqondi kakuhle ukuba yonke into ilungile eRashiya kwaye abanini beeprojekthi ezinkulu zaseRashiya ze-intanethi bathatha indlela enoxanduva lokugcina idatha yomsebenzisi. Ndikhawuleza ukuyichaza le ntsomi ndisebenzisa lo mzekelo.
Inkonzo yezonyango yaseRashiya kwi-intanethi ye-DOC + ngokucacileyo ikwazile ukushiya i-ClickHouse database kunye neendawo zokungena ezifumaneka esidlangalaleni. Ngelishwa, iilog zijongeka zineenkcukacha kangangokuba idatha yobuqu yabasebenzi, amaqabane kunye nabathengi benkonzo ibinokuvuza.
Izinto zokuqala kuqala ...
ΠΠΈΡΠΊΠ»Π΅ΠΉΠΌΠ΅Ρ: Π²ΡΡ ΠΈΠ½ΡΠΎΡΠΌΠ°ΡΠΈΡ Π½ΠΈΠΆΠ΅ ΠΏΡΠ±Π»ΠΈΠΊΡΠ΅ΡΡΡ ΠΈΡΠΊΠ»ΡΡΠΈΡΠ΅Π»ΡΠ½ΠΎ Π² ΠΎΠ±ΡΠ°Π·ΠΎΠ²Π°ΡΠ΅Π»ΡΠ½ΡΡ
ΡΠ΅Π»ΡΡ
. ΠΠ²ΡΠΎΡ Π½Π΅ ΠΏΠΎΠ»ΡΡΠ°Π» Π΄ΠΎΡΡΡΠΏΠ° ΠΊ ΠΏΠ΅ΡΡΠΎΠ½Π°Π»ΡΠ½ΡΠΌ Π΄Π°Π½Π½ΡΠΌ ΡΡΠ΅ΡΡΠΈΡ
Π»ΠΈΡ ΠΈ ΠΊΠΎΠΌΠΏΠ°Π½ΠΈΠΉ. Π‘ΠΊΡΠΈΠ½ΡΠΎΡΡ Π²Π·ΡΡΡ Π»ΠΈΠ±ΠΎ ΠΈΠ· ΠΎΡΠΊΡΡΡΡΡ
ΠΈΡΡΠΎΡΠ½ΠΈΠΊΠΎΠ², Π»ΠΈΠ±ΠΎ Π±ΡΠ»ΠΈ ΠΏΡΠ΅Π΄ΠΎΡΡΠ°Π²Π»Π΅Π½Ρ Π°Π²ΡΠΎΡΡ Π°Π½ΠΎΠ½ΠΈΠΌΠ½ΡΠΌΠΈ Π΄ΠΎΠ±ΡΠΎΠΆΠ΅Π»Π°ΡΠ΅Π»ΡΠΌΠΈ.
Ndikunye nam, njengomnini wetshaneli yeTelegram "", Umfundi wesitishi onqwenela ukungaziwa igama lakhe uye wanxibelelana kwaye waxela ngokoqobo oku kulandelayo:
Iseva yeClickHouse evulekileyo yafunyanwa kwi-Intanethi, eyenkampani doc+. Idilesi ye-IP yomncedisi ihambelana nedilesi ye-IP apho idomeyini ye-docplus.ru iqwalaselwe.
Isuka kwiWikipedia: I-DOC + (iNew Medicine LLC) yinkampani yezonyango yaseRashiya enikezela ngeenkonzo kwintsimi ye-telemedicine, ukubiza ugqirha ekhaya, ukugcinwa kunye nokusebenza. idatha yobuqu yezonyango. Inkampani ifumene utyalo-mali kwiYandex.
Ukuqwalasela ulwazi oluqokelelweyo, i-ClickHouse database yayifikeleleke ngokukhululekileyo, kwaye nabani na, eyazi idilesi ye-IP, unokufumana idatha kuyo. Le datha ibonakale ngathi ziilog zofikelelo lwenkonzo.
Njengoko ubona kumfanekiso ongentla, ukongeza kwi-www.docplus.ru iseva yewebhu kunye ne-ClickHouse iseva (port 9000), i-database ye-MongoDB ixhonywe ngokubanzi kwidilesi ye-IP efanayo (apho, ngokucacileyo, akukho nto. umdla).
Ngokokwazi kwam, i-injini yokukhangela ye-Shodan.io yasetyenziselwa ukufumanisa iseva yeClickHouse (malunga Ndabhala ngokwahlukileyo) ngokubambisana neskripthi esikhethekileyo , ekhangele idatabase efunyenweyo ngenxa yokunqongophala koqinisekiso kwaye idwelise zonke iitafile zayo. Ngelo xesha kwakubonakala ngathi kukho abangama-474.
Ukusuka kumaxwebhu siyazi ukuba ngokungagqibekanga, iseva yeClickHouse imamele iHTTP kwi-port 8123. Ke ngoko, ukubona okuqulathwe kwiitafile, kwanele ukwenza into efana nalo mbuzo weSQL:
http://[IP-Π°Π΄ΡΠ΅Ρ]:8123?query=SELECT * FROM [Π½Π°Π·Π²Π°Π½ΠΈΠ΅ ΡΠ°Π±Π»ΠΈΡΡ]Njengesiphumo sokwenza isicelo, yintoni enokuthi ibuyiswe yile iboniswe kumfanekiso wekhusi ongezantsi:
Ukusuka kumfanekiso wekhusi kucacile ukuba ulwazi olukwintsimi IINTLOKO iqulethe idatha malunga nendawo (ubude kunye nobude) bomsebenzisi, idilesi yakhe ye-IP, ulwazi malunga nesixhobo aqhagamshele kuso inkonzo, inguqulo ye-OS, njl.
Ukuba kwenzekile ukuba umntu aguqule kancinane umbuzo weSQL, umzekelo, ngolu hlobo:
http://[IP-Π°Π΄ΡΠ΅Ρ]:8123?query=SELECT * FROM [Π½Π°Π·Π²Π°Π½ΠΈΠ΅ ΡΠ°Π±Π»ΠΈΡΡ] WHERE REQUEST LIKE β%25Profiles%25β
ke into efana nedatha yobuqu yabasebenzi inokubuyiselwa, eyile: igama elipheleleyo, umhla wokuzalwa, isini, inombolo yesazisi serhafu, ubhaliso kunye needilesi zokwenyani zendawo yokuhlala, iinombolo zomnxeba, izikhundla, idilesi ye-imeyile nokunye okuninzi:
Lonke olu lwazi luvela kwiscreenshot apha ngasentla lufana kakhulu nedatha ye-HR evela kwi-1C: Enterprise 8.3.
Ukujonga ngakumbi kwiparameter API_USER_TOKEN unokucinga ukuba lo luphawu "lokusebenza" onokuthi ngalo wenze izenzo ezahlukeneyo egameni lomsebenzisi, kubandakanya nokufumana idatha yakhe yobuqu. Kodwa ke andinakuyithetha le nto.
Okwangoku akukho lwazi lokuba iseva yeClickHouse isafumaneka ngokukhululekileyo kwidilesi ye-IP efanayo.
umthombo: www.habr.com