Kbase P21102: Error occurs when connecting to database via ODBC/JDBC/SQL Explorer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/7/2011 |
|
Status: Verified
SYMPTOM(s):
[DataDirect][ODBC OPENEDGE Wire Protocol driver] [OpenEdge] Broker rejects connection.
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.
Correct JAVA version is installed,
Starting sqlexp produces error 8933
Starting SQL explorer produces error 8933
FACT(s) (Environment):
Able to connect 4gl clients remotely
UNIX
Progress 9.x
OpenEdge 10.x
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:
Option 1:
Change the permission of database files from 644 to 666. Use the command: chmod 666 file.name
Change file.name to point to each database file. To obtain a list of database files and their locations runn the command: prostrct list dbname
Option 2:
Login and start the database as the owner of the database files