Try adding "SLAVE MONITOR" instead of "SUPER", as the error message says.
On Friday, 21 January 2022 at 17:21:01 UTC [email protected] wrote: > Yes, I have granted what is stated on the url you mentioned but it did not > work until I granted SUPER Status > > On Friday, January 21, 2022 at 4:58:21 PM UTC+1 Brian Candler wrote: > >> 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/0244c7b6-f3eb-4424-bc42-1d9c8e02dcdfn%40googlegroups.com.
