I get the following error when trying to create a data source connecting to an RDS Database (MYSQL)
Connection failed: Exception occurred during AWS data source recovery: /organizations/organization_1/datasources/databasename. The vpc ID 'vpc-050xxxxxx' does not exist
The instance was created with the cloud formation stack as recommended
Can anyone show me where I am going wrong?
Hi Pete - I don't have quite enough information to help you troubleshoot, so I'll start with a few helpful links in case you haven't found them already. If the problem persists, please write back with the details of your data source type. Omit things like your password, of course.
Connect to AWS Data Sources wiki article and connection best practices video: http://community.jaspersoft.com/jaspersoft-aws/connect
FAQ: Can I connect to on-premise databases?: http://community.jaspersoft.com/wiki/jaspersoft-bi-aws-frequently-asked-questions#Can_I_connect_to_on-premise_databases
Hi Mary - I had read the wiki & watched the best practices video but thanks for the note,
The Jaspersoft instance was loaded using the cloud formation stack as recommended in the launch video and the database created in the same account
RDS database is MYSQL
Data Source in Jaspersoft is of type 'AWS Data Source'
The AWS Settings are 'Use EC2 Credentials'
The database is listed in the AWS DataSource under Amazon RDS
The database driver is 'com.mysql.jdbc.Driver'
when I try to test the connection I get the' VPC ID does not exist error'.
I just installed Jasper, I had also the database in RDS (MYSQL) created, and I had not way to connect both instances to work together.
I have no idea what I did wrong, ....
@Ogavaka, when you say "By your error i can say - your database is inside of VPC.", I assume I can create a RDS MYSQL DB outside the VPC.... but how? I am deploying the application in AWS Sao Paulo.....
I tried the second option installing Jasper through the console.... not luck...
DO you have some troubleshooting guide for this issue? I do not get to make it work....