Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error "Missing security context for .....\SECURITY3.FDB" [CORE4659] #4972

Closed
firebird-automations opened this issue Jan 6, 2015 · 18 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Imam Chalimi (virgonia)

Is related to CORE4607

Attachments:
bug_pic.jpg
bug_text.txt
attach_4659.zip
fb_snapshot.jpg

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>

Commits: 76df787 FirebirdSQL/fbt-repository@f4793f7

@firebird-automations
Copy link
Collaborator Author

Modified by: Imam Chalimi (virgonia)

Attachment: bug_pic.jpg [ 12659 ]

Attachment: bug_text.txt [ 12660 ]

description: 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.31514-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>

=>

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>

security: Developers [ 10012 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: Imam Chalimi (virgonia)

Component: API / Client Library [ 10040 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

I can't reproduce a bug on build 3.0.0.31534. Please attach your *.conf files here.

@firebird-automations
Copy link
Collaborator Author

Commented by: Imam Chalimi (virgonia)

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)

@firebird-automations
Copy link
Collaborator Author

Modified by: Imam Chalimi (virgonia)

Attachment: attach_4659.zip [ 12662 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Imam Chalimi (virgonia)

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=...)

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Patch is committed, please verify it using tomorrow's snapshot build

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Version: 3.0 Beta 2 [ 10586 ]

Fix Version: 3.0 Beta 2 [ 10586 ]

Version: 3.0 Beta 1 [ 10332 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: Imam Chalimi (virgonia)

Still Error on snapshot build Firebird-3.0.0.31541-0_Win32

@firebird-automations
Copy link
Collaborator Author

Modified by: Imam Chalimi (virgonia)

Attachment: fb_snapshot.jpg [ 12664 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Fixed build number is 31543, please wait for the today's snapshot.

@firebird-automations
Copy link
Collaborator Author

Commented by: Imam Chalimi (virgonia)

Fixed on Firebird-3.0.0.31543 .. thanks

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Link: This issue is related to CORE4607 [ CORE4607 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

A bug was introduced when implementing multiple user managers support

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants