Kbase P98054: Unable to connect to multiple databases from Unix using mpro or _progres on 10.0B
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/3/2009 |
|
Status: Verified
SYMPTOM(s):
Unable to connect to multiple databases from the command line using mpro
Unable to connect to multiple databases from the command line using _progres
Error 1136 occurs when non-root user connects to two or more databases that are owned and started by root
Shared memory access permissions denied (1136)
Stack trace from _progres reads:
shmmsg
shmAttachSegment
shmVerifySegment
shmattsegs
shmAttach
Errors 43 and 1423 occur when databases are not started by root and connected from the command line using a different user.
Cannot find or open file dbname.db, errno = 13. (43)
There is no server for database dbname. (1423)
FACT(s) (Environment):
UNIX
Progress 9.1E
OpenEdge 10.0B
OpenEdge 10.0B 64-bit
OpenEdge 10.1C
CAUSE:
Bug# OE00110908
FIX:
Upgrade to 10.0B02.
Upgrade to 10.1C03.
To workaround this issue perform the following:
1) Start the databases to accept client server connections and connect clients via TCP:
mpro -db dbname1 -S 8001 -db dbname2 -S 8002
2) Change permissions on all the database files from 644 to 666.
If using a third party program where the connection statements are hidden, consider using the clientlogging utility. This may help identify if a second db connection is being called.