Not able to connect MySQL hosted in AWS to skuid

Questions
1

I have created a MySql database in Amazon RDS. While trying to create a Data source configuration in Skuid, I am getting the following error - 

Unsuccessful.

Skuid could not connect to the Data Source.
Please check all configuration values and make sure the Data Source can be accessed from Skuid’s web servers in your region.

error

I have already white listed the Skuid IP addresses in security group.

2

Do you have SSL enabled on the Data Source?

3

I have granted SSL access to the database user, but Unfortunately since my Developer account has expired, I can not verify this :frowning:

There is no specific setting other than granting user SSL on the Mysql RDS instance in AWS.

GRANT SELECT ON mydatabase.* TO ‘myuser’@‘%’ IDENTIFIED BY ‘…’ REQUIRE SSL;

Once my developer environment is extended, I will go into the system and verify the same.

4

Ankur, can you send me your site’s subdomain? I can extend your developer trial.

5

https://bluebit-us-trial.skuidsite.com/

Thanks for your help on this, will respond once I test the same.

6

I’ve extended your trial. 

For your RDS AWS configuration, make sure that you’ve made the database publicly-accessible.

Also, maybe check the RDS logs to see if there are any errors there related to network connectivity.
And also click “Test Connection” in the Skuid Data Source configuration page, and check the Network Requests in Chrome’s Network Console, there may be some information in the “Response” to the network request to /ping that might be helpful.

7

Thanks for the extension, 
Using the Grant command worked, 

But skuid is not able to import any Data Source objects, neither it is able to create a Data Source Object when I am using the option Manually create a Data Source Object.

It is giving me the attached error. “Test Connection” is working successfully.

Thanks in advance for your help.

Regards,

8

There is currently a known issue with “Manually create Data Source Object” — we are working to address this.

You should be able to “Import Data Source Objects” though — try only importing Data Source Objects from one schema at a time.

9

Hi Zach,

I have a table in my schema, but the skuid interface does not show the table when I click on Import Data Source Objects.

In the screenshot, as you can see the table in the schema is visible in mysql workbench.
On the right, when I click Import Data Source objects, first it shows a popup, but when it shows the window - there are no tables visible.

When I am inspecting the skuid page on the network tab against “source-entity”  Response is “null”

I am wondering, if the table created needs to be of any specific encoding type ?
Currently the Table collation - latin1_swedish_ci

Thanks for your help in debugging this issue.


Regards,

10

@Zach

Any luck in figuring out the issue ?

Regards,
Ankur