Wrong server id

jai.thomas · Post by **jai.thomas** » Fri Feb 08, 2002 11:36 am

I am setting up Webinator on our production server (HP-UX 11). I have created a new profile and started walk.
But the walk gets abandoned immediately and walk status displays lots of 'Wrong server id' errors as given below. I first thought it is related to permission since it worked fine on NT server and verified the owner of all texis files. Still getting the same error.

What does this error mean?
Please help

Latest run: ABANDONED

Webinator Walk Report for AGSITES

Creating database /usr/local/morph3/texis/agsites/db2...
000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Wrong server id

000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Wrong server id

000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Wrong server id

000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Server ID (3) owned by 0, not 1316

000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Wrong server id

000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Wrong server id

000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Wrong server id

000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Wrong server id

000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Wrong server id

000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Wrong server id

000 /opt/HTTPServer/htdocs/en_US/webinator/dowalk(create) 846: Wrong server id
Done.

Thanks
Jai

Post by **mark** » Fri Feb 08, 2002 11:57 am

Also check the perms of the default Texis database in INSTALLDIR/texis/testdb

jai.thomas · Post by **jai.thomas** » Fri Feb 08, 2002 12:37 pm

I checked /texis/testdb files. Those are also owned by the same user. What does this error mean? Could this be due to a wrong configuration input? Our sysadmin folks installed it and that is the only thing I am not sure of. How can I verify installation?

Thanks
Jai

Post by **mark** » Fri Feb 08, 2002 1:06 pm

It means the shared mem segment used for locks is probably bad.
Run "rmlocks -f /PATH/TO/DATABASE". If the problem persists run "ipcs -mb" to find the shared mem ID. The SEGSZ should be 125668. Use "ipcrm -m ID" to remove it. Texis will recreate it on the next database use.

jai.thomas · Post by **jai.thomas** » Fri Feb 15, 2002 4:01 pm

I finally got some time to get back to this problem.
I am seeing something strange now.
I have created a brand new profile now and started a new walk. Walk status reported teh same 'wrong server id' errors and it reported a status 'Latest run: ABANDONED'. But when I refresh walk status, it shows all new pages fetched below those errors. Every time I refresh, I am seeing new pages fetched. It looks like the walk is continuing in spite of the ABANDONED status.
What is going on here? Can I assume the walk is continuing successfully?

Thanks
Jai

Post by **mark** » Fri Feb 15, 2002 5:34 pm

New profile or not, it still needs to talk to the global database in /usr/local/morph3/texis/testdb . Have you checked all perms and done the repairs suggested in message 4?
What's the output of
ls -l /usr/local/morph3/bin/monitor /usr/local/morph3/texis/testdb
And ls -l on "texis" in your CGI directory.
And ls -l on your new profile's dataspace directory.
And ipcs -mb

jai.thomas · Post by **jai.thomas** » Mon Feb 18, 2002 2:07 pm

We came to know that the account that owned texis files were not the web server account. Thinking that might be the problem, decided to reinstall Texis and that made the matters worse. Now, it looks like webinator is not getting installed properly. Webinator Admin complains about couple of missing tables and more interesting thing is that it display 'Free Webinator' as title (we have commercial license ).
Here's the errors appearing on top of admin screen
002 [webinatoradmin=webinatoradmin](perm) 2276: Can't open KDBF file /usr/local/morph3/texis/testdb/SYSTABLES.tbl for writing: error 13: Permission denied 000 [webinatoradmin=webinatoradmin](perm) 2276: Could not open SYSTABLES in the function ddopen 000 [webinatoradmin=webinatoradmin](perm) 2276: Could not connect to /usr/local/morph3/texis/testdb in the function openntexis 002 [webinatoradmin=webinatoradmin](loginform) 2315: Can't open KDBF file /usr/local/morph3/texis/testdb/SYSTABLES.tbl for writing: error 13: Permission denied 000 [webinatoradmin=webinatoradmin](loginform) 2315: Could not open SYSTABLES in the function ddopen 000 [webinatoradmin=webinatoradmin](loginform) 2315: Could not connect to /usr/local/morph3/texis/testdb in the function openntexis 002 [webinatoradmin=webinatoradmin](sendlogincookie) 2298: Can't open KDBF file /usr/local/morph3/texis/testdb/SYSTABLES.tbl for writing: error 13: Permission denied 000 [webinatoradmin=webinatoradmin](sendlogincookie) 2298: Could not open SYSTABLES in the function ddopen 000 [webinatoradmin=webinatoradmin](sendlogincookie) 2298: Could not connect to /usr/local/morph3/texis/testdb in the function openntexis .

Looks like testdb is not getting created successfully.
(There was no installation errors to that effect).
Why did it install successfully first time and not now?

Here's the answers you questions:
$ pwd
/usr/local/morph3/texis
$ ls -l testdb
total 440
-rwxrwxrwx 1 lycmusr lyceum 22832 Nov 13 13:17 SYSCOLUMNS.tbl
-rwxrwxrwx 1 lycmusr lyceum 5052 Nov 13 13:17 SYSINDEX.tbl
-rwxrwxrwx 1 lycmusr lyceum 8 Feb 18 11:29 SYSLOCKS.SEQ
-rwxrwxrwx 1 lycmusr lyceum 3318 Nov 13 13:16 SYSMETAINDEX.tbl
-rwxrwxrwx 1 lycmusr lyceum 5630 Nov 13 13:17 SYSPERMS.tbl
-rwxrwxrwx 1 lycmusr lyceum 1608 Feb 18 11:26 SYSSTATS.tbl
-rwxrwxrwx 1 lycmusr lyceum 8856 Nov 13 13:17 SYSTABLES.tbl
-rwxrwxrwx 1 lycmusr lyceum 3318 Nov 13 13:16 SYSTRIG.tbl
-rwxrwxrwx 1 lycmusr lyceum 3540 Feb 18 11:26 SYSUSERS.tbl
-rwxrwxrwx 1 lycmusr lyceum 724 Feb 18 11:26 index
-rwxrwxrwx 1 lycmusr lyceum 3152 Feb 18 11:26 index.vtx
-rwxrwxrwx 1 lycmusr lyceum 58779 Nov 13 13:17 patent.tbl
-rwxrwxrwx 1 lycmusr lyceum 3318 Nov 13 13:17 vortex.tbl
-rwxrwxrwx 1 lycmusr lyceum 32060 Nov 13 13:17 xpabs.btr
-rwxrwxrwx 1 lycmusr lyceum 11412 Nov 13 13:17 xpabs.dat
-rwxrwxrwx 1 lycmusr lyceum 1376 Nov 13 13:17 xpabs.tok
-rwxrwxrwx 1 lycmusr lyceum 50 Nov 13 13:17 xpabs_D.btr
-rwxrwxrwx 1 lycmusr lyceum 1586 Nov 13 13:17 xpabs_P.tbl
-rwxrwxrwx 1 lycmusr lyceum 160 Nov 13 13:17 xpabs_T.btr
-rwxrwxrwx 1 lycmusr lyceum 8362 Nov 13 13:17 xpid.btr
-rwxrwxrwx 1 lycmusr lyceum 160 Nov 13 13:17 xvid.btr
$ ls -l /opt/HTTPServer/cgi-bin
total 9876
-rwxrwxr-x 1 root lyceum 274 Jun 8 2000 printenv
-rwxr-xr-x 1 lycmusr lyceum 5054561 Feb 18 11:26 texis
$ ls -l /usr/local/morph3/bin
total 57424
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 addtable -> monitor
-rwxrwxrwx 1 lycmusr lyceum 4190274 Nov 13 13:18 anytotx
-rwxrwxrwx 1 lycmusr lyceum 3082 Nov 13 13:18 anytotx.txt
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 backref -> monitor
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 chkind -> monitor
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 copydb -> monitor
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 copydbf -> monitor
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 cpdb -> monitor
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 creatdb -> monitor
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 dumplock -> monitor
-rwxrwxrwx 1 lycmusr lyceum 40982 Nov 13 13:17 geturl
-rwxrwxrwx 1 lycmusr lyceum 4022351 Feb 18 11:26 gw
-rwxrwxrwx 1 lycmusr lyceum 49190 Nov 13 13:17 gwpatch
-rwxrwxrwx 1 lycmusr lyceum 20502 Nov 13 13:16 hex
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 kdbfchk -> monitor
-rwxrwxrwx 1 lycmusr lyceum 1798144 Nov 13 13:18 libpdftoolkit.sl
-rwxrwxrwx 1 lycmusr lyceum 1064960 Nov 13 13:18 libpfs.sl
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 ltest -> monitor
-rwxrwxrwx 1 lycmusr lyceum 5054561 Feb 18 11:24 monitor
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 monlock -> monitor
-rwxrwxrwx 1 lycmusr lyceum 57369 Nov 13 13:16 rex
-rwxrwxrwx 1 lycmusr lyceum 49191 Feb 18 11:24 rmlocks
-rwxrwxrwx 1 lycmusr lyceum 32792 Nov 13 13:17 tac
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 texis -> monitor
-rwxrwxrwx 1 lycmusr lyceum 3862603 Feb 18 11:24 texisd
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 timport -> monitor
-rwxrwxrwx 1 lycmusr lyceum 4022335 Nov 13 13:16 timportn
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 tsql -> monitor
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 txtocf -> monitor
-rwxrwxrwx 1 lycmusr lyceum 5054561 Feb 18 11:24 vhttpd
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 wordlist -> monitor
lrwxrwxr-x 1 lycmusr lyceum 7 Feb 18 11:24 wsem -> monitor
-rwxrwxrwx 1 lycmusr lyceum 24600 Nov 13 13:16 xtree

We opened these files for everyone just for experimentation purposes.
Please respond as early as possible.

Thanks
Jai

Post by **mark** » Mon Feb 18, 2002 2:59 pm

Were those the file permissions when you got the "permission denied" errors? If so, what are the perms on the directories above ( ls -ld /usr /usr/local /usr/local/morph3 /usr/local/morph3/texis /usr/local/morph3/texis/testdb ).

It's still important to run texis as the same user so the in memory locking structure may be accessed properly. The webserver will run programs as a user other than lycmusr. Make texis setuid with
chmod u+s /opt/HTTPServer/cgi-bin/texis /usr/local/morph3/bin/monitor /usr/local/morph3/bin/rmlocks /usr/local/morph3/bin/gw

jai.thomas · Post by **jai.thomas** » Mon Feb 18, 2002 3:14 pm

$ ls -ld /usr /usr/local /usr/local/morph3 /usr/local/morph3/texis /usr/local/mo
rph3/texis/testdb
dr-xr-xr-x 23 bin bin 1024 Apr 28 2001 /usr
drwxrwxrwx 12 bin bin 1024 Feb 18 11:20 /usr/local
lrwxrwxrwx 1 root sys 31 Feb 18 11:20 /usr/local/morph3 -> /
appsvr/texsvr/usr/local/morph3
drwxrwxrwx 5 lycmusr lyceum 4096 Feb 18 11:26 /usr/local/morph3/texi
s
drwxrwxrwx 2 lycmusr lyceum 4096 Feb 18 11:26 /usr/local/morph3/texi
s/testdb

Any idea why Webinator is not getting installed properly? We re-installed Texis twice with same results.

Thanks
Jai

jai.thomas · Post by **jai.thomas** » Mon Feb 18, 2002 3:44 pm

We reinstalled once again with web server uid and excuted chmod as you suggested. Now I am able to login to admin but getting the following error:
175 [webinatoradmin=webinatoradmin](selectwalk) 2177: Table options not found in data dictionary in the function opendbtbl 115 [webinatoradmin=webinatoradmin](selectwalk) 2177: No such table: options in the database: /usr/local/morph3/texis/testdb/ 000 [webinatoradmin=webinatoradmin](selectwalk) 2177: SQLPrepare() failed with -1 in the function prepntexis

Table 'options' is not getting created during setup and I guess that is causing this error. It is still showing 'Free Webinator'. I am wondering if these two problems are related.

Please help.

Thanks
Jai