database access...

[shadowslash]

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?

[RRobert]

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

Why not? Doesn't your CGI script run on the same server?

Robert

[shadowslash]

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

[RRobert]

Try to run the script from the shell and see what revolution says or examine the error log of the webserver.

Robert

[shadowslash]

Try to run the script from the shell and see what revolution says or examine the error log of the webserver.

Robert

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]

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

Do you have shell access via SSH2? Or access to the apache log directory?

PS: Do you use Windows, Mac or Linux locally?

Robert

[shadowslash]

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

Do you have shell access via SSH2? Or access to the apache log directory?

PS: Do you use Windows, Mac or Linux locally?

Robert

I use Windows and quite frankly, I haven't the slightest idea about SSH2... x)

[RRobert]

Does your hoster write something about SSH on his website?

PS: puTTY is a free SSH client.

Robert

[Mark]

You can find a version of PuTTy here: http://qurl.tk/a8

Best,

Mark

[bangkok]

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

I had the same problem.

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.

[Klaus]

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

[bangkok]

FYI: Version 3.5 of Rev was the last version you could use as a CGI engine!
RunRev removed this feature from later versions!

Ah ah ah ah !



Now I understand...

Oh my god, I lost a couple of hours on this...

Anyway.