On your Redshift Management Console, Click on your cluster to see its configuration details.
Under the Configuration section, you'll see the name of its security group, under VPC Security Group. Click it to modify the security group
This will list the security groups for your VPC. Click edit to modify the security group
Add an inbound rule for Ubiq (IP-126.96.36.199) and click save
The data connection form has the following fields:
Please ensure the host name, database name, user name, password & port are entered correctly before you click Connect. In case of issues, please don't hesitate to mail us as email@example.com. We surely reply within a few hours.
For SSL connections, you can connect your MySQL database hosted on Amazon Redshift to Ubiq with just 4 steps.
Access your Redshift Management Console.
Navigate to DB Security Groups from the left sidebar and select one of your security groups. A form for a CIDR will be presented. Paste the Ubiq CIDR: 188.8.131.52/32 into the form and click Add to add Ubiq to your security group. This will allow Ubiq to access your Redshift instance.
Note - If you are using the Amazon Virtual Private Cloud (VPC) you will need to setup an elastic IP to your Redshift instance so that it will be accessible outside the your VPC by the Ubiq servers.
Copy & update the following commands and paste them into a MySQL shell to create the user. Please replace the parts in bold below as per your requirement. This will create a read-only user that Ubiq can use to access your database.
CREATE USER $user@'184.108.40.206' IDENTIFIED BY '$password';
GRANT SELECT, SHOW VIEW
TO $user@'220.127.116.11' IDENTIFIED BY '$password' REQUIRE SSL;
Where $database_name, $user, and $password are the values you will be using in the form below. If your database name has spaces in it, please use the name within ``.
If you have configured your server to accept SSL connections, you can skip this step. Else, please confirm ssl support on your MySQL installation by typing in your shell:
If you have not added location of MySQL installation to PATH environment variable, you will need to navigate to bin subfolder at your MySQL installation location.
If you see something like [ERROR] mysqld: unknown option '--ssl' it means you need to upgrade your server. MySQL has supported SSL for quite some time so it should not really be a problem.
Please refer to Create SSL certificates to learn how to create SSL certificates.
When you click on Create Connection on the Data Sources tab, on project homepage, you will see the following form.
Select the type of database you want to create a connection for. The form has the following fields:
Please ensure the host name, database name, user name, password & port are entered correctly before you click Connect. On successful connection, you will see the data source listed under the Data Sources Tab. In case of issues, you will see an intuitive message on the screen.