Hi All,

I've recently moved a working DBman installation from one local machine to another and now I can't do anything when logged in as Admin without getting an 'internal server error message'. I've tried deleting the '.pass' file and replacing it with the default one from the downloaded Zip to no avail. I've also tried playing aorund with the different authenticaiton options as suggested in previous posts on a similar issue to no avail. Any help would be greatly appreciated.


++++++++++++++++++ default.cfg ++++++++++++++++++++++++++++

# ----------------------
# DBMan
# ----------------------
# Database Administrator
#
# File: default.cfg
# Description: This is the setup file that contains the database
definition,
# and most of the options required to set the program
up.
#
=====================================================================


# File and URL's
# --------------------------------------------------------
# URL of the directory dbman resides in. No Trailing Slash Please.
$db_dir_url = "http://localhost/cgi-bin/dbman/default";
# URL of dbman.
$db_script_url = $db_dir_url . "/db.pl";
# 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 = (
'ID' => [ 0, 'numer', 20, 255,
1, '', '\d{4}'],
'Surname' => [ 1, 'alpha', 20, 255,
1, '', ''],
'First name' => [ 2, 'alpha', 20, 255,
1, '', ''],
'County' => [ 3, 'alpha', 0, 10,
1, '', ''],
'Genre' => [ 4, 'alpha', 0, 78,
1, '', ''],
'Biography' => [ 5, 'alpha', '40x5', 1000,
0, '', ''],
'Age group' => [ 6, 'alpha', 0, 255,
0, '', ''],
'Session' => [ 7, 'alpha', 0, 73,
1, '', ''],
'Tel no' => [ 8, 'numer', 20, 255,
0, '', '\d{6}'],
'Fax no' => [ 9, 'numer', 20, 255,
0, '', '\d{6}'],
'E-mail' => [10, 'alpha', 20, 255,
0, '', '.+@.+..+'],
'Web' => [11, 'alpha', 20, 255,
0, '', '^http://'],
'Address' => [12, 'alpha', '40x5', 1000,
0, '', '']
);

# 'Address' => [12, 'alpha', 20, 255,
1, '', '']


# 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 = 'ID';
# 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 = 0;
# Auto generate the html forms (1 = Yes, 0 = No).
$db_auto_generate = 0;
# Display Benchmarking Information (1 = Yes, 0 = No).
# use Benchmark; # Uncomment this line if benchmarking is
used.
$db_benchmark = 0;
# Display Debugging Information (1 = Yes, 0 = No).
$db_debug = 0;

# Select fields. Field name => 'comma seperated list of drop down
options'.
%db_select_fields = (
'County'
=> 'Antrim,Armagh,Carlow,Cavan,Clare,Cork,Derry,Donegal,Down,Dublin,Fe
rmanagh,Galway,Kerry,Kildare,Kilkenny,Laois,Leitrim,Limerick,Longford,
Louth,Mayo,Meath,Monaghan,Offaly,Roscommon,Sligo,Tipperary,Tyrone,Wate
rford,Westmeath,Wexford,Wicklow'
);

# Radio fields. Field name => comma seperated list of radio buttons.
%db_radio_fields = (

);

# Checkbox fields. Field name => Checkbox value.
%db_checkbox_fields = (
'Genre' => 'poet,dramatist,\'fiction writer\',storyteller,\'childrens
writer\'',
'Age group' => '4 - 7,8 - 12,13 - 15,16+',
'Session' => 'workshop,curriculum,reading,storytelling,talk,\'discuss
with writer\''
);

# Default maximum number of hits returned in a search.
$db_max_hits = 10;
# Bold search results (1 = Yes, 0 = No).
$db_bold = 1;
# Regular and title fonts used in auto_generation and html.pl.
$font = 'font face="arial,helvetica,sans-serif" size="2"';
$font_title = 'font face="arial,helvetica,sans-serif" 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 = 1;

# 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 = 1;

# 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
# receive default permissions.
$auth_signup = 0;

# Permissions a new signup should get.
@auth_signup_permissions = (0,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 = 0;

# 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.poetryireland.ie/education/wis.htm";


#
======================================================================
=====
# 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;

Try this solution and see if it works:

Default passwords don't work

The problem is caused by your server encrypting the default passwords differently.

What you need to do is create new passwords. This can be done as follows:

1.Erase all entries in the password file.
2.Set $auth_allow_default = 1;
3.Set @auth_default_permissions = (1,1,1,1,1);
4.Go to db.cgi?uid=default
5.Go to admin and add your own users.

That should be it! Reset the authentication back to what you want when you are done.

Hope this helps

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

Hi LoisC,

I've tried this, and when I try to add a new user I get the 'internal server error' message again. Any ideas?

Thanks for your help.

Internal Server Error is a really generic error that doesn't tell you anything about what is causing the error. Take a look at your server's error_log and paste here what the error_log says. It could be permissions, or a syntax error in the script.

Was there a specific reason for bringing this topic back to the top after 2 months?

I'm not sure if the original poster would be looking for a further response at this point in time and may have already found the solution.

Unoffical DBMan FAQ

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

Yep, just trying to be helpful.