Kbase P97058: prolog changes owner, group, and permissions of database log file and can cause 2257 error with CONN
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/08/2010 |
|
Status: Verified
SYMPTOM(s):
User receives 2257 error when connecting to a database using the CONNECT statement.
Unable to open or create <filename>, error <number>. (2257)
Unable to open or create dbname.lg error errno=13. (2257)
Errno 13 is an EACCES error indicating permission denied.
User has successfully connected to the database in the past.
prolog command was ran against the database since last successful connection.
The command: ls -al dbname* shows database log file has different owner and permissions than all the other database files.
Owner and group for the dbname.lg file changed to the user account that ran the prolog command.
Permissions on the dbname.lg file are the same as the umask setting for the user that ran the prolog command.
FACT(s) (Environment):
UNIX
Progress 9.1D
CAUSE:
Bug# OE00110505
FIX:
Upgrade to 9.1E01 or 10.1A.
If a fix does not exist for the version of Progress you are running, the following workaround can be used to address this issue:
Use the UNIX chown and chmod commands to reset the owner, group and permissions to the original account associated with the database.
1. Determine the original user account and permissions associated with the database:
Command: ls -al dbname* ("*" is a wildcard). Will show you all the database files and their owner/group and permissions.
Example:
-rw-rw-r-- 1 root system 2228224 Nov 2 14:06 sports2000.b1
-rw-rw-r-- 1 root system 720896 Nov 2 14:06 sports2000.d1
-rw-rw-r-- 1 root system 32768 Nov 2 14:06 sports2000.db
-rw-r--r-- 1 smith acct 3017 Nov 2 14:06 sports2000.lg
-r--r--r-- 1 smith acct 0 Nov 2 14:06 sports2000.lic
-rw-rw-r-- 1 root system 546 Nov 2 14:05 sports2000.st
-rw-rw-r-- 1 root system 327680 Nov 2 14:06 sports2000_10.d1
-rw-rw-r-- 1 root system 32768 Nov 2 14:06 sports2000_10.d2
-rw-rw-r-- 1 root system 1310720 Nov 2 14:06 sports2000_11.d1
-rw-rw-r-- 1 root system 196608 Nov 2 14:06 sports2000_11.d2
-rw-rw-r-- 1 root system 327680 Nov 2 14:06 sports2000_12.d1
-rw-rw-r-- 1 root system 32768 Nov 2 14:06 sports2000_12.d2
-rw-rw-r-- 1 root system 327680 Nov 2 14:06 sports2000_7.d1
-rw-rw-r-- 1 root system 32768 Nov 2 14:06 sports2000_7.d2
-rw-rw-r-- 1 root system 622592 Nov 2 14:06 sports2000_8.d1
-rw-rw-r-- 1 root system 32768 Nov 2 14:06 sports2000_8.d2
-rw-rw-r-- 1 root system 327680 Nov 2 14:06 sports2000_9.d1
-rw-rw-r-- 1 root system 32768 Nov 2 14:06 sports2000_9.d2
2. Change the owner of the database log file back to the appropriate owner and group combination:
Command: chown root:system sports2000.lg
3. Change the permissions of the database log file back to the original permissions
Command: chmod 664 sports2000.lg