I'm getting a 500 Server Error with my installation...

www.psoriasis-netz.de/cgi-bin/dbman/db.cgi

and specialy www.psoriasis-netz.de/cgi-bin/dbman/db.cgi?db=medikamente

The errormessage is:
"DBMan encountered an internal error. Please enable debugging to view."

But: Debuggig *is* enabled. Perl-Version is >5.0. Permissions are set like in your readme. The files are submit in the text-modus, not binary.

Greetings from Berlin (Germany)

Claudia

Sorry to ask but are you positive that you uploaded the files in ASCII mode using FTP.

Are you certain your host provider allows you to create sub directories within your cgi-bin.

There may be an error in your .cfg file. Could you make a text copy and post the url to where it can be viewed.

Unoffical DBMan FAQ

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

Hi,

for the .cfg-file look at

http://www.psoriasis-netz.de/cfg.txt

>>> are you positive that you uploaded the files in ASCII mode using FTP.
Yes. First I've uploaded the files in "automatic" modus, than in this forum I've seen, that the ascii-modus must be and I've uploaded the files than in ascii-modus.

>>> Are you certain your host provider allows you to create sub directories within your cgi-bin.
Yes, I'am. There are also other cgi's in many others sub directories.

Many thanks for your help!

Greetings

Claudia

Do you have telnet/ssh access?

If so do:

perl -c db.cgi

One thing to check... you are not requiring authentication (loggin in), but you are not allowing default users. Could this be causing a conflict?

Also check the name of this file...

medikamentehtml.pl

or is it

medikamente.pl ?

See what you have labeled in your cfg file and then see what the actual name of the file is.

I don't see anything in the path setting that could be causing problems.

I did notice that you have it set so that people have to signup to view the database. If that is the case define:

$auth_user_field = -1;

as:

$auth_user_field = 9;

which is your Userid field.

You did create the auth directory and chmod it to 777 correct?

Are you working with your files in a text editor or did you use a word processing program? The later will add extra character returns and such which could cause problems.

Unoffical DBMan FAQ

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

Hi LoisC,

>>>I did notice that you have it set so that people have to signup to view the database.
Hmmmh. Users should view the database, but add etc. is only for me.

>>>You did create the auth directory and chmod it to 777 correct?
Yes.

>>>Are you working with your files in a text editor or did you use a word processing program?
Sure. I'm working with a Apple and I'm using BBEdit, a text-only editor.

Greetings

Claudia

Hi LoisC,

is it possible, that

$auth_allow_default = 0

must be set to 1?

Or is it possible, that

$auth_signup = 1

must be set fo 0?

I'm helpless.

Greetings

Claudia

This is a long shot but...

I see you have renamed most of the files. If you have renamed default.cfg to medikamente.cfg you will need to change the following line near the top of db.cgi:

$in{'db'} ? ($db_setup = $in{'db'}) : ($db_setup = 'default');

to:

$in{'db'} ? ($db_setup = $in{'db'}) : ($db_setup = 'medikamente');
_______________________________________________________
Lem Motlow, Proprietor Lynchburg (pop 361), Tenn.

I have never had to change that line in the db.cgi file.

Doing so would prevent your being able to use the same .cgi file for more than one database.

Unoffical DBMan FAQ

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

That is true, no argument there, but I noticed that all the file names were changed and if she did change the cfg file to the same sort of name, she would have to change that line in db.cgi to make it work.

Please correct me if I'm wrong.
_______________________________________________________
Lem Motlow, Proprietor Lynchburg (pop 361), Tenn.

Hi,

no, after the change in db_setup... variable to "medikamente" it's no better - error 500. With "default" in this variable there was a errorcode "DBMan encountered an internal error. Please enable debugging to view." (and it's enabled!) But it's also not a help

Greetings

Claudia

Hello Claudia, you should not need to make changes in the db.cgi file to point to the database cfg file however you would need to specify the database name in the url.

You've changed this field name in the config file:
Produkt

Did you also make that change in your html.pl file (renamed medikamentehtml.pl)? Double check that you have an INPUT field for each of your database fields in sub html_record_form - you must have a field even if you are using info generated by the script/system. "Date" for example is using info generated by the system but there must be a field (can be hidden) for that data.