database access...
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- Posts: 344
- Joined: Tue Feb 24, 2009 6:14 pm
- Location: Philippines
- Contact:
database access...
I haven't tested this yet but would still like confirmation before I do... I have already set up a fully working revCGI from the rev3.5-gm-2 engine on my hosting. my hosting offers up to 3 SQL databases for me to use.. my question is, will revCGI or *.cgi scripts on my server be able to access the database that my host provided? take note that my host doesn't support remote access to the MySQL database...
any insights or experiences on these aspects?
any insights or experiences on these aspects?
Re: database access...
Why not? Doesn't your CGI script run on the same server?will revCGI or *.cgi scripts on my server be able to access the database that my host provided? take note that my host doesn't support remote access to the MySQL database...
Robert
-
- Posts: 344
- Joined: Tue Feb 24, 2009 6:14 pm
- Location: Philippines
- Contact:
Re: database access...
yes but when I try to run a test page for INSERTing VALUES into the database, it gives me a "500 Internal Server Error"... i don't know what the reason is for that case either..
Re: database access...
Try to run the script from the shell and see what revolution says or examine the error log of the webserver.
Robert
Robert
-
- Posts: 344
- Joined: Tue Feb 24, 2009 6:14 pm
- Location: Philippines
- Contact:
Re: database access...
I'm not sure I follow what you stated. What do you mean by try to run the script from the shell? Oh and additional information, my hosting provider seems to be using a Linux box...RRobert wrote:Try to run the script from the shell and see what revolution says or examine the error log of the webserver.
Robert
Re: database access...
Do you have shell access via SSH2? Or access to the apache log directory?shadowslash wrote:I'm not sure I follow what you stated. What do you mean by try to run the script from the shell? Oh and additional information, my hosting provider seems to be using a Linux box...
PS: Do you use Windows, Mac or Linux locally?
Robert
-
- Posts: 344
- Joined: Tue Feb 24, 2009 6:14 pm
- Location: Philippines
- Contact:
Re: database access...
I use Windows and quite frankly, I haven't the slightest idea about SSH2... x)RRobert wrote:Do you have shell access via SSH2? Or access to the apache log directory?shadowslash wrote:I'm not sure I follow what you stated. What do you mean by try to run the script from the shell? Oh and additional information, my hosting provider seems to be using a Linux box...
PS: Do you use Windows, Mac or Linux locally?
Robert
Re: database access...
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
Re: database access...
I had the same problem.shadowslash wrote:yes but when I try to run a test page for INSERTing VALUES into the database, it gives me a "500 Internal Server Error"... i don't know what the reason is for that case either..
It migth be related to the way you have installed the rev cgi.
- put in comment/delete all your DB commands and functions within your cgi. My point : my own cgi was working perfect.... until I started to add DB related script. I had too a 500 internal server error
This little test should help you to trace the origin of the problem. If it's related to DB functions, then it's linked to your rev cgi installation : DB drivers, even the runtime version etc. and the tricky issue of path (for the db driver for instance)
For instance, during my own tests : i had problems with a runtime 4.5 and 4. So I took a version 3.5 and then it was working fine.
Re: database access...
FYI: Version 3.5 of Rev was the last version you could use as a CGI engine!
RunRev removed this feature from later versions!
Best
Klaus
RunRev removed this feature from later versions!
Best
Klaus
Re: database access...
Ah ah ah ah !Klaus wrote:FYI: Version 3.5 of Rev was the last version you could use as a CGI engine!
RunRev removed this feature from later versions!
Now I understand...
Oh my god, I lost a couple of hours on this...
Anyway.