Kbase P18066: CONNECT statement errors with 1136 - group access
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/09/2005 |
|
Status: Verified
SYMPTOM(s):
Cannot connect to database using CONNECT statement
Can connect from command line using mpro dbname
setuid bit is enabled for all progress executables except _sqlsrv2 and _waitfor
SYSTEM ERROR: Shared memory access permission denied (1136)
CHANGE:
Upgraded 9.1B to 9.1D
CAUSE:
4GL program execution is performed after the process has been "downgraded" from root, i.e. they are NOT run as root. If the user running the program
does not have access to the database or is not part of a group that has access to the database, then user will not have access to the shared memory for
that database.
When a server is started, the ownership of the shared memory is changed so that it mimics the .db file. This is a change from the 9.1B method.
If a user has access to the .db file or they belong to a group which has access to the .db file, then they will have access to the shared memory for the database.
FIX:
1. Grant group access to the database using chmod to set permissions for owner, group, world.
2. Then add all users that need access to the database to that group.