Jaspersoft Studio Data Adapter to AWS Jaspersoft Server

0

Hello Everyone,

I am new to Jaspersoft and I am running a Jaspersoft Server instance in AWS on a VPC. I have established a Server connection within Jaspersoft Studio but I was wondering how to configure a data adatper within Jaspersoft studio to connect to the sample foodmart DB on the Server from within Studio.

JDBC Driver: org.postgresql.Driver

JDBC URL: jdbc:postgresql://IP Address:5432/foodmart

Has anyone some pointer of how I need to configure this to make it work. My VPN is working and all firewall have been disabled and I still get a TCP/IP timeout error

Thanks

Carlos

cperez7's picture
Joined: Oct 30 2014 - 8:36am
Last seen: 1 year 6 months ago

1 Answer:

0

I'm not 100% sure; call it 95%. But the postgres instance inside the JasperServer AWS AMI which is where foodmart is stored is not configured to answer to external connections (for security reasons).

You will have to modify the postgres configuration in the AMI. In the Jasperserver AMI the path to the postgres config is "/var/lib/pgsql93/data" and you will need to be root to edit it (sudo) since the ec2-user does not have permission to read or write this file (or folder)

I found this links that will help you:
http://www.postgresql.org/docs/9.3/static/runtime-config-connection.html
http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connectio...

marianol's picture
4908
Joined: Sep 13 2011 - 8:04am
Last seen: 1 year 3 months ago
Feedback
randomness