Issue Details (XML | Word | Printable)

Key: CORE-1728
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Alexander Peshkov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Monitoring tables do not work after fresh linux install.

Created: 06/Feb/08 03:37 AM   Updated: 18/Nov/08 01:38 PM
Component/s: Engine
Affects Version/s: 2.1 RC1
Fix Version/s: 2.1 RC2, 2.5 Alpha 1

Time Tracking:
Not Specified

Environment: linux

Planning Status: Unspecified


 Description  « Hide
The issue was reported by Ivan C Cruz:

I have start testing Firebird 2.1 last week and stumbled in a possible bug:
whenever I select from one of the new monitoring virtual tables I receive
the error:

Statement failed, SQLCODE = -902
operating system directive open failed
-Permission denied

In isql, the error is printed just after the headers. No records are
printed.
In the firebird.log I get this:

IvanAMD32 (Server) Tue Feb 5 23:52:36 2008
    Cannot initialize the shared memory region

Tested with both beta(?) 2 and rc 1. OS is Ubuntu 7.10. Firebird is
SuperServer 2.1.0.17735 installed with the script provided in
the tar.gz package. Database was backed up and restored
properly. ODS version is 11.1. Problem only happens with
monitoring tables and everything else looks OK.


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 06/Feb/08 05:58 AM
Just for information, it seems that it is a Linux Superserver issue only (32 and 64 bits) , I tested Classic under Linux and SuperServer under MacOsx and both are ok

Alexander Peshkov added a comment - 06/Feb/08 06:06 AM
In that case I tend to think that we have incorrect access rights to $FbRoot directory. User firebird should not have write access to it.

Alexander Peshkov added a comment - 06/Feb/08 06:35 AM
Create appropriate file at install time (like files for locks, events, etc.)