prom/mysqld-exporter启动失败

prom/mysqld-exporter启动失败

• 问题描述

  配置了compose文件，但是启动时一直自动退出
  
  cat docker-compose.yml
  #---
  version: '3'
  networks:
      monitor:
          driver: bridge
  
  services:
      mysqlexporter:
          image: prom/mysqld-exporter
          container_name: mysqld-exporter
          ports:
              - "9104:9104"
          environment:
              - TZ=Asia/Shanghai
              - DATA_SOURCE_NAME=exporter:exporter123@(192.168.109.3:3306)/
          networks:
              - monitor
  

  查看容器日志

  docker logs -f mysqld-exporter 
  
  time=2025-06-08T03:30:56.580Z level=ERROR source=config.go:141 msg="failed to validate config" section=client err="no user specified in section or parent"
  time=2025-06-08T03:30:56.580Z level=info msg="Error parsing host config" file=.my.cnf err="no configuration found"

问题分析

file=.my.cnf err="no configuration found"：无法找到配置文件 .my.conf。

此时因为compose配置了mysql信息参数，并没有配置.my.cnf，但是mysqld-exporter默认查找配置文件，因此挂在卷并添加配置信息

version: '3'
networks:
    monitor:
        driver: bridge

services:
    mysqlexporter:
        image: prom/mysqld-exporter
        container_name: mysqld-exporter
        ports:
            - "9104:9104"
        environment:
            - TZ=Asia/Shanghai
            - DATA_SOURCE_NAME=exporter:exporter123@(192.168.109.3:3306)/
        volumes:
            - ./.my.cnf:/.my.cnf
        networks:
            - monitor

vim .my.cnf

[client]
host=192.168.109.3
port=3306
user = exporter
password = exporter123

• docker-compose rm

• docker-compose up -d

• docker-compose ps
       Name               Command          State                    Ports                  
  -----------------------------------------------------------------------------------------
  mysqld-exporter   /bin/mysqld_exporter   Up      0.0.0.0:9104->9104/tcp,:::9104->9104/tcp
  

http://192.168.109.3:9104/metrics中显示：mysql_up 1