Jump to content
Changes to the Jaspersoft community edition download ×

Jaspersoft Studio Data Adapter to AWS Jaspersoft Server


cperez7

Recommended Posts

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

Link to comment
Share on other sites

  • 1 month later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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-connection.html

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...