search

prometheus / mysqld_exporter

Exporter for MySQL server metrics
http://prometheus.io/
Apache License 2.0
2.07k stars 741 forks source link

msg="Error pinging mysqld" err="TLS requested but server does not support TLS" #770

Open wl2659297 opened 9 months ago

wl2659297 commented 9 months ago

Host operating system: output of uname -a

mysqld_exporter version: output of mysqld_exporter --version

MySQL server version

aliyun rds: innodb_version 5.7.40 protocol_version 10 rds_audit_log_version MYSQL_V1 rds_hotfix_version 0 rds_version 40 slave_type_conversions
tls_version TLSv1,TLSv1.1,TLSv1.2 version 5.7.40-log version_comment Source distribution version_compile_machine x86_64 version_compile_os Linux

mysqld_exporter command line flags

docker compose start the container： mysqld_exporter: image: harbor2.chinawanglei.com:60082/es/prom/mysqld-exporter:v0.15.0 hostname: mysqld_exporter container_name: mysqld_exporter restart: always ports:

my.cnf file info: [client] user = xxxxxx password = xxxxx tls = skip-verify

What did you do that produced an error?

ts=2023-09-21T07:26:36.373Z caller=mysqld_exporter.go:220 level=info msg="Starting mysqld_exporter" version="(version=0.15.0, branch=HEAD, revision=6ca2a42f97f3403c7788ff4f374430aa267a6b6b)" ts=2023-09-21T07:26:36.374Z caller=mysqld_exporter.go:221 level=info msg="Build context" build_context="(go=go1.20.5, platform=linux/amd64, user=root@c4fca471a5b1, date=20230624-04:09:04, tags=netgo)" ts=2023-09-21T07:26:36.374Z caller=mysqld_exporter.go:233 level=info msg="Scraper enabled" scraper=global_status ts=2023-09-21T07:26:36.374Z caller=mysqld_exporter.go:233 level=info msg="Scraper enabled" scraper=global_variables ts=2023-09-21T07:26:36.374Z caller=mysqld_exporter.go:233 level=info msg="Scraper enabled" scraper=slave_status ts=2023-09-21T07:26:36.374Z caller=mysqld_exporter.go:233 level=info msg="Scraper enabled" scraper=info_schema.innodb_cmp ts=2023-09-21T07:26:36.374Z caller=mysqld_exporter.go:233 level=info msg="Scraper enabled" scraper=info_schema.innodb_cmpmem ts=2023-09-21T07:26:36.374Z caller=mysqld_exporter.go:233 level=info msg="Scraper enabled" scraper=info_schema.query_response_time ts=2023-09-21T07:26:36.374Z caller=tls_config.go:274 level=info msg="Listening on" address=[::]:9104 ts=2023-09-21T07:26:36.374Z caller=tls_config.go:277 level=info msg="TLS is disabled." http2=false address=[::]:9104 ts=2023-09-21T07:26:38.562Z caller=exporter.go:152 level=error msg="Error pinging mysqld" err="TLS requested but server does not support TLS" ts=2023-09-21T07:26:53.562Z caller=exporter.go:152 level=error msg="Error pinging mysqld" err="TLS requested but server does not support TLS" ts=2023-09-21T07:27:08.561Z caller=exporter.go:152 level=error msg="Error pinging mysqld" err="TLS requested but server does not support TLS" ts=2023-09-21T07:27:23.561Z caller=exporter.go:152 level=error msg="Error pinging mysqld" err="TLS requested but server does not support TLS" ts=2023-09-21T07:27:38.564Z caller=exporter.go:152 level=error msg="Error pinging mysqld" err="TLS requested but server does not support TLS"

What did you expect to see?

What did you see instead?

wl2659297 commented 9 months ago

i disable tls 。but still send tls request . and then see the error log "TLS requested but server does not support TLS".how to solve this problem?

please help me . thanks!!!

wl2659297 commented 9 months ago

the docker soure image is "prom/mysqld-exporter:v0.15.0"

wl2659297 commented 9 months ago

The reference configuration is https://github.com/prometheus/mysqld_exporter/blob/main/config/testdata/client_custom_tls.cnf

Jack-R-lantern commented 6 months ago

@wl2659297 I face the same problem and I think this is the problem