help: index didn't even start

Post Reply
User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

help: index didn't even start

Post by Thunderstone »



We are currently evaluating webinator, but are having a problems with
index. I've used it before to create an index of the same site, but
after I deleted all the databases to try some other features, it just
chokes. The following is a verbose level 9 output from the command

gw -index -v9 -d../db -U<user deleted> -P<password deleted>
http://my.site.com/



000 Could not connect to ../db
Option: "-index"
Option: "-v9"
Option: "-d../db"
Option: "-U<username deleted>"
Option: "-P<password deleted>"
100 User _SYSTEM has been added without a password.
100 User PUBLIC has been added without a password.
200 Database created
Create ../db/.htaccess
Copy D:\data\web\webinator\_master\SYSOBJECTS.tbl to
../db\SYSOBJECTS.tbl
create table html(id counter,New int,Visited date,Dlsecs int,Depth
int,Url varch
ar(80),Title varchar(80),Body varchar(2048),Meta varchar(128));
create table refs(id counter,Url varchar(80),Ref varchar(80));
create table todo(Dlsecs int,Depth int,Url varchar(80));
create table error(id counter,Url varchar(80),Reason varchar(80));
create table options(id counter,Profile varchar(8),Name
varchar(8),Type varchar(
8),Int int,Float double,String varchar(80),Strlist strlst);
create table querylog(id counter,Client varchar(40),Query
varchar(80));
create unique index xhtmlurl on html(Url);
create unique index xtodourl on todo(Url);
create index xoptname on options(Name);
create index xoptstr on options(String);
create index xqueryid on querylog(id);
grant select on html to PUBLIC;
grant select on refs to PUBLIC;
grant select on todo to PUBLIC;
grant select on error to PUBLIC;
grant all on options to PUBLIC;
grant all on querylog to PUBLIC;
Saving options and URLs to lastrun
Indexing new pages
Using meta data field
set delexp=0;
set addexp='\alnum{2,30}';
create metamorph index xhtmlbod on html(Title\Meta\Body);
create index xhtmlid on html(id);
create index xrefsurl on refs(Url);
create index xrefsref on refs(Ref);
create unique index xhtmlurl on html(Url);
015 xhtmlurl already exists and is not a Metamorph index
create unique index xtodourl on todo(Url);
015 xtodourl already exists and is not a Metamorph index
create index xoptname on options(Name);
015 xoptname already exists and is not a Metamorph index
create index xoptstr on options(String);
015 xoptstr already exists and is not a Metamorph index
create index xqueryid on querylog(id);
015 xqueryid already exists and is not a Metamorph index
create unique index xhostnm on hosts(Name);
175 Table hosts not found in data dictionary
create index xhostip on hosts(IP);
175 Table hosts not found in data dictionary
getip() called 0 times. 0 hits
gethostbyname() called 0 times


Why is it unable to find the hosts table? Is it never created? Why
would it not be created with a -create (I have tried explicitly
stating -create)?

Why does it keep stating 015 x* already exists and is not a Metamorph
index? Again, shouldn't this be taken care of during the creation of
the database?


Thanks in advance,
Tim Rosine


User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

help: index didn't even start

Post by Thunderstone »



By using the "-index" option, you have said just update the indices, don't
walk. Leave off -index to walk. It will automatically index when the
walk completes.

As for the messages... You turned verbosity up to the max, so it's
printing all kinds of info, not necessarily errors.
The hosts table is only created for -dnscache.
The "015 x* already exists ..." messages are just informative.



Post Reply