System is c$ uname -a Linux 4.4.0-141-generic #167-Ubuntu SMP Wed Dec 5 10:40:15 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
Using mysqld_exporter-0.12.1.linux-amd64.tar.gz I just installed Prometheus successfully pulling stats from 5 servers using node_explorer and visualizing with Grafana. I have installed mysql_explorer on two servers each with an instance of MySql 5.7 and both fail in the same way, they won't start, from journalctl -xe: Mar 30 20:55:24 sea-server-02 systemd[1]: Started Prometheus MySQL Exporter. -- Subject: Unit mysql_exporter.service has finished start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql_exporter.service has finished starting up. -- -- The start-up result is done. Mar 30 20:55:24 sea-server-02 mysqld_exporter[28996]: time="2021-03-30T20:55:24-05:00" level=info msg="Starting mysqld_exporter (version=0.12.1, branch=HEAD, revision=48667bf7c3b438b5e93b259f3d17b70a7c9a Mar 30 20:55:24 sea-server-02 mysqld_exporter[28996]: time="2021-03-30T20:55:24-05:00" level=info msg="Build context (go=go1.12.7, user=root@0b3e56a7bc0a, date=20190729-12:35:58)" source="mysqld_exporter Mar 30 20:55:24 sea-server-02 mysqld_exporter[28996]: time="2021-03-30T20:55:24-05:00" level=fatal msg="failed reading ini file: open <strong>/etc/.mysqld_exporter.cnf</strong>: no such file or directory Mar 30 20:55:24 sea-server-02 systemd[1]: mysql_exporter.service: Main process exited, code=exited, status=1/FAILURE Mar 30 20:55:24 sea-server-02 systemd[1]: mysql_exporter.service: Unit entered failed state. Mar 30 20:55:24 sea-server-02 systemd[1]: mysql_exporter.service: Failed with result 'exit-code'. Mar 30 20:55:25 sea-server-02 systemd[1]: mysql_exporter.service: Service hold-off time over, scheduling restart. Mar 30 20:55:25 sea-server-02 systemd[1]: Stopped Prometheus MySQL Exporter. -- Subject: Unit mysql_exporter.service has finished shutting down -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel The file /etc/.mysqld_exporter.cnf does in fact exist: /etc$ ls -lart | grep mysqld -rwxrwxrwx 1 root prometheus 54 Mar 30 15:57 .mysqld_exporter.cnf And has this content: /etc$ cat .mysqld_exporter.cnf [client] user=mysqld_exporter password=XXXXXXXX I have verified from command line that this userid/password work. Any help, debug tips would be appreciated.. Thanks, Al -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/ac93d3bd-9bde-440e-84b8-26d547603d15n%40googlegroups.com.