postgresql output support secretstores

[yoon-sunghyun-fnblock]

Use Case

telegraf.conf

[[secretstores.http]]
  id = "meta_conf"
  url = "http://localhost/meta/META_DB"

[[outputs.postgresql]]  
  connection = "host=@{meta_conf:host} port=@{meta_conf:port} user=@{meta_conf:user} password=@{meta_conf:password} sslmode=disable dbname=@{meta_conf:database}"

Expected behavior

Secretstores available in postgresql output

example>

http://localhost/meta/META_DB

{"host":"0.0.0.0","user":"postgres","password":"postgres","port":"5432","database":"postgres"}

Assuming the API is the above value, the value is stored in secretstores.

Actual behavior

The secretstores value is substituted into the setting value.

[[outputs.postgresql]]  
  connection = "host=0.0.0.0 port=5432 user=postgres password=postgres sslmode=disable dbname=postgres"

Additional info

No response

[powersj]

next steps: looking at adding this similar to other sql plugins. However, we would only land this once the secret store initialization change goes in to avoid impacting other plugins or users who are not using secret store.

[powersj]

@yoon-sunghyun-fnblock,

I have put up #15041 with the ability to use secret stores as a part of the connection option. Can you please give that a try and let me know if it resolves your request?

Thanks

[yoon-sunghyun-fnblock]

@powersj

Are you saying to use this to modify the source?

[powersj]

Hi @yoon-sunghyun-fnblock,

You can download artifacts that you can try out directly from this comment: #15041 (comment)

[yoon-sunghyun-fnblock]

@powersj

It's perfect. Confirmed that it is working properly. secretstores.http to receive information and use it for connection.
I appreciate it.