I would guess it's doing something like "show slave status" and needs appropriate permissions.
The required grants are documented here: https://github.com/prometheus/mysqld_exporter#required-grants On Friday, 21 January 2022 at 13:47:01 UTC [email protected] wrote: > I changed BindAdree to 0.0.0.0, restarted exporter, started getting > > Jan 21 13:20:47 puppetmaster29 mysqld_exporter[120483]: level=error > ts=2022-01-21T12:20:47.712Z caller=exporter.go:174 msg="Error from scraper" > scraper=slave_status err="Error 1227: Access denied; you need (at least one > of) the SUPER, SLAVE MONITOR privilege(s) for this operation" > Jan 21 13:21:02 puppetmaster29 mysqld_exporter[120483]: level=error > ts=2022-01-21T12:21:02.688Z caller=exporter.go:174 msg="Error from scraper" > scraper=slave_status err="Error 1227: Access denied; you need (at least one > of) the SUPER, SLAVE MONITOR privilege(s) for this operation" > Jan 21 13:21:17 puppetmaster29 mysqld_exporter[120483]: level=error > ts=2022-01-21T12:21:17.684Z caller=exporter.go:174 msg="Error from scraper" > scraper=slave_status err="Error 1227: Access denied; you need (at least one > of) the SUPER, SLAVE MONITOR privilege(s) for this operation" > Jan 21 13:21:32 puppetmaster29 mysqld_exporter[120483]: level=error > ts=2022-01-21T12:21:32.679Z caller=exporter.go:174 msg="Error from scraper" > scraper=slave_status err="Error 1227: Access denied; you need (at least one > of) the SUPER, SLAVE MONITOR privilege(s) for this operation" > Jan 21 13:21:47 puppetmaster29 mysqld_exporter[120483]: level=error > ts=2022-01-21T12:21:47.684Z caller=exporter.go:174 msg="Error from scraper" > scraper=slave_status err="Error 1227: Access denied; you need (at least one > of) the SUPER, SLAVE MONITOR privilege(s) for this operation" > Jan 21 13:22:02 puppetmaster29 mysqld_exporter[120483]: level=error > ts=2022-01-21T12:22:02.687Z caller=exporter.go:174 msg="Error from scraper" > scraper=slave_status err="Error 1227: Access denied; you need (at least one > of) the SUPER, SLAVE MONITOR privilege(s) for this operation" > > On Friday, January 21, 2022 at 12:42:51 PM UTC+1 Brian Candler wrote: > >> 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/e798f178-6153-4a19-b935-ab9c006ea88an%40googlegroups.com.
