level=error msg="Error pinging mysqld: dial tcp: lookup ((mysqld_exporter.mysql.address)): no such host" source="mysqld_exporter.go:268"

[Murryy79]

Hello:
I noticed mysql dashboards has no data to show in grafana.

Upon investigating, I peeked into /var/vcap/sys/log/mysqld_exporter/mysqld_exporter.stderr.log and found bunch of these error messages
time="2017-10-20T22:04:36Z" level=info msg="Starting mysqld_exporter (version=0.10.0, branch=master, revision=80680068f15474f87847c8ee8f18a2939a26196a)" source="mysqld_exporter.go:460"
time="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"
time="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"
time="2017-10-20T22:04:36Z" level=info msg="Listening on :9104" source="mysqld_exporter.go:479"
time="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"
time="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"
time="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"
time="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"
time="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"
time="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"
time="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"
time="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"
time="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"

further looking into prometheus.yml & local.yml, I found the following paragraph commented out.
https://github.com/pivotal-cf/prometheus-on-PCF/blob/master/pipeline/tasks/etc/local.yml#L60

Is there a reason commented out and wondering if it's related to why MySQL: dashboards aren't populated

Thanks

[mkuratczyk]

Hey. Take a look here: #15
I 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.

[Murryy79]

@mkuratczyk Sure, i would love to test new pipeline.
Some customization, I have added to existing pipeline are
target bosh using director hostname,
removed docker image dependency,
added SAML support
added multiple receivers in alertmanager
added LDAP authentication for grafana

not sure if i could ping on slack without invite to channel
my slack handle @mhathiw

best regards

[mkuratczyk]

I can't find your handle in OSS CF slack team. If you are there - try to reach me @kura or on #prometheus. Thanks