Yes you are right. Able to make it work after the mysqld option. Thanks Brian for your help. Appreciate it....
On Tuesday, August 22, 2023 at 1:08:58 PM UTC+5:30 Brian Candler wrote: > What does "telnet 127.0.0.1 3306" show? > > You haven't shown the mariadb "LISTEN" socket. If it's listening on > 10.0.0.4:3306 rather than 0.0.0.0:3306 or *:3306, then it will only > accept connections on 10.0.0.4:3306, and not 127.0.0.1:3306. > > You can see from your original error message that the exporter connects to > localhost:3306 by default, as documented under the general flags > <https://github.com/prometheus/mysqld_exporter/#general-flags>: > > mysqld.address > Hostname and port used for connecting to MySQL server, format: host:port. > (default: locahost:3306) > Therefore, if this is the only target you want to scrape, you could pass > --mysqld.address=10.0.0.4:3306 to override this. > > You could also do this through the scraping URL /probe with a "target" > parameter: > curl -s <IP>:9104/probe?target=10.0.0.4:3306 > > This is documented here: > https://github.com/prometheus/mysqld_exporter/#multi-target-support > However, that feature was only introduced in version v0.15.0 > <https://github.com/prometheus/mysqld_exporter/releases/tag/v0.15.0>. > > On Tuesday, 22 August 2023 at 06:16:35 UTC+1 Y.G Kumar wrote: > >> The mariadb service is infact running on the node on 3306: >> -- >> # telnet 10.0.0.4 3306 >> Trying 10.0.0.4 ... >> Connected to 10.0.0.4 . >> Escape character is '^]'. >> u >> 5.5.5-10.6.10-MariaDB-1:10.6.10+maria~ubu2004-logVcYvf{X'V�_X}.iHlf<69\mysql_native_password^CConnection >> >> closed by foreign host. >> --- >> >> tcp 0 0 10.0.0.4:3306 10.0.0.4:55890 ESTABLISHED >> 2863920/mariadbd >> >> But still the exporter is not able to detect the service. Not sure where >> it is going wrong ? >> >> >> On Tuesday, August 22, 2023 at 10:10:02 AM UTC+5:30 Y.G Kumar wrote: >> >>> What is the exact configuration option to mention the port number of the >>> service ? >>> >>> On Friday, August 18, 2023 at 5:55:58 PM UTC+5:30 Brian Candler wrote: >>> >>>> > dial tcp 127.0.0.1:3306: connect: connection refused >>>> >>>> Your mariadb is not listening on TCP port 3306 on the loopback address >>>> (127.0.0.1). >>>> >>>> If you show what command you use to connect to mariadb normally (e.g. >>>> using the "mysql" command line client) it should be possible to configure >>>> the mysql export to talk the same way. You would set this in whatever >>>> file >>>> you give to --config.my-cnf (defaults to ~/.my.cnf) >>>> See https://github.com/prometheus/mysqld_exporter/ >>>> >>>> On Friday, 18 August 2023 at 13:06:06 UTC+1 Y.G Kumar wrote: >>>> >>>>> Hi All, >>>>> >>>>> We have a galera mariadb 10.6 version three node cluster. When I tried >>>>> installing mysql exporter by following the link >>>>> https://computingforgeeks.com/monitoring-mysql-mariadb-with-prometheus-in-five-minutes/?expand_article=1 >>>>> >>>>> , I could not get the exporter to detect the mysql service in which it >>>>> is >>>>> running .. These are the logs: >>>>> -- >>>>> /tmp# curl -s <IP>:9104/metrics | grep mysql_up >>>>> ts=2023-08-18T11:22:21.544Z caller=exporter.go:152 level=error >>>>> msg="Error pinging mysqld" err="dial tcp 127.0.0.1:3306: connect: >>>>> connection refused" >>>>> # HELP mysql_up Whether the MySQL server is up. >>>>> # TYPE mysql_up gauge >>>>> mysql_up 0 >>>>> --- >>>>> >>>>> But the mariadb service is running on this node: >>>>> --- >>>>> ● mariadb.service - MariaDB 10.6.10 database server >>>>> Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; >>>>> vendor preset: enabled) >>>>> Drop-In: /etc/systemd/system/mariadb.service.d >>>>> └─migrated-from-my.cnf-settings.conf, override.conf >>>>> Active: active (running) since Wed 2023-05-10 23:10:13 UTC; 3 >>>>> months 8 days ago >>>>> Docs: man:mariadbd(8) >>>>> https://mariadb.com/kb/en/library/systemd/ >>>>> Main PID: 2540463 (mariadbd) >>>>> Status: "Taking your SQL requests now..." >>>>> Tasks: 1587 (limit: 618903) >>>>> CPU: 2w 5d 9h 34min 28.076s >>>>> CGroup: /galera.slice/mariadb.service >>>>> └─2540463 /usr/sbin/mariadbd >>>>> --wsrep_start_position=d635b506-3dd8-11e8-989e-7aec6efd1673:2862939478 >>>>> --- >>>>> >>>>> Can anyone help me where the fault is ? I have given enough >>>>> privileges for the 'mysqld_exporter' user as well. >>>>> >>>>> Thanks >>>>> Kumar >>>>> >>>>> -- 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/585680f6-935e-40b8-a4e8-380b000da5ffn%40googlegroups.com.
