Issue Details (XML | Word | Printable)

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

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

Error "Missing security context for .....\SECURITY3.FDB"

Created: 06/Jan/15 09:17 AM   Updated: 18/Jan/16 03:22 PM
Component/s: API / Client Library
Affects Version/s: 3.0 Beta 2
Fix Version/s: 3.0 Beta 2

File Attachments: 1. Zip Archive attach_4659.zip (292 kB)
2. Text File bug_text.txt (0.8 kB)

Image Attachments:

1. bug_pic.jpg
(89 kB)

2. fb_snapshot.jpg
(207 kB)
Environment: Windows 7 32bit
Issue Links:
Relate
 

QA Status: No test


 Description  « Hide
an Error "Missing security context for .....\SECURITY3.FDB" when create new user (create user ...) or select security table (select * from sec$users) on per database user configuration.

This error occurs on firebird 3 snapshot build Firebird-3.0.0.31514-0_Win32 - Firebird-3.0.0.31530-0_Win32 (last today snapshot).
on Firebird-3.0.0.31512-0_Win32 is fine.

** database.conf **
koko = D:\koko\koko_new.fb
{
 SecurityDatabase = koko
}

** script **
C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> select * from sec$users;

SEC$USER_NAME SEC$FIRST_NAME SEC$MIDDLE_NAME
                  SEC$LAST_NAME SEC$ACTIVE SEC$ADMIN SEC$DE
SCRIPTION SEC$PLUGIN
=============================== ================================ ===============
================= ================================ ========== ========= ========
========= ===============================
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL> quit;

C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> create user test123 password '123';
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL>

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 12/Jan/15 08:52 AM
I can't reproduce a bug on build 3.0.0.31534. Please attach your *.conf files here.

Imam Chalimi added a comment - 12/Jan/15 12:03 PM
Many thanks for reponse,
I include the following attachment file (ZIP format)

Attached file content :

new reproduce with Firebird-3.0.0.31532-0_Win32 and Firebird-3.0.0.31512-0_Win32.

1. TEST_BUG.FB (case test), original path c:\fb30.b1
2. firebird.conf, server config
3. databases.conf , per database config
4. isql_31512_perdb_ok.jpg, reproduce on build 31512 with perdatabase config (OK)
5. isql_31532_perserver_ok.jpg, reproduce on build 31532 without perdatabase config (OK)
6. isql_31532_perdb_direct_bad.jpg, reproduce on build 31532 with perdatabase config & using direct path (BAD)
7. isql_31532_perdb_alias_bad.jpg, reproduce on build 31532 with perdatabase config & using alias (BAD)

Imam Chalimi added a comment - 12/Jan/15 12:08 PM - edited
note / correction:
last reproduce above using Firebird-3.0.0.31534-0_Win32 not Firebird-3.0.0.31532-0_Win32.

error only occurs when using perdatabase configuration (SecurityDatabase=...)

Vlad Khorsun added a comment - 13/Jan/15 11:30 AM
Patch is committed, please verify it using tomorrow's snapshot build

Imam Chalimi added a comment - 13/Jan/15 10:37 PM
Still Error on snapshot build Firebird-3.0.0.31541-0_Win32

Dmitry Yemanov added a comment - 14/Jan/15 07:54 AM
Fixed build number is 31543, please wait for the today's snapshot.

Imam Chalimi added a comment - 14/Jan/15 09:53 AM
Fixed on Firebird-3.0.0.31543 .. thanks

Alexander Peshkov added a comment - 14/Jan/15 03:39 PM
A bug was introduced when implementing multiple user managers support