Gossamer Forum
Home : Products : DBMan : Installation :

HELP! No error description

Quote Reply
HELP! No error description
I can't figure this out. The debug is on, and it gives me an internal error, but no description on what that error is.

I had one before saying it couldn't find auth folder, so I added the auth folder and then I get this error now
http://www.teamfortresscentral.com/clans/db.cgi

I have also included a db.txt in same path for you to try to figure this out.

I have already tried to make the direct path in db.cgi to
http://www.teamfortresscentral.com/clans

But that didn't work, unless that is wrong, BTW that replaced the '.' that is in there right now.

Everything seems to be working, I just don't get why there is still an internal error?!?

Quote Reply
Re: HELP! No error description In reply to
If everything is working fine, you can turn off $db_debug in default.cfg by setting it to 0.

- Mark


Astro-Boy!!
http://www.zip.com.au/~astroboy/
Quote Reply
Re: HELP! No error description In reply to
Ok, that worked, but now I am editing it to fit my needs and I get an internal error and I turn ON debug and it still just says internal error with no description.

It is using default.cfg cause I only need one DB.

It is at the address specified above.

Also here is my current default.cfg. What is wrong?

Thanks for any information.
--------------------------------------------------------
#
# ----------------------
# DBMan
# ----------------------
# Database Administrator
#
# File: db.cfg
# Description: This is the setup file that contains the database definition,
# and most of the options required to set the program up.
# Author: Alex Krohn
# Web: http://www.gossamer-threads.com/
# Version: 2.05
# CVS Revision: $Id: default.cfg,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.
# =====================================================================

# File and URL's
# --------------------------------------------------------
# URL of the directory dbman resides in. No Trailing Slash Please.
$db_dir_url = "http://www.teamfortresscentral.com/clans";
# 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";

# Database Definition
# --------------------------------------------------------
# Definition of your database. Format is
# field_name => ['position', 'field_type', 'form-length', 'maxlength', 'not_null', 'default', 'valid_expr']

%db_def = (
Clan Name => [0, 'alpha', 40, 0, 1, '', ''],
Description => [1, 'alpha', '40x3', 500, 0, '', ''],
Current Leader => [2, 'alpha', 40, 255, 1, '', ''],
# of Members => [3, 'alpha', 40, 3, 1, '', ''],
Favorite Maps => [4, 'alpha', 40, 0, 0, '', ''],
IRC Channel => [5, 'alpah', 40, 0, 0, '', ''],
Webpage => [6, 'alpha', 40, 0, 0, '', ''],
Games Play => [7, 'alpha', 40, 0, 0, '', ''],
Quote => [8, 'alpha', 40, 0, 0, '', ''],
Main Country => [9, 'alpha', 40, 0, 0, '', '']
);

# The column name for the database key. Can be any column, but it must be unique!
# You can't have two records with the same key value!
$db_key = 'Clan Name';
# Track the key? Should DBMan keep a counter of the next key to use? This isn't
# neccessary if you can guarantee that your entry in the key field will be unique
# (i.e. a userid).
$db_key_track = 1;
# Database delimeter.
$db_delim = '|';
# Use file locking (1 = Yes, 0 = No). Should be used, but won't work on Win95.
$db_use_flock = 1;
# Auto generate the html forms (1 = Yes, 0 = No).
$db_auto_generate = 0;
# Display Benchmarking Information (1 = Yes, 0 = No).
$db_benchmark = 0;
# Display Debugging Information (1 = Yes, 0 = No).
$db_debug = 1;

# Select fields. Field name => 'comma seperated list of drop down options'.
%db_select_fields = (
Category => 'General,Configuration Management,Project Management,Process Improvement,Standards,Testing & Quality Assurance',
Type => 'Web,Newsgroup,Mailing List,FTP,Gopher'
);

# Radio fields. Field name => comma seperated list of radio buttons.
%db_radio_fields = ( Validated => 'Yes,No' );

# Checkbox fields. Field name => Checkbox value.
%db_checkbox_fields = ( Popular => 'Yes' );

# Default maximum number of hits returned in a search.
$db_max_hits = 20;
# Bold search results (1 = Yes, 0 = No).
$db_bold = 1;
# Regular and title fonts used in auto_generatrion and html.pl.
$font = 'font face="verdana,arial,helvetica" size="2"';
$font_title = 'font face="verdana,arial,helvetica" size="3"';

# Authorization Options
# --------------------------------------------------------
# No Authentication? (1 = "there is no authentication", 0 = "there is authentication")
# If you choose no authentication, then set the permissions of what
# people can do with: @auth_default_permissions below.
$auth_no_authentication = 0;

# The amount of time in seconds that user files are kept in the
# auth directory before the program removes them. 2-6 hours is
# probably a good value.
$auth_time = 21600; # 6 hours (in seconds)

# Enable (1) or disable (0) logging.
$auth_logging = 0;

# Allow a default user? This means you can specify a user via the URL
# and skip the logon process. Use this to allow people to search without
# logging on, but require log in if they want to add/modify/remove etc.
# (1 = "yes", 0 = "no")
$auth_allow_default = 1;

# Default permissions used if there is no authentication, or for a default
# user. (View, Add, Delete, Modify, Admin), 1 = enable, 0 = disable.
@auth_default_permissions = (1,0,0,0,0);

# Allow people to sign up for their own userid/passwords? They will
# recieve default permissions.
$auth_signup = 1;

# Permissions a new signup should get.
@auth_signup_permissions = (1,0,0,0,0);

# Registered users: can modify/delete _only_ own records. For this to make
# sense you should set default off or to 1,0,0,0.
$auth_modify_own = 1;

# Registered users: can view _only_ own records. For this to make sense
# you should turn off default permissions.
$auth_view_own = 0;

# Auth user field. This is the field position in the database used for storing
# the userid who owns the record. Set to -1 if not used.
$auth_user_field = 9;

# URL to send user if they chose log off. Leave blank and the script will return to
# the logon prompt (although this only makes sense if you are using authentication).
$auth_logoff = "http://www.teamfortresscentral.com/";

# ===========================================================================
# Build up some variables from your definitions. Internal use only.
foreach (sort { $db_def{$a}[0] <=> $db_def{$b}[0] } keys %db_def) {
push (@db_cols, $_);
$db_sort{$_} = $db_def{$_}[1];
$db_form_len{$_} = $db_def{$_}[2];
$db_lengths{$_} = $db_def{$_}[3];
$db_not_null{$_} = $db_def{$_}[4];
$db_defaults{$_} = $db_def{$_}[5];
$db_valid_types{$_} = $db_def{$_}[6];
($_ eq $db_key) and $db_key_pos = $db_def{$_}[0];
}
1;


Quote Reply
Re: HELP! No error description In reply to
BTW, I don't know much CGI, I know more HTML and ASP and all that, but

$db_file_name = $db_script_path . "/default.db";

Isn't that saying "http://www.teamfortresscentral.com/clans/db.cgi/default.db"?

I don't know just asking.

Quote Reply
Re: HELP! No error description In reply to
In Reply To:
Isn't that saying "http://www.teamfortresscentral.com/clans/db.cgi/default.db"?
Nope...if you set your $db_script_path correctly, then it should be referencing the PHYSICAL ABSOLUTE path where the db file is located.


Regards,

Eliot Lee
Quote Reply
Re: HELP! No error description In reply to
ok...so I want to set

# URL of the directory dbman resides in. No Trailing Slash Please.
$db_dir_url = "http://www.teamfortresscentral.com/clans";


to

"c:/www/teamfortresscentral.com/clans"?

Quote Reply
Re: HELP! No error description In reply to
I would highly suggest you visit the DBMan tutorial and learn how to setup your database and fields.

http://www.jpdeni.com/dbman/

You have many problems that I can spot quickly.
For instance you have maxlengths in the fields set to 0 which means that nothing can be entered.

You don't have a userid field and yet have that marked as field 9. And you have tracking setup for an alpha field.

The tutorial will help you understand how to set things up and there is a configurator which will greatly help in setting up your fields and setting correctly.

Also does your server allow you to run cgi scripts in the root directory rather than your cgi-bin directory? It would be more secure in a cgi-bin directory.

Hope this helps


Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/
Quote Reply
Re: HELP! No error description In reply to
What tutorial? All I saw was a readme.txt

And I saw zero's in the default.cfg before hand, so I thought that meant Unlimited length...so How do I do unlimited length?

And it is a NT server, I don't need a cgi-bin, I have newspro (newsposter) setup all over the site. That uses multiple cgi files and runs with no problem.

Can you tell me where I can find this tutorial. I'll change the 0's and the 9 but I have read the readme.txt throughly and nothing is mentioned on that.

Quote Reply
Re: HELP! No error description In reply to
Well here is the cfg file now..
I changed the length and the 9 is -1
I also connected the field names cause I saw that on a ealier thread.
-----------

#
# ----------------------
# DBMan
# ----------------------
# Database Administrator
#
# File: db.cfg
# Description: This is the setup file that contains the database definition,
# and most of the options required to set the program up.
# Author: Alex Krohn
# Web: http://www.gossamer-threads.com/
# Version: 2.05
# CVS Revision: $Id: default.cfg,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.
# =====================================================================

# File and URL's
# --------------------------------------------------------
# URL of the directory dbman resides in. No Trailing Slash Please.
$db_dir_url = "http://www.teamfortresscentral.com/clans";
# 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_url . "/default.db";
# Full path and file name of the counter file.
$db_id_file_name = $db_script_url . "/default.count";
# Full path and file name of the authorization directory.
$auth_dir = $db_script_url . "/auth";
# Full path and file name of the password file.
$auth_pw_file = $db_script_url . "/default.pass";
# Full path and file name of the log file.
$auth_log_file = $db_script_url . "/default.log";
# Full path and file name of the html routines.
require $db_script_url . "/html.pl";

# Database Definition
# --------------------------------------------------------
# Definition of your database. Format is
# field_name => ['position', 'field_type', 'form-length', 'maxlength', 'not_null', 'default', 'valid_expr']

%db_def = (
'Clan_Name' => [0, 'alpha', 40, 255, 1, '', ''],
'Description' => [1, 'alpha', '40x3', 500, 0, '', ''],
'Current_Leader' => [2, 'alpha', 40, 255, 1, '', ''],
'No_of_Members' => [3, 'alpha', 40, 3, 1, '', ''],
'Favorite_Maps' => [4, 'alpha', 40, 255, 0, '', ''],
'IRC_Channel' => [5, 'alpah', 40, 255, 0, '', ''],
'Webpage' => [6, 'alpha', 40, 255, 0, '', ''],
'Games_Play' => [7, 'alpha', 40, 255, 0, '', ''],
'Quote' => [8, 'alpha', 40, 255, 0, '', ''],
'Main_Country' => [9, 'alpha', 40, 255, 0, '', '']
);

# The column name for the database key. Can be any column, but it must be unique!
# You can't have two records with the same key value!
$db_key = 'Clan_Name';
# Track the key? Should DBMan keep a counter of the next key to use? This isn't
# neccessary if you can guarantee that your entry in the key field will be unique
# (i.e. a userid).
$db_key_track = 1;
# Database delimeter.
$db_delim = '|';
# Use file locking (1 = Yes, 0 = No). Should be used, but won't work on Win95.
$db_use_flock = 1;
# Auto generate the html forms (1 = Yes, 0 = No).
$db_auto_generate = 0;
# Display Benchmarking Information (1 = Yes, 0 = No).
$db_benchmark = 0;
# Display Debugging Information (1 = Yes, 0 = No).
$db_debug = 1;

# Select fields. Field name => 'comma seperated list of drop down options'.
%db_select_fields = (
Category => 'General,Configuration Management,Project Management,Process Improvement,Standards,Testing & Quality Assurance',
Type => 'Web,Newsgroup,Mailing List,FTP,Gopher'
);

# Radio fields. Field name => comma seperated list of radio buttons.
%db_radio_fields = ( Validated => 'Yes,No' );

# Checkbox fields. Field name => Checkbox value.
%db_checkbox_fields = ( Popular => 'Yes' );

# Default maximum number of hits returned in a search.
$db_max_hits = 20;
# Bold search results (1 = Yes, 0 = No).
$db_bold = 1;
# Regular and title fonts used in auto_generatrion and html.pl.
$font = 'font face="verdana,arial,helvetica" size="2"';
$font_title = 'font face="verdana,arial,helvetica" size="3"';

# Authorization Options
# --------------------------------------------------------
# No Authentication? (1 = "there is no authentication", 0 = "there is authentication")
# If you choose no authentication, then set the permissions of what
# people can do with: @auth_default_permissions below.
$auth_no_authentication = 0;

# The amount of time in seconds that user files are kept in the
# auth directory before the program removes them. 2-6 hours is
# probably a good value.
$auth_time = 21600; # 6 hours (in seconds)

# Enable (1) or disable (0) logging.
$auth_logging = 0;

# Allow a default user? This means you can specify a user via the URL
# and skip the logon process. Use this to allow people to search without
# logging on, but require log in if they want to add/modify/remove etc.
# (1 = "yes", 0 = "no")
$auth_allow_default = 1;

# Default permissions used if there is no authentication, or for a default
# user. (View, Add, Delete, Modify, Admin), 1 = enable, 0 = disable.
@auth_default_permissions = (1,0,0,0,0);

# Allow people to sign up for their own userid/passwords? They will
# recieve default permissions.
$auth_signup = 1;

# Permissions a new signup should get.
@auth_signup_permissions = (1,0,0,0,0);

# Registered users: can modify/delete _only_ own records. For this to make
# sense you should set default off or to 1,0,0,0.
$auth_modify_own = 1;

# Registered users: can view _only_ own records. For this to make sense
# you should turn off default permissions.
$auth_view_own = 0;

# Auth user field. This is the field position in the database used for storing
# the userid who owns the record. Set to -1 if not used.
$auth_user_field = -1;

# URL to send user if they chose log off. Leave blank and the script will return to
# the logon prompt (although this only makes sense if you are using authentication).
$auth_logoff = "http://www.teamfortresscentral.com/";

# ===========================================================================
# Build up some variables from your definitions. Internal use only.
foreach (sort { $db_def{$a}[0] <=> $db_def{$b}[0] } keys %db_def) {
push (@db_cols, $_);
$db_sort{$_} = $db_def{$_}[1];
$db_form_len{$_} = $db_def{$_}[2];
$db_lengths{$_} = $db_def{$_}[3];
$db_not_null{$_} = $db_def{$_}[4];
$db_defaults{$_} = $db_def{$_}[5];
$db_valid_types{$_} = $db_def{$_}[6];
($_ eq $db_key) and $db_key_pos = $db_def{$_}[0];
}
1;


Quote Reply
Re: HELP! No error description In reply to
In Reply To:
What tutorial? All I saw was a readme.txt
In Reply To:
I would highly suggest you visit the DBMan tutorial and learn how to setup your database and fields.

http://www.jpdeni.com/dbman/
That tutorial Wink

- Mark


Astro-Boy!!
http://www.zip.com.au/~astroboy/
Quote Reply
Re: HELP! No error description In reply to
It wasn't really the tutorial that helped, it was that configurator. I am surprised that isn't in the readme.txt file (to go to that configurator on that site) cause that makes it very easy. Got it working.

Got one more question, but I will post on a new thread. Thanks for your help....