Hi all,
Im very new in this cgi work and encountered this problem about my default.cfg
I searched the previous discussions but none of them showed similarity with my case.
I guess default.cfg couldnot be located and this is the problem. I am using cuteftp and saw that some problems happened when using it.I changed db.cgi but it didnt mean much. Im stuck here, please help me. This is the message I receive when I try to run the cgi


CGI RROR==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: Can't locate default.cfg in @INC (@INC contains: . C:/Perl/lib C:/Perl/site/lib .) at D:\home\ntr5f89\cgi-bin\db.cgi line 51.
Script Location : D:\home\ntr5f89\cgi-bin\db.cgi
Perl Version : 5.00503Setup File : default.cfgForm Variables
-------------------------------------------Environment Variables
-------------------------------------------COMPUTERNAME : NTR5
COMSPEC : C:\WINNT\system32\cmd.exeCONTENT_LENGTH : 0
GATEWAY_INTERFACE : CGI/1.1HTTPS : offHTTP_ACCEPT : */*
HTTP_ACCEPT_ENCODING: gzip, deflateHTTP_ACCEPT_LANGUAGE: en-us
HTTP_CONNECTION : Keep-AliveHTTP_HOST : www.burcin.org
HTTP_USER_AGENT : Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)
INCLUDE : C:\Program Files\Mts\IncludeINSTANCE_ID : 89
LIB : C:\Program Files\Mts\Lib
LOCAL_ADDR : 216.149.52.89NTRESKIT : C:\NTRESKIT
NUMBER_OF_PROCESSORS: 1OS : Windows_NT
OS2LIBPATH : C:\WINNT\system32\os2\dll;
PATH : C:\Perl\bin;C:\WINNT\system32;C:\WINNT;C:\NTRESKIT;C:\NTRESKIT\Perl;C:\Program Files\Mts;C:\Program Files\Symantec\pcAnywhere
PATHEXT : .COM;.EXE;.BAT;.CMD;.VBS;.JS
PATH_INFO : /cgi-bin/db.cgi
PATH_TRANSLATED : D:\home\ntr5f89\cgi-bin\db.cgiPROCESSOR_ARCHITECTURE: x86
PROCESSOR_IDENTIFIER: x86 Family 6 Model 5 Stepping 2, GenuineIntel
PROCESSOR_LEVEL : 6PROCESSOR_REVISION : 0502
REMOTE_ADDR : 138.202.122.61REMOTE_HOST : 138.202.122.61
REQUEST_METHOD : GETSCRIPT_NAME : /cgi-bin/db.cgi
SERVER_NAME : www.burcin.orgSERVER_PORT : 80
SERVER_PORT_SECURE : 0SERVER_PROTOCOL : HTTP/1.1
SERVER_SOFTWARE : Microsoft-IIS/4.0SYSTEMDRIVE : C:
SYSTEMROOT : C:\WINNT
USERPROFILE : C:\WINNT\Profiles\Default User
WINDIR : C:\WINNT

Since you seem to be on a Windows (or possibly NT) system, you don't need to change db.cgi at all. Or at least you shouldn't need to.

Take out any changes you made to db.cgi and upload the file again.

If you still have problems, set

$db_script_path = 'D:\home\ntr5f89\cgi-bin';

in the db.cgi file. Then give it a try.

If that doesn't work, try

$db_script_path = 'D:/home/ntr5f89/cgi-bin';

------------------
JPD


[This message has been edited by JPDeni (edited April 07, 2000).]

Thank you very much, second one worked. At least I received the logon screen. When I try to login as guest I encounter this problem this time.

CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:

Can't open perl script "D:\home\ntr5f89\cgi-bin\dbman\db.cgi": No such file or directory

Actually there is no dbman directory in the server. I dont know why the script is trying to find cgi under that directory

Thanks

I think I need to take a look at your .cfg file. Please copy it to a web-accessible directory (one where you would put .html files) and rename it to default_cfg.txt. Then come back and tell me where I can find it. I'll take a look and see what I can figure out.


------------------
JPD

I put the file in www.burcin.org/default_cfg.txt
I couldnt understand the problem, there is no such an entry in the file.

Thanks again

This is a new problem that I haven't come up with before. I don't know where the "dbman" directory could be coming from.

Is there any chance your sysadmin could help you?


------------------
JPD

 
I did it. I unzipped the file again and it is working although I dont know why.
Now I have a new problem of course.
What I want to have is a database management system with a single admin without any logging. So people will be able to add & search records without any authentication process. I tried several times with authentication variable values but I couldnt come up with a condition which does not require login process but also allows the admin to delete and modify records. I know it
is a bit weird to have a system with no login but an admin authority but I would like to know if there was such a way.

Thanks for your great help, I really appreciate what you are doing here...

I still think there are gremlins on the 'net, especially recently. There have been several folks who have experienced strange things and when they uploaded a new file, everything was okay.

Now for your permissions.

You (as admin) will need to log in. Default users will not have to log in.

In your .cfg file, set

$auth_no_authentication = 0;
$auth_allow_default = 1;
@auth_default_permissions = (1,1,0,0,0);
$auth_signup = 0;
$auth_user_field = -1;

In your link for users to enter the database, use the following format:

http://www.server.com/cgi-bin/db.cgi?db=default&uid=default

When you, as admin, want to do something, use

http://www.server.com/cgi-bin/db.cgi

You'll probably want to save the link as a bookmark in your browser so you don't have to type it in.


------------------
JPD

Great, it is really working.
I wanted to change the fields of the database and now I get this error message
CGI ERROR
==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: syntax error at D:/home/ntr5f89/cgi-bin/default.cfg line 65, near "Graduation Year"

%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
Name => [1, 'alpha', 20, 255, 1, '', ''],
Surname => [2, 'alpha', 20, 255, 1, '', ''],
email => [3, 'alpha', 30, 255, 1, '', ''],
Homepage => [4, 'alpha', 40, 255, 0, 'http://', '^http://'],
Department => [5, 'alpha', 20, 60, 1, '', ''],
Graduation Year => [6, 'numer', 4, 4, 1, '', ''],
Present Company/Institution => [7, 'alpha', 40, 255, 1, '', ''],
Degree/Title => [8, 'alpha', 40, 255, 1, '', 'Yes|No'],
Address => [9, 'alpha', 3*40, 255, 0, '', ''],
City => [10, 'alpha', 25, 255, 0, '', ''],
State => [11, 'alpha', 25, 255, 0, '', ''],
Zip => [12, 'alpha', 25, 255, 0, '', ''],
Coutry => [13, 'alpha', 30, 255, 0, '', ''],
Optional (ICQ, Phone etc.) => [14, 'alpha', 3*40, 255, 0, '', ''],
Clubs in Bogazici => [16, 'alpha', 50, 255, 0, '', ''],
Userid => [17, 'alpha', -2, 15, 0, '', '']
);

this is my database declaration I couldnt find what is wrong with it?

Thanks again for all

If you have spaces in your fieldnames, you need to enclose the fieldnames in single quotes:


'Graduation Year' => [6, 'numer', 4, 4, 1, '', ''],
'Present Company/Institution' => [7, 'alpha', 40, 255, 1, '', ''],

'Optional (ICQ, Phone etc.)' => [14, 'alpha', 3*40, 255, 0, '', ''],
'Clubs in Bogazici' => [16, 'alpha', 50, 255, 0, '', ''],


You may also need to put quotes around

'Degree/Title' => [8, 'alpha', 40, 255, 1, '', 'Yes|No'],

but I'm not sure about that one. If you get an error, put in the quotes.

(BTW, if you just copied and pasted from your file, you may want to fix the typo in Coutry.)



------------------
JPD

 
Hi again,
I configured my fields and variables with the help of configuration wizard from your site.
When I want to replace the sub_html_record_form and sub_html_form I encountered the error message. I tried only replacing the sub_html_record_form and it worked perfect but as soon as I replaced sub_html_form it keeps giving this error message. can there be a missing bracket in the output the program produced?

Thanks for all again and again...

Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: Missing right bracket at D:/home/ntr5f89/cgi-bin/html.pl line 1363, at end of line
syntax error at D:/home/ntr5f89/cgi-bin/html.pl line 1363, at EOF

It appears there is a bug somewhere in the Configurator. It has to do with the setting "skip blank lines," I think, especially when coupled with "admin only" fields. That's my guess anyway.

You would do me a great kindness if you would let me see your file so I can see exactly where the problem is. (I can also tell you how to fix it. )

Please copy your html.pl file to a web-accessible directory (one where you would place .html files) and rename it to html_pl.txt. Then come back and let me know the URL where I can view it. You will be doing a great service to all users of the Configurator.


------------------
JPD

 
I put the file to http://www.burcin.org/html_pl.txt

It would be great if you could fix it.
That code generator is great.

The problem is where I thought it would be. I'm not sure how I'm going to fix the problem in the Configurator, but here's how to fix the problem in your script.

In sub html_record, replace:


with


That will fix your bracket problem.

Thanks for the compliments on the Configurator. Even with this bug, it has saved me from having to get a lot of people out of problems.


------------------
JPD