ETL - Change allowed IPs

When creating new internal databases in webmin, it is possible to provide single ips, ip-ranges and ip-subnets that are allowed to access the database.

Unfortunately it is not currently possible to change the ips afterwards via the webmin interface.

The procedure to change the allowed IP addresses for an ETL staging database is this:

• SSH to your server.

• Log into isxo DB:

  # sudo supsql isxo

• Retrieve your db name by executing:

  # SELECT database_name from external_server_configurations ;

• Find the database name you want to change the allowed IP addresses for.

• Change the allowed IP address by executing a statement like:

  # update external_server_configurations set external_ips = '10.0.0.0/8,192.0.0.0/8' where database_name='<database name found earlier>’;

• Change the IP range  '10.0.0.0/8,192.0.0.0/8' to what is needed. It can be just 10.0.0.0/8 or a single IP...etc

  You may find some help here

• Finally run this statement:

  # update etl_settings set ip=’10.0.0.0/8,192.0.0.0/8' where dbname='<database name found earlier>’;

• Now quit the psql console by typing: 

  \q (<enter>)

• Apply the configuration from the command prompt:

  # sudo /usr/sbin/Platform.pm update-access-files