Gossamer Forum
Home : Products : DBMan : Installation :

OpenVMS blues

Quote Reply
OpenVMS blues
I'm stuck with OpenVMS; it does run Perl 5, so that's good.

Here's the URL I'm trying to run:
http://www.muohio.edu/cgi/~zoomuscwis/db.cgi

I absolutely cannot get "db.cgi" to run correctly. (Yes, I'm using the correct URL; I've tested sample CGI scripts here successfully.) Here is the server error message:


Code:
CGI ERROR
==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: Can't locate sys_users:[zoo.zoomuscwis.www.cgi]/html.pl in @INC at /sys_users/zoo/zoomuscwis/www/cgi/default.cfg line 51.

Script Location : sys_users:[zoo.zoomuscwis.www.cgi]db.cgi;3
Perl Version : 5.00397
Setup File : default.cfg

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

This error message is generated from the first section of the db.cgi file:

Code:
#!/usr/local/bin/perl

# If you run into problems, set $db_script_path to the full path
# to your directory.
$db_script_path = "sys_users:[zoo.zoomuscwis.www.cgi]";

# Load the form information and set the config file and userid.
local(%in) = &parse_form;
$in{'db'} ? ($db_setup = $in{'db'}) : ($db_setup = 'default');
$in{'uid'} ? ($db_uid = $in{'uid'}): ($db_uid = '');

# Required Librariers
# --------------------------------------------------------
# Make sure we are using perl 5.003, load the config file, and load the auth file.
eval {
unshift (@INC, $db_script_path);
require 5.003; # We need at least Perl 5.003
unless ($db_setup =~ /^[A-Za-z0-9]+$/) { die "Invalid config file name: $db_setup"; }
require "$db_setup.cfg"; # Database Definition File
require "auth.pl"; # Authorization Routines
};


The documentation tells me to edit another file, default.cfg and "set $db_dir_url to the director that db.cgi resides in." Here's the head of that file:


Code:
# File and URL's
# --------------------------------------------------------
# URL of the directory dbman resides in. No Trailing Slash Please.
$db_dir_url = "sys_users:[zoo.zoomuscwis.www.cgi]";
# 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";



You'll note that I have used fully qualified paths to the cgi script directory, because I thought the problem lay with relative paths:
sys_users:[zoo.zoomuscwis.www.cgi]

Please help!



Quote Reply
Re: OpenVMS blues In reply to
$db_dir_url = "sys_users:[zoo.zoomuscwis.www.cgi]";

This needs to be a URL, not a path. Maybe it is a URL, but I've always seen URLs start with "http://." Yours doesn't?

I'm also not familiar with using brackets in paths, but that may be just something I haven't come across before.


------------------
JPD





Quote Reply
Re: OpenVMS blues In reply to
OK. I changed the URL to a standard one; I tried both relative and absolute, and still nothing happens. It seems to me that db.cgi simply cannot find default.cfg, but I don't know why.
Quote Reply
Re: OpenVMS blues In reply to
Try taking out

$db_script_path = "sys_users:[zoo.zoomuscwis.www.cgi]";

and just using the default

$db_script_path = ".";



------------------
JPD





Quote Reply
Re: OpenVMS blues In reply to
Thanks, I've done that now, and it's still not working.

Any other ideas?

Quote Reply
Re: OpenVMS blues In reply to
Can you give me a URL where I can see it?


------------------
JPD





Quote Reply
Re: OpenVMS blues In reply to
Sure, it's http://www.muohio.edu/cgi/~zoomuscwis/db.cgi .

Our server requires us to make the CGI reference before the account name, when in reality the CGI folder lies beneath the account folder (zoomuscwis).

I've had similar difficulties with another app called Webteacher's Webdata; it was unable to find the CGI folder either, no matter what I tried.
Quote Reply
Re: OpenVMS blues In reply to
I really do think it's a problem with your server. I suppose if all of the DBMan files were in one file, you might be able to get it to work. Except you'd still need to be able to write to the auth directory and that would put you back in the same position you're in now.

I encourage anyone who has any more knowledge of servers to throw in your opinions, because I'm way over my head here. Smile

Wish I could have been of more help.


------------------
JPD





Quote Reply
Re: OpenVMS blues In reply to
Thanks for the try, though!
Quote Reply
Re: OpenVMS blues In reply to
Have you been able to get any cgi scripts to work?


------------------
JPD





Quote Reply
Re: OpenVMS blues In reply to
Yes, very successfully, but then, they weren't nearly as sophisticated as this one.

Webdata doesn't seem to "know" that it is already IN the CGI folder, and that its buddies are there too. I blame OpenVMS because I see all you other people who can successfully install this, and I just know that you are using an OS that was written this century!
Quote Reply
Re: OpenVMS blues In reply to
Eureka! My network guy came back from vacation, and fixed it! I just needed a MUCH longer directory path than I expected:
Code:
/sys_users/zoo/zoomuscwis/www/cgi

Now I'm getting a password challenge, but wait! None of the passwords work (admin, author, guest). What gives?
Quote Reply
Re: OpenVMS blues In reply to
Yay! I'm glad your admin got things fixed for you.

re the passwords: Some servers use a different encryption than others do. Here's the fix for it.

Open up default.cfg.

Set
$auth_no_authentication = 1;
@auth_default_permissions = (1,1,1,1,1);

Upload the file and then go to the database. You won't have to enter a password at all.

Select the "Admin" link and create a new userid and password for yourself. Be sure to click all the checkboxes at the bottom of the screen.

Then go back to default.cfg and set
$auth_no_authentication = 0;
@auth_default_permissions = (1,1,1,1,0);

(If you're using the demo, it won't really matter, but you may want that to be changed later.)

Save and upload the new default.cfg and go to the database again. This time you should see the login screen. Enter the username and password you added before. You should get logged on with admin permissions.


------------------
JPD