Gossamer Forum
(Advanced Search)
for
Home : Products : Links 2.0 : Installation -- Unix :

error: validate.db

Apr 3, 1999, 10:40 AM
Matt_A
Deleted
Apr 3, 1999, 10:40 AM
Post #1 of 18
Views: 5250
Shortcut
Quote Reply
error: validate.db
While clicking on VALIDATE in the admin area, I get the error:

No such file or directory, unable to open validation file: /custs/home/m/mil21156/public_html/links/admin/data/validate.db. Reason: No such file or directory.

As far as I can tell, the path is correct, validate.db exists in the Data directory, and is chmod-ed correctly.

The links.cfg file can be viewed at:
http://www.millennium-compendium.com/links/admin/links.cfg.txt

The rest of the links and admin program worked perfectly. Please respond if you have any advice.

--
Matt_A
Apr 3, 1999, 2:17 PM
Bobsie
Veteran (3111 posts)
Bobsie's avatar
Apr 3, 1999, 2:17 PM
Post #2 of 18
Views: 5212
Shortcut
Quote Reply
Re: error: validate.db In reply to
 
Quote:
As far as I can tell, the path is correct, validate.db exists in the Data directory, and is chmod-ed correctly.

As far as I can see, looking at your links.cfg file, your path is correct as you said so the problem must be elsewhere, especially if the rest of your site works normally.

In your quoted text above, you said "Data" directory. By chance, do you have the name of the data directory capitalized? It should not be, if so. If that is not the problem, then please post the entire error message so we can see what else it says. You might want to uncomment the last line in admin.cgi so it will provide more information.
Apr 3, 1999, 2:41 PM
Matt_A
Deleted
Apr 3, 1999, 2:41 PM
Post #3 of 18
Views: 5187
Shortcut
Quote Reply
Re: error: validate.db In reply to
No, the data directory is not capitalized.

I removed the comment in the admin.cgi file like you suggested but I didn't notice in a change in the amount of information the error provided. Here it is in full:

CGI Error: No such file or directory Message: unable to open validation file: /custs/home/m/mil21156/public_html/links/admin/data/validate.db. Reason: No such file or directory

_________Form Variables __________
validate_form: 1

_________Environment Variables__________
AUTH_TYPE: Basic
CONTENT_LENGTH: 0
DOCUMENT_ROOT: /usr/local/zeus/web_roots/main/www.millennium-compendium.com
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, image/png, */*
HTTP_ACCEPT_CHARSET: iso-8859-1,*,utf-8
HTTP_ACCEPT_LANGUAGE: en
HTTP_CONNECTION: Keep-Alive
HTTP_HOST: www.millennium-compendium.com
HTTP_REFERER: http://www.millennium-compendium.com/links/admin/nav.htm
HTTP_USER_AGENT: Mozilla/4.04 [en] (Win95; I)
PATH: /usr/bin:/usr/ucb/bin:/usr/local/bin
QUERY_STRING: validate_form=1
REMOTE_ADDR: 206.217.110.139
REMOTE_HOST: 206.217.110.139
REMOTE_USER:
REQUEST_METHOD: GET
REQUEST_URI: /links/admin/admin.cgi?validate_form=1
SCRIPT_FILENAME: /usr/local/zeus/web_roots/main/www.millennium-compendium.com/links/admin/admin.cgi
SCRIPT_NAME: /links/admin/admin.cgi
SERVER_ADMIN: webmaster@myhost
SERVER_NAME: www.millennium-compendium.com
SERVER_PORT: 80
SERVER_PROTOCOL: HTTP/1.1
SERVER_SOFTWARE: Zeus/3.1
TZ: US/Eastern
VSERVER_NAME: main
Apr 3, 1999, 2:49 PM
Bobsie
Veteran (3111 posts)
Bobsie's avatar
Apr 3, 1999, 2:49 PM
Post #4 of 18
Views: 5186
Shortcut
Quote Reply
Re: error: validate.db In reply to
Hmmm....

Quote:
CGI Error: No such file or directory Message: unable to open validation file:
/custs/home/m/mil21156/public_html/links/admin/data/validate.db. Reason: No such file or directory

but it says:

Quote:
SCRIPT_FILENAME:
/usr/local/zeus/web_roots/main/www.millennium-compendium.com/links/admin/admin.cgi

Those paths sure don't look the same. Could this be the problem?
Apr 9, 1999, 1:47 PM
Matt_A
Deleted
Apr 9, 1999, 1:47 PM
Post #5 of 18
Views: 5203
Shortcut
Quote Reply
Re: error: validate.db In reply to
The paths don't look identical, but how can I fix this? Would the rest of the program be working correctly if my links.cfg file was set incorrectly?
Apr 9, 1999, 4:55 PM
Bobsie
Veteran (3111 posts)
Bobsie's avatar
Apr 9, 1999, 4:55 PM
Post #6 of 18
Views: 5189
Shortcut
Quote Reply
Re: error: validate.db In reply to
Is /custs/home/m/mil21156/public_html/ the path to your web directory and /usr/local/zeus/web_roots/main/www.millennium-compendium.com/ the path to your cgi scripts directory?

Can you post what you have in links.cfg for the following variables:

$db_script_path
$db_dir_url
$db_cgi_url
$build_root_path
$build_root_url

That way, we can get a better idea of what is what with the paths.

Thanks.
Apr 10, 1999, 8:38 AM
Matt_A
Deleted
Apr 10, 1999, 8:38 AM
Post #7 of 18
Views: 5168
Shortcut
Quote Reply
Re: error: validate.db In reply to
$db_script_path = "/custs/home/m/mil21156/public_html/links/admin";
$db_dir_url = "http://www.serve.com/Catacombs/links/admin";
$build_root_path = "/custs/home/m/mil21156/public_html/links";
$build_root_url = "http://www.millennium-compendium.com/links";

I can't find $db_cgi_url in my links.cfg.txt (viewable at http://www.millennium-compendium.com/links/admin/links.cfg.txt)
Apr 10, 1999, 8:40 AM
Matt_A
Deleted
Apr 10, 1999, 8:40 AM
Post #8 of 18
Views: 5211
Shortcut
Quote Reply
Re: error: validate.db In reply to
Sorry, I included the path from my old site by mistake.

$db_dir_url = "http://www.millennium-compendium.com/links/admin";
Apr 10, 1999, 4:29 PM
Bobsie
Veteran (3111 posts)
Bobsie's avatar
Apr 10, 1999, 4:29 PM
Post #9 of 18
Views: 5192
Shortcut
Quote Reply
Re: error: validate.db In reply to
Matt,

For the life of me, I can't seem to find the problem here. I looked at your links.cfg file and, for the most part, it looks fine (you do need to delete the "/" from the end of those paths/url's that are not supposed to have them such as the New and Cool paths/url's).

People can add sites just fine, so validate.db is there but, when you try to validate, the script says it is not there. This doesn't make sense to me and yet, it is exactly what is happening (I saw the validate.db file myself). You say that validate.db is chmod'd correctly. What permissions does it have and what permissions are on the data directory? Just for the heck of it, try changing both to 777 and see what happens (you really need to password protect the admin directory first, though).

If that doesn't do it, I am at a loss as what to suggest next. Maybe Alex (or someone else) can spot something we have overlooked.

[This message has been edited by Bobsie (edited April 10, 1999).]
Apr 10, 1999, 4:43 PM
Matt_A
Deleted
Apr 10, 1999, 4:43 PM
Post #10 of 18
Views: 5188
Shortcut
Quote Reply
Re: error: validate.db In reply to
I had the data directory chmoded to 775 and validate.db to 666. I tried setting both to 777 like you suggested and nothing.

As for the New and Cool paths, do you mean I shouldn't have that trailing slash? I modified the program so it works with the ending slash. If I did it incorrectly, would that affect validate.db? I don't see how because the program correctly adds new and cool links.

My webhosting provider (ICOM) has to protect the admin directory (for a fee, can you believe that?) because I don't have Telnet access. I requested the password protection over a week ago and they still haven't done it. I better send them a complaint.

Ugh, this is fustrating, ain't it?! Smile Thanks for your help though, Bobsie. ICOM has a CGI support staff I could ask, but guess what... they charge a fee!

Matt
Apr 11, 1999, 2:09 PM
Bobsie
Veteran (3111 posts)
Bobsie's avatar
Apr 11, 1999, 2:09 PM
Post #11 of 18
Views: 5196
Shortcut
Quote Reply
Re: error: validate.db In reply to
 
Quote:
As for the New and Cool paths, do you mean I shouldn't have that trailing slash? I modified the program so it works with the ending slash. If I did it incorrectly, would that affect validate.db? I don't see how because the program correctly adds new and cool links.

No, it won't affect validate.db. I just made that comment about the ending slash because the config instructions say to leave it off the paths. If you modified the script to use it that way (which I didn't know when I wrote the comment), then no problem. Now I am wondering if something else you may have modified is affecting how the access to validate.db is done.
May 6, 1999, 12:27 PM
Ozikan
New User (1 post)
May 6, 1999, 12:27 PM
Post #12 of 18
Views: 5221
Shortcut
Quote Reply
Re: error: validate.db In reply to
Hi I've now the same problem,i tried all what sugested in this thread !!! But the validation does not work !!! Who can help ???
Aug 1, 1999, 12:38 PM
Craig A
User (243 posts)
Aug 1, 1999, 12:38 PM
Post #13 of 18
Views: 5207
Shortcut
Quote Reply
Re: error: validate.db In reply to
aaaarrrgggghhhhhhh!!!!!!

Me too Frown

Quote:

CGI ERROR
==========================================
Error Message : unable to open validation file: /usr/www/tententh/httpd/htdocs/links/admin/data/validate.db. Reason: No such file or directory
Script Location : /usr/www/tententh/httpd/htdocs/links/admin/admin.cgi
Perl Version : 5.00502

Form Variables
-------------------------------------------
db : links
validate_form : 1

Environment Variables
-------------------------------------------
AUTH_TYPE : Basic
DOCUMENT_ROOT : /usr/www/tententh/httpd/htdocs
GATEWAY_INTERFACE : CGI/1.1
HTTP_ACCEPT : image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */*
HTTP_ACCEPT_CHARSET : iso-8859-1,*,utf-8
HTTP_ACCEPT_LANGUAGE: en
HTTP_CONNECTION : Keep-Alive
HTTP_HOST : 216.55.29.184
HTTP_REFERER : http://216.55.29.184/links/admin/admin.cgi?display=navigation
HTTP_USER_AGENT : Mozilla/4.03 [en] (Win95; I ;Nav)
PATH : /usr/local/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:/usr/local/Hughes/bin
QUERY_STRING : db=links&validate_form=1
REMOTE_ADDR : 194.222.206.166
REMOTE_HOST : titangb.demon.co.uk
REMOTE_PORT : 2392
REMOTE_USER : Craig1
REQUEST_METHOD : GET
REQUEST_URI : /links/admin/admin.cgi?db=links&validate_form=1
SCRIPT_FILENAME : /usr/www/tententh/httpd/htdocs/links/admin/admin.cgi
SCRIPT_NAME : /links/admin/admin.cgi
SERVER_ADMIN : webmaster@ten-tenths.com
SERVER_NAME : 216.55.29.184
SERVER_PORT : 80
SERVER_PROTOCOL : HTTP/1.0
SERVER_SOFTWARE : Apache/1.2.6

Quote:
# PATH and URL of Admin CGI directory. No Trailing Slash.
$db_script_path = "/usr/www/tententh/httpd/htdocs/links/admin";
$db_dir_url = "http://216.55.29.184/links/admin";

# URL of User CGI directory. No Trailing Slash.
$db_cgi_url = "http://216.55.29.184/links";

# PATH and URL of Pages to be built. No Trailing Slash.
$build_root_path = "/usr/www/tententh/httpd/htdocs/links";
$build_root_url = "http://216.55.29.184/links";

The file's there, it's chmod to 777, as are all directories which are above it, yet it still fails Frown Did you ever figure all these problems out ? HELP!

------------------
Craig Antill
10 Tenths Motorsport (1.1) - www.Ten-Tenths.com/links/
THE Directory (2.0b3) - www.gardenbuildings.com/
Aug 2, 1999, 7:30 AM
Craig A
User (243 posts)
Aug 2, 1999, 7:30 AM
Post #14 of 18
Views: 5257
Shortcut
Quote Reply
Re: error: validate.db In reply to
Anyone ?! It's been 3 days now and i've got a mountain of links to validate Frown

Any help gratefully received...

------------------
Craig Antill
10 Tenths Motorsport (1.1) - www.Ten-Tenths.com/links/
THE Directory (2.0b3) - www.gardenbuildings.com/
Aug 6, 1999, 10:56 AM
Craig A
User (243 posts)
Aug 6, 1999, 10:56 AM
Post #15 of 18
Views: 5172
Shortcut
Quote Reply
Re: error: validate.db In reply to
HELP!!

------------------
Craig Antill
10 Tenths Motorsport (1.1) - www.Ten-Tenths.com/links/
THE Directory (2.0b3) - www.gardenbuildings.com/
Aug 6, 1999, 11:14 AM
Craig A
User (243 posts)
Aug 6, 1999, 11:14 AM
Post #16 of 18
Views: 5207
Shortcut
Quote Reply
Re: error: validate.db In reply to
Come on folks, help me out here! Smile

Could this have anything to do with it ?
Quote:
Perl Version : 5.00502

Doesn't the script need 5.02 ? What to do ? The server doesn't appear to have any other version...

Also, can I just cut and paste the links awaiting validation into links.db or would this cause problems ?

Craig.

------------------
Craig Antill
10 Tenths Motorsport (1.1) - www.Ten-Tenths.com/links/
THE Directory (2.0b3) - www.gardenbuildings.com/
Aug 6, 1999, 12:21 PM
Alex
Administrator (9387 posts)
Aug 6, 1999, 12:21 PM
Post #17 of 18
Views: 5201
Shortcut
Quote Reply
Re: error: validate.db In reply to
Sorry, this is my fault. If you look in admin_html.pl around line 1049 you'll see the culprit:

open (MODIFY, "<$db_modified_name") or &cgierr("unable to open validation file: $db_valid_name. Reason: $!");

So the problem is it can't open/find your modified.db, but is reporting the error incorrectly.

Simply, make sure $db_modified_name exists and permissions are set properly.

Sorry about the headaches!

Cheers,

Alex
Aug 7, 1999, 11:00 PM
Craig A
User (243 posts)
Aug 7, 1999, 11:00 PM
Post #18 of 18
Views: 5175
Shortcut
Quote Reply
Re: error: validate.db In reply to
Alex, you're a star!!

Cheers for that - I can relax at last as i've now been able to validate all those links!

Cheers man!

------------------
Craig Antill
10 Tenths Motorsport (1.1) - www.Ten-Tenths.com/links/
THE Directory (2.0b3) - www.gardenbuildings.com/