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@xxxxxxxxxxxxxxxxxxxxxxxxxxxx
> >>
> >> 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.
Matt
--
Matt Hyclak
Department of Mathematics
Department of Social Work
Ohio University
(740) 593-1263
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
