Markjdsmith Posted April 8, 2014 Share Posted April 8, 2014 Hi 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? cheers mark Link to comment Share on other sites More sharing options...
Solution marianol Posted April 9, 2014 Solution Share Posted April 9, 2014 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. MarianoLIf this answer your question remember to check it!! 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