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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/ac93d3bd-9bde-440e-84b8-26d547603d15n%40googlegroups.com.
