Kbase P18067: CONNECT statement errors with 1136 - client / server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/06/2005 |
|
Status: Verified
SYMPTOM(s):
Cannot connect to database using CONNECT statement
Can connect from command line using mpro dbname
The setuid bit is enabled for all progress executables (_files located in $DLC/bin except for _waitfor and _sqlsrv2).
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 he/she 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. Connecting via client server would allow a user to connect to shared memory without having permission to the shared memory as connection would occur via server process which would already have access to shared memory.
FIX:
1. Start database with -H hostname -S service name parameters.
2. Connect client to database using same -H and -S parameters.
This method can also be used if you telnet to the server machine. You will mimic a local loop back connection