Gossamer Forum
Home : Products : DBMan : Customization :

Relational Mod - JPD

Quote Reply
Relational Mod - JPD
All this recent talk about the Relational Mod encouraged me to load up the demo. I have been struggling to get it to run, but keep getting the error message:
CGI ERROR
==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: Can't locate auth.pl in @INC (@INC contains
.......... at /usr/local/etc/httpd/cgi-bin/relation/db.cgi line 54.

This relates to auth.pl

Interestingly, when trying the demo at JPDeni's site, on clicking Log Off, I receive the same message from her server - except that it refers to line 51
Any ideas what the problem is? I cannot see any obvious problems with my scripts or permissions etc.

David Olley
Anglo & Foreign International Limited,
http://www.afil.co.uk
Quote Reply
Re: Relational Mod - JPD In reply to
I loaded the files as well. I had the exact same error, however my error does say line 51.
------------------------------------------------------------
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: . /usr/lib/perl5/5.005/i386-linux /usr/lib/perl5/5.005 /usr/local/lib/site_perl/i386-linux /usr/local/lib/site_perl /usr/lib/perl5 .) at db.cgi line 51.

Script Location : db.cgi
Perl Version : 5.00503
Setup File : default.cfg
-----------------------------------------------------------

It seems to be looking for the default.cfg, but there is no default.cfg. In her files she has the 2 relational ones, user.cfg & item.cfg.

For the heck of it (and i mean that sincerely, as I am still learning a lot here and have no clue if this is the right thing to do), I went to the top and changed the word "default" to "user".
-------------------------------------------------------
# Load the form information and set the config file and userid.
local(%in) = &parse_form;
$in{'db'} ? ($db_setup = $in{'db'}) : ($db_setup = 'user');
$in{'uid'} ? ($db_uid = $in{'uid'}): ($db_uid = '');
----------------------------------------------------------
That actually got the log in screen and it let me add myself, but that is far as it went. After I added myself and then tried to log in, I got another error:
-----------------------------------------------------------
CGI ERROR
==========================================
Error Message : error in get_records. unable to open db file: ./user.db.
Reason: No such file or directory
Script Location : db.cgi
Perl Version : 5.00503
Setup File : user.cfg
User ID : dianarae
Session ID : dianarae.99003627786022
----------------------------------------------------
Anyone that may have loaded this test mod have any clues?

Thanks! Smile

Diana Rae

The Newbie...
Quote Reply
Re: Relational Mod - JPD In reply to
still trying! still doesnt work.

The Newbie
Quote Reply
Re: Relational Mod - JPD In reply to
I had the same problem when I setup the relational mod. See this thread http://www.gossamer-threads.com/...ew=&sb=&vc=1

Quote Reply
Duh In reply to
David,

I got it to work. Smile

Well, I shouldn't say *I* did, actually Philip_Clark was so kind to take the time to look at my problem and figured it out. Of course, I feel very silly now. Smile

What I did above IS correct! Change the word default at the top to user.

Make sure all off of your permissions are correct (use JPDeni's chart). and it should work. Smile

Why didn't for me at first, you ask?....Well...I forgot to upload the user.db...small problem! Duh! Tongue

Thanks again SO MUCH, Philip! Laugh

The Newbie
Quote Reply
Re: Duh In reply to
Actually I made all those changes before uploading the scripts. I carefully checked the presence of all files, and their permissions.
What I just discovered, however, is that I somehow lost the auth.pl file from the directory. It was there when I started ... I swear.
The demo works fine now, of course.
Something about wood and trees..

David Olley
Anglo & Foreign International Limited,
http://www.afil.co.uk