Permission Issue

[amee.trivedi]

Hi John,

We have a search database on a filer. When the scripts try to accessthe database, we are getting the folllowing error:

Texis Version 05.01.1184645521(20070716) Copyright (c) 1988-2007 Thunderstone EPI

013 Permission denied in the function semlock
000 Unable to obtain semaphore
000 Could not open locking mechanism in the function ddopen
000 Couldn't connect to . in the function SQLConnect

It will be great if any of your executive attend a meeting over phone with the experts on our side to resolve this issue.

Thanks and Regards,
Amee

[mark]

It looks like you've running texis as variant users.
It's critical that all texis processes ALWAYS run as the same non-root
userid, whether from CGI or from command line as invoked by any user.
This is usually accomplished by making the texis programs in
/usr/local/morph3/bin owned by and setuid to the DBA's userid.
If you've written any programs using the texis C API they should
also be setuid to the DBA's userid.
All database files, semaphores, and shared mems (if any) must be
owned by that user.

Solution:
cd /usr/local/morph3/bin
chown THE_DBA_USERID anytotx gw monitor rmlocks texisd
chmod u+s anytotx gw monitor rmlocks texisd
chown -R THE_DBA_USERID /path/to/database
(kill all running texis/monitor/vhttpd processes)
/usr/local/morph3/bin/rmlocks -f /path/to/database
(you may have to use ipcs to find and ipcrm to remove semaphores
owned by the wrong user).
If you're using vhttpd edit /usr/local/morph3/conf/vhttpd.conf and
make sure "User" is set to the DBA's userid.

If you're using apache make sure it is allowing setuid or that
it's running CGI programs as the DBA's userid.