cperez7 Posted March 18, 2015 Share Posted March 18, 2015 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.DriverJDBC URL: jdbc:postgresql://IP Address:5432/foodmartHas 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 errorThanksCarlos Link to comment Share on other sites More sharing options...
marianol Posted April 27, 2015 Share Posted April 27, 2015 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now