You are correct, there is an issu coonnecting to SQL, I am not sure why it is trying to use [::1]. Anyway, I granted the user on this ipv6 but still not able to connect CREATE USER 'mysqld_exporter'@'::1' IDENTIFIED BY 'mysqld_exporter' WITH MAX_USER_CONNECTIONS 2;
restarted the services but still getting Jan 21 11:21:47 puppetmaster29 mysqld_exporter[3863944]: level=error ts=2022-01-21T10:21:47.619Z caller=exporter.go:149 msg="Error pinging mysqld" err="dial tcp [::1]:3306: c> Jan 21 11:22:02 puppetmaster29 mysqld_exporter[3863944]: level=error ts=2022-01-21T10:22:02.619Z caller=exporter.go:149 msg="Error pinging mysqld" err="dial tcp [::1]:3306: c> Jan 21 11:22:17 puppetmaster29 mysqld_exporter[3863944]: level=error ts=2022-01-21T10:22:17.619Z caller=exporter.go:149 msg="Error pinging mysqld" err="dial tcp [::1]:3306: c> On Friday, January 21, 2022 at 9:04:36 AM UTC+1 Brian Candler wrote: > What do you get from: > > curl -sS 192.168.1.48:9104/metrics > > ? > > On Thursday, 20 January 2022 at 23:44:06 UTC [email protected] wrote: > >> I have just successful setup and run mysql exporter, when I switch to >> Prometheus >> UI, try to search for sql metrics, I see only 4 items >> >> mysql_exporter_last_scrape_error >> mysql_exporter_scrapes_total >> mysql_up >> mysqld_exporter_build_info >> >> in spite of the fact that I created a service file on Fedora 35 with all >> following flags >> ******************************************** >> [client] >> user=mysqld_exporter >> password=myuser >> >> [Unit] >> Description=Prometheus MySQL Exporter >> After=network.target >> User=prometheus >> Group=prometheus >> >> [Service] >> Type=simple >> Restart=always >> ExecStart=/usr/local/bin/mysqld_exporter \ >> --config.my-cnf /etc/.mysqld_exporter.cnf \ >> --collect.global_status \ >> --collect.info_schema.innodb_metrics \ >> --collect.auto_increment.columns \ >> --collect.info_schema.processlist \ >> --collect.binlog_size \ >> --collect.info_schema.tables.databases \ >> --collect.info_schema.tablestats \ >> --collect.global_variables \ >> --collect.info_schema.query_response_time \ >> --collect.info_schema.userstats \ >> --collect.info_schema.tables \ >> --collect.perf_schema.tablelocks \ >> --collect.perf_schema.file_events \ >> --collect.perf_schema.eventswaits \ >> --collect.perf_schema.indexiowaits \ >> --collect.perf_schema.tableiowaits \ >> --collect.perf_schema.memory_events \ >> --collect.slave_status \ >> --web.listen-address=192.168.1.48:9104 >> >> [Install] >> WantedBy=multi-user.target >> >> *********************************************** >> >> It starts succesfuly by running the service status in green and no >> errors. Thanks for your help >> >> -- 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/e78e449d-93f1-4ac5-a6a3-16c2a2713944n%40googlegroups.com.
