{"id":809,"date":"2018-11-26T11:28:53","date_gmt":"2018-11-26T10:28:53","guid":{"rendered":"https:\/\/www.webonic.hu\/support\/?post_type=ht_kb&p=809"},"modified":"2018-11-26T11:28:53","modified_gmt":"2018-11-26T10:28:53","slug":"virussal-fertozott-adatbazisok","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.hu\/tamogatas\/kb\/virussal-fertozott-adatbazisok\/","title":{"rendered":"V\u00edrussal fert\u0151z\u00f6tt adatb\u00e1zisok"},"content":{"rendered":"

Ha a fert\u0151z\u00e9s egy k\u00fcl\u00f6n\u00e1ll\u00f3 adatb\u00e1zisban van, akkor \u00e9rdemes v\u00edruskeres\u0151t futtatni az itt<\/a> megtal\u00e1lhat\u00f3 \u00fatmutat\u00f3 szerint. Ezt k\u00f6vet\u0151en a honlap als\u00f3 r\u00e9sz\u00e9n a k\u00f6vetkez\u0151 \u00fczenet jelenik meg:<\/p>\n

 <\/p>\n

Ebben az esetben azt l\u00e1tjuk, hogy a sample123_inf elnevez\u00e9s\u0171 adatb\u00e1zis lett megfert\u0151zve, \u00e9s a fert\u0151z\u00e9s konkr\u00e9tan a wp_posts t\u00e1bl\u00e1ban tal\u00e1lhat\u00f3.<\/p>\n

Megjegyz\u00e9s: a k\u00f6vetkez\u0151 l\u00e9p\u00e9seket k\u00f6r\u00fcltekint\u0151en kell v\u00e9grehajtani, mert az oldal hib\u00e1s m\u0171k\u00f6d\u00e9s\u00e9t okozhatja.<\/p>\n

COINHIVE T\u00cdPUS\u00da ADATB\u00c1ZIS-FERT\u0150Z\u00c9S:<\/h2>\n

Els\u0151 l\u00e9p\u00e9sk\u00e9nt biztons\u00e1gi ment\u00e9st hozunk l\u00e9tre az adatb\u00e1zisr\u00f3l. Az adatb\u00e1zist let\u00f6ltj\u00fck a sz\u00e1m\u00edt\u00f3g\u00e9pre: az adatb\u00e1zisok list\u00e1j\u00e1ban megkeress\u00fck a fert\u0151z\u00f6tt adatb\u00e1zist, majd a Kezel\u00e9s – Let\u00f6lt\u00e9s gombra kattintva let\u00f6ltj\u00fck az adatb\u00e1zist.<\/p>\n

Ezt k\u00f6vet\u0151en bel\u00e9p\u00fcnk a webhostinggal \u00f6sszek\u00f6t\u00f6tt shell konzolba, p\u00e9ld\u00e1ul a k\u00f6vetkez\u0151 \u00fatmutat\u00f3<\/a> szerint:<\/p>\n

Az \u00e9rintett adatb\u00e1zist let\u00f6ltj\u00fck a shell seg\u00edts\u00e9g\u00e9vel:<\/p>\n

mysqldump -u username -p password -h host -P port database > infected_dump.sql<\/p>\n

A username \u00e9s a password mez\u0151ket helyettes\u00edtj\u00fck az adatb\u00e1zishoz tartoz\u00f3 aktu\u00e1lis felhaszn\u00e1l\u00f3n\u00e9vvel \u00e9s jelsz\u00f3val, a host mez\u0151t a k\u00fcls\u0151s hoszttal (pl. a MariaDB 10.1 adatb\u00e1zis eset\u00e9n ez mariadb101.websupport.sk), a port mez\u0151t az adott porttal (pl. 3312).<\/p>\n

Ezt k\u00f6vet\u0151en a dump biztons\u00e1gi ment\u00e9sre (az adatb\u00e1zis ment\u00e9se sz\u00f6veges form\u00e1ban) elind\u00edtjuk a scriptet, amely megtiszt\u00edtja az adatb\u00e1zist a CoinHive fert\u0151z\u00e9st\u0151l:<\/p>\n

perl -pe ‘s#<script[\\s\\S]*?>[\\s\\S]*?(CoinHive|authedmine)[\\s\\S]*?<\\\/script>##g’ < infected_dump.sql > clean_dump.sql<\/p>\n

A k\u00f6vetkez\u0151 paranccsal ism\u00e9t felt\u00f6lthetj\u00fck az adatb\u00e1zist a szerverre:<\/p>\n

mysql -u username -p password -h host -P port database < clean_dump.sql<\/p>\n

Ezt k\u00f6vet\u0151en ellen\u0151rizni kell a weboldal m\u0171k\u00f6d\u00e9s\u00e9t. Az utols\u00f3 l\u00e9p\u00e9sben a t\u00e1rhely foglalts\u00e1g miatt  javasoljuk a sz\u00fcks\u00e9gtelen f\u00e1jlok t\u00f6rl\u00e9s\u00e9t a k\u00f6vetkez\u0151 paranccsal:<\/p>\n

rm infected_dump.sql clean_dump.sql<\/p>\n","protected":false},"excerpt":{"rendered":"

Ha a fert\u0151z\u00e9s egy k\u00fcl\u00f6n\u00e1ll\u00f3 adatb\u00e1zisban van, akkor \u00e9rdemes v\u00edruskeres\u0151t futtatni az itt megtal\u00e1lhat\u00f3 \u00fatmutat\u00f3 szerint. Ezt k\u00f6vet\u0151en a honlap als\u00f3 r\u00e9sz\u00e9n a k\u00f6vetkez\u0151 \u00fczenet jelenik meg:   Ebben az esetben azt l\u00e1tjuk, hogy a sample123_inf elnevez\u00e9s\u0171 adatb\u00e1zis lett megfert\u0151zve, \u00e9s a fert\u0151z\u00e9s konkr\u00e9tan a wp_posts t\u00e1bl\u00e1ban tal\u00e1lhat\u00f3. Megjegyz\u00e9s: a…<\/p>\n","protected":false},"author":19,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[94,100],"ht-kb-tag":[1782,1779,1773],"class_list":["post-809","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-the-hosting","ht_kb_category-adatbazis","ht_kb_tag-adtbazis-fertozes","ht_kb_tag-coinhive","ht_kb_tag-virusos-adatbazisok"],"yoast_head":"\nV\u00edrussal fert\u0151z\u00f6tt adatb\u00e1zisok - Websupport Tud\u00e1sb\u00e1zis<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.websupport.hu\/tamogatas\/kb\/virussal-fertozott-adatbazisok\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"V\u00edrussal fert\u0151z\u00f6tt adatb\u00e1zisok - Websupport Tud\u00e1sb\u00e1zis\" \/>\n<meta property=\"og:description\" content=\"Ha a fert\u0151z\u00e9s egy k\u00fcl\u00f6n\u00e1ll\u00f3 adatb\u00e1zisban van, akkor \u00e9rdemes v\u00edruskeres\u0151t futtatni az itt megtal\u00e1lhat\u00f3 \u00fatmutat\u00f3 szerint. Ezt k\u00f6vet\u0151en a honlap als\u00f3 r\u00e9sz\u00e9n a k\u00f6vetkez\u0151 \u00fczenet jelenik meg:   Ebben az esetben azt l\u00e1tjuk, hogy a sample123_inf elnevez\u00e9s\u0171 adatb\u00e1zis lett megfert\u0151zve, \u00e9s a fert\u0151z\u00e9s konkr\u00e9tan a wp_posts t\u00e1bl\u00e1ban tal\u00e1lhat\u00f3. Megjegyz\u00e9s: a...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.hu\/tamogatas\/kb\/virussal-fertozott-adatbazisok\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Tud\u00e1sb\u00e1zis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/virussal-fertozott-adatbazisok\\\/\",\"url\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/virussal-fertozott-adatbazisok\\\/\",\"name\":\"V\u00edrussal fert\u0151z\u00f6tt adatb\u00e1zisok - Websupport Tud\u00e1sb\u00e1zis\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/#website\"},\"datePublished\":\"2018-11-26T10:28:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/virussal-fertozott-adatbazisok\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/virussal-fertozott-adatbazisok\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/virussal-fertozott-adatbazisok\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"V\u00edrussal fert\u0151z\u00f6tt adatb\u00e1zisok\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/\",\"name\":\"Websupport Tud\u00e1sb\u00e1zis\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"V\u00edrussal fert\u0151z\u00f6tt adatb\u00e1zisok - Websupport Tud\u00e1sb\u00e1zis","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.websupport.hu\/tamogatas\/kb\/virussal-fertozott-adatbazisok\/","og_locale":"hu_HU","og_type":"article","og_title":"V\u00edrussal fert\u0151z\u00f6tt adatb\u00e1zisok - Websupport Tud\u00e1sb\u00e1zis","og_description":"Ha a fert\u0151z\u00e9s egy k\u00fcl\u00f6n\u00e1ll\u00f3 adatb\u00e1zisban van, akkor \u00e9rdemes v\u00edruskeres\u0151t futtatni az itt megtal\u00e1lhat\u00f3 \u00fatmutat\u00f3 szerint. Ezt k\u00f6vet\u0151en a honlap als\u00f3 r\u00e9sz\u00e9n a k\u00f6vetkez\u0151 \u00fczenet jelenik meg:   Ebben az esetben azt l\u00e1tjuk, hogy a sample123_inf elnevez\u00e9s\u0171 adatb\u00e1zis lett megfert\u0151zve, \u00e9s a fert\u0151z\u00e9s konkr\u00e9tan a wp_posts t\u00e1bl\u00e1ban tal\u00e1lhat\u00f3. Megjegyz\u00e9s: a...","og_url":"https:\/\/www.websupport.hu\/tamogatas\/kb\/virussal-fertozott-adatbazisok\/","og_site_name":"Websupport Tud\u00e1sb\u00e1zis","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.hu\/tamogatas\/kb\/virussal-fertozott-adatbazisok\/","url":"https:\/\/www.websupport.hu\/tamogatas\/kb\/virussal-fertozott-adatbazisok\/","name":"V\u00edrussal fert\u0151z\u00f6tt adatb\u00e1zisok - Websupport Tud\u00e1sb\u00e1zis","isPartOf":{"@id":"https:\/\/www.websupport.hu\/tamogatas\/#website"},"datePublished":"2018-11-26T10:28:53+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.hu\/tamogatas\/kb\/virussal-fertozott-adatbazisok\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.hu\/tamogatas\/kb\/virussal-fertozott-adatbazisok\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.hu\/tamogatas\/kb\/virussal-fertozott-adatbazisok\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.hu\/tamogatas\/"},{"@type":"ListItem","position":2,"name":"V\u00edrussal fert\u0151z\u00f6tt adatb\u00e1zisok"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.hu\/tamogatas\/#website","url":"https:\/\/www.websupport.hu\/tamogatas\/","name":"Websupport Tud\u00e1sb\u00e1zis","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.hu\/tamogatas\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb\/809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/users\/19"}],"version-history":[{"count":0,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb\/809\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/media?parent=809"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb-category?post=809"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb-tag?post=809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}