What do these show? telnet ::1 3306 telnet localhost 3306
The requirements for enabling mysql to accept IPv6 connections are here: https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html Have you set bind_address=:: <https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_bind_address> ? As for why it's using IPv6, my guess is that your /etc/hosts has something like this: 127.0.0.1 localhost ::1 localhost One workaround is to change your exporter config to point to "127.0.0.1" instead of "localhost". Another workaround is to change /etc/hosts to 127.0.0.1 localhost ::1 localhost6 On Friday, 21 January 2022 at 10:38:20 UTC [email protected] wrote: > 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/ea85dc6e-d6de-4474-892f-1fa9a1a07c40n%40googlegroups.com.
