Gossamer Forum
Home : Products : DBMan : Installation :

wits end...

Quote Reply
wits end...
I installed dbMan on another host service a few years ago but am having real trouble now.

I have the following in my default.cfg
# URL of the directory dbman resides in. No Trailing Slash Please.
$db_dir_url = "http://www.lechai.com/cgi-bin/dbman";
# URL of dbman.
$db_script_url = $db_dir_url . "/db.cgi";
# Full Path and File name of the database file.
$db_file_name = $db_script_path . "/default.db";
# Full path and file name of the counter file.
$db_id_file_name = $db_script_path . "/default.count";
# Full path and file name of the authorization directory.
$auth_dir = $db_script_path . "/auth";
# Full path and file name of the password file.
$auth_pw_file = $db_script_path . "/default.pass";
# Full path and file name of the log file.
$auth_log_file = $db_script_path . "/default.log";
# Full path and file name of the html routines.
require $db_script_path . "/html.pl";

All files uploaded to a cgi-bin/dbman directory that has the proper permissions and all files uploaded in ASCII. All I get are Internal Server Error.

In a previous life I got dbMan to work with the following config file information:

# URL of the directory dbman resides in. No Trailing Slash Please.
$db_dir_url = "http://www.abcinvestments.com/admin/dbman";
# URL of dbman.
$db_script_url = $db_dir_url . "/db.cgi";
$db_script_path = $ENV{DOCUMENT_ROOT} ."/admin/dbman";
# Full Path and File name of the database file.
$db_file_name = $ENV{DOCUMENT_ROOT} . "/cgi-local/alerts.db";
# Full path and file name of the counter file.
$db_id_file_name = $db_script_path . "/alerts.count";
# Full path and file name of the authorization directory.
$auth_dir = $db_script_path . "/auth";
# Full path and file name of the password file.
$auth_pw_file = $db_script_path . "/alerts.pass";
# Full path and file name of the log file.
$auth_log_file = $db_script_path . "/alerts.log";
# Full path and file name of the html routines.
require $db_script_path . "/html.pl";

I can't exactly remember, but it seems that on the server that abcinvestments.com was on I had problems getting db.cgi to find the scripts and the files and therefore had to "force" it. The server I am on now offers the following configuration information from the script serverinfo.cgi (so I know that something will work in the cgi-bin directory!):

DOCUMENT_ROOT: /home/com/lechai/html
HTTP_HOST: www.lechai.com
EQUEST_URI: /cgi-bin/serverinfo.cgi
SCRIPT_FILENAME: /home/com/lechai/cgi-bin/serverinfo.cgi
SCRIPT_NAME: /cgi-bin/serverinfo.cgi
SCRIPT_URI: http://www.lechai.com/cgi-bin/serverinfo.cgi
SCRIPT_URL: /cgi-bin/serverinfo.cgi


It has been too long since I installed dbMan and therefore I can't remember what I did before (four years ago) to get the sucker to work. I hope someone can help me out.

Thanks in advance
Quote Reply
Re: [cadpi] wits end...still In reply to
another night of frustration trying to get dbman working. I have been able to get two other scripts to work, but dbman continues to give 500 Internal Server Error. I cannot get a telnet prompt on this server so I can't check the perl syntax with perl -c and I can't get the debugging to work. All permissions set correctly, dbman installed in http://www.lechai.com/cgi-bin/db.cgi

here are links to the default.cfg and db.cgi

http://www.lechai.com/db.txt
http://www.lechai.com/default.txt

I am ready to tear my hear out b/c it shouldn't be this hard. Here is a link to a script that works
http://www.lechai.com/cgi-bin/serverinfo.cgi
and the text of it
http://www.lechai.com/serverinfo.txt

Any help is appreciated -
Quote Reply
Re: [cadpi] wits end...still In reply to
I can't spot anything wrong in your .cfg file. and the path to perl is correct for the db.cgi file.

You did create the /auth directory?

To get server error messages insert this in the top of your .cfg, .html.pl, and db.cgi file (under the path to perl)


BEGIN {
open (STDERR, ">/home/com/lechai/html/error.txt");
}

then create and upload a error.txt file in your route directory.

Run the script again and then check this file in another window and see if it displays any errors.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [LoisC] wits end...still In reply to
Finally got the demo to work. Thanks for your reply. Here's what I did to get it to work:

On the first line of db.cgi I added a -w at the end of the #!/usr/local/bin/perl

Don't know why the '-w' that makes the script work, but it does.