Re: Livecode server UNIX version (not Linux).

2020-10-16 Thread Bernard Devlin via use-livecode
Hi Heriberto Back in the day (20 years ago) the engine/IDE ran on FreeBSD and various proprietary unixes. The Linux server version has been seen to work on FreeBSD back in 2011 (after installing Linux compatibility layer).

Re: SSL cPanel mySql setup

2020-10-16 Thread Sean Cole (Pi) via use-livecode
Excellent. Thanks Matthias. Both your comments and the other discussion were of help. Looks like I'll be making a server app then. Sean Cole *Pi Digital * On Fri, 16 Oct 2020 at 10:51, matthias rebbe via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi Sean, > > there was a discussion

Re: SSL cPanel mySql setup

2020-10-16 Thread Mark Waddingham via use-livecode
On 2020-10-16 10:51, matthias rebbe via use-livecode wrote: Hi Sean, there was a discussion a few weeks ago with the topic "Strange behavior between Mysql, MariaDB and SSL." I am not sure if the information in that discussion will solve your problem. I had a quick look through that thread

SSL cPanel mySql setup

2020-10-16 Thread Pi Digital via use-livecode
Hi I’ve found myself out of my depth and in need of advice. We have a cPanel webspace with mySQL running on a phpMyAdmin layer within the cPanel setup. Communicating with it from LC has been a breeze. However, doing a traffic scan we noticed that our queries and responses from the database are

Test, please ignore

2020-10-16 Thread Graham Samuel via use-livecode
One of my mails didn’t make it to the list, even though I re-sent it. Just checking if anything at all is coming through... ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your

Re: SSL cPanel mySql setup

2020-10-16 Thread matthias rebbe via use-livecode
Hi Sean, there was a discussion a few weeks ago with the topic "Strange behavior between Mysql, MariaDB and SSL." I am not sure if the information in that discussion will solve your problem. Another approach is the following. For security reasons we do not let communicat our LC apps directly

Re: SSL cPanel mySql setup

2020-10-16 Thread Pi Digital via use-livecode
Thanks Mark As I thought. Might as well have a server app that does the talking to the database. Sean Cole Pi Digital > On 16 Oct 2020, at 11:33, Mark Waddingham via use-livecode > wrote: > > On 2020-10-16 10:51, matthias rebbe via use-livecode wrote: >> Hi Sean, >> there was a discussion

Re: Interface Resolution

2020-10-16 Thread John McKenzie via use-livecode
Jacqueline, thank you for adding to my thread about the interface on 4k monitors. I did as suggested but there is no persistence with the plugins dialogue box. If there is a save, OK, or apply type functions I cannot find them. Closing the window does not appear to save the changes as there

Re: Odd data in message box

2020-10-16 Thread Mark Wieder via use-livecode
On 10/16/20 8:46 AM, Dan Friedman via use-livecode wrote: There is no problem with this function, and it's producing the correct time. However, when it's all said and done, I get this in the message box: 394,2185,1 what's line 2185 look like? -- Mark Wieder ahsoftw...@gmail.com

Re: SSL cPanel mySql setup

2020-10-16 Thread William Prothero via use-livecode
Sean: You might find this download interesting, perhaps useful: http://earthlearningsolutions.org/wp-content/uploads/2018/07/RemoteDbEncryption.livecode.zip It is a demo of AES encryption that I use.

Re: Odd data in message box

2020-10-16 Thread Dan Friedman via use-livecode
Mark, THANK YOU for the reply... Line 2185 is: put sTime + ((timeOffset*60)*60) into sTime function convertToLocalTime sTime //sTime is already been converted to seconds format //convert the time using the hour offset for local time zone put word 6 of the internet date into

RE: Odd data in message box

2020-10-16 Thread Ralph DiMola via use-livecode
This what I get here in the eastern US time zone(gmt-4). Looks Correct to me. Command: put the seconds into x;put convertToLocalTime(x) into y;convert x to dateitems;convert y to dateitems;put x Message box results: 2020,10,16,12,20,25,6 2020,10,16,16,20,25,6 Ralph DiMola IT Director

Odd data in message box

2020-10-16 Thread Dan Friedman via use-livecode
I get a bunch of data from my server. In this array, there are some dates. I roll through each one converting the date to local time: function convertToLocalTime sTime //sTime is already been converted to seconds format //convert the time using the hour offset for local time zone put

Re: Interface Resolution

2020-10-16 Thread J. Landman Gay via use-livecode
Since it's just a stack, open it normally in LC. You can do that either from the Open file menu or since it's open already it should be in the Windows menu. Edit the script normally. Apply and save the stack. The next time LC starts up, the handlers should run. The plugin dialog only manages

Re: SSL cPanel mySql setup

2020-10-16 Thread Pi Digital via use-livecode
Bill Thanks for this. We were just discussing the same solution. I already have some php scripts I’m using for the HTML5 deployment of a LC stack as a portal to the same database. The whole thing needs an overhaul. I’ve inherited this world of pain that has been 10-15years of amateur coding.

Re: Odd data in message box

2020-10-16 Thread J. Landman Gay via use-livecode
On 10/16/20 10:46 AM, Dan Friedman via use-livecode wrote: There is no problem with this function, and it's producing the correct time. However, when it's all said and done, I get this in the message box: 394,2185,1 465,2185,1 253,2185,1 241,2181,1,convertToLocalTime 353,0,0,stack

Fwd: Re: Odd data in message box

2020-10-16 Thread Mark Wieder via use-livecode
On 10/16/20 9:57 AM, Dan Friedman wrote: Mark, THANK YOU for the reply... Line 2185 is: put sTime + ((timeOffset*60)*60) into sTime That's what I thought. The error you're getting (see Jacque's annotated list) is pointing to an invalid value for sTime in some iteration of that

Re: SSL cPanel mySql setup

2020-10-16 Thread J. Landman Gay via use-livecode
When I get a stack like that it's usually easier to figure out what it does and just rewrite it from scratch. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com On October 16, 2020 12:16:52 PM Pi Digital via use-livecode wrote: Bill

Re: SSL cPanel mySql setup

2020-10-16 Thread Mark Wieder via use-livecode
On 10/16/20 10:14 AM, Pi Digital via use-livecode wrote: The call to the server along with all the credentials had been copy pasted over 900 times inside 700 objects. OMG!!! -- Mark Wieder ahsoftw...@gmail.com ___ use-livecode mailing list

Re: Interface Resolution

2020-10-16 Thread J. Landman Gay via use-livecode
Plugins are just normal stacks that appear in the plugins folder. When you open the stack, which opens automatically and invisibly on startup in this case, it will just sit there. It needs an activation handler, which can be on openstack or opencard or whatever is appropriate. Add whatever you