I'm currently involved in a project that requires the setup and configuration of numerous Ignition servers. Our setup process generally includes a consistent set of changes, like creating database connections, tag providers, and adjusting the gateway security settings.
I know that all these configurations are stored in the config.idb folder and found that corresponding tables reflect each setting. Having experimented with this, I noticed that changes made directly in these tables are then visible in the gateway webpage. This gave me the idea to automate this process further, possibly with a PowerShell script or a single query that would expedite the configuration with just a click.
Although this approach could save us a significant amount of time and minimize human error, I'm mindful of potential risks involved with directly updating the configuration database.
Given my experience, I would like to ask:
- What potential risks could be associated with this direct update approach?
- What precautions should we consider taking to mitigate these risks?
- Is there a recommended method or existing tools for automating Ignition gateway configurations?
- Are there specific tables or settings in the config.idb that should never be altered directly?