data collection parameter substitution

I have the following JDBC data collection service defined in collectd-configuration.xml

      <service name="ABBCS-MSSql-acmetest" interval="300000" user-defined="false" status="on">
         <parameter key="collection" value="ABBCS-SQLServer"/>
         <parameter key="thresholding-enabled" value="true"/>
         <parameter key="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
         <parameter key="user" value="testuser"/>
         <parameter key="password" value="Passw0rd"/>
         <parameter key="timeout" value="120000"/>
         <parameter key="url" value="jdbc:sqlserver://testdb.database.windows.net:1433;databaseName=testdb;"/>
      </service>

But I would like to make this service definition not DB specific, and use place holder variables for "user", "password" and "url"

As far as I can work out, the only available substitutable parameter I can use is "OPENNMS_JDBC_HOSTNAME" which does not provide enough variability.  That is, I currently need to define 1 service per database with user, password and URL hardcoded into the service definition.

It would be ideal if I could have the user and password stored in an asset field, and either the entire URL string, or enough information that the URL could be derived from asset fields so that definition of a database would not require creating a new service definition.

It looks to me like issue NMS-10200<https://issues.opennms.org/browse/NMS-10200> potentially addresses this issue.  Can someone confirm if NMS-10200 will address my use case for a jdbc collection service?


Regards,
John

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss