Jump to content
We've recently updated our Privacy Statement, available here ×

Jaspersoft AWS ssh connection to mysql

Go to solution Solved by marianol,

Recommended Posts



i've just provisioned a jaspersoft was using a cloud formation template as per instructions on the site


i am now trying to create a data source that connects to  mysql using ssh. The ui doesn't have any options for that


can anybody help?





Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

  • Solution

If I understad this correctly you want to do an SSH tunnel from your EC2 AWS Jasper intance to your MySQL database that is somewhere else in the cloud.

To do that you just need to create the tunnel at the OS lever and forward the port. For example mysql server is running on a remote machine and listening on let's say port 3306..

To create such a tunnel from port 1234 on your local machine to port 3306 on a remote machine using the command line ssh client, you would type the following command from your local machine:
ssh -L 1234:localhost:3306 mysql.server.remote
Tunnel is done!!! then you just configure your JasperServer datasource to point to "jdbc:mysql://localhost:1234/MyFancyDB"
Check the EMR connectivity form AWS the Option#2 described there uses a very similar method.
If this answer your question remember to check it!!


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