Kbase P19921: Can not start SQL-92 Server on UNIX
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/09/2008 |
|
Status: Verified
SYMPTOM(s):
Can not start SQL-92 Server on UNIX
Database not started received by SQL clients (ODBC, JDBC or ESQL/C)
BROKER 0: Could not spawn a SQL server. (8842)
SQLSRV2 2: Failure during dsmUserConnect (-1)
LD_LIBRARY_PATH is set correctly
ldd $DLC/bin/_sqlsrv2 returns no errors
_sqlsrv2 -z \
-D juniper.serverid=1 \
-D "juniper.dbfile=\"`pwd`/dbname.db\"" \
generates the same error 8842 in database lg file
Database files have 644 permissions
Database owned by root but started by a dba user
FACT(s) (Environment):
UNIX
Progress 9.1x
CAUSE:
Bug 20030227-011
_sqlsrv2, unlike 4GL server components, does not have the "setuid" bit
set in its permission. This means that when _sqlsrv2 runs it runs as the user
who started the database server. This means that the user who started the
server must have r/w privs to the database files. [_sqlsrv2 cannot have setuid
bit set because its library use with then fail, because of security rules for
library paths.]
FIX:
1. Start the db as the owner of the db files
or
2. Change permission for db files from 644 to 666