{"id":122,"date":"2017-04-13T23:05:49","date_gmt":"2017-04-13T21:05:49","guid":{"rendered":"http:\/\/adminsnet.de\/?p=122"},"modified":"2017-04-13T23:25:15","modified_gmt":"2017-04-13T21:25:15","slug":"ubuntu-16-04-unter-check_mysql_health","status":"publish","type":"post","link":"https:\/\/adminsnet.de\/?p=122","title":{"rendered":"check_mysql_health unter Ubuntu 16.04 (Icinga2)"},"content":{"rendered":"<p><strong>Download, kompilieren, installieren<\/strong><\/p>\n<pre>wget https:\/\/labs.consol.de\/assets\/downloads\/nagios\/check_mysql_health-2.2.2.tar.gz\r\ntar xfz check_mysql_health-2.2.2.tar.gz\r\ncd check_mysl_health\r\n.\/configure\r\nmake \r\nmake install<\/pre>\n<p><strong>Ben\u00f6tigte Pakete<\/strong><\/p>\n<pre>apt install libdbi-perl\r\napt install libdbd-mysql-perl<\/pre>\n<p><strong>Check testen<\/strong><\/p>\n<pre>root@icinga2:\/usr\/lib\/nagios\/plugins# .\/check_mysql_health -H 127.0.0.1 --user 'username' --password 'password' --mode threads-connected\r\n<em>OK - 7 client connection threads | threads_connected=7;10;20<\/em><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Download, kompilieren, installieren wget https:\/\/labs.consol.de\/assets\/downloads\/nagios\/check_mysql_health-2.2.2.tar.gz tar xfz check_mysql_health-2.2.2.tar.gz cd check_mysl_health .\/configure make make install Ben\u00f6tigte Pakete apt install libdbi-perl apt install libdbd-mysql-perl Check testen root@icinga2:\/usr\/lib\/nagios\/plugins# .\/check_mysql_health -H 127.0.0.1 &#8211;user &#8218;username&#8216; &#8211;password &#8218;password&#8216; &#8211;mode threads-connected OK &#8211; 7 client connection threads &hellip; <a href=\"https:\/\/adminsnet.de\/?p=122\">Weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[9],"tags":[],"class_list":["post-122","post","type-post","status-publish","format-standard","hentry","category-icinga2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>check_mysql_health unter Ubuntu 16.04 (Icinga2) - K3ops Blog<\/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:\/\/adminsnet.de\/?p=122\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"check_mysql_health unter Ubuntu 16.04 (Icinga2) - K3ops Blog\" \/>\n<meta property=\"og:description\" content=\"Download, kompilieren, installieren wget https:\/\/labs.consol.de\/assets\/downloads\/nagios\/check_mysql_health-2.2.2.tar.gz tar xfz check_mysql_health-2.2.2.tar.gz cd check_mysl_health .\/configure make make install Ben\u00f6tigte Pakete apt install libdbi-perl apt install libdbd-mysql-perl Check testen root@icinga2:\/usr\/lib\/nagios\/plugins# .\/check_mysql_health -H 127.0.0.1 --user &#039;username&#039; --password &#039;password&#039; --mode threads-connected OK - 7 client connection threads &hellip; Weiterlesen &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adminsnet.de\/?p=122\" \/>\n<meta property=\"og:site_name\" content=\"K3ops Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-13T21:05:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T21:25:15+00:00\" \/>\n<meta name=\"author\" content=\"k3ops\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"k3ops\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/adminsnet.de\\\/?p=122#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/adminsnet.de\\\/?p=122\"},\"author\":{\"name\":\"k3ops\",\"@id\":\"https:\\\/\\\/adminsnet.de\\\/#\\\/schema\\\/person\\\/c7b07ff4c9bdfa407fd3025cb616ff64\"},\"headline\":\"check_mysql_health unter Ubuntu 16.04 (Icinga2)\",\"datePublished\":\"2017-04-13T21:05:49+00:00\",\"dateModified\":\"2017-04-13T21:25:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/adminsnet.de\\\/?p=122\"},\"wordCount\":14,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/adminsnet.de\\\/#\\\/schema\\\/person\\\/c7b07ff4c9bdfa407fd3025cb616ff64\"},\"articleSection\":[\"Icinga2\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/adminsnet.de\\\/?p=122#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/adminsnet.de\\\/?p=122\",\"url\":\"https:\\\/\\\/adminsnet.de\\\/?p=122\",\"name\":\"check_mysql_health unter Ubuntu 16.04 (Icinga2) - K3ops Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/adminsnet.de\\\/#website\"},\"datePublished\":\"2017-04-13T21:05:49+00:00\",\"dateModified\":\"2017-04-13T21:25:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/adminsnet.de\\\/?p=122#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/adminsnet.de\\\/?p=122\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/adminsnet.de\\\/?p=122#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/adminsnet.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"check_mysql_health unter Ubuntu 16.04 (Icinga2)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/adminsnet.de\\\/#website\",\"url\":\"https:\\\/\\\/adminsnet.de\\\/\",\"name\":\"K3ops Blog\",\"description\":\"any - any  - deny\",\"publisher\":{\"@id\":\"https:\\\/\\\/adminsnet.de\\\/#\\\/schema\\\/person\\\/c7b07ff4c9bdfa407fd3025cb616ff64\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/adminsnet.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/adminsnet.de\\\/#\\\/schema\\\/person\\\/c7b07ff4c9bdfa407fd3025cb616ff64\",\"name\":\"k3ops\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da70c997989fdcd1e3636b97a4cf8e277f0ace20b0cedf0ad6ac5ff4f1be42c8?s=96&d=retro&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da70c997989fdcd1e3636b97a4cf8e277f0ace20b0cedf0ad6ac5ff4f1be42c8?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da70c997989fdcd1e3636b97a4cf8e277f0ace20b0cedf0ad6ac5ff4f1be42c8?s=96&d=retro&r=g\",\"caption\":\"k3ops\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da70c997989fdcd1e3636b97a4cf8e277f0ace20b0cedf0ad6ac5ff4f1be42c8?s=96&d=retro&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"check_mysql_health unter Ubuntu 16.04 (Icinga2) - K3ops Blog","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:\/\/adminsnet.de\/?p=122","og_locale":"de_DE","og_type":"article","og_title":"check_mysql_health unter Ubuntu 16.04 (Icinga2) - K3ops Blog","og_description":"Download, kompilieren, installieren wget https:\/\/labs.consol.de\/assets\/downloads\/nagios\/check_mysql_health-2.2.2.tar.gz tar xfz check_mysql_health-2.2.2.tar.gz cd check_mysl_health .\/configure make make install Ben\u00f6tigte Pakete apt install libdbi-perl apt install libdbd-mysql-perl Check testen root@icinga2:\/usr\/lib\/nagios\/plugins# .\/check_mysql_health -H 127.0.0.1 --user 'username' --password 'password' --mode threads-connected OK - 7 client connection threads &hellip; Weiterlesen &rarr;","og_url":"https:\/\/adminsnet.de\/?p=122","og_site_name":"K3ops Blog","article_published_time":"2017-04-13T21:05:49+00:00","article_modified_time":"2017-04-13T21:25:15+00:00","author":"k3ops","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"k3ops"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/adminsnet.de\/?p=122#article","isPartOf":{"@id":"https:\/\/adminsnet.de\/?p=122"},"author":{"name":"k3ops","@id":"https:\/\/adminsnet.de\/#\/schema\/person\/c7b07ff4c9bdfa407fd3025cb616ff64"},"headline":"check_mysql_health unter Ubuntu 16.04 (Icinga2)","datePublished":"2017-04-13T21:05:49+00:00","dateModified":"2017-04-13T21:25:15+00:00","mainEntityOfPage":{"@id":"https:\/\/adminsnet.de\/?p=122"},"wordCount":14,"commentCount":1,"publisher":{"@id":"https:\/\/adminsnet.de\/#\/schema\/person\/c7b07ff4c9bdfa407fd3025cb616ff64"},"articleSection":["Icinga2"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/adminsnet.de\/?p=122#respond"]}]},{"@type":"WebPage","@id":"https:\/\/adminsnet.de\/?p=122","url":"https:\/\/adminsnet.de\/?p=122","name":"check_mysql_health unter Ubuntu 16.04 (Icinga2) - K3ops Blog","isPartOf":{"@id":"https:\/\/adminsnet.de\/#website"},"datePublished":"2017-04-13T21:05:49+00:00","dateModified":"2017-04-13T21:25:15+00:00","breadcrumb":{"@id":"https:\/\/adminsnet.de\/?p=122#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adminsnet.de\/?p=122"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/adminsnet.de\/?p=122#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/adminsnet.de\/"},{"@type":"ListItem","position":2,"name":"check_mysql_health unter Ubuntu 16.04 (Icinga2)"}]},{"@type":"WebSite","@id":"https:\/\/adminsnet.de\/#website","url":"https:\/\/adminsnet.de\/","name":"K3ops Blog","description":"any - any  - deny","publisher":{"@id":"https:\/\/adminsnet.de\/#\/schema\/person\/c7b07ff4c9bdfa407fd3025cb616ff64"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/adminsnet.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/adminsnet.de\/#\/schema\/person\/c7b07ff4c9bdfa407fd3025cb616ff64","name":"k3ops","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/da70c997989fdcd1e3636b97a4cf8e277f0ace20b0cedf0ad6ac5ff4f1be42c8?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/da70c997989fdcd1e3636b97a4cf8e277f0ace20b0cedf0ad6ac5ff4f1be42c8?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/da70c997989fdcd1e3636b97a4cf8e277f0ace20b0cedf0ad6ac5ff4f1be42c8?s=96&d=retro&r=g","caption":"k3ops"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/da70c997989fdcd1e3636b97a4cf8e277f0ace20b0cedf0ad6ac5ff4f1be42c8?s=96&d=retro&r=g"}}]}},"_links":{"self":[{"href":"https:\/\/adminsnet.de\/index.php?rest_route=\/wp\/v2\/posts\/122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adminsnet.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adminsnet.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adminsnet.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adminsnet.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=122"}],"version-history":[{"count":6,"href":"https:\/\/adminsnet.de\/index.php?rest_route=\/wp\/v2\/posts\/122\/revisions"}],"predecessor-version":[{"id":124,"href":"https:\/\/adminsnet.de\/index.php?rest_route=\/wp\/v2\/posts\/122\/revisions\/124"}],"wp:attachment":[{"href":"https:\/\/adminsnet.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adminsnet.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adminsnet.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}