Gossamer Forum
Home : Products : DBMan : Installation :

CGI Error on Win 2000 Server

Quote Reply
CGI Error on Win 2000 Server
I've read many posts here but can't find the answers I'm looking for. I feel like my head is going to burst.

I have a working version of DBMan on a UNIX server, but I'm trying to move it over to a new server which is on a Windows 2000 Server platform. I'm encountering an error when I try to open the db.cgi file.

To view the error, go to www.mboxdesign.com/cgi_error.txt

To view my default.cfg file go to
www.mboxdesign.com/default_cfg.txt

Please let me know what is set wrong. I'm dyin' here!

Thanks for your support.

- Junethesis.

Quote Reply
Re: CGI Error on Win 2000 Server In reply to
Have you tried using the following in the db.cgi script?

Code:

$db_script_path = "C:/Inetpub/wwwroot/www.naet.com/dbman";


Regards,

Eliot Lee
Quote Reply
Re: CGI Error on Win 2000 Server In reply to
I had tried a relative path earlier, just "\dbman" but that didn't work.

I just entered the entire path like you said and I still am getting the same error. Unfortunately, you won't be able to see it directly because I'm working off of the server locally - it's not on the web yet.

Any other ideas?

Quote Reply
Re: CGI Error on Win 2000 Server In reply to
Yea...ALL your VARIABLES in the default.cfg file are WRONG...

You need to use the following:

Code:

# 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 are using RELATIVE paths in the DEFAULT.CFG, which is causing the problem...in addition, you probably should use the complete FULL/ABSOLUTE path for the $db_script_path as I already suggested.

Regards,

Eliot Lee
Quote Reply
Re: CGI Error on Win 2000 Server In reply to
Still - that doesn't do it. I've saved another file for you to look at the error page now. Just go to the same URL but enter cgi_error2.txt

I think it's all the same.

Also I added a 2nd cfg: default_cfg2.txt

Quote Reply
Re: CGI Error on Win 2000 Server In reply to
Looks like you did not follow my earlier advice, by editing the $db_script_path variable in the db.cgi script.

Regards,

Eliot Lee
Quote Reply
Re: CGI Error on Win 2000 Server In reply to
Yes I did - that's what's there now. Here, I'll copy and paste it:

$db_script_path = "C:/Inetpub/wwwroot/www.naet.com/dbman";

See? Isn't that it? The one in the dbman directory.

Quote Reply
Re: CGI Error on Win 2000 Server In reply to
I solved my problem by doing two things:

1) For some reason there were two default.cfg files in separate folders and I was making changes to the wrong one. I replaced the old one with the new one but still has encountering an error.

2) The hardcoded path you told me to change by script dir path to was wrong, not that you knew that, but I had to change it to my cgi directory.

Now I have one last question to prevent security risks. How should each DBMan directory have its permissions set to prevent problems?

Thanks for your help.

- Junethesis.

Quote Reply
Re: CGI Error on Win 2000 Server In reply to
In Reply To:
How should each DBMan directory have its permissions set to prevent problems?
Surprisingly you will need to read the README

So when you see a file called README, what do you do....ignore it!



Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Quote Reply
Re: CGI Error on Win 2000 Server In reply to
Don't get nasty. I didn't have a readme file because someone else installed this DBMan.

Check your attitude kind sir.

Quote Reply
Re: CGI Error on Win 2000 Server In reply to
I'm not getting nasty and don't have an attitude. It is just common sense to read the README. Or at least make sure you HAVE the README in the first place.

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Quote Reply
Re: CGI Error on Win 2000 Server In reply to
The readme doesn't say anything about setting permissions in Windows, so it wouldn't have helped much anyway...

I suggest you download DBMan again, if not just for the sake of having the readme.

<cut><paste>
Code:
You should find the following files in the archive and they
should have the following permissions

db.cgi (755) -rwxr-xr-x
html.pl (644) -rw-r--r--
auth.pl (644) -rw-r--r--
default.cfg (644) -rw-r--r--
default.pass (666) -rw-rw-rw-
default.count (666) -rw-rw-rw-
default.log (666) -rw-rw-rw-
default.db (666) -rw-rw-rw
auth (777) drwxrwxrwx
README.txt (644) -rw-r--r--

The only file that should be accessible from the net is db.cgi.
All requests to the script will go through db.cgi, and letting people
view the password file or auth directory is a major security risk
(risk to DBMan's built in security, not to the security of the system).
You can get by, by making sure Directory Indexing is off (and rename
the files, security through obfuscation) or by placing all the files
in a cgi-bin directory (preferred).
</cut></paste>

- Mark


Astro-Boy!!
http://www.zip.com.au/~astroboy/