duanditang2916 2016-06-10 16:27
浏览 161

Postgres错误在数据库上运行查询:无法检测默认用户名

Hi I am trying to monitor postgres SQL with Prometheus. For this purpose I am using this exporter https://github.com/wrouesnel/postgres_exporter

I am starting the exporter in my docker-compose.yml like this:

  exporter-postgres:
    image: wrouesnel/postgres_exporter
    ports:
      - 9113:9113
    environment:
      - DATA_SOURCE_NAME="postgresql://user:pass@localhost:5432/?sslmode=disable" 

When the exporter is trying to access the database errors like this are thrown:

Error running query on database: pg_stat_database pg: Could not detect default username. Please provide one explicitly. file="postgres-exporter.go" line=490

and

Error scanning runtime variable: pg_stat_database pg: Could not detect default username. Please provide one explicitly. file="postgres-exporter.go" line=464

I am not really sure what this message could mean. Also I am not really sure if the issues originates in my docker-compose file, or the exporter.

The lines which throw the error in the postgres-exporter.go are:

// Use SHOW to get the value
row := db.QueryRow(fmt.Sprintf("SHOW %s;", columnName))

var val interface{}
err := row.Scan(&val)
if err != nil {
    log.Errorln("Error scanning runtime variable:", columnName, err)
    continue
}

and

query, er := queryOverrides[namespace]
if er == false {
    query = fmt.Sprintf("SELECT * FROM %s;", namespace)
}

// Don't fail on a bad scrape of one metric
rows, err := db.Query(query)
if err != nil {
    log.Println("Error running query on database: ", namespace, err)
    e.error.Set(1)
    return
}

https://github.com/wrouesnel/postgres_exporter/blob/master/postgres_exporter.go

I am thankful for any help!

Edit:

Here is the connection to the database:

db, err := sql.Open("postgres", e.dsn)

Whereas e.dsn is generated like this:

dsn := os.Getenv("DATA_SOURCE_NAME")

The connection doesn't throw any error

  • 写回答

1条回答 默认 最新

  • dongxun6458 2016-06-11 13:17
    关注

    Hey for anyone having a similiar issue in the future:

    The problem was this line in the docker-compose.yml

     - DATA_SOURCE_NAME="postgresql://user:pass@localhost:5432/?sslmode=disable" 
    

    Changing it to

     - DATA_SOURCE_NAME=postgresql://user:pass@localhost:5432/?sslmode=disable
    

    (Without the quotes) made everything work :)

    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB怎么通过柱坐标变换画开口是圆形的旋转抛物面?
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿