Allow external connections to the database via the orchestrator

Proceed with caution

We do not recommend making any direct changes to the Opsview databases. Wherever possible, you should use the API instead.

Changes to the Opsview databases can irreparably damage your Opsview installation.

Always take appropriate backup precautions before making any direct changes to the Opsview databases.

All connections to the Opsview databases are routed through the opsview-loadbalancer component on the orchestrator. The load balancer does not accept outside connections by default. This article explains how to allow external connections to the database via the orchestrator.

Prerequisites Copied

• None

Process Copied

Nonpersistent changes

The following changes may not persist across runs of opsview-deploy. You may need to re-apply these changes each time you run opsview-deploy.

1. Log in to your orchestrator as root.
2. Open the file /opt/opsview/loadbalancer/etc/database-balance.cfg in your preferred text editor.
3. Change the line

bind 127.0.0.1:13306

to

bind 0.0.0.0:13306

4. Restart the opsview-loadbalancer component using opsview-monit:

/opt/opsview/watchdog/bin/opsview-monit restart opsview-loadbalancer