Is This Possible

[Lucky Bastard]

Hi

I have just changed server and host and also ISP.

Unfortunately I can't get a dedicated IP with my ISP which means I can't access the server via SSH (host restrictions).

Well no problem I can do HTTP tunneling. I have got this setup and working – no problem.

HOWEVER, I had an added benefit before when I was able to SSH tunnel:

some old VB6 applications I wrote could pick up on the sqlgyog SSH tunnel and also access the remote server MySQl (via localhost) and query it (securely??).

Should it be possible (as an added benfit – I know it isn't a feature of sqlyog) for these VB6 applications to do the same with the HTTP tunnel?

Thanks!

[peterlaursen]

“some old VB6 applications I wrote could pick up on the sqlgyog SSH tunnel”

really the SQLyog SSH tunnel? You did not just create a romote SSH shell?

“.. possible for these VB6 applications to do the same with the HTTP tunnel?

The SQLyog executable and the tunneller file communicate using XML. The tunnneller will only work with the SQLyog compiled-in XML-parser. To write something similar yourself you should convince Ritesh that he publish all details of the XML-schema. I don't think you can …

[Lucky Bastard]

peterlaursen wrote on May 17 2006, 06:53 PM:

“some old VB6 applications I wrote could pick up on the sqlgyog SSH tunnel”

really the SQLyog SSH tunnel? You did not just create a romote SSH shell?

Yeah, I could do that too 🙂 But for the sake of my explanation I was wanting to highlight I could interface with the SSH tunnel in SQLyog. It would be cool if we could also interface in our own applications with SQLyogs HTTP tunnel when SQLyog is open and running on the computer. Is there any change of this guys?

I'm surpirsed there isn't such a product (even standalone) on the market which creates an HTTP tunnel to a server and on the local PC listens to “localhost” for any MySQL connections and tunnels them to the remote server via HTTP. Maybe a product idea for webyog? Wouldnb;t be hard seeing they already have the mysql http tunnel technology.

[peterlaursen]

This is very exiting, I think!

“if we could also interface in our own applications with SQLyogs HTTP tunnel when SQLyog is open and running on the computer.”

OK, SQLyog Enterprise must be installed and running, you say. Well, then it is no 'threat' and the 'secrets' remain inside SQLyog. What is needed is simply then a 'gate' in the program where external programs can 'throw' individual SQL-statements and have results returned. And that would then work with SSH, HTTP(s) and proxies as well.

To my best understanding implementation of that would only need the occupation of 1 or 2 ports for the communication and a very simple protocol. Maybe the existing HTTP-implementation can be used. And may even be possible to access it from a program running on another computer …

Wait for Ritesh to comment on that!

[Lucky Bastard]

peterlaursen wrote on May 18 2006, 01:39 AM:

This is very exiting, I think!

“if we could also interface in our own applications with SQLyogs HTTP tunnel when SQLyog is open and running on the computer.”

OK, SQLyog Enterprise must be installed and running, you say. Well, then it is no 'threat' and the 'secrets' remain inside SQLyog. What is needed is simply then a 'gate' in the program where external programs can 'throw' individual SQL-statements and have results returned. And that would then work with SSH, HTTP(s) and proxies as well.

Exactly, to our outside applications what happens in SQLYog stays in SQLYog. So no trade secrets are needed to be shared.

peterlaursen wrote on May 18 2006, 01:39 AM:

To my best understanding implementation of that would only need the occupation of 1 or 2 ports for the communication and a very simple protocol. Maybe the existing HTTP-implementation can be used. And may even be possible to access it from a program running on another computer …

Wait for Ritesh to comment on that!

Fingers crossed, this would be great if it could be implemented.

[peterlaursen]

Introducing the SCA = SQLyog Communication Agent 🙂

[Ritesh]

What he basically wants is the SSH/HTTP tunneling code compiled as library which he can then use it inside his product just as we use PUTTY with SQLyog.

This will require a separate product. Nice idea.

Added in the TO-DO list.

[peterlaursen]

I do not think that was the request:

He wrote:

“if we could also interface in our own applications with SQLyogs HTTP tunnel when SQLyog is open and running on the computer.”

I figured it as a 'powertool' opening a seperate window just like STRUCTURE SYNC does. Ideally the server side of the MySQL protocol should then be implemented here.

But both solutions are possible, I think

[Author]

Posts