{"id":102281,"date":"2021-11-14T09:36:51","date_gmt":"2021-11-14T07:36:51","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/obnovlenie-postgresql-s-ustraneniem-uyazvimostej-vypusk-balansirovshhika-soedinenij-odyssey-1-2"},"modified":"2021-11-14T09:36:51","modified_gmt":"2021-11-14T07:36:51","slug":"obnovlenie-postgresql-s-ustraneniem-uyazvimostej-vypusk-balansirovshhika-soedinenij-odyssey-1-2","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/obnovlenie-postgresql-s-ustraneniem-uyazvimostej-vypusk-balansirovshhika-soedinenij-odyssey-1-2","title":{"rendered":"P\u00ebrdit\u00ebsimi i PostgreSQL p\u00ebr eliminimin e dob\u00ebsive. L\u00ebshimi i balancuesit t\u00eb lidhjeve Odyssey 1.2","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Jan\u00eb formuar p\u00ebrdit\u00ebsime korrigjuese p\u00ebr t\u00eb gjitha deg\u00ebt e mb\u00ebshtetura t\u00eb PostgreSQL: 14.1, 13.5, 12.9, 11.14, 10.19 dhe 9.6.24. L\u00ebshimi 9.6.24 do t\u00eb jet\u00eb p\u00ebrdit\u00ebsimi i fundit p\u00ebr deg\u00ebn 9.6, mb\u00ebshtetja e s\u00eb cil\u00ebs do t\u00eb pezullohet. P\u00ebrdit\u00ebsimet p\u00ebr deg\u00ebn 10 do t\u00eb formohen deri n\u00eb n\u00ebntor 2022, 11 \u2014 deri n\u00eb n\u00ebntor 2023, 12 \u2014 deri n\u00eb n\u00ebntor 2024, 13 \u2014 deri n\u00eb n\u00ebntor 2025, 14 \u2014 deri n\u00eb n\u00ebntor 2026. <\/p>\n

N\u00eb versionet e reja jan\u00eb propozuar m\u00eb shum\u00eb se 40 korrigjime dhe jan\u00eb eliminuar dy vulnerabilitete (CVE-2021-23214, CVE-2021-23222) n\u00eb procesin e serverit dhe bibliotek\u00ebn klient libpq. Vulnerabilitetet lejojn\u00eb nj\u00eb sulmues t\u00eb nd\u00ebrhyj\u00eb n\u00eb kanalin e koduar t\u00eb komunikimit p\u00ebrmes nj\u00eb sulmi MITM. Sulmi nuk k\u00ebrkon t\u00eb ket\u00eb nj\u00eb p\u00ebrfshirje t\u00eb sakt\u00eb. SSL<\/a>-certifikata dhe mund t\u00eb zhvillohet kund\u00ebr sistemeve q\u00eb k\u00ebrkojn\u00eb autentifikimin e klientit p\u00ebrmes certifikat\u00ebs. N\u00eb kontekstin e serverit, sulmi lejon z\u00ebvend\u00ebsimin e k\u00ebrkes\u00ebs SQL gjat\u00eb vendosjes s\u00eb lidhjes s\u00eb koduar t\u00eb klientit me serverin PostgreSQL. N\u00eb kontekstin e libpq, vulnerabiliteti lejon sulmuesin t\u00eb kthej\u00eb nj\u00eb p\u00ebrgjigje t\u00eb rreme nga serveri p\u00ebr klientin. N\u00eb kombinim, k\u00ebto vulnerabilitete lejojn\u00eb nxjerrjen e informacionit p\u00ebr fjal\u00ebkalimin ose t\u00eb dh\u00ebnave t\u00eb tjera t\u00eb ndjeshme t\u00eb klientit q\u00eb kalojn\u00eb n\u00eb faz\u00ebn e hershme t\u00eb lidhjes. <\/p>\n

P\u00ebrve\u00e7 k\u00ebsaj, mund t\u00eb theksohet publikimi nga kompania Yandex i nj\u00eb versioni t\u00eb ri t\u00eb serverit proxy Odyssey 1.2, i destinuar p\u00ebr mbajtjen e nj\u00eb grupi t\u00eb lidhjeve t\u00eb hapura me DBMS PostgreSQL dhe organizimin e routing-ut t\u00eb k\u00ebrkesave. Odyssey mb\u00ebshtet ekzekutimin e disa proceseve punuese me p\u00ebrpunues nj\u00ebkoh\u00ebsor\u00eb, gjithashtu server<\/a> n\u00eb rivendosjen e lidhjes s\u00eb klientit, mund\u00ebsin\u00eb e lidhjes s\u00eb grupeve t\u00eb lidhjeve me p\u00ebrdoruesit dhe DB-n\u00eb. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn BSD. <\/p>\n

N\u00eb versionin e ri t\u00eb Odyssey \u00ebsht\u00eb shtuar mbrojtja p\u00ebr bllokimin e z\u00ebvend\u00ebsimit t\u00eb t\u00eb dh\u00ebnave pas pajtimit SSL (lejon bllokimin e sulmeve q\u00eb p\u00ebrdorin dob\u00ebsit\u00eb e p\u00ebrmendura CVE-2021-23214 dhe CVE-2021-23222). \u00cbsht\u00eb realizuar mb\u00ebshtetje p\u00ebr PAM dhe LDAP. \u00cbsht\u00eb shtuar integrimi me sistemin e monitorimit Prometheus. \u00cbsht\u00eb p\u00ebrmir\u00ebsuar llogaritja e parametrave statistikor\u00eb p\u00ebr t\u00eb marr\u00eb parasysh koh\u00ebn e ekzekutimit t\u00eb transaksioneve dhe k\u00ebqyrjeve.
\n
Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0421\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432\u0435\u0442\u043e\u043a PostgreSQL: 14.1, 13.5, 12.9, 11.14, 10.19 \u0438 9.6.24. \u0412\u044b\u043f\u0443\u0441\u043a 9.6.24 \u0441\u0442\u0430\u043d\u0435\u0442 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u043c \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0434\u043b\u044f \u0432\u0435\u0442\u043a\u0438 9.6, \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0430. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0432\u0435\u0442\u043a\u0438 10 \u0431\u0443\u0434\u0443\u0442 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2022 \u0433\u043e\u0434\u0430, 11 — \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2023 \u0433\u043e\u0434\u0430, 12 — \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2024 \u0433\u043e\u0434\u0430, 13 — \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2025 \u0433\u043e\u0434\u0430, 14 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-102281","post","type-post","status-publish","format-standard","hentry","category-novosti-interneta"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47P\u00ebrdit\u00ebsimi i PostgreSQL me zgjidhjen e dob\u00ebsive. L\u00ebshimi i balancuesit t\u00eb lidhjeve Odyssey 1.2 | ProHoster","description":"\u00cbsht\u00eb formuar p\u00ebrdit\u00ebsime korrigjuese p\u00ebr t\u00eb gjitha deg\u00ebt e mb\u00ebshtetur t\u00eb PostgreSQL: 14.1, 13.5, 12.9, 11.14, 10.19 dhe 9.6.24. L\u00ebshimi i 9.6.24 do t\u00eb jet\u00eb p\u00ebrdit\u00ebsimi i fundit p\u00ebr deg\u00ebn 9.6, mb\u00ebshtetje p\u00ebr t\u00eb cil\u00ebn do t\u00eb ndalet. P\u00ebrdit\u00ebsimet p\u00ebr deg\u00ebn 10 do t\u00eb formohen deri n\u00eb n\u00ebntor 2022, 11 - deri n\u00eb n\u00ebntor 2023, 12 - deri n\u00eb n\u00ebntor 2024, 13 - deri n\u00eb n\u00ebntor 2025, 14.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/obnovlenie-postgresql-s-ustraneniem-uyazvimostej-vypusk-balansirovshhika-soedinenij-odyssey-1-2","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 PostgreSQL \u0441 \u0443\u0441\u0442\u0440\u0430\u043d\u0435\u043d\u0438\u0435\u043c \u0443\u044f\u0437\u0432\u0438\u043c\u043e\u0441\u0442\u0435\u0439. \u0412\u044b\u043f\u0443\u0441\u043a \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439 Odyssey 1.2 | ProHoster","og:description":"\u0421\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432\u0435\u0442\u043e\u043a PostgreSQL: 14.1, 13.5, 12.9, 11.14, 10.19 \u0438 9.6.24. \u0412\u044b\u043f\u0443\u0441\u043a 9.6.24 \u0441\u0442\u0430\u043d\u0435\u0442 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u043c \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0434\u043b\u044f \u0432\u0435\u0442\u043a\u0438 9.6, \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0430. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0432\u0435\u0442\u043a\u0438 10 \u0431\u0443\u0434\u0443\u0442 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2022 \u0433\u043e\u0434\u0430, 11 - \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2023 \u0433\u043e\u0434\u0430, 12 - \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2024 \u0433\u043e\u0434\u0430, 13 - \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2025 \u0433\u043e\u0434\u0430, 14","og:url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/obnovlenie-postgresql-s-ustraneniem-uyazvimostej-vypusk-balansirovshhika-soedinenij-odyssey-1-2","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2021-11-14T07:36:51+00:00","article:modified_time":"2021-11-14T07:36:51+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"102281","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-11-14 07:37:43","updated":"2026-02-09 21:42:00","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/102281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=102281"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/102281\/revisions"}],"predecessor-version":[{"id":160183,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/102281\/revisions\/160183"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=102281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=102281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=102281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}