Re: SSL cPanel mySql setup

Folks: Please ignore my posting in this thread. I re-posted it in a new thread. Best, Bill William A. Prothero Santa Barbara, CA. 93105 http://earthlearningsolutions.org/ > On Oct 19, 2020, at 9:45 AM, Sean Cole (Pi) via use-livecode > wrote: > > Why is it that so many hijack threads rather

Re: SSL cPanel mySql setup

Sean, LC server issues seemed like the general topic. Sorry to have bothered you. Bill William Prothero http://es.earthednet.org > On Oct 19, 2020, at 9:47 AM, Sean Cole (Pi) via use-livecode > wrote: > > Why is it that so many hijack threads rather than start new ones? > >> On Mon, 19 Oct

Re: SSL cPanel mySql setup

Why is it that so many hijack threads rather than start new ones? On Mon, 19 Oct 2020 at 17:30, ELS Prothero via use-livecode < use-livecode@lists.runrev.com> wrote: > Folks, > I’ve been thinking about experimenting with Livecode server. I have a vps > and root access, but I’m wondering what are

Re: SSL cPanel mySql setup

Folks, I’ve been thinking about experimenting with Livecode server. I have a vps and root access, but I’m wondering what are the speed and user consequences of installing it at root level, or as a cgi. The cgi is fairly large and I’m concerned about both speed and memory issues when multiple

Re: SSL cPanel mySql setup

Hi revQueryDatabase(tConnId, “SHOW STATUS”) only returns an integer Same for revdb_execute which returns 0 Any clues on how to actually get the status back? Still trying to work out why these certificates are not working. Sean -- Sean Cole *Pi Digital Productions Ltd* www.pidigital.co.uk

Re: SSL cPanel mySql setup

> Le 19 oct. 2020 à 08:45, Dev via use-livecode > a écrit : > > Since I have been on DreamHost for more than a decade, I would love to have > something like this set up. I’m not too proficient with Terminal or Linux, > but can follow instructions. I would love to know if there is a crib

Re: SSL cPanel mySql setup

> I'm not sure what that DH rep is going on about, because the same set of > LC Lessons that describe how to set it up via Apache config also include > one on setting it up via .htacces on shared hosts. Many thanks Richard I will give it a go. I was once told by a DreamHost support guy that

Re: SSL cPanel mySql setup

Hi Richard Since I have been on DreamHost for more than a decade, I would love to have something like this set up. I’m not too proficient with Terminal or Linux, but can follow instructions. I would love to know if there is a crib sheet or step by step or tutorial that I could follow to get an

Re: SSL cPanel mySql setup

Neville Smythe wrote: On 19 Oct 2020, at 3:00 am, use-livecode-request at lists.runrev.com wrote: Dreamhost never did install LC ... but several of us have made it work. Just get the right server executable and permissions. I could never get it work account wide but it rocked for individual

Re: SSL cPanel mySql setup

> On 19 Oct 2020, at 3:00 am, use-livecode-requ...@lists.runrev.com wrote: > > Dreamhost never did install LC ... but several of us have made it work. > Just get the right server executable and permissions. > I could never get it work account wide but it rocked for individual web > site

Re: SSL cPanel mySql setup

We have some Azure .net API guys in India we have that make the middle-man for this. It's all written in C#. I then use REST to talk through that to the clients DynCRM. I didn't want to go into all the C# which is why we outsourced it to India. They are great and have often been able to help at a

Re: SSL cPanel mySql setup

Neville Smythe wrote: > So I need some middleware. LC Server would have been ideal, but > Dreamhost no longer install it ;-(. I particularly could have used > LC Server to drive mailman distribution list > subscription/unsubscription tasks from the database for which I do > not have a good

Re: SSL cPanel mySql setup

Sean Cole wrote: Since then I've added DocuSign, MS DynamicsCRM integration Are you at liberty to describe what that integration involved? Specifically, do you use MS' REST API? And if so, how were you able to set up the app registration in Azure for successful authentication? I have a

Re: SSL cPanel mySql setup

Neville, Sorry for your pain but I'm glad it's been brought to light for you too before someone heinously exploits it. Looks like we've both got some work on our hands. From what I have worked out and been advised, using php over https is the easiest route to switch to. I say easiest. But it's

Re: SSL cPanel mySql setup

Jacqueline wrote: > > just rewrite it from scratch Hehe :) Just to give you an idea of the behemoth of a monstrous beast I have taken on, here are some stats I just ran a script to collate: 1 Main Stack 95 Substacks (Excl Data grids) 786 Cards 76779 Controls (Excl Data grids) 376377 Lines of

Re: SSL cPanel mySql setup

Dreamhost never did install LC ... but several of us have made it work. Just get the right server executable and permissions. I could never get it work account wide but it rocked for individual web site installation. -- Stephen Barncard - Sebastopol Ca. USA - mixstream.org On Sat, Oct 17, 2020

Re: SSL cPanel mySql setup

Neville, Can't you install LC Server on your own on your Dreamhost account. I remember there were others on the list or in the forum who were successful with installing LC Server on their Dreamhost account. - Matthias Rebbe Life Is Too Short For Boring Code > Am 18.10.2020 um 01:32 schrieb

Re: SSL cPanel mySql setup

Thanks to this thread for the realisation my remote db connections are not secure. I just checked with Dreamhost and they gave their reasons for not use SSL with their mySQL setup — unacceptable burden on their server and undesirable for web app access; so in their opinion very few shared host

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

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

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