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/5ad1321b-59bc-4d0d-a5c2-44b9d26da147n%40googlegroups.com.
