I want to add multiple entries in my environment variable and then pass them into my logstash jdbc connection string. When I do that it reads all the values in my variable at once and then fails with my connection attempt - is there a way around this?
The intention is to have this logstash input section run across multiple servers and the environment variable be dynamically read in. I have about 300+ servers which I need to run this against thus it is vital to have the servername in my connection string populated with a list.
Example below:
This is how I set my variable, this works fine if I only have one server in the list:
export ENV_NAME="servername1,servername2"
Config file (not sure why my Dollar signs are being removed):
"jdbc:sqlserver://${ENV_NAME};user=secretuser;password=${ES_PWD}"