Kbase P1800: Error 8841 in the database log and Database not started error displayed from SQL explorer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/1/2009 |
|
Status: Verified
SYMPTOM(s):
Error 8841 in the database log and Database not started error displayed from SQL explorer
[MERANT][ODBC Progress Driver][Progress] Database not started.
SQL server process terminated. (8841)
FACT(s) (Environment):
The error 8841 is reported to the Progress database log file
"Database not started" when attempting SQL92 SQL explorer Connection
"Database not started" when attempting SQL92/ODBC Connection
ODBC Progress Driver Error is displayed on Windows 32-bit client machines when a SQL-92/ODBC connection is made to database.
Setuid bit is enabled for _sqlsrv2 executable
Progress 9.1x
UNIX
CAUSE:
_sql92, not like _progres, is an executable linked to shared libraries. When an executable is linked to shared libraries, there are some security rules imposed by OS if it has setuid bit set, the executable can only load shared libraries from /usr/lib whether shared library path environment variable (LD_LIBRARY_PATH, SHLIB_PATH, LIBPATH)is set or not. Because the _sqlsrv2 can not load needed runtime libraries, the process terminates.
FIX:
To correct the problem:
1. Set the UNIX permissions on the Progress SQL-92 server executable (_sqlsrv2) to 755.
2. Leave the Progress database broker executable (_mprosrv) set to 4775. The files should then appear as follows:
-rwsrwxr-x 1 root xxx 1693006 Jun 6 2001 _mprosrv
-rwxr-xr-x 1 xxxxx xxx 595654 Jun 6 2001 _sqlsrv2