Question & Answer > View Question

Can't achieve external JDBC access to MySQL from Joget cloud.

Confluence User - 23 Aug, 2016

I am on the Joget cloud hosted server.

Within the Datalist Builder I have set up the parameters Custom Datasource, com.mysql.jdbc.Driver, jdbc:mysql://cyberacc.cs9dyg1kikp3.us-east-1.rds.amazonaws.com/loveinc?characterEncoding=UTF8 (My AWS RDS URL), My MySQL Username, My MySQL Password, A valid SQL SELECT Query and the field name of the Primary Key. I have opened the AWS RDS firewall for 54.193.24.224/32 per a lookup on the Joget cloud server.

However, when I Test Connection, I get the popup "Not able to establish connection. Could not create connection to database server."

What am I missing?

Thanks!

datalists

2

Confluence User •

31 Aug, 2016 •

confluenceUser •

•

confluenceUser •

The Joget cloud server is probably restricting access database connections for security reasons. Instead of direct database calls, you could try to expose your database calls through an API http://programmers.stackexchange.com/questions/170463/why-to-use-web-services-instead-of-direct-access-to-a-relational-database-for-an

Confluence User •

09 Jul, 2019 •

confluenceUser •

•

confluenceUser •

No, it sounds more like your AWS security group does not allow access from JoGet cloud server IP. You could create a special security group for your RDS instance that allows access from all IP, but that's not recommended. Wouldn't hurt to test the theory. It would be better for Joget to publish this information.

1

CSV | Excel | XML | PDF

Your answer

Print

Can't achieve external JDBC access to MySQL from Joget cloud.

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-0fe821c6-7465-42cb-8642-5f7afde674d9{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-f07c7f83-41bd-4ba8-b36e-e67d81f396c4{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer