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 serv

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“ Befeh

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 matthi

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 abo

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 ge

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 not

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. C

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 t

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 connections.

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 Rubinstein

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 kind

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 additional

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, > > G

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 datab

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 W

Re: revOpenDatabase acting differently in IDE and standalone

On 5/2/13 8:19 PM, Peter Haworth wrote: I guess I'm a little surprised by that. There was a thread in November last year about this and some pretty enlightened experts on this list indicated that the format of a standalone had changed within the last year and it was no longer possible (OK, it's

Re: revOpenDatabase acting differently in IDE and standalone

I guess I'm a little surprised by that. There was a thread in November last year about this and some pretty enlightened experts on this list indicated that the format of a standalone had changed within the last year and it was no longer possible (OK, it's always possible!) to get at the scripts wi

Re: revOpenDatabase acting differently in IDE and standalone

yes, i missed that change. but my other comments still stand :) On 02.05.2013, at 21:56, stephen barncard wrote: > I think Mark Wieder stated that script limits are gone now. > > > On Thu, May 2, 2013 at 3:54 AM, Björnke von Gierke wrote: > >> >> On 02.05.2013, at 00:05, Peter Haworth wrote:

Re: revOpenDatabase acting differently in IDE and standalone

I think Mark Wieder stated that script limits are gone now. On Thu, May 2, 2013 at 3:54 AM, Björnke von Gierke wrote: > > On 02.05.2013, at 00:05, Peter Haworth wrote: > > > I don't think so - standalones are the same as any other executables, > they > > have compiled code in them, not scripts.

Re: revOpenDatabase acting differently in IDE and standalone

On 02.05.2013, at 00:05, Peter Haworth wrote: > I don't think so - standalones are the same as any other executables, they > have compiled code in them, not scripts. Just want to note that this is wrong, and standalones do contain all unencrypted scripts as clear text. They also contain field c

Re: revOpenDatabase acting differently in IDE and standalone

On Wed, May 1, 2013 at 2:11 PM, Mike Bonner wrote: > Another thought, (again 98% sure this isn't the issue but..) If the > standalone builder picks and chooses db support based on code it sees in > the stack, and if you are using a splash stack, or your db code is in a > substack/external stack,

Re: revOpenDatabase acting differently in IDE and standalone

On Wed, May 1, 2013 at 3:03 PM, Mike Bonner wrote: > Also, if its a splashstack type with a separate stack file the separate > file could be opened in the ide. > Right, forgot about that Pete lcSQL Software ___ use-livecode mail

Re: revOpenDatabase acting differently in IDE and standalone

On Wed, May 1, 2013 at 2:02 PM, Dr. Hawkins wrote: > Yes, but if I send it out without the password protection, anyone could > open it with the IDE, couldn't they? > I don't think so - standalones are the same as any other executables, they have compiled code in them, not scripts. Anyway, best

Re: revOpenDatabase acting differently in IDE and standalone

Also, if its a splashstack type with a separate stack file the separate file could be opened in the ide. On Wed, May 1, 2013 at 4:00 PM, J. Landman Gay wrote: > On 5/1/13 4:02 PM, Dr. Hawkins wrote: > >> On Wed, May 1, 2013 at 1:55 PM, Peter Haworth wrote: >> >> Maybe I'm misunderstanding the

Re: revOpenDatabase acting differently in IDE and standalone

On 5/1/13 4:02 PM, Dr. Hawkins wrote: On Wed, May 1, 2013 at 1:55 PM, Peter Haworth wrote: Maybe I'm misunderstanding the requirement here, but aren't you sending this application out as a standalone? If so the issue of password protecting the scripts is moot since it only applies to running

Re: revOpenDatabase acting differently in IDE and standalone

Dr. Hawkins writes: > > On Wed, May 1, 2013 at 1:04 PM, Mark Wieder wrote: > > > Ah. In that case, LC 5.5.4 is your friend. > > But you knew that already. > > > > But this *is* 5.5.4 that can't open a postgres database from a standalone! > > It doesn't have a problem with sqlite, though, and

Re: revOpenDatabase acting differently in IDE and standalone

Another thought, (again 98% sure this isn't the issue but..) If the standalone builder picks and chooses db support based on code it sees in the stack, and if you are using a splash stack, or your db code is in a substack/external stack, is it possible that the standalone builder is just not inclu

Re: revOpenDatabase acting differently in IDE and standalone

Hmm, based on the error you posted i'm sure this isn't the issue, but.. you aren't trying to open the postgres database in preopenstack are you? If so, externals loading may not yet be complete. On Wed, May 1, 2013 at 3:02 PM, Dr. Hawkins wrote: > On Wed, May 1, 2013 at 1:55 PM, Peter Haworth

Re: revOpenDatabase acting differently in IDE and standalone

On Wed, May 1, 2013 at 1:55 PM, Peter Haworth wrote: > Maybe I'm misunderstanding the requirement here, but aren't you sending > this application out as a standalone? If so the issue of password > protecting the scripts is moot since it only applies to running stacks in > the IDE. > Yes, but if

Re: revOpenDatabase acting differently in IDE and standalone

On Wed, May 1, 2013 at 1:04 PM, Mark Wieder wrote: > Ah. In that case, LC 5.5.4 is your friend. > But you knew that already. > But this *is* 5.5.4 that can't open a postgres database from a standalone! It doesn't have a problem with sqlite, though, and the IDE (both 6.x and 5.5.4) can open post

Re: revOpenDatabase acting differently in IDE and standalone

Dr Hawkins, Maybe I'm misunderstanding the requirement here, but aren't you sending this application out as a standalone? If so the issue of password protecting the scripts is moot since it only applies to running stacks in the IDE. Doesn't help with your revdatabaseopen problem though. Pete lcS

Re: revOpenDatabase acting differently in IDE and standalone

Richard- > That is *exactly* what I need to do Ah. In that case, LC 5.5.4 is your friend. But you knew that already. -- Mark Wieder mwie...@ahsoftware.net ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscr

Re: revOpenDatabase acting differently in IDE and standalone

On Tue, Apr 30, 2013 at 9:46 PM, Mark Wieder wrote: > Well, as has been mentioned before, you don't need to encrypt them > until you're ready to push them out into the wild. That is *exactly* what I need to do, and what I was able to do when using sqlite instead of postcript. These are demo an

Re: revOpenDatabase acting differently in IDE and standalone

Richard- Tuesday, April 30, 2013, 9:35:12 PM, you wrote: > I'm *trying* to get commercial 6.0.1, but all I've found so far is community. > I *absolutely* need commercial, as I need the stacks encrypted. Well, as has been mentioned before, you don't need to encrypt them until you're ready to pus

Re: revOpenDatabase acting differently in IDE and standalone

On Tue, Apr 30, 2013 at 7:59 PM, Mike Bonner wrote: > Sounds like something is up with the external for postgres standalone > building. You might look in the installation folder for LC 6+, find the > tools/runtime/windows/x86-32/externals folder, look at the file > externals.txt and see if it loo

Re: revOpenDatabase acting differently in IDE and standalone

Sounds like something is up with the external for postgres standalone building. You might look in the installation folder for LC 6+, find the tools/runtime/windows/x86-32/externals folder, look at the file externals.txt and see if it looks right, then also look in the database drivers folder and m

Re: revOpenDatabase server syntax

I tried this with my MS-SQL Server and it works after changing the port to 55999 put "192.168.178.67,55999" into aPrefs["DBServer"] put "myDB" into aPrefs["DBDatabase"] put "sa" into aPrefs["DBUser"] put "myPassword" into aPrefs["DBPassword"] put revOpenDatabase("ODBC","DRIVER=SQL Server;SERVER

Re: revOpenDatabase

You need to first create a new System DSN that is configured to connect to the database. http://www.interfaceware.com/manual/creating_odbc.html ~Roger On Apr 16, 2013 6:19 AM, "Mats Åström" wrote: > > > Has anyone used revOpenDatabase to connect to an MS SQL database? > I have been trying to op

Re: revOpenDatabase

Hallo Mats, the correct syntax for the SERVER part is Server= [protocol:]Server[,port] hope this helps Wolfgang Am 16.04.2013 12:19, schrieb Mats Åström: Has anyone used revOpenDatabase to connect to an MS SQL database? I have been trying to open an ODBC connection using this: put revOpenDa

Re: revOpenDatabase - can't connect

Right, and if your data has any value at all I would not do that. Something like 10.45.2.% might do the trick, but provider subnets are rarely classful, meaning the mask is either 255.0.0.0, 255.255.0.0, or 255.255.255.0. There is actually a bit more to it than that, but this is the general idea

Re: revOpenDatabase - can't connect

You can also enter wildcards. If you figure out the provider's subnet, just set it for a likely range, or get a fixed IP from your provider if they provide it. Frankly though, I think using remote SQL makes sense only for development. Knowing what I know, I don't think I would ever deploy an ap

Re: revOpenDatabase - can't connect

If i remember right in that case you could enter %.%.%.% as a wildcard ip address, but this would accept connections from every ip address. Regards, Matthias Am 14.08.2012 um 14:30 schrieb Martin Koob : > Also with on-rev and cPanel when you enable remote access you specify the IP > addres

Re: revOpenDatabase - can't connect

Also with on-rev and cPanel when you enable remote access you specify the IP address you will be connecting from. If your service provider changes your IP address then you have to go into cPanel and change the IP address for remote access to the new one. Martin -- View this message in contex

Re: revOpenDatabase - can't connect

If this is an On-Rev SQL database, you have to enable remote access to the database, and then define which IP addresses you are allowed to connect remotely from. Bob On Aug 13, 2012, at 3:04 PM, Dan Friedman wrote: > Greetings! > > I am trying to connect to a mySQL database on a couple of r

Re: revOpenDatabase - can't connect

Hi Dan, Although it looks like you can access your database directly, you might want to check with the hosting company that this is meant to be possible. Try creating a new database user in CPanel (if that's what you use) and make sure it has the right permissions. Which version of Revolutio

Re: revOpenDatabase - can't connect

Dan, most server do not allow remote access for security reasons. Only access from local scripts are allowed in that case. So you have to check if you can enable remote db access on that servers. Regards, Matthias Am 14.08.2012 um 00:04 schrieb Dan Friedman : > Greetings! > > I am trying to

Re: revOpenDatabase Problem

Yes you will get an error if you send a query using this construct: put "SELECT TRUE as CONNECTED" into theSQL try put revDataFromQuery(,,tConnectionID,theSQL) into myResult catch theError answer theError exit to top end try -- myResult now equals 1 Call something like this right after yo

Re: revOpenDatabase Problem

All good stuff but none of it tells me if I've opened an sqlite database :-) You may have missed the post about opening the file as a regular file and checking the first 16 bytes - that's the solution I used, seems to work just great. On Tue, Dec 27, 2011 at 9:35 AM, Bob Sneidar wrote: > After

Re: revOpenDatabase Problem

After opening it, and inside a try/catch statement just use select TRUE as connected and get the query as a string. If it throws an error you know something is wrong. One thing I like to do in database driven apps is create handlers called dbopen, dbclose, dbIdle isConnected. In those handlers

Re: revOpenDatabase Problem

Thanks Andre and Mike. Mike - thanks for the link. You're right, that works just fine. First 16 characters must be "SQLite format 3" plus a nul if it's an SQLite file. LC probably ought to be checking for that but that's OK. On Mon, Dec 26, 2011 at 2:09 PM, Mike Bonner wrote: > Here, look he

Re: revOpenDatabase Problem

Here, look here under 1.2 database header. http://www.sqlite.org/fileformat2.html Looks like the first 16 bytes of the header are what you are looking for which are of course the first 16 bytes of the file. Should be quick and easy to grab those bytes and determine if the file is sqlite or not.

Re: revOpenDatabase Problem

Pete, Try the following query: SELECT name FROM sqlite_master WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%' UNION ALL SELECT name FROM sqlite_temp_master WHERE type IN ('table','view') ORDER BY 1 It should return the tables in the database, if there are no tables, then, there is so

Re: revOpenDatabase Problem

Hmm. don't have time to test it right this sec, but isn't an sqlite file pretty much a regular old text file? If so, it might be possible to open for read, read the first however much and check the file for validity. (even if its binary, surely there is a way to determine if its really an sqlite fi

Re: revOpenDatabase Problem

I think that's probably true. I'm trying to figure out how to to tell if a real sqlite database was opened. The first access to the db fails but the error is "Undefined SQLite error" which is not very specific! This is in an app where the user can select an sqlite db so I'm at the mercy of what

Re: revOpenDatabase Problem

My guess is that it doesn't check for a valid schema/format but that it is only establishing a file handle which is successful. Then it should fail with an error on actual attempt to use. On Mon, Dec 26, 2011 at 2:33 PM, Pete wrote: > Using revOpenDatabase to open an sqlite database using a file