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