CentOS - Mar 2008 - SSH, SCP connections to remote MySQL Database using OpenOffice Possible?

I'm trying to find a way to get remote connections from my Linux Desktop
machine to a remote Linux box which is hosting a MySQL database, via SSH port
22, and then once connection is established, log in to the database port 3306
and have either an SSH and or SCP connection established so I can securely do
edits and queries.

I am able to connect this way from my Windows machine to remote server using
Navicat. Both the windows desktop and the server are set up this way. I just
can't figure out how to get my Linux desktop and the remote Linux box to
talk this way.

I can connect to the remote database via Linux desktop, it's just via an un
encrypted connection through port 3306. For obvious reasons I don't want to
do it that way.

I tried connecting to the remote database in the same way I use Konqueror for
FTP over SSH, i.e., by connecting via the fish protocol over port 22 -by
enterning into OpenOffice Base for the server URL: fish://user at
myservername.com:22 and the error that comes up in either OO Base or Calc said I
must specify a port number after the : , which I did, and it still won't
connect that way.

My question is, is OpenOffice Calc able to connect to remote databases via SSH
and or SCP? If so, do I need a plug in for that, or need to configure calc to do
that in some way? How would I do this, or which plug in(s) do I need?

_________________________________________________________________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008

On Mon, Mar 10, 2008 at 7:50 AM, Therese Trudeau <mswotr at hotmail.com>
wrote:
>  I can connect to the remote database via Linux desktop, it's just via
an un encrypted connection through port 3306. For obvious reasons I don't
want to do it that way.
>  My question is, is OpenOffice Calc able to connect to remote databases via
SSH and or SCP? If so, do I need a plug in for that, or need to configure calc
to do that in some way? How would I do this, or which plug in(s) do I need?
>
No, but what you could do is use an ssh tunnel to accomplish this.
Something along the lines of "ssh -L 3307:database.example.net:3306
database.example.net"

This will tell your system to tunnel the local port 3307 through the
database box, TO the database box on port 3306. From this point, after
you connect via ssh with the above command, you can simply point your
database software to the local 3307 port in plain text, and it'll
travel over ssh to the remote box.

I've probably done a bad job explaining this, so I'll go get some more
coffee.


-- 
During times of universal deceit, telling the truth becomes a revolutionary act.
George Orwell