Re: revOpenDatabase over SSH tunnel?

I can't speak for most of the world, but in the past where we've directly connected to MySQL over the internet that's always been limited by IP (which as you doubtless know is built-in to the permissions system). The difference for me in this case is that instead of talking to a dedicated

Re: revOpenDatabase over SSH tunnel?

matthias wrote: > As more and more servers do not allow remote MySQL access due to > security restrictions... It's almost like experienced hosting vendors and even the MySQL team itself are trying to tell us something... How does most of the world outside of the LC community handle remote DB

Re: revOpenDatabase over SSH tunnel?

Danke. ;) > Am 10.03.2022 um 23:00 schrieb Niggemann, Bernd via use-livecode > : > > There are two sentences in german: > > Folgenden Befehl in der Kommandozeile des Win10 PCs ausführen: > > Run the following command on the command line of the Win10 PC: > > > > Bei dem „Vordergrund“

Re: revOpenDatabase over SSH tunnel?

There are two sentences in german: Folgenden Befehl in der Kommandozeile des Win10 PCs ausführen: Run the following command on the command line of the Win10 PC: Bei dem „Vordergrund“ Befehl, sieht man nur einen blinkenden Cursor. Bei dem „Hintergrund“ Befehl erscheint ein neuer Prompt. With

Re: revOpenDatabase over SSH tunnel?

Here's a link to the english version of the instructions. If you find wrong expression or wrong grammar please let me know, so i can fix it. https://dl.qck.nu/?dl=SSH_Port_Forwarding.pdf Regards, Matthias > Am 10.03.2022 um 16:51 schrieb

Re: revOpenDatabase over SSH tunnel?

bob blipped, > Livecode currently can only send one statement per query to *any* sql server, > at least that is what I have come to understand. Trust me, I send a single transaction of several hundred SELECT every time I open a debtor “file”. Not being able to do updates as a block, though,

Re: revOpenDatabase over SSH tunnel?

I do not think this is a mySQL issue. Livecode currently can only send one statement per query to *any* sql server, at least that is what I have come to understand. But I do not think issuing many queries from livecode is the bottleneck, but rather the ability of the SQL server to respond. When

Re: revOpenDatabase over SSH tunnel?

I dropped mysql after the first run with my software—I don’t know if mysql could have handled it at the time, but LiveCode could only send a single command per transaction (afaik, this is still the case). And with several hundred transactions to start a session . . . (there were also issues

Re: revOpenDatabase over SSH tunnel?

This is very interesting. My issue with mySQL is that I am running on a Windows 7 box, and there is no support for SSH in the Oracle version (or there wasn't last time I checked.) There *are* builds that do support it, but the weeds in that swamp are thick, and after several days of trying to

Re: revOpenDatabase over SSH tunnel?

You are right. You invoke the SSH in a terminal on that machine that shall communicate with the MySQL database on a remote server. LC then connects to itself (127.0.01) using the port you've used in the command for ssh connection, in my example 6102. That's it. As more and more servers do

Re: revOpenDatabase over SSH tunnel?

Yes, my case is that the database is on a hosted platform which only supports access over SSH. My reading of your document, Matthias, is that we simply invoke SSH in a terminal, and then LiveCode/revOpenDatabase uses that tunnel automatically because the database host is at the same address.

Re: revOpenDatabase over SSH tunnel?

Yes, the server agent part resides on the same device that the SQL Server is on. The server agent communicates directly with the SQL server, and is responsible for making and storing connection specifics. The client agent can request a list of connections from the server agent when it connects

Re: revOpenDatabase over SSH tunnel?

There is nothing wrong with your method. But there might be situations where you need direct access to the MySQL database, e.g. you are using 3rd party software (in my case SQLPro Studio) or libraries. I have a customer who is using a special Delphi library that only supports direct

Re: revOpenDatabase over SSH tunnel?

Google translate is pretty capable and can do whole web pages. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com On March 10, 2022 9:54:47 AM Ben Rubinstein via use-livecode wrote: Hi Matthias, That is (a) good news and (b) very kind!

Re: revOpenDatabase over SSH tunnel?

Great, thank you. Ben On 10/03/2022 16:07, matthias rebbe via use-livecode wrote: Ben, i've sent it to you. If there are questions regarding macOS, just ask. I will post a link to the updated english version here in the list. Regards, Matthias Am 10.03.2022 um 16:52 schrieb Ben

Re: revOpenDatabase over SSH tunnel?

I am not sure what SSH tunneling is, but I did a proof of concept where I had an LC client app communicating with an LC server app that encrypted the data at the client end before sending it, and the server end decrypted it. I just used non-secured sockets. I used AES encryption with a key only

Re: revOpenDatabase over SSH tunnel?

Ben, i've sent it to you. If there are questions regarding macOS, just ask. I will post a link to the updated english version here in the list. Regards, Matthias > Am 10.03.2022 um 16:52 schrieb Ben Rubinstein via use-livecode > : > > Hi Matthias, > > That is (a) good news and (b) very

Re: revOpenDatabase over SSH tunnel?

Hi Matthias, That is (a) good news and (b) very kind! Or if it's easier, I have a German colleague - less technical skills, but excellent language skills - if you sent me the guide in German, I could ask her to have a go at translating it. (I'd still be very interested in the macOS

Re: revOpenDatabase over SSH tunnel?

Yes of course. I will post a link to it here in the list. If time allows i will also create a Livecode Lesson. Matthias > Am 10.03.2022 um 16:45 schrieb Glen Bojsza via use-livecode > : > > I would be interested in this guide if possible. > > Will you be willing to share? > > regards, > >

Re: revOpenDatabase over SSH tunnel?

I would be interested in this guide if possible. Will you be willing to share? regards, Glen On Thu, Mar 10, 2022 at 10:32 AM matthias rebbe via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi, > > I've used SSH tunneling in the past to connect SQLPro Studio with remote > MySQL

Re: revOpenDatabase over SSH tunnel?

Hi, I've used SSH tunneling in the past to connect SQLPro Studio with remote MySQL databases, but never with LC. And although i was pretty sure that it will work with LC, i just did a quick test with LC to be 100 percent sure. Yes it's possible. I have created a small quick start guide for

revOpenDatabase over SSH tunnel?

I need to access a (MySQL) database on a remote service - which has to be done over an SSH tunnel. Has anyone done this in LiveCode? Is it trivial/possible/impossible? TIA, Ben ___ use-livecode mailing list use-livecode@lists.runrev.com Please