Re: SSH, SCP connections to remote MySQL Database using OpenOffice Possible?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



on 3-10-2008 1:33 PM Therese Trudeau spake the following:

----------------------------------------
Date: Mon, 10 Mar 2008 15:12:31 -0400
From: hyclak@xxxxxxxxxxxxxx
To: centos@xxxxxxxxxx
Subject: Re:  SSH,	SCP connections to remote MySQL Database using OpenOffice Possible?

On Mon, Mar 10, 2008 at 03:08:19PM -0400, Therese Trudeau enlightened us:
----------------------------------------
Date: Mon, 10 Mar 2008 13:27:28 -0400
From: hyclak@xxxxxxxxxxxxxx
To: centos@xxxxxxxxxx
Subject: Re:  SSH,	SCP connections to remote MySQL Database using OpenOffice Possible?

On Mon, Mar 10, 2008 at 12:38:34PM -0400, Therese Trudeau enlightened us:
 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.
Hehe THANKS Jim I need some too!

So when I "ssh -L 3307:database.example.net:3306", am I doing this via terminal prior to connecting with Calc (or base),
then start up base and enter in just the regular database.example.net into the "Server URL" field in Clac or base?

Or do I need to enter "ssh -L 3307:database.example.net:3306" just once in to the "Server URL" FIeld from within OpenOffice Calc or VBase?
You should enter localhost:3307. That connects to the local end of your SSH
tunnel.
OK this is what I tried - I opened up terminal on my local desktop machine, and I issued the command:  ssh -L 3307:domain.name.of.DesktopLocalMySQLserver:3306 username-d7gQ9grfmP7uf9qcbqpnZGC4GVmHw8X4ZSToKVHwfNc@xxxxxxxxxxxxxxxx

Then I started up OpenOffice Calc, clicked on File>New>Database, and in the area where it asks for the "ServerURL", I entered in:  localhost:3307 and just below it where it asks for the port number I also entered in 3307 (the default is 3306).

The error I got was "Illegal Connection Port Value 3307:3307: and I could not connect.
I think what you really want is
ssh -L 3307:localhost:3306 remote.db.server

The host in the middle is relative to the end machine. You could also
probably do
ssh -L 3307:remote.db.server:3306 remote.db.server

(for that matter, I don't see why you couldn't do ssh -L 3306:... as long as
you don't have mysql running on your desktop)
OK so you are saying to enter into Terminal, either: ssh -L 3307:localhost:3306 remote.db.server , OR enter into Terminal: ssh -L 3307:remote.db.server:3306 remote.db.server and substitute in my remote server address for "remote.db.server"
Once I do that, what should I enter into the OpenOffice Calc Spreadsheet Application Dialog box, in order to get the OpenOffice Calc local applicationwhich resides on my desktop
machine to read the remote database?

Correct, that *should* work.

Sadly I can't get OpenOffice Calc to connect that way, I keep getting those �Illegal Connection Port Value 3307:3307� errors from Calc when I enter in �localhost:3307� into Calc open new database box.
_________________________________________________________________
If there is a separate port dialog box, don't put the port in twice. IE... In serverurl put localhost and in port put 3307.



--
MailScanner is like deodorant...
You hope everybody uses it, and
you notice quickly if they don't!!!!

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux