Gossamer Forum
Home : Products : DBMan : Installation :

Installing on new server

Quote Reply
Installing on new server
Several years ago my DBMan database was working fine but my ISP (former) wiped out everything.

Now I am attempting to reinstall on Earthlink.

My files can be inspected at http://limericks.org/DBManStuff

Earthlink tells me my cgi bin is named cgi

(quote)you will not have cgi-bin folder, however you have another folder called cgi where you can place all the cgi scripts. once you login to FTP your website, you will logged into webdocs folder which is the default folder, in the webdocs folder you can see the cgi folder.(endquote)

I have uploaded all my DBMan files to the cgi folder, but I don't know how to test/run them. The JPDeni's Tutorial tells me to go to a modified url [limericks.org/cgi/dbman/db.cgi]

http://server/cgi-bin/dbman/db.cgi

but I get a 500 Internal Server Error

Earthlink says (quote)I'm sorry to inform you that you cannot run the CGI script directly, you have to use html file to call the CGI script then it gets executed.(endquote)

My attempts to call the cgi script fail.

I think there is something basic that I do not understand.

Arthur




Quote Reply
Re: [copy3] Installing on new server Additional Info In reply to
My real database is limbib

Arthur
Quote Reply
Re: [copy3] Installing on new server Additional Info In reply to
Post a link (or pm me) with the actual url where you get the error message. I tried every combination I can think of and didn't get a good url to test it with.
Quote Reply
Re: [Watts] Installing on new server Additional Info In reply to
My domain is limericks.org and I have placed DBMan stuff in limericks.org/cgi/dbman

limbib.cgi and db.cgi

If I go to http://limericks.org/cgi/dbman/db.cgi I get
a 500 message

If I go to http://limericks.org/cgi/dbman/limbib.cgi I get the equivalent of a 404 message

email me for password if that will help arthur@limericks.org


Arthur
Quote Reply
Re: [copy3] Installing on new server Additional Info In reply to
Silly question but do you have a password, log and count file in your directory also?

And did you check to see if the call to perl is what your server uses (i.e. #!/usr/bin/perl).

Add this to the top of your script below the call to perl and see if it will display any error messages:

use CGI::Carp qw/fatalsToBrowser/; # For testing only

perhaps that will help to find out what may be causing the errors.

You could also add it to the other files also (html and .cfg).

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [LoisC] Installing on new server Additional Info In reply to
Thanks for your help so far...

I have started over from scratch.

Complete installation info is displayed at http://limericks.org/dbman1HTML/Demo_Files_dbman1.html

I do have password, log, & count files.

Earthlink confirms location of Perl.

Running my db.cgi file results in:
"DBMan encountered an internal error. Please enable debugging to view"

No joy (or anything) when degugging is enabled.

Arthur
Quote Reply
Re: [copy3] Installing on new server Additional Info In reply to
I didn't see the error line displaying in the scripts which might show what the errror could be? Please add this line and see if it will display any error messages:

use CGI::Carp qw/fatalsToBrowser/; # For testing only

-------------------

Other Suggestions:

In your .cfg file move the line:

$db_debug = 1;

up to above the line:

# File and URL's

That will be sure to catch any errors within the .cfg file itself.

=======================

In your cgi file near the top change:

$db_script_path = "http://www.limericks.org/cgi/dbman1";

back to the original of:

$db_script_path = ".";

There are only rare instances where this needs to be changed.

--------------------

In your .cgi file try replacing the this sub .... to see if it would reveal your errors.

sub cgierr { ### modified this for security .. to not show env variables when there is an error 5/20/2000
# --------------------------------------------------------
# Displays any errors and prints out FORM and ENVIRONMENT information. Useful for debugging.

if (!$html_headers_printed) {
print "Content-type: text/html\n\n";
$html_headers_printed = 1;
}

print "<PRE>\n\nCGI ERROR\n==========================================\n";
$_[0] and print "Error Message : $_[0]\n";
if ($db_debug) { #### added this line #######
$0 and print "Script Location : $0\n";
$] and print "Perl Version : $]\n";
$db_setup and print "Setup File : $db_setup.cfg\n";
$db_userid and print "User ID : $db_userid\n";
$db_uid and print "Session ID : $db_uid\n";

print "\nForm Variables\n-------------------------------------------\n";
foreach $key (sort keys %in) {
my $space = " " x (20 - length($key));
print "$key$space: $in{$key}\n";
}
print "\nEnvironment Variables\n-------------------------------------------\n";
foreach $env (sort keys %ENV) {
my $space = " " x (20 - length($env));
print "$env$space: $ENV{$env}\n";
}
print "\n</PRE>";
####### new lines ###########
}
else {
#This links to your e-mail if someone receive a link to this page
print "\n\nPlease e-mail the <A HREF=\"mailto: $error_email\">Webmaster</A> and report the error stated.";
}
##### end new lines ###########
exit -1;
}

---------------
I looked at the earthlink site to see if I could find anything related to their use of scripts and I did find that they offer a script called:

Perl Debugger
This CGI script allows you to check the validity of Perl scripts on your Web site.

I'm also wondering if you are using a unix or windows based server??? This would make a big difference in setting up your script.

Also have you tried running any of their free scripts just to see if they will work with your account.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [LoisC] Installing on new server Additional Info In reply to
QUICK RESPONSE (no time to change scripts yet)

" I looked at the earthlink site to see if I could find anything related to their use of scripts and I did find that they offer a script called:

Perl Debugger
This CGI script allows you to check the validity of Perl scripts on your Web site.
"

Earthlink Chat says they have no Perl Debugger script but they would like to have a link to one -- can you help out on that?



" I'm also wondering if you are using a unix or windows based server? " UNIX



Earthlink site says:

"After the scripts are uploaded, the execute bit must be set before they can be used. Request this by contacting EarthLink Web Support by sending email to: startersite@earthlink.net. Remember, EarthLink does not allow world-writable (777, 766, etc.) files in the cgi directory, neither can script files be set to world-writable (777, 766, etc.). "

What should my CHMOD values be rest to?


Arthur