I'm having trouble getting the default db to run.

I've edited db.cgi and set the path to perl appropriately.

I've changed the file-types from dos to unix on all of the files in the distribution.

I've checked more times than I can think of the perms:
drwxr-xr-x 3 cajun cajun 4096 Sep 23 11:19 .
drwxr-xr-x 5 root root 4096 Sep 23 11:14 ..
-rw-r--r-- 1 root root 19822 Sep 23 11:15 README.txt
drwxrwxrwx 2 root root 4096 Jul 8 11:14 auth
-rw-r--r-- 1 root root 6632 Sep 23 11:15 auth.pl
-rwxr-xr-x 1 root root 46647 Sep 23 11:16 db.cgi
-rw-r--r-- 1 root root 7545 Sep 23 11:15 default.cfg
-rw-rw-rw- 1 root root 2 Sep 23 11:15 default.count
-rw-rw-rw- 1 root root 6693 Sep 23 11:15 default.db
-rw-rw-rw- 1 root root 654 Sep 23 11:15 default.log
-rw-rw-rw- 1 root root 143 Sep 23 11:15 default.pass
-rw-r--r-- 1 root root 43169 Sep 23 11:15 html.pl
-rw-r--r-- 1 root root 33440 Sep 23 11:15 httpd.conf
-rwxr--r-- 1 root root 143 Sep 23 11:19 setperms


I've edited default.cfg for the correct path to $db_dir_url:

# URL of the directory dbman resides in. No Trailing Slash Please.
$db_dir_url = "http://rattler/cgi-bin/dbman";

I've read numerous posts on this list about install problems, but haven't found the problem as of yet. Is there a method to get a more descriptive error listing than the "DBMan encountered an internal error. Please enable debugging to view." ?

I've added the following near the top of both the db.cgi and html.pl scripts with no success (it creates a 0 byte file)

BEGIN {
open (STDERR, ">/home/httpd/cgi-bin/dbman/error.txt");
}

I would appreciate any suggestions as to what the problem might be or pointers to the correct post(s) in the forum.

Thanks,
Mike

Hi Mike, is this the actual entry you have in the db.cfg file, or has it been modified for displaying in the forum?
$db_dir_url = "http://rattler/cgi-bin/dbman";

If this is the actual entry, it is inaccurate because it has an incomplete domain name. The extension is missing as in this example:
$db_dir_url = "http://rattler.com/cgi-bin/dbman";

Thanks Karen. Yes, that is the actual entry

"$db_dir_url = "http://rattler/cgi-bin/dbman";

It's running on internal dns. If I type 'rattler' in my browser, it brings up the web site. To get to dbman I type 'rattler/cgi-bin/dbman/db.cgi'.

I get the same error at the server by running './db.cgi' from the command line.

Mike

Hi Mike, I maybe in over my head here <grin> going to throw out a question anyway. Are you running the scripts on your local machine only then? Not being access via the web?

If so, this would be the path for web access, wouldn't it (with the http:// in there)?
$db_dir_url = "http://rattler/cgi-bin/dbman";

Karen, I may have just resolved the problem. Reading db.cgi it says that it must be called from a GET or POST method from the web. From this, I gather it cannot be called by './db.cgi'.

After trying the browser method for so many times and failing, I went to using the './db.cgi' method. Part of the method to my madness was to eliminate any cache problems that might be cropping up because of the browser.

In short, the default setup is working now from the browser (still not working from './db.cgi').

Now to see if I can get the database mods in that I want.

Thanks !
Mike

Yes, and no Karen. I can access it via './db.cgi' (not working, from the local server (the machine running the httpd. From any machine on the internal network, I can access it by putting in any of the following:

http://rattler/cgi-bin/dbman/db.cgi

rattler/cgi-bin/dbman/db.cgi

http://rattler/cgi-bin/dbman/db.cgi

http://192.168.1.1/cgi-bin/dbman/db.cgi

Hopefully that answers your question ?

Now I have a new problem (same error message as before 'internal error'). I've put in my customized default.cfg and html.pl from the generated scripts found on JPDeni's www page. Now I'm getting the internal error again. Grrr.....

Thanks,
Mike

Sorry it went sour again Mike - I have seen some posts on the forums about a known problem with the configurator - I am not familiar with the actual problem or fix though :-(

You can try searching (link at top of page) in each of the dbman forums for threads which discuss the configurator. (Use that as a search term) or you can visit LoisC's "Unofficial DBMan FAQ's" site (linked from Resource area) and see if there are any tips/suggestions there on correcting the problem.

Sorry I can't be of more help on this :-(

Ok, thanks much for the assistance Karen.

I've posted my customized (from the configurator) default.cfg and html.pl at the following URL's (not where dbman is being run from):

http://www.cajuninc.com/default.cfg
http://www.cajuninc.com/html.pl

Thanks
Mike

From what I could see looking at your .cfg file:

Your not allowing a default user

$auth_allow_default = 0;
@auth_default_permissions = (0,0,0,0,0);

And you are also not allowing anyone to signup for an account.

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

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

I don't see how the script would be able to run if nobody has permission to view it?

Also in your first post you give the permission settting as being in the root directory and yet you are calling the files from your: cgi-bin/dbman/ directory.

When you posted your html.pl file you only posted what was provided by the configurator. Are you aware you need to paste those portions in the full html.pl file? If so, that is what you should post when you post your files.

When I tried running the script I received a CGIWrap Error. You may want to search the forum to see why this error occurs and a possible solution.

The first thing you should do is to allow viewing by either the default user or those with sign-up permissions!

Hope this helps

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

Default user / allowing signup = This is going to be a Return Authorization database. There will only be a handfull of authorized users. The remainder of the folks that will even have access rights to the db will login as guest/guest with no privledges other than view.

I don't understand what you mean about the permission setting being in the root directory.

html.pl = Duhhhh..... I'm just learning to read.... This was the problem. I found it moments ago and have the db working now. I took for granted, rather than reading the first two lines that the file was a 'replacement' for html.pl, not a cut / paste sort of thing. Sheeeesh....

CGIWrap error ? Where did you see this ? In the browser ?

Yes, it helps. Thank you very much Lois. I wish I had seen your post several hours earlier :-(

Thanks Again !

Mike

Yes the cgiwrap error appeared in the browser when trying to view your script.

Perhaps using the complete html.pl file corrected this error also.

Glad you got it working

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