Re: Using MySQL on (headless) Linux

2021-02-16 Thread Richard Gaskin via use-livecode
Thank you, Mark, but the downside to my longish emails is that I'll need further guidance: which part/phrases would be of greatest interest? Happy to see if I can put together something to help with it. -- Richard Gaskin Fourth World Systems On 2/4/21 3:33 AM, Mark Smith wrote: Richard,

RE: Using MySQL on (headless) Linux

2021-02-04 Thread Ralph DiMola via use-livecode
om] On Behalf Of Mark Wieder via use-livecode Sent: Thursday, February 04, 2021 11:52 AM To: Richard Gaskin via use-livecode Cc: Mark Wieder Subject: Re: Using MySQL on (headless) Linux On 2/4/21 1:52 AM, Richard Gaskin via use-livecode wrote: > With all this flexibility in one lean install, f

Re: Using MySQL on (headless) Linux

2021-02-04 Thread Mark Wieder via use-livecode
On 2/4/21 1:52 AM, Richard Gaskin via use-livecode wrote: With all this flexibility in one lean install, for me the pros of LC Server for headless work are clear: ...plus the fact that there's an "include" command in the server, allowing for things like global constants. -- Mark Wieder

Re: Using MySQL on (headless) Linux

2021-02-04 Thread Bob Sneidar via use-livecode
I don’t remember what I had for dinner on Friday. :-) Bob S On Feb 3, 2021, at 10:58 PM, Mark Waddingham via use-livecode mailto:use-livecode@lists.runrev.com>> wrote: On 2021-02-03 20:07, Richard Gaskin via use-livecode wrote: LC Server had already been ruled out (for whatever reason) in an

Re: Using MySQL on (headless) Linux

2021-02-04 Thread Richard Gaskin via use-livecode
Mark Waddingham wrote: On 2021-02-03 20:07, Richard Gaskin via use-livecode wrote: LC Server had already been ruled out (for whatever reason) in an earlier part of the thread... That's too bad. LC Server is LiveCode build designed specifically for command line use. Interesting - I don't

Re: Using MySQL on (headless) Linux

2021-02-03 Thread Mark Waddingham via use-livecode
On 2021-02-03 20:07, Richard Gaskin via use-livecode wrote: LC Server had already been ruled out (for whatever reason) in an earlier part of the thread... That's too bad. LC Server is LiveCode build designed specifically for command line use. Interesting - I don't remember that being what I

Re: Using MySQL on (headless) Linux

2021-02-03 Thread Dr. Hawkins via use-livecode
That the deployment needs to be headless doesn’t prevent you from running it n the IDE to gain access to single stepping, breakpoints, and the like. I don’t remember why offhand, but before finding the -ui option, I did some experimenting and fount that I could get the linux version of

Re: Using MySQL on (headless) Linux

2021-02-03 Thread Richard Gaskin via use-livecode
Mark Waddingham wrote: On 2021-02-03 00:31, Richard Gaskin via use-livecode wrote: As for my post, it was a question in reply to Mark Waddingham's note about how only standalones can be expected to use externals. That is, at least as I read it. Mark said nothing of the sort :) Very glad to

Re: Using MySQL on (headless) Linux

2021-02-03 Thread Ben Rubinstein via use-livecode
Yes sorry Richard et al for confusion. I was using LC standard on a headless Linux machine, i.e. launching the IDE but with -ui. It worked fine and ran my stack OK, until it tried to access a database. At that point I listened to advice and made a minimal standalone configured as a launcher -

Re: Using MySQL on (headless) Linux

2021-02-02 Thread Mark Waddingham via use-livecode
On 2021-02-03 00:31, Richard Gaskin via use-livecode wrote: As for my post, it was a question in reply to Mark Waddingham's note about how only standalones can be expected to use externals. That is, at least as I read it. Mark said nothing of the sort :) LC Server had already been ruled out

Re: Using MySQL on (headless) Linux

2021-02-02 Thread Richard Gaskin via use-livecode
Good rules in general, but my question was about something else entirely. As for the IDE, it's a GUI; I'm not sure what could be done with it on a headless system. (Yes, instructions are provided for sys admins to automate *installing* it via command line -- great for computer labs and such

Re: Using MySQL on (headless) Linux

2021-02-02 Thread Mark Talluto via use-livecode
My simple rule on this is: If I need to write code, use the IDE. If I need to deploy code, use a standalone. You get the best possible performance. They are flexible since you can dynamically load code. They do not have the burden of the IDE. It seems the right path to go. Maybe there is a

Re: Using MySQL on (headless) Linux

2021-02-02 Thread Richard Gaskin via use-livecode
LC Server doesn't handle externals, so for that we need a standalone? I think I'm missing something. -- Richard Gaskin Fourth World Systems Mark Waddingham wrote: On 2021-02-01 22:25, Ben Rubinstein via use-livecode wrote: Undesirable things found: 1. I've not found how to access

Re: Using MySQL on (headless) Linux

2021-02-02 Thread Ben Rubinstein via use-livecode
Hi Mark, On 02/02/2021 09:03, Mark Waddingham via use-livecode wrote: I'll report (2) and (3) formally when I've done a bit more investigation. I'd still love to know what I'm doing wrong, in relation to (1). Please don't - as neither are bugs :) The "investigation" I referred to was

Re: Using MySQL on (headless) Linux

2021-02-02 Thread Ben Rubinstein via use-livecode
Thanks Mark. The issue here is that the stack was running headless, not in the IDE. But I had it write the externals to stdout and indeed the result was empty, so then I resaved it with the embedded property... etc. But this is moot given other-Mark's message. cheers, Ben On 02/02/2021

Re: Using MySQL on (headless) Linux

2021-02-02 Thread Mark Waddingham via use-livecode
On 2021-02-01 22:25, Ben Rubinstein via use-livecode wrote: Undesirable things found: 1. I've not found how to access externals (in this case the database library) without explicitly setting the 'externals' property of the stack to a (generally unreliably) full path before the stack is saved.

Re: Using MySQL on (headless) Linux

2021-02-01 Thread Mark Wieder via use-livecode
On 2/1/21 2:25 PM, Ben Rubinstein via use-livecode wrote: 1. I've not found how to access externals (in this case the database library) without explicitly setting the 'externals' property of the stack to a (generally unreliably) full path before the stack is saved. If you type in the

Re: Using MySQL on (headless) Linux

2021-02-01 Thread Ben Rubinstein via use-livecode
Devin, thank you - that was the last bit I needed. So my complete stack now works. Hurrah! Thanks everyone who helped me. Undesirable things found: 1. I've not found how to access externals (in this case the database library) without explicitly setting the 'externals' property of the stack

Re: Using MySQL on (headless) Linux

2021-02-01 Thread Devin Asay via use-livecode
Ben, I have seen the “invalid database type” error on Linux because of a case error. Make sure you use “mysql” as the database type, not “MySQL” or anything else with upper case letters. LiveCode is not case-sensitive, but Linux is. Hope this helps. Devin > On Feb 1, 2021, at 2:32 PM, Ben

Re: Using MySQL on (headless) Linux

2021-02-01 Thread Ben Rubinstein via use-livecode
Update. I have managed to get access to the Rev database external by explicitly setting the `externals` property of the stack before saving it (on Mac) to the full path on the linux machine to `revdb.so`. Consequently the functions such as `revOpenDatabases` and `revOpenDatabase` no longer

Re: Using MySQL on (headless) Linux

2021-02-01 Thread Ben Rubinstein via use-livecode
Hi Mark, > "error in function handler" is a pretty generic response - sort of the > engine's version of ¯\_(ツ)_/¯. Is the MySQL database local to the server > machine or on a different computer? I should point out that this error is thrown - I take it to mean that the function isn't even

Re: Using MySQL on (headless) Linux

2021-02-01 Thread Mark Wieder via use-livecode
On 2/1/21 11:15 AM, Ben Rubinstein via use-livecode wrote: With thanks to friends here who helped me install and start using LC on a headless Linux box. I've now another little problem... my stack tries and fails to connect to a MySQL database. When it attempts to call revOpenDatabase, it

Using MySQL on (headless) Linux

2021-02-01 Thread Ben Rubinstein via use-livecode
With thanks to friends here who helped me install and start using LC on a headless Linux box. I've now another little problem... my stack tries and fails to connect to a MySQL database. When it attempts to call revOpenDatabase, it throws error 219, "error in function handler". I take it