Whitelisting IP Addresses for Database Connectors

To ensure secure and seamless connections between Lumenore and your database, you need to whitelist specific IP addresses. These addresses allow your server to communicate with various databases supported by Lumenore.

Whitelisted IPs

To enable access for Lumenore, whitelist the following IPs:

• 20.232.65.209/32
• 48.206.184.64/32
• 20.84.23.208/28
• 20.75.217.64/28
• 20.62.181.224/32
• 20.84.23.214/32
• 20.75.217.73/32

Supported Databases

Ensure these IPs are whitelisted for the following databases:

• MySQL
• PostgreSQL
• Oracle
• MS SQL Server
• Vertica
• Snowflake
• Greenplum
• Redshift
• MariaDB

Prerequisites

Before setting up a connection between your database and Lumenore, ensure the following prerequisites are met:

• Database Access Information: Make sure you have the necessary credentials (host, database name, port, username, and password) for the database you are connecting to.
• SSL Configuration: For databases like MySQL and PostgreSQL, make sure SSL is enabled to secure your connections.
• Database Firewall Configuration: You’ll need access to your database firewall or security group settings to whitelist the provided IP addresses.

Steps to Whitelist

1. Access Database Security Settings: Navigate to your database security settings, usually found in your firewall or security group rules (depending on your hosting provider).
2. Add IP Addresses: Add the IP addresses from the list under inbound rules for your database’s firewall settings.
3. Define Allowed Ports: Ensure the correct ports are open. For example:
   • MySQL: typically uses port 3306.
   • PostgreSQL: uses port 5432.
   • MS SQL Server: uses port 1433.
   • Other databases have their specific default ports, but you may need to confirm if custom ports are used.
4. Save Changes: Once the IP addresses are added, save the changes to your firewall rules.
5. Verifying Connection: After whitelisting, configure your data connector and test your database connection from Lumenore’s Data Center.

Why is Whitelisting Necessary?

Whitelisting these IPs ensures that Lumenore can securely query and retrieve data from your database. Without this step, your firewall may block essential communication, disrupting the data flow between your database and Lumenore.

Best Practices for Whitelisting

• Limit Exposure: Whitelist only the IPs provided to limit exposure to your database.
• Secure Connections: Always enable SSL where possible to ensure secure communication between Lumenore and your database.
• IP Configuration: Ensure no extra spaces or characters are mistakenly added when copying and pasting the IP addresses into the whitelist.

Troubleshooting Whitelisting Issues

• Connection Refused: If you encounter this error after whitelisting, ensure the IP addresses are correctly entered and the appropriate ports are open.
• SSL Errors: If you receive SSL errors, verify that the SSL certificates are properly configured on the database server.
• Firewall Issues: Ensure that your firewall or security group settings reflect the whitelisted IPs without misconfigurations.

Further Assistance

For additional support or if you have any issues setting up your whitelist, feel free to reach out to our “Lumenore Support Team” or refer to the specific documentation for each database for detailed setup instructions.