Schema for table html not permitted

Post Reply
tech14
Posts: 12
Joined: Mon Mar 18, 2002 3:57 pm

Schema for table html not permitted

Post by tech14 »

This is the command I used to use to build my search database in a previous version, now it's giving me trouble. Any suggestions on how to upgrade the database create command to 5.0?

[root@server scripts]# /www/webinator/bin/gw -d/www/webinator/khouse -meta=keywords,description http://www.khouse.org/
200 Database created
000 Schema for table html not permitted by current license
000 SQLPrepare() failed with -1
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Schema for table html not permitted

Post by mark »

I'll check into that and get back to you. One thing to note however is that gw is only provided for back compatibility with version 2. If you want to use any version 5 features you need to use the web based admin interface instead of gw.

http://www.thunderstone.com/texis/site/ ... +Interface
User avatar
Kai
Site Admin
Posts: 1271
Joined: Tue Apr 25, 2000 1:27 pm

Schema for table html not permitted

Post by Kai »

If you run texis -update from the command line, your license should be updated to include gw permissions.
tech14
Posts: 12
Joined: Mon Mar 18, 2002 3:57 pm

Schema for table html not permitted

Post by tech14 »

[root@server webinator]# bin/texis -update
Texis Web Script (Vortex) Copyright (c) 1996-2004 Thunderstone - EPI, Inc.
Free Webinator Version 5.00.1084805211 20040517 (i686-unknown-linux2.4.9-64-32)

Attempting to update license
[root@server webinator]#

[root@server webinator]# /www/webinator/bin/gw -d/www/webinator/khouse -meta=keywords,description http://www.khouse.org/
000 Schema for table html not permitted by current license
115 No such table: html in the database: /www/webinator/khouse/
000 SQLPrepare() failed with -1
Sorry, you have reached the maximum allowed pages. (max=10000/cur=0)
User avatar
Kai
Site Admin
Posts: 1271
Joined: Tue Apr 25, 2000 1:27 pm

Schema for table html not permitted

Post by Kai »

Check /usr/local/morph3/texis/monitor.log for "Successful reply from license server" with a time stamp around the time you ran texis -update. Also try texis -update once more.

(As a side note, it's not a good idea to run any Webinator/Texis program as root, as that invites permission problems.)
julian_loy
Posts: 8
Joined: Thu May 20, 2004 9:30 am

Schema for table html not permitted

Post by julian_loy »

I'm having the same problem as started in the beginning of this thread. When I run texis -update the following message shows up in the monitor.log file:

100 2004-05-26 11:10:07 (11965) License update requested: No license.upd file found


I'm running the Linux 2.412.2 x86 version.

thanks
User avatar
Kai
Site Admin
Posts: 1271
Joined: Tue Apr 25, 2000 1:27 pm

Schema for table html not permitted

Post by Kai »

Do you see "Contacting license server" in the log? If not, wait 15 minutes and try again.
Texis User
Posts: 74
Joined: Thu Jul 13, 2006 8:47 am

Schema for table html not permitted

Post by Texis User »

Hi,

I am see same error at my end,the only difference being I am running

SQL 1>select * from person_profile_log;
000 Schema for table person_profile_log not permitted by current license
115 No such table: person_profile_log in the database: supdb/

Though I see this table in SYSTABLES and SYSCOLUMNS too.

I did a tail on monitor log

[scgpsrch03]$ tail -f monitor.log
200 2007-02-04 14:01:44 (7767) Contacting license server
000 2007-02-04 14:01:44 (7767) Cannot resolve host `ls.thunderstone.com': Host not found
000 2007-02-04 14:01:44 (7767) Could not contact license server
200 2007-02-04 14:01:44 (7767) Successful reply from license server
100 2007-02-05 07:35:02 (7767) License update requested: No license.upd file found
200 2007-02-05 07:35:02 (7767) Contacting license server
000 2007-02-05 07:35:02 (7767) Cannot resolve host `ls.thunderstone.com': Host not found
000 2007-02-05 07:35:02 (7767) Could not contact license server
200 2007-02-05 07:35:02 (7767) Successful reply from license server
100 2007-02-05 07:35:30 (7767) License update requested: No license.upd file found
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Schema for table html not permitted

Post by John »

You need to install the license.upd file for you license.
John Turnbull
Thunderstone Software
Post Reply