{"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\/hu\/blog\/news\/obnovlenie-postgresql-s-ustraneniem-uyazvimostej-vypusk-balansirovshhika-soedinenij-odyssey-1-2","title":{"rendered":"A PostgreSQL friss\u00edt\u00e9se sebezhet\u0151s\u00e9gek kijav\u00edt\u00e1s\u00e1val. Az Odyssey 1.2 kapcsolatkiegyenl\u00edt\u0151 kiad\u00e1sa","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

K\u00e9sz\u00fcltek korrekci\u00f3s friss\u00edt\u00e9sek az \u00f6sszes t\u00e1mogatott PostgreSQL \u00e1g sz\u00e1m\u00e1ra: 14.1, 13.5, 12.9, 11.14, 10.19 \u00e9s 9.6.24. A 9.6.24 kiad\u00e1s lesz az utols\u00f3 friss\u00edt\u00e9s a 9.6 \u00e1g sz\u00e1m\u00e1ra, amelynek t\u00e1mogat\u00e1sa megsz\u0171nik. A 10-es \u00e1g friss\u00edt\u00e9seit 2022 november\u00e9ig, a 11-es \u00e1g\u00e9t 2023 november\u00e9ig, a 12-es \u00e1g\u00e9t 2024 november\u00e9ig, a 13-as \u00e1g\u00e9t 2025 november\u00e9ig, a 14-es \u00e1g\u00e9t pedig 2026 november\u00e9ig k\u00e9sz\u00edtik el. <\/p>\n

Az \u00faj verzi\u00f3k t\u00f6bb mint 40 jav\u00edt\u00e1st \u00e9s k\u00e9t sebezhet\u0151s\u00e9get (CVE-2021-23214, CVE-2021-23222) tartalmaznak a szerveroldali folyamatban \u00e9s a libpq kliensk\u00f6nyvt\u00e1rban. Ezek a sebezhet\u0151s\u00e9gek lehet\u0151v\u00e9 teszik a t\u00e1mad\u00f3 sz\u00e1m\u00e1ra, hogy be\u00e9p\u00fclj\u00f6n a titkos\u00edtott kapcsolatba, v\u00e9grehajtva egy MITM t\u00e1mad\u00e1st. A t\u00e1mad\u00e1s nem ig\u00e9nyel \u00e9rv\u00e9nyes SSL<\/a>-tan\u00fas\u00edtv\u00e1nyt, \u00e9s v\u00e9grehajthat\u00f3 olyan rendszerek ellen, amelyek kliens-azonos\u00edt\u00e1st ig\u00e9nyelnek tan\u00fas\u00edtv\u00e1ny r\u00e9v\u00e9n. A szerver kontextus\u00e1ban a t\u00e1mad\u00e1s lehet\u0151v\u00e9 teszi, hogy a t\u00e1mad\u00f3 helyettes\u00edtse a saj\u00e1t SQL-lek\u00e9rdez\u00e9s\u00e9t a PostgreSQL szerverhez val\u00f3 titkos\u00edtott kapcsolat fel\u00e1ll\u00edt\u00e1s\u00e1nak pillanat\u00e1ban. A libpq eset\u00e9ben a sebezhet\u0151s\u00e9g lehet\u0151v\u00e9 teszi a t\u00e1mad\u00f3 sz\u00e1m\u00e1ra, hogy megt\u00e9veszt\u0151 v\u00e1laszt k\u00fcldj\u00f6n a kliensnek. Ezek a sebezhet\u0151s\u00e9gek egy\u00fctt inform\u00e1ci\u00f3k kisziv\u00e1rg\u00e1s\u00e1t teszik lehet\u0151v\u00e9, p\u00e9ld\u00e1ul a jelszavakr\u00f3l vagy m\u00e1s bizalmas adatokkal, amelyeket a kapcsolat korai szakasz\u00e1ban tov\u00e1bb\u00edtanak. <\/p>\n

Tov\u00e1bb\u00e1 eml\u00edt\u00e9sre m\u00e9lt\u00f3, hogy a Yandex \u00faj verzi\u00f3t tett k\u00f6zz\u00e9 az Odyssey 1.2 proxy-szerverb\u0151l, amely a PostgreSQL adatb\u00e1zis-kezel\u0151h\u00f6z val\u00f3 nyitott kapcsolatok poolj\u00e1nak fenntart\u00e1s\u00e1ra \u00e9s a lek\u00e9rdez\u00e9sek ir\u00e1ny\u00edt\u00e1s\u00e1ra szolg\u00e1l. Az Odyssey t\u00e1mogatja t\u00f6bb munkafolyamat ind\u00edt\u00e1s\u00e1t t\u00f6bb sz\u00e1l\u00fa kezel\u0151kkel, emellett szerverhez<\/a> a kliensn\u00e9l t\u00f6rt\u00e9n\u0151 \u00fajracsatlakoz\u00e1skor a kapcsol\u00f3d\u00e1si poolok felhaszn\u00e1l\u00f3khoz \u00e9s adatb\u00e1zisokhoz val\u00f3 k\u00f6t\u00e9s\u00e9nek lehet\u0151s\u00e9g\u00e9t is. A k\u00f3d C nyelven k\u00e9sz\u00fclt \u00e9s BSD licenc alatt \u00e9rhet\u0151 el. <\/p>\n

Az \u00faj Odyssey verzi\u00f3ban bevezet\u00e9sre ker\u00fclt egy v\u00e9delem az adatok helyettes\u00edt\u00e9s\u00e9nek blokkol\u00e1s\u00e1ra az SSL-munkamenet megk\u00f6t\u00e9se ut\u00e1n (lehet\u0151v\u00e9 teszi a fent eml\u00edtett CVE-2021-23214 \u00e9s CVE-2021-23222 sebezhet\u0151s\u00e9gekkel kapcsolatos t\u00e1mad\u00e1sok blokkol\u00e1s\u00e1t). Implement\u00e1lva lett a PAM \u00e9s LDAP t\u00e1mogat\u00e1s. A Prometheus monitoring rendszer integr\u00e1ci\u00f3ja is be\u00e9p\u00edt\u00e9sre ker\u00fclt. Jav\u00edtott\u00e1k a statisztikai param\u00e9terek sz\u00e1m\u00edt\u00e1s\u00e1t a tranzakci\u00f3k \u00e9s lek\u00e9rdez\u00e9sek v\u00e9grehajt\u00e1si idej\u00e9nek figyelembev\u00e9tel\u00e9vel.
\n
Forr\u00e1s: 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-news"],"aioseo_notices":[],"aioseo_head":"\n\t\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\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47PostgreSQL friss\u00edt\u00e9se a sebezhet\u0151s\u00e9gek kik\u00fcsz\u00f6b\u00f6l\u00e9s\u00e9vel. Az Odyssey 1.2 kapcsolatkiegyenl\u00edt\u0151 kiad\u00e1sa | ProHoster","description":"A megfelel\u0151 friss\u00edt\u00e9sek elk\u00e9sz\u00fcltek a PostgreSQL minden t\u00e1mogatott \u00e1g\u00e1hoz: 14.1, 13.5, 12.9, 11.14, 10.19 \u00e9s 9.6.24. A 9.6.24 kiad\u00e1s lesz az utols\u00f3 friss\u00edt\u00e9s a 9.6 \u00e1ghoz, amelynek t\u00e1mogat\u00e1sa megsz\u0171nik.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/obnovlenie-postgresql-s-ustraneniem-uyazvimostej-vypusk-balansirovshhika-soedinenij-odyssey-1-2","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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.","og:url":"https:\/\/prohoster.info\/hu\/blog\/news\/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\/hu\/wp-json\/wp\/v2\/posts\/102281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=102281"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/102281\/revisions"}],"predecessor-version":[{"id":160183,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/102281\/revisions\/160183"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=102281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=102281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=102281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}