Hello,



after uploading DbMan (german version) i only get the following error message:

CGI ERROR
==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: Can't locate ./home/strato/www/ta/www.tacitus-online.de/htdocs/cgi-bin/dbman/html.pl in @INC (@INC contains: . /opt/KQperl/lib/sun4-solaris/5.00405 /opt/KQperl/lib /opt/KQperl/lib/site_perl/sun4-solaris /opt/KQperl/lib/site_perl .) at default.cfg line 51.

Script Location : db.cgi
Perl Version : 5.00405
Setup File : default.cfg

Form Variables
-------------------------------------------

Environment Variables
-------------------------------------------
DOCUMENT_ROOT : /home/strato/www/ta/www.tacitus-online.de/htdocs
GATEWAY_INTERFACE : CGI/1.1
HTTP_ACCEPT : */*
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_ACCEPT_LANGUAGE: de
HTTP_CONNECTION : Keep-Alive
HTTP_COOKIE : fkuhn=admin; lama=yyQcHB.blpxnI
HTTP_HOST : www.tacitus-online.de
HTTP_USER_AGENT : Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; DT; Q312461)
QUERY_STRING :
REMOTE_ADDR : 217.84.138.220
REMOTE_PORT : 5022
REQUEST_METHOD : GET
REQUEST_URI : /cgi-bin/dbman/db.cgi
SCRIPT_FILENAME : /home/strato/www/ta/www.tacitus-online.de/htdocs/cgi-bin/dbman/db.cgi
SCRIPT_NAME : /cgi-bin/dbman/db.cgi
SCRIPT_URI : http://www.tacitus-online.de/cgi-bin/dbman/db.cgi
SCRIPT_URL : /cgi-bin/dbman/db.cgi
SERVER_ADMIN : service@webmailer.de
SERVER_NAME : www.tacitus-online.de
SERVER_PORT : 80
SERVER_PROTOCOL : HTTP/1.1
SERVER_SOFTWARE : Apache/1.3.11 (Unix) mod_x-httpd-php4_script
TZ : MET
UNIQUE_ID : PG51XcCoChQAAAarzCE

Does anyone know the problem?



Frank

Have you uploaded all the files into the same directory? It looks as though DBMan is attempting to locate html.pl in a different directory from db.cgi.

Check for configuration errors on or about default.cfg line 51. If you do not spot anything, you'll need to save your cfg file as a text file and upload to your server so it can be viewed via the web.

Hello Karen,

thanks for posting, but it didn' t work. I made an error by setting the wrong URL to the db.cgi. But after changing it to the right variable it didn' t work either.

I' ve uploaded the file:

http://www.tacitus-online.de/default.txt



Frank

Your cfg file setting should look like this:

$db_dir_url = "http://www.tacitus-online.de/cgi-bin/dbman";
$db_script_url = $db_dir_url . "db.cgi";
$db_file_name = $db_script_path . "default.db";
$db_id_file_name = $db_script_path . "default.count";
$auth_dir = $db_script_path . "auth";
$auth_pw_file = $db_script_path . "default.pass";
$auth_log_file = $db_script_path . "default.log";
require $db_script_path . "html.pl";

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

And it worked: thank you!

Hi there - I am a new user.

After uploading the demo system I experienced the same CGI ERROR problem as frankk. But LoisC's fix did not work for me I noticed that in LoisC's suggestions for cfg filenames that there was no leading "/" and this resulted in a bad filename "bdmanhtml.pl". I reloaded the default html.pl file but still got the CGI error even though html.pl exists and was uploaded as ASCII and the file permissions are set -rw-r--r--.

Any ideas what else could be wrong?

I am using Perl 5.00503 on Apache 1.3.6 (UNIX)

That explains why Lois's instructions didn't work for you - the instructs she listed were for a NT server where the .cgi file had been changed to show the full system path.

On your default.cfg file, doublecheck that you have:

Defined the correct URL to the DBMAN directory on your domain.

Have numbered your fields sequentially starting with "0" ( 0 1 2 3 ...)

Have a comma ( , ) at the end of each field definition EXCEPT the last one.

In html.pl (or whatever you've named it) check that you have:

Defined an input field (TEXT or HIDDEN) in sub html_form for each field in your database.

In db.cgi check the first line in the file to make sure you have the correct path/to/perl defined for your system.

If you still have problems after checking each of those items, save your default.cfg and html.pl files as text files (default.txt and html.txt) and upload the files to your server in a location where they can be viewed via the web. Post again and provide the URL's to your files and someone will be able to take a look and help you troubleshoot.



~ Karen

I have checked my files using Karen's checklist....

default.cfg
Q1 Defined the correct URL to the DBMAN directory on your domain
A1 Yes - $db_dir_url = "http://www.netlineservices.co.nz/cgi/dbman";

Q2 Have numbered your fields sequentially starting with "0" ( 0 1 2 3 ...)
A2 Yes - I am using the demo default.cfg and fields are numbered 0 .. 9

Q3 Have a comma ( , ) at the end of each field definition EXCEPT the last one.
A3 Yes - as per the demo default.cgi

html.pl
Q4 Defined an input field in sub html_form for each field in your database.
A4 In the demo html.pl all input fields are defined in sub html_record_form (NOTE: there is no sub html_form)

db.cgi
Q5 First line has the correct path/to/perl
A5 Yes - for my server it is #!/usr/bin/perl

I have uploaded as ASCII files all the demo files, amended as above,
but still have the CGI ERROR.

My default.cfg and html.pl files as text files (default.txt and html.txt) may be viewed at http://www.netlineservices.co.nz/
I have also included the CGI ERROR log (cgi_error.txt) and db.cgi (db.txt).

Thanks for also posting your db.cgi file - It looks as though the problem is originating there.

<!--StartFragment-->$db_script_path = http://www.netlineservices.co.nz/cgi/dbman;


Try changing that line back to the line from the original download:

$db_script_path = ".";



Your URL path has already been identified in the config file, it doesn't need to be identified in the db.cgi file.

Apologies for the inconvenience of identifying that sub inaccurately - the figure skating finals are on ... a bit distracted.

~ Karen

Hi Karen,

Everything now works fine. Thanks for the prompt replies - I am most impressed. Take a break and get back to the skating.