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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/585680f6-935e-40b8-a4e8-380b000da5ffn%40googlegroups.com.
