{"action":"created","issue":{"url":"https://api.github.com/repos/pivotal-cf/prometheus-on-PCF/issues/16","repository_url":"https://api.github.com/repos/pivotal-cf/prometheus-on-PCF","labels_url":"https://api.github.com/repos/pivotal-cf/prometheus-on-PCF/issues/16/labels{/name}","comments_url":"https://api.github.com/repos/pivotal-cf/prometheus-on-PCF/issues/16/comments","events_url":"https://api.github.com/repos/pivotal-cf/prometheus-on-PCF/issues/16/events","html_url":"https://github.com/pivotal-cf/prometheus-on-PCF/issues/16","id":268412636,"number":16,"title":"level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"","user":{"login":"Murryy79","id":19574664,"avatar_url":"https://avatars2.githubusercontent.com/u/19574664?v=4","gravatar_id":"","url":"https://api.github.com/users/Murryy79","html_url":"https://github.com/Murryy79","followers_url":"https://api.github.com/users/Murryy79/followers","following_url":"https://api.github.com/users/Murryy79/following{/other_user}","gists_url":"https://api.github.com/users/Murryy79/gists{/gist_id}","starred_url":"https://api.github.com/users/Murryy79/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Murryy79/subscriptions","organizations_url":"https://api.github.com/users/Murryy79/orgs","repos_url":"https://api.github.com/users/Murryy79/repos","events_url":"https://api.github.com/users/Murryy79/events{/privacy}","received_events_url":"https://api.github.com/users/Murryy79/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-10-25T14:09:26Z","updated_at":"2017-10-25T14:20:49Z","closed_at":null,"author_association":"NONE","body":"Hello:\r\nI noticed mysql dashboards has no data to show in grafana.\r\n![image](https://user-images.githubusercontent.com/19574664/32003005-7e1e0846-b963-11e7-8b64-2d1565519a59.png)\r\n\r\nUpon investigating, I peeked into /var/vcap/sys/log/mysqld_exporter/mysqld_exporter.stderr.log and found bunch of these error messages\r\ntime=\"2017-10-20T22:04:36Z\" level=info msg=\"Starting mysqld_exporter (version=0.10.0, branch=master, revision=80680068f15474f87847c8ee8f18a2939a26196a)\" source=\"mysqld_exporter.go:460\"\r\ntime=\"2017-10-20T22:04:36Z\" level=info msg=\"Build context (go=go1.8.1, user=root@3b0154cd9e8e, date=20170425-11:24:12)\" source=\"mysqld_exporter.go:461\"\r\ntime=\"2017-10-20T22:04:36Z\" level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"\r\ntime=\"2017-10-20T22:04:36Z\" level=info msg=\"Listening on :9104\" source=\"mysqld_exporter.go:479\"\r\ntime=\"2017-10-20T22:10:23Z\" level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"\r\ntime=\"2017-10-20T22:11:23Z\" level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"\r\ntime=\"2017-10-20T22:12:23Z\" level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"\r\ntime=\"2017-10-20T22:13:23Z\" level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"\r\ntime=\"2017-10-20T22:14:23Z\" level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"\r\ntime=\"2017-10-20T22:15:23Z\" level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"\r\ntime=\"2017-10-20T22:16:23Z\" level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"\r\ntime=\"2017-10-20T22:17:23Z\" level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"\r\ntime=\"2017-10-20T22:18:23Z\" level=error msg=\"Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host\" source=\"mysqld_exporter.go:268\"\r\n\r\nfurther looking into prometheus.yml & local.yml, I found the following paragraph commented out.\r\nhttps://github.com/pivotal-cf/prometheus-on-PCF/blob/master/pipeline/tasks/etc/local.yml#L60\r\n \r\nIs there a reason commented out and wondering if it's related to why MySQL:  dashboards aren't populated \r\n![image](https://user-images.githubusercontent.com/19574664/32003247-1e1d94ec-b964-11e7-92e1-92e8eadaff28.png)\r\n\r\nThanks\r\n"},"comment":{"url":"https://api.github.com/repos/pivotal-cf/prometheus-on-PCF/issues/comments/339346048","html_url":"https://github.com/pivotal-cf/prometheus-on-PCF/issues/16#issuecomment-339346048","issue_url":"https://api.github.com/repos/pivotal-cf/prometheus-on-PCF/issues/16","id":339346048,"user":{"login":"mkuratczyk","id":9566114,"avatar_url":"https://avatars2.githubusercontent.com/u/9566114?v=4","gravatar_id":"","url":"https://api.github.com/users/mkuratczyk","html_url":"https://github.com/mkuratczyk","followers_url":"https://api.github.com/users/mkuratczyk/followers","following_url":"https://api.github.com/users/mkuratczyk/following{/other_user}","gists_url":"https://api.github.com/users/mkuratczyk/gists{/gist_id}","starred_url":"https://api.github.com/users/mkuratczyk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkuratczyk/subscriptions","organizations_url":"https://api.github.com/users/mkuratczyk/orgs","repos_url":"https://api.github.com/users/mkuratczyk/repos","events_url":"https://api.github.com/users/mkuratczyk/events{/privacy}","received_events_url":"https://api.github.com/users/mkuratczyk/received_events","type":"User","site_admin":false},"created_at":"2017-10-25T14:20:49Z","updated_at":"2017-10-25T14:20:49Z","author_association":"CONTRIBUTOR","body":"Hey. Take a look here: https://github.com/pivotal-cf/prometheus-on-PCF/pull/15\r\nI haven't spent much time investigating this because I'm working on a total rewrite of this pipeline. I'm literally working on mysql support right now (and small footprint PCF support).  Ping me on CF Slack @kura if you would like to test the new pipeline."}}
{"actor":{"display_login":"mkuratczyk"}}