Kbase P23329: Error 8933 occurs when starting SQL Explorer; change owner o
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/06/2004 |
|
Status: Verified
FACT(s) (Environment):
UNIX
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Starting SQL explorer produces error 8933
Starting sqlexp produces error 8933
Error: [JDBC Progress Driver]:Database not started. (8933)
SQL server will not be spawned and the database log file shows error 8841
SQL server process terminated. (8841)
Database was started with the proserve command.
JAVA SDK is installed, not JRE.
Correct JAVA version is installed, as per the Progress Installation and Configuration Guide.
CAUSE:
_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 broker, and therefore the user who started the broker must have read/write privileges 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:
Login and start the database as the owner of the database files