Search found 12 matches

by LeeC
Mon Nov 03, 2014 5:11 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

Perfect, the script above works a treat which means with a bit of fiddling around with my script I should be able to get it to work.
Thanks for all your help guys.
by LeeC
Mon Nov 03, 2014 4:41 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

Is there a very simple script I can run just to test connectivity to the database or is the one I am using as simple as I can get?
by LeeC
Mon Nov 03, 2014 4:29 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

Yes, I removed whatever version I had and replaced it with the 6.0.1 as you suggested.
by LeeC
Mon Nov 03, 2014 3:34 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

So, I have removed whatever version I had installed and replaced it with 6.01 and the error has changed to Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator at webmaster@localhost to inf...
by LeeC
Mon Nov 03, 2014 2:07 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

Thanks for the quick replies. Here is my file permission root@Livecode:/usr/lib/cgi-bin# ls -l total 12600 drwxr-xr-x 2 root root 4096 Oct 9 04:19 drivers drwxr-xr-x 2 root root 4096 Oct 9 04:19 externals -rwxr-xr-x 1 root root 12892072 Sep 19 11:33 livecode-community-server yes tried every combo of...
by LeeC
Mon Nov 03, 2014 12:17 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

Thanks again for the assistance.

Yes I believe the server configuration is correct.
The date script can be run correctly here 178.62.12.137 / date.lc and the Hello world script to 178.62.12.137 / test.lc

The externals and drivers are installed into /usr/lib/cgi-bin and I have chmod them to 755 again
by LeeC
Mon Nov 03, 2014 9:41 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

Hi, As I said I am a beginner to all of this but I working in the computer environment. The server I have is a virtual server which is hosted with Digital Ocean. The server is Linux Ubuntu 14 installed as a LAMP server. I can connect to MySQL with PHPMyadmin and I have tried my script with the root ...
by LeeC
Fri Oct 31, 2014 6:15 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

Thanks Dave ill give it a try when I get home this evening.
by LeeC
Fri Oct 31, 2014 2:42 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

Still cant get it working. I have written several different scripts trying to get this to work. Checked all livecode server file and even set them to 777 but still get the same error from the webpage or from the command line.
Any other suggestions for a quickly balding man.
by LeeC
Fri Oct 31, 2014 9:20 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

Hi,

I have tried everything from 127.0.0.1, localhost and the public IP of my server.

Also, I have tried populating the connector with all the details. The script works fine if I do it from my desktop specifying the public IP.
by LeeC
Thu Oct 30, 2014 6:08 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Re: Database connection so frustrating

Thanks for the reply Martin, unfortunately it hasn't made a difference.
by LeeC
Thu Oct 30, 2014 5:22 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Database connection so frustrating
Replies: 25
Views: 15416

Database connection so frustrating

First of I should say I know next to nothing about programming though I have dabbled a little over the years. Over the last week I have been trying to learn Livecode which was going reasonably well until I stumbled on a forum post about database security and not having your SQL credentials in the ma...