Gossamer Forum
Home : Products : DBMan : Installation :

Going Nuts!

Quote Reply
Going Nuts!
Guys, I've read through many, many of the forum problems, but none that touch on this possible one. I've loaded up the dbman demo, changed all the pemissions and tried to run. Nothing. Just got the Server misconfiguration panel over and over. I figured it was my path settings. Finally had someone who knew perl look at the DB.CGI file. They said the problem is that UNIX is picking up an end of line special character ^M throughout the file. They said clean it up with a different editor and I should be fine. Well I ftp'd the db.cgi right out of the zip and it has these characters imbedded as well. Any ideas on why this is happening and how I can clean these up?...Thanks
Quote Reply
Re: Going Nuts! In reply to
I would suggest extracting the files again from the original zip with a good file compression/decompression program, like WINZIP. Then upload the db.cgi file in ASCII Mode via FTP to your server. Make sure that you change the directory path in the db.cgi before uploading it to your server. Then change the file's permission to 755 (rwx-r-xr-x).

See if that works.

BTW: A good editor that cleans up files with problems you are experiencing is EditPlus, which is located at:

www.editplus.com

Hope this helps.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------


Quote Reply
Re: Going Nuts! In reply to
Thanks, got by the special character sitch. Now I have the similiar problem as Boris. I'm preety darn sure I the 2 paths setup correctly. Help...

default.cfg:
# URL of the directory dbman resides in. No Trailing Slash Please.
$db_dir_url = "http://www-got.sce.com/WWW/server_root/cgi-bin";

db.cgi:
$db_script_path = "/sceprd/WWW/server_root/cgi-bin";


CGI ERROR
==========================================
Error Message : unable to open directory in auth_cleanup: /sceprd/WWW/server_root/cgi-bin/auth. Reason: A file or directory in the path name does not exist.
Script Location : /sceprd/WWW/server_root/cgi-bin/db.cgi
Perl Version : 5.00404
Setup File : default.cfg

Form Variables
-------------------------------------------

Environment Variables
-------------------------------------------
APPS : /apps
DB2COMM : TCPIP
DB2DBDFT : SAMPLE
DB2INSTANCE : httpd
GATEWAY_INTERFACE : CGI/1.1
GS_LIB : /usr/lib/ghostscript
HTTPS : OFF
HTTP_ACCEPT : image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, image/png, */*
HTTP_ACCEPT_CHARSET : iso-8859-1,*,utf-8
HTTP_ACCEPT_ENCODING: gzip
HTTP_ACCEPT_LANGUAGE: en
HTTP_CONNECTION : Keep-Alive
HTTP_COOKIE : edna_loc=Rosemead; edna_cc=SCE%20Employee%20Directory#/edn/dir/empdir.shtml!SCE%20BU%20Directory#/edn/dir/budira.shtml; edna_attache=Edison%20News#/cpi/ednews/current_issue!Bloomberg#http%3A//www.bloomberg.com/!Facility%20Maps#/map/index.shtml!CNN#http%3A//www .cnn.com/!LA%20Times#http%3A//www.latimes.com/!Mapquest#http%3A//www.mapquest.com/!Business%20Resources#/ebr/!Employee%20Activity%20Center#h ttp%3A//www.recreationconnection.com/!Employee%20Benefits#/hrz/hr_service_center/benefits.htm!HR%20Interactive#/hrz/hr_interactive.htm!IT%20 Service%20Center#/it2/!Edison%20University#/edn/academy/index.shtml!The%20Internet%20Place#/tip/index.shtml!Hotel%20Office%20Reservations#/r ph/!Metrolink%20Train%20Schedules#http%3A//www.metrolinktrains.com/!JOIS%20Applications#/hrm/jois_app.html!Traffic%20Reports#http%3A//traffi c.maxwell.com/la/!Weather%20Reports#http%3A//www.intellicast.com/LocalWeather/World/UnitedStates/Southwest/California/LosAngeles/Forecast/; edna_hq=SCE%20Information#/edn/coinfo/sceinfo.shtml!EIX%20Information#/edn/coinfo/eixinfo.shtml!Stock%20Quotes#/html/stocks/index.shtml!Job% 20Opportunities%20%28JOIS%29#/hrm!Org.%20Charts#/edn/coinfo/; edna_name=Brian; edna_org=IT
HTTP_HOST : www-got.sce.com
HTTP_USER_AGENT : Mozilla/4.5 [en]C-CCK-MCD SCE_CDE-2 (Win95; U)
LANG : en_US
OCLIENT : /apps/oclient
ODMDIR : /etc/objrepos
PATH : /apps/oracle/bin:/usr/local/bin::/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/home/httpd/sqllib/bin:/home/httpd/sqllib/adm:/home/htt pd/sqllib/misc:/usr/lpp/ssp/bin:/usr/lpp/ssp/kerberos/bin:/var/ifor:/usr/opt/ifor/ls/conf
REMOTE_ADDR : 155.13.206.118
REMOTE_HOST : 155.13.206.118
REQUEST_METHOD : GET
SCRIPT_NAME : /cgi-bin/db.cgi
SERVER_NAME : www-got.sce.com
SERVER_PORT : 80
SERVER_PROTOCOL : HTTP/1.0
SERVER_SOFTWARE : Netscape-Enterprise/3.5.1E
SERVER_URL : http://www-got.sce.com
SHELL : /bin/ksh
SYBASE : /apps/oclient
TZ : PST8PDT
WAISCOMMONSOURCEDIR : INFO
Quote Reply
Re: Going Nuts! In reply to
You should set your $db_script_path (in db.cgi) to either the following.. (if your information is correct)

$db_script_path = ".";

or

$db_script_path = "http://www-got.sce.com/WWW/server_root/cgi-bin";

The first is the default.. and you really shouldn't have to change this at all.. however if you do run into problems.. then use the second one.

The second one is assuming that your script is in cgi-bin.

------------------
-----------
millsie Smile

A smile a day...
keeps the viri' away.


[This message has been edited by millsie (edited November 01, 1999).]
Quote Reply
Re: Going Nuts! In reply to
millsie,

WRONG! Nice try...Some servers are configured to only execute files with FULL directory paths to files. But, nice try. Telling people to only use "." is absolutely poor advice. Wink It really depends on the server and how it is configured.

The ACTUAL problem, B Sparks, is the permissions of your /auth/ is not correct. You need to change its permission to 777 (drwxrwxrwx).

See the error message:

Quote:
Error Message : unable to open directory in auth_cleanup:...

That means that the permissions of this directory are only set to 644 meaning that there is not the appropriate write access associated with the directory.

Hope this helps.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------


Quote Reply
Re: Going Nuts! In reply to
Well, getting there slowing but surely. I changed the $db_script_path = "."; and updated the permission of the /auth/ directory to 777. I now can get the login screen but can't login using either admin, author or guest. I just get the following:

The requested object does not exist on this server. The link you followed is either outdated, inaccurate, or the server has
been instructed not to let you have it. Please inform the site administrator.

Help...

thx
Quote Reply
Re: Going Nuts! In reply to
Are you sure that you have a directory auth in your cgi-bin directory and that that directory's permissions are set to 777
(drwxrwxrwx) as Eliot said?


------------------
JGU



[This message has been edited by jury (edited November 01, 1999).]
Quote Reply
Re: Going Nuts! In reply to
At the risk of looking stupid in Eliots eyes..

I had this error when I first started.. finally realized that I had uploaded the password file in binary instead of ASCII.

A simple check of the following may help..

Are you sure you have uploaded the password file to the correct directory.. and chmod' it correctly?

If so.. how about the path to the password file in your config? Is this set correctly?

Otherwise.. I'm sure Eliot will set us all straight Smile



------------------
-----------
millsie :)

A smile a day...
keeps the viri' away.
Quote Reply
Re: Going Nuts! In reply to
Got things working. Jazzed! New problem is that when I'm trying to add new records to the database the ID counter that is visible seems to disappear when I click add, thus getting a 'Can't be blank error' Also, I've coded the following timestamp field, but am getting an error 'Invalid Date format'.

TimeStamp => [13,'date', -1, 15, 0, &get_date, '']

thanks...
Quote Reply
Re: Going Nuts! In reply to
Hmm...That is weird....

Please save your updated files as text files and upload them to a publicly accessible directory (outside of your cgi-bin directory). Then post the URL where we can view the files.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------


Quote Reply
Re: Going Nuts! In reply to
Well...that sucks.

Wink

I don't really have time to look at your files right now. And I have taken my email address off my signature file and also my profile configurations due to the overwhelming amount of email I was receiving from people who wanted me to help them on an individual basis, which I do have the time nor patience for.

When I have time, I will email you and you can send me files to the email address I use to contact you.

Smile

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------




[This message has been edited by Eliot (edited November 04, 1999).]
Quote Reply
Re: Going Nuts! In reply to
Eliot, if you can believe it, I'm working within the contraints of an intranet and have no access to public space. Can I send my files to you as attachments at your E-Mail address? Please provide if ok...thanks a bunch
Quote Reply
Re: Going Nuts! In reply to
I understand. While awaiting your reply, I'll try to find some free space out there somewhere, where I can put these for you to look at...thanks