Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Connect Apache Ant remotely to MySQL over SSH tunneling

Posted on 2011-09-28
2
Medium Priority
?
1,156 Views
Last Modified: 2013-11-10
A hosting provider I'm working with has port 3306 blocked for public access on their firewall, they recommend connecting to MySQL over ssh tunneling. This works fine for MySQL Workbench as it provides such functionality, but I'm trying to get a similar thing going with Apache Ant so I can automate restoring databases. I'm trying to figure out if I'm doing this correctly, from what I've read <sshsession> in Apache Ant 1.8.x provides tunneling. But I'm not sure whether to use localtunnel or remote tunnel and I'm not sure if I'll be able to even do what I want over a tunnel. Any suggestions?

<sshsession host="example.com" username="user" keyfile="${sshKeyLocation}" passphrase="password">
    <remotetunnel rport="3306" lhost="example.com" lport="3306"/>
    <sequential>
        <sql driver="com.mysql.jdbc.Driver" url="jdbc:mysql://example.com:3306/${databaseName}" userid="dbuser" password="dbpass">
            <transaction src="temp.sql"/>
        </sql>
    </sequential>
</sshsession>
0
Comment
Question by:level9wizard
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 24

Accepted Solution

by:
johanntagle earned 1500 total points
ID: 36813808
Maybe you can try it in two steps:

1.  Set up tunnel:

ssh -f example.com -L 3305:127.0.0.1:3306 -N

2.  Use 127.0.0.1:3305 in your connection string.

(Replace 3305 with whatever you want as the local port).

0
 
LVL 11

Author Closing Comment

by:level9wizard
ID: 36814530
Thanks, this lead me in the right direction. The actual code used with Ant (in case anyone else stumbles on this Q/A):

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<project name="Release Builder" default="release" basedir=".">
    <description><![CDATA[Release Builder]]></description>
   
    <!-- REQUIREMENTS: MySQL JDBC Driver, DatabaseNameParser, DomainFileName, jsch -->
   
   
    <!-- Configuration -->
    <property name="mysqlUser" value="root"/>
    <property name="mysqlPassword" value="xxxxxxx"/>
    <property name="sshKeyLocation" value="private.ossh"/>
   
    <!-- End Configuration -->
    <basename property="basedir.name" file="${basedir}"/>
   
    <target name="release" description="Release to the live server">
        <!-- Create the time stamp -->
        <tstamp/>
       
        <sshsession host="example.com" username="root" keyfile="${sshKeyLocation}" passphrase="xxxxxxxxxxxx" trust="true">
            <localtunnel rport="3306" rhost="example.com" lport="3305"/>
            <sequential>
                <sql driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3305/project_name" userid="zzzzzzz" password="xxxxxxx">
                    SELECT * FROM SiteTree LIMIT 1
                </sql>
            </sequential>
        </sshsession>
    </target>
</project>
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Introduction to Processes
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question