My head is currently hitting off the wall trying to setup this cgi.

Firstly I got the Internal Error and had to insert the debug line into the db.cgi file, can't get any further, checked permissions, etc, etc. Please help!

Here is my current error:

DBMan encountered an internal error.



CGI ERROR
==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: Can't locate /web/cgi-bin/dbman/html.pl in @INC (@INC contains: /web/cgi-bin/dbman /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005 .) at default.cfg line 49.

Script Location : /home/sites/site10/web/cgi-bin/dbman/db.cgi
Perl Version : 5.00503
Setup File : default.cfg

Could you please save your default.cfg as a text file and upload to somewhere where we can view it? We should be able to get a better idea of how to fix the problem that way.

- Mark


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

Here is the address

http://www.heirloomireland.com/cgi-bin/dbman/default.cfg

Well your .cfg looks fine.

The error message you are getting:
Can't locate /web/cgi-bin/dbman/html.cgi

Have you changed the $db_script_path variable in db.cgi?
Generally you shouldn't need to, you can just leave it as "."

If you have changed it, make sure it is set to the full path of the script.
Which in this case looks like: /home/sites/site10/web/cgi-bin/dbman

- Mark


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

Am already using the full correct path as "." didn't work.

Any other ideas?? Please:)

Hmmm, why have you named your:
# Full path and file name of the html routines.
require $db_script_path . "/html.cgi";

It should be:

# Full path and file name of the html routines.
require $db_script_path . "/html.pl";

Your script errors because it's looking for html.pl and you have called it html.cgi, try changing it.
Rob

I changed all the .pl files to .cgi hoping that would work, but as you can see it didn't.

I have just changed the file names back to their defaults, same problem :(

Can you post a link to your current default.cfg please? The one in the post above must be your old one?

just checked this is the correct link

http://www.heirloomireland.com/cgi-bin/dbman/default.cfg

probably cause I was just messing with it there now..

You 100% sure that html.pl is renamed on the server? It can't find that file. Permissions ok? transferred via ASCII (sorry not being pedantic)

would it have anything to do with the html.pl file??

Could be

Can you post a link to it please? Save it as a text file on a public area on a server though.

URL of html.pl text file

http://www.heirloomireland.com/htmlpl.txt

Ok, we need to try the following:-

1. Rename html.cgi to html.pl and ensure that is what is referenced in default.cfg
2. In db.cgi set this:-
$db_script_path = ".";
3. At the beginning of the db.cgi script insert this:-
BEGIN {
open (STDERR, ">/www/data/antrim/error.txt");
}
immediately after your #!/usr/local/bin/perl line(or equivalent) where www/data/antrim etc. is the full correct path and not the url.
4. Run http://www.antrimcarpets.com/cgi-bin/antrim/db.cgi?db=default and then look at error.txt for better info.

Now getting a new error after making a few changes:

DBMan encountered an internal error.



CGI ERROR
==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: syntax error at ./html.pl line 61, near "


Here is the first few lines of my html.pl:

#
# ----------------------
# DBMan
# ----------------------
# Database Administrator
#
# File: html.pl
# Description: This file contains all the HTML that the program generates.
# Author: Alex Krohn
# Web: http://www.gossamer-threads.com/
# Version: 2.05
# CVS Revision: $Id: html.pl,v 1.3 2000/07/08 18:14:40 alex Exp $
#
# COPYRIGHT NOTICE:
#
# Copyright 1997 Gossamer Threads Inc. All Rights Reserved.
#
# This program is being distributed as shareware. It may be used and
# modified free of charge for personal, academic, government or non-profit
# use, so long as this copyright notice and the header above remain intact.
# Any commercial use should be registered. Please also send me an email,
# and let me know where you are using this script. By using this program
# you agree to indemnify Gossamer Threads Inc. from any liability.
#
# Selling the code for this program without prior written consent is
# expressly forbidden. Obtain permission before redistributing this
# program over the Internet or in any other medium. In all cases
# copyright and header must remain intact.
#
# Please check the README file for full details on registration.
# =====================================================================

##########################################################
## HTML Globals ##
##########################################################
# Put any globals you like in here for your html pages.
$html_title = 'NexusCafe-N.Ireland's Business Park';

##########################################################
## Record Layout ##
##########################################################

sub html_record_form {
# --------------------------------------------------------
# The form fields that will be displayed each time a record is
# edited (including searching). You don't want to put the
# <FORM> and </FORM tags, merely the <INPUT> tags for each field.
# The values to be displayed are in %rec and should be incorporated
# into your form. You can use &build_select_field, &build_checkbox_field
# and &build_radio_field to generate the respective input boxes. Text and
# Textarea inputs can be inserted as is. If you turn on form auto
# generation, the program will build the forms for you (all though they may
# not be as nice). See the README for more info.

my (%rec) = @_;
($db_auto_generate and print &build_html_record_form(%rec) and return);

my $font_color = 'Font face="Verdana, Arial, Helvetica" Size=2 Color=#003399';

print qq|
<TABLE WIDTH="450" CELLPADDING=0 CELLSPACING=0 BORDER=1 BGCOLOR="#FFFFCC">
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><$font_color>UserID:</FONT></TD>
<TD VALIGN="TOP" WIDTH="475"> <INPUT TYPE="TEXT" NAME="UserID" SIZE="20" VALUE="$rec{'UserID'}"

Oh by the way my cgi is now at
http://www.antrimcarpets.com/cgi-bin/antrim/db.cgi

NOT heirloomireland.com

Can you save your html.pl into a text file on a publicly accessible server please.

here you go. The html.pl text file can be found at:
http://www.antrimcarpets.com/htmlpl.txt

did you put that debug code into db.cgi?
If so please post the error.txt content

the error code u gave me doesn't work for some reason??

I can see one problem:
$html_title = 'NexusCafe-N.Ireland's Business Park';

You'll need to escape that quote, as it is breaking the string:
$html_title = 'NexusCafe-N.Ireland\'s Business Park';

- Mark


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

THANK YOU :)

I am now getting to the login page (wait for it!), but can't login.

What next????

All sorted. Thanks everybody that helped. Best support I've got on the net yet:)