Re: Paste no closeField

[Bob Sneidar via use-livecode]

It only works with fields whose name begins with "fld" (damn you spell correct!)

Bob S


> On Mar 10, 2022, at 14:53 , Bob Sneidar via use-livecode 
>  wrote:
> 
> It only works with fields whose name begins with "old" 


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Paste no closeField

[Bob Sneidar via use-livecode]

hi all. 

I have been seeing that when pasting text into a field then exiting the field, 
closeField is not getting sent to that field. Here are a couple handlers for 
your frontScript to deal with that. It only works with fields whose name begins 
with "old" otherwise this would trigger the script editor field and editable 
datagrid fields, and really slow things down. 

/*
If a user pastes something into a text field, then leaves the field, closeField 
is not triggered. These two handlers 
are the workaround for that. Only fields beginning with "fld"  are considered. 
*/
on openField
   put long id of the target into pField
   if char 1 to 3 of the short name of pField is not "fld" then \
 pass openField
   set the savedtext of pField to the text of pField
   pass openField
end openField

on exitField
   put the long id of the target into pField
   if char 1 to 3 of the short name of pField is not "fld" then \
 pass exitField   
   if the text of pField is not the savedtext of pField then \
 dispatch closeField to pField
   set the savedtext of pField to empty
   pass exitField
end exitField

Bob S
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: use-livecode Digest, Vol 222, Issue 8

[doc hawk via use-livecode]

jacqui jawed,


>  filter tHugeDict without regex pattern "[qkxyz]”

I expect that would be faster.

But it will also bring words that are too long, although I have no idea whether 
or not there would be enough to matter.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[matthias rebbe via use-livecode]

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“ Befehl, sieht man nur einen blinkenden Cursor. Bei dem 
> „Hintergrund“ Befehl erscheint ein neuer Prompt.
> 
> With the "Foreground" command, you only see a flashing cursor. With the 
> "Background" command, a new prompt appears.
> 
> (Automatic translation courtesy MacOs)
> 
> Kind regards
> Bernd
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[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“ Befehl, sieht man nur einen blinkenden Cursor. Bei dem 
„Hintergrund“ Befehl erscheint ein neuer Prompt.

With the "Foreground" command, you only see a flashing cursor. With the 
"Background" command, a new prompt appears.

(Automatic translation courtesy MacOs)

Kind regards
Bernd
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[matthias rebbe via use-livecode]

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 matthias rebbe via use-livecode 
> :
> 
> 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,
>> 
>> 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 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 Windows some weeks ago, but
>>> unfortunately that is in German.
>>> 
>>> I could translate that to English and add some additional information for
>>> macOS. But it would take 1 or 2 days.
>>> 
>>> If you could wait i could send you that guide.
>>> 
>>> Regards,
>>> 
>>> Matthias
>>> 
 Am 10.03.2022 um 12:34 schrieb Ben Rubinstein via use-livecode <
>>> use-livecode@lists.runrev.com>:
 
 
 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 visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
>>> 
>>> 
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Speed up a slow loop

[J. Landman Gay via use-livecode]

On 3/9/22 5:09 PM, Alex Tweedly via use-livecode wrote:


  - you can reuse the same tile later in a word (e.g.
Y  L  A
X  E  T

would allow "lately" as a word.

OR

- you can double-up on a tile (e.g. M I L would allow 'mill')
(more important if you're British than if you're American :-)


That's CHEATING! :) But while I've been testing I thought of a way I'd like to play. You can 
get credit for a made-up word if you can supply a clever enough definition for it that the 
other players agree is good enough.


Something like these neologisms (winners in the 2005 neologism contest,) only not real words 
like these are:


1. Coffee (n.), the person upon whom one coughs.
2. Flabbergasted (adj.), appalled over how much weight you have gained.
3. Abdicate (v.), to give up all hope of ever having a flat stomach.
4. Esplanade (v.), to attempt an explanation while drunk.
5. Willy-nilly (adj.), impotent.
6. Negligent (adj.), describes a condition in which you
absentmindedly answer the door in your nightgown.
7. Lymph (v.), to walk with a lisp.
8. Gargoyle (n.), olive-flavored mouthwash.
9. Flatulence (n.) emergency vehicle that picks you up after you are
run over by a steamroller.
10. Balderdash (n.), a rapidly receding hairline.
11. Testicle (n.), a humorous question on an exam.
12. Rectitude (n.), the formal, dignified bearing adopted by
proctologists.
13. Pokemon (n), a Rastafarian proctologist.
14. Oyster (n.), a person who sprinkles his conversation with Yiddishisms.
15. Frisbeetarianism (n.), the belief that, when you die, your Soul
flies up onto the roof and gets stuck there.
16. Circumvent (n.), an opening in the front of boxer shorts worn by
Jewish males


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

[Mark Wieder via use-livecode]

On 3/10/22 08:26, Ben Rubinstein via use-livecode wrote:
Thanks Panos, that gave me the clues I needed to get the other ones as 
well.


Can confirm the app is now running on Ubuntu 18.04.2 LTS.


Wow... woke up to a lot of emails this morning.
I'm running the latest LC builds on the latest linux mint which is based 
on Ubuntu 20.


So you should be fine as long as you don't need printing or browsers or 
the new chart widget or...


--
 Mark Wieder
 ahsoftw...@gmail.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: use-livecode Digest, Vol 222, Issue 8

[J. Landman Gay via use-livecode]

On 3/9/22 3:42 PM, doc hawk via use-livecode wrote:

Something like


^[manl]\{2,5\}$

which matches all strings of length 2 to 5 composed exclusively of the letters m, 
a, n, & l ?


I want to eliminate all words contains any of the letters in the group. I didn't get 
confirmation that my regex is correct but it seems to work:


  filter tHugeDict without regex pattern "[qkxyz]"

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[doc hawk via use-livecode]

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, could give me inconsistencies 
if I could have both failures and successes in the same set, to the point of 
having to pack my bags and go home.


> But I do not think issuing many queries from livecode is the bottleneck, but 
> rather the ability of the SQL server to respond.

I happened to have a notable latency at  the time, which made things far worse. 
 But when you have a great many, you have a built in 2n*latency lag, even if 
the transactions themselves took no time.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[Bob Sneidar via use-livecode]

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 I use 
memory databases, the response time is nearly nil. A single mySQL query over a 
LAN is not even noticeable. I make maybe 15 or so queries every time I select a 
new customer in my Forms Generator app, and it isn't the queries that slow 
things down, it's the populating of the datagrids and fields that take time. 

Now on Windows, I think I do experience some delays with queries, but I think 
that is just Windows networking security overhead. 

Bob S


> On Mar 10, 2022, at 11:37 , doc hawk via use-livecode 
>  wrote:
> 
> 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 about 
> lack of actual rollback).
> 
> I switched to postgresql, which can trivially connect remotely.  
> Unfortunately, even though the option is there in the command, and Postgres 
> supports it, livecode still can’t do an encrypted connection to a postgres 
> server.
> 
> If I were going to continue, I suppose I would do it through an https 
> connection to the server, possibly encrypting before sending and letting the 
> server decrypt.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

[doc hawk via use-livecode]

Gosh, I never got *any* version of 6 to work well enough to use!

:)

There’s still switches in my code for 5, but there are enough other uses of 
later features of 7+ that it’s a non-issue.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[doc hawk via use-livecode]

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 about 
lack of actual rollback).

I switched to postgresql, which can trivially connect remotely.  Unfortunately, 
even though the option is there in the command, and Postgres supports it, 
livecode still can’t do an encrypted connection to a postgres server.

If I were going to continue, I suppose I would do it through an https 
connection to the server, possibly encrypting before sending and letting the 
server decrypt.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[Bob Sneidar via use-livecode]

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 get that working I 
gave up. 

Bob S


> On Mar 10, 2022, at 10:55 , matthias rebbe via use-livecode 
>  wrote:
> 
> 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 allow remote MySQL access due to security 
> restrictions, SSH tunneling or a solution like the one Bob has created are 
> the only way. Whereby the SSH tunneling would allow a real direct 
> communication. Which one is better, i do not know. It depends on the needs of 
> the customer and also what software is available.
> 
> 
> 
> 
>> Am 10.03.2022 um 19:11 schrieb Ben Rubinstein via use-livecode 
>> :
>> 
>> 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. Can that be right? Or does 
>> this only work with LiveCode server?
>> 
>> Ben
>> 
>> On 10/03/2022 16:42, matthias rebbe via use-livecode wrote:
>>> 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.
>>> Okay that is not the case when using Livecode. But there might be servers 
>>> that do not run Livecode Server. In this case you cannot use your solution.
>>> In this case SSH tunneling would be a safe solution.
 Am 10.03.2022 um 17:14 schrieb Bob Sneidar via use-livecode 
 :
 
 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 
 I know, and a method for corrupting the data in a way only the server can 
 "cleanse".
 
 I suppose some may advise me on what is wrong with this method, and I 
 welcome the input, but it worked for me. No unencrypted data went "over 
 the wire".
 
 The reason I developed this method is because I do not want to deal with 
 expiring security certificates or secure websites to handle the data 
 transfer. The method works out of the box.
 
 Bob S
 
 
> On Mar 10, 2022, at 03:34 , Ben Rubinstein via use-livecode 
>  wrote:
> 
> 
> 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 visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
 
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your 
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your 
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

[Curry Kenworthy via use-livecode]

(P.S. I already employ new features or syntax
only supported in v9.x and up, but that means
maintaining a small bit of branched 6/9 code.

Like to move beyond that eventually, but no rush;
whatever people need!)

Best wishes,

Curry K.

===

Richmond:

What do you mean when you write "I'm still supporting LC 6.7"?


Bob:

I believe he means that utilities he creates will still function
when used with 6.7, but wouldn't if he employs new features
or syntax only supported in v9.x and up.


Me:
> Correct! "I'm still supporting LC 6.7" for my Addons:
> WordLib, WordOut, SpreadLib, WordReport, FieldTrip, etc.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

[Curry Kenworthy via use-livecode]

Richmond:
> What do you mean when you write "I'm still supporting LC 6.7"?

Bob:
> I believe he means that utilities he creates will still function
> when used with 6.7, but wouldn't if he employs new features
> or syntax only supported in v9.x and up.

Correct! "I'm still supporting LC 6.7" for my Addons:
WordLib, WordOut, SpreadLib, WordReport, FieldTrip, etc.

Best wishes,

Curry Kenworthy

WordLib: Import MS Word and OpenOffice files in LiveCode!
"Dominate documents with WordLib and LC"
http://livecodeaddons.com/wordlib.html

Innovative Christian LiveCode Training and Consulting
"Better Methods, Better Results"
http://livecodeconsulting.com/

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[matthias rebbe via use-livecode]

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 allow remote MySQL access due to security 
restrictions, SSH tunneling or a solution like the one Bob has created are the 
only way. Whereby the SSH tunneling would allow a real direct communication. 
Which one is better, i do not know. It depends on the needs of the customer and 
also what software is available.




> Am 10.03.2022 um 19:11 schrieb Ben Rubinstein via use-livecode 
> :
> 
> 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. Can that be right? Or does 
> this only work with LiveCode server?
> 
> Ben
> 
> On 10/03/2022 16:42, matthias rebbe via use-livecode wrote:
>> 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.
>> Okay that is not the case when using Livecode. But there might be servers 
>> that do not run Livecode Server. In this case you cannot use your solution.
>> In this case SSH tunneling would be a safe solution.
>>> Am 10.03.2022 um 17:14 schrieb Bob Sneidar via use-livecode 
>>> :
>>> 
>>> 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 I 
>>> know, and a method for corrupting the data in a way only the server can 
>>> "cleanse".
>>> 
>>> I suppose some may advise me on what is wrong with this method, and I 
>>> welcome the input, but it worked for me. No unencrypted data went "over the 
>>> wire".
>>> 
>>> The reason I developed this method is because I do not want to deal with 
>>> expiring security certificates or secure websites to handle the data 
>>> transfer. The method works out of the box.
>>> 
>>> Bob S
>>> 
>>> 
 On Mar 10, 2022, at 03:34 , Ben Rubinstein via use-livecode 
  wrote:
 
 
 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 visit this url to subscribe, unsubscribe and manage your 
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
>>> 
>>> 
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your 
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

[Richmond Mathewson via use-livecode]

Aha. Thick types like me need things to be made explicit.

Richmond.

On Thu, 10 Mar 2022, 20:51 Bob Sneidar via use-livecode, <
use-livecode@lists.runrev.com> wrote:

> I believe he means that utilities he creates will still function when used
> with 6.7, but wouldn't if he employs new features or syntax only supported
> in v9.x and up. Eventually he would consider ONLY supporting 9.x and up,
> and wants to get an idea of how many people would still need 6.7 support.
>
> Bob S
>
>
> > On Mar 10, 2022, at 10:33 , Richmond via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > What do you mean when you write "I'm still supporting LC 6.7"?
> >
> > On 10.03.22 20:25, Curry Kenworthy via use-livecode wrote:
> >>
> >> To plan addon development for the next few years,
> >> I would like to know if some people still need LC 6.7.
> >>
> >> If you're a Lurker, that's OK! If shy: offlist is fine.
> >> (Regulars welcome too, of course.)
> >>
> >> Currently I'm still supporting LC 6.7 too, but as LC 9
> >> matures on bugs/stability and performance, hopefully
> >> there will come a time when I can make this decision.
> >>
> >> Supporting LC 6.7 and 9/10 is fine, in fact it's fun,
> >> but moving past 6.7 eventually would have some perks.
> >> So the question is how long people will still need it.
> >>
> >> Your input will help guide my plan! Thanks.
> >>
> >> Best wishes,
> >>
> >> Curry Kenworthy
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

revOpenDatabase - ODBC - on Ubuntu - failing with empty error

[Ben Rubinstein via use-livecode]

Thanks to everyone who's responded to my woes over the last few days.

I'm making progress, but have hit a new hurdle.

I know have the LC-built app running in a Docker container on Ubuntu 18. It's 
set up with an ODBC connection to an Oracle database. I can test the 
connection on the command line with "isql", and it works fine.


But when the app tries to open the database, revOpenDatabase returns empty.

Normally it would return either an integer connection id, or an error message. 
But now it is just returning an empty string.


Is anyone else using ODBC on Linux? Any clues as to what I need to do, or 
where I could find a clue as to what the error is, since revOpenDatabase 
didn't return anything?


(Just for fun, I renamed the "dbodbc.so" driver in the 
Externals/database_drivers folder, and sure enough revOpenDatabase returned an 
error as I would expect, 'revdberr,invalid database type'.)


Any clues gratefully received,

Ben

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

[Bob Sneidar via use-livecode]

I believe he means that utilities he creates will still function when used with 
6.7, but wouldn't if he employs new features or syntax only supported in v9.x 
and up. Eventually he would consider ONLY supporting 9.x and up, and wants to 
get an idea of how many people would still need 6.7 support. 

Bob S


> On Mar 10, 2022, at 10:33 , Richmond via use-livecode 
>  wrote:
> 
> What do you mean when you write "I'm still supporting LC 6.7"?
> 
> On 10.03.22 20:25, Curry Kenworthy via use-livecode wrote:
>> 
>> To plan addon development for the next few years,
>> I would like to know if some people still need LC 6.7.
>> 
>> If you're a Lurker, that's OK! If shy: offlist is fine.
>> (Regulars welcome too, of course.)
>> 
>> Currently I'm still supporting LC 6.7 too, but as LC 9
>> matures on bugs/stability and performance, hopefully
>> there will come a time when I can make this decision.
>> 
>> Supporting LC 6.7 and 9/10 is fine, in fact it's fun,
>> but moving past 6.7 eventually would have some perks.
>> So the question is how long people will still need it.
>> 
>> Your input will help guide my plan! Thanks.
>> 
>> Best wishes,
>> 
>> Curry Kenworthy


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

[Richmond via use-livecode]

What do you mean when you write "I'm still supporting LC 6.7"?

On 10.03.22 20:25, Curry Kenworthy via use-livecode wrote:


To plan addon development for the next few years,
I would like to know if some people still need LC 6.7.

If you're a Lurker, that's OK! If shy: offlist is fine.
(Regulars welcome too, of course.)

Currently I'm still supporting LC 6.7 too, but as LC 9
matures on bugs/stability and performance, hopefully
there will come a time when I can make this decision.

Supporting LC 6.7 and 9/10 is fine, in fact it's fun,
but moving past 6.7 eventually would have some perks.
So the question is how long people will still need it.

Your input will help guide my plan! Thanks.

Best wishes,

Curry Kenworthy

WordLib: Import MS Word and OpenOffice files in LiveCode!
"Dominate documents with WordLib and LC"
http://livecodeaddons.com/wordlib.html

Innovative Christian LiveCode Training and Consulting
"Better Methods, Better Results"
http://livecodeconsulting.com/

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] SpreadLib ordering is back online

[Curry Kenworthy via use-livecode]

Bob:

> I'm really looking forward to this update Curry.
> I have a current need for parsing excel spreadsheets.

Thanks, I'm excited about this one too!

Best wishes,

Curry Kenworthy

SpreadLib: Excel files to LC fields in 1 script line!
"Excel-lent spreadsheet import and export for LiveCode"
http://livecodeaddons.com/spreadlib.html

Innovative Christian LiveCode Training and Consulting
"Better Methods, Better Results"
http://livecodeconsulting.com/

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

[Curry Kenworthy via use-livecode]

To plan addon development for the next few years,
I would like to know if some people still need LC 6.7.

If you're a Lurker, that's OK! If shy: offlist is fine.
(Regulars welcome too, of course.)

Currently I'm still supporting LC 6.7 too, but as LC 9
matures on bugs/stability and performance, hopefully
there will come a time when I can make this decision.

Supporting LC 6.7 and 9/10 is fine, in fact it's fun,
but moving past 6.7 eventually would have some perks.
So the question is how long people will still need it.

Your input will help guide my plan! Thanks.

Best wishes,

Curry Kenworthy

WordLib: Import MS Word and OpenOffice files in LiveCode!
"Dominate documents with WordLib and LC"
http://livecodeaddons.com/wordlib.html

Innovative Christian LiveCode Training and Consulting
"Better Methods, Better Results"
http://livecodeconsulting.com/

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: What version of Ubuntu does LiveCode (9.6.6) support?

[Ben Rubinstein via use-livecode]

To record an answer to my own question, for completeness: it appears that 
standalones built from LiveCode 9.6.6, at least, seems to work fine on Ubuntu 
18.04.2 LTS, at least. You may need to install some additional libraries.


Phew!

Ben

On 10/03/2022 15:29, Ben Rubinstein via use-livecode wrote:


Just read the release notes (for 9.6.6, but also for 10.0.0.dp2) which say

LiveCode supports the following Linux distributions, on 32-bit or 64-bit 
Intel/AMD or compatible processors:

Ubuntu 14.04 and 16.04
Fedora 23 & 24
Debian 7 (Wheezy) and 8 (Jessie) [server] CentOS 7 [server]


Is that correct - i.e. Ubuntu 18 is NOT supported? Might this be my problem 
with "libexpat.so.1"?


(I question it only because the 9.6.6 version of the User Guide says

The minimal requirements for LiveCode to run on Linux are:
 32-bit installation, or a 64-bit linux distribution that has a 32-bit 
compatibility layer

 2.4.x or later kernel

which is clearly out of date.)

Is anyone running LiveCode, or at least standalones built from LiveCode, on 
Ubuntu 18? Or is that my problem?


TIA,

Ben

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: What version of Ubuntu does LiveCode (9.6.6) support?

[Richmond via use-livecode]

Here's a few observations:

https://forums.livecode.com/viewtopic.php?f=20=36784

Best, Richmond.

On 10.03.22 17:29, Ben Rubinstein via use-livecode wrote:


Just read the release notes (for 9.6.6, but also for 10.0.0.dp2) which 
say


LiveCode supports the following Linux distributions, on 32-bit or 
64-bit Intel/AMD or compatible processors:

Ubuntu 14.04 and 16.04
Fedora 23 & 24
Debian 7 (Wheezy) and 8 (Jessie) [server] CentOS 7 [server]


Is that correct - i.e. Ubuntu 18 is NOT supported? Might this be my 
problem with "libexpat.so.1"?


(I question it only because the 9.6.6 version of the User Guide says

The minimal requirements for LiveCode to run on Linux are:
 32-bit installation, or a 64-bit linux distribution that has a 
32-bit compatibility layer

 2.4.x or later kernel

which is clearly out of date.)

Is anyone running LiveCode, or at least standalones built from 
LiveCode, on Ubuntu 18? Or is that my problem?


TIA,

Ben

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[Ben Rubinstein via use-livecode]

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. Can that be right? Or does 
this only work with LiveCode server?


Ben

On 10/03/2022 16:42, matthias rebbe via use-livecode wrote:

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.

Okay that is not the case when using Livecode. But there might be servers that 
do not run Livecode Server. In this case you cannot use your solution.
In this case SSH tunneling would be a safe solution.




Am 10.03.2022 um 17:14 schrieb Bob Sneidar via use-livecode 
:

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 I know, and a method for corrupting the data in a way 
only the server can "cleanse".

I suppose some may advise me on what is wrong with this method, and I welcome the input, 
but it worked for me. No unencrypted data went "over the wire".

The reason I developed this method is because I do not want to deal with 
expiring security certificates or secure websites to handle the data transfer. 
The method works out of the box.

Bob S



On Mar 10, 2022, at 03:34 , Ben Rubinstein via use-livecode 
 wrote:


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 visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] SpreadLib ordering is back online

[Bob Sneidar via use-livecode]

I'm really looking forward to this update Curry. I have a current need for 
parsing excel spreadsheets. 

Bob S


> On Mar 9, 2022, at 12:53 , Curry Kenworthy via use-livecode 
>  wrote:
> 
> 
> The SpreadLib order page is back up:
> 
> http://livecodeaddons.com/spreadlib.html
> http://livecodeaddons.com/buy-spreadlib
> 
> This is NOT a new version! Just the "store restored"
> after going offline when eSellerate died.
> (I've marked the price down a bit, though, at SendOwl.)
> 
> We have a MUCH newer private release made for 2020,
> but COVID nuked my productivity those last two years,
> so it never got the License keys for a public release.
> 
> That's a priority this year, therefore
> 
> Here's the SpreadLib for 2022 Plan:
> 
> - Public release during Summer.
> - New backend integration for more frequent updates.
> - Newer Mac improvements.
> - Multi-sheet handling.
> - Updated and expanded Documentation.
> - Many more improvements done before 2020.
> 
> (Meanwhile, WordLib is first in line again,
> with a minor version coming up around Easter
> for supercharged MS Word Comments.)
> 
> Happy coding! More news soon
> 
> Best wishes,
> 
> Curry Kenworthy
> 
> SpreadLib: Excel files to LC fields in 1 script line!
> "Excel-lent spreadsheet import and export for LiveCode"
> http://livecodeaddons.com/spreadlib.html
> 
> Innovative Christian LiveCode Training and Consulting
> "Better Methods, Better Results"
> http://livecodeconsulting.com/
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC and SqlLite Question

[Bob Sneidar via use-livecode]

As mentioned, only for reads, only one for write. But why not create a server 
agent that is responsible for handling multiple connections from clients, and 
the server agent can be the single connection to the sqLite database? 

Bob S


> On Mar 10, 2022, at 08:34 , Paul Dupuis via use-livecode 
>  wrote:
> 
> Can a sqlLite database file on disk be accessed by more than 1 LiveCode app 
> at the same time?
> 
> A server hosted mySql database can be accessed by any number of client LC 
> apps at the same time as the serve side mySql does the record locking 
> necessary, but what about a sqlLite file?
> 
> Obviously, I could code up some test apps and try it, but I am hoping some 
> one on the list definitively know for sure.
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[Bob Sneidar via use-livecode]

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 to it. All 
that passes between the client and server are these requests for connections, 
the sql statements the server needs to execute, and the data the server 
retrieves. All back and forth are encrypted. It's really quite elegant if I do 
say so myself. :-)

It really is just the framework for any client server solution. It can be used 
for a document storage and retrieval system too, or anything you want to 
communicate between two devices securely. 

Bob S


> On Mar 10, 2022, at 08:42 , matthias rebbe via use-livecode 
>  wrote:
> 
> 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.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC and SqlLite Question

[Tom Glod via use-livecode]

And finally. https://sqlite.org/wal.html

On Thu, Mar 10, 2022 at 11:55 AM Tom Glod  wrote:

> sorry about the double paste. :)
>
> On Thu, Mar 10, 2022 at 11:54 AM Tom Glod  wrote:
>
>> For writing its only ever 1, but it can have multiple readers if you use
>> the write ahead log .
>>
>> PRAGMA journal_mode=WAL;
>>
>> run that when creating database.never tested, but based on documentation. 
>> never
>> tested, but based on documentation.
>>
>> let me know if you test it successfully.
>>
>> On Thu, Mar 10, 2022 at 11:38 AM Paul Dupuis via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>>
>>> Can a sqlLite database file on disk be accessed by more than 1 LiveCode
>>> app at the same time?
>>>
>>> A server hosted mySql database can be accessed by any number of client
>>> LC apps at the same time as the serve side mySql does the record locking
>>> necessary, but what about a sqlLite file?
>>>
>>> Obviously, I could code up some test apps and try it, but I am hoping
>>> some one on the list definitively know for sure.
>>>
>>>
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC and SqlLite Question

[Tom Glod via use-livecode]

sorry about the double paste. :)

On Thu, Mar 10, 2022 at 11:54 AM Tom Glod  wrote:

> For writing its only ever 1, but it can have multiple readers if you use
> the write ahead log .
>
> PRAGMA journal_mode=WAL;
>
> run that when creating database.never tested, but based on documentation. 
> never
> tested, but based on documentation.
>
> let me know if you test it successfully.
>
> On Thu, Mar 10, 2022 at 11:38 AM Paul Dupuis via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> Can a sqlLite database file on disk be accessed by more than 1 LiveCode
>> app at the same time?
>>
>> A server hosted mySql database can be accessed by any number of client
>> LC apps at the same time as the serve side mySql does the record locking
>> necessary, but what about a sqlLite file?
>>
>> Obviously, I could code up some test apps and try it, but I am hoping
>> some one on the list definitively know for sure.
>>
>>
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC and SqlLite Question

[Tom Glod via use-livecode]

For writing its only ever 1, but it can have multiple readers if you use
the write ahead log .

PRAGMA journal_mode=WAL;

run that when creating database.never tested, but based on documentation. never
tested, but based on documentation.

let me know if you test it successfully.

On Thu, Mar 10, 2022 at 11:38 AM Paul Dupuis via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Can a sqlLite database file on disk be accessed by more than 1 LiveCode
> app at the same time?
>
> A server hosted mySql database can be accessed by any number of client
> LC apps at the same time as the serve side mySql does the record locking
> necessary, but what about a sqlLite file?
>
> Obviously, I could code up some test apps and try it, but I am hoping
> some one on the list definitively know for sure.
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[matthias rebbe via use-livecode]

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.

Okay that is not the case when using Livecode. But there might be servers that 
do not run Livecode Server. In this case you cannot use your solution. 
In this case SSH tunneling would be a safe solution.



> Am 10.03.2022 um 17:14 schrieb Bob Sneidar via use-livecode 
> :
> 
> 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 I know, and a 
> method for corrupting the data in a way only the server can "cleanse". 
> 
> I suppose some may advise me on what is wrong with this method, and I welcome 
> the input, but it worked for me. No unencrypted data went "over the wire". 
> 
> The reason I developed this method is because I do not want to deal with 
> expiring security certificates or secure websites to handle the data 
> transfer. The method works out of the box. 
> 
> Bob S
> 
> 
>> On Mar 10, 2022, at 03:34 , Ben Rubinstein via use-livecode 
>>  wrote:
>> 
>> 
>> 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 visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[J. Landman Gay via use-livecode]

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!

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 info though.)

Many thanks,

Ben


On 10/03/2022 15:31, matthias rebbe via use-livecode wrote:

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 Windows some weeks ago, but 
unfortunately that is in German.


I could translate that to English and add some additional information for 
macOS. But it would take 1 or 2 days.


If you could wait i could send you that guide.

Regards,

Matthias

Am 10.03.2022 um 12:34 schrieb Ben Rubinstein via use-livecode 
:



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 visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode





___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

LC and SqlLite Question

[Paul Dupuis via use-livecode]

Can a sqlLite database file on disk be accessed by more than 1 LiveCode 
app at the same time?


A server hosted mySql database can be accessed by any number of client 
LC apps at the same time as the serve side mySql does the record locking 
necessary, but what about a sqlLite file?


Obviously, I could code up some test apps and try it, but I am hoping 
some one on the list definitively know for sure.



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[Ben Rubinstein via use-livecode]

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 via use-livecode 
:

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 info though.)

Many thanks,

Ben


On 10/03/2022 15:31, matthias rebbe via use-livecode wrote:

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 Windows some weeks ago, but 
unfortunately that is in German.
I could translate that to English and add some additional information for 
macOS. But it would take 1 or 2 days.
If you could wait i could send you that guide.
Regards,
Matthias

Am 10.03.2022 um 12:34 schrieb Ben Rubinstein via use-livecode 
:


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 visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

[Ben Rubinstein via use-livecode]

Thanks Panos, that gave me the clues I needed to get the other ones as well.

Can confirm the app is now running on Ubuntu 18.04.2 LTS.

Thanks again,

Ben

On 10/03/2022 16:03, panagiotis m via use-livecode wrote:

Hello Ben,

For libfreetype, I think you should do:

sudo apt-get install libfreetype6-dev

Also, yes, the "official" supported Ubuntu distros for LC are 14 and 16
LTS. However, LC standalones built from 9.6.6 should run on Ubuntu 18 and
above as well.

Tomorrow I'll try to set up an Ubuntu 18 VM and give it a try.

Kind regards,
Panos
--

On Thu, 10 Mar 2022 at 17:51, Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:


Thanks Panos.

I'd just got part of the way there from your comment on this
https://quality.livecode.com/show_bug.cgi?id=23163 report.

(I'm a complete Linux noob.)

So now I know about 'ldd' I was able to execute:

# ldd CB304
   linux-vdso.so.1 (0x7ffed1b36000)
   libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x7f2e7fa49000)
   libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0

(0x7f2e7f82a000)

   libexpat.so.1 => not found
   libfreetype.so.6 => not found
   libfontconfig.so.1 => not found
   libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6

(0x7f2e7f4a1000)

   libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x7f2e7f103000)
   libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1

(0x7f2e7eeeb000)

   libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x7f2e7eafa000)
   /lib64/ld-linux-x86-64.so.2 (0x7f2e7fc4d000)


I was able to use apt to install "expat" and "fontconfig", but it couldn't
find "freetype".

Nonetheless I thought I'd try my app again, hoping at least that the error
have moved on. But alas:


# ./CB304 -ui
./CB304: error while loading shared libraries: libexpat.so.1: cannot

open shared object file: No such file or directory


Also - can you confirm whether LC standalones (built from 9.6.6) should be
able to run on Ubuntu 18? Or is Ubuntu 16 the limit?

Many thanks,

Ben

On 10/03/2022 15:32, panagiotis m via use-livecode wrote:

Hello all,

I think libexpat.so.1 is a system lib required by LC apps, so it might be
worth installing it.

I have not done any research, but I would expect that it would be enough

to

do something like:

sudo apt-get install expat

or

sudo apt-get install libexpat

Kind regards,
Panos


On Thu, 10 Mar 2022 at 17:15, Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:


Hi Stephen,

Built on Mac. I didn't zip it because I've got a folder shared with the
Docker
container, so I just dragged it in.

But sensing something behind your question... I just zipped up the
original
build folder, dragged that in, and then in the shell unzipped it,

invoked

that
binary... same result.

Thanks anyway!

Ben

On 10/03/2022 14:56, Stephen Barncard via use-livecode wrote:

Hi Ben,
Did you make the standalone on mac or win and  zip the file before
uploading ?
--
Stephen Barncard - Sebastopol Ca. USA -
mixstream.org


On Thu, Mar 10, 2022 at 6:50 AM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:



I'm trying to develop an app which will run headless on Linux

(actually

in

a
docker container). I've done this before... so long ago that I can't
remember... with an earlier version of this app. Normally I run this

on

Mac
and Windows.

So (under LiveCode 9.6.6) I simply checked the Linux 64 option in the
Standalone builder, built the app, transported the folder with the

binary

"MyApp", "Externals" folder, and "revsecurity.so" to the Docker

container,

and
tried to launch it:


# ./MyApp -ui
./MyApp: error while loading shared libraries: libexpat.so.1: cannot

open shared object file: No such file or directory

Can anyone point me in the right direction here? Does this mean that I
need to
do something different in how I build the app, or install something
different
in the environment?

(The container is running Ubuntu 18.04.2 LTS).

TIA,

Ben

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your

subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your

subscription preferences:

Re: revOpenDatabase over SSH tunnel?

[Bob Sneidar via use-livecode]

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 I know, and a method 
for corrupting the data in a way only the server can "cleanse". 

I suppose some may advise me on what is wrong with this method, and I welcome 
the input, but it worked for me. No unencrypted data went "over the wire". 

The reason I developed this method is because I do not want to deal with 
expiring security certificates or secure websites to handle the data transfer. 
The method works out of the box. 

Bob S


> On Mar 10, 2022, at 03:34 , Ben Rubinstein via use-livecode 
>  wrote:
> 
> 
> 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 visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

[panagiotis m via use-livecode]

Might be worth trying this as well:

sudo apt-get install libexpat1

Cheers,
Panos


On Thu, 10 Mar 2022 at 18:03, panagiotis m  wrote:

> Hello Ben,
>
> For libfreetype, I think you should do:
>
> sudo apt-get install libfreetype6-dev
>
> Also, yes, the "official" supported Ubuntu distros for LC are 14 and 16
> LTS. However, LC standalones built from 9.6.6 should run on Ubuntu 18 and
> above as well.
>
> Tomorrow I'll try to set up an Ubuntu 18 VM and give it a try.
>
> Kind regards,
> Panos
> --
>
> On Thu, 10 Mar 2022 at 17:51, Ben Rubinstein via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> Thanks Panos.
>>
>> I'd just got part of the way there from your comment on this
>> https://quality.livecode.com/show_bug.cgi?id=23163 report.
>>
>> (I'm a complete Linux noob.)
>>
>> So now I know about 'ldd' I was able to execute:
>> > # ldd CB304
>> >   linux-vdso.so.1 (0x7ffed1b36000)
>> >   libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2
>> (0x7f2e7fa49000)
>> >   libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0
>> (0x7f2e7f82a000)
>> >   libexpat.so.1 => not found
>> >   libfreetype.so.6 => not found
>> >   libfontconfig.so.1 => not found
>> >   libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6
>> (0x7f2e7f4a1000)
>> >   libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x7f2e7f103000)
>> >   libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1
>> (0x7f2e7eeeb000)
>> >   libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x7f2e7eafa000)
>> >   /lib64/ld-linux-x86-64.so.2 (0x7f2e7fc4d000)
>>
>> I was able to use apt to install "expat" and "fontconfig", but it
>> couldn't
>> find "freetype".
>>
>> Nonetheless I thought I'd try my app again, hoping at least that the
>> error
>> have moved on. But alas:
>>
>> > # ./CB304 -ui
>> > ./CB304: error while loading shared libraries: libexpat.so.1: cannot
>> open shared object file: No such file or directory
>>
>>
>> Also - can you confirm whether LC standalones (built from 9.6.6) should
>> be
>> able to run on Ubuntu 18? Or is Ubuntu 16 the limit?
>>
>> Many thanks,
>>
>> Ben
>>
>> On 10/03/2022 15:32, panagiotis m via use-livecode wrote:
>> > Hello all,
>> >
>> > I think libexpat.so.1 is a system lib required by LC apps, so it might
>> be
>> > worth installing it.
>> >
>> > I have not done any research, but I would expect that it would be
>> enough to
>> > do something like:
>> >
>> > sudo apt-get install expat
>> >
>> > or
>> >
>> > sudo apt-get install libexpat
>> >
>> > Kind regards,
>> > Panos
>> >
>> >
>> > On Thu, 10 Mar 2022 at 17:15, Ben Rubinstein via use-livecode <
>> > use-livecode@lists.runrev.com> wrote:
>> >
>> >> Hi Stephen,
>> >>
>> >> Built on Mac. I didn't zip it because I've got a folder shared with the
>> >> Docker
>> >> container, so I just dragged it in.
>> >>
>> >> But sensing something behind your question... I just zipped up the
>> >> original
>> >> build folder, dragged that in, and then in the shell unzipped it,
>> invoked
>> >> that
>> >> binary... same result.
>> >>
>> >> Thanks anyway!
>> >>
>> >> Ben
>> >>
>> >> On 10/03/2022 14:56, Stephen Barncard via use-livecode wrote:
>> >>> Hi Ben,
>> >>> Did you make the standalone on mac or win and  zip the file before
>> >>> uploading ?
>> >>> --
>> >>> Stephen Barncard - Sebastopol Ca. USA -
>> >>> mixstream.org
>> >>>
>> >>>
>> >>> On Thu, Mar 10, 2022 at 6:50 AM Ben Rubinstein via use-livecode <
>> >>> use-livecode@lists.runrev.com> wrote:
>> >>>
>> 
>>  I'm trying to develop an app which will run headless on Linux
>> (actually
>> >> in
>>  a
>>  docker container). I've done this before... so long ago that I can't
>>  remember... with an earlier version of this app. Normally I run this
>> on
>>  Mac
>>  and Windows.
>> 
>>  So (under LiveCode 9.6.6) I simply checked the Linux 64 option in the
>>  Standalone builder, built the app, transported the folder with the
>> >> binary
>>  "MyApp", "Externals" folder, and "revsecurity.so" to the Docker
>> >> container,
>>  and
>>  tried to launch it:
>> 
>> > # ./MyApp -ui
>> > ./MyApp: error while loading shared libraries: libexpat.so.1: cannot
>>  open shared object file: No such file or directory
>> 
>>  Can anyone point me in the right direction here? Does this mean that
>> I
>>  need to
>>  do something different in how I build the app, or install something
>>  different
>>  in the environment?
>> 
>>  (The container is running Ubuntu 18.04.2 LTS).
>> 
>>  TIA,
>> 
>>  Ben
>> 
>>  ___
>>  use-livecode mailing list
>>  use-livecode@lists.runrev.com
>>  Please visit this url to subscribe, unsubscribe and manage your
>>  subscription preferences:
>>  http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> >>> ___
>> >>> 

Re: revOpenDatabase over SSH tunnel?

[matthias rebbe via use-livecode]

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!
> 
> 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 info though.)
> 
> Many thanks,
> 
> Ben
> 
> 
> On 10/03/2022 15:31, matthias rebbe via use-livecode wrote:
>> 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 Windows some weeks ago, but 
>> unfortunately that is in German.
>> I could translate that to English and add some additional information for 
>> macOS. But it would take 1 or 2 days.
>> If you could wait i could send you that guide.
>> Regards,
>> Matthias
>>> Am 10.03.2022 um 12:34 schrieb Ben Rubinstein via use-livecode 
>>> :
>>> 
>>> 
>>> 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 visit this url to subscribe, unsubscribe and manage your 
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

[panagiotis m via use-livecode]

Hello Ben,

For libfreetype, I think you should do:

sudo apt-get install libfreetype6-dev

Also, yes, the "official" supported Ubuntu distros for LC are 14 and 16
LTS. However, LC standalones built from 9.6.6 should run on Ubuntu 18 and
above as well.

Tomorrow I'll try to set up an Ubuntu 18 VM and give it a try.

Kind regards,
Panos
--

On Thu, 10 Mar 2022 at 17:51, Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Thanks Panos.
>
> I'd just got part of the way there from your comment on this
> https://quality.livecode.com/show_bug.cgi?id=23163 report.
>
> (I'm a complete Linux noob.)
>
> So now I know about 'ldd' I was able to execute:
> > # ldd CB304
> >   linux-vdso.so.1 (0x7ffed1b36000)
> >   libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x7f2e7fa49000)
> >   libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0
> (0x7f2e7f82a000)
> >   libexpat.so.1 => not found
> >   libfreetype.so.6 => not found
> >   libfontconfig.so.1 => not found
> >   libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6
> (0x7f2e7f4a1000)
> >   libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x7f2e7f103000)
> >   libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1
> (0x7f2e7eeeb000)
> >   libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x7f2e7eafa000)
> >   /lib64/ld-linux-x86-64.so.2 (0x7f2e7fc4d000)
>
> I was able to use apt to install "expat" and "fontconfig", but it couldn't
> find "freetype".
>
> Nonetheless I thought I'd try my app again, hoping at least that the error
> have moved on. But alas:
>
> > # ./CB304 -ui
> > ./CB304: error while loading shared libraries: libexpat.so.1: cannot
> open shared object file: No such file or directory
>
>
> Also - can you confirm whether LC standalones (built from 9.6.6) should be
> able to run on Ubuntu 18? Or is Ubuntu 16 the limit?
>
> Many thanks,
>
> Ben
>
> On 10/03/2022 15:32, panagiotis m via use-livecode wrote:
> > Hello all,
> >
> > I think libexpat.so.1 is a system lib required by LC apps, so it might be
> > worth installing it.
> >
> > I have not done any research, but I would expect that it would be enough
> to
> > do something like:
> >
> > sudo apt-get install expat
> >
> > or
> >
> > sudo apt-get install libexpat
> >
> > Kind regards,
> > Panos
> >
> >
> > On Thu, 10 Mar 2022 at 17:15, Ben Rubinstein via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> Hi Stephen,
> >>
> >> Built on Mac. I didn't zip it because I've got a folder shared with the
> >> Docker
> >> container, so I just dragged it in.
> >>
> >> But sensing something behind your question... I just zipped up the
> >> original
> >> build folder, dragged that in, and then in the shell unzipped it,
> invoked
> >> that
> >> binary... same result.
> >>
> >> Thanks anyway!
> >>
> >> Ben
> >>
> >> On 10/03/2022 14:56, Stephen Barncard via use-livecode wrote:
> >>> Hi Ben,
> >>> Did you make the standalone on mac or win and  zip the file before
> >>> uploading ?
> >>> --
> >>> Stephen Barncard - Sebastopol Ca. USA -
> >>> mixstream.org
> >>>
> >>>
> >>> On Thu, Mar 10, 2022 at 6:50 AM Ben Rubinstein via use-livecode <
> >>> use-livecode@lists.runrev.com> wrote:
> >>>
> 
>  I'm trying to develop an app which will run headless on Linux
> (actually
> >> in
>  a
>  docker container). I've done this before... so long ago that I can't
>  remember... with an earlier version of this app. Normally I run this
> on
>  Mac
>  and Windows.
> 
>  So (under LiveCode 9.6.6) I simply checked the Linux 64 option in the
>  Standalone builder, built the app, transported the folder with the
> >> binary
>  "MyApp", "Externals" folder, and "revsecurity.so" to the Docker
> >> container,
>  and
>  tried to launch it:
> 
> > # ./MyApp -ui
> > ./MyApp: error while loading shared libraries: libexpat.so.1: cannot
>  open shared object file: No such file or directory
> 
>  Can anyone point me in the right direction here? Does this mean that I
>  need to
>  do something different in how I build the app, or install something
>  different
>  in the environment?
> 
>  (The container is running Ubuntu 18.04.2 LTS).
> 
>  TIA,
> 
>  Ben
> 
>  ___
>  use-livecode mailing list
>  use-livecode@lists.runrev.com
>  Please visit this url to subscribe, unsubscribe and manage your
>  subscription preferences:
>  http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> >>> ___
> >>> use-livecode mailing list
> >>> use-livecode@lists.runrev.com
> >>> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >>> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>
> >> ___
> >> use-livecode mailing list
> >> 

Re: revOpenDatabase over SSH tunnel?

[Ben Rubinstein via use-livecode]

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 info though.)


Many thanks,

Ben


On 10/03/2022 15:31, matthias rebbe via use-livecode wrote:

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 Windows some weeks ago, but 
unfortunately that is in German.

I could translate that to English and add some additional information for 
macOS. But it would take 1 or 2 days.

If you could wait i could send you that guide.

Regards,

Matthias


Am 10.03.2022 um 12:34 schrieb Ben Rubinstein via use-livecode 
:


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 visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[matthias rebbe via use-livecode]

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,
> 
> 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 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 Windows some weeks ago, but
>> unfortunately that is in German.
>> 
>> I could translate that to English and add some additional information for
>> macOS. But it would take 1 or 2 days.
>> 
>> If you could wait i could send you that guide.
>> 
>> Regards,
>> 
>> Matthias
>> 
>>> Am 10.03.2022 um 12:34 schrieb Ben Rubinstein via use-livecode <
>> use-livecode@lists.runrev.com>:
>>> 
>>> 
>>> 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 visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

[Ben Rubinstein via use-livecode]

Thanks Panos.

I'd just got part of the way there from your comment on this 
https://quality.livecode.com/show_bug.cgi?id=23163 report.


(I'm a complete Linux noob.)

So now I know about 'ldd' I was able to execute:
# ldd CB304 
	linux-vdso.so.1 (0x7ffed1b36000)

libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x7f2e7fa49000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 
(0x7f2e7f82a000)
libexpat.so.1 => not found
libfreetype.so.6 => not found
libfontconfig.so.1 => not found
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 
(0x7f2e7f4a1000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x7f2e7f103000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 
(0x7f2e7eeeb000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x7f2e7eafa000)
/lib64/ld-linux-x86-64.so.2 (0x7f2e7fc4d000)


I was able to use apt to install "expat" and "fontconfig", but it couldn't 
find "freetype".


Nonetheless I thought I'd try my app again, hoping at least that the error 
have moved on. But alas:



# ./CB304 -ui
./CB304: error while loading shared libraries: libexpat.so.1: cannot open 
shared object file: No such file or directory



Also - can you confirm whether LC standalones (built from 9.6.6) should be 
able to run on Ubuntu 18? Or is Ubuntu 16 the limit?


Many thanks,

Ben

On 10/03/2022 15:32, panagiotis m via use-livecode wrote:

Hello all,

I think libexpat.so.1 is a system lib required by LC apps, so it might be
worth installing it.

I have not done any research, but I would expect that it would be enough to
do something like:

sudo apt-get install expat

or

sudo apt-get install libexpat

Kind regards,
Panos


On Thu, 10 Mar 2022 at 17:15, Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:


Hi Stephen,

Built on Mac. I didn't zip it because I've got a folder shared with the
Docker
container, so I just dragged it in.

But sensing something behind your question... I just zipped up the
original
build folder, dragged that in, and then in the shell unzipped it, invoked
that
binary... same result.

Thanks anyway!

Ben

On 10/03/2022 14:56, Stephen Barncard via use-livecode wrote:

Hi Ben,
Did you make the standalone on mac or win and  zip the file before
uploading ?
--
Stephen Barncard - Sebastopol Ca. USA -
mixstream.org


On Thu, Mar 10, 2022 at 6:50 AM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:



I'm trying to develop an app which will run headless on Linux (actually

in

a
docker container). I've done this before... so long ago that I can't
remember... with an earlier version of this app. Normally I run this on
Mac
and Windows.

So (under LiveCode 9.6.6) I simply checked the Linux 64 option in the
Standalone builder, built the app, transported the folder with the

binary

"MyApp", "Externals" folder, and "revsecurity.so" to the Docker

container,

and
tried to launch it:


# ./MyApp -ui
./MyApp: error while loading shared libraries: libexpat.so.1: cannot

open shared object file: No such file or directory

Can anyone point me in the right direction here? Does this mean that I
need to
do something different in how I build the app, or install something
different
in the environment?

(The container is running Ubuntu 18.04.2 LTS).

TIA,

Ben

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your

subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[Glen Bojsza via use-livecode]

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 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 Windows some weeks ago, but
> unfortunately that is in German.
>
> I could translate that to English and add some additional information for
> macOS. But it would take 1 or 2 days.
>
> If you could wait i could send you that guide.
>
> Regards,
>
> Matthias
>
> > Am 10.03.2022 um 12:34 schrieb Ben Rubinstein via use-livecode <
> use-livecode@lists.runrev.com>:
> >
> >
> > 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 visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

[panagiotis m via use-livecode]

Hello all,

I think libexpat.so.1 is a system lib required by LC apps, so it might be
worth installing it.

I have not done any research, but I would expect that it would be enough to
do something like:

sudo apt-get install expat

or

sudo apt-get install libexpat

Kind regards,
Panos


On Thu, 10 Mar 2022 at 17:15, Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Hi Stephen,
>
> Built on Mac. I didn't zip it because I've got a folder shared with the
> Docker
> container, so I just dragged it in.
>
> But sensing something behind your question... I just zipped up the
> original
> build folder, dragged that in, and then in the shell unzipped it, invoked
> that
> binary... same result.
>
> Thanks anyway!
>
> Ben
>
> On 10/03/2022 14:56, Stephen Barncard via use-livecode wrote:
> > Hi Ben,
> > Did you make the standalone on mac or win and  zip the file before
> > uploading ?
> > --
> > Stephen Barncard - Sebastopol Ca. USA -
> > mixstream.org
> >
> >
> > On Thu, Mar 10, 2022 at 6:50 AM Ben Rubinstein via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> >>
> >> I'm trying to develop an app which will run headless on Linux (actually
> in
> >> a
> >> docker container). I've done this before... so long ago that I can't
> >> remember... with an earlier version of this app. Normally I run this on
> >> Mac
> >> and Windows.
> >>
> >> So (under LiveCode 9.6.6) I simply checked the Linux 64 option in the
> >> Standalone builder, built the app, transported the folder with the
> binary
> >> "MyApp", "Externals" folder, and "revsecurity.so" to the Docker
> container,
> >> and
> >> tried to launch it:
> >>
> >>> # ./MyApp -ui
> >>> ./MyApp: error while loading shared libraries: libexpat.so.1: cannot
> >> open shared object file: No such file or directory
> >>
> >> Can anyone point me in the right direction here? Does this mean that I
> >> need to
> >> do something different in how I build the app, or install something
> >> different
> >> in the environment?
> >>
> >> (The container is running Ubuntu 18.04.2 LTS).
> >>
> >> TIA,
> >>
> >> Ben
> >>
> >> ___
> >> use-livecode mailing list
> >> use-livecode@lists.runrev.com
> >> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revOpenDatabase over SSH tunnel?

[matthias rebbe via use-livecode]

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 Windows some weeks ago, but 
unfortunately that is in German.

I could translate that to English and add some additional information for 
macOS. But it would take 1 or 2 days.

If you could wait i could send you that guide.

Regards,

Matthias

> Am 10.03.2022 um 12:34 schrieb Ben Rubinstein via use-livecode 
> :
> 
> 
> 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 visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

What version of Ubuntu does LiveCode (9.6.6) support?

[Ben Rubinstein via use-livecode]

Just read the release notes (for 9.6.6, but also for 10.0.0.dp2) which say


LiveCode supports the following Linux distributions, on 32-bit or 64-bit 
Intel/AMD or compatible processors:
Ubuntu 14.04 and 16.04
Fedora 23 & 24
Debian 7 (Wheezy) and 8 (Jessie) [server] CentOS 7 [server]


Is that correct - i.e. Ubuntu 18 is NOT supported? Might this be my problem 
with "libexpat.so.1"?


(I question it only because the 9.6.6 version of the User Guide says

The minimal requirements for LiveCode to run on Linux are:
 32-bit installation, or a 64-bit linux distribution that has a 32-bit 
compatibility layer
 2.4.x or later kernel

which is clearly out of date.)

Is anyone running LiveCode, or at least standalones built from LiveCode, on 
Ubuntu 18? Or is that my problem?


TIA,

Ben

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

[Ben Rubinstein via use-livecode]

Hi Stephen,

Built on Mac. I didn't zip it because I've got a folder shared with the Docker 
container, so I just dragged it in.


But sensing something behind your question... I just zipped up the original 
build folder, dragged that in, and then in the shell unzipped it, invoked that 
binary... same result.


Thanks anyway!

Ben

On 10/03/2022 14:56, Stephen Barncard via use-livecode wrote:

Hi Ben,
Did you make the standalone on mac or win and  zip the file before
uploading ?
--
Stephen Barncard - Sebastopol Ca. USA -
mixstream.org


On Thu, Mar 10, 2022 at 6:50 AM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:



I'm trying to develop an app which will run headless on Linux (actually in
a
docker container). I've done this before... so long ago that I can't
remember... with an earlier version of this app. Normally I run this on
Mac
and Windows.

So (under LiveCode 9.6.6) I simply checked the Linux 64 option in the
Standalone builder, built the app, transported the folder with the binary
"MyApp", "Externals" folder, and "revsecurity.so" to the Docker container,
and
tried to launch it:


# ./MyApp -ui
./MyApp: error while loading shared libraries: libexpat.so.1: cannot

open shared object file: No such file or directory

Can anyone point me in the right direction here? Does this mean that I
need to
do something different in how I build the app, or install something
different
in the environment?

(The container is running Ubuntu 18.04.2 LTS).

TIA,

Ben

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

[Stephen Barncard via use-livecode]

Hi Ben,
Did you make the standalone on mac or win and  zip the file before
uploading ?
--
Stephen Barncard - Sebastopol Ca. USA -
mixstream.org


On Thu, Mar 10, 2022 at 6:50 AM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:

>
> I'm trying to develop an app which will run headless on Linux (actually in
> a
> docker container). I've done this before... so long ago that I can't
> remember... with an earlier version of this app. Normally I run this on
> Mac
> and Windows.
>
> So (under LiveCode 9.6.6) I simply checked the Linux 64 option in the
> Standalone builder, built the app, transported the folder with the binary
> "MyApp", "Externals" folder, and "revsecurity.so" to the Docker container,
> and
> tried to launch it:
>
> > # ./MyApp -ui
> > ./MyApp: error while loading shared libraries: libexpat.so.1: cannot
> open shared object file: No such file or directory
>
> Can anyone point me in the right direction here? Does this mean that I
> need to
> do something different in how I build the app, or install something
> different
> in the environment?
>
> (The container is running Ubuntu 18.04.2 LTS).
>
> TIA,
>
> Ben
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Trying to run standalone (headless) on Linux (Ubuntu) - failed at first hurdle

[Ben Rubinstein via use-livecode]

I'm trying to develop an app which will run headless on Linux (actually in a 
docker container). I've done this before... so long ago that I can't 
remember... with an earlier version of this app. Normally I run this on Mac 
and Windows.


So (under LiveCode 9.6.6) I simply checked the Linux 64 option in the 
Standalone builder, built the app, transported the folder with the binary 
"MyApp", "Externals" folder, and "revsecurity.so" to the Docker container, and 
tried to launch it:



# ./MyApp -ui
./MyApp: error while loading shared libraries: libexpat.so.1: cannot open 
shared object file: No such file or directory


Can anyone point me in the right direction here? Does this mean that I need to 
do something different in how I build the app, or install something different 
in the environment?


(The container is running Ubuntu 18.04.2 LTS).

TIA,

Ben

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

revOpenDatabase over SSH tunnel?

[Ben Rubinstein via use-livecode]

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 visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode