Re: SSL cPanel mySql setup

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

Fwd: Re: Odd data in message box

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: Odd data in message box

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

Re: SSL cPanel mySql setup

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

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

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

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: Interface Resolution

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

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

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

Re: Interface Resolution

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

Odd data in message box

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: SSL cPanel mySql setup

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: SSL cPanel mySql setup

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

Re: SSL cPanel mySql setup

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

Test, please ignore

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

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

SSL cPanel mySql setup

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

Re: Livecode server UNIX version (not Linux).

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: Interface Resolution

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